Poller Error

[farhan]

Hello Guys,

Everything is running fine but why i am receiving following errors in

cacti.log. I am using CACTID instead of cmd.php.

09/15/2006 11:16:27 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='1'"
09/15/2006 11:17:37 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('2', '6430', 'Running', NOW())"
09/15/2006 11:18:23 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='2'"
09/15/2006 11:18:46 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('3', '6571', 'Running', NOW())"
09/15/2006 11:18:46 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='3'"
09/15/2006 11:20:02 AM - SYSTEM STATS: Time:1.1735 Method:cactid Processes:1 Threads:1 Hosts:6 HostsPerProcess:6 DataSources:608 RRDsProcessed:308
09/15/2006 11:20:29 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('3', '6663', 'Running', NOW())"
09/15/2006 11:20:35 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='3'"
09/15/2006 11:20:53 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('-1', '0', 'Running', NOW())"
09/15/2006 11:20:53 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('2', '6815', 'Running', NOW())"
09/15/2006 11:20:53 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('1', '6813', 'Running', NOW())"
09/15/2006 11:20:53 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('3', '6817', 'Running', NOW())"
09/15/2006 11:20:55 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('0', '6945', 'Running', NOW())"
09/15/2006 11:20:55 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT COUNT(*) FROM mac_track_processes WHERE device_id <> '0'"
09/15/2006 11:20:57 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT count(*) FROM mac_track_processes WHERE device_id > 0"
09/15/2006 11:20:57 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='-1'"
09/15/2006 11:20:57 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed "SELECT * FROM mac_track_processes WHERE device_id = 0"
09/15/2006 11:20:57 AM - SYSTEM MACTRACK STATS: Time:4.0599 ConcurrentProcesses:7 Devices:3
09/15/2006 11:20:57 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='3'"
09/15/2006 11:20:58 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='0'"
09/15/2006 11:21:43 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='2'"
09/15/2006 11:22:28 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='1'"

Cheers,

Farhan

[cigamit]

Looks like your missing the mac_track_processes table from the database, re-import the SQL file, and also run the database_upgrade.php script.

[farhan]

Hello cigamit,

I ran database_upgrade.php and whole thing screwed up. Luckily I have had

backup ); After running database upgrade script when I run poller_mactrack.php

check following output.


DEBUG: About to enter MacTrack poller processing
DEBUG: Into Processing. Checking to determine if it's time to run.
DEBUG: Checking if user changed the start time
DEBUG: Checking if user changed the maintenance time
DEBUG: The next run time has been determined to be at '2006-09-20 21:15:13'
DEBUG: The next database maintenance run time has been determined to be at '2006-09-20 0:50:00'
DEBUG: Either a scan has been forced, or it's time to check for macs
DEBUG: CMD: /usr/bin/php -q /usr/local/cacti/plugins/mactrack/mactrack_scanner.php -id=1 -d
DEBUG: CMD: /usr/bin/php -q /usr/local/cacti/plugins/mactrack/mactrack_scanner.php -id=2 -d
DEBUG: CMD: /usr/bin/php -q /usr/local/cacti/plugins/mactrack/mactrack_scanner.php -id=3 -d
DEBUG: DNS Resolver process launched
DEBUG: A process cycle launch just completed.
DEBUG: Waiting on 3 to complete prior to exiting.
DEBUG: Waiting on 2 to complete prior to exiting.
DEBUG: Waiting on 2 to complete prior to exiting.
DEBUG: Waiting on 2 to complete prior to exiting.
DEBUG: Waiting on 2 to complete prior to exiting.

Nothing was appearing under MAC/IP report. Without upgrading database,
it is working fine but dumping some errors in cacti.log related mac_track_process table.

Any idea?

[fozzy]

reawakening a dead thread...
same here, sme errors in the logs but the mactrack utility is running fine....

Luca

[blisk]

I have the same problem.
Can someone help please?

Dec 6 17:55:05 Cacti[5359]: CMDPHP: ERROR: SQL Assoc Failed "select * from reports"
Dec 6 17:55:05 Cacti[5411]: CMDPHP: ERROR: SQL Exec Failed "delete from mac_track_processes where start_date < '2006-12-06 17:35:05'"
Dec 6 17:56:01 snmpd[3964]: Connection from UDP: [127.0.0.1]:47471
Dec 6 18:00:02 snmpd[3964]: Connection from UDP: [127.0.0.1]:47472
Dec 6 18:00:02 snmpd[3964]: Received SNMP packet(s) from UDP: [127.0.0.1]:47472
Dec 6 18:00:03 Cacti[5606]: CMDPHP: Host[1] DS[20] WARNING: Result from CMD not valid. Partial Result:

[airwalk]

[blisk]

yes I did, but I get blank white page and nothing happends.

[TheWitness]

That script MUST be run from the command line and not the web site.

TheWitness