Difference between revisions of "Template:SQWareProduction installation"

From Wiki_dbSQWare
Jump to: navigation, search
(Created page with '==== SQWareProduction for {{{1}}} ==== You have to customize SQWareProduction for {{{1}}} on the focal point $HOME/dbSQWare/SQWareProduction/{{{3}}}/$version/*.<br> <br> ===== Va…')
 
(Users customization)
 
(6 intermediate revisions by the same user not shown)
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>
+
 
 
===== 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>
 
The user have to be granted 'select', 'update', 'delete', 'insert right on SQWareRepository.<br>
 
[[SQWareProduction:{{{3}}}#edt{{{5}}}_GlobalVar.cfg | For help on edt{{{5}}}_GlobalVar.cfg]]<br>
 
<br>
 
 
===== Deployement =====
 
===== Deployement =====
 
After that, you can deploy SQWareProduction for {{{1}}} on all your hosts.<br>
 
After that, you can deploy SQWareProduction for {{{1}}} on all your hosts.<br>
 
'''Attention''', you must have install '''rsync''' on all your hosts.<br>
 
'''Attention''', you must have install '''rsync''' on all your hosts.<br>
SQWareProduction for {{{1}}} will be deploy in ~$gvsqw_UserUnique{{{1}}}/SQWareProduction/{{{3}}}
+
SQWareProduction for {{{1}}} will be deploy in ~$gvsqw_UserUnique/SQWareProduction/{{{3}}}
 
  #Use SQWareCentral
 
  #Use SQWareCentral
 
  depl_{{{5}}}
 
  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.<br>
+
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 on all {{{1}}} hosts.<br>
$gvsqw_RootexpdbCentral/action/{{{3}}}/lst/sqwc_Liste{{{1}}}Unique.ksh should return the host/user list.<br>
+
 
<br>
 
 
===== 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).<br>
  export gvsqw_{{{6}}}Bin=~$gvsqw_UserUnique{{{1}}}/SQWareProduction/oracle/bin
+
  export gvsqw_{{{6}}}Bin=~$gvsqw_UserUnique/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 33: Line 25:
 
     . $gvsqw_{{{6}}}Bin/../etc/.profile_confort
 
     . $gvsqw_{{{6}}}Bin/../etc/.profile_confort
 
  fi
 
  fi
<br>
+
 
 
===== Test your environnement =====
 
===== Test your environnement =====
 
To test your new environnement:<br>
 
To test your new environnement:<br>
Line 42: Line 34:
 
  #to see your customizations
 
  #to see your customizations
 
  cetc
 
  cetc
<br>
+
 
 
To check if connection to SQWareRepository is OK for SQWareProduction:<br>
 
To check if connection to SQWareRepository is OK for SQWareProduction:<br>
 
  #to go in SQWareProduction scripts
 
  #to go in SQWareProduction scripts
 
  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.<br>
<br>
 

Latest revision as of 17:20, 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/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 on all {{{1}}} hosts.

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).

export gvsqw_{{{6}}}Bin=~$gvsqw_UserUnique/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.