Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
I try to install Cacti version 0.8.7 b on a PC (windows 2000) to test before tranfers it to the server windows 2003 (the cacti version 0.8.6.j still works there)
I have copied the cacti database from the 0.8.6 j to the new version, (and also the rrdtool files)
I have a few problems :
1) In the Data input methods option, I do not see more the
Get Script Data (Indexed) Script Query
Get Script Server Data (Indexed) Script Query - Script Server
Get SNMP Data SNMP
Get SNMP Data (Indexed)
I try to add them, it's ok for one more, but it stills limits to 9
Get SNMP Data (Indexed) SNMP Query
Linux - Get Memory Usage Script/Command
Unix - Get Free Disk Space Script/Command
Unix - Get Load Average Script/Command
Unix - Get Logged In Users Script/Command
Unix - Get System Processes Script/Command
Unix - Get TCP Connections Script/Command
Unix - Get Web Hits Script/Command
Unix - Ping Host Script/Command
Is there a patch or a modification to do with the file data_input.php
2) In Data Queries, when I click on one 'date queries', in the list data input method, the followings : Get Script Data (Indexed) and Get Script Server Data (Indexed) are double :
Can I choose the two (or the three) ?
3) When I install PHP version 5.2.3, I had the message "Error in my_thread_global_end(): 1 threads didn't exit" with the php -m , I have replaced the file libmysql.dll by the same but from an other version (5.2.1) ; I have not more the message but can I have other problems with PHP with this change ?
Thanks for your answers,
Last edited by Dom... on Thu Apr 03, 2008 3:37 pm, edited 1 time in total.
1) I've got 39 Data Input Methods in my 0.8.7b installation (carried up from the 0.8.6x upgrade). If you're trying to create a new data input method, and think you're missing some "Input Types", this is on purpose since internal data methods are now hidden.
You've got something else going on.
2) "Get Script Data (Indexed)" and "Get Script Server Data (Indexed)" are two separate types of input methods. Do you have one of those duplicated? If so, there is something majorly wrong with your cacti db.
3) I'd recommend trying the latest version of php. Then if you still get that error, try the older libmysql file. Just be warned, it can have unknown consequences. This isn't a cacti related problem anyways; more of php and windows.
4) Did/do you have the plugin arch installed? That could be causing some of your problems...
BSOD2600 wrote:1) I've got 39 Data Input Methods in my 0.8.7b installation (carried up from the 0.8.6x upgrade). If you're trying to create a new data input method, and think you're missing some "Input Types", this is on purpose since internal data methods are now hidden.
You've got something else going on.
2) "Get Script Data (Indexed)" and "Get Script Server Data (Indexed)" are two separate types of input methods. Do you have one of those duplicated? If so, there is something majorly wrong with your cacti db.
3) I'd recommend trying the latest version of php. Then if you still get that error, try the older libmysql file. Just be warned, it can have unknown consequences. This isn't a cacti related problem anyways; more of php and windows.
4) Did/do you have the plugin arch installed? That could be causing some of your problems...
Thanks for your answers.
1) It's ok , for other input data methods, it works (the "problem" is only for the internal data method that are not displayed)
2) I have replaced again the caci database, and it is not more replicated (Get ...)
3) I have installed php 5.2.5 but same problem (so I have replace again by the file from version 5.2.1) I hope that will not cause problems
4) Not yet
I have another problem with the 0.8.7.b version.
I see devices in status 'down' (they are up in the version 0.8.6j and the ping is ok < 50 ms)
The options are however the same :
Host Availability Settings
Downed Host Detection : Ping and SNMP
Ping Type : ICMP type
Ping Port : 23
Ping Timeout Value : 400
Ping Retry Count : 1
General
Enabled : ok
Poller Type : cmd.php
Poller Interval : 1'
Cron Interval : 1'
Maximum Concurrent Poller Processes : 1
The log file :
03/28/2008 11:32:02 AM - SYSTEM STATS: Time:1.2877 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0
03/28/2008 11:32:01 AM - POLLER: Poller[0] NOTE: There are no items in your poller for this polling cycle!
03/28/2008 11:32:01 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php.exe, ARGS: -q c:/cacti/cmd.php 0 2
03/28/2008 11:32:01 AM - POLLER: Poller[0] NOTE: Poller Int: '60', Scheduled Task Int: '60', Time Since Last: '60', Max Runtime '58', Poller Runs: '1'
03/28/2008 11:32:02 AM - SYSTEM STATS: Time:1.2877 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0
03/28/2008 11:32:01 AM - POLLER: Poller[0] NOTE: There are no items in your poller for this polling cycle!
03/28/2008 11:31:01 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php.exe, ARGS: -q c:/cacti/cmd.php 0 2
03/28/2008 11:31:01 AM - POLLER: Poller[0] NOTE: Poller Int: '60', Scheduled Task Int: '60', Time Since Last: '60', Max Runtime '58', Poller Runs: '1'
Update :
03/28/2008 11:53:01 AM - CMDPHP: Poller[0] Host[2] PING: Cannot connect to host
03/28/2008 11:53:01 AM - CMDPHP: Poller[0] Time: 0.0427 s, Theads: N/A, Hosts: 2
Did you notice the following in the debug log? There are no items in your poller for this polling cycle!
That is obviously a big problem. Also, I don't see anything in there about cacti attempting to determine the up/down status of the devices.
You do know that with 0.8.7, Host Availability has moved to per-device.
Your use of 1 min polling could possibly be part of the problem. while other polling intervals than 5 min are in 0.8.7, the devs recommend most users hold off implementing it until 0.8.8 when it's more refined, FYI.
BSOD2600 wrote:Did you notice the following in the debug log? There are no items in your poller for this polling cycle!
That is obviously a big problem. Also, I don't see anything in there about cacti attempting to determine the up/down status of the devices.
You do know that with 0.8.7, Host Availability has moved to per-device.
Your use of 1 min polling could possibly be part of the problem. while other polling intervals than 5 min are in 0.8.7, the devs recommend most users hold off implementing it until 0.8.8 when it's more refined, FYI.
For the polling cycle, I have not put the lines in blue colour (sql, ...), it was perhaps the problem.
I think it works now, I have selected in a device (that had the status 'down')
Availabilty/Reachability Options :
a) Downed Device Detection : SNMP (instead of 'ping and SNMP')
When I chose options 'ping' or 'ping and SNMP' , the status is again 'down' (I do not think a ping is launched ?) I don't see where is the problem ?
In 'data in input methods' I see the script : Unix - Ping Host. Is it necessary to do something with this script ?
b) Ping Timeout Value : 400
c) Ping Retry Count : 10
For this device (a nortel switch) the polling 1 min of 1 port works now.
Is it necessary to put all to 5 minutes ?
Just a note on this to avoid confusion, the data input methods that you identified early on here are what I refer to as "system" data input methods. They have been hidden from the user in this latest version of Cacti. So, even though they do not show up, they are there.
As far as your polling is concerned, it may have everything to do with your mysql change. The best way to understand what is going on with the poller is to run it, actually cmd.php, in debug mode.
TheWitness
True understanding begins only when we realize how little we truly understand...
I have still this problem if I select the 'ping' (or snmp and ping).
For example, I have added a new device today (the others are with the option 'snmp' and are in status 'up') with the option 'ping and snmp' to test again, but the status is 'down' immediately and 'up' (after recovery) if I change to 'snmp'
Do you have an idea why ? (in version 0.8.6j all the devices are in 'ping and snmp' and it works without problems.
Thanks
What ping method are you using? I'd suggest icmp for windows. Does the problem box(es) respond to pings when you manually try it from the command prompt?
Enables : select
Poller type : cmd.php
Poller Interval : every 5 minutes (I change it)
Cron Interval : every 5 mintues
Maximum Concurrent Polsler Process : 1 (I have changed to 2 to try but no change in the status)
When I select this device and Click on 'choose an action' change availability options, I have
Downed Devide Detection : Ping and SNMP
Ping Timeout Value : 400
Ping Retry Count : 1
The debug lines for 1 cycle :
04/03/2008 11:31:51 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
04/03/2008 11:31:51 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM plugin_realms"
04/03/2008 11:31:51 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
04/03/2008 11:31:51 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
04/03/2008 11:31:51 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'draw_navigation_text'"
04/03/2008 11:31:51 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_header_tabs'"
04/03/2008 11:31:51 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_head'"
04/03/2008 11:31:51 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_title'"
04/03/2008 11:31:51 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_header'"
04/03/2008 11:31:51 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
04/03/2008 11:31:51 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
04/03/2008 11:31:51 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'auth_alternate_realms'"
04/03/2008 11:31:51 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
04/03/2008 11:31:51 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_form'"
04/03/2008 11:31:51 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'valid_host_fields'"
04/03/2008 11:31:51 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_settings'"
04/03/2008 11:31:51 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM plugin_realms"
04/03/2008 11:31:51 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
04/03/2008 11:31:35 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
04/03/2008 11:31:35 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM plugin_realms"
04/03/2008 11:31:35 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
04/03/2008 11:31:35 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
04/03/2008 11:31:35 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'draw_navigation_text'"
04/03/2008 11:31:35 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_header_tabs'"
04/03/2008 11:31:35 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_head'"
04/03/2008 11:31:35 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_title'"
04/03/2008 11:31:35 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_header'"
04/03/2008 11:31:35 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
04/03/2008 11:31:35 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
04/03/2008 11:31:35 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'auth_alternate_realms'"
04/03/2008 11:31:35 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
04/03/2008 11:31:35 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_form'"
04/03/2008 11:31:35 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'valid_host_fields'"
04/03/2008 11:31:35 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_settings'"
04/03/2008 11:31:35 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM plugin_realms"
04/03/2008 11:31:35 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
04/03/2008 11:31:14 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
04/03/2008 11:31:14 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM plugin_realms"
04/03/2008 11:31:14 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
04/03/2008 11:31:14 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
04/03/2008 11:31:14 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'draw_navigation_text'"
04/03/2008 11:31:14 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_header_tabs'"
04/03/2008 11:31:14 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_head'"
04/03/2008 11:31:14 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_title'"
04/03/2008 11:31:14 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_header'"
04/03/2008 11:31:14 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
04/03/2008 11:31:14 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
04/03/2008 11:31:14 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'auth_alternate_realms'"
04/03/2008 11:31:14 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
04/03/2008 11:31:14 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_form'"
04/03/2008 11:31:14 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'valid_host_fields'"
04/03/2008 11:31:14 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_settings'"
04/03/2008 11:31:14 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM plugin_realms"
04/03/2008 11:31:14 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'poller_bottom'"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:1.8887 Method:cmd.php Processes:4 Threads:N/A Hosts:4 HostsPerProcess:1 DataSources:6 RRDsProcessed:1')"
04/03/2008 11:31:03 AM - SYSTEM STATS: Time:1.8887 Method:cmd.php Processes:4 Threads:N/A Hosts:4 HostsPerProcess:1 DataSources:6 RRDsProcessed:1
04/03/2008 11:31:03 AM - POLLER: Poller[0] CACTI2RRD: c:/cacti/rrdtool.exe update C:\cacti\rra\router-labo_traffic_in_8.rrd --template traffic_in:traffic_out 1207215063:1894917923:1021216134
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'poller_on_demand'"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'poller_output'"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='8' and rrd_name='traffic_out' and time='2008-04-03 11:31:03'"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='8' and rrd_name='traffic_in' and time='2008-04-03 11:31:03'"
04/03/2008 11:31:03 AM - 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) "
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] Time: 0.1550 s, Theads: N/A, Hosts: 1
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (8, 'traffic_in', '2008-04-03 11:31:03', '1894917923')"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] Host[3] DS[8] SNMP: v1: 147.93.224.254, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.51, output: 1894917923
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] Time: 0.0201 s, Theads: N/A, Hosts: 1
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update host set status = '1', status_event_count = '52', status_fail_date = '0000-00-00 00:00:00', status_rec_date = '0000-00-00 00:00:00', status_last_error = 'SNMP not performed due to setting or ping result., Cannot connect to host', min_time = '9.99999', max_time = '0.00000', cur_time = '0.00000', avg_time = '0.00000', total_polls = '53', failed_polls = '53', availability = '0' where hostname = '147.93.214.189'"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] Host[5] SNMP: SNMP not performed due to setting or ping result.
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] Host[5] PING: Cannot connect to host
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_step - 300 WHERE (rrd_next_step < 0 AND host_id >= 5 AND host_id <= 5)"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_next_step - 300 WHERE (host_id >= 5 AND host_id <= 5)"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) FROM poller_item WHERE (action=2 AND host_id >= 5 AND host_id <= 5 AND rrd_next_step <= 0)"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM poller_item WHERE (host_id >= 5 AND host_id <= 5 AND rrd_next_step <= 0) ORDER by host_id"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (8, 'traffic_out', '2008-04-03 11:31:03', '1021216134')"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] Host[3] DS[8] SNMP: v1: 147.93.224.254, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.51, output: 1021216134
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: " SELECT * FROM host WHERE (disabled = '' AND id >= 5 AND id <= 5) ORDER by id"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='1095456972' where host_id='3' and data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0'"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_form'"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'valid_host_fields'"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] Host[3] RECACHE: Processing 1 items in the auto reindex cache for '147.93.224.254'.
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_reindex.data_query_id, poller_reindex.action, poller_reindex.op, poller_reindex.assert_value, poller_reindex.arg1 from poller_reindex where poller_reindex.host_id=3"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_settings'"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM plugin_realms"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update host set status = '3', status_event_count = '0', status_fail_date = '0000-00-00 00:00:00', status_rec_date = '2008-04-02 11:01:03', status_last_error = 'Host did not respond to SNMP', min_time = '9.99999', max_time = '697.65000', cur_time = '33.11', avg_time = '57.634022692308', total_polls = '107', failed_polls = '3', availability = '97.196261682243' where hostname = '147.93.224.254'"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] Host[3] SNMP: Host responded to SNMP
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_step - 300 WHERE (rrd_next_step < 0 AND host_id >= 3 AND host_id <= 3)"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_next_step - 300 WHERE (host_id >= 3 AND host_id <= 3)"
04/03/2008 11:31:03 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) FROM poller_item WHERE (action=2 AND host_id >= 3 AND host_id <= 3 AND rrd_next_step <= 0)"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM poller_item WHERE (host_id >= 3 AND host_id <= 3 AND rrd_next_step <= 0) ORDER by host_id"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: " SELECT * FROM host WHERE (disabled = '' AND id >= 3 AND id <= 3) ORDER by id"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_form'"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'valid_host_fields'"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_settings'"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM plugin_realms"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
04/03/2008 11:31:02 AM - POLLER: Poller[0] NOTE: There are no items in your poller for this polling cycle!
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_step - 300 WHERE (rrd_next_step < 0 AND host_id >= 1 AND host_id <= 1)"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_next_step - 300 WHERE (host_id >= 1 AND host_id <= 1)"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) FROM poller_item WHERE (action=2 AND host_id >= 1 AND host_id <= 1 AND rrd_next_step <= 0)"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM poller_item WHERE (host_id >= 1 AND host_id <= 1 AND rrd_next_step <= 0) ORDER by host_id"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: " SELECT * FROM host WHERE (disabled = '' AND id >= 1 AND id <= 1) ORDER by id"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_form'"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'valid_host_fields'"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_settings'"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM plugin_realms"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
04/03/2008 11:31:02 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php.exe, ARGS: -q c:/cacti/cmd.php 5 5]
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
04/03/2008 11:31:02 AM - POLLER: Poller[0] NOTE: There are no items in your poller for this polling cycle!
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_step - 300 WHERE (rrd_next_step < 0 AND host_id >= 0 AND host_id <= 0)"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_next_step - 300 WHERE (host_id >= 0 AND host_id <= 0)"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) FROM poller_item WHERE (action=2 AND host_id >= 0 AND host_id <= 0 AND rrd_next_step <= 0)"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM poller_item WHERE (host_id >= 0 AND host_id <= 0 AND rrd_next_step <= 0) ORDER by host_id"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: " SELECT * FROM host WHERE (disabled = '' AND id >= 0 AND id <= 0) ORDER by id"
04/03/2008 11:31:02 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php.exe, ARGS: -q c:/cacti/cmd.php 3 3]
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_form'"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'valid_host_fields'"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_settings'"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM plugin_realms"
04/03/2008 11:31:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
04/03/2008 11:31:02 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php.exe, ARGS: -q c:/cacti/cmd.php 1 1]
04/03/2008 11:31:01 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php.exe, ARGS: -q c:/cacti/cmd.php 0 0]
04/03/2008 11:31:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'poller_command_args'"
04/03/2008 11:31:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT local_data_id, rrd_name FROM poller_output"
04/03/2008 11:31:01 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "TRUNCATE TABLE poller_time"
04/03/2008 11:31:01 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','c:/cacti')"
04/03/2008 11:31:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
04/03/2008 11:31:01 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('poller_lastrun',1207215061)"
04/03/2008 11:31:01 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Scheduled Task Int: '300', Time Since Last: '300', Max Runtime '298', Poller Runs: '1'
Last edited by Dom... on Thu Apr 03, 2008 2:19 pm, edited 1 time in total.
It works now.
In fact, I used a 'scheduled task' (php c:\cacti\poller.php) with an account other than I use to log in windows . Perhaps this account could not launch the ping (it worked with snmp)
I will try the other solution of your note :
"
Use a windows script to hide the command windows. Only do this after your cacti installation is fully functional!
Create a file called invisible.vbs. Place it where ever you like.
Edit invisible.vbs and paste the following
Set objWSHShell = WScript.CreateObject("WScript.Shell")objWSHShell.Run "poller.php", 0, False
Edit the Cacti scheduled task and change the Run to:
