- otrs - OTRS mailing lists

RE: [otrs] Time Tracking
by Erik Mathis - ATL Dunwoody Staff 26 Sep '03

26 Sep '03

Jason Joines wrote: > It looks like we are going to deploy OTRS as the Ticket System for > my organiztion. Other organiztions have asked me for sugggestions. > However, one of their requirements is the ability for each Tech that > works on a ticket to be able to enter the amount of time they spent on > it. The management wants to be able to see how much time was spent on > various things. > > I didn't see any mention of this kind of functionality in the > manual. Is this capability available or does anyone have any ideas > for how to add it? > When one closes a ticket, a box named "Time units (work units):" is where they can fill this in. > Thanks, > > Jason Joines > Open Source = Open Mind > ======================== > > _______________________________________________ > 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 Erik Mathis AIU Dunwoody Network Administrator emathis(a)aiuniv.edu

2 1

Error Message after login!!
by Chris Wong 26 Sep '03

26 Sep '03

After login, I've got the following message, how can i solve it? Thx Server error! The server encountered an internal error and was unable to complete your request. Error message: no connection to syslog available at /opt/otrs//Kernel/System/Log/SysLog.pm line 42 If you think this is a server error, please contact the webmaster Error 500 _________________________________________________________ 最新鈴聲推介:遇見，亂世佳人，假如愛有天意... http://ringtone.yahoo.com.hk

1 0

attachments
by Bernhard Mandera 25 Sep '03

25 Sep '03

Hallo, what must be done so that otrs can send more than one attachment in an email? Best Regards, Bernhard Mandera -------------- PIRONET NDH AG Bernhard Mandera Maarweg 149-161 - 50825 Cologne (Germany) Phone: +49 (0) 221 770 1332 - Fax: +49 (0) 221 770 1005

2 1

Interesting permissions problem on Redhat 9
by Miller, Avi 25 Sep '03

25 Sep '03

Hi, I'm hoping someone can help me out here: I've installed OTRS on a Redhat 9 system, using the Redhat 8 RPM (though, the same thing happens installing manually via the tarball). Everything installs fine, but the CRONTAB entries don't run. I get the following errors for PostMasterPOP3.pl, UnlockTickets.pl and GenericAgent.pl -- I assume I'll get the same errors on all the scripts, when they run. install_driver(mysql) failed: Can't locate loadable object for module DBD::mysql in @INC (@INC contains: /opt/otrs/Kernel/cpan-lib /opt/otrs /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at (eval 35) line 3 Compilation failed in require at (eval 35) line 3. Perhaps a module that DBD::mysql requires hasn't been fully installed at /opt/otrs/Kernel/System/DB.pm line 103 What's interesting about this error is that it only happens when the otrs user tries to run the script. If I run the script as root, it works just fine. So, there is something wrong with the permissions for the otrs user. I've been trying to search on this, but can't seem to find anything. Any assistance would be appreciated! Thanks, Avi --- Web Infrastructure Manager National Office for the Information Economy Phone : 02 6271 1120 Mobile: 0412 229 687

2 1

RE: Error: Can't connect to local MySQL server (resolved)
by Steven Casey 25 Sep '03

25 Sep '03

> > Hi Steven, > > On Thu, Sep 25, 2003 at 12:54:07AM -0500, Steven Casey wrote: > > Mandrake Linux 9.1 > > MySQL 4.0.14 > > Apache1.3.28 (mod_perl 1.x) > > otrs-1.1.3-01 > > > > I've installed otrs several times on different machines and haven't had this > > problem. I'm not sure where to go to fix it. I can plug in the url: > > http://servername/otrs/installer.pl and I can create the db fine. When I go > > to index.pl, I get: Error: Can't connect to local MySQL server through > > socket '/var/lib/mysql/mysql.sock (2). It's no wonder since I don't have > > that directory. The /etc/my.cnf only lists /tmp/mysql.sock for both the > > client and the server. What's happening? Thanks in advance. > > http://servername/otrs/installer.pl is using the mysql shell (till OTRS 1.2). > > http://servername/otrs/index.pl is using DBD::mysql (Perl DBI driver). In > your case it looks like DBD::mysql isn't compiled for your dist. or on your > machine. However, it should work if you create an link from /var/lib/mysql/mysql.sock > to /tmp/mysql.sock in your filesystem. > > > Steven Casey > > Systems Engineer > > scasey2(a)tampabay.rr.com > > Martin > > -- > Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ > -- > "The number of Unix installations has grown to 10, with more expected." > The Unix Programmer's Manual, 2nd Edition, June 1972 > > > Thanks for the reply Martin, but I think something else is happening. I > didn't do anything with the modules (nor did I create any sym links to the > mysql.sock) and merely shut the web services down and restarted ( about 7 > times), then, for some reason, I got my login screen. That's the good > news...the bad news is that I can't login as any user with or without a > password.....checking the archives again.... *************************************************** ok, maybe 4:30 in the morning isn't the best time to tackle things, but what I forgot to do was login as suggested with root@localhost/root My problem was my root account has a different password which was what I was trying to use...duh! Once I used the correct login, everything was fine. Maybe for setup, the initial login would default to the root@localhost/root combo? Just a thought.

1 0

Using time zone different from MySQL server
by Goran Sorak 25 Sep '03

25 Sep '03

Hello, I am interested if there is an "easy" way (even with global search/replace in source code) to have OTRS times in MySQL database to use different time zone from the one for which MySQL server is set up? Details: MySQL server (version 3.23.56) is run by ISP in different time zone from my customers. and I can't change it (MySQL server's time zone). Still, I would like my customers to see ticket's times from database in their local time (all customers are in the same time zone). Is there an easy way to do it (I don't think MySQL has any client side options to select time zone). Thanks, Goran

1 0

http://localhost/otrs/installer.pl will not be executed
by Ortner, Uwe 25 Sep '03

25 Sep '03

Hello, I had to move my installation from Linux to Solaris (SPARC) When I try to open http://localhost/otrs/installer.pl, I see the file contents, but nothing will be executed. I made a sample: #!/usr/bin/perl -w use strict; my $r = shift; $r->send_http_header('text/html'); $r->print("works!!!\n"); this works pretty fine Any ideas? Regards Uwe PS: perl, v5.8.0 built for sun4-solaris

2 3

RE: Error: Can't connect to local MySQL server (update)
by Steven Casey 25 Sep '03

25 Sep '03

Subject: Error: Can't connect to local MySQL server > Mandrake Linux 9.1 > MySQL 4.0.14 > Apache1.3.28 (mod_perl 1.x) > otrs-1.1.3-01 > > I've installed otrs several times on different machines and haven't had this > problem. I'm not sure where to go to fix it. I can plug in the url: > http://servername/otrs/installer.pl and I can create the db fine. When I go > to index.pl, I get: Error: Can't connect to local MySQL server through > socket '/var/lib/mysql/mysql.sock (2). It's no wonder since I don't have > that directory. The /etc/my.cnf only lists /tmp/mysql.sock for both the > client and the server. What's happening? Thanks in advance. Thanks for the reply Martin, but I think something else is happening. I didn't do anything with the modules (nor did I create any sym links to the mysql.sock) and merely shut the web services down and restarted ( about 7 times), then, for some reason, I got my login screen. That's the good news...the bad news is that I can't login as any user with or without a password.....checking the archives again....

1 0

Error: Can't connect to local MySQL server
by Steven Casey 25 Sep '03

25 Sep '03

Mandrake Linux 9.1 MySQL 4.0.14 Apache1.3.28 (mod_perl 1.x) otrs-1.1.3-01 I've installed otrs several times on different machines and haven't had this problem. I'm not sure where to go to fix it. I can plug in the url: http://servername/otrs/installer.pl and I can create the db fine. When I go to index.pl, I get: Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock (2). It's no wonder since I don't have that directory. The /etc/my.cnf only lists /tmp/mysql.sock for both the client and the server. What's happening? Thanks in advance. Best Regards, Steven Casey Systems Engineer scasey2(a)tampabay.rr.com

2 1

RE: [otrs] Bug with PhoneDefaultSubject (?)
by Lars Monsees 24 Sep '03

24 Sep '03

Ok, I already found it (but I´m sure it wasn´t there yesterday ;-) One has to use "PhoneDefaultNewSubject" instead of "PhoneDefaultSubject". Is "PhoneDefaultSubject" used for something else or isn´t it used anymore? Lars > -----Original Message----- > From: otrs-bounces(a)otrs.org > [mailto:otrs-bounces@otrs.org]On Behalf Of > Lars Monsees > Sent: Tuesday, September 23, 2003 10:19 AM > To: Otrs (E-Mail) > Subject: [otrs] Bug with PhoneDefaultSubject (?) > > > Hello, > > I want a new ticket (created in phoneview) to not have a > default subject. > Therefore I copied the following text from Defaults.pm to > Config.pm. > > # default note subject > $Self->{PhoneDefaultSubject} = ''; > > # default note text > $Self->{PhoneDefaultNewNoteText} = ''; > > > It wasn´t necessary to restart httpd or otrs for the > "NewNoteText" to be empty. > But it didn´t work for the subject. I then restarted httpd > and otrs but nothing changed. > > I used 'test' instead of '' and this didn´t work either. > > > Did I forget something or could this be a bug? > > > > Lars > _______________________________________________ > 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? >

5 5