November 2003 - otrs - OTRS mailing lists

Closed Ticket auto reply?
by Rogers, Weston 19 Nov '03

19 Nov '03

When I close a ticket, it sends an auto reponse as such : ** THIS IS JUST A NOTE *** The state of your ticket '1000022' has been changed by 'Weston Rogers' to 'closed successful'. http://192.168.1.252/otrs/customer.pl?Action=CustomerZoom&TicketID=23 Your OTRS Notification Master *** THIS IS JUST A NOTE *** How can I get rid of this? I don't want an auto reponse when I close a ticket. I went to the Admin area, and there are no auto reponses set up for any of the queues, yet I still get it. Any clues? Thanks, Weston Rogers Data Applications Engineer USLec Corp. 704.319.1332

3 2

Can only login on localhost, via web won't work.
by GLASHEEN,JOHN D 18 Nov '03

18 Nov '03

I have a new Redhat 9 server with pretty much default settings, fully updated as far as Redhat is concerned, but Apache, Perl, etc are the versions that came with the Redhat ISO (I haven't figured out how to yet) All seems swell when I login at http://localhost/otrs/index.pl, but I can't login with any username via the web (not local host). I can see the login page, but there's also the following accross the bottom: ******* Forbidden You don't have permission to access /otrs/ on this server. Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request. Apache/2.0.40 Server at rivers Port 80 ***** Any ideas? I assume that it's a permissions thing. Thanks, John -- GLASHEEN,JOHN D

1 0

RE: [otrs] LDAP Integration Error
by Thomas Nilsen 18 Nov '03

18 Nov '03

Neil, By the looks of the error message I would assume that you run on a Active Directory. If that's the case, are you 100% sure that your setup really is "O=domain.local"? Normally, an AD installation would be in the form of "cn=domain,cn=local". You can do a dump of AD using "ldifde -f output.txt". If you do this dump, you can easily see read the correct o/cn from the output.txt file.. But then I might be all wrong about the AD assumption... Regards, Thomas >-----Original Message----- >From: Neil Lehouillier [mailto:NLehouillier@comptonpetroleum.com] >Sent: Tuesday, November 18, 2003 10:00 PM >To: User questions and discussions about OTRS. >Subject: RE: [otrs] LDAP Integration Error > > >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/ >_______________________________________________ >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/ > DISCLAIMER: This message contains information that may be privileged or confidential and is the property of the Roxar Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorised to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.

1 0

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