Issue with running Cacti no longer graphing.

[EdwardQ]

My cacti install is no longer graphing.. It was around the time that I looked at the cacti log and it crashed php and www..

Window 2003, Cacti 0.8.6j, Rddtool 1.2

The cmdphp window shows,

Code: Select all

8/31/2007 11:20:10 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update c:Inetpubwwwrootcacti
raapc_detriot_2200xl__mgc_apc_in_freq_213.rrd --template mgc_apc_in_freq N:60
ERROR: opening 'c:Inetpubwwwrootcacti
raapc_detriot_2200xl__mgc_apc_in_freq_213.rrd': No such file or directory
08/31/2007 11:20:10 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update c:Inetpubwwwrootcacti
raapc_detriot_2200xl__lit_apc_volt_min_212.rrd --template Lit_APC_Volt_Min N:210
ERROR: opening 'c:Inetpubwwwrootcacti
raapc_detriot_2200xl__lit_apc_volt_min_212.rrd': No such file or directory
08/31/2007 11:20:10 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update c:Inetpubwwwrootcacti
raapc_detriot_2200xl__lit_apc_volt_max_211.rrd --template Lit_APC_Volt_Max N:213
ERROR: opening 'c:Inetpubwwwrootcacti
raapc_detriot_2200xl__lit_apc_volt_max_211.rrd': No such file or directory
08/31/2007 11:20:10 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update c:Inetpubwwwrootcacti
raapc_detriot_2200xl__lit_apc_volt_curren_210.rrd --template Lit_APC_Volt_Curren N:213
ERROR: opening 'c:Inetpubwwwrootcacti
raapc_detriot_2200xl__lit_apc_volt_curren_210.rrd': No such file or directory
08/31/2007 11:20:10 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update c:Inetpubwwwrootcacti
raapc_detriot_2200xl__lit_apc_error_code_209.rrd --template Lit_APC_Error_Code N:9
ERROR: opening 'c:Inetpubwwwrootcacti

Every one of those rrd files are in the rrd directory.. If I remove the rrd file they are recreated.

When I go to the Graph management for any of the graphics RDDTOOL say ok. I have checked the permissions any they are still set as stated in the install doc.

Any help appeactied.


*edit* Put a more readable error up.

[BSOD2600]

read http://forums.cacti.net/viewtopic.php?t=11747 yet ?

[EdwardQ]

I ran thought that serveral times. I dont see anything that matches my errors.

The thing I noticed about the error message is that there is no '/' in the directory name. How they become missing?

If I do a select statement I get the '/'

Code: Select all

mysql> select name,data_source_path from data_template_data where local_data_id=103;
   
+-----------------------------------------------+-------------------------------------------------------+
| name                                          | data_source_path
                        |
+-----------------------------------------------+-------------------------------------------------------+
| |host_description| - Traffic - |query_ifName| | <path_rra>/detroit_switch_3750g_24_traffic_in_103.rrd |
+-----------------------------------------------+-------------------------------------------------------+
1 row in set (0.00 sec)

But the Graph Management shows it correctally.

[BSOD2600]

So you've went through http://docs.cacti.net/node/283 entirely?

[EdwardQ]

1. No timeouts.

2. snmpget -c MaharSNMP -v 1c 10.4.1.203 .1.3.6.1.4.1.318.1.1.1.3.2.1.0


C:\Inetpub\wwwroot\cacti>snmpget -c MaharSNMP -v 1 10.4.1.203 .1.3.6.1.4.1.318.1.1.1.3.2.1.0
Cannot find module (NOTIFICATION-LOG-MIB): At line 1 in (none)
Cannot find module (NET-SNMP-AGENT-MIB): At line 1 in (none)
Cannot find module (DISMAN-EVENT-MIB): At line 1 in (none)
SNMPv2-SMI::enterprises.318.1.1.1.3.2.1.0 = Gauge32: 213


3. php -q cmd.php 28 28
See Attach file.. (I see data returning).


I see a error
ERROR: SQL Assoc Failed "select poller_reindex.data_query_id, poller_reindex.action, poller_reindex.op, poller_reindex.assert_value, poller_reindex.arg1 from poller_reindex where poller_reindex.host_id=28"

When I run the sql cmd I get.
ERROR 1017 (HY000): Can't find file: 'poller_reindex' (errno: 2)


-- Dropped table and recreated. Error doesnt show now.. Get Empty set now.




4. mysql> insert into poller_output (local_data_id,rrd_name,time,output) values (21
0,'Lit_APC_Volt_Curren','2007-08-31 16:04:36','213');
Query OK, 1 row affected (0.00 sec)

mysql>




5. As stated before. the rrdtool update cmd is missing the '/'
c:/rrdtool/rrdtool.exe update c:Inetpubwwwrootcacti raapc_detriot_2200xl__lit_apc_volt_curren_210.rrd --template Lit_APC_Volt_Curren N:213


if I add the '/' in with the missing 'r' is rra It works.

c:/rrdtool/rrdtool.exe update c:/Inetpub/wwwroot/cacti/rra/apc_detriot_2200xl__lit_apc_volt_curren_210.rrd --template Lit_APC_Volt_Curren N:213

The poller cache has the '/' missing too.
Data Source: APC Detriot 2200XL - Lit _APC_Volt_Current_AC_Line
RRD: c:Inetpubwwwrootcacti raapc_detriot_2200xl__lit_apc_volt_curren_210.rrd
Action: 0, OID: .1.3.6.1.4.1.318.1.1.1.3.2.1.0 (Host: 10.4.1.203, Community: MaharSNMP)



How do I correct this error? This where I think the error is.. How do I correct the '/'?

[BSOD2600]

Hmm, odd the slashes are getting stripped out.

Got all patches installed for cacti?
What version of php you using?
How was it installed, and are you sure you've made the needed corrections in php.ini per my installation guide?

[EdwardQ]

Sorry, Thought I put that info up.

php: PHP Version 5.1.4

Cacti 0.8.6h when it stopped, patched to 0.8.6j to see if it would fix it.


I installed it almost 1 1/2 years ago per your instuctions. It was running find until I looked at the log file and it crashed my php and inetinfo processes.

[BSOD2600]

Did you install the patches for cacti 0.8.6j too?

What about updating php to 5.2.x? An IIS crash shouldn't cause those paths to loose their slashes though. I'm guessing a restart of IIS didn't fix it.

Is your cacti log file larger than 2GB per chance?

[EdwardQ]

I used the prepatch files (4 of them) to upgrade to 0.8.6j.

I been clearing the log file since it stopped reporting..


Thinking that something it corrupted in the upgrade. I deleted the cacti folder and reinstalled 0.8.6j per your page. I still was getting the same problem.

I created a test device and notice that the 't' in test and one of the 'r' in rra was missing in the rrd file name. As we know a \t is tab and \r is carrige return.

So following the differant functions to recreate the poller cache I got into the function api_poller_cache_item_add() in api_poller.php file. After some print varible testing I saw that the addslashes() php funcition was not adding slashes to the slashes. I removed the calls to addslashes() and clean_up_path() in the sql statement.. It seems to be working now.