Syslog 1.0 Released

Announcements concerning Plugins for Cacti

Moderators: Moderators, Developers

Post Reply
Author
Message
hammer733
Posts: 22
Joined: Fri Aug 20, 2010 6:47 pm

#106 Post by hammer733 » Mon Sep 13, 2010 7:45 am

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'"

User avatar
TheWitness
Developer
Posts: 14817
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

#107 Post by TheWitness » Mon Sep 13, 2010 8:22 am

The table 'syslog_reports' does not exist.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of MacTrack, Boost, CLog, SpikeKill, Platform RTM, DSStats, maintainer of Spine, lot's of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Central Plugin Repository
Central Templates Repository


I'm still out there people. Getting excited for Cacti 1.2. I think it will be a great release.

armstrongzhao
Posts: 28
Joined: Mon Feb 02, 2009 10:21 am
Location: CHINA

#108 Post by armstrongzhao » Thu Sep 16, 2010 8:42 am

why my rsyslog does no log host ip?
The plugin is syslog1.05.
Attachments
syslognohostip.png
syslognohostip.png (65.94 KiB) Viewed 7157 times

User avatar
zgamer
Cacti User
Posts: 86
Joined: Sat Sep 23, 2006 7:50 pm
Location: WI, USA

#109 Post by zgamer » Mon Sep 20, 2010 4:27 pm

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?
Current cacti install
-------------------------
Hardware: ESXi 5.1 VM
Software Load: FreeBSD 9.0 + Lighttpd + MySQL + Cacti 0.8.7
Plug-ins loaded: aggregate, flowview, monitor, realtime, rrdclean, syslog, spikekill, settings, thold, weathermap, and uptime.

trungtano
Cacti User
Posts: 90
Joined: Fri Apr 10, 2009 1:57 am
Contact:

#110 Post by trungtano » Wed Sep 22, 2010 10:42 pm

woa supper ... I will try it
Last edited by trungtano on Wed Sep 22, 2010 10:45 pm, edited 1 time in total.

trungtano
Cacti User
Posts: 90
Joined: Fri Apr 10, 2009 1:57 am
Contact:

Re: Syslog 1.0 Released

#111 Post by trungtano » Wed Sep 22, 2010 10:44 pm

TheWitness wrote: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
Posts: 13
Joined: Thu Sep 30, 2010 1:22 am

Re: Syslog 1.0 Released

#112 Post by giokob » Thu Sep 30, 2010 2:44 am

nice plugin thanks


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

User avatar
TheWitness
Developer
Posts: 14817
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Syslog 1.0 Released

#113 Post by TheWitness » Thu Sep 30, 2010 8:55 am

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

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of MacTrack, Boost, CLog, SpikeKill, Platform RTM, DSStats, maintainer of Spine, lot's of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Central Plugin Repository
Central Templates Repository


I'm still out there people. Getting excited for Cacti 1.2. I think it will be a great release.

giokob
Posts: 13
Joined: Thu Sep 30, 2010 1:22 am

Re: Syslog 1.0 Released

#114 Post by giokob » Fri Oct 01, 2010 12:30 am

thank you

giokob
Posts: 13
Joined: Thu Sep 30, 2010 1:22 am

Re: Syslog 1.0 Released

#115 Post by giokob » Mon Oct 04, 2010 2:30 am

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

User avatar
TheWitness
Developer
Posts: 14817
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Syslog 1.0 Released

#116 Post by TheWitness » Tue Oct 05, 2010 6:31 am

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

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of MacTrack, Boost, CLog, SpikeKill, Platform RTM, DSStats, maintainer of Spine, lot's of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Central Plugin Repository
Central Templates Repository


I'm still out there people. Getting excited for Cacti 1.2. I think it will be a great release.

kevin_taco
Posts: 37
Joined: Fri Feb 11, 2005 5:32 pm

Re: Syslog 1.0 Released

#117 Post by kevin_taco » Tue Oct 05, 2010 3:01 pm

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!

User avatar
TheWitness
Developer
Posts: 14817
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Syslog 1.0 Released

#118 Post by TheWitness » Tue Oct 05, 2010 7:18 pm

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

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of MacTrack, Boost, CLog, SpikeKill, Platform RTM, DSStats, maintainer of Spine, lot's of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Central Plugin Repository
Central Templates Repository


I'm still out there people. Getting excited for Cacti 1.2. I think it will be a great release.

kevin_taco
Posts: 37
Joined: Fri Feb 11, 2005 5:32 pm

Re: Syslog 1.0 Released

#119 Post by kevin_taco » Tue Oct 05, 2010 8:46 pm

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.
Attachments
ftable.png
ftable.png (29.98 KiB) Viewed 6960 times
dropdown.png
dropdown.png (34.49 KiB) Viewed 6960 times

User avatar
TheWitness
Developer
Posts: 14817
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Syslog 1.0 Released

#120 Post by TheWitness » Wed Oct 06, 2010 7:53 am

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
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of MacTrack, Boost, CLog, SpikeKill, Platform RTM, DSStats, maintainer of Spine, lot's of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Central Plugin Repository
Central Templates Repository


I'm still out there people. Getting excited for Cacti 1.2. I think it will be a great release.

Post Reply