perfSONAR User Q&A and Other Discussion

[Zhi-Wei Lu <>]

Hi Jason,

The upgrade script didn't work, it gave many warning messages, and it says 
that your cacti is already up to date.

PHP Warning:  date(): It is not safe to rely on the system's timezone 
settings. You are *required* to use the date.timezone settin\
g or the date_default_timezone_set() function. In case you used any of those 
methods and you are still getting this warning, you m\
ost likely misspelled the timezone identifier. We selected 
'America/Los_Angeles' for 'PDT/-7.0/DST' instead in /opt/perfsonar_ps/t\
oolkit/web/root/admin/cacti/lib/functions.php on line 486

Your Cacti is already up to date.

We might have to manually adding those missing tables in, but the existing 
tables could be altered as well.


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

-----Original Message-----
From: Jason Zurawski 
[mailto:]
 
Sent: Friday, April 11, 2014 6:40 AM
To: Zhi-Wei Lu; Kevin Kawaguchi
Cc: 

Subject: Re: [perfsonar-user] cacti failed on 
perl-perfSONAR_PS-Toolkit-3.3.2-13.psPS

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