Projects / sysklogd-sql

sysklogd-sql

sysklogd-sql is a port of the sysklogd daemon that can log data to a MySQL or PostgreSQL database running either on the same machine or a remote database server. The SQL configuration is done in the standard syslog.conf file for easy administration and configuration. Also included is a set of sample PHP scripts to query the data from the syslog database. In a large environment, you can set up a central logging server, or configure a secure syslog environment that will make it very difficult to tamper with the syslog data.

Tags
Licenses
Operating Systems

Recent releases

  •  09 Jul 2003 17:39

    Release Notes: This version supports both MySQL and PostgreSQL databases, and includes major enhancements to the way that errors are handled when sending data to the SQL server. It no longer requires the SQL server to be running prior to syslogd. The ability to log to multiple SQL servers of the same type has been added (beta).

    •  25 Jun 2002 06:10

      Release Notes: This release has security enhancements to help deal with possible buffer overflows and HTTP attacks against the sample Web front end. There is now a cleaner interface for date-based searching on the results page in the sample Web front end, and the beginnings of Oracle support and log rotation.

      •  27 May 2002 08:43

        Release Notes: Changed the buffers used for SQL processing to use internal defines to help eliminate possible buffer overflows, and increased the size of some of the buffers by 1 byte. A new, more intuitive date-based search syntax was included, some unused SQL calls were removed, and SQL data is escaped to accommodate the new search and to deal with possible HTTP attacks from the sample front end. An index was added to the Machine column for faster processing of first page of the sample.

        •  22 May 2002 20:56

          No changes have been submitted for this release.

          Recent comments

          11 Aug 2008 11:37 ricky_john

          Re: How about PostgreSQL?


          >

          > % Does this only work with MySQL or is

          > % PostgreSQL also do-able?

          > %

          > % Thanks

          >

          >

          > PostgreSQL is now supported in the

          > lastest CVS version. You can get it from

          > http://www.sourceforge.net/projects/sysklogd-sql

          can i get sysklog with ipv6 support?

          I want to include only IPv6 support to sysklogd.!

          Can any one help me please??

          Regards

          Ricky

          21 Mar 2005 20:44 mundanelunacy

          sqlite?
          Any chance for sqlite support? Mind if I add it in there?

          16 Feb 2003 20:59 ronnocol

          Re: How about PostgreSQL?

          > Does this only work with MySQL or is
          > PostgreSQL also do-able?
          >
          > Thanks


          PostgreSQL is now supported in the lastest CVS version. You can get it from http://www.sourceforge.net/projects/sysklogd-sql

          22 May 2002 17:25 ronnocol

          Re: How about PostgreSQL?

          > Does this only work with MySQL or is
          > PostgreSQL also do-able?
          >
          > Thanks

          At this time only MySQL is supported, I have plans of porting it to other SQL servers as time permits.

          22 May 2002 17:17 crippler

          How about PostgreSQL?
          Does this only work with MySQL or is PostgreSQL also do-able?

          Thanks

          Screenshot

          Project Spotlight

          OpenStack4j

          A Fluent OpenStack client API for Java.

          Screenshot

          Project Spotlight

          TurnKey TWiki Appliance

          A TWiki appliance that is easy to use and lightweight.