Log inUsernamePassword
Log me on automatically each visit    
Register
Register
Log in to check your private messages
Log in to check your private messages
SMS Forum Index » SMS User Support

Post new topic   Reply to topic
otrs login denied
View previous topic :: View next topic  
Author Message
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Tue Dec 16, 2008 10:20 pm    Post subject: otrs login denied Reply with quote

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:Very HappyB::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?
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1753
Location: Greece

PostPosted: Wed Dec 17, 2008 6:39 am    Post subject: Reply with quote

Something is wrong with your mysql otrs database.
what's the output of
Code:
mysql
mysql> show grants for otrs@localhost;
?

Just for the record I just install otrs in a fresh SMS installation without any errors
I just had to restart apache after the installation manually, I'll fix that.

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Wed Dec 17, 2008 8:56 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1753
Location: Greece

PostPosted: Wed Dec 17, 2008 10:14 pm    Post subject: Reply with quote

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

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Wed Dec 17, 2008 11:22 pm    Post subject: Reply with quote

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.

?
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1753
Location: Greece

PostPosted: Thu Dec 18, 2008 6:19 am    Post subject: Reply with quote

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

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Thu Dec 18, 2008 4:13 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1753
Location: Greece

PostPosted: Thu Dec 18, 2008 8:22 pm    Post subject: Reply with quote

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

what's your /etc/hosts ?

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Thu Dec 18, 2008 9:15 pm    Post subject: Reply with quote

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

thanks for the help
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    SMS Forum Index » SMS User Support All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum

SMS - Superb! Mini Server Project © 2016
Powered by phpBB © 2001, 2002 phpBB Group
iCGstation v1.0 Template By Ray © 2003, 2004 iOptional