Problems polling with cactid

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

Post Reply
Masamune
Posts: 7
Joined: Sat Feb 04, 2006 7:36 am
Location: Germany

Problems polling with cactid

Post by Masamune »

I'm using
- MySQL 5.0.18
- Apache 2.2.0
- PHP 5.1.1
- cacti 0.8.6h with patches
- cactid 0.8.6g
- RRDTool cygwin 1.2.12

but i can not poll my Switch with the cactid (cmd.php works)

Poller.php prints out the following Messages:
02/04/2006 01:32:18 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces
s [CMD: C:/cactid/cactid.exe, ARGS: 0 2]
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
^C

The cacti.log contains:
02/04/2006 01:32:18 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item"
02/04/2006 01:32:18 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
02/04/2006 01:32:18 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','c:/xampp/htdocs/cacti')"
02/04/2006 01:32:18 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_time"
02/04/2006 01:32:18 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: C:/cactid/cactid.exe, ARGS: 0 2]
02/04/2006 01:32:20 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
02/04/2006 01:32:20 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
02/04/2006 01:32:20 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)"
02/04/2006 01:32:21 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
02/04/2006 01:32:21 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)"
02/04/2006 01:32:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
02/04/2006 01:32:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)"
02/04/2006 01:32:23 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
02/04/2006 01:32:23 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)"
02/04/2006 01:32:24 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
02/04/2006 01:32:24 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)"
02/04/2006 01:32:25 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
02/04/2006 01:32:25 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)"
02/04/2006 01:32:26 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
02/04/2006 01:32:26 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)"
02/04/2006 01:32:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
02/04/2006 01:32:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)"
02/04/2006 01:32:28 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
02/04/2006 01:32:28 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)"
02/04/2006 01:32:29 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
02/04/2006 01:32:29 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)"
02/04/2006 01:32:30 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
02/04/2006 01:32:30 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)"
02/04/2006 01:32:31 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
02/04/2006 01:32:31 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)"
02/04/2006 01:32:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
02/04/2006 01:32:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)"

I have to monitor the Traffic at approximately 1000 LAN Ports, so cactid is necessary. Do you need any other logfiles or information?

If i made any mistakes: sorry for my english :)
Top
User avatar
TheWitness
Developer
Posts: 17064
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Post by TheWitness »

1) Turn off your scheduled task
2) Set logging to DEBUG
3) Open a shell and CD to the Cactid binary directory
4) Run "./cactid"
5) Post output.

Thanks,

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
Masamune
Posts: 7
Joined: Sat Feb 04, 2006 7:36 am
Location: Germany

Post by Masamune »

Tnx for your help!

CACTID: Using cactid config file [cactid.conf]
CACTID: MYSQL: Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Top
User avatar
TheWitness
Developer
Posts: 17064
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Post by TheWitness »

Please either change from "localhost" to the IP or hostname in your cactid.conf file. Then, make sure that the user has privileges from either the IP or hostname from mysql and your problem will be solved.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
Masamune
Posts: 7
Joined: Sat Feb 04, 2006 7:36 am
Location: Germany

Post by Masamune »

It works :) Tnx for your fast help!
Top
kbartoletta
Cacti User
Posts: 146
Joined: Tue Oct 04, 2005 4:20 pm
Location: suwanee, ga
Contact:
Contact kbartoletta

Post by kbartoletta »

Witness,

Is your above suggestion, is this just for DB running remotely... my db is on my cactid box.. i am seeing similiar issues - i just tried to upgrade to cactid...

Not sure what you meant by
Then, make sure that the user has privileges from either the IP or hostname from mysql and your problem will be solved.
can you elaborate...?

Also, i installed cactid from the RPM, are the prereqs already included or do i need to install the prereqs that are mentioned in the compiling instructions...?
Top
kbartoletta
Cacti User
Posts: 146
Joined: Tue Oct 04, 2005 4:20 pm
Location: suwanee, ga
Contact:
Contact kbartoletta

Post by kbartoletta »

In debug mode, it appears that I am connecting to the DB...

[root@qualrrd01 bin]# ./cactid
CACTID: Using cactid config file [/etc/cactid.conf]
CACTID: DEBUG: MySQL Query ID '1': 'SELECT value FROM settings WHERE name = 'path_webroot''
CACTID: DEBUG: MySQL Query ID '1': OK
CACTID: DEBUG: MySQL Query ID '2': 'SELECT value FROM settings WHERE name = 'path_cactilog''
CACTID: DEBUG: MySQL Query ID '2': OK
CACTID: DEBUG: The path_php_server variable is /var/www/html/cacti/script_server.php
CACTID: DEBUG: The path_cactilog variable is /var/www/html/cacti/log/cacti.log
CACTID: DEBUG: MySQL Query ID '3': 'SELECT value FROM settings WHERE name = 'log_destination''
CACTID: DEBUG: MySQL Query ID '3': OK
CACTID: DEBUG: The log_destination variable is 1 (FILE)
CACTID: DEBUG: MySQL Query ID '4': 'SELECT value FROM settings WHERE name = 'path_php_binary''
CACTID: DEBUG: MySQL Query ID '4': OK
CACTID: DEBUG: The path_php variable is /usr/bin/php
CACTID: DEBUG: MySQL Query ID '5': 'SELECT value FROM settings WHERE name = 'availability_method''
CACTID: DEBUG: MySQL Query ID '5': OK
CACTID: DEBUG: The availability_method variable is 2
CACTID: DEBUG: MySQL Query ID '6': 'SELECT value FROM settings WHERE name = 'ping_recovery_count''
CACTID: DEBUG: MySQL Query ID '6': OK
CACTID: DEBUG: The ping_recovery_count variable is 3
CACTID: DEBUG: MySQL Query ID '7': 'SELECT value FROM settings WHERE name = 'ping_failure_count''
CACTID: DEBUG: MySQL Query ID '7': OK
CACTID: DEBUG: The ping_failure_count variable is 3
CACTID: DEBUG: MySQL Query ID '8': 'SELECT value FROM settings WHERE name = 'ping_method''
CACTID: DEBUG: MySQL Query ID '8': OK
CACTID: DEBUG: The ping_method variable is 2
CACTID: DEBUG: MySQL Query ID '9': 'SELECT value FROM settings WHERE name = 'ping_retries''
CACTID: DEBUG: MySQL Query ID '9': OK
CACTID: DEBUG: The ping_retries variable is 1
CACTID: DEBUG: MySQL Query ID '10': 'SELECT value FROM settings WHERE name = 'ping_timeout''
CACTID: DEBUG: MySQL Query ID '10': OK
CACTID: DEBUG: The ping_timeout variable is 1000
CACTID: DEBUG: MySQL Query ID '11': 'SELECT value FROM settings WHERE name = 'log_perror''
CACTID: DEBUG: MySQL Query ID '11': OK
CACTID: DEBUG: The log_perror variable is 1
CACTID: DEBUG: MySQL Query ID '12': 'SELECT value FROM settings WHERE name = 'log_pwarn''
CACTID: DEBUG: MySQL Query ID '12': OK
CACTID: DEBUG: The log_pwarn variable is 1
CACTID: DEBUG: MySQL Query ID '13': 'SELECT value FROM settings WHERE name = 'log_pstats''
CACTID: DEBUG: MySQL Query ID '13': OK
CACTID: DEBUG: The log_pstats variable is 1
CACTID: DEBUG: MySQL Query ID '14': 'SELECT value FROM settings WHERE name = 'max_threads''
CACTID: DEBUG: MySQL Query ID '14': OK
CACTID: DEBUG: The threads variable is 1
CACTID: DEBUG: MySQL Query ID '15': 'SELECT value FROM settings WHERE name = 'poller_interval''
CACTID: DEBUG: MySQL Query ID '15': OK
CACTID: DEBUG: The polling interval is the system default
CACTID: DEBUG: MySQL Query ID '16': 'SELECT value FROM settings WHERE name = 'concurrent_processes''
CACTID: DEBUG: MySQL Query ID '16': OK
CACTID: DEBUG: The number of concurrent processes is 1
CACTID: DEBUG: MySQL Query ID '17': 'SELECT value FROM settings WHERE name = 'script_timeout''
CACTID: DEBUG: MySQL Query ID '17': OK
CACTID: DEBUG: The script timeout is 25
CACTID: DEBUG: MySQL Query ID '18': 'SELECT value FROM settings WHERE name = 'php_servers''
CACTID: DEBUG: MySQL Query ID '18': OK
CACTID: DEBUG: The number of php script servers to run is 2
CACTID: DEBUG: MySQL Query ID '19': 'SELECT action FROM poller_item WHERE action=2 LIMIT 1'
CACTID: DEBUG: MySQL Query ID '19': OK
CACTID: DEBUG: StartHost='-1', EndHost='-1', TotalPHPScripts='1'
CACTID: DEBUG: The PHP Script Server is Required
CACTID: DEBUG: MySQL Query ID '20': 'SELECT value FROM settings WHERE name = 'max_get_size''
CACTID: DEBUG: MySQL Query ID '20': OK
CACTID: DEBUG: The Maximum SNMP OID Get Size is 10
CACTID: CACTID: Version 0.8.6f starting
CACTID: MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
CACTID: MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
CACTID: CACTID: Initializing Net-SNMP API
CACTID: CACTID: Initializing PHP Script Server
CACTID: DEBUG: SS[0] PHP Script Server Routine Starting
CACTID: DEBUG: SS[0] PHP Script Server About to FORK Child Process
CACTID: DEBUG: SS[0] PHP Script Server Child FORK Success
CACTID: DEBUG: SS[0] Confirmed PHP Script Server running
CACTID: DEBUG: SS[1] PHP Script Server Routine Starting
CACTID: DEBUG: SS[1] PHP Script Server About to FORK Child Process
CACTID: DEBUG: SS[1] PHP Script Server Child FORK Success
CACTID: DEBUG: SS[1] Confirmed PHP Script Server running
CACTID: DEBUG: MySQL Query ID '21': 'SELECT id FROM host WHERE disabled='' ORDER BY id'
CACTID: DEBUG: MySQL Query ID '21': OK
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: MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
CACTID: DEBUG: MySQL Query ID '22': 'SELECT action,hostname,snmp_community,snmp_version,snmp_username,snmp_password,rrd_name,rrd_path,arg1,arg2,arg3,local_data_id,rrd_num,snmp_port,snmp_timeout FROM poller_item WHERE host_id=0 ORDER BY arg1'
CACTID: DEBUG: MySQL Query ID '22': OK
CACTID: Host[0] DEBUG: The POPEN returned the following File Descriptor 10
Error in packet
Reason: (noSuchName) There is no such variable name in this MIB.
Failed object: SNMPv2-SMI::enterprises.9.2.1.58.0

CACTID: Host[0] DS[988] WARNING: Result from SCRIPT not valid. Partial Result: cpu_util_5...
CACTID: Host[0] DS[988] SCRIPT: /usr/bin/perl /var/www/html/cacti/scripts/cisco_2900_IOS_stats.pl, output: U
CACTID: Host[0] DEBUG: The POPEN returned the following File Descriptor 10
Error in packet
Reason: (noSuchName) There is no such variable name in this MIB.
Failed object: SNMPv2-SMI::enterprises.9.2.1.58.0

CACTID: Host[0] DS[1607] WARNING: Result from SCRIPT not valid. Partial Result: cpu_util_5...
CACTID: Host[0] DS[1607] SCRIPT: /usr/bin/perl /var/www/html/cacti/scripts/cisco_2900_IOS_stats.pl, output: U
CACTID: DEBUG: MySQL Insert ID '0': 'INSERT INTO poller_output (local_data_id,rrd_name,time,output) VALUES (988,'','2006-02-08 22:36:54','U'),(1607,'','2006-02-08 22:36:54','U')'
CACTID: DEBUG: MySQL Insert ID '0': OK
CACTID: Host[0] 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: MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
CACTID: DEBUG: MySQL Query ID '23': 'SELECT id, hostname,snmp_community,snmp_username,snmp_password,snmp_version,snmp_port,snmp_timeout,status,status_event_count,status_fail_date,status_rec_date,status_last_error,min_time,max_time,cur_time,avg_time,total_polls,failed_polls,availability FROM host WHERE id=1'
CACTID: DEBUG: MySQL Query ID '23': OK
CACTID: Host[1] SNMP Result: Host did not respond to SNMP
CACTID: DEBUG: MySQL Insert ID '1': 'update host set status='1',status_event_count='20', status_fail_date='2006-02-08 19:45:00',status_rec_date='2005-11-22 06:20:02',status_last_error='Host did not respond to SNMP',min_time='0.000000',max_time='999.999990',cur_time='56.170000',avg_time='58.591830',total_polls='29678',failed_polls='33',availability='99.8888' where id='1''
CACTID: DEBUG: MySQL Insert ID '1': OK
CACTID: DEBUG: MySQL Query ID '24': 'SELECT action,hostname,snmp_community,snmp_version,snmp_username,snmp_password,rrd_name,rrd_path,arg1,arg2,arg3,local_data_id,rrd_num,snmp_port,snmp_timeout FROM poller_item WHERE host_id=1 ORDER BY arg1'
CACTID: DEBUG: MySQL Query ID '24': OK
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: MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
CACTID: DEBUG: MySQL Query ID '25': 'SELECT id, hostname,snmp_community,snmp_username,snmp_password,snmp_version,snmp_port,snmp_timeout,status,status_event_count,status_fail_date,status_rec_date,status_last_error,min_time,max_time,cur_time,avg_time,total_polls,failed_polls,availability FROM host WHERE id=2'
CACTID: DEBUG: MySQL Query ID '25': OK
CACTID: Host[2] SNMP Result: Host did not respond to SNMP
CACTID: DEBUG: MySQL Insert ID '2': 'update host set status='1',status_event_count='7488', status_fail_date='2006-01-13 04:00:14',status_rec_date='2006-01-12 04:10:07',status_last_error='Host did not respond to SNMP',min_time='9.999990',max_time='999.999990',cur_time='54.130000',avg_time='62.386130',total_polls='29675',failed_polls='7554',availability='74.5442' where id='2''
CACTID: DEBUG: MySQL Insert ID '2': OK
CACTID: DEBUG: MySQL Query ID '26': 'SELECT action,hostname,snmp_community,snmp_version,snmp_username,snmp_password,rrd_name,rrd_path,arg1,arg2,arg3,local_data_id,rrd_num,snmp_port,snmp_timeout FROM poller_item WHERE host_id=2 ORDER BY arg1'
CACTID: DEBUG: MySQL Query ID '26': OK
CACTID: Host[2] 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: MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
CACTID: DEBUG: MySQL Query ID '27': 'SELECT id, hostname,snmp_community,snmp_username,snmp_password,snmp_version,snmp_port,snmp_timeout,status,status_event_count,status_fail_date,status_rec_date,status_last_error,min_time,max_time,cur_time,avg_time,total_polls,failed_polls,availability FROM host WHERE id=3'
CACTID: DEBUG: MySQL Query ID '27': OK
CACTID: Host[3] SNMP Result: Host did not respond to SNMP
CACTID: DEBUG: MySQL Insert ID '3': 'update host set status='1',status_event_count='20', status_fail_date='2006-02-08 19:46:00',status_rec_date='2005-10-25 07:15:05',status_last_error='Host did not respond to SNMP',min_time='9.999990',max_time='999.999990',cur_time='61.690000',avg_time='103.754030',total_polls='29436',failed_polls='39',availability='99.8675' where id='3''
CACTID: DEBUG: MySQL Insert ID '3': OK
CACTID: DEBUG: MySQL Query ID '28': 'SELECT action,hostname,snmp_community,snmp_version,snmp_username,snmp_password,rrd_name,rrd_path,arg1,arg2,arg3,local_data_id,rrd_num,snmp_port,snmp_timeout FROM poller_item WHERE host_id=3 ORDER BY arg1'
CACTID: DEBUG: MySQL Query ID '28': OK
CACTID: Host[3] 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: MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
CACTID: DEBUG: MySQL Query ID '29': 'SELECT id, hostname,snmp_community,snmp_username,snmp_password,snmp_version,snmp_port,snmp_timeout,status,status_event_count,status_fail_date,status_rec_date,status_last_error,min_time,max_time,cur_time,avg_time,total_polls,failed_polls,availability FROM host WHERE id=4'
CACTID: DEBUG: MySQL Query ID '29': OK
CACTID: Host[4] SNMP Result: Host did not respond to SNMP
CACTID: DEBUG: MySQL Insert ID '4': 'update host set status='1',status_event_count='20', status_fail_date='2006-02-08 19:46:00',status_rec_date='2005-10-25 07:15:05',status_last_error='Host did not respond to SNMP',min_time='9.999990',max_time='999.999990',cur_time='54.170000',avg_time='97.378910',total_polls='29435',failed_polls='37',availability='99.8743' where id='4''
CACTID: DEBUG: MySQL Insert ID '4': OK
CACTID: DEBUG: MySQL Query ID '30': 'SELECT action,hostname,snmp_community,snmp_version,snmp_username,snmp_password,rrd_name,rrd_path,arg1,arg2,arg3,local_data_id,rrd_num,snmp_port,snmp_timeout FROM poller_item WHERE host_id=4 ORDER BY arg1'
CACTID: DEBUG: MySQL Query ID '30': OK
CACTID: Host[4] 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: MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
CACTID: DEBUG: MySQL Query ID '31': 'SELECT id, hostname,snmp_community,snmp_username,snmp_password,snmp_version,snmp_port,snmp_timeout,status,status_event_count,status_fail_date,status_rec_date,status_last_error,min_time,max_time,cur_time,avg_time,total_polls,failed_polls,availability FROM host WHERE id=5'
CACTID: DEBUG: MySQL Query ID '31': OK
CACTID: Host[5] SNMP Result: Host did not respond to SNMP
CACTID: DEBUG: MySQL Insert ID '5': 'update host set status='1',status_event_count='20', status_fail_date='2006-02-08 19:46:00',status_rec_date='2005-10-25 07:15:05',status_last_error='Host did not respond to SNMP',min_time='9.999990',max_time='999.999990',cur_time='51.490000',avg_time='66.654060',total_polls='29435',failed_polls='32',availability='99.8913' where id='5''
CACTID: DEBUG: MySQL Insert ID '5': OK
CACTID: DEBUG: MySQL Query ID '32': 'SELECT action,hostname,snmp_community,snmp_version,snmp_username,snmp_password,rrd_name,rrd_path,arg1,arg2,arg3,local_data_id,rrd_num,snmp_port,snmp_timeout FROM poller_item WHERE host_id=5 ORDER BY arg1'
CACTID: DEBUG: MySQL Query ID '32': OK
CACTID: Host[5] 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: MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
CACTID: DEBUG: MySQL Query ID '33': 'SELECT id, hostname,snmp_community,snmp_username,snmp_password,snmp_version,snmp_port,snmp_timeout,status,status_event_count,status_fail_date,status_rec_date,status_last_error,min_time,max_time,cur_time,avg_time,total_polls,failed_polls,availability FROM host WHERE id=6'
CACTID: DEBUG: MySQL Query ID '33': OK
CACTID: Host[6] SNMP Result: Host did not respond to SNMP
CACTID: DEBUG: MySQL Insert ID '6': 'update host set status='1',status_event_count='20', status_fail_date='2006-02-08 19:46:00',status_rec_date='0000-00-00 00:00:00',status_last_error='Host did not respond to SNMP',min_time='9.999990',max_time='999.999990',cur_time='56.330000',avg_time='116.915920',total_polls='28557',failed_polls='20',availability='99.9300' where id='6''
CACTID: DEBUG: MySQL Insert ID '6': OK
CACTID: DEBUG: MySQL Query ID '34': 'SELECT action,hostname,snmp_community,snmp_version,snmp_username,snmp_password,rrd_name,rrd_path,arg1,arg2,arg3,local_data_id,rrd_num,snmp_port,snmp_timeout FROM poller_item WHERE host_id=6 ORDER BY arg1'
CACTID: DEBUG: MySQL Query ID '34': OK
CACTID: Host[6] 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: MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
CACTID: DEBUG: MySQL Query ID '35': 'SELECT id, hostname,snmp_community,snmp_username,snmp_password,snmp_version,snmp_port,snmp_timeout,status,status_event_count,status_fail_date,status_rec_date,status_last_error,min_time,max_time,cur_time,avg_time,total_polls,failed_polls,availability FROM host WHERE id=7'
CACTID: DEBUG: MySQL Query ID '35': OK
CACTID: Host[7] SNMP Result: Host did not respond to SNMP
CACTID: DEBUG: MySQL Insert ID '7': 'update host set status='1',status_event_count='20', status_fail_date='2006-02-08 19:46:00',status_rec_date='0000-00-00 00:00:00',status_last_error='Host did not respond to SNMP',min_time='9.999990',max_time='999.999990',cur_time='57.890000',avg_time='90.831570',total_polls='28553',failed_polls='20',availability='99.9300' where id='7''
CACTID: DEBUG: MySQL Insert ID '7': OK
CACTID: DEBUG: MySQL Query ID '36': 'SELECT action,hostname,snmp_community,snmp_version,snmp_username,snmp_password,rrd_name,rrd_path,arg1,arg2,arg3,local_data_id,rrd_num,snmp_port,snmp_timeout FROM poller_item WHERE host_id=7 ORDER BY arg1'
CACTID: DEBUG: MySQL Query ID '36': OK
CACTID: Host[7] 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: MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
CACTID: DEBUG: MySQL Query ID '37': 'SELECT id, hostname,snmp_community,snmp_username,snmp_password,snmp_version,snmp_port,snmp_timeout,status,status_event_count,status_fail_date,status_rec_date,status_last_error,min_time,max_time,cur_time,avg_time,total_polls,failed_polls,availability FROM host WHERE id=8'
CACTID: DEBUG: MySQL Query ID '37': OK
Top
Post Reply

Return to “Help: Windows Specific”

Who is online

Users browsing this forum: No registered users and 2 guests