[solved] Error when Querying data or viewing graphs

[jadus]

I'm getting an unusual error after migrating my Cacti install to a new server.
I used PHPmyadmin to export the database, and then used the Windows Installer to install Cacti on the new server (Windows Server 2003). I re-imported the database and copied over the RRA's and plugins.

It appears like Cacti is working properly, in that graphs display and correct values are being shown, including for my Weathermap.

However, when trying to add new data sources, or even new graphs using the "SNMP - Interface Statistics" under "Associated Data Queries", I get many errors in the log. These error occur when I either view a graph, or click "reload data query":

Code: Select all

01/22/2009 11:29:09 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select snmp_index from host_snmp_cache where host_id=6 and snmp_query_id=1 group by snmp_index"
01/22/2009 11:29:09 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select snmp_index from host_snmp_cache where host_id=6 and snmp_query_id=1"
01/22/2009 11:29:09 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select snmp_index from host_snmp_cache where host_id=6 and snmp_query_id=9 group by snmp_index" 

When I debug the data source of the existing "SNMP - Interface statistics" there are no errors and everything looks fine, however the "reload Data query" still returns no results and adds those errors to the log.

I have made sure file permissions are correct. I have tried running the repair_database.php file, and rebuilding the poller cache.

Any suggestions?

[BSOD2600]

The technical support page show everything is ok? sounds like the database might need repair.

[jadus]

The technical support page lists all the tables in the database as "OK", and nothing else seems out of the ordinary.

I had already run the repair_database.php file.

[BSOD2600]

Try clearing the poller/snmp caches, since thats what its complaining about.

[jadus]

What is supposed to happen if the rebuild of the cache works correctly?

When I view the Poller cache within Cacti, there's 129 items, and the SNMP cache is empty.

After running "php rebuild_poller_cache.php", and then viewing the poller cache in Cacti again, there's still the same 129 items.

Perhaps it's not clearing properly?

[jadus]

I think I figured it out. When I had copied the database to the new server, somehow the host_snmp_cache table didn't get copied.

I added it in from the cacti.sql file and now everything seems to be working.