[SOLVED] Cacti 0.8.7i mysql database on remote machine

[levi]

Hi guys,
I am planning to migrate my current cacti 0.8.7g to 0.8.7.i but i wanted to make some tests in testbed before actual upgrade.
I've installed new centos 6.2 on virtual machine and followed install guides from here and it worked just fine.
After I've tried to move database to other virtual machine, like it is in my production server and here I've got troubles it is showing:

Code: Select all

FATAL: Cannot connect to MySQL server on '10.5.2.44'. Please make sure you have specified a valid MySQL database name in 'include/config.php'

And at the same time (witn same config file) the "php cli/analyze_database.php" shows:

Code: Select all

[root@nss-www cacti]# php cli/analyze_database.php
Analyzing All Cacti Database Tables
Analyzing Table -> 'cdef' Successful
Analyzing Table -> 'cdef_items' Successful
Analyzing Table -> 'colors' Successful
Analyzing Table -> 'data_input' Successful
Analyzing Table -> 'data_input_data' Successful
Analyzing Table -> 'data_input_fields' Successful
Analyzing Table -> 'data_local' Successful
Analyzing Table -> 'data_template' Successful
Analyzing Table -> 'data_template_data' Successful
Analyzing Table -> 'data_template_data_rra' Successful
Analyzing Table -> 'data_template_rrd' Successful
Analyzing Table -> 'graph_local' Successful
Analyzing Table -> 'graph_template_input' Successful
Analyzing Table -> 'graph_template_input_defs' Successful
Analyzing Table -> 'graph_templates' Successful
Analyzing Table -> 'graph_templates_gprint' Successful
Analyzing Table -> 'graph_templates_graph' Successful
Analyzing Table -> 'graph_templates_item' Successful
Analyzing Table -> 'graph_tree' Successful
Analyzing Table -> 'graph_tree_items' Successful
Analyzing Table -> 'host' Successful
Analyzing Table -> 'host_graph' Successful
Analyzing Table -> 'host_snmp_cache' Successful
Analyzing Table -> 'host_snmp_query' Successful
Analyzing Table -> 'host_template' Successful
Analyzing Table -> 'host_template_graph' Successful
Analyzing Table -> 'host_template_snmp_query' Successful
Analyzing Table -> 'plugin_config' Successful
Analyzing Table -> 'plugin_db_changes' Successful
Analyzing Table -> 'plugin_hooks' Successful
Analyzing Table -> 'plugin_realms' Successful
Analyzing Table -> 'poller' Successful
Analyzing Table -> 'poller_command' Successful
Analyzing Table -> 'poller_item' Successful
Analyzing Table -> 'poller_output' Successful
Analyzing Table -> 'poller_reindex' Successful
Analyzing Table -> 'poller_time' Successful
Analyzing Table -> 'rra' Successful
Analyzing Table -> 'rra_cf' Successful
Analyzing Table -> 'settings' Successful
Analyzing Table -> 'settings_graphs' Successful
Analyzing Table -> 'settings_tree' Successful
Analyzing Table -> 'snmp_query' Successful
Analyzing Table -> 'snmp_query_graph' Successful
Analyzing Table -> 'snmp_query_graph_rrd' Successful
Analyzing Table -> 'snmp_query_graph_rrd_sv' Successful
Analyzing Table -> 'snmp_query_graph_sv' Successful
Analyzing Table -> 'user_auth' Successful
Analyzing Table -> 'user_auth_perms' Successful
Analyzing Table -> 'user_auth_realm' Successful
Analyzing Table -> 'user_log' Successful
Analyzing Table -> 'version' Successful

Please have a look what could be done wrong?

P.S.
I apologize if there is already similar report available, but i was not allowed to search words mysql and server

Thank You.

[gandalf]

Please clarify: was this error thrown on 087i?
R.

[levi]

Please clarify: was this error thrown on 087i?
R.

Error was displayed in web browser when i was trying to open the cacti in testbed (version 0.8.7i) immediately after changing address of mysql server pointing to the remote host.

Thank You.

[levi]

Hi,

Am i only one who uses MYSQL on different host? Does anyone have similar error?

Thank You.

[gandalf]

Hi,

Am i only one who uses MYSQL on different host? Does anyone have similar error?

Thank You.

No, you're not. This is used quite seldom. But there are no known limitations/problems; at least to my knowledge. And I'm still confused why cli works and online doesn't. Both are using the same config file.
And this is no "distro" code? 087i code was downloaded from cacti.net?
R.

[levi]

No, you're not. This is used quite seldom. But there are no known limitations/problems; at least to my knowledge. And I'm still confused why cli works and online doesn't. Both are using the same config file.
And this is no "distro" code? 087i code was downloaded from cacti.net?
R.

Yes right from here.

Tomorrow i will try version without PA maybe something will change...

[gandalf]

You did apply all mysql credentials to include/config.php, then?
R.

[levi]

You did apply all mysql credentials to include/config.php, then?
R.

I HATE SELinux!!!!!!
After disabling it everything works just great...
Sorry for disturbing....