Syslog 1.0 Released

[hammer733]

I am getting the below error in cacti log. Any idea how I can fix??

09/13/2010 08:35:56 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1146', SQL:"SHOW COLUMNS FROM `cacti`.`syslog_reports` LIKE 'body'"

[TheWitness]

The table 'syslog_reports' does not exist.

[armstrongzhao]

why my rsyslog does no log host ip?
The plugin is syslog1.05.

[zgamer]

The syslog plugin looks to be installed correctly. rsyslog is installed and running with the following modifications to the rsyslog.conf file.

Inserted at the top of the file:

Code: Select all

$ModLoad immark.so   # provides --MARK-- message capability
$ModLoad imuxsock.so # provides support for local system logging
$ModLoad imklog.so   # kernel logging
$ModLoad ommysql

Inserted at the bottom of the file:

Code: Select all

$ModLoad ommysql

$template cacti_syslog,"INSERT INTO syslog_incoming(facility, priority, date, time, host, message) values (%syslogfacility%, %syslogpriority%,  '%timereporte
d:::date-mysql%', '%timereported:::date-mysql%', '%HOSTNAME%', '%msg%')", SQL *.* >localhost,cacti,cacti_user,cacti_dbpass;cacti_syslog

Any idea why the logs are showing up the server but are not dumping correctly to the mysql database?

[trungtano]

woa supper ... I will try it

[trungtano]

All,

Syslog 1.05 is released. This Plugin Requires Cacti 0.8.7g++ and PIA 2.8++. You can find more information, and the download here: http://docs.cacti.net/plugin:syslog#syslog

TheWitness

---------------------------------------------------------------


I will attach some screen shots momentarily.[/list]

Woa supper ... I will try

[giokob]

nice plugin thanks


is it possible to create alarms, removals per device?
can i show full messages in syslog viewer not only titles?

[TheWitness]

There is a dropdown for the amount of display to provide in the on the page. Per Host Alert's are configurable.

TheWitness

[giokob]

thank you

[giokob]

it will be great to have permission control on syslog messages for users like graph permissions work, are you going to implement it?

[TheWitness]

You have to be more specific. Give me examples and use cases.

TheWitness

[kevin_taco]

Hi The Witness,

I really appreciate your work on this plugin. Thanks so much!

I do have an issue and I'm hoping this forum thread can help.

Cacti 0.8.7g++
Syslog 1.05
PIA 2.8++

The "All Facilities" drop down list doesn't show the Facilities values the boxes are reporting. What is enumerated are multiple values of the same Facility. For example, the drop down will show "Deamon", "User, and "Auth" over and over. There's about 50+ values in there.

When I look at the syslog_facilities table the correct Facilities values are there. I tried searching the forum but couldn't find a search match for this issue. Can you help?

Thanks!

[TheWitness]

That's quite odd. Attach a screen show showing this..

TheWitness

[kevin_taco]

Here are the screenshots you requested. You can see the odd drop down values for Facilites and the table which I think the code is looking up for the values.

Please let me know if you need further info.

[TheWitness]

In syslog.php line 557 change the "SELECT f.facility" to "SELECT DISTINCT f.facility" and let me know if the problem goes away. Odd that this has not been reported before.

TheWitness