Upgrade odl threshold version to the lastest

kenny29 · Post by **kenny29** » Fri Mar 06, 2009 8:14 am

Hi,

I have an old threshold version but i want upgrade it to threshold V0.4.1.
I have notice that the thold.sql in the new version has news fields (NOT NULL).

Is there a migration script or do i need to rebuild database and create again all thresholds ?

Post by **TheWitness** » Fri Mar 06, 2009 8:17 am

Check for the "upgrade.php" script located in the extra's folder.

TheWitness

kenny29 · Post by **kenny29** » Fri Mar 06, 2009 11:25 am

Ho thx !

But do I don't understand very well how to do this. Do I need to paste the new direcrory version instead of the current Thold directory, end then run the file upgrade.php in command line?

Post by **TheWitness** » Fri Mar 06, 2009 1:10 pm

Ok confused now. It's an upgrade script. You run it.

TheWitness

kenny29 · Post by **kenny29** » Wed Mar 11, 2009 4:29 am

Does Thold-0.4.1 can work with cacti-0.8.7b ? Because I have upgrade correctly thold but thold tab doesn't appear any more on Cacti Web page.

$plugins[] = 'thold'; is uncommented on global.php and config.php

Post by **TheWitness** » Thu Mar 12, 2009 7:03 pm

Well, config.php should have only database information. Also, I would suspect that it would work just fine. You will have to paste from your apache log the errors. You must have PIA 2.x though and the PA.SQL sourced.

TheWitness

kenny29 · Post by **kenny29** » Fri Mar 13, 2009 3:13 am

I have installed PA v2.1 for Cacti 0.8.7b. When I look my apache2 error.log or cacti.log, there are no errors in relation with Thold.

kenny29 · Post by **kenny29** » Fri Mar 13, 2009 3:38 am

Well... I don't understand why my pa.sql wasn't in database cacti -_-. So I push table in Cacti database and NOW I have "Plugins Management". Thold is well installed.

Now, when I want to add a threshold template I have this error :

Error: A template with that Data Source already exists!

I have purge thold_template table in database but it doesn't change anything.

Is there a solution to solve that problem ?

Thanks.

Post by **TheWitness** » Fri Mar 13, 2009 8:08 pm

In the told directory, there is an "upgrade.php" script. Run it. Do not uninstall the plugin, or you will loose all of your data. It's nasty that way (the PIA that is).

TheWitness

kenny29 · Post by **kenny29** » Thu Mar 19, 2009 2:47 am

Hi Witness,

Yes but that 's I have done. I have just deleted the old thold directory. Then I have passed the new thold directory (v0.4.1) without change anything in database and I haven't touched Thold in plugin management. I run the upgrad.php script and upgrade was successful.

When I look my database I can see the thold tables were updated and all the data are there. But Thold in cacti doesn't see any data (No Thresholds).

I have tried the uprgade process for this post http://forums.cacti.net/viewtopic.php?t=31726
So I had the same mysql error and your solution solved it. But it doesn't change anything for me.... no threshold appears...

If I had a new threshold, Cacti return "Record Saved" but it isn't diplayed on threshold list.

On thershold template, cacti found a template but the diplay parameters for this template are wrong. Before the upgrade, it was a template base on baseline and now it's a template base on High / Low values... and if I try to change the type and save next, I have this error "Error : Save Failed"

I don't know what to do

Post by **TheWitness** » Thu Mar 19, 2009 7:00 am

Post the output of your dump command. It should be pretty small. Also, for my benefit, also post the thold*.sql from the plugin directory.

TheWitness

kenny29 · Post by **kenny29** » Thu Mar 19, 2009 8:34 am

For my dump command I hace dumped all the thold tables (plugin_thold_contacts plugin_thold_template_contact plugin_thold_threshold_contact thold_data thold_template). So in the destination file I have all tables, their values and parameters but it's not pretty small.

I have add the thold.sql (thold.txt) from thold dir and then the file dump result (mycurr_thold.txt).

kenny29 · Post by **kenny29** » Thu Mar 19, 2009 10:23 am

I have made a mysqldump of thold_data table and I have uninstall thold 0.4.1, so all tables were removed from database and for finish I removed the thold directory. After I make a basic install of thold 0.4.1 (without upgrade).

Now I can create template but an error appear when I want create a template using "Baseline". Indead if therse is no value for "Baseline deviation DOWN" cacti return this error :

Notice: Undefined index: bl_pct_down in /var/www/cacti/plugins/thold/thold_functions.php on line 404

Warning: Cannot modify header information - headers already sent by (output started at /var/www/cacti/plugins/thold/thold_functions.php:404) in /var/www/cacti/plugins/thold/thold_templates.php on line 353.

Perhaps you have a solution to solved that problem because normally you can leave the field blank.... I don't need baseline-LOW.

Then I did a mysqldump of thold_data table and all threshold are displayed on the console menu now. I don't understand why threshold are not diplayed on Thold tab on the other hand. When filter is empty nothing appears but when a put just a letter, all threshold containing this letter in their name are diplayed....

I have an other issue which is the double poller issue. I take a look from here http://docs.cacti.net/manual:087:4_help ... #debugging but I have on cron file (/etc/cron.d/cacti) with " */1 * * * * cacti /usr/bin/php /var/www/cacti/poller.php > /tmp/cacti.log " and nothing in crontab. When I enable threshold the second cacti poller process appears and after there is grabs on my graphs and the cacti log error " PM - SPINE: Poller[0] ERROR: Spine Timed Out While Processing Hosts Internal ".
If I disable threshold, second process poller disappears and all becomes again normal.

I must solve this problem quickly because I must put my cacti server in production soon.

Why cacti hates me

?!!!

cigamit · Post by **cigamit** » Mon Mar 23, 2009 1:35 pm

Is your MySQL running in strict mode?

kenny29 · Post by **kenny29** » Wed Mar 25, 2009 3:36 am

Hmmmm where can I see that ? I'm on a 5.0.32-Debian_7etch8.
In my conf file my.cnf there isn't a "mode" option.

Upgrade odl threshold version to the lastest

Upgrade odl threshold version to the lastest

Who is online