I have cacti working flawlessly on a centos 7.0 machine but I need it working on a centos 6.3 machine. I download the same version of cacti as what is on the 7.0 and I installed rrdtool from yum. After performing a successful base installation of cacti and confirm it works. I then copy over the database rsync /var/mysql/mydb and restart mysqld I see my data but ‘none of the charts appear’ and I get this error in my cacti.log
10/01/2014 04:12:31 AM - CMDPHP: Poller ERROR: SQL Row Failed!, Error:'1033', SQL:"select host.id, host.hostname, host.snmp_community, host.snmp_version, host.snmp_username, host.snmp_password, host.snmp_auth_protocol, host.snmp_priv_passphrase, host.snmp_priv_protocol, host.snmp_context, host.snmp_port, host.snmp_timeout, host.disabled from host where host.id=1"
since, I have upgraded MySQL to 5.4 and rddtool to 1.4.8 and tried a different cacti versions also. I have also tried every script in cli/ to repair the DB or bring it up to specs. Mysqlcheck say the database is just fine. Same error
How do I get my cacti charts to work?