No graph.. No insert in database

[Samuel2202]

Hi all,

(I'm french so my english isn't very good )
Well..

I have installed cacti on my server... I have make the cron...
I have an acces to the administrator panel but no graph !
I have viewed in my database and :

poller - no insert
poller_command - no insert
poller_output - no insert
poller_reindex - no insert

Can you help-me ??
Thanx!

[gandalf]

Please read through the first link of my sig. If problems persist, please post
Reinhard

[Samuel2202]

Hi,

When I make "/usr/bin/php /cactidir" :
"FATAL: Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'"

I'm sure about user & password... The problem may be that i've moved mysql's socket here : "/databases/var/mysql.sock"...

Can you help me ?

Thanx.

Note: Cacti's administration is connected to database ( i have configure php to mysql socket )

[Samuel2202]

Ok.

It was that... I have modified de adodb-mysql.inc.php file with my socket informations and it works... well I have a problem :
cf:attached file

It's a problem... Tables are truncate every cron...

[Samuel2202]

Hi,

I have modified poller settings.

04/21/2008 12:41:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
04/21/2008 12:41:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','/usr/share/cacti')"
04/21/2008 12:41:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "TRUNCATE TABLE poller_time"
04/21/2008 12:41:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT local_data_id, rrd_name FROM poller_output"
04/21/2008 12:41:02 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php5, ARGS: -q /usr/share/cacti/cmd.php 0 1]
04/21/2008 12:41:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
04/21/2008 12:41:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
04/21/2008 12:41:02 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) LIMIT 10000"
04/21/2008 12:41:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: " SELECT * FROM host WHERE (disabled = '' AND id >= 0 AND id <= 1) ORDER by id"
04/21/2008 12:41:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM poller_item WHERE (host_id >= 0 AND host_id <= 1 AND rrd_next_step <= 0) ORDER by host_id"
04/21/2008 12:41:02 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) FROM poller_item WHERE (action=2 AND host_id >= 0 AND host_id <= 1 AND rrd_next_step <= 0)"
04/21/2008 12:41:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_next_step - 60 WHERE (host_id >= 0 AND host_id <= 1)"
04/21/2008 12:41:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_step - 60 WHERE (rrd_next_step < 0 AND host_id >= 0 AND host_id <= 1)"
04/21/2008 12:41:02 PM - POLLER: Poller[0] NOTE: There are no items in your poller for this polling cycle!
04/21/2008 12:41:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
04/21/2008 12:41:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
04/21/2008 12:41:03 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) "
04/21/2008 12:41:03 PM - SYSTEM STATS: Time:1.1580 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:5 RRDsProcessed:0
04/21/2008 12:41:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:1.1580 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:5 RRDsProcessed:0')"
04/21/2008 12:41:03 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"

[Samuel2202]

Is there anybody here???