SOLVED No Data Sources shown but cmd.php is reporting 1041 D

[faser]

Hi All,

after an upgrade of an old system get a little bit wrong my cacti is behaving strange.

1. Cacti is not updated sofar, it is stil 0.8.6g
2. I updated php, mysql, apache

When I log into cati my graphs and Data Sources seems to be empty (nothing shown while actually they are showing plenty of items on the page counter (see attached picture).
And the strange part is that the logfile correctly shows all data sources and all rra's are updated correctly.

Any hints are welcome!

Cheers

Fred

03/11/2009 02:52:16 PM - SYSTEM STATS: Time:134.5037 Method:cmd.php Processes:1 Threads:N/A Hosts:116 HostsPerProcess:116 DataSources:1041 RRDsProcessed:663

[TheWitness]

Make sure that MySQL is not running in STRICT mode.

Code: Select all

mysql
show global variables like 'sql_mode';

Make sure it is unset. If it is, I hope you made a backup of your database. You may be ok, but only if you have not created more graphs.

Once you make the change in my.cnf, make sure that you restart mysql.

TheWitness

[faser]

Hi,

the result is empty what I assume means 'unset'.

mysql> show global variables like 'sql_mode';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| sql_mode | |
+---------------+-------+
1 row in set (0.00 sec)

One more hint, the MYSQL upgrade I made was from 4 to 5

Cheers

Fred

[faser]

Hi,

an Upgrade to 0.8.7b has solved the problem. Still strange what was wrong before?

Cheers

Fred

[TheWitness]

Yes, very odd.

TheWitness