I'm trying to put together an init script to stop and start Ingres on a few machines. The problem is that the hosts have differently engineered Ingres installations so the bin type folders are in different locations.
Ideally I would like a '1 script fits all' and the idea we were working with was calling the .profile of the ingres user which always sits in /home/ingres.
The script I have so far is as follows:
su - ingres -c ". $HOME/.profile"
the problem is, the echo commands are showing the variables for root and not for ingres.
If I go through this step by step I get the expected results i.e. the ingres variables.
Can anyone please help?