I have gone through many... many hours of trying to set this to work. I have also gone through the http://docs.cacti.net/manual:088:4_help ... #debugging guide and have been unable to fix or identify my problem. I am not a linux expert at all just a simple Network Engineer trying to use this awesome tool to monitor some Cisco devices. Anyways cutting to the chase. See below a fragment of my cacti.log file and also an rrd file that is showing the 'Nan" value in the graphs. Also I have done chmod -R 777 for the rra file. If you need extra information other than below to help me identifying the problem please let me know and I will post it. Thank you.
cacti.log
=============================
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] Host[23] DS[715] SNMP: v2: 192.168.10.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.7, output: 1130227566
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] Host[23] DS[716] SNMP: v2: 192.168.10.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.8, output: 2858566580
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] Host[23] DS[716] SNMP: v2: 192.168.10.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.8, output: 1227811520
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] Host[23] DS[717] SNMP: v2: 192.168.10.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.9, output: 0
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] Host[23] DS[717] SNMP: v2: 192.168.10.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.9, output: 0
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] Host[23] DS[718] SNMP: v2: 192.168.10.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.10, output: 1471236932
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] Host[23] DS[718] SNMP: v2: 192.168.10.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.10, output: 3579725706
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] Host[23] DS[719] SNMP: v2: 192.168.10.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.11, output: 1543535466
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] Host[23] DS[719] SNMP: v2: 192.168.10.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.11, output: 2703246421
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] Time: 3.8832 s, Theads: N/A, Hosts: 3
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "SHOW CREATE TABLE `syslog`.`syslog`"
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT PARTITION_NAME FROM `information_schema`.`partitions` WHERE table_schema='syslog' AND table_name='syslog' ORDER BY partition_ordinal_position DESC LIMIT 1,1;"
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT PARTITION_NAME FROM `information_schema`.`partitions` WHERE table_schema='syslog' AND table_name='syslog' ORDER BY partition_ordinal_position DESC LIMIT 1,1;"
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) FROM `syslog`.`syslog_incoming` WHERE status=84"
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE `syslog`.`syslog_incoming` SET status=84 WHERE status=0"
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE `syslog`.`syslog_incoming` SET priority='warn' WHERE priority='warning'"
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "INSERT INTO `syslog`.`syslog_facilities` (facility) SELECT DISTINCT facility FROM `syslog`.`syslog_incoming` ON DUPLICATE KEY UPDATE facility=VALUES(facility), last_updated=NOW()"
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "INSERT INTO `syslog`.`syslog_priorities` (priority) SELECT DISTINCT priority FROM `syslog`.`syslog_incoming` ON DUPLICATE KEY UPDATE priority=VALUES(priority), last_updated=NOW()"
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "INSERT INTO `syslog`.`syslog_hosts` (host) SELECT DISTINCT host FROM `syslog`.`syslog_incoming` WHERE status=84 ON DUPLICATE KEY UPDATE host=VALUES(host), last_updated=NOW()"
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "INSERT INTO `syslog`.`syslog_host_facilities` (host_id, facility_id) SELECT host_id, facility_id FROM ((SELECT DISTINCT host, facility FROM `syslog`.`syslog_incoming` WHERE status=84) AS s INNER JOIN `syslog`.`syslog_hosts` AS sh ON s.host=sh.host INNER JOIN `syslog`.`syslog_facilities` AS sf ON sf.facility=s.facility) ON DUPLICATE KEY UPDATE host_id=VALUES(host_id), last_updated=NOW()"
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "INSERT INTO `syslog`.`syslog_statistics` (host_id, facility_id, priority_id, insert_time, records) SELECT host_id, facility_id, priority_id, NOW(), sum(records) AS records FROM (SELECT host_id, facility_id, priority_id, count(*) AS records FROM syslog_incoming AS si INNER JOIN syslog_facilities AS sf ON sf.facility=si.facility INNER JOIN syslog_priorities AS sp ON sp.priority=si.priority INNER JOIN syslog_hosts AS sh ON sh.host=si.host WHERE status=84 GROUP BY host_id, priority_id, facility_id) AS merge GROUP BY host_id, priority_id, facility_id"
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM `syslog`.`syslog_remove` WHERE enabled='on'"
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) FROM `syslog`.`syslog_incoming` WHERE status=84"
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "DELETE FROM `syslog`.`syslog_incoming` WHERE host='192.168.11.32' AND status='84'"
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM `syslog`.`syslog_alert` WHERE enabled='on'"
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "INSERT INTO `syslog`.`syslog` (logtime, priority_id, facility_id, host_id, message) SELECT TIMESTAMP(`date`, `time`), priority_id, facility_id, host_id, message FROM (SELECT date, time, priority_id, facility_id, host_id, message FROM syslog_incoming AS si INNER JOIN syslog_facilities AS sf ON sf.facility=si.facility INNER JOIN syslog_priorities AS sp ON sp.priority=si.priority INNER JOIN syslog_hosts AS sh ON sh.host=si.host WHERE status=84) AS merge"
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "DELETE FROM `syslog`.`syslog_incoming` WHERE status=84"
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "DELETE FROM `syslog`.`syslog_statistics` WHERE insert_time<'2016-09-17 10:15:06'"
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "DELETE FROM `syslog`.`syslog_logs` WHERE logtime<'2016-09-11 10:15:06'"
09/18/2016 10:15:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM `syslog`.`syslog_reports` WHERE enabled='on'"
09/18/2016 10:15:06 AM - SYSTEM SYSLOG STATS:Time:0.24 Deletes:0 Incoming:0 Removes:0 XFers:31 Alerts:0 Alarms:0 Reports:0
09/18/2016 10:20:01 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '0', Max Runtime '298', Poller Runs: '1'
09/18/2016 10:20:01 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q "/var/www/cacti/cmd.php" 0 23]
09/18/2016 10:20:02 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/localhost_mem_swap_4.rrd --template mem_swap 1474208402:0
09/18/2016 10:20:02 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/localhost_users_6.rrd --template users 1474208402:1
09/18/2016 10:20:02 AM - CMDPHP: Poller[0] Host[0] DS[3] CMD: perl /var/www/cacti/scripts/linux_memory.pl MemFree:, output: 2498644
09/18/2016 10:20:02 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/localhost_mem_buffers_3.rrd --template mem_buffers 1474208402:2498644
09/18/2016 10:20:02 AM - CMDPHP: Poller[0] Host[0] DS[4] CMD: perl /var/www/cacti/scripts/linux_memory.pl SwapFree:, output: 0
09/18/2016 10:20:02 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/localhost_mem_swap_4.rrd --template mem_swap 1474208402:0
09/18/2016 10:20:02 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/localhost_proc_7.rrd --template proc 1474208402:132
09/18/2016 10:20:02 AM - CMDPHP: Poller[0] Host[0] DS[5] CMD: perl /var/www/cacti/scripts/loadavg_multi.pl, output: 1min:0.01 5min:0.16 10min:0.22
09/18/2016 10:20:02 AM - POLLER: Poller[0] Parsed MULTI output field '1min:0.01' [map 1min->load_1min]
09/18/2016 10:20:02 AM - POLLER: Poller[0] Parsed MULTI output field '5min:0.16' [map 5min->load_5min]
09/18/2016 10:20:02 AM - POLLER: Poller[0] Parsed MULTI output field '10min:0.22' [map 10min->load_15min]
09/18/2016 10:20:02 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/localhost_load_1min_5.rrd --template load_1min:load_5min:load_15min 1474208402:0.01:0.16:0.22
09/18/2016 10:20:02 AM - CMDPHP: Poller[0] Host[0] DS[6] CMD: perl /var/www/cacti/scripts/unix_users.pl , output: 1
09/18/2016 10:20:02 AM - CMDPHP: Poller[0] Host[0] DS[7] CMD: perl /var/www/cacti/scripts/unix_processes.pl, output: 132
09/18/2016 10:20:02 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/localhost_proc_7.rrd --template proc 1474208402:132
09/18/2016 10:20:02 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/1/116.rrd --template hdd_used:hdd_free 1474208402:U:U
09/18/2016 10:20:02 AM - CMDPHP: Poller[0] Host[0] DS[115] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get available /dev/sda1, output: 890200
09/18/2016 10:20:02 AM - CMDPHP: Poller[0] Host[0] DS[115] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get used /dev/sda1, output: 56692
09/18/2016 10:20:02 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/1/115.rrd --template hdd_free:hdd_used 1474208402:890200:56692
09/18/2016 10:20:02 AM - CMDPHP: Poller[0] Host[0] DS[116] WARNING: Result from CMD not valid. Partial Result: U
09/18/2016 10:20:02 AM - CMDPHP: Poller[0] Host[0] DS[116] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get available /dev/mapper/vesta-home, output: U
09/18/2016 10:20:02 AM - CMDPHP: Poller[0] Host[0] DS[116] WARNING: Result from CMD not valid. Partial Result: U
09/18/2016 10:20:02 AM - CMDPHP: Poller[0] Host[0] DS[116] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get used /dev/mapper/vesta-home, output: U
09/18/2016 10:20:02 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/1/116.rrd --template hdd_used:hdd_free 1474208402:U:U
09/18/2016 10:20:02 AM - CMDPHP: Poller[0] Host[0] DS[117] WARNING: Result from CMD not valid. Partial Result: U
09/18/2016 10:20:02 AM - CMDPHP: Poller[0] Host[0] DS[117] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get available /dev/mapper/vesta-opt, output: U
09/18/2016 10:20:02 AM - CMDPHP: Poller[0] Host[0] DS[117] WARNING: Result from CMD not valid. Partial Result: U
09/18/2016 10:20:02 AM - CMDPHP: Poller[0] Host[0] DS[117] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get used /dev/mapper/vesta-opt, output: U
09/18/2016 10:20:02 AM - CMDPHP: Poller[0] Host[0] DS[118] WARNING: Result from CMD not valid. Partial Result: U
09/18/2016 10:20:02 AM - CMDPHP: Poller[0] Host[0] DS[118] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get available /dev/mapper/vesta-root, output: U
09/18/2016 10:20:03 AM - CMDPHP: Poller[0] Host[0] DS[118] WARNING: Result from CMD not valid. Partial Result: U
09/18/2016 10:20:03 AM - CMDPHP: Poller[0] Host[0] DS[118] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get used /dev/mapper/vesta-root, output: U
09/18/2016 10:20:03 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/1/120.rrd --template hdd_used:hdd_free 1474208402:U:U
09/18/2016 10:20:03 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/1/118.rrd --template hdd_used:hdd_free 1474208402:U:U
09/18/2016 10:20:03 AM - CMDPHP: Poller[0] Host[0] DS[119] WARNING: Result from CMD not valid. Partial Result: U
09/18/2016 10:20:03 AM - CMDPHP: Poller[0] Host[0] DS[119] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get available /dev/mapper/vesta-tmp, output: U
09/18/2016 10:20:03 AM - CMDPHP: Poller[0] Host[0] DS[119] WARNING: Result from CMD not valid. Partial Result: U
09/18/2016 10:20:03 AM - CMDPHP: Poller[0] Host[0] DS[119] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get used /dev/mapper/vesta-tmp, output: U
09/18/2016 10:20:03 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/1/119.rrd --template hdd_free:hdd_used 1474208403:U:U
09/18/2016 10:20:03 AM - CMDPHP: Poller[0] Host[0] DS[120] WARNING: Result from CMD not valid. Partial Result: U
09/18/2016 10:20:03 AM - CMDPHP: Poller[0] Host[0] DS[120] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get available /dev/mapper/vesta-var, output: U
09/18/2016 10:20:03 AM - CMDPHP: Poller[0] Host[0] DS[120] WARNING: Result from CMD not valid. Partial Result: U
09/18/2016 10:20:03 AM - CMDPHP: Poller[0] Host[0] DS[120] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get used /dev/mapper/vesta-var, output: U
09/18/2016 10:20:03 AM - CMDPHP: Poller[0] Host[10] PING: UDP Ping Success (0.07 ms)
09/18/2016 10:20:03 AM - CMDPHP: Poller[0] Host[10] RECACHE: Processing 1 items in the auto reindex cache for '127.0.0.1'.
09/18/2016 10:20:03 AM - CMDPHP: Poller[0] Host[10] RECACHE DQ[6] OID: .1.3.6.1.2.1.1.3.0
09/18/2016 10:20:03 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/1/120.rrd --template hdd_free:hdd_used 1474208403:U:U
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/10/121.rrd --template mem_buffers 1474208403:2499032
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/10/122.rrd --template mem_swap 1474208403:0
09/18/2016 10:20:05 AM - POLLER: Poller[0] Parsed MULTI output field '1min:0.25' [map 1min->load_1min]
09/18/2016 10:20:05 AM - POLLER: Poller[0] Parsed MULTI output field '5min:0.21' [map 5min->load_5min]
09/18/2016 10:20:05 AM - POLLER: Poller[0] Parsed MULTI output field '10min:0.23' [map 10min->load_15min]
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/10/123.rrd --template load_1min:load_5min:load_15min 1474208403:0.25:0.21:0.23
09/18/2016 10:20:05 AM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'127.0.0.1', and OID:'.1.3.6.1.2.1.1.3.0'
09/18/2016 10:20:05 AM - CMDPHP: Poller[0] Host[10] RECACHE DQ[6] OID: .1.3.6.1.2.1.1.3.0, output:
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/10/124.rrd --template users 1474208403:1
09/18/2016 10:20:05 AM - CMDPHP: Poller[0] Host[10] DS[121] CMD: perl /var/www/cacti/scripts/linux_memory.pl MemFree:, output: 2497976
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/10/121.rrd --template mem_buffers 1474208403:2497976
09/18/2016 10:20:05 AM - CMDPHP: Poller[0] Host[10] DS[122] CMD: perl /var/www/cacti/scripts/linux_memory.pl SwapFree:, output: 0
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/10/122.rrd --template mem_swap 1474208403:0
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/10/125.rrd --template proc 1474208403:132
09/18/2016 10:20:05 AM - CMDPHP: Poller[0] Host[10] DS[123] CMD: perl /var/www/cacti/scripts/loadavg_multi.pl, output: 1min:0.25 5min:0.21 10min:0.23
09/18/2016 10:20:05 AM - POLLER: Poller[0] Parsed MULTI output field '1min:0.25' [map 1min->load_1min]
09/18/2016 10:20:05 AM - POLLER: Poller[0] Parsed MULTI output field '5min:0.21' [map 5min->load_5min]
09/18/2016 10:20:05 AM - POLLER: Poller[0] Parsed MULTI output field '10min:0.23' [map 10min->load_15min]
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/10/123.rrd --template load_1min:load_5min:load_15min 1474208403:0.25:0.21:0.23
09/18/2016 10:20:05 AM - CMDPHP: Poller[0] Host[10] DS[124] CMD: perl /var/www/cacti/scripts/unix_users.pl , output: 1
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/10/124.rrd --template users 1474208403:1
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/10/127.rrd --template hdd_free:hdd_used 1474208403:3779480:8184
09/18/2016 10:20:05 AM - CMDPHP: Poller[0] Host[10] DS[125] CMD: perl /var/www/cacti/scripts/unix_processes.pl, output: 132
09/18/2016 10:20:05 AM - CMDPHP: Poller[0] Host[10] DS[126] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get available /dev/mapper/cacti-home, output: 1884400
09/18/2016 10:20:05 AM - CMDPHP: Poller[0] Host[10] DS[126] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get used /dev/mapper/cacti-home, output: 9416
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/10/126.rrd --template hdd_used:hdd_free 1474208403:9416:1884400
09/18/2016 10:20:05 AM - CMDPHP: Poller[0] Host[10] DS[127] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get available /dev/mapper/cacti-opt, output: 3779480
09/18/2016 10:20:05 AM - CMDPHP: Poller[0] Host[10] DS[127] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get used /dev/mapper/cacti-opt, output: 8184
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/10/127.rrd --template hdd_free:hdd_used 1474208403:3779480:8184
09/18/2016 10:20:05 AM - CMDPHP: Poller[0] Host[10] DS[128] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get available /dev/mapper/cacti-root, output: 2456388
09/18/2016 10:20:05 AM - CMDPHP: Poller[0] Host[10] DS[128] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get used /dev/mapper/cacti-root, output: 1331276
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/10/128.rrd --template hdd_used:hdd_free 1474208403:1331276:2456388
09/18/2016 10:20:05 AM - CMDPHP: Poller[0] Host[10] DS[129] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get available /dev/mapper/cacti-tmp, output: 900296
09/18/2016 10:20:05 AM - CMDPHP: Poller[0] Host[10] DS[129] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get used /dev/mapper/cacti-tmp, output: 46596
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/10/131.rrd --template hdd_free:hdd_used 1474208403:890200:56692
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/10/129.rrd --template hdd_used:hdd_free 1474208403:46596:900296
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/22/709.rrd --template traffic_out:traffic_in 1474208405:348049547:2411644416
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/22/708.rrd --template traffic_out:traffic_in 1474208405:3165573370:3762605495
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/22/706.rrd --template traffic_in:traffic_out 1474208405:1166515490:1239738301
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/22/707.rrd --template traffic_out:traffic_in 1474208405:1640228949:562616456
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/22/705.rrd --template traffic_out:traffic_in 1474208405:1806397053:3672231284
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/23/734.rrd --template traffic_out 1474208405:0
09/18/2016 10:20:05 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/23/735.rrd --template asa_memfree 1474208405:150117800
09/18/2016 10:20:05 AM - CMDPHP: Poller[0] Host[10] DS[130] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get available /dev/mapper/cacti-var, output: 3415252
09/18/2016 10:20:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/23/732.rrd --template dropped_out 1474208405:0
09/18/2016 10:20:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/23/729.rrd --template WebvpnNumSessions 1474208405:0
09/18/2016 10:20:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/23/730.rrd --template currentInUse 1474208405:227
09/18/2016 10:20:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/23/723.rrd --template traffic_in:traffic_out 1474208405:104341198:29746890
09/18/2016 10:20:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/23/725.rrd --template SVCNumSessions 1474208405:0
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[10] DS[130] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get used /dev/mapper/cacti-var, output: 372412
09/18/2016 10:20:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/10/130.rrd --template hdd_used:hdd_free 1474208403:372412:3415252
09/18/2016 10:20:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/23/710.rrd --template traffic_in:traffic_out 1474208405:2978465705:2796519832
09/18/2016 10:20:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/23/713.rrd --template traffic_in:traffic_out 1474208405:0:0
09/18/2016 10:20:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/23/714.rrd --template traffic_in:traffic_out 1474208405:0:0
09/18/2016 10:20:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/23/715.rrd --template traffic_in:traffic_out 1474208405:1130319078:1130319160
09/18/2016 10:20:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/23/717.rrd --template traffic_in:traffic_out 1474208405:0:0
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[10] DS[131] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get available /dev/sda1, output: 890200
09/18/2016 10:20:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/cacti/rra/23/719.rrd --template traffic_out:traffic_in 1474208405:2703428913:1545199511
09/18/2016 10:20:06 AM - SYSTEM STATS: Time:4.4876 Method:cmd.php Processes:1 Threads:N/A Hosts:4 HostsPerProcess:4 DataSources:86 RRDsProcessed:48
09/18/2016 10:20:06 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /var/www/cacti/plugins/dsstats/poller_dsstats.php]
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[10] DS[131] CMD: perl /var/www/cacti/scripts/query_unix_partitions.pl get used /dev/sda1, output: 56692
09/18/2016 10:20:06 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /var/www/cacti/plugins/syslog/syslog_process.php]
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[22] SNMP: Host responded to SNMP
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[22] RECACHE: Processing 1 items in the auto reindex cache for '192.168.30.2'.
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[22] RECACHE DQ[1] OID: .1.3.6.1.2.1.1.3.0
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[22] RECACHE DQ[1] OID: .1.3.6.1.2.1.1.3.0, output: 369975871
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[22] DS[709] SNMP: v2: 192.168.30.2, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.10116, output: 348049547
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[22] DS[709] SNMP: v2: 192.168.30.2, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.10116, output: 2411644416
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[22] DS[708] SNMP: v2: 192.168.30.2, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.10115, output: 3165573370
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[22] DS[708] SNMP: v2: 192.168.30.2, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.10115, output: 3762605495
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[22] DS[707] SNMP: v2: 192.168.30.2, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.10114, output: 1640228949
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[22] DS[707] SNMP: v2: 192.168.30.2, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.10114, output: 562616456
09/18/2016 10:20:06 AM - SYSTEM THOLD STATS: Time:0.0042 Tholds:0 DownHosts:0
09/18/2016 10:20:06 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /var/www/cacti/plugins/rrdclean/rrdmove.php]
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[22] DS[706] SNMP: v2: 192.168.30.2, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.10113, output: 1239738301
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[22] DS[706] SNMP: v2: 192.168.30.2, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.10113, output: 1166515490
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[22] DS[705] SNMP: v2: 192.168.30.2, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.5001, output: 3672231284
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[22] DS[705] SNMP: v2: 192.168.30.2, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.5001, output: 1806397053
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] SNMP: Host responded to SNMP
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] RECACHE: Processing 1 items in the auto reindex cache for '192.168.10.1'.
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] RECACHE DQ[1] OID: .1.3.6.1.2.1.1.3.0
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] RECACHE DQ[1] OID: .1.3.6.1.2.1.1.3.0, output: 370046400
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[737] SNMP: v2: 192.168.10.1, dsname: asa_conn, oid: .1.3.6.1.4.1.9.9.147.1.2.2.2.1.5.40.6, output: 227
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[736] SNMP: v2: 192.168.10.1, dsname: asa_memused, oid: .1.3.6.1.4.1.9.9.48.1.1.1.5.1, output: 386753112
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[735] SNMP: v2: 192.168.10.1, dsname: asa_memfree, oid: .1.3.6.1.4.1.9.9.48.1.1.1.6.1, output: 150117800
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[734] SNMP: v2: 192.168.10.1, dsname: traffic_out, oid: .1.3.6.1.4.1.9.9.171.1.2.1.11.0, output: 0
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[733] SNMP: v2: 192.168.10.1, dsname: traffic_in, oid: .1.3.6.1.4.1.9.9.171.1.2.1.3.0, output: 0
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[732] SNMP: v2: 192.168.10.1, dsname: dropped_out, oid: .1.3.6.1.4.1.9.9.171.1.2.1.13.0, output: 0
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[731] SNMP: v2: 192.168.10.1, dsname: dropped_in, oid: .1.3.6.1.4.1.9.9.171.1.2.1.5.0, output: 0
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[730] SNMP: v2: 192.168.10.1, dsname: currentInUse, oid: 1.3.6.1.4.1.9.9.147.1.2.2.2.1.5.40.6, output: 227
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[729] SNMP: v2: 192.168.10.1, dsname: WebvpnNumSessions, oid: 1.3.6.1.4.1.9.9.392.1.3.38.0, output: 0
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[728] SNMP: v2: 192.168.10.1, dsname: IPSecNumSession, oid: 1.3.6.1.4.1.9.9.392.1.3.26.0, output: 0
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[727] SNMP: v2: 192.168.10.1, dsname: IPSecNumSession, oid: 1.3.6.1.4.1.9.9.392.1.3.29.0, output: 0
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[726] SNMP: v2: 192.168.10.1, dsname: ike_tunnels, oid: .1.3.6.1.4.1.9.9.171.1.2.1.1.0, output: 0
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[723] SNMP: v2: 192.168.10.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.15, output: 29746890
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[723] SNMP: v2: 192.168.10.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.15, output: 104341198
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[722] SNMP: v2: 192.168.10.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.14, output: 2243366479
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[722] SNMP: v2: 192.168.10.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.14, output: 176207294
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[721] SNMP: v2: 192.168.10.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.13, output: 2915500951
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[721] SNMP: v2: 192.168.10.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.13, output: 3383604414
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[725] SNMP: v2: 192.168.10.1, dsname: SVCNumSessions, oid: 1.3.6.1.4.1.9.9.392.1.3.35.0, output: 0
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[724] SNMP: v2: 192.168.10.1, dsname: asa5min_cpu, oid: .1.3.6.1.4.1.9.9.109.1.1.1.1.5.1, output: 1
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[720] SNMP: v2: 192.168.10.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.12, output: 476
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[720] SNMP: v2: 192.168.10.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.12, output: 0
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[710] SNMP: v2: 192.168.10.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.2, output: 2978465705
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[710] SNMP: v2: 192.168.10.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.2, output: 2796519832
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[711] SNMP: v2: 192.168.10.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.3, output: 1044526575
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[711] SNMP: v2: 192.168.10.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.3, output: 941821586
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[712] SNMP: v2: 192.168.10.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.4, output: 434105906
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[712] SNMP: v2: 192.168.10.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.4, output: 2730085551
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[713] SNMP: v2: 192.168.10.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.5, output: 0
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[713] SNMP: v2: 192.168.10.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.5, output: 0
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[714] SNMP: v2: 192.168.10.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.6, output: 0
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[714] SNMP: v2: 192.168.10.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.6, output: 0
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[715] SNMP: v2: 192.168.10.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.7, output: 1130319160
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[715] SNMP: v2: 192.168.10.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.7, output: 1130319242
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[716] SNMP: v2: 192.168.10.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.8, output: 2858930144
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[716] SNMP: v2: 192.168.10.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.8, output: 1227962930
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[717] SNMP: v2: 192.168.10.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.9, output: 0
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[717] SNMP: v2: 192.168.10.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.9, output: 0
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[718] SNMP: v2: 192.168.10.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.10, output: 1478633609
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[718] SNMP: v2: 192.168.10.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.10, output: 3671908493
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[719] SNMP: v2: 192.168.10.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.11, output: 1545203964
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Host[23] DS[719] SNMP: v2: 192.168.10.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.11, output: 2703433475
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] Time: 4.0357 s, Theads: N/A, Hosts: 3
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "SHOW CREATE TABLE `syslog`.`syslog`"
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT PARTITION_NAME FROM `information_schema`.`partitions` WHERE table_schema='syslog' AND table_name='syslog' ORDER BY partition_ordinal_position DESC LIMIT 1,1;"
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT PARTITION_NAME FROM `information_schema`.`partitions` WHERE table_schema='syslog' AND table_name='syslog' ORDER BY partition_ordinal_position DESC LIMIT 1,1;"
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) FROM `syslog`.`syslog_incoming` WHERE status=68"
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE `syslog`.`syslog_incoming` SET status=68 WHERE status=0"
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE `syslog`.`syslog_incoming` SET priority='warn' WHERE priority='warning'"
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "INSERT INTO `syslog`.`syslog_facilities` (facility) SELECT DISTINCT facility FROM `syslog`.`syslog_incoming` ON DUPLICATE KEY UPDATE facility=VALUES(facility), last_updated=NOW()"
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "INSERT INTO `syslog`.`syslog_priorities` (priority) SELECT DISTINCT priority FROM `syslog`.`syslog_incoming` ON DUPLICATE KEY UPDATE priority=VALUES(priority), last_updated=NOW()"
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "INSERT INTO `syslog`.`syslog_hosts` (host) SELECT DISTINCT host FROM `syslog`.`syslog_incoming` WHERE status=68 ON DUPLICATE KEY UPDATE host=VALUES(host), last_updated=NOW()"
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "INSERT INTO `syslog`.`syslog_host_facilities` (host_id, facility_id) SELECT host_id, facility_id FROM ((SELECT DISTINCT host, facility FROM `syslog`.`syslog_incoming` WHERE status=68) AS s INNER JOIN `syslog`.`syslog_hosts` AS sh ON s.host=sh.host INNER JOIN `syslog`.`syslog_facilities` AS sf ON sf.facility=s.facility) ON DUPLICATE KEY UPDATE host_id=VALUES(host_id), last_updated=NOW()"
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "INSERT INTO `syslog`.`syslog_statistics` (host_id, facility_id, priority_id, insert_time, records) SELECT host_id, facility_id, priority_id, NOW(), sum(records) AS records FROM (SELECT host_id, facility_id, priority_id, count(*) AS records FROM syslog_incoming AS si INNER JOIN syslog_facilities AS sf ON sf.facility=si.facility INNER JOIN syslog_priorities AS sp ON sp.priority=si.priority INNER JOIN syslog_hosts AS sh ON sh.host=si.host WHERE status=68 GROUP BY host_id, priority_id, facility_id) AS merge GROUP BY host_id, priority_id, facility_id"
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM `syslog`.`syslog_remove` WHERE enabled='on'"
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) FROM `syslog`.`syslog_incoming` WHERE status=68"
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "DELETE FROM `syslog`.`syslog_incoming` WHERE host='192.168.11.32' AND status='68'"
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM `syslog`.`syslog_alert` WHERE enabled='on'"
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "INSERT INTO `syslog`.`syslog` (logtime, priority_id, facility_id, host_id, message) SELECT TIMESTAMP(`date`, `time`), priority_id, facility_id, host_id, message FROM (SELECT date, time, priority_id, facility_id, host_id, message FROM syslog_incoming AS si INNER JOIN syslog_facilities AS sf ON sf.facility=si.facility INNER JOIN syslog_priorities AS sp ON sp.priority=si.priority INNER JOIN syslog_hosts AS sh ON sh.host=si.host WHERE status=68) AS merge"
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "DELETE FROM `syslog`.`syslog_incoming` WHERE status=68"
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "DELETE FROM `syslog`.`syslog_statistics` WHERE insert_time<'2016-09-17 10:20:06'"
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "DELETE FROM `syslog`.`syslog_logs` WHERE logtime<'2016-09-11 10:20:06'"
09/18/2016 10:20:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM `syslog`.`syslog_reports` WHERE enabled='on'"
09/18/2016 10:20:06 AM - SYSTEM SYSLOG STATS:Time:0.24 Deletes:0 Incoming:0 Removes:0 XFers:35 Alerts:0 Alarms:0 Reports:0
=============================
rrd file
last_update = 1474217103
ds[traffic_in].type = "COUNTER"
ds[traffic_in].minimal_heartbeat = 600
ds[traffic_in].min = 0.0000000000e+00
ds[traffic_in].max = 1.0000000000e+09
ds[traffic_in].last_ds = "1166301589"
ds[traffic_in].value = NaN
ds[traffic_in].unknown_sec = 3
ds[traffic_out].type = "COUNTER"
ds[traffic_out].minimal_heartbeat = 600
ds[traffic_out].min = 0.0000000000e+00
ds[traffic_out].max = 1.0000000000e+09
ds[traffic_out].last_ds = "1238554702"
ds[traffic_out].value = NaN
ds[traffic_out].unknown_sec = 3
rra[0].cf = "AVERAGE"
rra[0].rows = 600
rra[0].cur_row = 534
rra[0].pdp_per_row = 1
rra[0].xff = 5.0000000000e-01
rra[0].cdp_prep[0].value = NaN
rra[0].cdp_prep[0].unknown_datapoints = 0
rra[0].cdp_prep[1].value = NaN
rra[0].cdp_prep[1].unknown_datapoints = 0
rra[1].cf = "AVERAGE"
rra[1].rows = 700
rra[1].cur_row = 67
rra[1].pdp_per_row = 6
rra[1].xff = 5.0000000000e-01
rra[1].cdp_prep[0].value = NaN
rra[1].cdp_prep[0].unknown_datapoints = 3
rra[1].cdp_prep[1].value = NaN
rra[1].cdp_prep[1].unknown_datapoints = 3
rra[2].cf = "AVERAGE"
rra[2].rows = 775
rra[2].cur_row = 355
rra[2].pdp_per_row = 24
rra[2].xff = 5.0000000000e-01
rra[2].cdp_prep[0].value = NaN
rra[2].cdp_prep[0].unknown_datapoints = 9
rra[2].cdp_prep[1].value = NaN
rra[2].cdp_prep[1].unknown_datapoints = 9
rra[3].cf = "AVERAGE"
rra[3].rows = 797
rra[3].cur_row = 196
rra[3].pdp_per_row = 288
rra[3].xff = 5.0000000000e-01
rra[3].cdp_prep[0].value = NaN
rra[3].cdp_prep[0].unknown_datapoints = 201
rra[3].cdp_prep[1].value = NaN
rra[3].cdp_prep[1].unknown_datapoints = 201
rra[4].cf = "MAX"
rra[4].rows = 600
rra[4].cur_row = 230
rra[4].pdp_per_row = 1
rra[4].xff = 5.0000000000e-01
rra[4].cdp_prep[0].value = NaN
rra[4].cdp_prep[0].unknown_datapoints = 0
rra[4].cdp_prep[1].value = NaN
rra[4].cdp_prep[1].unknown_datapoints = 0
rra[5].cf = "MAX"
rra[5].rows = 700
rra[5].cur_row = 409
rra[5].pdp_per_row = 6
rra[5].xff = 5.0000000000e-01
rra[5].cdp_prep[0].value = NaN
rra[5].cdp_prep[0].unknown_datapoints = 3
rra[5].cdp_prep[1].value = NaN
rra[5].cdp_prep[1].unknown_datapoints = 3
rra[6].cf = "MAX"
rra[6].rows = 775
rra[6].cur_row = 421
rra[6].pdp_per_row = 24
rra[6].xff = 5.0000000000e-01
rra[6].cdp_prep[0].value = NaN
rra[6].cdp_prep[0].unknown_datapoints = 9
rra[6].cdp_prep[1].value = NaN
rra[6].cdp_prep[1].unknown_datapoints = 9
rra[7].cf = "MAX"
rra[7].rows = 797
rra[7].cur_row = 494
rra[7].pdp_per_row = 288
rra[7].xff = 5.0000000000e-01
rra[7].cdp_prep[0].value = NaN
rra[7].cdp_prep[0].unknown_datapoints = 201
rra[7].cdp_prep[1].value = NaN
rra[7].cdp_prep[1].unknown_datapoints = 201