Problems with MySQL

Please doublecheck all passwords. Mostly people setup the system with a wrong password. In this case it is the easiest way to re-setup the system.

Check the database connection

To check the database connection use '~otrs/bin/CheckDB.pl'. Is the output "It looks Ok!", you don't have problems connecting to your database. If not, read the error message.

Access denied for user: 'otrs@localhost'

Check the password for the database user in Kernel/Config.pm. If you don't know the database password for the database otrs user (any more), set it new:
shell> mysql -u root -p
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 37 to server version: 3.23.48-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT ALL PRIVILEGES ON otrs.* TO otrs@localhost IDENTIFIED BY "yourpw" WITH GRANT OPTION;
mysql> 
Reload the grant tables of your mysql-daemon:
$shell> mysqladmin -u root -p reload
(or restart your mysql-daemon) and change the new otrs password in Kernel/Config.pm.

Note: If you use mod_perl, restart the webserver, because mod_perl is reading the perlcode (incl. Kernel/Config.pm) on startup.

Lost root password of MySQL

Follow: http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.html#Resetting_permissions

http://localhost/otrs/installer.pl

If you want to set up the otrs database again, you can call the setup program by browsing to http://localhost/otrs/installer.pl.

Note: Just for SuSE Linux RPMs.