Blank "MySQL Table Information"

[ssb]

Hi there, I just finished installing and patching cacti on a SLES 11 64bit machine and i'm having a couple of issues.

When I go to "Technical Support" I find that the "MySQL Table Information" section completely blank.

However, I was able to create a device in the web interface but polling fails and gives me the "ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT snmp_query.id, snmp_query.name, snmp_query.xml_path FROM (snmp_query,host_snmp_query) WHERE host_snmp_query.snmp_query_id=snmp_query.id AND host_snmp_query.host_id= ORDER BY snmp_query.name"" error in the logs.

When I fetch the device id manually from the web interface (12) and call the same query manually with the host_id populated I get the correct two rows returned, for me this confirms that the database is OK :

Code: Select all

+----+-------------------------------------+------------------------------------------------------+
| id | name                                | xml_path                                             |
+----+-------------------------------------+------------------------------------------------------+
|  1 | SNMP - Interface Statistics         | <path_cacti>/resource/snmp_queries/interface.xml     | 
|  2 | ucd/net -  Get Monitored Partitions | <path_cacti>/resource/snmp_queries/net-snmp_disk.xml | 
+----+-------------------------------------+------------------------------------------------------+

I already checked my snmp configuration on the remote machine using snmpwalk and I don't think that is the issue.

If I ignore the error and continue to make graphs then they contain NaN's which I think is expected.

Any help or advice would be greatly appreciated.

[TheWitness]

Sounds almost as if the database did not completely install. What happens if you simply source the sql file, do you get any warnings or errors? What about the MySQL version?

TheWitness

[ssb]

MySQL version :mysql Ver 14.12 Distrib 5.0.67, for suse-linux-gnu (x86_64) using readline 5.2.
php version : PHP 5.2.6 with Suhosin-Patch 0.9.6.2 (cli) (built: Feb 12 2010 15:26:33)

I re-installed everything and the problem went away....a bittersweet solution :/