cacti.log contains only SQL entries

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

Post Reply
snowgasm
Posts: 19
Joined: Fri Sep 02, 2005 5:32 pm

cacti.log contains only SQL entries

Post by snowgasm »

Hi there,

I am having a problem with the cacti.log. When i have the log setting set to DEBUG, the only thing i see in the logfile is SQL entries, so no snmp output results:

09/07/2006 03:13:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('remove_verification', 'on')"
09/07/2006 03:13:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('snmp_retries', '3')"
09/07/2006 03:13:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('snmp_port', '161')"
09/07/2006 03:13:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('snmp_timeout', '500')"
09/07/2006 03:13:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('snmp_password', '')"
09/07/2006 03:13:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('snmp_username', '')"
09/07/2006 03:13:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('snmp_community', 'public')"
09/07/2006 03:13:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('snmp_ver', '2')"
09/07/2006 03:13:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('rrdtool_version', 'rrd-1.2.x')"
09/07/2006 03:13:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('snmp_version', 'net-snmp')"
09/07/2006 03:13:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('log_perror', '')"
09/07/2006 03:13:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('log_pwarn', '')"
09/07/2006 03:13:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('log_pstats', '')"
09/07/2006 03:13:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('log_verbosity', '3')"
09/07/2006 03:13:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('log_export', '')"
09/07/2006 03:13:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('log_graph', '')"
09/07/2006 03:13:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('log_snmp', '')"
09/07/2006 03:13:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('log_destination', '1')"
09/07/2006 03:13:55 PM - 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'"
09/07/2006 03:13:55 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username=''"
09/07/2006 03:13:55 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='remove_verification'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='remove_verification'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='other_header'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='other_header'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_retries'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_retries'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_port'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_port'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_timeout'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_timeout'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_password'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_password'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_username'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_username'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_community'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_community'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_ver'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_ver'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_header'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_header'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='rrdtool_version'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='rrdtool_version'"
09/07/2006 03:13:48 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_version'"

I have waited for over an hour, but no poller statistics, only SQL entries. Any idea why the logfile does not contain any poller results? like:

Thanks!
Last edited by snowgasm on Wed Sep 13, 2006 2:51 am, edited 1 time in total.
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:

Post by rony »

I would say it seems like your poller isn't running...

Are you seeing graphs?
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
snowgasm
Posts: 19
Joined: Fri Sep 02, 2005 5:32 pm

Post by snowgasm »

that's the same thing i was thinking about, but my graphs are working just fine. Could it just be a parameter anywhere in a conf file where you can disable the poller output logging?
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:

Post by rony »

Nope, logging levels are controlled by the interface setting.

If you don't want to see interface type messages, just set the permissions so only the poller user can write the cacti.log.
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests