Ryszard Musielak
Member
Hello,
I know this may be a basic question. I have a third party company who installed my Progress system (Red Hat Linux), an application based on 4GL, etc. I received some basic training on how to start the database and stuff (I mean apps server services). My background is mainly Oracle, so I can only have some assumptions on how things work. The problem is I can't sometimes get an exact answer from my third party, that's why I would like you to help me a bit.
We use a script setup to start the database and services. I also wrote (over the course of a few weeks) a script that monitors the part that have to be running. This is what I need and check - for clarity just some snippets...:
This is the code that starts the datebase:
Normally the start script is supposed to be executed from the ROOT account (the WHO in the subject). However I once received some vague information that some of the services should not be started as ROOT, but database admin. The UNIX account for that is called "bcp", I can (and usually do) start the database as that user, but then I get another confused message that one service has to run as ROOT.
Can anyone shed some light on this subject?
I believe the DB and software was installed as "bcp", but I am not sure. I was not involved (sadly) in the installation process, as I would have seen it.
I would appreciate your thoughts on what approach you all have?
Thanks,
Richard
I know this may be a basic question. I have a third party company who installed my Progress system (Red Hat Linux), an application based on 4GL, etc. I received some basic training on how to start the database and stuff (I mean apps server services). My background is mainly Oracle, so I can only have some assumptions on how things work. The problem is I can't sometimes get an exact answer from my third party, that's why I would like you to help me a bit.
We use a script setup to start the database and services. I also wrote (over the course of a few weeks) a script that monitors the part that have to be running. This is what I need and check - for clarity just some snippets...:
Code:
# Check if Admin Server is running
proadsv -q
proutil package -C holder
# Name server running?
nsman -i NS1 -q
# ASBMAN broker check...
asbman -i AccordLive -q
This is the code that starts the datebase:
Code:
#*** Remove comments as required
proutil package -C holder 1>/dev/null
retcode=$? # this saves the return code
case $retcode in
14) echo "The database is in maintenance mode and will not start."
echo "If this is unexpected call BCP Support on 0161 355 3002"
exit;;
0) proserve package -pf broker.pf # Serve the database
probiw package # Enterprise Progress
proapw package # Enterprise Progress
proapw package # Enterprise Progress
proserve package -pf sqlbroker.pf # SQL - Unixware problem
prowdog package # Enterprise Progress
sleep 5 # Pause 5 seconds
asbman -i AccordLive -stop 1>/dev/null # App server
# wtbman -i wsbroker1 -stop 1>/dev/null # Web server
sleep 5 # Pause 5 seconds
asbman -i AccordLive -start # App server
# wtbman -i wsbroker1 -start # Web server;;
esac
Normally the start script is supposed to be executed from the ROOT account (the WHO in the subject). However I once received some vague information that some of the services should not be started as ROOT, but database admin. The UNIX account for that is called "bcp", I can (and usually do) start the database as that user, but then I get another confused message that one service has to run as ROOT.
Can anyone shed some light on this subject?
I believe the DB and software was installed as "bcp", but I am not sure. I was not involved (sadly) in the installation process, as I would have seen it.
I would appreciate your thoughts on what approach you all have?
Thanks,
Richard