- otrs - OTRS mailing lists

RE: [otrs] LDAP Integration Error
by Neil Lehouillier 18 Nov '03

18 Nov '03

I have been able to browse the ldap database using a third party program. But I think I'm enter the information wrong into the Config.pm file. Can you help me out with the formatting....: Here is our setup: O=domain.local OU=Accounts OU=Admins CN=testuser # ldap host Host => 'dc1.domain.local', # ldap base dn BaseDN => 'O=domain.local', # search scope (one|sub) SSCOPE => 'sub', # The following is valid but would only be necessary if the # anonymous user does NOT have permission to read from the LDAP tree UserDN => 'O=domain.local/DC=Accounts/DC=Admins/DC=testuser', UserPw => 'passwordtest123', Any help is appreciated.... Neil -----Original Message----- From: otrs-bounces(a)otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Martin Edenhofer Sent: Monday, November 17, 2003 3:34 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] LDAP Integration Error Hi Neil, On Mon, Nov 17, 2003 at 03:18:07PM -0700, Neil Lehouillier wrote: > Ok it seems I had the wrong host in the Config.pm. Everything seems > to work now except when I go and look at the Customer User information > Nothing shows up. When I look in the /var/log/messages file I find: > > Nov 17 15:12:40 otrs OTRS-CGI-10[3103]: > [Error][Kernel::System::CustomerUser::LDAP::CustomerUserList][Line:192 > ]: 000020D6: SvcErr: DSID-03100690, problem 5012 (DIR_ERROR), data 0 > [...] Is there anything more I need to enter in the Config.pm file? Try to debug it (access to your ldap server with Config.pm settings) with an ldap browser. Then you should have the same problem. > Neil 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/

1 0

New Message Age
by Charles R. "Rusty" Thompson 18 Nov '03

18 Nov '03

Ok.. I think I may have asked for this before, but now I really need to hack this solution out, we had a case slip out of control because it's latest message snuck in after a previous reply. Message... Agent... Cust. Reply.. (shows new message. No action needed at that moment, so left it) Cust Urget Reply (goes unnoticed because New Message still shows) We have a problem with the personal queue views. When it says 'New Message!' in red or whatever, we need it to also state the age or at least the date/timestamp of that new message. I know.. it's our techs own fault for not posting a note to clear the new message deal but we'd really like to see the age of the emails in the list view. What is available to me in that area to either show the new message date/time or calc the age of the newest email? Thanks, Charles

1 0

root@localhost does not have access to administrative functions
by Gold, Steven T 18 Nov '03

18 Nov '03

When I log into OTRS 1.1.3 as root@localhost I have no access to the administrative functions. I have looked in the MySQL database, but as I am no expert I am hopeful that someone can point me in the right direction for fixing this dilemma (short of deleting the database..hopefully). Steve _________________________________________________ Steve Gold Network Administrator WBFS-UPN33, WTVX-UPN34 & WFOR-CBS4

3 2

root@localhost does not have access to administrative functions
by Gold, Steven T 18 Nov '03

18 Nov '03

When I log into OTRS 1.1.3 as root@localhost I have no access to the administrative functions. I have looked in the MySQL database, but as I am no expert I am hopeful that someone can point me in the right direction for fixing this dilemma (short of deleting the database..hopefully). Steve _________________________________________________ Steve Gold Network Administrator WBFS-UPN33, WTVX-UPN34 & WFOR-CBS4

1 0

RE: [otrs] otrs on mac osx - problems with pop3
by Erik Mathis - AIU Dunwoody Staff 18 Nov '03

18 Nov '03

I would first check to see if you could pop your mail from another client. If you want to manually do it, use this link http://www.faqs.org/rfcs/rfc1939.html for reference. Next you say you are not getting any email sent to that server? Can you send mail from another account from that server back to the local account? Try sending the mail to addy(a)hostname.domain.ext (FQDN). If you get the mail that way, then I would look at your DNS settings and make sure the MX record is correct. Hope this helps Erik Mathis AIU Dunwoody Network Administrator > -----Original Message----- > From: Johan Pustoch [mailto:Johan.Pustoch@emn.fr] > Sent: Friday, November 14, 2003 11:30 AM > To: otrs(a)otrs.org > Subject: [otrs] otrs on mac osx - problems with pop3 > > > Hello, > > First, excuse my bad english... > I had installed otrs on a mac os x server (with perl 5.8, mysql). > > I have now a problem with pop3: > - I have created an "POP3 account" with login, > password, host, trusted, > queue, ... > - I have created a system adress in "Email adresses". > This adress is > associated with the POP3 account. > > It doesn't work (I don't receive the emails... There 's no > error message...) I read the documentation but i don't find > how to resolve y problem... > > Do I forget something in configuration ? > Do you how to test if pop3 work on my machine with perl ? > > Thank You and have a nice week end, > Johan P. > > > > > > > -------------------------------------------------------------- > ---------- > Johan Pustoch > Centre de Ressources et d'Innovation en Technologies Educatives > > CRITE - Ecole des Mines de Nantes > 4, rue Alfred Kastler - BP 20722 > F-44307 Nantes Cedex 3 > FRANCE > Tél / Phone : (33) 2 51 85 86 53 > -------------------------------------------------------------- > ---------- > > _______________________________________________ > 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/ >

2 1

RE: [otrs] trouble logging in in
by Mike Vidal 18 Nov '03

18 Nov '03

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(a)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(a)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(a)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/

1 0

RE: [otrs] trouble logging in in
by Mike Vidal 18 Nov '03

18 Nov '03

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(a)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(a)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/

1 0

bind MAILER-DAEMON responses to ticket?
by Frank Adler 17 Nov '03

17 Nov '03

Hi, we use a web form which sends email to OTRS. Unfortunately the users sometimes have problems to type their email address correcty. In this cases the answer will bounce but is not added to the ticket. Did anyone figure out how to 'manipulate' the incoming mails that way to bind them to the appropriate ticket? -- Best regards, Frank mailto:otrs_ml@allesklar.com

3 3

RE: [otrs] trouble logging in in
by Mike Vidal 17 Nov '03

17 Nov '03

I'll drop the db and redo it and see what happnes. -----Original Message----- From: otrs-bounces(a)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(a)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/

1 0

RE: [otrs] trouble logging in in
by Mike Vidal 17 Nov '03

17 Nov '03

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(a)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/

2 1