November 2003 - otrs - OTRS mailing lists

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

Notification for notes
by Alex French 17 Nov '03

17 Nov '03

Hi all, Two quick questions about agent notes added via the web interface: - Is there an easy way to have a notification sent to all group members when a note is added (like for email followups) - Is there a way to make the latest note be shown in the queue view, like emails are? Thanks, Alex

2 1

email
by Stefan Pampel 17 Nov '03

17 Nov '03

Hello otrs-ML, Is it possible to send a EMail? Not a response to a Ticket, but a single mail to one or more customers.. -- Best regards, Stefan mailto:stefanp@edo.uni-dortmund.de

2 1

trouble logging in in
by Mike Vidal 17 Nov '03

17 Nov '03

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?

2 1

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

17 Nov '03

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 Nov 17 15:12:40 otrs Nov 17 15:12:42 otrs OTRS-CGI-10[3106]: [Error][Kernel::System::CustomerUser::LDAP::CustomerUserDataGet][Line:214]: Need User or CustomerID! Nov 17 15:12:42 otrs OTRS-CGI-10[3106]: [Error][Kernel::System::CustomerUser::LDAP::CustomerUserList][Line:192]: 000020D6: SvcErr: DSID-03100690, problem 5012 (DIR_ERROR), data 0 Nov 17 15:12:42 otrs Nov 17 15:12:43 otrs OTRS-CGI-10[3107]: [Error][Kernel::System::CustomerUser::LDAP::CustomerUserDataGet][Line:214]: Need User or CustomerID! Nov 17 15:12:43 otrs OTRS-CGI-10[3107]: [Error][Kernel::System::CustomerUser::LDAP::CustomerUserList][Line:192]: 000020D6: SvcErr: DSID-03100690, problem 5012 (DIR_ERROR), data 0 Nov 17 15:12:43 otrs Nov 17 15:12:45 otrs OTRS-CGI-10[3108]: [Error][Kernel::System::CustomerUser::LDAP::CustomerUserDataGet][Line:214]: Need User or CustomerID! Nov 17 15:12:45 otrs OTRS-CGI-10[3108]: [Error][Kernel::System::CustomerUser::LDAP::CustomerUserList][Line:192]: 000020D6: SvcErr: DSID-03100690, problem 5012 (DIR_ERROR), data 0 Nov 17 15:12:45 otrs Nov 17 15:16:37 otrs OTRS-CGI-10[3101]: [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? Neil -----Original Message----- From: otrs-bounces(a)otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Martin Edenhofer Sent: Monday, November 17, 2003 2:30 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] LDAP Integration Error Hi Neil, On Mon, Nov 17, 2003 at 11:48:44AM -0700, Neil Lehouillier wrote: > I finally got all the required files installed and have otrs working > with apache 2.0 and Mod_perl 1.99 rpms. I got everything configured > and when I work without the ldap integration it works fine. > > When I put in the ldap information into the Config.pm file I get the > following on the http web page and in the logs: > > [Mon Nov 17 11:33:56 2003] [error] 2665: ModPerl::Registry: > IO::Socket::INET: connect: Connection refused at > /opt/otrs/Kernel/cpan-lib/CGI/Carp.pm line 301, <DATA> line 225.! It looks like your LDAP server isn't running! .-) > Neil 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/

2 1

LDAP Integration Error
by Neil Lehouillier 17 Nov '03

17 Nov '03

Hi again, I finally got all the required files installed and have otrs working with apache 2.0 and Mod_perl 1.99 rpms. I got everything configured and when I work without the ldap integration it works fine. When I put in the ldap information into the Config.pm file I get the following on the http web page and in the logs: [Mon Nov 17 11:33:56 2003] [error] 2665: ModPerl::Registry: IO::Socket::INET: connect: Connection refused at /opt/otrs/Kernel/cpan-lib/CGI/Carp.pm line 301, <DATA> line 225.! Has anyone encountered this before??? I've searched through the mail archive and found a couple of references but the were all for older versions of otrs. Thanks.... Neil

2 1

RE: [otrs] Setup OTRS to use a virtual host (ie: otrs.domain.com)
by Erik Spigle 17 Nov '03

17 Nov '03

That's the deal. The apache user group has ownership of the pictures. When I setup my httpd.conf file like this: Alias /otrs-web/ "/opt/otrs/var/httpd/htdocs/" Alias /otrs/ "/opt/otrs/bin/cgi-bin/" <Location /otrs> SetHandler perl-script PerlHandler Apache::Registry Options ExecCGI PerlSendHeader On </Location> the pictures display fine and the whole deal works fine. It's only when I try to setup OTRS as a name-based virtualhost that I run into my issues. Are you referring to some httpd.conf directive to give the name-based virtualhost the proper access? I can't figure out what else to do to my directives inside of <virtualhost *></virtalhost> to give the proper access rights. -----Original Message----- From: Paul [mailto:otrs-users@neenerville.com] Sent: Monday, November 17, 2003 2:49 PM To: 'User questions and discussions about OTRS.' Subject: RE: [otrs] Setup OTRS to use a virtual host (ie: otrs.domain.com) Hi, > Here's the deal, now. I can actually log in, but all my graphics are > missing (items under /otrs-web). Here is the error I get when trying to > directly go to a picture: > > Forbidden > You don't have permission to access /otrs-web/images/Standard/warning.png > on this server. Have you considered giving apache access to the picture files? Check your permissions in relation to the user/group apache is running as. _______________________________________________ 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] Setup OTRS to use a virtual host (ie: otrs.domain.com)
by Erik Spigle 17 Nov '03

17 Nov '03

Here is what I have tried so far, but to no avail. <VirtualHost *> ServerName otrs.mydomain.com ServerAlias otrs.mydomain.com ServerAdmin support(a)mydomain.com DocumentRoot /usr/local/otrs/bin/cgi-bin DirectoryIndex /index.pl ErrorLog /var/log/apache/otrs-error.log CustomLog /var/log/apache/otrs-access.log common Alias /otrs-web "/usr/local/otrs/var/httpd/htdocs" <Location /> SetHandler perl-script PerlHandler Apache::Registry Options ExecCGI PerlSendHeader On </Location> <Directory "/usr/local/otrs/bin/cgi-bin"> AllowOverride None Options ExecCGI Order allow,deny Allow from all </Directory> <Directory "/usr/local/otrs/bin/cgi-bin"> AllowOverride None Options ExecCGI Order allow,deny Allow from all </Directory> </VirtualHost> Here's the deal, now. I can actually log in, but all my graphics are missing (items under /otrs-web). Here is the error I get when trying to directly go to a picture: Forbidden You don't have permission to access /otrs-web/images/Standard/warning.png on this server. -------------------------------------------------------------------------------- Apache/1.3.27 Server at otrs.mihlfeld.com Port 80 It seems to obviously be a permissions error. The odd part is all the permissions are in place from how the readme says (on the file structure) and they work fine when I'm not using a name-based virtualhost: Alias /otrs-web/ "/opt/otrs/var/httpd/htdocs/" Alias /otrs/ "/opt/otrs/bin/cgi-bin/" <Location /otrs> SetHandler perl-script PerlHandler Apache::Registry Options ExecCGI PerlSendHeader On </Location> That works just fine when I'm not going for a name-based virtualhost (which I want one, though). So I think the webserver has the right access to the physical location, but I'm obviously not setting it up right in the http.conf file for it to access the files. Also, another oddity with the virtualhost part is in Windows, I can type http://otrs.mydomain.com and it will go to the index.pl login page. In linux it will try to download some file unless I explictly type in http://otrs.mydomain.com/index.pl This is not the issue with the non-virtualhost type setup (ie: http://www.mydomain.com/) Anyway, I just wanted to provide some more information. I'm sure this is an easy fix, but it's escaping me right now given my apache knowledge isn't the greatest. Thanks! -----Original Message----- From: Erik Spigle Sent: Monday, November 17, 2003 11:57 AM To: otrs(a)otrs.org Subject: [otrs] Setup OTRS to use a virtual host (ie: otrs.domain.com) I got OTRS up and running just fine with its default setup in apache where it resudes under your domain as a sub-directory (ie: www.domain.com/otrs) However, what I would like to do is actually set it up as its own virtual name host (ie: otrs.domain.com) That would put the root of the site at that virtual host rather than /otrs behind whatever the host is. I'm not the greatest with apache virtual hosts, but I can mak them work for the most part. It seems that OTRS is a bit different in how it works and I'm not readily figuring out how to make it work as a virtual host, however. I am trying to set it up under Apache 1.3.27 on a Debian Testing box. Can someone show me how I can adapt the example configuration for apache into one that uses a virtual name host and where the root of the site resides right under that address (ie: otrs.domain.com) instead of a subdirectory (ie: www.domain.com/otrs or otrs.domain.com/otrs) Thankyou _______________________________________________ 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