No rra files created

Dragos · Post by **Dragos** » Sat Mar 19, 2005 4:53 pm

I tried installing in 2 different systems and still no files generated in /raa dir.

Here are som devug output. I folowed the post with duplicate in/out problem, and it is not my case.

Code: Select all

Data Source Debug

/usr/bin/rrdtool create \
/opt/cacti/rra/metropolis_traffic_in_91.rrd \
--step 300  \
DS:traffic_out:COUNTER:600:0:100000000 \
DS:traffic_in:COUNTER:600:0:100000000 \
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 \

In Graph Management no graphs are showing, and this is the error:

Code: Select all

RRDTool Says:

ERROR: opening '/opt/cacti/rra/metropolis_traffic_in_91.rrd': No such file or directory

[/code]

Dragos · Post by **Dragos** » Sat Mar 19, 2005 4:55 pm

The rra dir is chmoded 777

Dragos · Post by **Dragos** » Sat Mar 19, 2005 9:06 pm

The cacti version is cacti-0.8.6c, and was taken 2 days ago from the oficial website in tgz format(cacti-0.8.6c.tar.gz). I did a fresh install.
I use apache, php, netsnmp, mysql. I tried using both the php pooler and cactid, compiled on my machine. Still no result.

Post by **rony** » Sat Mar 19, 2005 9:39 pm

Run poller.php in debug mode and post the cacti.log from that run.

In the web interface "Settings -> Poller -> Logging" is where you turn on debug.

Dragos · Post by **Dragos** » Sun Mar 20, 2005 1:13 pm

Here is the answer when i run cactid in debug mode. I run as cactiuser from root of cacti's instalation. Cactid and his config file are in /usr/local/cactid/ dir and here are the permision for this folder:

Code: Select all

drwxrwxrwx   2 cactiuser nobody 4096 2005-03-18 08:56 cactid/
-rwxrwxrwx   1 cactiuser nobody 1281482 2005-03-18 08:55 cactid*
-rwxrwxrwx   1 cactiuser nobody    2316 2005-03-18 08:56 cactid.conf*
So i don't know why the "ERROR: Could not open config file"

The debug output is ( i replace bi hand in debug output the real ip with x.x.x.x):

Code: Select all

/opt/cacti$ /usr/local/cactid/cactid
ERROR: Could not open config file
ERROR: Could not open config file
ERROR: Could not open config file
ERROR: Could not open config file
ERROR: Could not open config file
CACTID: DEBUG: The path_php_server variable is /opt/cacti/script_server.php
CACTID: DEBUG: The path_cactilog variable is /opt/cacti/log/cacti.log
CACTID: DEBUG: The log_destination variable is 1
CACTID: DEBUG: The path_php variable is /usr/local/bin/php
CACTID: DEBUG: The availability_method variable is 1
CACTID: DEBUG: The ping_recovery_count variable is 3
CACTID: DEBUG: The ping_failure_count variable is 2
CACTID: DEBUG: The ping_method variable is 2
CACTID: DEBUG: The ping_retries variable is 1
CACTID: DEBUG: The ping_timeout variable is 400
CACTID: DEBUG: The log_perror variable is 1
CACTID: DEBUG: The log_pwarn variable is 1
CACTID: DEBUG: The log_pstats variable is 1
CACTID: DEBUG: The threads variable is 1
CACTID: CACTID: Version 0.8.6d starting
CACTID: MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
CACTID: DEBUG: PHP Script Server Routine Started
CACTID: DEBUG: PHP Script Server About to FORK Child Process
CACTID: DEBUG: PHP Script Server Child FORK Success
CACTID: DEBUG: Confirmed PHP Script Server Running
CACTID: DEBUG: Initial Value of Active Threads is 0
CACTID: DEBUG: Valid Thread to be Created
CACTID: DEBUG: The Value of Active Threads is 1
CACTID: DEBUG: In Poller, About to Start Polling of Host
CACTID: MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
CACTID: DEBUG: The UDP Ping return_code was -1, errno was 111, total_time was 0.1560
CACTID: Host[1] PING Result: UDP: Host is Alive
CACTID: Host[1] SNMP Result: Host does not require SNMP
CACTID: DEBUG: SQLCMD: 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='0.146890',max_time='0.205110',cur_time='0.155970',avg_time='0.165606',total_polls='11',failed_polls='0',availability='100.0000' where id='1'

CACTID: Host[1] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
CACTID: DEBUG: The Value of Active Threads is 0
CACTID: DEBUG: Valid Thread to be Created
CACTID: DEBUG: The Value of Active Threads is 1
CACTID: DEBUG: In Poller, About to Start Polling of Host
CACTID: MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
CACTID: DEBUG: The UDP Ping return_code was -1, errno was 111, total_time was 13.2430
CACTID: Host[4] PING Result: UDP: Host is Alive
CACTID: Host[4] SNMP Result: Host responded to SNMP
CACTID: DEBUG: SQLCMD: 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='3.369490',max_time='106.900000',cur_time='25.615485',avg_time='29.482273',total_polls='5',failed_polls='0',availability='100.0000' where id='4'

CACTID: Host[4] RECACHE: Processing 1 items in the auto reindex cache for 'x.x.x.x'
CACTID: Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.2, value: 2542932259
CACTID: DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (92,'traffic_in','2005-03-20 20:02:07','2542932259')
CACTID: Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.2, value: 3045957581
CACTID: DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (92,'traffic_out','2005-03-20 20:02:07','3045957581')
CACTID: Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.3, value: 3029125630
CACTID: DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (93,'traffic_in','2005-03-20 20:02:07','3029125630')
CACTID: Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.3, value: 4118844080
CACTID: DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (93,'traffic_out','2005-03-20 20:02:07','4118844080')
CACTID: Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.6, value: 1719880199
CACTID: DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (94,'traffic_in','2005-03-20 20:02:07','1719880199')
CACTID: Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.6, value: 1282172843
CACTID: DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (94,'traffic_out','2005-03-20 20:02:07','1282172843')
CACTID: Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.20, value: 1324879565
CACTID: DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (95,'traffic_in','2005-03-20 20:02:07','1324879565')
CACTID: Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.20, value: 218559044
CACTID: DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (95,'traffic_out','2005-03-20 20:02:07','218559044')
CACTID: Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.21, value: 2993998235
CACTID: DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (96,'traffic_in','2005-03-20 20:02:07','2993998235')
CACTID: Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.21, value: 3523798008
CACTID: DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (96,'traffic_out','2005-03-20 20:02:07','3523798008')
CACTID: Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.22, value: 0
CACTID: DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (97,'traffic_in','2005-03-20 20:02:07','0')
CACTID: Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.22, value: 0
CACTID: DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (97,'traffic_out','2005-03-20 20:02:07','0')
CACTID: Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.23, value: 3872738702
CACTID: DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (98,'traffic_in','2005-03-20 20:02:07','3872738702')
CACTID: Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.23, value: 1059554752
CACTID: DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (98,'traffic_out','2005-03-20 20:02:07','1059554752')
CACTID: Host[4] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
CACTID: DEBUG: The Value of Active Threads is 0
CACTID: DEBUG: SQLCMD: replace into settings (name,value) values ('date',NOW())
CACTID: DEBUG: SQLCMD: insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())
CACTID: DEBUG: Thread Cleanup Complete
CACTID: DEBUG: PHP Script Server Shutdown Started
CACTID: DEBUG: PHP Script Server Pipes Closed
CACTID: DEBUG: Allocated Variable Memory Freed
CACTID: DEBUG: MYSQL Free & Close Completed
CACTID: Execution Time: 2.5978 s, Threads: 1, Hosts: 2

Post by **rony** » Sun Mar 20, 2005 2:37 pm

Well, first, since version 0.8.6, you run poller.php and it then runs the poller that you have selected in settings. Just running cactid or cmd.php will not update/create the RRD's, that is poller.php job.

Please make sure that you are running poller.php from cron.

And if you are still having problems, please post the cacti.log from one polling cycle of poller.php.

Thanks,

Dragos · Post by **Dragos** » Mon Mar 21, 2005 8:18 am

If i understood correctly pooler.php is running cmd.php or cactid (the one selected in settings). Therefore I don't need to add cmd.php or cactid in cron.

I only have pooler.php running in cron every five minutes. My graphs are showing now but there is no data. only white graphs.

Here are my logs:

Code: Select all

03/21/2005 03:02:34 PM - CACTID: Poller[0] DEBUG: The path_php variable is /usr/local/bin/php
03/21/2005 03:02:34 PM - CACTID: Poller[0] DEBUG: The availability_method variable is 1
03/21/2005 03:02:34 PM - CACTID: Poller[0] DEBUG: The ping_recovery_count variable is 3
03/21/2005 03:02:34 PM - CACTID: Poller[0] DEBUG: The ping_failure_count variable is 2
03/21/2005 03:02:34 PM - CACTID: Poller[0] DEBUG: The ping_method variable is 2
03/21/2005 03:02:34 PM - CACTID: Poller[0] DEBUG: The ping_retries variable is 1
03/21/2005 03:02:34 PM - CACTID: Poller[0] DEBUG: The ping_timeout variable is 400
03/21/2005 03:02:34 PM - CACTID: Poller[0] DEBUG: The log_perror variable is 1
03/21/2005 03:02:34 PM - CACTID: Poller[0] DEBUG: The log_pwarn variable is 1
03/21/2005 03:02:34 PM - CACTID: Poller[0] DEBUG: The log_pstats variable is 1
03/21/2005 03:02:34 PM - CACTID: Poller[0] DEBUG: The threads variable is 1
03/21/2005 03:02:34 PM - CACTID: Poller[0] CACTID: Version 0.8.6d starting
03/21/2005 03:02:34 PM - CACTID: Poller[0] MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
03/21/2005 03:02:35 PM - CACTID: Poller[0] DEBUG: PHP Script Server Routine Started
03/21/2005 03:02:35 PM - CACTID: Poller[0] DEBUG: PHP Script Server About to FORK Child Process
03/21/2005 03:02:35 PM - CACTID: Poller[0] DEBUG: PHP Script Server Child FORK Success
03/21/2005 03:02:36 PM - PHPSVR: Poller[0] DEBUG: SERVER: cactid
03/21/2005 03:02:36 PM - PHPSVR: Poller[0] DEBUG: GETCWD: /tmp/cacti-cactid-0.8.6d/1
03/21/2005 03:02:36 PM - PHPSVR: Poller[0] DEBUG: DIRNAM: /opt/cacti
03/21/2005 03:02:36 PM - PHPSVR: Poller[0] DEBUG: FILENM: /opt/cacti/script_server.php
03/21/2005 03:02:36 PM - PHPSVR: Poller[0] PHP Script Server has Started - Parent is cactid
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: Confirmed PHP Script Server Running
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: Initial Value of Active Threads is 0
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: Valid Thread to be Created
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: The Value of Active Threads is 1
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: In Poller, About to Start Polling of Host
03/21/2005 03:02:36 PM - CACTID: Poller[0] MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: The UDP Ping return_code was -1, errno was 111, total_time was 0.1571
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[1] PING Result: UDP: Host is Alive
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[1] SNMP Result: Host does not require SNMP
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: 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='0.146890',max_time='0.205110',cur_time='0.157070',avg_time='0.164889',total_polls='12',failed_polls='0',availability='100.0000' where id='1'

03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[1] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: The Value of Active Threads is 0
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: Valid Thread to be Created
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: The Value of Active Threads is 1
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: In Poller, About to Start Polling of Host
03/21/2005 03:02:36 PM - CACTID: Poller[0] MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: The UDP Ping return_code was -1, errno was 111, total_time was 5.6260
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] PING Result: UDP: Host is Alive
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP Result: Host responded to SNMP
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: 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='3.369490',max_time='367.235000',cur_time='5.228035',avg_time='116.563612',total_polls='23',failed_polls='0',availability='100.0000' where id='4'

03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] RECACHE: Processing 1 items in the auto reindex cache for 'x.x.x.x'
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: 5min_cpu, oid: .1.3.6.1.4.1.9.2.1.58.0, value: 46
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (164,'5min_cpu','2005-03-21 15:02:34','46')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1, value: 1825495754
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (165,'traffic_in','2005-03-21 15:02:34','1825495754')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1, value: 4036013897
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (165,'traffic_out','2005-03-21 15:02:34','4036013897')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.2, value: 396756231
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (166,'traffic_in','2005-03-21 15:02:34','396756231')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.2, value: 1520074306
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (166,'traffic_out','2005-03-21 15:02:34','1520074306')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.3, value: 295806597
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (167,'traffic_in','2005-03-21 15:02:34','295806597')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.3, value: 4120168460
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (167,'traffic_out','2005-03-21 15:02:34','4120168460')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.6, value: 1052088382
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (168,'traffic_in','2005-03-21 15:02:34','1052088382')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.6, value: 3822182840
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (168,'traffic_out','2005-03-21 15:02:34','3822182840')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.7, value: 0
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (169,'traffic_in','2005-03-21 15:02:34','0')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.7, value: 247635212
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (169,'traffic_out','2005-03-21 15:02:34','247635212')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] WARNING: Result from SNMP not valid. Partial Result: No Such Instance cur...
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.9, value: U
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (170,'traffic_in','2005-03-21 15:02:34','U')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] WARNING: Result from SNMP not valid. Partial Result: No Such Instance cur...
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.9, value: U
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (170,'traffic_out','2005-03-21 15:02:34','U')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] WARNING: Result from SNMP not valid. Partial Result: No Such Instance cur...
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.10, value: U
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (171,'traffic_in','2005-03-21 15:02:34','U')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] WARNING: Result from SNMP not valid. Partial Result: No Such Instance cur...
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.10, value: U
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (171,'traffic_out','2005-03-21 15:02:34','U')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] WARNING: Result from SNMP not valid. Partial Result: No Such Instance cur...
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.11, value: U
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (172,'traffic_in','2005-03-21 15:02:34','U')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] WARNING: Result from SNMP not valid. Partial Result: No Such Instance cur...
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.11, value: U
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (172,'traffic_out','2005-03-21 15:02:34','U')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] WARNING: Result from SNMP not valid. Partial Result: No Such Instance cur...
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.12, value: U
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (173,'traffic_in','2005-03-21 15:02:34','U')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] WARNING: Result from SNMP not valid. Partial Result: No Such Instance cur...
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.12, value: U
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (173,'traffic_out','2005-03-21 15:02:34','U')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] WARNING: Result from SNMP not valid. Partial Result: No Such Instance cur...
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.13, value: U
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (174,'traffic_in','2005-03-21 15:02:34','U')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] WARNING: Result from SNMP not valid. Partial Result: No Such Instance cur...
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.13, value: U
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (174,'traffic_out','2005-03-21 15:02:34','U')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] WARNING: Result from SNMP not valid. Partial Result: No Such Instance cur...
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.14, value: U
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (175,'traffic_in','2005-03-21 15:02:34','U')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] WARNING: Result from SNMP not valid. Partial Result: No Such Instance cur...
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.14, value: U
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (175,'traffic_out','2005-03-21 15:02:34','U')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] WARNING: Result from SNMP not valid. Partial Result: No Such Instance cur...
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.15, value: U
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (176,'traffic_in','2005-03-21 15:02:34','U')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] WARNING: Result from SNMP not valid. Partial Result: No Such Instance cur...
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.15, value: U
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (176,'traffic_out','2005-03-21 15:02:34','U')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.17, value: 1219921417
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (177,'traffic_in','2005-03-21 15:02:34','1219921417')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.17, value: 46079765
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (177,'traffic_out','2005-03-21 15:02:34','46079765')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.18, value: 1224990310
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (178,'traffic_in','2005-03-21 15:02:34','1224990310')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.18, value: 47595077
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (178,'traffic_out','2005-03-21 15:02:34','47595077')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.20, value: 2623410122
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (179,'traffic_in','2005-03-21 15:02:34','2623410122')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.20, value: 1923996271
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (179,'traffic_out','2005-03-21 15:02:34','1923996271')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.21, value: 229670439
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (180,'traffic_in','2005-03-21 15:02:34','229670439')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.21, value: 2737777477
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (180,'traffic_out','2005-03-21 15:02:34','2737777477')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.22, value: 0
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (181,'traffic_in','2005-03-21 15:02:34','0')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.22, value: 0
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (181,'traffic_out','2005-03-21 15:02:34','0')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.23, value: 307410729
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (182,'traffic_in','2005-03-21 15:02:34','307410729')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.23, value: 2476711668
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (182,'traffic_out','2005-03-21 15:02:34','2476711668')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.24, value: 3882155115
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (183,'traffic_in','2005-03-21 15:02:34','3882155115')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.24, value: 80061397
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (183,'traffic_out','2005-03-21 15:02:34','80061397')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.25, value: 3135744738
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (184,'traffic_in','2005-03-21 15:02:34','3135744738')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.25, value: 4013777858
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (184,'traffic_out','2005-03-21 15:02:34','4013777858')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.26, value: 2931003737
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (185,'traffic_in','2005-03-21 15:02:34','2931003737')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.26, value: 2756379962
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (185,'traffic_out','2005-03-21 15:02:34','2756379962')
03/21/2005 03:02:36 PM - CACTID: Poller[0] Host[4] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: The Value of Active Threads is 0
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: Valid Thread to be Created
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: The Value of Active Threads is 1
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: In Poller, About to Start Polling of Host
03/21/2005 03:02:36 PM - CACTID: Poller[0] MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
03/21/2005 03:02:36 PM - CACTID: Poller[0] DEBUG: The UDP Ping return_code was -1, errno was 111, total_time was 139.1560
03/21/2005 03:02:37 PM - CACTID: Poller[0] Host[5] PING Result: UDP: Host is Alive
03/21/2005 03:02:37 PM - CACTID: Poller[0] Host[5] SNMP Result: Host responded to SNMP
03/21/2005 03:02:37 PM - CACTID: Poller[0] DEBUG: SQLCMD: update host set status='3',status_event_count='0', status_fail_date='2005-03-20 10:32:14',status_rec_date='0000-00-00 00:00:00',status_last_error='SNMP not performed due to setting or ping result.',min_time='9.999990',max_time='369.827005',cur_time='369.827005',avg_time='137.556749',total_polls='6',failed_polls='2',availability='66.6667' where id='5'

03/21/2005 03:02:37 PM - CACTID: Poller[0] Host[5] RECACHE: Processing 1 items in the auto reindex cache for 'y.y.y.y'
03/21/2005 03:02:37 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: 5min_cpu, oid: .1.3.6.1.4.1.9.2.1.58.0, value: 4
03/21/2005 03:02:37 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (186,'5min_cpu','2005-03-21 15:02:34','4')
03/21/2005 03:02:37 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1, value: 2684542908
03/21/2005 03:02:37 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (187,'traffic_in','2005-03-21 15:02:34','2684542908')
03/21/2005 03:02:37 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1, value: 594454280
03/21/2005 03:02:37 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (187,'traffic_out','2005-03-21 15:02:34','594454280')
03/21/2005 03:02:37 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.2, value: 272238317
03/21/2005 03:02:37 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (188,'traffic_in','2005-03-21 15:02:34','272238317')
03/21/2005 03:02:38 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.2, value: 1935390699
03/21/2005 03:02:38 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (188,'traffic_out','2005-03-21 15:02:34','1935390699')
03/21/2005 03:02:38 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.3, value: 2872891357
03/21/2005 03:02:38 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (189,'traffic_in','2005-03-21 15:02:34','2872891357')
03/21/2005 03:02:38 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.3, value: 9052712
03/21/2005 03:02:38 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (189,'traffic_out','2005-03-21 15:02:34','9052712')
03/21/2005 03:02:38 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.4, value: 4077709572
03/21/2005 03:02:38 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (190,'traffic_in','2005-03-21 15:02:34','4077709572')
03/21/2005 03:02:38 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.4, value: 1098411259
03/21/2005 03:02:38 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (190,'traffic_out','2005-03-21 15:02:34','1098411259')
03/21/2005 03:02:38 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.5, value: 3906830198
03/21/2005 03:02:38 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (191,'traffic_in','2005-03-21 15:02:34','3906830198')
03/21/2005 03:02:38 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.5, value: 1959076873
03/21/2005 03:02:38 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (191,'traffic_out','2005-03-21 15:02:34','1959076873')
03/21/2005 03:02:38 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.6, value: 1997684342
03/21/2005 03:02:38 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (192,'traffic_in','2005-03-21 15:02:34','1997684342')
03/21/2005 03:02:38 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.6, value: 2828235578
03/21/2005 03:02:38 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (192,'traffic_out','2005-03-21 15:02:34','2828235578')
03/21/2005 03:02:38 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.7, value: 2956513881
03/21/2005 03:02:38 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (193,'traffic_in','2005-03-21 15:02:34','2956513881')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.7, value: 2025077877
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (193,'traffic_out','2005-03-21 15:02:34','2025077877')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.9, value: 4056519360
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (194,'traffic_in','2005-03-21 15:02:34','4056519360')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.9, value: 3644464260
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (194,'traffic_out','2005-03-21 15:02:34','3644464260')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.12, value: 2630958704
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (195,'traffic_in','2005-03-21 15:02:34','2630958704')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.12, value: 1583685907
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (195,'traffic_out','2005-03-21 15:02:34','1583685907')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.45, value: 710541955
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (196,'traffic_in','2005-03-21 15:02:34','710541955')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.45, value: 931400139
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (196,'traffic_out','2005-03-21 15:02:34','931400139')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.48, value: 606172545
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (197,'traffic_in','2005-03-21 15:02:34','606172545')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.48, value: 3941346261
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (197,'traffic_out','2005-03-21 15:02:34','3941346261')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.49, value: 789235223
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (198,'traffic_in','2005-03-21 15:02:34','789235223')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.49, value: 4050555228
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (198,'traffic_out','2005-03-21 15:02:34','4050555228')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.52, value: 0
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (199,'traffic_in','2005-03-21 15:02:34','0')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.52, value: 0
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (199,'traffic_out','2005-03-21 15:02:34','0')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.53, value: 0
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (200,'traffic_in','2005-03-21 15:02:34','0')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.53, value: 0
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (200,'traffic_out','2005-03-21 15:02:34','0')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.8, value: 4147806792
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (201,'traffic_in','2005-03-21 15:02:34','4147806792')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.8, value: 3898072335
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (201,'traffic_out','2005-03-21 15:02:34','3898072335')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.2, value: 274225470
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (202,'traffic_in','2005-03-21 15:02:34','274225470')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.2, value: 1936106937
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (202,'traffic_out','2005-03-21 15:02:34','1936106937')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.3, value: 2872891689
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (203,'traffic_in','2005-03-21 15:02:34','2872891689')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.3, value: 9052712
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (203,'traffic_out','2005-03-21 15:02:34','9052712')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.4, value: 4077709572
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (204,'traffic_in','2005-03-21 15:02:34','4077709572')
03/21/2005 03:02:39 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.4, value: 1098411259
03/21/2005 03:02:39 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (204,'traffic_out','2005-03-21 15:02:34','1098411259')
03/21/2005 03:02:40 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.5, value: 3906858265
03/21/2005 03:02:40 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (205,'traffic_in','2005-03-21 15:02:34','3906858265')
03/21/2005 03:02:40 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.5, value: 1959225445
03/21/2005 03:02:40 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (205,'traffic_out','2005-03-21 15:02:34','1959225445')
03/21/2005 03:02:40 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.6, value: 1997684342
03/21/2005 03:02:40 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (206,'traffic_in','2005-03-21 15:02:34','1997684342')
03/21/2005 03:02:40 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.6, value: 2828235578
03/21/2005 03:02:40 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (206,'traffic_out','2005-03-21 15:02:34','2828235578')
03/21/2005 03:02:40 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.7, value: 2956513881
03/21/2005 03:02:40 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (207,'traffic_in','2005-03-21 15:02:34','2956513881')
03/21/2005 03:02:40 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.7, value: 2025077877
03/21/2005 03:02:40 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (207,'traffic_out','2005-03-21 15:02:34','2025077877')
03/21/2005 03:02:40 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.8, value: 4147806792
03/21/2005 03:02:40 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (208,'traffic_in','2005-03-21 15:02:34','4147806792')
03/21/2005 03:02:40 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.8, value: 3898072335
03/21/2005 03:02:40 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (208,'traffic_out','2005-03-21 15:02:34','3898072335')
03/21/2005 03:02:41 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.9, value: 4056519360
03/21/2005 03:02:41 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (209,'traffic_in','2005-03-21 15:02:34','4056519360')
03/21/2005 03:02:41 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.9, value: 3644464260
03/21/2005 03:02:41 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (209,'traffic_out','2005-03-21 15:02:34','3644464260')
03/21/2005 03:02:41 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.12, value: 2630958704
03/21/2005 03:02:41 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (210,'traffic_in','2005-03-21 15:02:34','2630958704')
03/21/2005 03:02:41 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.12, value: 1583685973
03/21/2005 03:02:41 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (210,'traffic_out','2005-03-21 15:02:34','1583685973')
03/21/2005 03:02:41 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.45, value: 711679237
03/21/2005 03:02:41 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (211,'traffic_in','2005-03-21 15:02:34','711679237')
03/21/2005 03:02:41 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.45, value: 933859469
03/21/2005 03:02:41 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (211,'traffic_out','2005-03-21 15:02:34','933859469')
03/21/2005 03:02:41 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.48, value: 606177981
03/21/2005 03:02:41 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (212,'traffic_in','2005-03-21 15:02:34','606177981')
03/21/2005 03:02:41 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.48, value: 3941396409
03/21/2005 03:02:41 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (212,'traffic_out','2005-03-21 15:02:34','3941396409')
03/21/2005 03:02:41 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.49, value: 789239904
03/21/2005 03:02:41 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (213,'traffic_in','2005-03-21 15:02:34','789239904')
03/21/2005 03:02:41 PM - CACTID: Poller[0] Host[5] SNMP: v1: y.y.y.y, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.49, value: 4050558042
03/21/2005 03:02:41 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (213,'traffic_out','2005-03-21 15:02:34','4050558042')
03/21/2005 03:02:41 PM - CACTID: Poller[0] Host[5] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
03/21/2005 03:02:41 PM - CACTID: Poller[0] DEBUG: The Value of Active Threads is 0
03/21/2005 03:02:41 PM - CACTID: Poller[0] DEBUG: SQLCMD: replace into settings (name,value) values ('date',NOW())
03/21/2005 03:02:42 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())
03/21/2005 03:02:42 PM - CACTID: Poller[0] DEBUG: Thread Cleanup Complete
03/21/2005 03:02:42 PM - CACTID: Poller[0] DEBUG: PHP Script Server Shutdown Started
03/21/2005 03:02:42 PM - CACTID: Poller[0] DEBUG: PHP Script Server Pipes Closed
03/21/2005 03:02:42 PM - CACTID: Poller[0] DEBUG: Allocated Variable Memory Freed
03/21/2005 03:02:42 PM - CACTID: Poller[0] DEBUG: MYSQL Free & Close Completed
03/21/2005 03:02:42 PM - PHPSVR: Poller[0] DEBUG: PHP Script Server Shutdown request received, exiting

Post by **rony** » Mon Mar 21, 2005 8:28 am

Please post the whole log, you are missing the all important CACTI2RRD lines. Which usually means, you aren't running poller.php but cactid or cmd.php direct. Or, you are posting the stdout from running the command. Please post the log/cacti.log file from running one complete polling cycle.

commoboy · Post by **commoboy** » Mon Mar 21, 2005 1:51 pm

Have you checked that your cacti db is completely configured? I ran into this problem as well and it turned out that I was missing about half of the required poller tables in my schema.

Can you post the output of "show tables" here?

Dragos · Post by **Dragos** » Mon Mar 21, 2005 2:25 pm

Here are my tables in cacti database. I imported them from sql file from the cacti distribution.

Code: Select all

mysql> show tables;
+---------------------------+
| Tables_in_cacti           |
+---------------------------+
| cdef                      |
| cdef_items                |
| colors                    |
| data_input                |
| data_input_data           |
| data_input_fields         |
| data_local                |
| data_template             |
| data_template_data        |
| data_template_data_rra    |
| data_template_rrd         |
| graph_local               |
| graph_template_input      |
| graph_template_input_defs |
| graph_templates           |
| graph_templates_gprint    |
| graph_templates_graph     |
| graph_templates_item      |
| graph_tree                |
| graph_tree_items          |
| host                      |
| host_graph                |
| host_snmp_cache           |
| host_snmp_query           |
| host_template             |
| host_template_graph       |
| host_template_snmp_query  |
| poller                    |
| poller_command            |
| poller_item               |
| poller_output             |
| poller_reindex            |
| poller_time               |
| rra                       |
| rra_cf                    |
| settings                  |
| settings_graphs           |
| settings_tree             |
| snmp_query                |
| snmp_query_graph          |
| snmp_query_graph_rrd      |
| snmp_query_graph_rrd_sv   |
| snmp_query_graph_sv       |
| user_auth                 |
| user_auth_perms           |
| user_auth_realm           |
| user_log                  |
| version                   |
+---------------------------+

[/code]

Dragos · Post by **Dragos** » Mon Mar 21, 2005 2:32 pm

also here are the logs from cacti.log (I haven't run, this time, from console any of the cacty files for the period I logged it):

Code: Select all

03/21/2005 09:14:13 PM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph -  --imgformat=PNG  --start=-86400  --end=-300  --title="router1 - Traffic - Gi0"  --rigid  --base=1000  --height=120  --width=500  --alt-autoscale-max  --lower-limit=0  --vertical-label="bytes per second"  DEF:a="/opt/cacti/rra/router1_traffic_in_216.rrd":traffic_in:AVERAGE  DEF:b="/opt/cacti/rra/router1_traffic_in_216.rrd":traffic_out:AVERAGE  AREA:a#00CF00:"Inbound"   GPRINT:a:LAST:" Current\:%8.2lf %s"   GPRINT:a:AVERAGE:"Average\:%8.2lf %s"   GPRINT:a:MAX:"Maximum\:%8.2lf %s\n"   LINE1:b#002A97:"Outbound"   GPRINT:b:LAST:"Current\:%8.2lf %s"   GPRINT:b:AVERAGE:"Average\:%8.2lf %s"   GPRINT:b:MAX:"Maximum\:%8.2lf %s"
03/21/2005 09:14:14 PM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph -  --imgformat=PNG  --start=-86400  --end=-300  --title="router1 - Traffic - Gi0"  --rigid  --base=1000  --height=120  --width=500  --alt-autoscale-max  --lower-limit=0  --vertical-label="bytes per second"  DEF:a="/opt/cacti/rra/router1_traffic_in_216.rrd":traffic_in:AVERAGE  DEF:b="/opt/cacti/rra/router1_traffic_in_216.rrd":traffic_out:AVERAGE  AREA:a#00CF00:"Inbound"   GPRINT:a:LAST:" Current\:%8.2lf %s"   GPRINT:a:AVERAGE:"Average\:%8.2lf %s"   GPRINT:a:MAX:"Maximum\:%8.2lf %s\n"   LINE1:b#002A97:"Outbound"   GPRINT:b:LAST:"Current\:%8.2lf %s"   GPRINT:b:AVERAGE:"Average\:%8.2lf %s"   GPRINT:b:MAX:"Maximum\:%8.2lf %s"

Dragos · Post by **Dragos** » Wed Mar 23, 2005 4:43 pm

Can anybody give me a hint? Please feel free to ask for more information as you need for debugging.
I am sure this app is working on cisco devices, but my graph are still white, with no shape at all in there, and I can asure you the traffic on interfaces is hevy and so is the cpu time.

Post by **TheWitness** » Wed Mar 23, 2005 10:08 pm

Please perform the following:

mysql --user=root --password cacti
> truncate table poller_output;
> exit

This command sequence will remove the output from you errant polling and alllow Cacti to pull records from the database without running out of memory. You RRD files should work correctly from that point on.

TheWitness

aecon · Post by **aecon** » Thu Mar 24, 2005 10:22 am

I am running a slackware linux 10.1 with the latest cacti version 0.8.6c. I have an unpatched version because i noticed that after applying the patches , cacti is unusable (db_connect() errors ).
I also noticed that my rra/ folder is empty (after some hours of trying to troubleshoot the missisng graphs) and i did truncate the poller_output table. I am running net-snmp 5.2.1the following way snmpd -r -f -L -C --rocommunity="testing 127.0.0.1" udp:161

I have php 4.3.10 and apache 1.3.33.Php was not compiled with snmp support (is it necessary?)
Is there going to be a new bug free version of cacti any time soon(i used it a couple of years ago with no problems)or am i doing something wrong?.I can provide the necessary info needed to debug this.

Thanx in advance

Dragos · Post by **Dragos** » Thu Mar 24, 2005 12:35 pm

TheWitness wrote:Please perform the following:

mysql --user=root --password cacti
> truncate table poller_output;
> exit

This command sequence will remove the output from you errant polling and alllow Cacti to pull records from the database without running out of memory. You RRD files should work correctly from that point on.

TheWitness

I did that and stil no results.

I can't stand it anymore!
I also run slackware 10 and php is compiled with snmp support.

No rra files created

No rra files created

Who is online