Re: Msyslog problem

[Wouter Clarie <rimshot@pandora.be>]

This is a list for technical discussion about OpenBSD, not about msyslog
or Redhat or whatever. Please post to an appropriate list.

//Wouter

On Thu, 12 Jun 2003, Raimundas wrote:

> Hello,
>
> I'm just start using msyslog. Becouse msyslog can log alarms into mysql
> database. But when I start msyslog they only log data to file but not into
> mysql DB. I can't find problem. Maybe you can.
>
> First step I use 1.08e rpm, bute later use 1.08g. Its the same problem.
> My OS -> RedHat 7.3 Profesional
> My config files
>
> I edit /etc/init.d/msyslog service control script:
> before:daemon msyslogd $CONFIG $DEBUG $MARK $IM_BSD $IM_DOORS $IM_LINUX
> $IM_STREAMS $IM_TCP $IM_UDP $IM_UNIX
> over:daemon msyslogd $CONFIG $DEBUG $MARK $IM_BSD $IM_DOORS $IM_LINUX
> $IM_STREAMS $IM_TCP $IM_UDP $IM_UNIX -i udp -p 514 -i om_mysql
>
> /etc/syslog.conf
> *.*             %mysql -s 127.0.0.1 -u logeruser -p logerpass -d logd -t
> syslogTB
> *.*     %classic /var/log/test
>
> /etc/sysconfig/msyslog
> CONFIG=""                       # example: "-f /etc/syslog.conf"
> DEBUG=""                        # example: "-d 20"
> MARK=""                         # example: "-m 20"
> IM_BSD=""                       # example: "-i bsd"
> IM_DOORS=""                     # example: "-i doors"
> #IM_LINUX="-i linux"            # example: "-i linux"
> IM_LINUX=""
> IM_STREAMS=""                   # example: "-i streams"
> IM_TCP=""                       # example: "-i tcp accepted.host.com 514"
> IM_UDP=""                       # example: "-i udp:514"
> #IM_UNIX="-i unix"              # example: "-i unix"
> IM_UNIX=""
> # Look in the im_*.8 man pages for more details on these options
>
> P.S. Server doesnt start when i write just lines with mysql loging rules ir
> syslog.conf
> I don't understand why msyslog not connecting tu mysql server. I'm loging all
> mysql querys and there no one query find about msyslog connection.
>
> Please help me.
>
> Best Regards.
> Raimundas Slavinskas