Okay I have ran the test and I'm still getting the same error. ticket-srv# perl CheckDB.pl It looks Ok! ticket-srv# mysql -u admin -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 68 to server version: 3.23.46 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> GRANT ALL PRIVILEGES ON ticket.* TO otrs@localhost IDENTIFIED BY "megan" WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec) mysql> exit Bye ticket-srv# mysqladmin -u admin -p reload Enter password: ticket-srv# and I still get the error -> Error: Access denied for user: 'otrs@localhost' (Using password: YES) Comment: Please contact your admin Bug Report: Click here to report a bug! Handle: /usr/local/psa/lib/perl5/site_perl/5.005/i386-freebsd/Apache/Registry.pm Frontend Subfunction: Apache::ROOT192_2e168_2e175_2e117::otrs::bin::cgi_2dbin::index_2epl::handler (v 1.49) Frontend Line: 123 Backend Subfunction: Kernel::System::DB::new (v 1.22) Backend Line: 55 Backend BackendMessage: Access denied for user: 'otrs@localhost' (Using password: YES) -> Console Jan 21 14:46:53 ticket-srv OTRS-CGI-10[291]: [Error][Kernel::System::DB::new][Line:55]: Access denied for user: 'otrs@localhost' (Using password: YES) Jan 21 14:46:55 ticket-srv OTRS-CGI-10[291]: [Error][Kernel::System::DB::new][Line:55]: Access denied for user: 'otrs@localhost' (Using password: YES) Jan 21 14:47:00 ticket-srv OTRS-CGI-10[291]: [Error][Kernel::System::DB::new][Line:55]: Access denied for user: 'otrs@localhost' (Using password: YES) Jan 21 14:52:17 ticket-srv OTRS-CGI-10[292]: [Error][Kernel::System::DB::new][Line:55]: Access denied for user: 'otrs@localhost' (Using password: YES) Jan 21 14:52:26 ticket-srv OTRS-CGI-10[292]: [Error][Kernel::System::DB::new][Line:55]: Access denied for user: 'otrs@localhost' (Using password: YES) ----- Original Message ----- From: "Martin Edenhofer" To: Sent: Tuesday, January 21, 2003 2:13 PM Subject: Re: [otrs] Install Problem on FreeBSD 4.7

On Tue, Jan 21, 2003 at 09:31:57PM +0100, Robert Kehl wrote:

...

...

Error: Access denied for user: 'otrs@localhost' (Using password: YES)

You may have a peek here:

http://otrs.org/pages/index.pl?Action=Ext&Site=Docu/problems-with-mysql.html

...

#AEN964

Jepp. And I see you use mod_perl (Frontend Subfunction: Apache::ROOT...).

Remember to restart the webserver if you change the Kernel/Config.pm ( installer.pl is changing Kernel/Config.pm (database user and pw)).

--=> mod_perl loads modules on startup.

...

Robert

Martin

-- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- nohl: 11:08pm up 90 days, 1:44, 6 users, load average: 0.40, 0.13, 0.09 _______________________________________________ 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

I going to reinstall everything, I will let you know what happens. -Brian ----- Original Message ----- From: "Martin Edenhofer" To: Sent: Tuesday, January 21, 2003 3:09 PM Subject: Re: [otrs] Install Problem on FreeBSD 4.7

On Tue, Jan 21, 2003 at 02:56:38PM -0800, OTRS wrote:

...

Okay I have ran the test and I'm still getting the same error.

ticket-srv# perl CheckDB.pl It looks Ok!

If this works the database and Kernel/Config.pm is ok.

Please check your apache config. Maybe there is an other (maybe OTRS 0.5) OTRS installed and your http://host/otrs/index.pl points to the old directory (/other/installation/OpenTRS/bin/cgi-bin/ or /other/installation/otrs/bin/cgi-bin/)!

Martin

-- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "There are two major products that come out of Berkeley: LSD and Unix. We don't believe this to be a coincidence." -- Jeremy S. Anderson

_______________________________________________ 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

Never mind I found it.. Thanks again for your help... Very cool system.. -Brian ----- Original Message ----- From: "OTRS" To: Sent: Tuesday, January 21, 2003 5:56 PM Subject: Re: [otrs] Install Problem on FreeBSD 4.7

Okay turns out the copy of MySQL was trashed, After the reinstall everything is fine. Just one more stupid question.

I have setup a Queue called Support and an email address to go with it (support@testdomain.com), Sending mail to the tt system works fine and I get a reply back with the tt #. But the admin account that is setup in the Config.pm never gets the mail letting him know there is a open ticket waiting for him.

I looked at the OTRS - Manual and did not see anything about this settting.

Thanks -Brian

----- Original Message ----- From: "OTRS" To: Sent: Tuesday, January 21, 2003 3:17 PM Subject: Re: [otrs] Install Problem on FreeBSD 4.7

...

I going to reinstall everything, I will let you know what happens.

-Brian

----- Original Message ----- From: "Martin Edenhofer" To: Sent: Tuesday, January 21, 2003 3:09 PM Subject: Re: [otrs] Install Problem on FreeBSD 4.7

...

On Tue, Jan 21, 2003 at 02:56:38PM -0800, OTRS wrote:

...

Okay I have ran the test and I'm still getting the same error.

ticket-srv# perl CheckDB.pl It looks Ok!

If this works the database and Kernel/Config.pm is ok.

Please check your apache config. Maybe there is an other (maybe OTRS 0.5) OTRS installed and your http://host/otrs/index.pl points to the old directory (/other/installation/OpenTRS/bin/cgi-bin/ or /other/installation/otrs/bin/cgi-bin/)!

Martin

-- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "There are two major products that come out of Berkeley: LSD and Unix. We don't believe this to be a coincidence." -- Jeremy S. Anderson

_______________________________________________ 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

_______________________________________________ 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

_______________________________________________ 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

I just check the Config.pm file and everything looks fine.. -> # -----------------------------------------------------# # database settings # # -----------------------------------------------------# # DatabaseHost # (The database host.) $Self->{DatabaseHost} = 'localhost'; # Database # (The database name.) $Self->{Database} = 'ticket'; # DatabaseUser # (The database user.) $Self->{DatabaseUser} = 'otrs'; # DatabasePw # (The password of database user.) $Self->{DatabasePw} = 'megan'; # DatabaseDSN # (The database DSN for MySQL ==> more: "man DBD::mysql") $Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};"; # (The database DSN for PostgrSQL ==> more: "man DBD::Pg") # $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};"; What file is it talking about here ? Line 55 Jan 21 14:52:17 ticket-srv OTRS-CGI-10[292]: [Error][Kernel::System::DB::new][Line:55]: Access denied for user: 'otrs@localhost' (Using password: YES) Jan 21 14:52:26 ticket-srv OTRS-CGI-10[292]: [Error][Kernel::System::DB::new][Line:55]: Access denied for user: 'otrs@localhost' (Using password: YES) thanks -Brian ----- Original Message ----- From: "Martin Edenhofer" To: Sent: Tuesday, January 21, 2003 2:13 PM Subject: Re: [otrs] Install Problem on FreeBSD 4.7

On Tue, Jan 21, 2003 at 09:31:57PM +0100, Robert Kehl wrote:

...

...

Error: Access denied for user: 'otrs@localhost' (Using password: YES)

You may have a peek here:

http://otrs.org/pages/index.pl?Action=Ext&Site=Docu/problems-with-mysql.html

...

#AEN964

Jepp. And I see you use mod_perl (Frontend Subfunction: Apache::ROOT...).

Remember to restart the webserver if you change the Kernel/Config.pm ( installer.pl is changing Kernel/Config.pm (database user and pw)).

--=> mod_perl loads modules on startup.

...

Robert

Martin

-- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- nohl: 11:08pm up 90 days, 1:44, 6 users, load average: 0.40, 0.13, 0.09 _______________________________________________ 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