[Solved] Problems with poller.php

[Chaucer]

I am having trouble getting my initial device working. I've gone through the FAQ and installation documentation here and on the net and I still havent been able to solve this. I'm sure it's just something I have overlooked.

Operating System: Windows 2003
Webserver: IIS 6
Cacti: 0.8.7b
MySQL: 5.0.51b
PHP: 5.2.6
RRDTool (Win32 version): 1.2.15
Net-SNMP: 5.4.1-3

When the poller.php runs, I am getting the following message in the command window:

Cannot find module (IP-MIB): At line 0 in (none)
Cannot find module (IF-MIB): At line 0 in (none)
Cannot find module (TCP-MIB): At line 0 in (none)
Cannot find module (UDP-MIB): At line 0 in (none)
Cannot find module (SNMPv2-MIB): At line 0 in (none)
Cannot find module (SNMPv2-SMI): At line 0 in (none)
Cannot find module (UCD-SNMP-MIB): At line 0 in (none)
Cannot find module (UCD-DEMO-MIB): At line 0 in (none)
Cannot find module (SNMP-TARGET-MIB): At line 0 in (none)
Cannot find module (SNMP-VIEW-BASED-ACM-MIB): At line 0 in (none)
Cannot find module (SNMP-COMMUNITY-MIB): At line 0 in (none)
Cannot find module (UCD-DLMOD-MIB): At line 0 in (none)
Cannot find module (SNMP-FRAMEWORK-MIB): At line 0 in (none)
Cannot find module (SNMP-MPD-MIB): At line 0 in (none)
Cannot find module (SNMP-USER-BASED-SM-MIB): At line 0 in (none)
Cannot find module (SNMP-NOTIFICATION-MIB): At line 0 in (none)
Cannot find module (SNMPv2-TM): At line 0 in (none)

At first glance I thought it was a problem with the Net-SNMP permissions but I have double check that and it is correct. The device that I added does show SNMP information when I go to Devices and click on my device.

Here is the info from the cacti.log file:


05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='logging_header'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='logging_header'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_destination'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_destination'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_snmp'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_snmp'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_graph'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_graph'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_export'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_export'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='poller_header'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='poller_header'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_verbosity'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_verbosity'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_pstats'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_pstats'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_pwarn'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_pwarn'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_perror'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_perror'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='versions_header'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='versions_header'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_version'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_version'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='rrdtool_version'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='rrdtool_version'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_header'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_header'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_ver'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_ver'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_community'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_community'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_username'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_username'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_password'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_password'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_auth_protocol'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_auth_protocol'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_priv_passphrase'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_priv_passphrase'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_priv_protocol'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_priv_protocol'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_timeout'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_timeout'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_port'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_port'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_retries'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_retries'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='other_header'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='other_header'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='remove_verification'"
05/31/2008 04:09:44 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='remove_verification'"
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item where rrd_next_step<=0"
05/31/2008 04:10:03 PM - POLLER: Poller[0] NOTE: Poller Int: '60', Scheduled Task Int: '60', Time Since Last: '396', Max Runtime '58', Poller Runs: '1'
05/31/2008 04:10:03 PM - POLLER: Poller[0] WARNING: Scheduled Task is out of sync with the Poller Interval! The Poller Interval is '60' seconds, with a maximum of a '300' second Scheduled Task, but 396 seconds have passed since the last poll!
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('poller_lastrun',1212268203)"
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','c:/Inetpub/wwwroot/cacti')"
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "TRUNCATE TABLE poller_time"
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT local_data_id, rrd_name FROM poller_output"
05/31/2008 04:10:03 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: C:/Inetpub/php/php.exe, ARGS: -q c:/inetpub/wwwroot/cacti/cmd.php 0 4]
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: " SELECT * FROM host WHERE (disabled = '' AND id >= 0 AND id <= 4) ORDER by id"
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM poller_item WHERE (host_id >= 0 AND host_id <= 4 AND rrd_next_step <= 0) ORDER by host_id"
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) FROM poller_item WHERE (action=2 AND host_id >= 0 AND host_id <= 4 AND rrd_next_step <= 0)"
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_next_step - 60 WHERE (host_id >= 0 AND host_id <= 4)"
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_step - 60 WHERE (rrd_next_step < 0 AND host_id >= 0 AND host_id <= 4)"
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] Host[4] SNMP: Host responded to SNMP
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update host set status = '3', status_event_count = '0', status_fail_date = '0000-00-00 00:00:00', status_rec_date = '0000-00-00 00:00:00', status_last_error = '', min_time = '8.2', max_time = '8.22000', cur_time = '8.2', avg_time = '8.21', total_polls = '2', failed_polls = '0', availability = '100' where hostname = '192.168.1.1'"
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "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=4"
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] Host[4] RECACHE: Processing 1 items in the auto reindex cache for '192.168.1.1'.
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='10276745' where host_id='4' and data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0'"
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] Host[4] DS[13] SNMP: v2: 192.168.1.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.8, output: 1227047643
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (13, 'traffic_in', '2008-05-31 16:10:03', '1227047643')"
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] Host[4] DS[13] SNMP: v2: 192.168.1.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.8, output: 3731693775
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (13, 'traffic_out', '2008-05-31 16:10:03', '3731693775')"
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] Time: 0.0268 s, Theads: N/A, Hosts: 1
05/31/2008 04:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
05/31/2008 04:10:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
05/31/2008 04:10:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) "
05/31/2008 04:10:04 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='13' and rrd_name='traffic_out' and time='2008-05-31 16:10:03'"
05/31/2008 04:10:04 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='13' and rrd_name='traffic_in' and time='2008-05-31 16:10:03'"
05/31/2008 04:10:04 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=13"

05/31/2008 04:10:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_template_data.rrd_step, rra.x_files_factor, rra.steps, rra.rows, rra_cf.consolidation_function_id, (rra.rows*rra.steps) as rra_order from data_template_data left join data_template_data_rra on (data_template_data.id=data_template_data_rra.data_template_data_id) left join rra on (data_template_data_rra.rra_id=rra.id) left join rra_cf on (rra.id=rra_cf.rra_id) where data_template_data.local_data_id=13 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"
05/31/2008 04:10:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT data_template_rrd.id, data_template_rrd.rrd_heartbeat, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_type_id FROM data_template_rrd WHERE data_template_rrd.local_data_id=13 ORDER BY local_data_template_rrd_id"
05/31/2008 04:10:04 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_template_rrd.data_source_name, data_template_data.name from (data_template_rrd,data_template_data) where data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_rrd.id=107"

05/31/2008 04:10:04 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_template_rrd.data_source_name, data_template_data.name from (data_template_rrd,data_template_data) where data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_rrd.id=108"

05/31/2008 04:10:04 PM - POLLER: Poller[0] CACTI2RRD: C:/Inetpub/rrdtool/rrdtool/Release/rrdtool.exe create C:/Inetpub/wwwroot/cacti/rra/radware_traffic_in_13.rrd --step 300 DS:traffic_in:COUNTER:600:0:100000000 DS:traffic_out:COUNTER:600:0:100000000 RRA:AVERAGE:0.5:1:600 RRA:AVERAGE:0.5:6:700 RRA:AVERAGE:0.5:24:775 RRA:AVERAGE:0.5:288:797 RRA:MAX:0.5:1:600 RRA:MAX:0.5:6:700 RRA:MAX:0.5:24:775 RRA:MAX:0.5:288:797
05/31/2008 04:10:04 PM - POLLER: Poller[0] CACTI2RRD: C:/Inetpub/rrdtool/rrdtool/Release/rrdtool.exe update C:\Inetpub\wwwroot\cacti\rra\radware_traffic_in_13.rrd --template traffic_out:traffic_in N:3731693775:1227047643
05/31/2008 04:10:04 PM - SYSTEM STATS: Time:1.1377 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:2 RRDsProcessed:1
05/31/2008 04:10:04 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:1.1377 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:2 RRDsProcessed:1')"
05/31/2008 04:10:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"


Any help would be greatly appreciated.

Thanks,
Chaucer

[BSOD2600]

1) I'd upgrade to rrdtool 1.2.25 or better, win32 build.

2) If you read the FAQ, then you should've saw the "Cannot find module" errors are related to an invalid MIBDIRS system variable.

3) I strongly suggest you stick with the default 5 min polling interval for cacti 0.8.7b.

4) Since cacti is trying to create and then update radware_traffic_in_13.rrd (for this example) that means you don't have NTFS permissions set correctly.

[Chaucer]

1) There's not a win32 build that is 1.2.25 or better. The most recent version is 1.2.15.

2) I missed this, my bad. My search was to specific when looking through the faq. My php\extra\mibs folder does have mibs in it. Also, the three modules are available when I do a php -m. However, what I did find is that my MIBDIRS system environment variable was messed up. Once I changed it I am not getting the Cannot Find Module errors when the schedule task runs.

3) I would go with 5 minute polling if this was a production box or if I was polling more than 2 devices. But since this is for our lab, I'd like to get more data.

4) radware_traffic_in_13.rrd is created and does have information in it (93 kb worth). I've also verified my permissions with chart from the faq again and they are set correctly.

Thanks for the help.

[BSOD2600]

1) There's not a win32 build that is 1.2.25 or better. The most recent version is 1.2.15.

WRONG. Did you even look on the rrdtool download site for Windows builds? http://www.gknw.net/mirror/rrdtool/

3) I would go with 5 minute polling if this was a production box or if I was polling more than 2 devices. But since this is for our lab, I'd like to get more data.

Well for someone starting out with Cacti, I strongly suggest you go with the 5min polling, since anything else presents some challenges, which you're probably experiencing. After changing back to 5 min polling, you're going to need to delete the rrd files so they get recreated.

[Chaucer]

Main Page

http://oss.oetiker.ch/rrdtool/

Click on Download

Click on Stable Release under Primary Distribution Point

Latest windows version is 1.2.15.

OR

Go down to Binary Distributions click on Native Windows 1 local

Latest windows version is 1.2.15.

Why not put the stable win32 releases in the appropiate places? Unless those releases are not stable. If they are going to scatter binary versions all over the place then its not worth my time trying to guess what is stable and whats not.

Also, the polling is working fine. Thanks for the help.

On a side note... You are quite vile for being a Moderator. I humbly came here for looking for help and you attack me with your condescending statements. It's not very professional or helpful. Not all of us are server guru's.

[BSOD2600]

http://oss.oetiker.ch/rrdtool/download.en.html -> Downloads -> Binary Distributions -> Native Windows 2.

Glad you got it figured out.