I am trying to do the same thing. I got three datacenters and I am logging all my routers and switches to syslog-ng servers in each location. I finally got sqlsyslogd working on a test server but noticed that the format in which my logs come into the database is wrong. Can you tell me if you was able to accomplish your goal and if so can you send me a sample config on how to tailor the logs before it is entered into the database. Thanks in advance. Ajamu Abraham Network Engineer About The Human Internet <http://about.com> 1440 Broadway, 20th Floor New York, NY 10018 Direct: (212) 204-1525 Cell: (917) 416-3800 "l'argent comptant règne tout autour de moi" -----Original Message----- From: Michael Earls [mailto:Michael.Earls@chmcc.org] Sent: Monday, April 08, 2002 2:18 PM To: syslog-ng@lists.balabit.hu Subject: RE: [syslog-ng]syslog-ng The reason I want it to log to a database is that I have over 100 routers and switches in different cities, I want a central Syslog server, I want all of techs in each city to be able to view the Syslog messages from a web browser anywhere. The only way I know to do this is have Syslog log to some database then have php/perl search from the web. What is the best way for me to do this with Syslog-ng? thanks michael -----Original Message----- From: bazsi@balabit.hu Sent: Wednesday, April 03, 2002 4:55 AM To: <syslog-ng@lists.balabit.hu> Subject: Re: [syslog-ng]syslog-ng On Wed, Apr 03, 2002 at 03:38:03AM 0500, Michael Earls wrote:

Will syslog ng ever be native to log to mysql or any other type of external database?

I don't understand what the problems with using an external program for such purpose are. Simply write a 10 line long perl script where you can even preprocess messages before they go to the database, and feed this script with a pipe/program destination. Adding support for pgsql/mysql/sybase/whatever into syslog ng is bloat in my opinion. Bazsi PGP info: KeyID 9AF8D0A9 Fingerprint CD27 CFB0 802C 0944 9CFD 804E C82C 8EB1 _______________________________________________ syslog ng maillist syslog ng@lists.balabit.hu https://lists.balabit.hu/mailman/listinfo/syslog ng _______________________________________________ syslog-ng maillist - syslog-ng@lists.balabit.hu https://lists.balabit.hu/mailman/listinfo/syslog-ng