perfSONAR User Q&A and Other Discussion

[Zhi-Wei Lu <>]

Hi all,

 

We recently update our system to the latest perfSonar version using “yum update” last week and rebooted system.   We noticed that today that our cacti environment failed since our last reboot.

 

There are tons of error message such as the following in the log file:

 

04/10/2014 03:02:37 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT 1 AS id, ph.name, ph.file, ph.function  FROM plugin_hooks AS ph  LEFT JOIN plugin_config AS pc  ON pc.directory=ph.name  WHERE ph.status = 1 AND hook = 'config_arrays'  AND ph.name IN ('settings', 'boost', 'dsstats')  UNION  SELECT pc.id, ph.name, ph.file, ph.function  FROM plugin_hooks AS ph  LEFT JOIN plugin_config AS pc  ON pc.directory=ph.name  WHERE ph.status = 1 AND hook = 'config_arrays'  AND ph.name NOT IN ('settings', 'boost', 'dsstats')  ORDER BY id ASC"

 

Upon investigating the issue, we noticed that

/opt/perfsonar_ps/toolkit/web/root/admin/cacti/cacti.sql

has all the definitions of the missing SQL tables, but our current /var/lib/mysql/cacti does not have the proper table.

 

Apparently, this current version if cacti is different from the previous version from the perfSonar packages, what is the proper way to upgrade the mysql cacti database to be consistent with the current version. We would like to keep our previous data if it is possible.

 

Thank you very much for your help.

 

Zhi-Wei Lu

IET-CR-Network Operations Center

University of California, Davis

(530) 752-0155