Search found 47 matches

by zhakal
19 Jan 2013, 03:32
Forum: Help
Topic: No close_time
Replies: 0
Views: 277

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...
by zhakal
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: 14539

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.
by zhakal
25 May 2012, 22:44
Forum: Help
Topic: [SOLVED] Mod_perl
Replies: 6
Views: 2122

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.
by zhakal
22 May 2012, 08:47
Forum: Help
Topic: [SOLVED] Mod_perl
Replies: 6
Views: 2122

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...
by zhakal
21 May 2012, 17:22
Forum: Help
Topic: [SOLVED] Mod_perl
Replies: 6
Views: 2122

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 installat...
by zhakal
21 May 2012, 07:08
Forum: Help
Topic: [SOLVED] Mod_perl
Replies: 6
Views: 2122

[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...
by zhakal
01 Feb 2012, 21:26
Forum: General
Topic: OTRS Feature Add-Ons
Replies: 5
Views: 1066

Re: OTRS Feature Add-Ons

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.
This is a question I'd also like a answer to. The price should be reasonable as it's no longer a subscription.
by zhakal
08 Jan 2012, 02:41
Forum: Help
Topic: otrs 3 with iis 7 and Microsoft sql
Replies: 5
Views: 701

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...
by zhakal
08 Jan 2012, 00:34
Forum: Help
Topic: [SOLVED] Hide Queue from Customer
Replies: 2
Views: 585

[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!!
by zhakal
06 Jan 2012, 21:49
Forum: Help
Topic: [SOLVED] Hide Queue from Customer
Replies: 2
Views: 585

[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...
by zhakal
04 Jan 2012, 22:04
Forum: Help
Topic: PostMaster Filter parts of body with wildcard
Replies: 4
Views: 1419

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?
by zhakal
03 Jan 2012, 17:45
Forum: Help
Topic: PostMaster Filter parts of body with wildcard
Replies: 4
Views: 1419

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}))
by zhakal
03 Jan 2012, 17:06
Forum: Help
Topic: PostMaster Filter parts of body with wildcard
Replies: 4
Views: 1419

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...
by zhakal
30 Dec 2011, 23:50
Forum: General
Topic: New account in the OTRS wiki
Replies: 1
Views: 483

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 :(
by zhakal
30 Dec 2011, 23:00
Forum: Patches / Modules
Topic: New Module: QuickClose
Replies: 5
Views: 7858

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 the process really extremely much on ce...
by zhakal
29 Dec 2011, 14:26
Forum: Help
Topic: Image upload bug after update to ckeditor 3.6.2
Replies: 14
Views: 1933

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...
by zhakal
28 Dec 2011, 19:20
Forum: Help
Topic: Email notification when using note-internal
Replies: 2
Views: 946

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...
by zhakal
26 Dec 2011, 20:49
Forum: General
Topic: New account in the OTRS wiki
Replies: 1
Views: 483

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
by zhakal
30 Nov 2011, 09:59
Forum: Help
Topic: How to update ckeditor
Replies: 2
Views: 820

Re: How to update ckeditor

Thank you! I can now do a proper udate of the ckeditor :D
by zhakal
29 Nov 2011, 23:27
Forum: Help
Topic: How to update ckeditor
Replies: 2
Views: 820

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...
by zhakal
28 Nov 2011, 14:10
Forum: Help
Topic: error OTRS-CGI-10 Invalid Date '22-NOV-11'!
Replies: 4
Views: 707

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.
by zhakal
28 Nov 2011, 12:48
Forum: Help
Topic: Strange SQL query used OFTEN
Replies: 0
Views: 299

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.
by zhakal
28 Nov 2011, 12:45
Forum: Help
Topic: error OTRS-CGI-10 Invalid Date '22-NOV-11'!
Replies: 4
Views: 707

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
by zhakal
20 Oct 2011, 16:26
Forum: OTRS Developers
Topic: Adding additional colum to views
Replies: 3
Views: 710

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.
by zhakal
20 Oct 2011, 16:22
Forum: Patches / Modules
Topic: New Module: QuickClose
Replies: 5
Views: 7858

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.
by zhakal
28 Sep 2011, 19:04
Forum: Help
Topic: Search on customer_company name
Replies: 3
Views: 1574

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?
by zhakal
28 Sep 2011, 13:07
Forum: Help
Topic: Search on customer_company name
Replies: 3
Views: 1574

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 ...
by zhakal
27 Sep 2011, 17:06
Forum: Help
Topic: Adding another column to AgentTicketQueue
Replies: 1
Views: 455

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?
by zhakal
27 Sep 2011, 13:33
Forum: Help
Topic: Adding another column to AgentTicketQueue
Replies: 1
Views: 455

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
by zhakal
09 Sep 2011, 13:30
Forum: Help
Topic: Attachment database to file storage
Replies: 1
Views: 468

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...
by zhakal
04 Sep 2011, 01:56
Forum: Help
Topic: [URGENT] : otrs.PostMaster at 99.9% CPU
Replies: 3
Views: 912

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'?
by zhakal
03 Sep 2011, 18:27
Forum: Help
Topic: [SOLVED] DBI:Sybase problem
Replies: 4
Views: 2331

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...
by zhakal
03 Sep 2011, 13:54
Forum: Help
Topic: [SOLVED] DBI:Sybase problem
Replies: 4
Views: 2331

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.
by zhakal
02 Sep 2011, 21:37
Forum: Help
Topic: [SOLVED] DBI:Sybase problem
Replies: 4
Views: 2331

[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...
by zhakal
01 Sep 2011, 18:50
Forum: Help
Topic: Two groups assigned the same role
Replies: 0
Views: 348

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...
by zhakal
31 Aug 2011, 17:37
Forum: Help
Topic: LDAP customer login
Replies: 6
Views: 724

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...
by zhakal
31 Aug 2011, 17:04
Forum: Help
Topic: LDAP customer login
Replies: 6
Views: 724

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 ...
by zhakal
31 Aug 2011, 14:46
Forum: Help
Topic: LDAP customer login
Replies: 6
Views: 724

Re: LDAP agent login

If i add 1 after the LDAP::UserAttr1 it works, but how to add another? Simply add 2?
by zhakal
31 Aug 2011, 13:32
Forum: Help
Topic: LDAP customer login
Replies: 6
Views: 724

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...
by zhakal
31 Aug 2011, 08:55
Forum: Help
Topic: Module GD and PDF not found.
Replies: 1
Views: 1023

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
by zhakal
30 Aug 2011, 09:45
Forum: Help
Topic: Configuring mirrorDB
Replies: 0
Views: 398

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...
by zhakal
25 Aug 2011, 09:40
Forum: Help
Topic: Jump to last artikle in ticket
Replies: 0
Views: 278

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?
by zhakal
18 Aug 2011, 21:09
Forum: Help
Topic: Check System Time vs Current Timestamp
Replies: 1
Views: 654

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 App server is set to CEST and ...
by zhakal
03 Aug 2011, 20:04
Forum: Help
Topic: OTRS-CGI-10 Invalid Date
Replies: 0
Views: 407

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...
by zhakal
31 Jul 2011, 16:08
Forum: Help
Topic: Getting note unlocks ticket
Replies: 4
Views: 734

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...
by zhakal
31 Jul 2011, 03:21
Forum: Help
Topic: Getting note unlocks ticket
Replies: 4
Views: 734

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 ...
by zhakal
30 Jul 2011, 20:10
Forum: Help
Topic: Getting note unlocks ticket
Replies: 4
Views: 734

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 ...