Syslog 1.0 Released

[trungtano]

Hi TheWitness
I'm enable it already. But the log is still there, it didn't delete by the rule.
P/S: only rule remove not working please see the picture
Thank you!

[TheWitness]

PM Cacti.Log. The Facility and Hostname have not been tested (at least by me). Good chance there is a bug there. Open a bug report here: http://bugs.cacti.net

TheWitness

[trungtano]

hi
Here is my cacti.log
thanks, best regard

[TheWitness]

I see some issues..... Correcting.

[TheWitness]

Here is your issue:

08/04/2010 03:20:06 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"UPDATE `cactidb`.`cactidb.syslog_incoming` set status=1 where status=0'
08/04/2010 03:20:06 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"select count(*) FROM `cactidb`.`cactidb.syslog_incoming` where `status`=1"
08/04/2010 03:20:06 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"UPDATE `cactidb`.`cactidb.syslog_incoming` set status=2 where status=1'
08/04/2010 03:20:06 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"INSERT INTO `cactidb`.`plugin_camm_syslog` (`host`, `sourceip`, `facility`, `priority`, `sys_date`, `message`, `status`, `alert`) SELECT `host`, `sourceip`, `facility`, `priority`, `sys_date`, `message`, `status`, `alert` FROM `cactidb`.`cactidb.syslog_incoming` WHERE status=2'
08/04/2010 03:20:06 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"DELETE FROM `cactidb`.`cactidb.syslog_incoming` where `status`=2'
08/04/2010 03:20:06 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT host, date(`sys_date`) as day_noumber, count(*) as count_rows FROM `cactidb`.`plugin_camm_syslog` where date(`sys_date`) < date('2010-07-28') group by host, date(`sys_date`) HAVING count_rows > 1200 order by count_rows;"
08/04/2010 03:20:06 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT count(*) from `cactidb`.`plugin_camm_syslog` where ( date(`sys_date`) < date('2010-07-28'))"

Post your config.php from the syslog plugin directory. Please remove passwords.

Here is the section of interest.

`cactidb`.`cactidb.syslog_incoming`

I prepend the `cactidb`. part. Don't know where the cactidb.syslog_incoming is coming from.

TheWitness

[trungtano]

Here is my config.php from syslog plugins

<?php
/*
+-------------------------------------------------------------------------+
| Copyright (C) 2007 The Cacti Group |
| |
| This program is free software; you can redistribute it and/or |
| modify it under the terms of the GNU General Public License |
| as published by the Free Software Foundation; either version 2 |
| of the License, or (at your option) any later version. |
| |
| This program is distributed in the hope that it will be useful, |
| but WITHOUT ANY WARRANTY; without even the implied warranty of |
| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
| GNU General Public License for more details. |
+-------------------------------------------------------------------------+
| Cacti: The Complete RRDTool-based Graphing Solution |
+-------------------------------------------------------------------------+
| This code is designed, written, and maintained by the Cacti Group. See |
| about.php and/or the AUTHORS file for specific developer information. |
+-------------------------------------------------------------------------+
| http://www.cacti.net/ |
+-------------------------------------------------------------------------+
*/

global $config, $database_type, $database_default, $database_hostname;
global $database_username, $database_password, $database_port;

/* revert if you dont use the Cacti database */
$use_cacti_db = true;

if (!$use_cacti_db) {
$syslogdb_type = 'mysql';
$syslogdb_default = 'cactidb';
$syslogdb_hostname = 'localhost';
$syslogdb_username = '******';
$syslogdb_password = '**********';
$syslogdb_port = 3306;
}else{
$syslogdb_type = $database_type;
$syslogdb_default = $database_default;
$syslogdb_hostname = $database_hostname;
$syslogdb_username = $database_username;
$syslogdb_password = $database_password;
$syslogdb_port = $database_port;
}

/* field in the incomming table */
$syslog_incoming_config['dateField'] = 'date';
$syslog_incoming_config['timeField'] = 'time';
$syslog_incoming_config['priorityField'] = 'priority';
$syslog_incoming_config['facilityField'] = 'facility';
$syslog_incoming_config['hostField'] = 'host';
$syslog_incoming_config['textField'] = 'message';
$syslog_incoming_config['id'] = 'seq';

?>

[TheWitness]

Ok, this is odd. Are you using the cacti preconfigured adodb or are you using a debian package, or something that installs a different version of ADODB. I'll take a second look at the code too and see if there is something not quite right there.

TheWitness

[TheWitness]

Well I found some oddities in the Syslog removal section, but none that would have broke your setup as documented in your Cacti log.

Make sure that you are running the latest version. I will push out 1.04-7 here momentarily to the docs site. All you have to do is copy it over the existing plugin to work. No database changes.

TheWitness

[trungtano]

oh, thanks you very much!

P/s: I using debian package

[TheWitness]

So it could be a more recent adodb causing the issues. Il have to check that out tommorow as i run debian too, but with cacti souces.

[trungtano]

Hello TheWitness

I was try with syslog 1.0.4.7 as your suggest, but the bug is not fix

I will try to check adodb!

Regard

[trungtano]

Hi

I update this package: php-adodb-4.95-2.a.fc11.noarch

but nothing happen

[zorrosam]

Hi

I update this package: php-adodb-4.95-2.a.fc11.noarch

but nothing happen

great plugin and really a good job my friend!

[TheWitness]

Hi

I update this package: php-adodb-4.95-2.a.fc11.noarch

but nothing happen

Here is a guess. Cacti is distributed using an 'old' version of ADODB. So, le't attempt to remove one line from the code.

Code: Select all

$cnn_id->DefaultDatabase = $database_default;

Line 92 of functions.php. Comment out that line, and let's see if that fixes it.

TheWitness

[zorrosam]

Hi

I update this package: php-adodb-4.95-2.a.fc11.noarch

but nothing happen

great plugin and really a good job my friend!

Hi,

Houston i have a problem ...

With the last version i'm not able to log any info in the syslog table.

The syslog.incoming is populated correctly ... but the script

/usr/bin/php -q /var/www/cacti/plugins/syslog/syslog_process.php

doesn't work anymore ... and tha data are not moved on the main table.

What can i do?

[root@patroclo syslog]# /usr/bin/php -q /var/www/cacti/plugins/syslog/syslog_process.php
PHP Deprecated: Function split() is deprecated in /var/www/cacti/plugins/syslog/syslog_process.php on line 70
08/10/2010 01:44:31 PM - SYSTEM SYSLOG STATS:Time:0.17 Deletes:0 Incoming:0 Removes:0 XFers:0 Alerts:0 Alarms:0 Reports:0

any help is appreciate!