Search found 47 matches
- 19 Jan 2013, 03:32
- Forum: Help
- Topic: No close_time
- Replies: 0
- Views: 717
No close_time
Hi, I have an issue which makes stats very hard to do correctly. When a ticket is created and closed at the same time (ref, new phone ticket with state closed sucessfull) it doesn't add any value to the close_time in ticket_history. Is there a way to get this time somehow set but still keep the orig...
- 12 Jul 2012, 22:54
- Forum: Patches / Modules
- Topic: MySQL Booster (current version: 1.1.4 RC for OTRS 2.4.x)
- Replies: 21
- Views: 82629
Re: MySQL Booster (current version: 1.1.4 RC for OTRS 2.4.x)
Also awaiting any news around 3.1.X or any way to contribute on it.
- 25 May 2012, 22:44
- Forum: Help
- Topic: [SOLVED] Mod_perl
- Replies: 6
- Views: 4507
Re: Mod_perl
Thanks for all the feedback. This issue was solved by doing a new compilation of Apache with even more modules then suggested by default.
- 22 May 2012, 08:47
- Forum: Help
- Topic: [SOLVED] Mod_perl
- Replies: 6
- Views: 4507
Re: Mod_perl
I read your post a few times. I still don't know what your problem is. Can you post what your problem is? Saying that mod_perl doesn't work is like saying my car doesn't work. When I start the Apache worker (none standard installation through yum) it starts, loads up OTRS with all modules specified...
- 21 May 2012, 17:22
- Forum: Help
- Topic: [SOLVED] Mod_perl
- Replies: 6
- Views: 4507
Re: Mod_perl
Yes, we compiled a worker apache in /opt/apache with the same modules as the one you get from "yum install httpd" The config loads mod_perl correctly through zzz_otrs.conf with the same httpd.conf in standard as used by the compiled one. So it's something strange as the configs work in one...
- 21 May 2012, 07:08
- Forum: Help
- Topic: [SOLVED] Mod_perl
- Replies: 6
- Views: 4507
[SOLVED] Mod_perl
We've installed OTRS 3.1.5 on Redhat 6.2 with a mysql database. Everything works as it should, just not mod_perl. The following is the output from the Support Assessment and if i disable the perl module cgid it work either. So if anybody has a good way of fixing this. It would help alot!! Display we...
- 01 Feb 2012, 21:26
- Forum: General
- Topic: OTRS Feature Add-Ons
- Replies: 5
- Views: 2577
Re: OTRS Feature Add-Ons
This is a question I'd also like a answer to. The price should be reasonable as it's no longer a subscription.joserribeiro26 wrote:jojo, thanks.
Yes, I intend to pay, but it is possible to pay only the addons? I do not need to subscribe.
Regards.
- 08 Jan 2012, 02:41
- Forum: Help
- Topic: otrs 3 with iis 7 and Microsoft sql
- Replies: 5
- Views: 2184
Re: otrs 3 with iis 7 and Microsoft sql
For us to be able to use øæå and equivalent characters we added the following to Config.pm $Self->{'DefaultCharset'} = 'iso-8859-1'; And the MSSQL Collation: Danish_Norwegian_CI_AS It can be used with UFT-8 but then you need to find a matching Collation in MSSQL. The following might be the closest o...
- 08 Jan 2012, 00:34
- Forum: Help
- Topic: [SOLVED] Hide Queue from Customer
- Replies: 2
- Views: 1562
[SOLVED] Hide Queue from Customer
Thanks, that solved it quite nicely
Only thing you'd need to do is then to add user_id, group_id and permission_key to the group_customer_user
Pretty sweet and took only a couple of minutes to solve it for every customer!!
Only thing you'd need to do is then to add user_id, group_id and permission_key to the group_customer_user
Pretty sweet and took only a couple of minutes to solve it for every customer!!
- 06 Jan 2012, 21:49
- Forum: Help
- Topic: [SOLVED] Hide Queue from Customer
- Replies: 2
- Views: 1562
[SOLVED] Hide Queue from Customer
This might have been solved in another thread, but can't find anything close to what i need to know. When a customer logs into the Customer interface, they can see every queue in the system. Is there a simple way of hiding/disabling given queues for the customer? The number of customers are above 40...
- 04 Jan 2012, 22:04
- Forum: Help
- Topic: PostMaster Filter parts of body with wildcard
- Replies: 4
- Views: 3324
Re: PostMaster Filter parts of body with wildcard
It finds the correct line, but can't set a variable through:
'X-OTRS-CustomerUser' =>[***],
If i make it set aaa.aa@test.com statically it works.
So how to get the line it finds and use that in the CustomerUser field?
'X-OTRS-CustomerUser' =>[***],
If i make it set aaa.aa@test.com statically it works.
So how to get the line it finds and use that in the CustomerUser field?
- 03 Jan 2012, 17:45
- Forum: Help
- Topic: PostMaster Filter parts of body with wildcard
- Replies: 4
- Views: 3324
Re: PostMaster Filter parts of body with wildcard
This seems to be a bit better but still doesn't put the result in the CustomerUser field:
(?<=EMAIL )(([a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,4}))
(?<=EMAIL )(([a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,4}))
- 03 Jan 2012, 17:06
- Forum: Help
- Topic: PostMaster Filter parts of body with wildcard
- Replies: 4
- Views: 3324
PostMaster Filter parts of body with wildcard
Hi, I need to filter the parts of a email body and set the found variable as customer. My try at the regex is: EMAIL (([a-zA-Z0-9_\-\.]+)@([a-zA-Z0-9_\-\.]+)\.([a-zA-Z]{2,5})) Example: ABC aaabbbcccc BBB test@test.com CCC aaabbbcccddd EMAIL otrs@otrs.org DDD aaaabbbbb Postmaster filter so far: Match...
- 30 Dec 2011, 23:50
- Forum: General
- Topic: New account in the OTRS wiki
- Replies: 1
- Views: 1111
Re: New account in the OTRS wiki
The issue is the captcha settings not working properly. Might be settings etc.. should look at the admin/settings/captcha/recaptcha
Might even want to generate some new keys to get it working again.
So until this is resolved or looked at I can't make an account and contribute
Might even want to generate some new keys to get it working again.
So until this is resolved or looked at I can't make an account and contribute
- 30 Dec 2011, 23:00
- Forum: Patches / Modules
- Topic: New Module: QuickClose
- Replies: 5
- Views: 57289
Re: New Module: QuickClose
renee is it possible to also get a "Type" and"Service" field added the QuickClose? The most needed is "Type" Another thing is to make the QuickClose only active in certain queues, like the it's done in "Manage Response-Queue Relations" This way we can speed up...
- 29 Dec 2011, 14:26
- Forum: Help
- Topic: Image upload bug after update to ckeditor 3.6.2
- Replies: 14
- Views: 4274
Re: Image upload bug after update to ckeditor 3.6.2
Clearing the cache doesn't work on this case. We had the same issue, I resolved it by removing the button on our environment as it wasn't needed. But if you look inside the 3.4.2 folder you have a file called OTRS-PATCHES.txt, have you done these steps? If not you need to follow the description here...
- 28 Dec 2011, 19:20
- Forum: Help
- Topic: Email notification when using note-internal
- Replies: 2
- Views: 1919
Re: Email notification when using note-internal
Hi, This can be done by going into the admin page, then under Ticket Settings , Notifications (Event) Recipient groups: Agent Event: ArticleCreate Article Type: note-internal Notification article type: email-notice-int Example of email: Subject: <OTRS_CUSTOMER_SUBJECT[100]> Body: <OTRS_AGENT_BODY[45...
- 26 Dec 2011, 20:49
- Forum: General
- Topic: New account in the OTRS wiki
- Replies: 1
- Views: 1111
New account in the OTRS wiki
Hi,
I've been wanting for some time now to contribute more to OTRS and wanted to add some pages onto the English Wiki page which where missing.
But when i try to register i get the following:
Could not open socket
I've been wanting for some time now to contribute more to OTRS and wanted to add some pages onto the English Wiki page which where missing.
But when i try to register i get the following:
Could not open socket
- 30 Nov 2011, 09:59
- Forum: Help
- Topic: How to update ckeditor
- Replies: 2
- Views: 1756
Re: How to update ckeditor
Thank you! I can now do a proper udate of the ckeditor
- 29 Nov 2011, 23:27
- Forum: Help
- Topic: How to update ckeditor
- Replies: 2
- Views: 1756
How to update ckeditor
Hi, When looking at the js/thirdparty plugins being used it seems OTRS 3.0.11 is running on older version of CKEditor. Namly the 3.4.2 version. Many of the CKEditor bugs i have at the moment seems to be fixed in the latest version 3.6.2 of CKEditor. To be able to update, do i need to do the tings de...
- 28 Nov 2011, 14:10
- Forum: Help
- Topic: error OTRS-CGI-10 Invalid Date '22-NOV-11'!
- Replies: 4
- Views: 1970
Re: error OTRS-CGI-10 Invalid Date '22-NOV-11'!
I've set the locales.conf to the following and it solved it for us:
[default]
date format = %Y-%m-%d %H:%M:%S:%z
It all depends on the setup and what language you've set up, and if your using mysql, mssql or another DB.
[default]
date format = %Y-%m-%d %H:%M:%S:%z
It all depends on the setup and what language you've set up, and if your using mysql, mssql or another DB.
- 28 Nov 2011, 12:48
- Forum: Help
- Topic: Strange SQL query used OFTEN
- Replies: 0
- Views: 615
Strange SQL query used OFTEN
When doing a trace of the things happening on our MSSQL 2008 server, we find that when doing a normal report of a new ticket the following SQL query is sendt 400 times:
Select 1 where 0=1
Where is is and why does it run?
I've tried to find it but i cannot find where it is located.
Select 1 where 0=1
Where is is and why does it run?
I've tried to find it but i cannot find where it is located.
- 28 Nov 2011, 12:45
- Forum: Help
- Topic: error OTRS-CGI-10 Invalid Date '22-NOV-11'!
- Replies: 4
- Views: 1970
Re: error OTRS-CGI-10 Invalid Date '22-NOV-11'!
Which type of server does it run on?
If it's a linux enviroment you can alter the /etc/locales.conf
If it's a linux enviroment you can alter the /etc/locales.conf
- 20 Oct 2011, 16:26
- Forum: Developers
- Topic: Adding additional colum to views
- Replies: 3
- Views: 1690
Re: Adding additional colum to views
You can alter the different .dtl files in Kernel/Output/HTML/Stanard (or folder for theme), then alter the given file.
This will make it display a new column but think you also need to change a PM file or two to get sorting etc working as intended for the new columns.
This will make it display a new column but think you also need to change a PM file or two to get sorting etc working as intended for the new columns.
- 20 Oct 2011, 16:22
- Forum: Patches / Modules
- Topic: New Module: QuickClose
- Replies: 5
- Views: 57289
Re: New Module: QuickClose
Got the same error, you could get around it by altering the database to make comments allow NULL but that isn't fixing anything but just making another issue later on.
- 28 Sep 2011, 19:04
- Forum: Help
- Topic: Search on customer_company name
- Replies: 3
- Views: 2596
Re: Search on customer_company name
Is there then a simple way to find all tickets for one company without having to search by a ID number but the actual name?
- 28 Sep 2011, 13:07
- Forum: Help
- Topic: Search on customer_company name
- Replies: 3
- Views: 2596
Search on customer_company name
At the moment when you want to search on given criterias, you are able to search on CustomerID and Customer User Login, but I need to be able to search on the name field used in the Customer_company table. It's mainly the same search criteria as on the AdminCustomerCompany search. How to do this in ...
- 27 Sep 2011, 17:06
- Forum: Help
- Topic: Adding another column to AgentTicketQueue
- Replies: 1
- Views: 1142
Re: Adding another column to AgentTicketQueue
I've now got everything working, but only thing missing is a proper <!-- dtl:block:#### --> for it to work with sorting and getting it highlighted.
But how to make these and link them to the CSS files?
But how to make these and link them to the CSS files?
- 27 Sep 2011, 13:33
- Forum: Help
- Topic: Adding another column to AgentTicketQueue
- Replies: 1
- Views: 1142
Adding another column to AgentTicketQueue
Hi,
I'm trying to add another column to the AgentTicketQueue view through AgentTicketOverviewSmall.dtl
I've managed to add the new column but i can't add another header column.
What and where do i need to change?
Running OTRS 3.0.10
I'm trying to add another column to the AgentTicketQueue view through AgentTicketOverviewSmall.dtl
I've managed to add the new column but i can't add another header column.
What and where do i need to change?
Running OTRS 3.0.10
- 09 Sep 2011, 13:30
- Forum: Help
- Topic: Attachment database to file storage
- Replies: 1
- Views: 1078
Attachment database to file storage
When changing the location of attachments to file storage, it only affects new tickets from the date it was put on. Is there any scripts or programs made to remove them from the DB and put them to the location on the file share? This will make everything use the fileshare, hence alot of speed will b...
- 04 Sep 2011, 01:56
- Forum: Help
- Topic: [URGENT] : otrs.PostMaster at 99.9% CPU
- Replies: 3
- Views: 2567
Re: [URGENT] : otrs.PostMaster at 99.9% CPU
what type of systems are you running?
OTRS version, OS, DB type etc?
How much memory on the VM?
What is the output of 'top'?
OTRS version, OS, DB type etc?
How much memory on the VM?
What is the output of 'top'?
- 03 Sep 2011, 18:27
- Forum: Help
- Topic: [SOLVED] DBI:Sybase problem
- Replies: 4
- Views: 5096
Re: DBI:Sybase problem
Finally found the problem and how to fix it!! \o/ The installation guide manual installation for linux (RHEL/Centos/fedora etc..) without the RPM package should be updated to include: Changing the etc/sysconfig/selinux file with the following: SELINUX=disabled Then reboot. I found the solution on th...
- 03 Sep 2011, 13:54
- Forum: Help
- Topic: [SOLVED] DBI:Sybase problem
- Replies: 4
- Views: 5096
Re: DBI:Sybase problem
I've added as mentioned the following in the Config.pm
$Self->{"Database::Type"} = 'mssql';
But the exactly same problem. I've managed to get OTRS 2.4.5 connected the same way to a MSSQL but 3.0.10 seems to be harder.
$Self->{"Database::Type"} = 'mssql';
But the exactly same problem. I've managed to get OTRS 2.4.5 connected the same way to a MSSQL but 3.0.10 seems to be harder.
- 02 Sep 2011, 21:37
- Forum: Help
- Topic: [SOLVED] DBI:Sybase problem
- Replies: 4
- Views: 5096
[SOLVED] DBI:Sybase problem
Hi, I've made another server but from scratch using OTRS 3.0.10 on Centos 6 x64 which connects to a W2008/SQL2008 When running otrs.CheckDB.pl i get the following. [root@localhost]# perl /opt/otrs/bin/otrs.CheckDB.pl Setting of CS_OPT_TEXTSIZE failed. at /usr/local/lib64/perl5/DBI.pm line 720. Tryin...
- 01 Sep 2011, 18:50
- Forum: Help
- Topic: Two groups assigned the same role
- Replies: 0
- Views: 855
Two groups assigned the same role
I was wondering if it was possible to assign two groups the same role somehow? If i do them after each other in $Self->{'AuthSyncModule::LDAP::UserSyncRolesDefinition'} the last one is the only one active. Is it possible to do something like 'cn=agent,o=otrs' | 'cn=agent2,o=otrs' => { # otrs role 'r...
- 31 Aug 2011, 17:37
- Forum: Help
- Topic: LDAP customer login
- Replies: 6
- Views: 2340
Re: LDAP customer login
Sorry didn't understand what you ment crythias. I've set up the following $Self->{'AuthModule::LDAP::Host'} = 'DC FQDN'; $Self->{'AuthModule::LDAP::BaseDN'} = 'OU=GROUP1,dc=domain,dc=com'; $Self->{'AuthModule::LDAP::UID'} = 'sAMAccountname'; $Self->{'AuthModule::LDAP::SearchUserDN'} = 'CN=OTRS,OU=GR...
- 31 Aug 2011, 17:04
- Forum: Help
- Topic: LDAP customer login
- Replies: 6
- Views: 2340
Re: LDAP agent login
I want it to traverse two different OU's in a domain. Where it's domain\OU1 and domain\OU2 Should i then do the following. $Self->{'AuthModule::LDAP::BaseDN'} =''OU=BaseOU1,DC=example,DC=com'; $Self->{'AuthModule::LDAP::BaseDN1'} =''OU=BaseOU2,DC=example,DC=com'; Or should i do it in one go somehow ...
- 31 Aug 2011, 14:46
- Forum: Help
- Topic: LDAP customer login
- Replies: 6
- Views: 2340
Re: LDAP agent login
If i add 1 after the LDAP::UserAttr1 it works, but how to add another? Simply add 2?
- 31 Aug 2011, 13:32
- Forum: Help
- Topic: LDAP customer login
- Replies: 6
- Views: 2340
LDAP customer login
I've set up a link to ActiveDirectory to give one group access. How to set up several groups? Is it as simple as just adding another GroupDN line? Or are there more changes needed? $Self->{'AuthModule::LDAP::GroupDN'} =''CN=otrs_ldap_allow_A,OU=Groups,OU=BaseOU,DC=example,DC=com'; $Self->{'AuthModul...
- 31 Aug 2011, 08:55
- Forum: Help
- Topic: Module GD and PDF not found.
- Replies: 1
- Views: 1555
Re: Module GD and PDF not found.
I would install CPAN if you haven't already installed it
yum install perl-CPAN
Then start CPAN:
perl -e shell -MCPAN.
First time you might need to configure, simplest is autoconfigure
Once CPAN is started do the following:
install GD GD::Text GD::Graph XML::Parser PDF::API2
yum install perl-CPAN
Then start CPAN:
perl -e shell -MCPAN.
First time you might need to configure, simplest is autoconfigure
Once CPAN is started do the following:
install GD GD::Text GD::Graph XML::Parser PDF::API2
- 30 Aug 2011, 09:45
- Forum: Help
- Topic: Configuring mirrorDB
- Replies: 0
- Views: 876
Configuring mirrorDB
Hi, I've set up a MSSQL2008R2 server, which mirrors to another server. But when i try to set up the mirrorDB i get no search results when trying to search. The system log doesn't output anything. DSN connection string is the following: DBI:Sybase:database=mirrordb;host=mirrordbhost;port=1433 Running...
- 25 Aug 2011, 09:40
- Forum: Help
- Topic: Jump to last artikle in ticket
- Replies: 0
- Views: 629
Jump to last artikle in ticket
Hi,
Currently when accessing a ticket it jumps to the last unread artikle (star'ed one). But is it possible to change this to jump to the last article on the ticket instead?
Currently when accessing a ticket it jumps to the last unread artikle (star'ed one). But is it possible to change this to jump to the last article on the ticket instead?
- 18 Aug 2011, 21:09
- Forum: Help
- Topic: Check System Time vs Current Timestamp
- Replies: 1
- Views: 1263
Check System Time vs Current Timestamp
When using the Overview: Support Assessment i find the following "error" Check "System Time" vs "Current Timestamp". There is a material difference (43201 seconds) between application server (1313691961) and database server (1313648760) time. When checking the time the ...
- 03 Aug 2011, 20:04
- Forum: Help
- Topic: OTRS-CGI-10 Invalid Date
- Replies: 0
- Views: 806
OTRS-CGI-10 Invalid Date
When i look in the system log it states: Wed Aug 3 19:54:16 2011 error OTRS-CGI-10 Invalid Date 'Aug 03 2011 08:18AM'! The left side states our time settings (24 h clock) but can't figure out why we get the Invalid and a 12 h clock. In the syslog we got the following: TimeInputFormat Option Timezone...
- 31 Jul 2011, 16:08
- Forum: Help
- Topic: Getting note unlocks ticket
- Replies: 4
- Views: 1981
Re: Getting note unlocks ticket
The Ticket::Frontend::AgentTicketNote###RequiredLock is set to NO We want to be able to add a note to another agents ticket without taking ownership from him when we add a note. Same goes for customers if they email in a note to the given ticket, then the system account shouldn't be set to owner whi...
- 31 Jul 2011, 03:21
- Forum: Help
- Topic: Getting note unlocks ticket
- Replies: 4
- Views: 1981
Re: Getting note unlocks ticket
A ticket is locked on another consultant, i add a note to it, it gets unlocked and locked to me instead. All the system log states is (email replaced by ####): Sun Jul 31 03:13:32 2011 notice OTRS-CGI-10 Sent agent 'AddNote' notification to '####'. If a custom sends in an note the system changes to ...
- 30 Jul 2011, 20:10
- Forum: Help
- Topic: Getting note unlocks ticket
- Replies: 4
- Views: 1981
Getting note unlocks ticket
Hi, When we have a ticket locked to a consultant and the customer replies with a note to it, it automatically unlocks the ticket (OTRS 3.0.9). This makes it harder for the right consultant to follow up the given ticket. The status on the ticket is still set to new, open or pending reminder, doesn't ...