[SMS]

[baboo]

I installed lms and otrs. The lms install and config went without any issues. The otrs install appears to go without problem but when trying to access web index the following message appears:

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: Tue Dec 16 20:19:30 2008

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

Traceback (6600):
Module: Kernel::System:B::new (v1.95) Line: 190
Module: Kernel::System::Web::InterfaceAgent::Run (v1.35) Line: 143
Module: /opt/otrs/bin/cgi-bin/index.pl (v1.87) Line: 47



any suggestions?

[gerasimos_h]

Something is wrong with your mysql otrs database.
what's the output of

[baboo]

mysql> show grants for otrs@localhost;
+-------------------------------------------------------------------------------------------------------------+
| Grants for otrs@localhost |
+-------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'otrs'@'localhost' IDENTIFIED BY PASSWORD '*2E7CA63422DD05ECDBBAA7C2CCEAD1C69492F7B6' |
| GRANT ALL PRIVILEGES ON `otrs`.* TO 'otrs'@'localhost' WITH GRANT OPTION |
+-------------------------------------------------------------------------------------------------------------+
2 rows in set (0.01 sec)


thanks

[gerasimos_h]

So it's working?
The query is right..

gerasimos_h

[baboo]

I get the same error message when accessing 192.168.0.90//otrs/index.pl.

If I try just 192.168.0.90/otrs, I get FORBIDDEN ACCES.

?

[gerasimos_h]

Try to access http://sms/otrs-web/
But since you getting reject from mysql for user otrs, you must flush otrs user and recreate him or flush all and reinstall the package.

gerasimos_h

[baboo]

thanks for the reply. I removed database and flushed all, uninstalled otrs. I then reinstalled otrs and still get the same error message.

I did notice that when I restart apache I get the following messages:

/etc/rc.d/rc.httpd restart
[Thu Dec 18 14:07:16 2008] [warn] module perl_module is already loaded, skipping
[Thu Dec 18 14:07:16 2008] [warn] The ScriptAlias directive in /etc/httpd/otrs.conf at line 6 will probably never match because it overlaps an earlier ScriptAlias.
[Thu Dec 18 14:07:16 2008] [warn] The Alias directive in /etc/httpd/otrs.conf at line 7 will probably never match because it overlaps an earlier Alias.
[Thu Dec 18 14:07:16 2008] [warn] The ScriptAlias directive in /etc/httpd/otrs.conf at line 6 will probably never match because it overlaps an earlier ScriptAlias.
[Thu Dec 18 14:07:16 2008] [warn] The Alias directive in /etc/httpd/otrs.conf at line 7 will probably never match because it overlaps an earlier Alias.

That doesn't seem to be important.

any other suggestions?

[gerasimos_h]

Installing the package twice duplicates otrs include conf remove it from httpd.conf.

what's your /etc/hosts ?

gerasimos_h

[baboo]

Sorry, started a reinstall before I received your reply. Will let you know what happens

thanks for the help