Search found 37 matches

by qt_zetroc
06 Oct 2012, 22:40
Forum: Help
Topic: syntax error at DBUpdate-to-3.1.mysql.sql
Replies: 2
Views: 1729

Re: syntax error at DBUpdate-to-3.1.mysql.sql

Sorry got confused there. I figured it out. Thanks for the tips.
by qt_zetroc
06 Oct 2012, 19:38
Forum: Help
Topic: syntax error at DBUpdate-to-3.1.mysql.sql
Replies: 2
Views: 1729

syntax error at DBUpdate-to-3.1.mysql.sql

Hi All,

Anyone can help?After running DBUpdate-to-3.1.mysql.sql | mysql -p -f -u root otrs I got this error :

[root@helpdesk scripts]# perl DBUpdate-to-3.1.mysql.sql | mysql -p -f -u root otrs
Bareword found where operator expected at DBUpdate-to-3.1.mysql.sql line 7, near ") NULL"
(Missing ...
by qt_zetroc
29 Sep 2012, 10:23
Forum: Help
Topic: Installing and Upgrading to OTRS 3.1.x or higher
Replies: 2
Views: 1381

Re: Installing and Upgrading to OTRS 3.1.x or higher

Thank you. Is it necessary to upgrade to beta (otrs-3.1.0.beta1-01.noarch.rpm) until the latest beta package (otrs-3.1.0.beta5-01.noarch.rpm), before upgrading to 3.1 (otrs-3.1.0.rc1-01.noarch.rpm)?

Or can I skip the beta part, say for example : From otrs-3.0.16-01.noarch.rpm to otrs-3.1.0.rc1-01 ...
by qt_zetroc
28 Sep 2012, 14:29
Forum: Help
Topic: Installing and Upgrading to OTRS 3.1.x or higher
Replies: 2
Views: 1381

Installing and Upgrading to OTRS 3.1.x or higher

Hi Moderators,

Just few questions and queries :
1. Is version 3.1.x or higher is free?Do I need a license to continue using it in production?
2. If can use for free, can I upgrade from 3.0.16 to 3.1.10?
2. If not, which free version can i use in production?

Thank you very much!
by qt_zetroc
26 Apr 2012, 05:17
Forum: Help
Topic: Apache Warning Error after removing ScriptAlias
Replies: 0
Views: 827

Apache Warning Error after removing ScriptAlias

Hi All,

I followed the topic on how to get rid of /otrs URI and was able to get this error on my apache :

[root@helpdesk ~]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd: [Thu Apr 26 11:06:38 2012] [warn] The Alias directive in /etc/httpd/conf/httpd.conf at line 539 will probably ...
by qt_zetroc
26 Apr 2012, 05:12
Forum: Help
Topic: Images at FAQ are not displaying after removing URI
Replies: 1
Views: 1060

Re: Images at FAQ are not displaying after removing URI

Consider this as resolved as I have manually uploaded the images on FAQ. Thank you
by qt_zetroc
17 Apr 2012, 07:11
Forum: Help
Topic: Images at FAQ are not displaying after removing URI
Replies: 1
Views: 1060

Images at FAQ are not displaying after removing URI

After following this forum http://forums.otterhub.org/posting.php?mode=reply&f=61&t=8978

The images are not displayed on the articles for all users (agent,customer,public)

It seems that the image path is still using the old URL such as /otrs/index.pl, /otrs/customer.pl and /otrs/public.pl.

Can ...
by qt_zetroc
21 Jan 2012, 08:25
Forum: Help
Topic: Customers unable to login with multiple domain/LDAP
Replies: 5
Views: 3999

Re: Customers unable to login with multiple domain/LDAP

Thanks crythias! You are the MASTER!
by qt_zetroc
20 Jan 2012, 14:16
Forum: Developers
Topic: How to add an Owner filter to dashboard
Replies: 6
Views: 11566

Re: How to add an Owner filter to dashboard

hi can share your code of AgentDasboardTicketGeneric.dtl

Thanks.
by qt_zetroc
20 Jan 2012, 13:53
Forum: Help
Topic: Is it possible to sign my auto-response with my PGP key?
Replies: 1
Views: 1084

Re: Is it possible to sign my auto-response with my PGP key?

Already figured out and need some coding out here. Can be resolved. Thanks
by qt_zetroc
20 Jan 2012, 13:52
Forum: Help
Topic: Customers unable to login with multiple domain/LDAP
Replies: 5
Views: 3999

Re: Customers unable to login with multiple domain/LDAP

Thanks, can be more specific. On which part I should give a number?

The code is attached and can help post the link here. Thanks
by qt_zetroc
20 Jan 2012, 13:48
Forum: Help
Topic: How to point GPG folder to another server?
Replies: 4
Views: 2634

Re: How to point GPG folder to another server?

Considered resolved. Thank you very much for the help.
by qt_zetroc
20 Jan 2012, 13:47
Forum: Help
Topic: How to make PRIORITY a mandatory field?
Replies: 5
Views: 3625

Re: How to make PRIORITY a mandatory field?

Thanks crythias. Considered resolved
by qt_zetroc
25 Oct 2011, 14:09
Forum: Help
Topic: Customers unable to login with multiple domain/LDAP
Replies: 5
Views: 3999

Re: Customers unable to login with multiple domain/LDAP

Hi Guys,

Please help. I need to work with multiple domains for customer login.

Thank you in advance!
by qt_zetroc
13 Oct 2011, 14:35
Forum: Help
Topic: Customers unable to login with multiple domain/LDAP
Replies: 5
Views: 3999

Customers unable to login with multiple domain/LDAP

Hi All,

I have configured two domains to query for customers using LDAP. I am able to see those customers under "Customer" tab, however they are not able to login thru customer portal (/customer.pl)
And also when using one domain everything is ok. Upon adding another one, this problem happens ...
by qt_zetroc
30 Aug 2011, 10:51
Forum: Help
Topic: Is it possible to sign my auto-response with my PGP key?
Replies: 1
Views: 1084

Is it possible to sign my auto-response with my PGP key?

Hi All,

I have configure OTRS with PGP enabled but my auto-response are not signed with my secret key.

Is it possible to have it signed before sending out to customers?
by qt_zetroc
29 Aug 2011, 12:49
Forum: Help
Topic: Accidentally removed index.pl file
Replies: 4
Views: 2469

Re: Accidentally removed index.pl file

Brilliant! It is resolved!

Thanks renee!You are truly a OTRS Wizard! :) :)
by qt_zetroc
29 Aug 2011, 12:17
Forum: Help
Topic: Accidentally removed index.pl file
Replies: 4
Views: 2469

Re: Accidentally removed index.pl file

Thanks Renee,

I have already the copy and loaded in the same location but somehow cannot make it work. Still having the same error.

Do you have the procedure the restore the file?
by qt_zetroc
29 Aug 2011, 12:01
Forum: Help
Topic: Accidentally removed index.pl file
Replies: 4
Views: 2469

Accidentally removed index.pl file

Hi Guys,

I accidentally removed the index.pl file from /opt/otrs/bin/cgi-bin. Is there a way to put this back without redoing or reinstalling everything?

I am actually getting a 500 Internal Server Error :
Internal Server Error
The server encountered an internal error or misconfiguration and was ...
by qt_zetroc
29 Aug 2011, 09:24
Forum: Help
Topic: How to make my private PGP key as default?
Replies: 0
Views: 800

How to make my private PGP key as default?

Hi Guys,

I have implemented PGP on our system and would like to make my private key as default. I want to automatically "Sign" all outgoing emails with my private key.

Upon creating new email ticket, I want to remove the "-none-" selection on the "Sign : " drop down selection. And the fact I only ...
by qt_zetroc
21 Aug 2011, 08:56
Forum: Help
Topic: How to point GPG folder to another server?
Replies: 4
Views: 2634

Re: How to point GPG folder to another server?

Is it possible or anyone have tried tweaking the PreferencesPGP.pm file to throw the file to another server?

Thanks in advance!
by qt_zetroc
18 Aug 2011, 16:54
Forum: Help
Topic: How to make PRIORITY a mandatory field?
Replies: 5
Views: 3625

Re: How to make PRIORITY a mandatory field?

Hi Crythias,

Actually the problem is to correct the PRIORITY everytime an agent creates a phone or email ticket. Giving a default 3 Standard is also not the correct approach for our environment.

For workaround, I have created a "-" PRIORITY to avoid always giving default 3 Standard everytime an ...
by qt_zetroc
18 Aug 2011, 08:29
Forum: Help
Topic: How to point GPG folder to another server?
Replies: 4
Views: 2634

How to point GPG folder to another server?

Hi All,

Currently we have two instance of OTRS running, one for customer page and the other for agent/administration page which connects to one Database server. Apparently, got two separate servers for Customer and Agent page.

AFAIK, GPG folder (.gnupg) stores all keys locally. Since customers ...
by qt_zetroc
18 Aug 2011, 08:18
Forum: Help
Topic: How to make PRIORITY a mandatory field?
Replies: 5
Views: 3625

How to make PRIORITY a mandatory field?

I wanted to make PRIORITY selection for new phone and email ticket to be mandatory at agent page.

Is this possible?Please advise. Many Thanks
by qt_zetroc
16 Aug 2011, 12:19
Forum: Help
Topic: decrypt message
Replies: 13
Views: 8653

Re: decrypt message

Thanks jojo,

I already figured out the issue. It is because of our Email (Anti virus/filtering) partner. It is scanning and appending a note under the emails.
by qt_zetroc
16 Aug 2011, 11:53
Forum: Help
Topic: Crypt private key passphrase
Replies: 5
Views: 3367

Re: Crypt private key passphrase

Thanks jojo for the clarifications and very swift response.

Can we add this as a feature request. :) Many Thanks!
by qt_zetroc
16 Aug 2011, 10:19
Forum: Help
Topic: Crypt private key passphrase
Replies: 5
Views: 3367

Crypt private key passphrase

Hi All,

Is there a way to crypt the passpharase of your own private key displayed at Sysconfig>Framework>Crypt::PGP? It seems that it is displayed as plain text on the web.

For some reasons, we need to hide and make it confidential due to security reasons.

By the way, I have tried crypting ...
by qt_zetroc
11 Aug 2011, 14:13
Forum: Help
Topic: decrypt message
Replies: 13
Views: 8653

Re: decrypt message

Any related topic sending encrypted HTML format emails ?

Many Thanks for the assistance!
by qt_zetroc
08 Aug 2011, 15:46
Forum: Help
Topic: decrypt message
Replies: 13
Views: 8653

Re: decrypt message

Thanks a lot!

I think I have figure this out and got it working. I have re-done the process and was able to see private key on the list.

However when sending HTML format email it is still displaying the encrypted message.

From: customer@company.com
To: otrs@company.com
Attachment: PGPexch.htm ...
by qt_zetroc
08 Aug 2011, 10:35
Forum: Help
Topic: decrypt message
Replies: 13
Views: 8653

Re: decrypt message

For import the private key in the PGP admin area :
A. Kindly confirm which admin area are you referring,
1.) Admin>PGP Keys
2.) Sysconfig>Framework>Crypt::PGP>PGP::Key::Password

Thank you!
by qt_zetroc
08 Aug 2011, 09:25
Forum: Help
Topic: decrypt message
Replies: 13
Views: 8653

Re: decrypt message

1. Did you import your private key? Kindly advise how to do this? What I done is to put it inside Crypt::PGP>PGP::Key::Password
2. Is it visible in admin pgp area? Only public keys of OTRS and customers are visible at Admin page. Do I need to import to the admin page?
3. Is the mail encrypted with ...
by qt_zetroc
08 Aug 2011, 07:51
Forum: Help
Topic: decrypt message
Replies: 13
Views: 8653

Re: decrypt message

Hi All,

I followed the manual at http://doc.otrs.org/3.0/en/html/configure-pgp.html but it still giving me the same error (gpg: No private key found to decrypt this message!)

I also tried hard coding the below code to Config.pm file of OTRS, but seems not working ...
by qt_zetroc
03 Aug 2011, 13:52
Forum: Help
Topic: Sent no 'auto reply' for Ticket [ticket #]
Replies: 7
Views: 4537

Re: Sent no 'auto reply' for Ticket [ticket #]

Hi All,

We are also facing the same issue here. We have the same setup where customers sends email to support@company.com and will be replicated to otrs@company.com. On the other hand, OTRS fetches email from otrs@company.com via POP3S.

We have configured "support@company.com" as SYSTEM EMAIL ...
by qt_zetroc
30 Jun 2011, 11:57
Forum: Help
Topic: Tag TicketFreeText to existing SLA
Replies: 4
Views: 2168

Re: Tag TicketFreeText to existing SLA

This is when customers who send email using their personal email address account (ex. @yahoo.com @ gmail.com @hotmail.com). This is for some reason that some customers used their personal email addresses, especially the Bosses. :)

Since OTRS will not recognized those email addresses as customers ...
by qt_zetroc
29 Jun 2011, 08:39
Forum: Help
Topic: Tag TicketFreeText to existing SLA
Replies: 4
Views: 2168

Re: Tag TicketFreeText to existing SLA

Hi All,

Anyone can help to sort this out? Many Thanks in advance!
by qt_zetroc
24 Jun 2011, 07:13
Forum: Help
Topic: Tag TicketFreeText to existing SLA
Replies: 4
Views: 2168

Tag TicketFreeText to existing SLA

Hi All,

I have enabled TicketFreeText Key1 and Key2 for customers who are not registered to my OTRS system. Now I want to tag this Service and SLA to my existing Services and SLAs.
This is to trigger the existing SLA when an agent creates a ticket in phone and email ticket.

I have attached the ...
by qt_zetroc
04 May 2011, 10:34
Forum: General
Topic: How is backup OTRS 3.x in Windows 2008?
Replies: 7
Views: 4594

Re: How is backup OTRS 3.x in Windows 2008?

Hi Reva,

This sounds interesting. Would you mind sharing us your script?Or maybe can keep between us by sending via PM.

Many Thanks and have a great day!