perfSONAR User Q&A and Other Discussion

[Jason Zurawski <>]

Hey Zhi-Wei/Kevin;

From reading online documentation, version 0.8.8 of CACTI now includes the 
Plugin Architecture directly as you note.  It appears there is a database 
upgrade script that can be run to add the new tables.  I tried this on a 
local instance, but I didn't have any historical data:

> php /opt/perfsonar_ps/toolkit/web/root/admin/cacti/cli/upgrade_database.php 


I would recommend before trying this to make a mysql backup (note, below 
command may need a -u or -p option supplied, depending on what the 
permissions of the database are):

> mysqldump -l --add-drop-table cacti > mysql.cacti

Let us know if this works, and we can file a bug to improve our database 
upgrade scripts.  

Thanks;

-jason

On Apr 11, 2014, at 3:04 AM, Zhi-Wei Lu 
<>
 wrote:

> 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