- syslog-ng - lists.balabit.hu

RE: [syslog-ng]Where is the web page
by Ohrberg, Mick 24 Jan '02

24 Jan '02

http://www.balabit.hu/ works fine for me. > -----Original Message----- > From: Mihai Barbos [mailto:Mihai.Barbos@eurospider.com] > Sent: Thursday, January 24, 2002 11:57 AM > To: syslog-ng(a)lists.balabit.hu > Subject: [syslog-ng]Where is the web page > > > Hi, > > I'm trying to connect to www.balabit.hu (hompage for > syslog-ng) but it > seems that it dissapeard. Can anyone tell me where is it gone ? > > Regards, > > Mihai > > > _______________________________________________ > syslog-ng maillist - syslog-ng(a)lists.balabit.hu > https://lists.balabit.hu/mailman/listinfo/syslog-ng >

1 0

Where is the web page
by Mihai Barbos 24 Jan '02

24 Jan '02

Hi, I'm trying to connect to www.balabit.hu (hompage for syslog-ng) but it seems that it dissapeard. Can anyone tell me where is it gone ? Regards, Mihai

2 1

log rotation features for syslog-ng
by klaas.vangend＠philips.com 24 Jan '02

24 Jan '02

Gentlemen, I'd like enhance syslog-ng with some features in order to get rid of some log rotation scripts. For some of our systems, we log on a centralised system, but also store the logs locally. These logs only need limited availability, say a week or so. The file() destination currently is already able to use the target $WEEKDAYS (which is undocumented, btw), but in that case, logs from both Jan 17 and Jan 24 are logged in messages.Thu.log Therefore, I'd like to add a new option clear_old(X) which removes a logfile with a timestamp older than X days prior to writing the new message to that file. (default should be 0 (=never), which means that for a disabled feauture only one C 'if' statement additional overhead is caused) But I can imagine that people also wants to set a max size on a logfile. E.g. to be able to compress it afterwards, or for simple log rotation, like: file('/var/log/mesages' max_size_old(200, 'gzip')) will rename the existing 200 kB file to /var/log/messages.old and then run 'gzip /var/log/messages.old' Maybe it is better to add a new destination rotatedfile(), maybe it's better to do something else... I'd to know wheter everyone agrees that these features are a good idea, and that the proper approach is taken to keep the configurationfile syntax simple. Groetjes, Klaas van Gend

3 2

Syslog-ng on Boot
by jesse.keefe＠convergys.com 22 Jan '02

22 Jan '02

For those who asked about starting syslog-ng on boot, here is what I did for Solaris 8. I simply modified the /etc/rc2.d/S74syslog script: case "$1" in 'start') if [ -f /etc/syslog-ng/syslog-ng.conf -a -f /usr/sbin/syslog-ng ]; then echo 'syslog-ng service starting.' # # Before syslogd starts, save any messages from previous # crash dumps so that messages appear in chronological order. # /usr/bin/savecore -m if [ -r /etc/dumpadm.conf ]; then . /etc/dumpadm.conf [ "x$DUMPADM_DEVICE" != xswap ] && \ /usr/bin/savecore -m -f $DUMPADM_DEVICE fi if [ ! -f /var/adm/messages ]; then /usr/bin/cp /dev/null /var/adm/messages /usr/bin/chmod 0644 /var/adm/messages fi /usr/sbin/syslog-ng >/dev/msglog 2>&1 & fi ;; 'stop') echo 'syslog-ng service stopping.' if [ -f /var/run/syslog-ng.pid ]; then syspid=`/usr/bin/cat /var/run/syslog-ng.pid` [ "$syspid" -gt 0 ] && kill -15 $syspid fi ;; *) echo "Usage: $0 { start | stop }" exit 1 ;; esac ------------------------------------------ Jesse Keefe <jesse.keefe(a)convergys.com> | Systems Administrator | Convergys Corp. | 229 West Seventh Street | P.O. Box 1638 | Cincinnati, Oh 45201 | (513)723-3689 | -- NOTICE: The information contained in this electronic mail transmission is intended by Convergys Corporation for the use of the named individual or entity to which it is directed and may contain information that is privileged or otherwise confidential. If you have received this electronic mail transmission in error, please delete it from your system without copying or forwarding it, and notify the sender of the error by reply email or by telephone (collect), so that the sender's address records can be corrected.

3 4

Logging to mysql
by Richard Wallace 22 Jan '02

22 Jan '02

Hello, I've setup a rule to send all log messages received for the local0 facility to a program which then inserts info into a local mysql database. The problem is this isn't working. The script doesn't appear to be being called, since there are no messages in the mysql.log file stating that anyone has tried to connect. Here are the lines I've added. Any help would be greatly appreciated. destination local0 { program("/usr/local/sbin/rsynclog.pl"); }; filter f_local0 { facility(local0); }; log { source(src); filter(f_local0); destination(local0); }; Thanks -- _ Richard Wallace /\ | | /\ /| AIM, Inc. (www.a--i--m.com) / \ | | / \ / | Information Systems Consultants \ \ | | \ \ / | / \ | | | \ / | "Providing New Technology, / /\ \ | | | \ / | the Old-Fashioned Way" / / \ \ | | | |\ \//| | / / /\ \ \ | | | | \ / | | / / \/ \ / | | | | \/ | | \/ \/ |_| |_| |___|

1 0

Re: Re: [syslog-ng]syslog-ng mistreating data as part of the hos tname ?
by Hildenbrand, Patrick 20 Jan '02

20 Jan '02

On Wed, Jan 16, 2002 at 07:45:26PM +0100, Nate Campi wrote: >On Wed, Jan 16, 2002 at 05:14:11PM +0100, Hildenbrand, Patrick wrote: >> some more info. >> >> tracing the output of the SSR, the packet does not contain the hostname at >> the proper place but only the timestamp. So the output looks like >> (translated into ascii): >> <174>Jan 13 04:02:12 %ACL_LOG-I-DENY, ACL [280] on "rtfa" UDP 192.168.1.2:4721 -> 14.9.1.3:53 this is the ascii converted hexdump of the package, there is only a single space between date and message. > [ ... ] > >Linux syslog sends messages like this: > ><123>named[123]: another error from BIND, you should use djbdns my debugging showed the prio beeing only two digits (ex. <23>) but yes and the difference is, there is even no timestamp, why this case is explicitly covered in the RFC, while the case of the cabeltron ssr is not. This is probably also why syslog-ng does not have a problem with this case, it gets logged as: Jan 17 08:11:21 hwdf0006/hwdf0006 PAM_pwdb[22525]: (sshd) session close so syslog-ng correctly adds time and hostname to the log entry. The format of linux (and others) is: <Prio>message The format of the SSR is: <Prio>datetime<space>message The format the RFC suggests is: <Prio>datetime{space}hostname{space}message >It is up to the relay/collector to input the complete header. this is my understanding from the rfc too, but how do I get this using syslog-ng ? >I missed the beggining of this thread, is "%ACL_LOG-I-DENY" getting set >as your hostname? I had the same problem with solaris logs when the >"TAG" field had a space in it, so syslog-ng (correctly) thinks the first >part of the process name (in the "TAG") was the hostname. I wrote a >syslog proxy to overcome this, since I can't ask syslog-ng to stop >following standards. as said above, there is one space between date and message but according to the standard, there is no standard on how devices do send their messages >Perhaps syslog-ng can have a configuration setting where if it receives >a certain string in the hostname field, you can set keep-hostname to no >for just that message. That would save the day for me, but I don't know >how hard it would be to implement that. Well I would vote for getting a setting just the other way around, so for being able to configure something like options( addhostname(<pattern>) which would lead to the hostname being added if the pattern is matched and the pattern then being treated as part of the message. For me this just would be a '^%' as every message of the ssr is prepended with the percent sign ;-) still do not know how much work it would be but ..... BTW: I do not know how the linux syslog does it, but it does not have this problem. Maybe because '%' is not a valid char for hostnames. linux syslog is a pretty standard syslog I'd guess, though you could argue, wether this is correct according to the standard. Linux syslog displays the message above as: Jan 13 04:02:12 1.2.3.4 %ACL_LOG-I-DENY, ACL [280] on "rtfa" UDP 192.168.1.2:4721 -> 14.9.1.3:53 so it automagically adds the ip address to the message. Again maybe because of the '%' and ',' signs inside the string at the <hostname> position. >-- >Nate Campi <http://www.campin.net> GnuPG key: 0xC17AEF79 Kind regards, Patrick Hildenbrand > Patrick Hildenbrand > Operations & Technology > SAP Hosting AG & Co. KG > Raiffeisenring 45 > 68789 St. Leon-Rot, Germany > T +49/6227/7-66410 > F +49/6227/7-66301 > E patrick.hildenbrand(a)sap.com > http://www.saphosting.com >

3 3

Leaky syslog-ng files?
by Rob Mitzel 19 Jan '02

19 Jan '02

Hi everyone, I'm pretty new to syslog-ng, but I really like it so far, except for one thing I can't figure out...(it could be a clueless newbie issue.) I'm using syslog-ng on FreeBSD 4.4 to log everything for about 10 cisco routers/switches right now, with about 30 more that will be added over the next week or two. I have them logging to separate files right now, and that works great, with newsyslog archiving stuff, etc etc. Works wonderfully. However, everything keeps leaking into my /var/log/messages file, which I don't want it to do. I *just* want it in their separate files. An example of what I use for filters is: filter f_gig2 { host("gig2-0"); }; And for log: log { source(src); filter(f_gig2); destination(gig2); }; And for destination: destination gig2 { file("/var/log/peer1/vancouver/gig2-0"); }; Anyone have any suggestions? Thanks in advance! -Rob.

1 0

Leaky syslog-ng files?
by Rob Mitzel 19 Jan '02

19 Jan '02

Hi everyone, I'm pretty new to syslog-ng, but I really like it so far, except for one thing I can't figure out...(it could be a clueless newbie issue.) I'm using syslog-ng on FreeBSD 4.4 to log everything for about 10 cisco routers/switches right now, with about 30 more that will be added over the next week or two. I have them logging to separate files right now, and that works great, with newsyslog archiving stuff, etc etc. Works wonderfully. However, everything keeps leaking into my /var/log/messages file, which I don't want it to do. I *just* want it in their separate files. An example of what I use for filters is: filter f_gig2 { host("gig2-0"); }; And for log: log { source(src); filter(f_gig2); destination(gig2); }; And for destination: destination gig2 { file("/var/log/peer1/vancouver/gig2-0"); }; Anyone have any suggestions? Thanks in advance! -Rob.

1 0

[Michael.Earls@chmcc.org: syslog-ng logging to mysql database]
by Balazs Scheidler 18 Jan '02

18 Jan '02

----- Forwarded message from Michael Earls <Michael.Earls(a)chmcc.org> ----- From: "Michael Earls" <Michael.Earls(a)chmcc.org> To: <syslog-ng-admin(a)lists.balabit.hu> Subject: syslog-ng logging to mysql database Date: Thu, 17 Jan 2002 12:10:19 -0500 ALL Ż I found a way to use syslog-ng to log to a mysql database, using syslog-ng template. I am writing a mini man page, the first draft is up if you want to check it out.. http://www.vermeer.org Thanks everyone for your help, Michael Earls ----- End forwarded message ----- -- Bazsi PGP info: KeyID 9AF8D0A9 Fingerprint CD27 CFB0 802C 0944 9CFD 804E C82C 8EB1

1 0

Re: [syslog-ng]syslog-ng mistreating data as part of the hostname ?
by Hildenbrand, Patrick 16 Jan '02

16 Jan '02

some more info. tracing the output of the SSR, the packet does not contain the hostname at the proper place but only the timestamp. So the output looks like (translated into ascii): <174>Jan 13 04:02:12 %ACL_LOG-I-DENY, ACL [280] on "rtfa" UDP 192.168.1.2:4721 -> 14.9.1.3:53 The format as described in rfc3164 is only required for relays, which the router is not, as it is the originator of the packet. In fact in the standard it reads: 4.2 Original syslog Packets Generated by a Device There are no set requirements on the contents of the syslog packet as it is originally sent from a device. It should be reiterated here that the payload of any IP packet destined to UDP port 514 MUST be considered to be a valid syslog message. It is, however, RECOMMENDED that the syslog packet have all of the parts described in Section 4.1 - PRI, HEADER and MSG - as this enhances readability by the recipient and eliminates the need for a relay to modify the message. Setting 'keep_hostname(yes)', the message will be displayed correctly but without the hostname (contrary to the normal linux syslog). I could not fiddle out a single set of options that would have given me the output of the standard syslog. Any hints what I can do besides calling an external Program ? Mit besten Grüssen, Kind regards, Patrick Hildenbrand > Patrick Hildenbrand > Operations & Technology > SAP Hosting AG & Co. KG > Raiffeisenring 45 > 68789 St. Leon-Rot, Germany > T +49/6227/7-66410 > F +49/6227/7-66301 > E patrick.hildenbrand(a)sap.com > http://www.saphosting.com >

2 1

Re: [syslog-ng]syslog-ng
by Michael Earls 16 Jan '02

16 Jan '02

I will make things very clear on what i am trying to do with syslog-ng,, i have 200 routers and i want them to all point to my syslog server, that is why i created a sep file for each router, how can i get them to log to a mysql databse, i have tried just loggin one ip to the databse useing sqlsyslogd tables but that did not work, How can I go about getting this to work,?? thanks michael >>> nate(a)campin.net 01/14/02 08:06PM >>> On Mon, Jan 14, 2002 at 07:48:35PM -0500, Michael Earls wrote: > sorry if i am missing something but I do not see that there, i see that u are logging to a host file, or are using sqlsyslog, i am looking for a way to take the statement for syslog-ng then pipe that into a database, Are you saying you only want to insert *certain* messages into the database? I really don't understand. I see now that my example syslog-ng.conf doesn't have an example line for using sqlsyslogd. If that's what you need, here you go: ---- destination sqlsyslogd { program("/usr/local/sbin/sqlsyslogd -u sqlsyslogd -t logs sqlsyslogd -p"); }; log { source(src); destination(sqlsyslogd); }; ---- "src" in this case is all the incoming messages, there's no filtering of messages. You still need to setup your database according to the instructions for sqlsyslogd. Read the docs that come with it. -- Nate Campi http://www.campin.net GnuPG key: 0xC17AEF79 "My computer's sick. I think my modem is a carrier." _______________________________________________ syslog-ng maillist - syslog-ng(a)lists.balabit.hu https://lists.balabit.hu/mailman/listinfo/syslog-ng

1 0

logging T3 messages to central loghost?
by KONSTANTIN GINZBURG 16 Jan '02

16 Jan '02

Does anybody have experience with logging T3 array messages to a central loghost? I'm running syslog-ng on the central loghost. I have my loglevel set to '3' on the T3 and the following line in /etc/syslog.conf on the T3 (I also have corresponding line in /etc/hosts): *.notice central_loghost In syslog-ng.conf on 'central_loghost' I have: source external { tcp(port(1999) max-connections(50)); }; source external_udp { udp(port(514)); }; filter f_udp { host("some_name") or host("T3_array_name"); }; destination hosts { file("/var/log/$HOST/$FACILITY/$YEAR/$MONTH/$DAY/$FACILITY$YEAR$MONTH$DAY" owner(root) create_dirs(yes)); }; log { source(external); destination(hosts); }; log { source(external_udp); destination(hosts); }; In other words I'm listening on TCP port 1999 for all hosts except for special cases like T3 (because I don't know any way to make it send its logs via tcp). However, I don't get anything from the T3 array on the central log host even though local 'syslog' on the T3 gets a lot of messages. Am I missing something? I would appreciate any ideas or suggestions. Thanks in advance. Konstantin Ginzburg UNIX Engineering Eagan COSC (651) 406-2614

1 0

Conditional Logic
by jesse.keefe＠convergys.com 16 Jan '02

16 Jan '02

David hit it on the head. The messages I receive are on two seperate lines. The daemon calls for MountTape and on the next line I will get an "open failed". I understand the idea of swatch, we use it here, but I'm trying to kill two birds here. Syslog-ng has the capability of replacing swatch, I've already . I probably could write a small program to evaluate the MountTape, but I was hoping for a simpler solution. Jesse Keefe Analyst Convergys Corp -- NOTICE: The information contained in this electronic mail transmission is intended by Convergys Corporation for the use of the named individual or entity to which it is directed and may contain information that is privileged or otherwise confidential. If you have received this electronic mail transmission in error, please delete it from your system without copying or forwarding it, and notify the sender of the error by reply email or by telephone (collect), so that the sender's address records can be corrected.

1 0

iptables and /v/l/messages
by greg whorley 15 Jan '02

15 Jan '02

I got syslog-ng to log iptables messages to /v/l/iptables using match(IN=) and it works fine. However, I still get iptables messages in /v/l/messages because, well, it's supposed to log all info level messages there. I changed my firewall script so that --log-level is 7 (debug) instead of 6 (info). I tested, and the messages are still logging to /v/l/messages. There is no filter for level(debug), only level(info). I bet there is a simple resolution to this. Can anyone help? -- _______________________________________________ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup 1 cent a minute calls anywhere in the U.S.! http://www.getpennytalk.com/cgi-bin/adforward.cgi?p_key=RG9853KJ&url=http:/…

1 0

Conditional logic
by jesse.keefe＠convergys.com 15 Jan '02

15 Jan '02

I'm running syslog-ng 1.4.14. I'm running Netbackup and I'm having certain messages paged out to certain people. Is there a way to have a filter use conditional logic? ie: Here are the messages I'm interested in: Jan 15 12:47:25 linen/linen tldd[25799]: [ID 992021 daemon.notice] TLD(0) MountTape CVG121 on drive 5, from slot 20 5 Jan 15 12:47:45 linen/linen tldd[26280]: [ID 302958 daemon.notice] TLD(0) open failed in io_open, I/O error What I would like to do is have the Mount Tape matched and if it fails page someone. If it passes, just continue on. Any ideas? Jesse Keefe Analyst Convergys Corp -- NOTICE: The information contained in this electronic mail transmission is intended by Convergys Corporation for the use of the named individual or entity to which it is directed and may contain information that is privileged or otherwise confidential. If you have received this electronic mail transmission in error, please delete it from your system without copying or forwarding it, and notify the sender of the error by reply email or by telephone (collect), so that the sender's address records can be corrected.

3 3

logging by IP
by Chuck Kelly 15 Jan '02

15 Jan '02

Anyone know how to get syslog-ng to log to /var/log/<Source_ip> instead of /var/log/$HOST ?? I have routers, switches, UNIX hosts with different log formats and as a result, I get funky directories created like 04DA, VPN, etc. Unless there is a way to prevent the funky directories from being created. -- Chuck

2 1

Re: [syslog-ng]syslog-ng
by Michael Earls 15 Jan '02

15 Jan '02

I will make things very clear on what i am trying to do with syslog-ng,, i have 200 routers and i want them to all point to my syslog server, that is why i created a sep file for each router, how can i get them to log to a mysql databse, i have tried just loggin one ip to the databse useing sqlsyslogd tables but that did not work, what would be the best way for me to do this, and how do i do this, thanks michael >>> nate(a)campin.net 01/14/02 08:06PM >>> On Mon, Jan 14, 2002 at 07:48:35PM -0500, Michael Earls wrote: > sorry if i am missing something but I do not see that there, i see that u are logging to a host file, or are using sqlsyslog, i am looking for a way to take the statement for syslog-ng then pipe that into a database, Are you saying you only want to insert *certain* messages into the database? I really don't understand. I see now that my example syslog-ng.conf doesn't have an example line for using sqlsyslogd. If that's what you need, here you go: ---- destination sqlsyslogd { program("/usr/local/sbin/sqlsyslogd -u sqlsyslogd -t logs sqlsyslogd -p"); }; log { source(src); destination(sqlsyslogd); }; ---- "src" in this case is all the incoming messages, there's no filtering of messages. You still need to setup your database according to the instructions for sqlsyslogd. Read the docs that come with it. -- Nate Campi http://www.campin.net GnuPG key: 0xC17AEF79 "My computer's sick. I think my modem is a carrier." _______________________________________________ syslog-ng maillist - syslog-ng(a)lists.balabit.hu https://lists.balabit.hu/mailman/listinfo/syslog-ng

1 0

how to make program destination
by David Monk 15 Jan '02

15 Jan '02

I am fairly new to central logging with syslog-ng and had a couple questions. I tried briefly looking to the mailing list archives, but I couldn't find any way to easily search it. I want to have some matched log entries from various hosts sent to the network admin staff. What would be most preferential is to have the source hostname in the subject line and the log message as the body. I defined the following: destination d_mail { program("mail -s \"Matched log entry from $HOST\" syslog); }; With this I DO get an email, but the $HOST macro is empty and the message body is also empty. Is there a better method? Or can anyone help with an example or two? Thanks, David Monk CCNA, MCSE david(a)purplebear.net

1 0

Re: [syslog-ng]syslog-ng
by Michael Earls 15 Jan '02

15 Jan '02

what do u think about this one, b/c i still can not get to to log to the mysql database, destination rrrouter { program("/usr/bin/mysql -u root -p -D rrrouter -t"); }; filter f_192.168.3.254 { host(192.168.3.254); }; log { source(net); filter(f_192.168.3.254); destination(rrrouter); }; thanks michael >>> nate(a)campin.net 01/14/02 20:16 PM >>> On Mon, Jan 14, 2002 at 07:48:35PM -0500, Michael Earls wrote: > sorry if i am missing something but I do not see that there, i see that u are logging to a host file, or are using sqlsyslog, i am looking for a way to take the statement for syslog-ng then pipe that into a database, Are you saying you only want to insert *certain* messages into the database? I really don't understand. I see now that my example syslog-ng.conf doesn't have an example line for using sqlsyslogd. If that's what you need, here you go: ---- destination sqlsyslogd { program("/usr/local/sbin/sqlsyslogd -u sqlsyslogd -t logs sqlsyslogd -p"); }; log { source(src); destination(sqlsyslogd); }; ---- "src" in this case is all the incoming messages, there's no filtering of messages. You still need to setup your database according to the instructions for sqlsyslogd. Read the docs that come with it. -- Nate Campi http://www.campin.net GnuPG key: 0xC17AEF79 "My computer's sick. I think my modem is a carrier." _______________________________________________ syslog-ng maillist - syslog-ng(a)lists.balabit.hu https://lists.balabit.hu/mailman/listinfo/syslog-ng

1 0

Re: [syslog-ng]syslog-ng
by Michael Earls 15 Jan '02

15 Jan '02

Ok -- this is what i came up with ,, i am able to get syslog-ng to run b/c it does like like "program" thats if i am correct. destination rrouter { program("/usr/bin/mysql -u root -D rrrouter -t -p")}; filter f_192.168.3.254 { host(192.168.3.254); }; log { source(net); filter(f_192.168.3.254); destination(rrrouter); }; thanks michael >>> nate(a)campin.net 01/14/02 20:16 PM >>> On Mon, Jan 14, 2002 at 07:48:35PM -0500, Michael Earls wrote: > sorry if i am missing something but I do not see that there, i see that u are logging to a host file, or are using sqlsyslog, i am looking for a way to take the statement for syslog-ng then pipe that into a database, Are you saying you only want to insert *certain* messages into the database? I really don't understand. I see now that my example syslog-ng.conf doesn't have an example line for using sqlsyslogd. If that's what you need, here you go: ---- destination sqlsyslogd { program("/usr/local/sbin/sqlsyslogd -u sqlsyslogd -t logs sqlsyslogd -p"); }; log { source(src); destination(sqlsyslogd); }; ---- "src" in this case is all the incoming messages, there's no filtering of messages. You still need to setup your database according to the instructions for sqlsyslogd. Read the docs that come with it. -- Nate Campi http://www.campin.net GnuPG key: 0xC17AEF79 "My computer's sick. I think my modem is a carrier." _______________________________________________ syslog-ng maillist - syslog-ng(a)lists.balabit.hu https://lists.balabit.hu/mailman/listinfo/syslog-ng

1 0

Re: [syslog-ng]syslog-ng
by Michael Earls 15 Jan '02

15 Jan '02

so u are saying that i can write something like this ## tking switch 192.168.3.254 destination 192.168.3.254 {program("/usr/bin/mysql -u sysloguser -t logs 192.168.3.254 -p")}; filter f_192.168.3.254 { host(192.168.3.254); }; log { source(net); filter(f_192.168.3.254); destination(192.168.3.254); }; the databse is logs and the table is 192.168.3.254, am i correct, thanks michael >>> Nate Campi <nate(a)campin.net> 01/14/02 20:07 PM >>> On Mon, Jan 14, 2002 at 07:48:35PM -0500, Michael Earls wrote: > sorry if i am missing something but I do not see that there, i see that u are logging to a host file, or are using sqlsyslog, i am looking for a way to take the statement for syslog-ng then pipe that into a database, Are you saying you only want to insert *certain* messages into the database? I really don't understand. I see now that my example syslog-ng.conf doesn't have an example line for using sqlsyslogd. If that's what you need, here you go: ---- destination sqlsyslogd { program("/usr/local/sbin/sqlsyslogd -u sqlsyslogd -t logs sqlsyslogd -p"); }; log { source(src); destination(sqlsyslogd); }; ---- "src" in this case is all the incoming messages, there's no filtering of messages. You still need to setup your database according to the instructions for sqlsyslogd. Read the docs that come with it. -- Nate Campi http://www.campin.net GnuPG key: 0xC17AEF79 "My computer's sick. I think my modem is a carrier."

1 0

Re: [syslog-ng]syslog-ng
by Nate Campi 15 Jan '02

15 Jan '02

On Mon, Jan 14, 2002 at 07:48:35PM -0500, Michael Earls wrote: > sorry if i am missing something but I do not see that there, i see that u are logging to a host file, or are using sqlsyslog, i am looking for a way to take the statement for syslog-ng then pipe that into a database, Are you saying you only want to insert *certain* messages into the database? I really don't understand. I see now that my example syslog-ng.conf doesn't have an example line for using sqlsyslogd. If that's what you need, here you go: ---- destination sqlsyslogd { program("/usr/local/sbin/sqlsyslogd -u sqlsyslogd -t logs sqlsyslogd -p"); }; log { source(src); destination(sqlsyslogd); }; ---- "src" in this case is all the incoming messages, there's no filtering of messages. You still need to setup your database according to the instructions for sqlsyslogd. Read the docs that come with it. -- Nate Campi http://www.campin.net GnuPG key: 0xC17AEF79 "My computer's sick. I think my modem is a carrier."

1 0

Re: [syslog-ng]syslog-ng
by Michael Earls 15 Jan '02

15 Jan '02

sorry if i am missing something but I do not see that there, i see that u are logging to a host file, or are using sqlsyslog, i am looking for a way to take the statement for syslog-ng then pipe that into a database, do u have an example syslog-ng file and mysql database? mearls >>> nate(a)campin.net 01/14/02 17:57 PM >>> On Mon, Jan 14, 2002 at 04:49:46PM -0500, Michael Earls wrote: > Hi -- i am new here, and was not sure if this has been posted > > i am trying to use syslog-ng to log to a mysql datase, i was told that i could pipe or use program, but i do not know how to, > > my syslog-ng file is very basic, i am adding lines to create sep files like this for each router, is there a way to just pipe this to a mysql database. I put up some pointers on this stuff at http://www.campin.net/newlogcheck.html -- Nate Campi http://www.campin.net GnuPG key: 0xC17AEF79 "Whom computers would destroy, they must first drive mad." -Anon. _______________________________________________ syslog-ng maillist - syslog-ng(a)lists.balabit.hu https://lists.balabit.hu/mailman/listinfo/syslog-ng

1 0

Re: [syslog-ng]syslog-ng
by Michael Earls 15 Jan '02

15 Jan '02

sorry if i am missing something but I do not see that there, i see that u are logging to a host file, or are using sqlsyslog, i am looking for a way to take the statement for syslog-ng then pipe that into a database, do u have an example syslog-ng file and mysql database? mearls >>> nate(a)campin.net 01/14/02 17:57 PM >>> On Mon, Jan 14, 2002 at 04:49:46PM -0500, Michael Earls wrote: > Hi -- i am new here, and was not sure if this has been posted > > i am trying to use syslog-ng to log to a mysql datase, i was told that i could pipe or use program, but i do not know how to, > > my syslog-ng file is very basic, i am adding lines to create sep files like this for each router, is there a way to just pipe this to a mysql database. I put up some pointers on this stuff at http://www.campin.net/newlogcheck.html -- Nate Campi http://www.campin.net GnuPG key: 0xC17AEF79 "Whom computers would destroy, they must first drive mad." -Anon. _______________________________________________ syslog-ng maillist - syslog-ng(a)lists.balabit.hu https://lists.balabit.hu/mailman/listinfo/syslog-ng

1 0

syslog-ng
by Michael Earls 14 Jan '02

14 Jan '02

Hi -- i am new here, and was not sure if this has been posted i am trying to use syslog-ng to log to a mysql datase, i was told that i could pipe or use program, but i do not know how to, my syslog-ng file is very basic, i am adding lines to create sep files like this for each router, is there a way to just pipe this to a mysql database. ### ### 7206-core ### destination 192.168.1.245 { file("/var/log/routers/7206-core.log"); }; filter f_192.168.1.245 { host(192.168.1.245); }; log { source(net); filter(f_192.168.1.245); destination(192.168.1.245); }; ## main router destination 192.168.1.1 { file("/var/log/routers/main-rr.log"); }; filter f_192.168.1.1 { host(192.168.1.1); }; log { source(net); filter(f_192.168.1.1); destination(192.168.1.1); }; ## switch 192.168.1.254 destination 192.168.1.254 { file("/var/log/routers/michaeleaarls-switch.log"); }; filter f_192.168.1.254 { host(192.168.1.254); }; log { source(net); filter(f_192.168.1.254); destination(192.168.1.254); }; ### ### this should work... ### ## tony kings router destination 192.168.3.1 { file("/var/log/routers/tking-main.log"); }; filter f_192.168.3.1 { host(192.168.3.1); }; log { source(net); filter(f_192.168.3.1); destination(192.168.3.1); }; ## tking switch 192.168.3.254 destination 192.168.3.254 { file("/var/log/routers/tking-switch.log"); }; filter f_192.168.3.254 { host(192.168.3.254); }; log { source(net); filter(f_192.168.3.254); destination(192.168.3.254); };

2 1