- otrs - OTRS mailing lists

How to Reply to a Ticket
by Chance Ervin 12 Feb '11

12 Feb '11

otrs version: 3.0.5 OS: Ubuntu 10.10 I have been able to successfully install ORTS, get to the web interface, and even fetch mail. I am not sure I understand how to reply to a ticket through the web interface, though. I can forward ticket content with the 'forward' button but I see no way to reply to a ticket. I see a -Reply- dropdown just to the right of the 'Print' button but it does not appear to do anything. If someone can point me in the right direction for replying to a ticket through the web interface, it would be much appreciated. I am very new with this software, so I may just be missing something simple. Thank you, -- Chance Ervin Sr. Systems and Network Engineer

2 3

Probles with OTRS
by Michelle Konzack 11 Feb '11

11 Feb '11

Hello, arround two years ago I had already asked this, but now it is more or less urgent. I run IBM eServer with a bunchof Apache VHosts and several customers. With OTRS it is not possibel, to run one VHost and have e.g. three differnt targets like "abuse", "support" and "info" like http://support.customer1.com/abuse/ /info/ /support/ http://support.customer2.com/abuse/ /info/ /support/ ... Also it is not possibel to have more then one customer on a server, because OTRS enforce to use ONE database instead one database per customer and target. Then I modified OTRS to support the two things above, but now I get the hell of mySQL performance and it crash all the time Does someone know a more suitable RequestTracker for this kind of usage? Also it should support PostgreSQL and use PHP5 or PHP6 The servers are IBM eServer x345 with Xeon DualCore 3GHz, 8 GByte memory and 6x 147 GByte U320/15k SCSI Drives (Raid-5 + Hotfix) Thanks, Greetings and nice Day/Evening Michelle Konzack -- ##################### Debian GNU/Linux Consultant ###################### Development of Intranet and Embedded Systems with Debian GNU/Linux itsystems@tdnet France EURL itsystems@tdnet UG (limited liability) Owner Michelle Konzack Owner Michelle Konzack Apt. 917 (homeoffice) 50, rue de Soultz Kinzigstraße 17 67100 Strasbourg/France 77694 Kehl/Germany Tel: +33-6-61925193 mobil Tel: +49-177-9351947 mobil Tel: +33-9-52705884 fix <http://www.itsystems.tamay-dogan.net/> <http://www.flexray4linux.org/> <http://www.debian.tamay-dogan.net/> <http://www.can4linux.org/> Jabber linux4michelle(a)jabber.ccc.de Linux-User #280138 with the Linux Counter, http://counter.li.org/

2 3

View source of e-mail
by Timur I. Bakeyev 11 Feb '11

11 Feb '11

Hi all! I've upgraded my OTRS 2.2 to 3.0.5 and now got puzzled, how in the new interface to get look onto the plain text source of the certain e-mail in the ticket, including all the transition headers? Something like what was known as "Plain text mail view": http://otrs.org/images/screen-3.0/email-plain.png Before there was a link "(plain)" next in the zoom view from where you could get that mail source text. With the new interface with the default settings I don't see anything like this, only RTF view. Can somebody point me how can I get such a view or what modules or options have to be enabled to get it? With regards, Timur Bakeyev.

2 2

REG : Closed Tickets
by vijay dahiya 11 Feb '11

11 Feb '11

Dear All, I am using version 3.0.5 , i closed 1 ticket and after closing if i am doing the search i can view tht ticket and with the other option like close and all . I feel once the ticket is closed other option should not be visible . How can i do that . Please help me sort out this .

2 1

Re: [otrs] Strange redirect from index.pl on apache/freebsd
by Ryan Miguel 11 Feb '11

11 Feb '11

I am far from an expert but I once installed from source and I ran into a bunch of problems with the Perl modules. I will try to give you a few ideas (if you haven't already tried or thought of them). As the error says, it can't locate SOAP/Transport/HTTP.pm, be sure that the includes (use SOAP::whatever) listed in rpc.pl exist and are installed and that your Perl library location is correctly stated in rpc.pl. If you checked the Perl modules by running otrs.checkModules it might be a good idea to use CPAN and double-check/reinstall the specific ones pertaining to SOAP and the dependencies. If everything related to Perl appear to be fine it might be a good idea to run the otrs.SetPermissions.pl script. From there I would double-check the web-server config. I hope I was able to provide you with something useful, - Ryan ---------------------------------------------------------------------- Message: 1 Date: Wed, 09 Feb 2011 15:11:29 +0300 From: "A.Rymkus" <rymkus(a)inbox.ru> Subject: Re: [otrs] Strange redirect from index.pl on apache/freebsd box To: "User questions and discussions about OTRS." <otrs(a)otrs.org> Message-ID: <4D528471.3020205(a)inbox.ru> Content-Type: text/plain; charset="windows-1251"; Format="flowed" 08.02.2011 16:55, A.Rymkus ?????: > Hi everybody! > > I'm using otrs-3.0.5 on FreeBSD 8.0-Stable/Intel > I tested it for some time, all was ok. > But, after installation of General Catalog and ITSM modules > (latest versions from ftp://ftp.otrs.org/pub/otrs/itsm/packages30/) > got strange redirect from index.pl to nowhere. > > HTML content of index.pl's (http://192.168.0.1/otrs/index.pl) output: > document <a href="http://192.168.0.1?RequestedURL=">moved</a> > witout any errors in apache's error logs. > > Trying to open rpc.pl causes error page (500 Internal Server > Error) and that's content about this error from apache's error log: > /[Tue Feb 08 16:50:56 2011] [error] Can't locate > SOAP/Transport/HTTP.pm in @INC (@INC contains: > /usr/local/sbin/../../Kernel/cpan-lib /usr/local/sbin/../.. ../../ > /usr/local/Custom /usr/local/Kernel/cpan-lib /usr/local > /usr/local/otrs/Custom /usr/local/otrs/Kernel/cpan-lib > /usr/local/otrs/ /usr/local/lib/perl5/5.8.9/BSDPAN > /usr/local/lib/perl5/site_perl/5.8.9/mach > /usr/local/lib/perl5/site_perl/5.8.9 /usr/local/lib/perl5/5.8.9/mach > /usr/local/lib/perl5/5.8.9 .) at /usr/local/otrs/bin/cgi-bin/rpc.pl > line 32.\nBEGIN failed--compilation aborted at > /usr/local/otrs/bin/cgi-bin/rpc.pl line 32.\n / > BTW, other packages and pages are working, such as customer.pl, > public.pl(faq.pl) > > I checked out all requested system and perl wide packages, as > described on http://www.freshports.org/devel/otrs/, them are correctly > installed and up to date. > > So, does OTRS system need any SOAP port, like SOAP::Lite? > Or direct me where I have to dig to fix this problem. > > PS: googling doesn't gave me anything interesting =( > > -- > WBR, A.Rymkus > > > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Hi again! I installed p5-Apache2-SOAP-0.73, p5-SOAP-Lite-0.712_2 and all dependand packages. That removed errors produced by rpc.pl. But index.pl still redirect me nowhere... help me please =\ -- WBR, A.Rymkus

2 2

Re: [otrs] Yet another unbelievable stats request (Ionel GARDAIS)
by Steve Durbin 11 Feb '11

11 Feb '11

Ionel, > Is there a requirement of a minimal MySQL version for it to work ? There shouldn't be a problem. SUBDATE and INNER JOIN have been in since at least 3.23, and these are the only ones that may be a problem. Try running it against your database and tell me what error messages you get! On my DB, with 2.3 million ticket history records and 63,000 tickets, it takes 1.7sec to run. Cheers, -- Steve Durbin Group Manager: Applications Delivery/Cyfarwyddwr Grŵp: Trosglwyddo Rhaglenni Bridgend County Borough Council/Cyngor Bwrdeistref Sirol Pen-y-Bont ar Ogwr Tel/Rhif ffon: 01656 642113 Mob/ffon symudol: 07976 271559 Fax/Ffacs: 01656 642125 Web/We: http://www.bridgend.gov.uk E-mail may be automatically logged, monitored and/or recorded for legal purposes. Please do not print this email unless absolutely necessary. E-bost yn cael ei logio, ei monitro a/neu ei chofnodi yn awtomatig am resymau cyfreithiol Peidiwch ag argraffu’r neges e-bost hon oni bai fod hynny’n gwbl angenrheidiol. ________________________________________________________________________ This e-mail and any attachments transmitted with it represents the views of the individual(s) who sent them and should not be regarded as the official view of Bridgend County Borough Council. The contents are confidential and intended solely for the use of the addressee. If you have received it in error, please inform the system administrator on (+44) 01656 642111. This e-mail and any attachments have been scanned with 'MessageLabs SkyScan' - http://www.messagelabs.com/ ________________________________________________________________________ Mae'r e-bost hwn ac unrhyw atodiadau a drosglwyddir gydag ef yn cynrychioli safbwyntiau'r unigolyn a'i anfonodd (unigolion a'u hanfonodd) ac ni ddylid eu hystyried fel safbwynt swyddogol Cyngor Bwrdeistref Sirol Pen-y-bont ar Ogwr. Mae'r cynnwys yn gyfrinachol ac wedi'i fwriadu ar gyfer y sawl y'i cyfeiriwyd ato yn unig. Os ydych wedi ei dderbyn mewn camgymeriad, rhowch wybod i weinyddwr y system ar (+44) 01656 642111. Mae'r e-bost hwn ac unrhyw atodiadau wedi cael eu sganio gyda 'MessageLabs SkyScan' - http://www.messagelabs.com/ ________________________________________________________________________

1 0

Re: [otrs] Yet another unbelievable stats request (Ionel GARDAIS)
by Steve Durbin 10 Feb '11

10 Feb '11

Ionel, This huge bit of SQL (for MySQL) will give you what you want. There's no 'stats' way of doing it I'm aware of. Note that a ticket that was closed then reopened will be counted twice. The result here was: +--------------------+---------+ | Fix Band | Tickets | +--------------------+---------+ | a. 0-4 Hours | 2590 | | b. 4 Hours - 1 Day | 502 | | c. 1 - 8 Days | 657 | | d. >8 days | 180 | +--------------------+---------+ 4 rows in set (1.82 sec) SELECT CASE WHEN (SUBDATE(th.change_time, INTERVAL 4 HOUR) <= t.create_time) THEN 'a. 0-4 Hours' WHEN ((SUBDATE(th.change_time, INTERVAL 1 DAY) <= t.create_time) AND (SUBDATE(th.change_time, INTERVAL 4 HOUR) > t.create_time)) THEN 'b. 4 Hours - 1 Day' WHEN ((SUBDATE(th.change_time, INTERVAL 8 DAY) <= t.create_time) AND (SUBDATE(th.change_time, INTERVAL 1 DAY) > t.create_time)) THEN 'c. 1 - 8 Days' ELSE 'd. >8 days' END as 'Fix Band', COUNT(*) as 'Tickets' FROM ticket AS t INNER JOIN ticket_state s ON t.ticket_state_id = s.id INNER JOIN ticket_state_type st ON s.type_id = st.id and st.name = 'closed' INNER JOIN ticket_history th on t.id = th.ticket_id and th.state_id = t.ticket_state_id INNER JOIN ticket_history_type tht on th.history_type_id = tht.id and tht.name in ('NewTicket','StateUpdate') WHERE t.create_time > SUBDATE(NOW(),INTERVAL 1 MONTH) AND th.change_time is not null GROUP BY CASE WHEN (SUBDATE(th.change_time, INTERVAL 4 HOUR) <= t.create_time) THEN 'a. 0-4 Hours' WHEN ((SUBDATE(th.change_time, INTERVAL 1 DAY) <= t.create_time) AND (SUBDATE(th.change_time, INTERVAL 4 HOUR) > t.create_time)) THEN 'b. 4 Hours - 1 Day' WHEN ((SUBDATE(th.change_time, INTERVAL 8 DAY) <= t.create_time) AND (SUBDATE(th.change_time, INTERVAL 1 DAY) > t.create_time)) THEN 'c. 1 - 8 Days' ELSE 'd. >8 days' END ORDER BY CASE WHEN (SUBDATE(th.change_time, INTERVAL 4 HOUR) <= t.create_time) THEN 'a. 0-4 Hours' WHEN ((SUBDATE(th.change_time, INTERVAL 1 DAY) <= t.create_time) AND (SUBDATE(th.change_time, INTERVAL 4 HOUR) > t.create_time)) THEN 'b. 4 Hours - 1 Day' WHEN ((SUBDATE(th.change_time, INTERVAL 8 DAY) <= t.create_time) AND (SUBDATE(th.change_time, INTERVAL 1 DAY) > t.create_time)) THEN 'c. 1 - 8 Days' ELSE 'd. >8 days' END; -- Steve Durbin Group Manager: Applications Delivery/Cyfarwyddwr Grŵp: Trosglwyddo Rhaglenni Bridgend County Borough Council/Cyngor Bwrdeistref Sirol Pen-y-Bont ar Ogwr Tel/Rhif ffon: 01656 642113 Mob/ffon symudol: 07976 271559 Fax/Ffacs: 01656 642125 Web/We: http://www.bridgend.gov.uk E-mail may be automatically logged, monitored and/or recorded for legal purposes. Please do not print this email unless absolutely necessary. E-bost yn cael ei logio, ei monitro a/neu ei chofnodi yn awtomatig am resymau cyfreithiol Peidiwch ag argraffu’r neges e-bost hon oni bai fod hynny’n gwbl angenrheidiol. ________________________________________________________________________ This e-mail and any attachments transmitted with it represents the views of the individual(s) who sent them and should not be regarded as the official view of Bridgend County Borough Council. The contents are confidential and intended solely for the use of the addressee. If you have received it in error, please inform the system administrator on (+44) 01656 642111. This e-mail and any attachments have been scanned with 'MessageLabs SkyScan' - http://www.messagelabs.com/ ________________________________________________________________________ Mae'r e-bost hwn ac unrhyw atodiadau a drosglwyddir gydag ef yn cynrychioli safbwyntiau'r unigolyn a'i anfonodd (unigolion a'u hanfonodd) ac ni ddylid eu hystyried fel safbwynt swyddogol Cyngor Bwrdeistref Sirol Pen-y-bont ar Ogwr. Mae'r cynnwys yn gyfrinachol ac wedi'i fwriadu ar gyfer y sawl y'i cyfeiriwyd ato yn unig. Os ydych wedi ei dderbyn mewn camgymeriad, rhowch wybod i weinyddwr y system ar (+44) 01656 642111. Mae'r e-bost hwn ac unrhyw atodiadau wedi cael eu sganio gyda 'MessageLabs SkyScan' - http://www.messagelabs.com/ ________________________________________________________________________

2 1

Yet another unbelievable stats request
by Ionel GARDAIS 09 Feb '11

09 Feb '11

Hi list, Big heads here are asking the following thing to be retrieved from OTRS : during a determined time-frame, provide a count of the ticket based on the resolution time. More clearly, that is : - for the last month - how many tickets - have been resolved/closed in "0 to 4hours", "4 hours to 1 day", "1 day to 8 days" and "8 days and more". Is it possible to get this stat within the stat module ? Many thanks, Ionel -- Ionel GARDAIS Tech'Advantage CIO - IT Team manager

1 0

Strange redirect from index.pl on apache/freebsd box
by A.Rymkus 09 Feb '11

09 Feb '11

Hi everybody! I'm using otrs-3.0.5 on FreeBSD 8.0-Stable/Intel I tested it for some time, all was ok. But, after installation of General Catalog and ITSM modules (latest versions from ftp://ftp.otrs.org/pub/otrs/itsm/packages30/) got strange redirect from index.pl to nowhere. HTML content of index.pl's (http://192.168.0.1/otrs/index.pl) output: document <a href="http://192.168.0.1?RequestedURL=">moved</a> witout any errors in apache's error logs. Trying to open rpc.pl causes error page (500 Internal Server Error) and that's content about this error from apache's error log: /[Tue Feb 08 16:50:56 2011] [error] Can't locate SOAP/Transport/HTTP.pm in @INC (@INC contains: /usr/local/sbin/../../Kernel/cpan-lib /usr/local/sbin/../.. ../../ /usr/local/Custom /usr/local/Kernel/cpan-lib /usr/local /usr/local/otrs/Custom /usr/local/otrs/Kernel/cpan-lib /usr/local/otrs/ /usr/local/lib/perl5/5.8.9/BSDPAN /usr/local/lib/perl5/site_perl/5.8.9/mach /usr/local/lib/perl5/site_perl/5.8.9 /usr/local/lib/perl5/5.8.9/mach /usr/local/lib/perl5/5.8.9 .) at /usr/local/otrs/bin/cgi-bin/rpc.pl line 32.\nBEGIN failed--compilation aborted at /usr/local/otrs/bin/cgi-bin/rpc.pl line 32.\n / BTW, other packages and pages are working, such as customer.pl, public.pl(faq.pl) I checked out all requested system and perl wide packages, as described on http://www.freshports.org/devel/otrs/, them are correctly installed and up to date. So, does OTRS system need any SOAP port, like SOAP::Lite? Or direct me where I have to dig to fix this problem. PS: googling doesn't gave me anything interesting =( -- WBR, A.Rymkus

1 1

Search / Generic Agent disagree?
by Nick Bright 09 Feb '11

09 Feb '11

Greetings, I'm trying to set up some generic agent jobs to delete specific notification tickets that don't need to be saved after they're closed and have aged past 90 days. When I set up a search critera with a specific "from" address, status = closed successful, and closed time before 3 months I get 834 results. Unfortuantely, when I set up a Generic Agent to delete these tickets with identical criteria, it says "0 Tickets affected! What do you want to do?". I've come across this about a half dozen times tonight with different searches I've tried, while deleting old SPAM tickets and junk that doesn't represent a real ticket but has been cluttering up my database. What am I doing wrong? -- --- - Nick Bright Network Administrator Valnet Tel 888-332-1616 x 315 Fax 620-331-0789

1 0