perfSONAR User Q&A and Other Discussion

[Zhi-Wei Lu <>]

Hi Jason,

I went back to the source rpm and perfSONAR_PS-Toolkit-3.3.1.1.tar.gz 
introduces extra plugin_hooks tables (and other tables) while 
perfSONAR_PS-Toolkit-3.3.1.tar.gz didn't have those tables!


On 04/10/2014 11:24 PM, Zhi-Wei Lu wrote:
> 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