RE: [otrs] Upgrate to 1.2.2 Admin Account Problem
What does the OTRS log file say? Jake Covert -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Rob Poudrette Sent: Monday, March 29, 2004 11:57 AM To: otrs@otrs.org Subject: [otrs] Upgrate to 1.2.2 Admin Account Problem Hello, After running 1.1 for almost a year, I decided to upgrade to 1.2.2. After doing this I noticed that I did not see any of my tickets anymore. When I log in using the root account, I also noticed that the advanced functionality has disappeared. I'm running RH 8.0 and MySQL. Any help would be greatly appreciated. Rob _______________________________________________ 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/
Covert, Jake wrote:
What does the OTRS log file say?
I could not find a log file for OTRS, but here is something from my messages file: Mar 29 11:12:46 venera OTRS-CGI-10[891]: [Error][Kernel::System::Group::GroupMemberList][Line:409]: Unknown column 'gu.permission_key' in 'field list', SQL: 'SELECT g.id, g.name, gu.permission_key, gu.permission_value, gu.user_id FROM groups g, group_user gu WHERE g.valid_id in ( 1 ) AND g.id = gu.group_id AND gu.permission_value = 1 AND gu.permission_key IN ('rw', 'rw') AND gu.user_id = 2' Mar 29 12:10:03 venera OTRS-PM3-10[2410]: [Error][Kernel::System::POP3Account::POP3AccountGet][Line:112]: Unknown column 'comments' in 'field list', SQL: 'SELECT login, pw, host, queue_id, trusted, comments, valid_id FROM pop3_account WHERE id = 1' Mar 29 12:10:03 venera OTRS-PM3-10[2410]: [Error][main::FetchMail][Line:130]: Can't connect to
Jake Covert
-----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Rob Poudrette Sent: Monday, March 29, 2004 11:57 AM To: otrs@otrs.org Subject: [otrs] Upgrate to 1.2.2 Admin Account Problem
Hello,
After running 1.1 for almost a year, I decided to upgrade to 1.2.2. After doing this I noticed that I did not see any of my tickets anymore. When I log in using the root account, I also noticed that the advanced functionality has disappeared. I'm running RH 8.0 and MySQL. Any help would be greatly appreciated.
Rob
_______________________________________________ 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/ _______________________________________________ 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/
On Monday, March 29, 2004 7:17 PM
Rob Poudrette
Covert, Jake wrote:
What does the OTRS log file say? I could not find a log file for OTRS
Your log destination is set in Config.pm through these settings: # (log backend module) $Self->{LogModule} = 'Kernel::System::Log::SysLog'; # $Self->{LogModule} = 'Kernel::System::Log::File'; # param for LogModule Kernel::System::Log::File (required!) $Self->{'LogModule::LogFile'} = '/tmp/otrs.log'; Per default, OTRS is logging to Syslog. On Windows, the default is the file c:\otrs\otrs\var\log\otrs.log. Just to clear up logging things, Robert Kehl -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Tel. +49 (0)6172 4832388
I found the problem. Since I upgraded using rpm, I assumed that any database changes would have been made. I ran the DBUpdate-to-1.2.mysql.sql and everything works again! Thanks, Rob Covert, Jake wrote:
What does the OTRS log file say?
Jake Covert
-----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Rob Poudrette Sent: Monday, March 29, 2004 11:57 AM To: otrs@otrs.org Subject: [otrs] Upgrate to 1.2.2 Admin Account Problem
Hello,
After running 1.1 for almost a year, I decided to upgrade to 1.2.2. After doing this I noticed that I did not see any of my tickets anymore. When I log in using the root account, I also noticed that the advanced functionality has disappeared. I'm running RH 8.0 and MySQL. Any help would be greatly appreciated.
Rob
_______________________________________________ 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/ _______________________________________________ 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/
participants (3)
-
Covert, Jake -
Rob Poudrette -
Robert Kehl