RE: [otrs] trouble logging in in
I figured it out. for some reason the installer.pl wouldnt work correctly. I set up the db and config file by and and now it's working. -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org]On Behalf Of Mike Vidal Sent: Monday, November 17, 2003 8:40 PM To: User questions and discussions about OTRS. Subject: RE: [otrs] trouble logging in in Anyone know if this looks correct? bash-2.05b# mysqlshow -vv -u root -pXXXXXXX otrs Database: otrs +------------------------------+----------+------------+ | Tables | Columns | Total Rows | +------------------------------+----------+------------+ | article | 25 | 0 | | article_attachment | 9 | 0 | | article_plain | 7 | 0 | | article_sender_type | 8 | 0 | | article_type | 8 | 0 | | auto_response | 14 | 0 | | auto_response_type | 8 | 0 | | charset | 9 | 0 | | customer_preferences | 3 | 0 | | customer_user | 14 | 0 | | faq | 10 | 0 | | follow_up_possible | 8 | 0 | | group_user | 8 | 0 | | groups | 8 | 0 | | personal_queues | 2 | 0 | | pop3_account | 12 | 0 | | queue | 20 | 0 | | queue_auto_response | 7 | 0 | | queue_standard_response | 6 | 0 | | salutation | 9 | 0 | | session | 2 | 0 | | signature | 9 | 0 | | standard_attachment | 11 | 0 | | standard_response | 9 | 0 | | standard_response_attachment | 7 | 0 | | system_address | 12 | 0 | | system_user | 11 | 0 | | theme | 7 | 0 | | ticket | 27 | 0 | | ticket_history | 11 | 0 | | ticket_history_type | 8 | 0 | | ticket_index | 7 | 0 | | ticket_lock_index | 1 | 0 | | ticket_lock_type | 7 | 0 | | ticket_loop_protection | 2 | 0 | | ticket_priority | 6 | 0 | | ticket_state | 9 | 0 | | ticket_state_type | 7 | 0 | | time_accounting | 8 | 0 | | user_preferences | 3 | 0 | | valid | 6 | 0 | +------------------------------+----------+------------+ 41 rows in set. -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org]On Behalf Of Martin Edenhofer Sent: Monday, November 17, 2003 5:07 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] trouble logging in in Hi Mike, it looks like your database is corrupt! I never saw something like that. -Martin On Mon, Nov 17, 2003 at 04:54:09PM -0600, Mike Vidal wrote:
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/ _______________________________________________ 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/
Martin Edenhofer -- ((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/ _______________________________________________ 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 (1)
-
Mike Vidal