August 2005 - otrs - OTRS mailing lists

RE: [otrs] Using apostrophes in the subject causing problems
by Sheline, Carl (LLU) 02 Aug '05

02 Aug '05

Here's the kicker: Just for fun, I took the same otrs installation, created a mysql database, changed a few config files to point otrs to the mysql database (instead of postgres) and magically all my problems I've been emailing this thread about disappeared! The apostrophe issue can't be duplicated. The case sensitive search issue is fixed also now. I made a few more changes and we have now switched to using mysql permanently. Thanks for everyone's help here. Carl Sheline School of Dentistry Loma Linda University -----Original Message----- From: otrs-bounces(a)otrs.org on behalf of Bryan Fullerton Sent: Tue 7/5/2005 2:19 PM To: User questions and discussions about OTRS.org Subject: Re: [otrs] Using apostrophes in the subject causing problems On 6/30/05, Jeremy Blain <jeremy(a)belent.com> wrote: > This sounds like an sql escaping issue, where placeholders or proper > quoting > should be used for all the data, but isn't correct. > (this is potentially a security issue too) > > I've filed a bug report about it > http://bugs.otrs.org/show_bug.cgi?id=809 This is the same as a bug I filed in May. http://bugs.otrs.org/show_bug.cgi?id=732 It also seems to be the same as this bug. http://bugs.otrs.org/show_bug.cgi?id=788 For what it's worth I haven't seen this bug recently, but I also haven't seen any email recently with apostrophes in the subject. Bryan _______________________________________________ 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 Support oder Consulting für Ihr OTRS System? =http://www.otrs.de/

5 8

Mod_perl2 required for Package Admin?
by Mark Nernberg 02 Aug '05

02 Aug '05

I was using OTRS 2.0-beta and decided to upgrade to the stable 2.01 version. I am running Apache 1.3.33 on FreeBSD 5.4 with Perl 5.8.6 Using the beta version, I found the Webmail & Calendar features super-useful. To my surprise, when I upgraded -- and I probably did it somewhat "bone-headed" -- I got the error message "Error: Sorry, mod_perl2 is needed by this module!" when I went to run the Package Manager. What could I do to re-install the Webmail & Calendar modules?

2 5

Accounted time
by Simon A. F. Lund 02 Aug '05

02 Aug '05

Dear Community, Is it possible to get the accounted time shown in the customer frontend? In the overview alongside "age, subject, state, etc.." and in the zoom view with a bit more detail about when the accounted time was "added"? regards, Simon

2 1

RE: Re: [otrs] Premature end of script headers: installer.pl
by Vikram Thakur 02 Aug '05

02 Aug '05

The server is running Apache 2.0.51 without mod_perl. I'm connecting to a mysql server running on another machine. I added the relevant information in the Config.pm file and httpd.conf. - Vikram > -----Original Message----- > From: otrs-bounces(a)otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of > Christian Schoepplein > Sent: Tuesday, August 02, 2005 4:29 AM > To: User questions and discussions about OTRS.org > Subject: Re: [otrs] Premature end of script headers: installer.pl > > Hello Vikram, > > On Mon, Aug 01, 2005 at 01:10:30PM -0400, Vikram Thakur wrote: > >I'm trying to install OTRS on Apache on Fedora Core 3. > > From source or via a prebuild package? > > >If I run the installer.pl file from the shell it shows me the HTML page > >and some stuff (no errors). But when I try to open the script from the > >browser it give me a 500 Internal error. The logs show it as.. > > > >Premature end of script headers: installer.pl > > > >Any help is appreciated. > > Can you post your webserver configuration for OTRS please? > > Best regards, > Christian > > -- > ((otrs)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg > http://www.otrs.de/ :: Manage your communication!

1 0

Premature end of script headers: installer.pl
by Vikram Thakur 02 Aug '05

02 Aug '05

I'm trying to install OTRS on Apache on Fedora Core 3. If I run the installer.pl file from the shell it shows me the HTML page and some stuff (no errors). But when I try to open the script from the browser it give me a 500 Internal error. The logs show it as.. Premature end of script headers: installer.pl Any help is appreciated. - Vikram

2 1

Upgrading from 1.2.2 to 2.0.1
by Jimmy Cobb 02 Aug '05

02 Aug '05

Are there any problems to expect when upgrading from 1.2.2 to 2.0.1? Is there a database conversion script available for 2.0.1? I'm also wondering if I am going to have to re-customize the web interface to get the colors and layout more like the rest of our site.

2 1

Delete Ticket in a Queue
by mbesponga＠greendot.com.ph 01 Aug '05

01 Aug '05

Hello. I wanted to delete tickets in "Junk Queue" every night. I configured Generic Agent "Junk" thru web interface (I do not have access in database). However, when I run the Generic Agent "Junk" all tickets in OTRS are all deleted not just tickets in Junk Queue. How do I resolve this problem? Thanks in advance. (: Marilyn

2 1