MySQL Offload Errors

[mikew]

Trying to offload the database to another server and getting this error:

Here is the error that fills everything.
SQL: SQL Error [ndoutils]: Table 'nagiosql.nagios_programstatus' doesn't exist


Is there anything different with the latest version and MySQL...I have done this many times before.

Permissions on database are correct, can login remotely, user nagios on both mysql databases has all rights. Box connects but when you view individual hosts you get that error.

All settings are correct...looked at this 10 times.

ndo2db.cfg
config.in.php
settings.php

CentOS 6.3 64-bit
Nagios XI 2012R1.5b

[scottwilkerson]

we had another user with almost the exact same error, we eventually figured out that they were using the same mysql username for both database on the remote mysql machine, and once they switched to use a different username for each it worked.

I believe it is because it is autologging in the user into the wrong database....

as nagiosql.nagios_programstatus is referring to the nagiosql database and the nagios_programstatus table which isn't in that database...

[mikew]

Thanks...that sounds about right. I will update later today.

[scottwilkerson]

Thanks mike

[mikew]

Scott...that was the solution...I owe you dinner....next time I see you be sure to collect.

[yancy]

marking issue as resolved.

adding +1 to scottwilkerson dinner count.

-Yancy