Trouble syslog remove

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

toneil
Posts: 4
Joined: Sun Jul 22, 2012 8:04 am
Location: Ohio

Re: Trouble syslog remove

Post by toneil »

U
B
D
MAN!

That did the trick. Thank you very much for your assistance.

-Tom
sharekhan
Cacti User
Posts: 57
Joined: Mon Apr 04, 2011 10:47 am

Re: Trouble syslog remove

Post by sharekhan »

Earlier i was getting the below error,
06/22/2016 10:45:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1305', SQL:"DELETE FROM `syslog`.`syslog_incoming` WHERE message (facility='user' AND priority='warning' AND message='pam_unix(cron:session): session opened for user www-data by (uid=0)') AND status='6''

So i have followed yours the SQL match expressions for Syslog Removal Rule Filters, through that the error gone but still the messages are not getting deleted from the syslog console.


Code:
facility='Syslog' AND priority='Info' AND message='restart'

But for some unclear now to me reasons my functions.php at line 344 looks like that
Code:
$sql = "DELETE
FROM `" . $syslogdb_default . "`.`" . $table . "`
WHERE " . $remove['message'];

pls help...
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests