The Syco Logviwer
Apache webbserver Mysql databas with logs Syslog stadards logformat in syslog
Syco to generate host list in webpage
InstallCopy the www folder containing all www files to /var/www/html/ Copy the apache vhost.conf file in the etc folder to /etc/httpd/cond.d Make shoure that the mod_cgi.se is enbaled in you apache config /etc/httod/httpd.conf Set upp user i htacess file ore use ldap read.
Set upp mysql settings in the mysql.py file (User must have read to Syslog database) Run sql file for mysql config
GRANT SELECT,INSERT,UPDATE on Syslog.Exclude TO 'rsyslogd'@'localhost'; GRANT SELECT,INSERT,UPDATE on Syslog.alert TO 'rsyslogd'@'localhost'; GRANT SELECT,INSERT,UPDATE on Syslog.signed TO 'rsyslogd'@'localhost'; GRANT SELECT on Syslog.* TO 'rsyslogd'@'localhost';
Extra: set upp logclean script Extra: Use nagios to montor logsSetup upp in webbpage what to exclude and alert in. "OK" settings will generate alerts if log entory is not find on the host chosen.
Cleaning out non wanted log entories define with add this script to crontab to run every hour. mysql_clean_exclude.py
Nagios alert are triggerd with nrpe to run on the script auto_alert.py
Use ldap instead of htacess file to host files. Uncomment the ldap section in the vhost.conf file Use Show daily logs Sining of logs Hidning non use logresults Removing non use logresults Trigger nagios alert on logs fins i db Trigger nagios alert on log NOT find in db on host