perfSONAR User Q&A and Other Discussion

[Zhi-Wei Lu <>]

Hi Jason,

The mysql database for cacti is actually clean, I can query the database 
either as user "root" or "cacti", but the cacti database built from the 
previous version of perfSonar is incompatible with the current version.
table plugin_hooks along with many other tables required in the current 
version do not exist in the previous version.

On 04/10/2014 04:52 PM, Jason Zurawski wrote:
> Hey Zhi-Wei/Kevin;
>
> This is just a guess - but maybe mysql needs to have a repair done?  Some 
> forums I read on the cacti web site seem to indicate that is a good first 
> thing to try:
>
> > mysqlcheck -u aaa -p --auto-repair --optimize --all-databases
>
> Let us know if that has any positive impact;
>
> Thanks;
>
> -jason
>
> On Apr 10, 2014, at 7:25 PM, Zhi-Wei Lu 
> <>
>  wrote:
>
> > 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

--
Zhi-Wei Lu
IET-CR-Network Operations Center
University of California, Davis
(530) 752-0155