Template:SQWareProduction installation

From Wiki_dbSQWare
Revision as of 10:39, 15 September 2011 by Expdbtools (talk | contribs) (Variables customization)
Jump to: navigation, search

SQWareProduction for {{{1}}}

You have to customize SQWareProduction for {{{1}}} on the focal point $HOME/dbSQWare/SQWareProduction/{{{3}}}/$version/*.

Variables customization

Customize connection variables to SQWareRepository for {{{1}}}:
To customize variables contain in $HOME/dbSQWare/SQWareProduction/{{{3}}}/$version/etc/edt{{{5}}}_DbRefVar.cfg,
put them into $HOME/dbSQWare/SQWareProduction/{{{3}}}/$version/etc_cust/edt{{{5}}}_DbRefVar.cfg.
The user have to be granted 'select', 'update', 'delete', 'insert right on SQWareRepository.
[[SQWareProduction:{{{3}}}#edt{{{5}}}_DbRefVar.cfg | For help on edt{{{5}}}_DbRefVar.cfg]]

Customize if necessary variables contain in $HOME/dbSQWare/SQWareProduction/{{{3}}}/$version/etc/edt{{{5}}}_GlobalVar.cfg,
put them into $HOME/dbSQWare/SQWareProduction/{{{3}}}/$version/etc_cust/edt{{{5}}}_GlobalVar.cfg.
[[SQWareProduction:{{{3}}}#edt{{{5}}}_GlobalVar.cfg | For help on edt{{{5}}}_GlobalVar.cfg]]

Deployement

After that, you can deploy SQWareProduction for {{{1}}} on all your hosts.
Attention, you must have install rsync on all your hosts.
SQWareProduction for {{{1}}} will be deploy in ~$gvsqw_UserUnique{{{1}}}/SQWareProduction/{{{3}}}

#Use SQWareCentral
depl_{{{5}}}

To be able to deploy SQWareProduction, you must set up the SSH public key of user which you have installed SQWareCentral into ~/.ssh/authorized_keys of $gvsqw_UserUnique{{{1}}} on all {{{1}}} hosts.
$gvsqw_RootexpdbCentral/action/{{{3}}}/lst/sqwc_Liste{{{1}}}Unique.ksh should return the host/user list.

Users customization

You must install on an Unix/Linux platform only.
The unix user must have /bin/ksh as shell.
Put these lines in .profile of user that own instance (change ~$gvsqw_UserUnique{{{1}}}).

export gvsqw_{{{6}}}Bin=~$gvsqw_UserUnique{{{1}}}/SQWareProduction/oracle/bin
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_{{{6}}}Bin/../etc/.profile_confort ]
then
   . $gvsqw_{{{6}}}Bin/../etc/.profile_confort
fi


Test your environnement

To test your new environnement:

#reload your profile
. ~/.profile
#to go in SQWareProduction scripts
bin
#to see your customizations
cetc


To check if connection to SQWareRepository is OK for SQWareProduction:

#to go in SQWareProduction scripts
bin
#gather indicators
./edt{{{5}}}_GatherIndicators.ksh {{{7}}}

The command should gather indicator and insert it in SQWareRepository for {{{1}}}.