Information: Forum is in read-only mode
For details and other support options see https://www.adiscon.com/news/support-forum-set-to-read-only-mode/

Implementing LogAnalayzer using syslog-ng

Everything which is related to the installation of phpLogCon.

Moderator: alorbach

Google Ads


Implementing LogAnalayzer using syslog-ng

Postby Yu Watanabe » Mon Jan 17, 2011 1:46 pm

Hi !

I am new here and would like to ask question for installation.

I am planning to deploy LogAnalyzer using syslog-ng. And also thinking of implementing direct connection from the syslog-ng
to mysql.

Has anyone had a experience of making direct connection from the syslog-ng to mysql?
If possible, I would like to see the sample configuration of the syslog-ng.conf.

Thanks!
Yu Watanabe
Yu Watanabe
New
 
Posts: 3
Joined: Mon Jan 17, 2011 1:36 pm

Urgent Question?

  • Pulling out your Hair?
  • Wasting Time and Money?
  • Deadline Approaching?

Re: Implementing LogAnalayzer using syslog-ng

Postby friedl » Thu Jan 27, 2011 2:56 pm

Hi,

unfortunately, we are not capable of giving support for syslog-ng. If it was about rsyslog, it would a different story. Please ask the syslog-ng team about some help with the configuration for MySQL.

Perhaps a forum user that is not directly addiliated to Adiscon might be able to help.

Florian
friedl
Adiscon Support
 
Posts: 67
Joined: Wed Sep 13, 2006 2:31 pm

Re: Implementing LogAnalayzer using syslog-ng

Postby plebreton » Fri Nov 18, 2011 2:40 pm

Hello,

This is my mysql configuration for syslog-ng :

destination d_mysql_drv {
sql(type(mysql)
host("localhost") username("CF") password("xxxxx") database("CF")
table("logs")
columns("host", "facility", "priority", "pid", "tag", "datetime", "program", "msg")
values( '$HOST', '$FACILITY_NUM', '$LEVEL_NUM', '$PID', '$TAG', '$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC',
'$PROGRAM', '$MSG' )
indexes("datetime","host","priority","facility","program")
log_fifo_size(6000));
};

# message generated by Syslog-NG

log {
source(s_local);
source(s_tcp_all);
source(s_udp_all);
destination(d_mysql_drv);
flags(flow-control);
};

Bye

Philippe
plebreton
Avarage
 
Posts: 12
Joined: Tue Nov 16, 2010 9:52 am

Re: Implementing LogAnalayzer using syslog-ng

Postby rgerhards » Fri Nov 18, 2011 2:48 pm

The sylsog-ng guys also have written a helpful article :)

http://blogs.balabit.com/2011/02/25/loganalyzer/
rgerhards
Site Admin
 
Posts: 3807
Joined: Thu Feb 13, 2003 11:57 am

Google Ads



Return to Installation

Who is online

Users browsing this forum: No registered users and 0 guests

cron