Difference between revisions of "Template:SQWareProduction installation"

From Wiki_dbSQWare
Jump to: navigation, search
(Variables customization)
(SQWareProduction for {{{1}}})
Line 1: Line 1:
 
==== SQWareProduction for {{{1}}} ====
 
==== SQWareProduction for {{{1}}} ====
You have to customize SQWareProduction for {{{1}}} on the focal point $HOME/dbSQWare/SQWareProduction/{{{3}}}/$version/*.<br>
+
You have to customize SQWareProduction for {{{1}}} on the focal point $HOME/dbSQWare/SQWareProduction/{{{3}}}/*.<br>
 
<br>
 
<br>
 
===== Variables customization =====
 
===== Variables customization =====
Customize connection variables to SQWareRepository for {{{1}}}:<br>
+
Customize if necessary variables contain in $HOME/dbSQWare/SQWareProduction/{{{3}}}/etc/sqw{{{5}}}_GlobalVar.cfg,<br>
To customize variables contain in $HOME/dbSQWare/SQWareProduction/{{{3}}}/$version/etc/edt{{{5}}}_DbRefVar.cfg,<br>
+
put them into $HOME/dbSQWare/SQWareProduction/{{{3}}}/etc_cust/sqw{{{5}}}_GlobalVar.cfg.<br>
put them into $HOME/dbSQWare/SQWareProduction/{{{3}}}/$version/etc_cust/edt{{{5}}}_DbRefVar.cfg.<br>
+
[[SQWareProduction:{{{3}}}#sqw{{{5}}}_GlobalVar.cfg | For help on sqw{{{5}}}_GlobalVar.cfg]]<br>
The user have to be granted 'select', 'update', 'delete', 'insert right on SQWareRepository.<br>
 
[[SQWareProduction:{{{3}}}#edt{{{5}}}_DbRefVar.cfg | For help on edt{{{5}}}_DbRefVar.cfg]]<br>
 
<br>
 
Customize if necessary variables contain in $HOME/dbSQWare/SQWareProduction/{{{3}}}/$version/etc/edt{{{5}}}_GlobalVar.cfg,<br>
 
put them into $HOME/dbSQWare/SQWareProduction/{{{3}}}/$version/etc_cust/edt{{{5}}}_GlobalVar.cfg.<br>
 
[[SQWareProduction:{{{3}}}#edt{{{5}}}_GlobalVar.cfg | For help on edt{{{5}}}_GlobalVar.cfg]]<br>
 
 
<br>
 
<br>
  
Line 25: Line 19:
 
===== Users customization =====
 
===== Users customization =====
 
'''You must install on an Unix/Linux platform only.'''<br>
 
'''You must install on an Unix/Linux platform only.'''<br>
The unix user must have /bin/ksh as shell.<br>
+
The unix user must have /bin/ksh as shell. User must also have access to a MySQL client (to load indicators).<br>
 
Put these lines in .profile of user that own instance (change ~$gvsqw_UserUnique{{{1}}}).<br>
 
Put these lines in .profile of user that own instance (change ~$gvsqw_UserUnique{{{1}}}).<br>
  export gvsqw_{{{6}}}Bin=~$gvsqw_UserUnique{{{1}}}/SQWareProduction/oracle/bin
+
  export gvsqw_{{{6}}}Bin=~$gvsqw_UserUnique{{{1}}}/SQWareProduction/{{{3}}}/bin
 
  lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
 
  lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
 
  if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_{{{6}}}Bin/../etc/.profile_confort ]
 
  if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_{{{6}}}Bin/../etc/.profile_confort ]
Line 47: Line 41:
 
  bin
 
  bin
 
  #gather indicators
 
  #gather indicators
  ./edt{{{5}}}_GatherIndicators.ksh {{{7}}}
+
  ./sqw{{{5}}}_GatherIndicators.ksh {{{7}}}
 
The command should gather indicator and insert it in SQWareRepository for {{{1}}}.<br>
 
The command should gather indicator and insert it in SQWareRepository for {{{1}}}.<br>
 
<br>
 
<br>

Revision as of 17:00, 6 April 2014

SQWareProduction for {{{1}}}

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

Variables customization

Customize if necessary variables contain in $HOME/dbSQWare/SQWareProduction/{{{3}}}/etc/sqw{{{5}}}_GlobalVar.cfg,
put them into $HOME/dbSQWare/SQWareProduction/{{{3}}}/etc_cust/sqw{{{5}}}_GlobalVar.cfg.
[[SQWareProduction:{{{3}}}#sqw{{{5}}}_GlobalVar.cfg | For help on sqw{{{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. User must also have access to a MySQL client (to load indicators).
Put these lines in .profile of user that own instance (change ~$gvsqw_UserUnique{{{1}}}).

export gvsqw_{{{6}}}Bin=~$gvsqw_UserUnique{{{1}}}/SQWareProduction/{{{3}}}/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
./sqw{{{5}}}_GatherIndicators.ksh {{{7}}}

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