RRD files not updated after MySQL 5.0.18 upgrade

[mshuttle]

Greetings,
I just upgraded my database server to MySQL 5.0.18 and now the poller is not updating the rrd files...
The graphs show up correctly they are not displaying the new data becuasue te rrd files are not update.

I'm using
Windows 2000 with version 0.8.6h of cacti, Php 5.1.2, RRdTool 1.0

I enabled logs debug and I got this error:

03/10/2006 06:32:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)"

Thanks in advance

[BSOD2600]

Ignore those SQL Assoc Failed errors.

Make sure you've installed the latest patches for cacti and don't have sql-strict mode enabled in mysql.

[mshuttle]

MySQL is not running in sql-strict mode. I installed all patches but the I didn't resolve the problem.

I'm still getting no RRD processed:

03/13/2006 10:39:40 AM - SYSTEM STATS: Time:59.6655 Method:cactid Processes:1 Threads:1 Hosts:22 HostsPerProcess:22 DataSources:217
RRDsProcessed:0

Regarding patches:
1) I download and patched under a Linux machine and finally copied the patched files in my Windows machine. I got errors during patching:

[root@smtp cacti-0.8.6h]# patch -p1 -N < fix_search_session_clear_issue.patch
patching file host.php
Hunk #1 FAILED at 726.
1 out of 1 hunk FAILED -- saving rejects to file host.php.rej
[root@smtp cacti-0.8.6h]# patch -p1 -N < fix_sql_syntax_related_to_default_rra_id.patch
patching file graph.php
Hunk #1 FAILED at 130.
1 out of 1 hunk FAILED -- saving rejects to file graph.php.rej
[root@smtp cacti-0.8.6h]# patch -p1 -N < nth_percentile_empty_return_set_issue.patch
patching file lib/graph_variables.php
Hunk #1 FAILED at 302.
Hunk #2 FAILED at 337.
Hunk #3 FAILED at 351.
Hunk #4 FAILED at 365.
4 out of 4 hunks FAILED -- saving rejects to file lib/graph_variables.php.rej
[root@smtp cacti-0.8.6h]# patch -p1 -N < mysql_5x_strict.patch
patching file cacti.sql
Hunk #1 FAILED at 1846.
1 out of 1 hunk FAILED -- saving rejects to file cacti.sql.rej
patching file lib/auth.php
Hunk #1 FAILED at 40.
1 out of 1 hunk FAILED -- saving rejects to file lib/auth.php.rej
patching file lib/database.php
Hunk #1 FAILED at 214.
1 out of 1 hunk FAILED -- saving rejects to file lib/database.php.rej
patching file lib/import.php
Hunk #1 FAILED at 341.
Hunk #2 FAILED at 419.
2 out of 2 hunks FAILED -- saving rejects to file lib/import.php.rej
patching file lib/template.php
Hunk #1 FAILED at 643.
1 out of 1 hunk FAILED -- saving rejects to file lib/template.php.rej
[root@smtp cacti-0.8.6h]#

2) I see that cacti.sql was also patched. Can I directly apply this SQL script my current cacti database without losing data ?

Thanks in advance

[BSOD2600]

Looks like all patching failed. Were you under the cygwin shell when patching? If so, try under the standard command prompt. Also could try using the premade patched files instead.

When you manually run php poller.php under an admin account, do the rrd files get updated?

[mshuttle]

Looks like all patching failed. Were you under the cygwin shell when patching? If so, try under the standard command prompt. Also could try using the premade patched files instead.

Ok, I used premade patched files. When I connected to cacti homepage, I get a database upgrade message. I did it and I completed the operations without errors but still the rrd files didn't get updated.

When you manually run php poller.php under an admin account, do the rrd files get updated?

Yes, I'm running php poller.php under administrator account, but the rrd files doesn't update...

[BSOD2600]

1) using the cygwin build of rrdtool instead of the win32 one?
2) proper rrdtool version / path selected in cacti?
3) turn the cacti polling logging level to debug and run it for a cycle and post the output.
4) you might want to run FileMon, like this thread suggest and see if you have any problems.

[mshuttle]

1) using the cygwin build of rrdtool instead of the win32 one?
2) proper rrdtool version / path selected in cacti?
3) turn the cacti polling logging level to debug and run it for a cycle and post the output.
4) you might want to run FileMon, like this thread suggest and see if you have any problems.

1) Yes, I tried each version
2) Yes, the path is correct. In the web interface I can see the graphs, but they are empy
3) Ok, I uploaded the log within this message
4) I already did it, but I don't see any file access in the /rra directory

[BSOD2600]

hmm, the lack of any cacti2rrd entries in your log file is troubling.

Try: mysql -u root -p cacti
>truncate table poller_output;
>quit

[mshuttle]

hmm, the lack of any cacti2rrd entries in your log file is troubling.

Try: mysql -u root -p cacti
>truncate table poller_output;
>quit

I tried the truncate table but RRD files are still not updating. I try also using Cactid instead of cmd.php but the situation didn't change.
I'm attaching the log with cactid

[BSOD2600]

Hmm, not sure exactly... think a dev will have to comment on this. Maybe the database upgrade didn't go smoothly.
Did you patch cacti 0.8.6h before or after updating the database?

[mshuttle]

I patched the database before upgrade to 0.8.6h.
Could be a problem of some tables ?

[mshuttle]

SOLVED!!!

I manually re-create the table pooler_output and importerd old data. The problem was a collation conflict with the default of database server.

Bye