SuSE

Hi

I have a script myscript.sh that needs to be run whenever the server boots. The script is actually logging Syslog-ng messages to sql server. I need to lauch it at startup

I have copied the script in etc/init.d

i have also added the link

Code:

ln -s /etc/init.d/syslog-ng-mssql-pipe.sh /etc/init.d/rc5.d/S99syslog-ng-mssql-pipe

It doesnt work


Please help

In order for this to work you need to follow a template based on LSB init scripts. If you would like to run your script at boot, simply put the full path in the boot.local file. If you want to make it an init script, rewrite the script to follow the same preprocess header style as the other suse init scripts.

It would be simpler to put it into the boot.local. Do realize, that if your script needs parameters from a real user's environment, that you will need to source those into your script's environment.

Hi

I did wat u said that is i put the path in the boot.local file.

But when loading the system hangs there

Code:

Mounting securityfs on /sys/kernel/security done
Loading AppArmor module done
Loading AppArmor profiles done
System Boot Control: The system has been set up
Skipped features: boot.cycle
System Boot Control: Running /etc/init.d/boot.local
INN

INN is a message that i displayed in the script.

The script reads from a FIFO (pipe) file. So it hangs there waiting..

Nothing else is loaded..

How do i go abt it

Please post in clear (as clear as you can) English. People here speak different native languages and it is often unclear when shortcuts or leetspeak is used.
Right now, I am unclear as to what you are asking, and I am a native English speaker.

Why is this waiting for a pipe? Your script itself may be broken. Did you do what I had said earlier and ensure your environment is set up correctly?

When you run a script after logging in, the script will take your environment. When you automate it that does not often happen.

Perhaps if you post the script (with code tags), I or somebody else may be able to help you.

Hi,

Let me try to explain what the script (pasted below) actually does.

I have syslog-ng installed on a server. It logs all messages (example firewall logs) from different clients. But the log messages are stored in a database.

When i launch the script manually (via putty), it works fine, but eventually when i quit putty, the script stops.

So basically messages are sent to a pipe file namely mssql.syslog-ng.pipe, then messages from there are written to database. As you can see its in a while loop, so it waits permanently for messages. Thats the way it should be. It should run in the background actually. My problem is i dont know how to make it start whenever the server starts and it should run in the background.

What i meant by it hangs in my previous post was it was waiting messages, so it hangs there waiting and the server is not loaded completely. Its not like you are starting oracle on startup and it gets started and the server proceeds with other processes.

I dont know if its clear enough now, but im still trying to find out a solution.

Thanks

Code:

#!/bin/sh
#
# File: syslogng-mssql-pipe.sh
#
# Take input from a FIFO and run execute it as a query for
# a sqlserver database.
#


if [ -e /tmp/mssql.syslog-ng.pipe ]; then
       while [ -e /tmp/mssql.syslog-ng.pipe ]
                do
                       echo "INN"
                       isql -v MSTEST "sa" "password" </tmp/mssql.syslog-ng.pipe
                done
else
        mkfifo /tmp/mssql.syslog-ng.pipe
fi

Have you tried using a template to create a startup script?

The init scripts in suse allow for prerequisites such as mysql being up if that is what you wish.

Cool Solutions: Creating Custom init Scripts should help you out