Here's what I found. In /var/log/messages Nov 17 22:33:54 rt OTRS-CGI-10[49432]: [Error][Kernel::System::State::StateGetStatesByType][Line$ Nov 17 22:33:54 rt OTRS-CGI-10[49432]: [Error][Kernel::System::State::StateGetStatesByType][Line$ Nov 17 22:33:54 rt OTRS-CGI-10[49432]: [Error][Kernel::System::Lock::LockViewableLock][Line:65]:$ Nov 17 22:33:54 rt OTRS-CGI-10[49432]: [Error][Kernel::System::Lock::LockViewableLock][Line:65]:$ Nov 17 22:34:03 rt OTRS-CGI-10[49432]: [Error][Kernel::System::State::StateGetStatesByType][Line$ Nov 17 22:34:03 rt OTRS-CGI-10[49432]: [Error][Kernel::System::State::StateGetStatesByType][Line$ Nov 17 22:34:03 rt OTRS-CGI-10[49432]: [Error][Kernel::System::Lock::LockViewableLock][Line:65]:$ Nov 17 22:34:03 rt OTRS-CGI-10[49432]: [Error][Kernel::System::Lock::LockViewableLock][Line:65]:$ Nov 17 22:34:03 rt OTRS-CGI-10[49432]: [Error][Kernel::System::Auth::DB::Auth][Line:88]: You hav$ Nov 17 22:34:03 rt OTRS-CGI-10[49432]: [Notice][Kernel::System::Auth::DB::Auth] User: root@local$ in /var/log/http-error.log lots and lots of this. [ [Mon Nov 17 03:14:10 2003] null: DBD::mysql::st execute failed: You have an error in your SQL sy$ ERROR: OTRS-CGI-10 Perl: 5.6.1 OS: freebsd Time: Mon Nov 17 03:14:10 2003 Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL$ Traceback (40195): Module: Kernel::System::State::StateGetStatesByType (v1.3) Line: 198 Module: Kernel::System::Ticket::new (v1.55) Line: 87 Module: Apache::ROOT::otrs::index_2epl::handler (v1.58) Line: 154 Module: (eval) (v2.01) Line: 149 Module: Apache::Registry::handler (v2.01) Line: 149 [Mon Nov 17 03:14:10 2003] null: DBD::mysql::st execute failed: You have an error in your SQL sy$ ERROR: OTRS-CGI-10 Perl: 5.6.1 OS: freebsd Time: Mon Nov 17 03:14:10 2003 Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL$ Traceback (40195): Module: Kernel::System::State::StateGetStatesByType (v1.3) Line: 198 Module: Kernel::System::Ticket::new (v1.55) Line: 92 Module: Apache::ROOT::otrs::index_2epl::handler (v1.58) Line: 154 Module: (eval) (v2.01) Line: 149 Module: Apache::Registry::handler (v2.01) Line: 149 [Mon Nov 17 03:14:10 2003] null: DBD::mysql::st execute failed: You have an error in your SQL sy$ ERROR: OTRS-CGI-10 Perl: 5.6.1 OS: freebsd Time: Mon Nov 17 03:14:10 2003 Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL$ Traceback (40195): Module: Kernel::System::Lock::LockViewableLock (v1.1) Line: 65 Module: Kernel::System::Ticket::new (v1.55) Line: 97 Module: Apache::ROOT::otrs::index_2epl::handler (v1.58) Line: 154 Module: (eval) (v2.01) Line: 149 Module: Apache::Registry::handler (v2.01) Line: 149 [Mon Nov 17 03:14:10 2003] null: DBD::mysql::st execute failed: You have an error in your SQL sy$ ERROR: OTRS-CGI-10 Perl: 5.6.1 OS: freebsd Time: Mon Nov 17 03:14:10 2003 Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL$ Traceback (40195): Module: Kernel::System::Lock::LockViewableLock (v1.1) Line: 65 Module: Kernel::System::Ticket::new (v1.55) Line: 99 Module: Apache::ROOT::otrs::index_2epl::handler (v1.58) Line: 154 Module: (eval) (v2.01) Line: 149 Module: Apache::Registry::handler (v2.01) Line: 149 [Mon Nov 17 03:15:10 2003] null: DBD::mysql::st execute failed: You have an error in your SQL sy$ ERROR: OTRS-CGI-10 Perl: 5.6.1 OS: freebsd Time: Mon Nov 17 03:15:10 2003 Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL$ Traceback (40196): Module: Kernel::System::State::StateGetStatesByType (v1.3) Line: 198 Module: Kernel::System::Ticket::new (v1.55) Line: 87 Module: Apache::ROOT::otrs::index_2epl::handler (v1.58) Line: 154 Module: (eval) (v2.01) Line: 149 Module: Apache::Registry::handler (v2.01) Line: 149 [Mon Nov 17 03:15:10 2003] null: DBD::mysql::st execute failed: You have an error in your SQL sy$ ERROR: OTRS-CGI-10 Perl: 5.6.1 OS: freebsd Time: Mon Nov 17 03:15:10 2003 Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL$ Traceback (40196): Module: Kernel::System::State::StateGetStatesByType (v1.3) Line: 198 Module: Kernel::System::Ticket::new (v1.55) Line: 92 Module: Apache::ROOT::otrs::index_2epl::handler (v1.58) Line: 154 Module: (eval) (v2.01) Line: 149 Module: Apache::Registry::handler (v2.01) Line: 149 [Mon Nov 17 03:15:10 2003] null: DBD::mysql::st execute failed: You have an error in your SQL sy$ ERROR: OTRS-CGI-10 Perl: 5.6.1 OS: freebsd Time: Mon Nov 17 03:15:10 2003 Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL$ Traceback (40196): Module: Kernel::System::Lock::LockViewableLock (v1.1) Line: 65 Module: Kernel::System::Ticket::new (v1.55) Line: 97 Module: Apache::ROOT::otrs::index_2epl::handler (v1.58) Line: 154 Module: (eval) (v2.01) Line: 149 Module: Apache::Registry::handler (v2.01) Line: 149 [Mon Nov 17 03:15:10 2003] null: DBD::mysql::st execute failed: You have an error in your SQL sy$ ERROR: OTRS-CGI-10 Perl: 5.6.1 OS: freebsd Time: Mon Nov 17 03:15:10 2003 Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL$ Traceback (40196): Module: Kernel::System::Lock::LockViewableLock (v1.1) Line: 65 Module: Kernel::System::Ticket::new (v1.55) Line: 99 Module: Apache::ROOT::otrs::index_2epl::handler (v1.58) Line: 154 Module: (eval) (v2.01) Line: 149 Module: Apache::Registry::handler (v2.01) Line: 149 [Mon Nov 17 03:15:10 2003] null: DBD::mysql::st execute failed: You have an error in your SQL sy$ ERROR: OTRS-CGI-10 Perl: 5.6.1 OS: freebsd Time: Mon Nov 17 03:15:10 2003 Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL$ Traceback (40196): Module: Kernel::System::Auth::DB::Auth (v1.6) Line: 88 Module: Kernel::System::Auth::Auth (v1.15) Line: 60 Module: Apache::ROOT::otrs::index_2epl::handler (v1.58) Line: 185 Module: (eval) (v2.01) Line: 149 Module: Apache::Registry::handler (v2.01) Line: 149 [Mon Nov 17 03:15:10 2003] null: DBD::mysql::st fetchrow_array failed: fetch() without execute()$ [Mon Nov 17 03:15:16 2003] null: DBD::mysql::st execute failed: You have an error in your SQL sy$ ERROR: OTRS-CGI-10 Perl: 5.6.1 OS: freebsd Time: Mon Nov 17 03:15:16 2003 Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL$ in /var/log/otrs.log NOTHING -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org]On Behalf Of Martin Edenhofer Sent: Monday, November 17, 2003 4:36 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] trouble logging in in Hi Mike, On Sun, Nov 16, 2003 at 09:36:31PM -0600, Mike Vidal wrote:
I just installed otrs and everything seemed to work well. When I try to log in for the first time using root@localhost with the pasword of root the login page tells me I have the wrong username and/or password. How do I debug this?
Have a look to the otrs and the werbserver error log file. You will find more info there. Martin -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Tel. +49 (0)6172 4832388 _______________________________________________ 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/