Problems with Host MIB - Available Disk Space (0.8.6)

[tapufd]

I'm trying the new 0.8.6 and have the following problem :
- add a new windows host (under devices) --> is OK
- searching for the following items on the windows host :
* SNMP - Get Mounted Partitions --> all found --> OK
* SNMP - Get Processor Information --> all found --> OK
* SNMP - Interface Statistics --> all found --> OK
- Following Graph Templates are selected :
* Host MIB - Available Disk Space
* Host MIB - CPU Utilization
* Interface - Traffic (bits/sec)
- click on 'Create Graphs for this Host'
- on this page I see all avialable items from the host
- creating graphs for cpus --> OK
creating graphs for interfaces --> OK
creating graphs for Mounted Partitions --> NOT OK
- the data sources and graph for the volumes are created, but are created as follow : SERVERNAME - Used Space - |query_hrStorageDescr|.
|query_hrStorageDescr| is not replaced with the volume name, and when opening the data sources I see that :
* the Data Source Path is NOT always filled in
* Index Type = Data query data sources must be created through New Graphs.
* Index Value is OK
* Output Type ID = Data query data sources must be created through New Graphs.
* the rrd's are also NOT created

Have tried several servers, and it's the same for all. Have also seen that always a general data source and graph is created, pointing to nothing. I mean like this :
SERVERNAME - Used Space - C -> OK
SERVERNAME - Used Space - D -> OK
SERVERNAME - Used Space - E -> OK
SERVERNAME - Available Disk Space -> why is this added?
This is for all data sources, so also for cpu, interfaces, netware cpu/volume, ... . (saw that this was also the case for 0.8.5a)

If you don't understand what I mean, I can always put some screenshots if you want?!

Thanks.

[raX]

Can you reproduce this same behavior on a fresh database (from cacti.sql) in the latest pre-release build? Creating the get mounted partitions graphs seemed to work fine for me.

Is it possible that your 'data_local' table is corrupt? Try running the following SQL just to be sure:

[tapufd]

Hi, as you asked :
D:\MySQL\bin>mysql --user=root --password cacti086
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.0.20a-nt

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

mysql> check table data_local;
+---------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+---------------------+-------+----------+----------+
| cacti086.data_local | check | status | OK |
+---------------------+-------+----------+----------+
1 row in set (0.11 sec)

mysql>


- All seems to be OK. If I open the table, I see data.
- This 0.8.6 was a fresh install from the release
cacti-0.8.6-pre20040901.zip. So it was not an update, but a new database from cacti.sql.
- If I open the table data_template_data, I see that name_cache & data_source_path are all filled in (name_cache for partitions has of course |query_hrStorageDescr| in it, but the rrd-filenames are all filled in).

Are there other things I can check for you? Many thanks for this excellent product and the quick reply.

[raX]

Lets do a little digging...

Go to "Data Sources" and hover over one of the bad data sources with the broken title. Take note of the "id" variable in the URL string.

Now open up a MySQL prompt and run the following SQL query:

[tapufd]

These are the results of ... :
the ids are 79 until 83, and all give the following :

[raX]

Little did I know, this problem is only reproducible on Windows! After a bit of digging through the code I did find the cause of the problem. I re-pushed the 20040903 pre-release if you want to give that a try.

-Ian

[tapufd]

Hi raX,

You solved the problem! THANKS!
Sorry for not mentioning my specs. Normally this is the first thing I do in a new post.
So : Windows XP (& 2003 Server); MySql 4.0.20D; php 5.01; cacti 0.8.6; net-snmp-5.1.2-1; rrdtool-1.0.4

Anyway, investigating in 0.8.6 a little deeper, I have found some other 'bugs', I think :

* On every graph-page I see the following text at the bottom :

PHP Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in D:\Cacti\Website086\include\html\inc_timespan_settings.php on line 42 PHP Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in D:\Cacti\Website086\include\html\inc_timespan_settings.php on line 54 PHP Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in D:\Cacti\Website086\include\html\inc_timespan_settings.php on line 114 PHP Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in D:\Cacti\Website086\include\html\inc_timespan_settings.php on line 121 PHP Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of set_preset_timespan(). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in D:\Cacti\Website086\include\html\inc_timespan_settings.php on line 239

When I open inc_timespan_settings.php and go to each line mentioned, I find "&$timespan". If you remove the "&" char, the messages disappear.

* Have also seen that always a general data source and graph is created, pointing to nothing. I mean like this :
SERVERNAME - Used Space - C -> OK
SERVERNAME - Used Space - D -> OK
SERVERNAME - Used Space - E -> OK
SERVERNAME - Available Disk Space -> why is this added?
This is for all data sources, so also for cpu, interfaces, netware cpu/volume, ... . (saw that this was also the case for 0.8.5a)

I have to delete then these data sources (+ graphs) everytime after creating/adding data sources, so that cacti is in a clean state.

Many thanks already, again, and again.

Greets,
/tap

[raX]