What does, ps=`ps -ax | grep "\--password=x" | awk '{ print $9 }'` do and how do you know it is not running? -Steve S.

-----Original Message----- From: syslog-ng-admin@lists.balabit.hu [mailto:syslog-ng- admin@lists.balabit.hu] On Behalf Of Robert.COward@deploymenthealth.osd.mil Sent: Wednesday, January 05, 2005 9:15 AM To: syslog-ng@lists.balabit.hu Cc: ssurdock@engineered-net.com Subject: RE: [syslog-ng]MYSQL pipe 2

Steven,

Thanks for the quick response. here is what my mysql entry looks like in /etc/rc.local:

# MYSQL if [ X"${mysql}" == X"YES" ]; then if [ -x /usr/local/bin/mysqld_safe ]; then echo -n " mysql"; /usr/local/bin/mysqld_safe --socket=/var/www/var/run/mysql/mysql.sock & sleep 10 echo -n " syslog-ng2mysql"; /etc/check_syslog-ng2mysql.sh & fi fi

and here is the /etc/check_syslog-ng2mysql.sh script i sent in yesterday:

#!/bin/sh ps=`ps -ax | grep "\--password=x" | awk '{ print $9 }'`

if [[ $ps != "" ]]; then echo "syslog-ng2mysql is alive." else if [ ! -p /tmp/mysql.pipe ]; then mkfifo /tmp/mysql.pipe kill -HUP `cat /var/run/syslog-ng.pid` fi mysql -u root --password=password syslog < /tmp/mysql.pipe fi

I don't think the problem is that mysqld is not started when i issue the mysql command in the script. I think it has something to do with how openbsd starts daemons from within /etc/rc.local and /etc/rc. When i reboot this server, the /etc/check_syslog-ng2mysql.sh does nto start at all. Basically I am just looking for other ways to start /etc/check_syslog-ng2mysql.sh or more to the point the "mysql -u root --password=password syslog < /tmp/mysql.pipe" line which just dumps the data from a named pipe created by syslog-ng, over to the mysql db. Thanks for all the help.