Move existing OTRS mysql DB in a separate server

[hfstef]

Hi all,

We have OTRS 3.1.11 running smoothly for the past 2 months. The database running is mysql.
We have copied the database into a separate server which is clustered. However, once we change the database connection details via Config.pm, we restarted the otrs service (and then the httpd and mysqld) and we get a message that we should run the web installer again.

Why is that ? Did we forget to update the new db credentials in any files ?

I appreciate any feedback that can be given. Thank you!

[crythias]

There is not enough information to address your question. Probably there's another log (otrs.log?) indicating that there is no database connection. This is possibly because the clustering database isn't allowing connection from your otrs box/username

[hfstef]

Hello and thanks for the prompt response.

The database connection itself is fine and the OTRS server is granted with full privileges + IP allowed on the database server. The error we get as soon as we "service otrs restart" is "No initial inserts found! Error!"

It's the exact error as described here http://stackoverflow.com/questions/1447 ... or-in-otrs but the only difference in our case is that the database is not Oracle but MariaDB.

[crythias]

run bin/otrs.CheckDB.pl

it is looking for "SELECT * from valid"

This is a rudimentary test, to be sure, but if it can't find results from the "valid" table, it can reasonably be assumed that you're going to have lots of other issues because the data isn't there, plus it *needs* to have those entries in the table "valid".

If you don't trust it (you have to, though) you should try phpmyadmin or mysql workbench or command line and see for yourself.