Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: cavagnaro on September 21, 2013, 04:14:18 AM

Title: DBserver on Linux startup issue
Post by: cavagnaro on September 21, 2013, 04:14:18 AM
Hi guys,
I'm having a little issue here.
I'm installing a DBServer on Linux for tests and the issue is that if I start it from command line (run.sh) it works fine, clients can do queries and stuff. However if I start it via SCI then seems it can't get the Environment variables I declared on bashrc (Oracle ones) and can't make it work, getting error code 1127. Any idea on how to solve this? Seems to be how LCA sends the start command but can't figure out how it does the execution.

This is my bashrc Oracle variables:
[quote]
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export ORACLE_BASE=/u01/app/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH
[/quote]

Thanks
Title: Re: DBserver on Linux startup issue
Post by: Kubig on September 21, 2013, 08:16:21 AM
The user account under which is the LCA running has these environment variables in his profile?Try to log in under this account and look at the env or try to restart LCA, I remember that in a past I have registered similiar issue, when the LCA was badly cached the profile.
Title: Re: DBserver on Linux startup issue
Post by: cavagnaro on September 21, 2013, 06:53:13 PM
LCA is running under root, the same account I'm using to start the DBserver manually, the Cfg DBserver does work fine but of course a starting it manually...really don't understand what am I missing... :/
Title: Re: DBserver on Linux startup issue
Post by: Kubig on September 22, 2013, 08:12:25 AM
Could you post logs fragment covering the error message?
Title: Re: DBserver on Linux startup issue
Post by: bublepaw on September 22, 2013, 11:08:27 AM
Last time I had similar case and I didn't have time to solve it properly so I added oracle exports to lca startup script
Title: Re: DBserver on Linux startup issue
Post by: cavagnaro on September 22, 2013, 08:16:57 PM
[quote author=bublepaw link=topic=8006.msg35171#msg35171 date=1379848107]
Last time I had similar case and I didn't have time to solve it properly so I added oracle exports to lca startup script
[/quote]
Well this worked...but why...then what environment variables does LCA uses??
Title: Re: DBserver on Linux startup issue
Post by: cavagnaro on September 22, 2013, 09:34:33 PM
Added the variables to bash_profile instead of bashrc and same bad behavior. Launching manually does work fine...
Title: Re: DBserver on Linux startup issue
Post by: cavagnaro on September 22, 2013, 10:05:07 PM
Well created a custom script inside /etc/profile.d/ (gcti.sh) and still didn't work...
Adding to /etc/environment fucked the system :P
Continuing tests

Well modifying /etc/environment properly seems to be the path, but now the listener doesn't start....
Seems easiest way is just to declare variables under LCA (/etc/init.d/gctilca) script... as bublepaw suggested
Title: Re: DBserver on Linux startup issue
Post by: borkokrz on September 27, 2013, 07:45:56 AM
you can also add variables to run.sh in DBServer directory and change application option 'command line' in CME from multiserver to run.sh. This should also work just fine and doesn't need to restart lca if this is case for you.
Title: Re: DBserver on Linux startup issue
Post by: cavagnaro on September 27, 2013, 09:47:01 AM
Why not? modifying LCA init.d script does the job...once and done. Not like a change that has to be done everytime.
Title: Re: DBserver on Linux startup issue
Post by: Steve on September 27, 2013, 09:55:03 AM
Kubig, Why is that? The important thing in production is that it works and is stable, all of these solutions meet that requirement.

On all varieties on Unix you need to force LCA to pick up the profile before calling the application.
 
The only thing I wouldn't allow in production is applications running as root.
Title: Re: DBserver on Linux startup issue
Post by: cavagnaro on September 27, 2013, 01:34:15 PM
Gee Kubig how continuously you change Database client software? You add only to LCA script the Oracle variables needed and same to bashrc. So how many? 2.
Why would adding another global environment variable would affect the already existing ones? Sometimes you really just exaggerating everything man... chill down a little bit... and coming from me says a lot lol...
Don't try to find the 5th leg to everything you see because it is not like that...