[syslog-ng]Remote MySQL?

[Michael Arndt]

Hello,

i am as well interested in collcting syslogdata on a central loghost
in a mysql database.

two questions concerning this topic:

has anyone build mysql or postgresqls report tools based on OSS tools 
or has feedback regarding this topic ?

Is there a easy to use mechanism to get at
least some routine queries / reports by a "GUI" ?

SQL queries are not so encouraging to not-technical people
(end users)

has anyone hints about the size of logfile information
he / she handles with MS SQL or postgres sql ?

> Not at all. There are quite a few different methods for doing so, each with
> its advantages and disadvantages.
> 
> Many are linked right on syslog-ng's FAQ page
> (http://www.campin.net/syslog-ng/faq.html#links):
> 
>   http://vermeer.org/syslog/ (how to do it with a pipe to the mysql
> command...the only command to change to make it remote is the "mysql"
> command itself right at the bottom. Just add a "-h hostname.domain.tld" to
> it)
>   http://www.campin.net/newlogcheck.html (talks about how to do it buy
> connecting with sqlsyslogd
>   The example config at http://www.campin.net/syslog-ng.conf uses the
> sqlsyslogs technique, as well.
>   There's also a link to an example of how to do it by using a dropoff
> directory. It's for postgresql, but can easily be adapted to mysql. The link
> is dead now, but you can still see it through Archive.org's "Wayback
> machine":
> http://web.archive.org/web/20030622012230/http://www.umialumni.com/~ben/SYSL
> OG-DOC.html
>   Finally, there's a discussion, comparison, and examples of both of these
> methods, as well a third, in the expanded example config at
> http://www.campin.net/syslog-ng/expanded-syslog-ng.conf 
> 
> Any of these techniques can be used for remote SQL logging.
> 
> Mike Nerone
>  
> /* The only secure computer is one that is unplugged from the network -- and
> the wall. */
> 
> <Activism>Did you know that our brilliant legislators recently (and quietly)
> legalized spam? The law now says that anyone who wants to *can* spam with no
> fear of punishment. They even named the law the "CAN SPAM" Act. Read about
> it at http://www.cauce.org/news/index.shtml, then talk about it with your
> congressman.</Activism>
> 
> -----Original Message-----
> From: syslog-ng-admin@lists.balabit.hu
> [mailto:syslog-ng-admin@lists.balabit.hu] On Behalf Of Tony Karakashian
> Sent: Monday, April 12, 2004 15:46
> To: syslog-ng@lists.balabit.hu
> Subject: [syslog-ng]Remote MySQL?
> 
> I've looked through the docs and lists and it doesn't appear that this is
> possible, so I'll ask: can I log from one machine to a MySQL server running
> on another machine?  It appears I can only log to MySQL if it's running on
> the same machine as syslog-ng.  Is that correct?
> 
> Thanks,
> -T
> 
> _______________________________________________
> syslog-ng maillist  -  syslog-ng@lists.balabit.hu
> https://lists.balabit.hu/mailman/listinfo/syslog-ng
> Frequently asked questions at http://www.campin.net/syslog-ng/faq.html

-- 
_________________________creating IT solutions
Michael Arndt
Bereichsleiter IT-Services Berlin    science + computing ag
phone   +49 30 72 62 38-50           Ehrenbergstrasse 19
fax     +49 30 72 62 38-59           D-10245 Berlin, Germany
m.arndt@science-computing.de         www.science-computing.de