Graph Management - No Data Sources to Choose From

[rony]

Any hints from the Apache error log when you try to access that page?

[fmangeant]

Hi Fred

did you update to PHP 5.1.4-pl4-gento and MySQL 4.1.21 ?

Cause I can't reproduice the problem since...

[Fred]

Any hints from the Apache error log when you try to access that page?

Nothing in the error log.

So, I'm getting the impression that you believe the database is in a consistent state, but it's the interface or business layer that's not working correctly? That's good news.

I'll see if I can figure out anything more.

[rony]

Did you run a check/repair on your database? What was the results?

I don't know, but I was unable to reproduce your issue with my development environment and your database.

Are you running any plugins or addons?

[Fred]

Did you run a check/repair on your database? What was the results?

The check did not appear reveal any errors in the database, but I ran the repair anyhow. Everything returned "OK".

I don't know, but I was unable to reproduce your issue with my development environment and your database.

Which bodes well for my database and makes me very happy. So, you're able to edit a graph from graph management and the data sources show up?

Are you running any plugins or addons?

I've added many templates as well as custom polling scripts, but no plugin architecture or other add-ons.

I updated to the latest mysql ebuild (4.1.21), and even updated php to 5.1.4, and there's no difference. I installed cacti from source and connected it to the same database, and same problem. Must be something about one of the other libraries...

Thanks for your help Tony. I'll let you know if I can figure it out.

[rony]

Can you email me the HTML source of the broken page?

Also, anyway I can get access to the system?

[Fred]

The email has been sent.

Unfortunately, there's is no way I can get you access to the system without jumping through all sorts of paperwork and approval hoops.

I'm very strong with Linux, pretty strong with MySQL, and a decent beginner at PHP, so let me know if there's anything you'd like me to run. I'm about to dig into the code myself to see if I can figure out where it's failing.

Update: I have a different system that's experiencing the same problem that you can have access to. I've sent you logon information.

[rony]

Ok, got the source, nothing wrong, other than the missing items...

I need think about this issue some more.

[Fred]

SOLVED!

Rony spent some time on my system last night and figured out the issue. This stems from a change in MySQL's default character encoding. Around the time of 8.6h's release, the Gentoo mysql maintainers changed the default character encoding in MySQL from latin1 to UTF8. This causes problems, specifically related to blanks being incorrectly returned as nulls. Rony had a more detailed explanation, but I imagine you're more interested in the fix.

The easiest way to do it is to export the database, change the character encoding in the dump, and then reimport it. It's surprisingly simple:

1) Dump your cacti database: "mysqldump -u root -p<password> cacti > cacti.sql"
2) Edit that cacti.sql file to replace all occurrences of "latin1" with "utf8".
3) Reload your database with the corrected encoding: "mysql -u root -p<password> cacti < cacti.sql"

This fixed the problem on two of my machines that were running cacti. Alternatively, you might be able to fix the problem by changing the encoding in /etc/mysql/my.cnf back to latin1, but I have not tested that.

Whatever you do, be sure to back up all your databases first.

Thanks again, Rony.

[rony]

Gentoo maintainer is getting an email from me today.

[jjhuff]

Fixed for me too!
Now that I see that it was the charset change, I realize that I should have checked that. I got bit by the change on my bugzilla install...

Anway, thanks rony, fred, and every one else!!