[otrs] Access denied for user 'otrs'@'localhost'

3,303 views
Skip to first unread message

Prince Chavez

unread,
Sep 25, 2009, 5:42:25 PM9/25/09
to ot...@otrs.org
Hi All,

I previously installed otrs2.2.4 on an Ubuntu 8.04 server, but it lacked imaps/pop3s support. So i removed it from my system and manually installed 2.4.4. Took me a while, but I managed to get the perl modules and apache configured. One thing I didn't remove was the database from my old install.

Now when i visit index.pl, i get this error:

Error: Access denied for user 'otrs'@'localhost' (using password: YES)
Comment: Please contact your admin
Bug Report:
Traceback: ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Sat Sep 26 05:31:34 2009

Message: Access denied for user 'otrs'@'localhost' (using password: YES)

Traceback (10316): 
   Module: Kernel::System::DB::new (v1.105) Line: 188
   Module: Kernel::System::Web::InterfaceAgent::Run (v1.43) Line: 143
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 48
   Module: (eval) (v1.88) Line: 204
   Module: ModPerl::RegistryCooker::run (v1.88) Line: 204
   Module: ModPerl::RegistryCooker::default_handler (v1.88) Line: 170
   Module: ModPerl::Registry::handler (v1.99) Line: 31

Any ideas? I already tried changing this line (just to test) on apache2-perl-startup.pl, but the auth failure still indicates otrs@localhost:

use Apache::DBI ();
Apache::DBI->connect_on_init('DBI:mysql:otrs', 'root', 'mysqlrootpasswdhere');
use DBI ();


Any help would be appreciated.

Thanks

Nathan Campbell

unread,
Sep 25, 2009, 6:11:11 PM9/25/09
to User questions and discussions about OTRS.

Have you run the db update scripts?

 

Nathan Campbell
Dallas Symphony Orchestra

From: otrs-b...@otrs.org [mailto:otrs-b...@otrs.org] On Behalf Of Prince Chavez
Sent: Friday, September 25, 2009 4:42 PM
To: ot...@otrs.org
Subject: [otrs] Access denied for user 'otrs'@'localhost'

 

Hi All,

I previously installed otrs2.2.4 on an Ubuntu 8.04 server, but it lacked imaps/pop3s support. So i removed it from my system and manually installed 2.4.4. Took me a while, but I managed to get the perl modules and apache configured. One thing I didn't remove was the database from my old install.

Now when i visit index.pl, i get this error:


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

Comment:

Please contact your admin

Bug Report:

[Click here to report a bug!]

Traceback:

ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Sat Sep 26 05:31:34 2009

Message: Access denied for user 'otrs'@'localhost' (using password: YES)

Traceback (10316): 
   Module: Kernel::System::DB::new (v1.105) Line: 188
   Module: Kernel::System::Web::InterfaceAgent::Run (v1.43) Line: 143
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 48
   Module: (eval) (v1.88) Line: 204
   Module: ModPerl::RegistryCooker::run (v1.88) Line: 204
   Module: ModPerl::RegistryCooker::default_handler (v1.88) Line: 170
   Module: ModPerl::Registry::handler (v1.99) Line: 31

Prince Chavez

unread,
Sep 25, 2009, 8:33:02 PM9/25/09
to User questions and discussions about OTRS.
Hi Nate,

I have managed to make it work! Here's what I did:

1.) Deleted the 'otrs' database using phpMyAdmin
2.) Created new database / user.
3.) Updated Kernel/Config.pm
4.) Uploaded otrs-schema.mysql.sql using phpMyAdmin
5.) Uploaded otrs-initial_insert.mysql.sql using phpMyAdmin

Amazing how much looking into the error logs and Google can help solve problems!

Prince Chavez
Customer Relations Manager
Tonerboss.com



Nathan Campbell wrote: 

---------------------------------------------------------------------
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
Reply all
Reply to author
Forward
0 new messages