Having syslog-ng send to a central server via local6
I am setting up syslog-ng to tail a database query log and have it sent to a central server for analysis / archiving. I have it partially working. I am able to send the UDP packets to the central server but I cannot get them to be sent to central server @ local6. Below is my source, destination, & log lines: *source s_general_db_log { file ("/var/lib/mysql/mysql/general_log.CSV" flags(no-parse) follow_freq(1) program_override("vchat3dev-db002_mysql_db_log:") ); }; destination d_central { udp( "10.0.4.162" port(514) ); }; log { source(s_general_db_log); destination(d_central); }; *I have tried adding in a facility option to the destination but it does not work. Any help with what I am missing would be greatly appreciated. Thanks in advance. -Patrick
On Mon, 2009-04-27 at 22:01 -0700, Patrick Topping wrote:
I am setting up syslog-ng to tail a database query log and have it sent to a central server for analysis / archiving. I have it partially working. I am able to send the UDP packets to the central server but I cannot get them to be sent to central server @ local6. Below is my source, destination, & log lines:
source s_general_db_log { file ("/var/lib/mysql/mysql/general_log.CSV" flags(no-parse) follow_freq(1) program_override("vchat3dev-db002_mysql_db_log:") ); };
destination d_central { udp( "10.0.4.162" port(514) ); };
log { source(s_general_db_log); destination(d_central); };
I have tried adding in a facility option to the destination but it does not work. Any help with what I am missing would be greatly appreciated. Thanks in advance.
Hi, You can add the facility() and priority() options to the source, otherwise it sets user/notice. M -- Key fingerprint = F78C 25CA 5F88 6FAF EA21 779D 3279 9F9E 1155 670D
Marton, Thanks for the info. Adding it to the source did the trick and I am up and running. Thanks again. -Patrick ----------------------------------- ILLES, Marton wrote:
On Mon, 2009-04-27 at 22:01 -0700, Patrick Topping wrote:
I am setting up syslog-ng to tail a database query log and have it sent to a central server for analysis / archiving. I have it partially working. I am able to send the UDP packets to the central server but I cannot get them to be sent to central server @ local6. Below is my source, destination, & log lines:
source s_general_db_log { file ("/var/lib/mysql/mysql/general_log.CSV" flags(no-parse) follow_freq(1) program_override("vchat3dev-db002_mysql_db_log:") ); };
destination d_central { udp( "10.0.4.162" port(514) ); };
log { source(s_general_db_log); destination(d_central); };
I have tried adding in a facility option to the destination but it does not work. Any help with what I am missing would be greatly appreciated. Thanks in advance.
Hi,
You can add the facility() and priority() options to the source, otherwise it sets user/notice.
M
On Wed, 2009-04-29 at 06:22 -0700, Patrick Topping wrote:
Marton,
Thanks for the info. Adding it to the source did the trick and I am up and running. Thanks again.
Please note that this was changed to default-priority/default-facility in most recent snapshots to more closely reflect its function. -- Bazsi
participants (4)
-
Balazs Scheidler
-
ILLES, Marton
-
okapareeya@hotmail.com
-
Patrick Topping