• Rsyslog Mysql

In this post I will cover. 1) Setting up a syslog server to log messages from local and remote sources. 2) Setup a GUI front end showing syslog items. I’ve done this on both Ubuntu Server 10.04 and 12.04. First we need to get some items loaded.

We will load these right from the repository. Apt-get install build-essential apache2 php5 php5-gd libapache2-mod-php5 mysql-server php5-mysql rsyslog Edit /etc/rsyslog.conf and uncomment or add the following. This will set the server to accept inbound syslog messages on UDP port 514. # provides UDP syslog reception $ModLoad imudp $UDPServerRun 514 Next, since the log analyzer runs on php, we need to tell apache how to handle php pages. Edit /etc/apache2/apache2.conf and add in the following item underneath “DefaultType None” DefaultType text/plain Addtype application/x-httpd-php.php Note: If this step is not done properly, you will get a message when loading the syslog web page prompting you to save the file instead of Apache displaying the file. Now on to the LogAnalyzer.

Download the latest log analyzer from the adiscon web site at cd /opt wget Unzip and extract the file. Gunzip loganalyzer-3.5.6.tar.gz tar -xvf loganalyzer-3.5.6.tar Copy the LogAnalyzer /src/ folder to the Apache www root or subfolder, copy the install script, make executable, and run the install scripts. It’s important to run the configure script from the same directory that will hold the syslog php files. Mkdir /var/www/syslog cp -r /opt/loganalyzer-3.5.6/src/. /var/www/syslog cp -r /opt/loganalyzer-3.5.6/contrib/.sh /var/www/syslog chmod +x /var/www/syslog/.sh cd /var/www/syslog/./configure.sh Grant Apache access to syslog. Usermod -G adm www-data Use a web browser to hit the new web service at The page will show a message stating the service is not configured. Follow the steps to setup your syslog front end.

I recently tried to install Adiscon Loganalyzer on ubuntu and boy it was a journey with a lot of googling and head wreaking! Finally i managed to get it working to my liking. Steves blog and Mikes blog were the two blogs that helped me a lot ( i have posted the links at the bottom of this article) and without thier blogs i would have definitly left it half way. First you would want to install Ubuntu server, mine was on virtual box( i assume that you already have it installed and have it up and running, if you do have any questions about it kindly leave a comment and i will send you a detailed way to install the server) Kindly make sure that you select the LAMP server option while installing the server as,if you dont install loganalyzer will work fine but once you restart the machine the the webpage wont load.

Rsyslog Mysql

If you do forget to check the LAMP option during installation you can install it later using the command @ubuntu:$ sudo apt-get install lamp-server^ I also recomend installing SSH as it would be easy for you to manage through a SSH client than straining you eye on the virtula box display. The command for installing ssh server is @ubuntu:$ sudo apt-get install openssh-server Ok, lets begin. 1) @ubuntu:$ sudo -s (so that you dont have to keep typing sudo in the begining of ech command) @ubuntu:$ apt-get update.

Sep 02, 2010 Set Up Rsyslog and LogAnalyzer on CentOS Linux 5.5 for Centralized Logging. Install and configure rsyslog on UBUNTU. Install of loganalyzer I.