problems after upgrading to php 5.0.5

[Jeppe]

Upgraded to php 5.0.5 - can't see graphs or data sources anymore.
If I click eg. data sources, I get a header "Showing Rows 1 to 30 of 39 [1,2]"
but then the list is empty with only "No Data Sources".
Same thing for graphs. both on the console and graph view. Everything else seems to work.

-J

[TheWitness]

Interesting, what happens when you goto "Graph Management", select a Graph and Hit the Debug link?

TheWitness

[Jeppe]

Well, not much really since I can't see any graphs there either.
Only 'showing rows 1 to 30' and then 'no graphs found'.

Of course I've done some other upgrades without visiting cacti so I can't be sure if it's PHP 505 but that's the most logical thing anyway..

-J

[Jeppe]

Well, this turned out to be MySQL 5.0.12 actually.

There's a bug in 5.0.12 regarding joins and it's fixed in 5.0.13.

Sorry about the trouble.

[rony]

No worries, good info to know.

[knyaz]

hm, i have similar problem:

If I click eg. data sources, I get a header "Showing Rows 1 to 30 of 39 [1,2]"
but then the list is empty with only "No Data Sources".
Same thing for graphs

as described by Jeppe
This remains even after uprgade from MySQL 5.0.12 to MySQL 5.0.13 and dropping & creating cacti database.

Code: Select all

[localhost]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12 to server version: 5.0.13-rc-standard-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use cacti;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select
    ->                 graph_templates_graph.id,
    ->                 graph_templates_graph.local_graph_id,
    ->                 graph_templates_graph.height,
    ->                 graph_templates_graph.width,
    ->                 graph_templates_graph.title_cache,
    ->                 graph_templates.name,
    ->                 graph_local.host_id
    ->                 from graph_local,graph_templates_graph
    ->                 left join graph_templates on graph_local.graph_template_id=graph_templates.id
    ->                 where graph_local.id=graph_templates_graph.local_graph_id
    ->                 and graph_templates_graph.title_cache like '%%%%'
    ->                 order by graph_templates_graph.title_cache,graph_local.host_id
    ->                 limit 0,30;
ERROR 1054 (42S22): Unknown column 'graph_local.graph_template_id' in 'on clause'
mysql> describe graph_local;
+-------------------+-----------------------+------+-----+---------+----------------+
| Field             | Type                  | Null | Key | Default | Extra          |
+-------------------+-----------------------+------+-----+---------+----------------+
| id                | mediumint(8) unsigned | NO   | PRI | NULL    | auto_increment |
| graph_template_id | mediumint(8) unsigned | NO   | MUL | 0       |                |
| host_id           | mediumint(8) unsigned | NO   | MUL | 0       |                |
| snmp_query_id     | mediumint(8)          | NO   |     | 0       |                |
| snmp_index        | varchar(100)          | NO   | MUL |         |                |
+-------------------+-----------------------+------+-----+---------+----------------+
5 rows in set (0.04 sec)

how can i fix this?

[rony]

We are currently not supporting mySQL 5.0, as it's not a full release.

When it is, we will have a patch or release to support it.

[rkramer]

oops, should have read this thread 30 minutes ago! I have mysql 5.0.13-rc freshly installed and see the same issue. If you bypass the security in graph_image.php you can see the graphs if you go to them directly, but I still have the problem of it not showing up everywhere else.

btw, mysql5 seems FAST! a noticeable difference at least for polling and just moving around the system) I'm going to dig around a little more to figure out an easy way to at least remove enough of the security checks to get it operational again, I don't really want to go down in mysql versions. I'll post what else I find here.

[rony]

The fix is simple... Check out the bug database..