--

I. DATABASE

   First of all, you need MySQL database, where you'll store logs and access
   to it.

   Execute:

   $ mysql -u root -p < sqlsyslogd.sql

   This sample database dump will create database sqlsyslogd with table
   sqlsyslogd and add user sqlsyslogd with password 'foo'.

--

II. CONFIGURATION

   Put password for MySQL database in file /usr/local/etc/sqlsyslogd.conf
   and add following line into your syslogd.conf:

   *.*					|/usr/local/sbin/sqlsyslogd <params>

   Params are:

	<-u username> -- username for MySQL database
	<-t table>    -- table, where logs will be stored
        [database]    -- database, where logs will be stored
        [-h hostname] -- hostname, if logging to remote MySQL
        [-p]          -- read password from /usr/local/etc/sqlsyslogd.conf

   Then rehash syslogd:

   # killall -HUP syslogd

--

Author: Przemyslaw Frasunek <venglin@freebsd.lublin.pl>

$Id: INSTALL,v 1.1.1.1 2001/05/21 15:31:50 venglin Exp $

--