cacti log is showing SQl error and no graph

[bentech4u]

Hi Forum,

i have recently installed cacti on centos 7 and my graphs are not plotting. While checking the cacti.og, i saw below error messages. I have used spine poller as default

Code: Select all

04/23/2016 06:16:12 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM user_auth WHERE id="
04/23/2016 06:16:12 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT id     FROM graph_tree    WHERE id IN (SELECT item_id FROM user_auth_perms WHERE type=2 AND user_id=)    ORDER BY id LIMIT 1"
04/23/2016 06:16:20 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM user_auth WHERE id="
04/23/2016 06:16:20 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT id     FROM graph_tree    WHERE id IN (SELECT item_id FROM user_auth_perms WHERE type=2 AND user_id=)    ORDER BY id LIMIT 1"
04/23/2016 06:17:21 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM user_auth WHERE id="
04/23/2016 06:17:21 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT id     FROM graph_tree    WHERE id IN (SELECT item_id FROM user_auth_perms WHERE type=2 AND user_id=)    ORDER BY id LIMIT 1"

Please anyone help me to fix this issue.

Regards,
Ben

[bentech4u]

I can able to rrd file generated by manually running /var/www/html/cacti/poller.php script.

but from the frontend(web) , nothing is ploting. all th graphs are blank

[root@client rra]# ls
localhost_hdd_free_40.rrd localhost_hdd_used_35.rrd localhost_proc_7.rrd localhost_ucd_memtotalreal_23.rrd
localhost_hdd_used_26.rrd localhost_hdd_used_36.rrd localhost_traffic_in_39.rrd localhost_ucd_memtotalswap_18.rrd
localhost_hdd_used_27.rrd localhost_hdd_used_37.rrd localhost_ucd_hrsystemprocess_24.rrd localhost_ucd_sscpurawidle_8.rrd
localhost_hdd_used_28.rrd localhost_hdd_used_38.rrd localhost_ucd_memavailreal_15.rrd localhost_ucd_sscpurawnice_9.rrd
localhost_hdd_used_29.rrd localhost_load_15min_13.rrd localhost_ucd_memavailreal_19.rrd localhost_ucd_sscpurawsystem_10.rrd
localhost_hdd_used_30.rrd localhost_load_1min_12.rrd localhost_ucd_memavailswap_17.rrd localhost_ucd_sscpurawuser_11.rrd
localhost_hdd_used_31.rrd localhost_load_1min_14.rrd localhost_ucd_membuffer_20.rrd localhost_users_25.rrd
localhost_hdd_used_32.rrd localhost_load_1min_5.rrd localhost_ucd_memcached_21.rrd localhost_users_6.rrd
localhost_hdd_used_33.rrd localhost_mem_buffers_3.rrd localhost_ucd_memshared_22.rrd
localhost_hdd_used_34.rrd localhost_mem_swap_4.rrd localhost_ucd_memtotalreal_16.rrd

[micke2k]

Run the sql-query manually from mysql in cli. Whats the error?