Data Source not polled (not in the table poller_item)

[mbernardino]

Hello,

I have just started with cacti. I had configured the some new servers without problems.
But now, I cannot generate new rrd files. I can configure new data sources, but the rrd files are not created.
When I create manually the rrd file it is not polled.

As far as I could check, the point is that the new data source is not into the table poller_item. So it is not created/polled.

Here is an example: ( host_id= 174; data source id= id=2888)

smysql> select * from data_local where host_id = 174;
+------+------------------+---------+---------------+------------+
| id | data_template_id | host_id | snmp_query_id | snmp_index |
+------+------------------+---------+---------------+------------+
| 2620 | 32 | 174 | 0 | |
| 2621 | 31 | 174 | 0 | |
| 2622 | 41 | 174 | 1 | 2 |
| 2619 | 30 | 174 | 0 | |
| 2618 | 5 | 174 | 0 | |
| 2617 | 4 | 174 | 0 | |
| 2616 | 6 | 174 | 0 | |
| 2888 | 48 | 174 | 0 | |
+------+------------------+---------+---------------+------------+


So, the host_id=174 has the data source 2888 (and others ... that are working)

This data source is active:

mysql> SELECT local_data_id,t_name, name, t_active, active from data_template_data where local_data_id=2888 ;
k+---------------+--------+----------------------+----------+--------+
| local_data_id | t_name | name | t_active | active |
+---------------+--------+----------------------+----------+--------+
| 2888 | NULL | |host_description| - | NULL | on |
+---------------+--------+----------------------+----------+--------+


But it is not into the table poller_item, so it is not pooled and the rrd files are not create/updated:

mysql> select local_data_id, host_id, hostname, rrd_name, rrd_path, rrd_num from poller_item where host_id=174;
+---------------+---------+--------------+-------------+--------------------------------------------------+---------+
| local_data_id | host_id | hostname | rrd_name | rrd_path | rrd_num |
+---------------+---------+--------------+-------------+--------------------------------------------------+---------+
| 2616 | 174 | 10.254.21.71 | cpu_nice | /usr/share/cacti/rra/xmlgwq1_cpu_nice_2616.rrd | 1 |
| 2617 | 174 | 10.254.21.71 | cpu_system | /usr/share/cacti/rra/xmlgwq1_cpu_system_2617.rrd | 1 |
| 2618 | 174 | 10.254.21.71 | cpu_user | /usr/share/cacti/rra/xmlgwq1_cpu_user_2618.rrd | 1 |
| 2619 | 174 | 10.254.21.71 | load_1min | /usr/share/cacti/rra/xmlgwq1_load_1min_2619.rrd | 1 |
| 2620 | 174 | 10.254.21.71 | load_15min | /usr/share/cacti/rra/xmlgwq1_load_15min_2620.rrd | 1 |
| 2621 | 174 | 10.254.21.71 | load_5min | /usr/share/cacti/rra/xmlgwq1_load_5min_2621.rrd | 1 |
| 2622 | 174 | 10.254.21.71 | traffic_in | /usr/share/cacti/rra/xmlgwq1_traffic_in_2622.rrd | 2 |
| 2622 | 174 | 10.254.21.71 | traffic_out | /usr/share/cacti/rra/xmlgwq1_traffic_in_2622.rrd | 2 |
+---------------+---------+--------------+-------------+--------------------------------------------------+---------+

I have already check the BD and all the tables are OK.

I am using:
Cacti Version 0.8.7g
Cacti OS unix
SNMP Version NET-SNMP version: 5.4.1
RRDTool Version RRDTool 1.4.x
pooler: spine


I would appreciate any help,

Thank you very much.
//MB

[mbernardino]

Meanwhile I check the cacti logs and I have this error:

03/01/2013 12:14:20 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"INSERT INTO poller_item (local_data_id, host_id, action,hostname, snmp_community, snmp_version, snmp_timeout, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, snmp_port, rrd_name, rrd_path, rrd_num, rrd_step, rrd_next_step, arg1, arg2, arg3) VALUES (2888, 174, 0,'10.254.21.71', ''XmLgw!2012'', '2', '500', '', '', '', '', '', '', '161', 'snmp_oid', '/usr/share/cacti/rra/xmlgwq1_snmp_oid_2888.rrd', '1', '300', '0', '.1.3.6.1.4.1.17304.7.1.3.1', '', '')'


Any idea to fix this problem,

Thank you very much,
//MB

[mbernardino]

My version of mysql is:

Server version: 5.1.30 Source distribution

[gandalf]

Do you use single quotes around the SNMP community string?
R.