I did grant full permission to the mysql db from query browser, it seems as though I am still getting the permission error when I try to access it, however I did notice that on trying to reboot mysql it would not reboot ie: rcmysql restart it shuts down with no problems but when it tries to start the MySQL service it fails any ideas on why or what to do at this point? thanks again!! On 7/26/05, Mark J. Nernberg wrote:

On Jul 26, 2005, at 11:51 AM, Chaden Hite wrote:

...

I am getting the following error when I try to access OTRS I am using MySQL as the backend DB, SUSE 9.1 for the OS, pointing to Active Directory for authentication access it seems like the user OTRS has lost access through my DB.... but I cannot seem to get it working

I have rebooted the server as well as the apache and otrs services several times any ideas?

here is the full 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.1 OS: linux Time: Tue Jul 26 09:14:59 2005

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

Traceback (1774): Module: Kernel::System::DB::new (v1.40) Line: 222 Module: Apache::ROOT::otrs::index_2epl::handler (v1.73) Line: 123 Module: (eval) (v2.01) Line: 149 Module: Apache::Registry::handler (v2.01) Line: 149

This is an SQL error.

Did you grant permissions on the SQL database (the one for OTRS)?

i.e.:

mysqladmin -u root -p 'grant all on otrs.* to otrs@localhost identified by "some password" '

SQL maintains its own authentication system.

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