Difference between revisions of "General:Installation"
Expdbtools (talk | contribs) (→SQWareCentral for Oracle) |
Expdbtools (talk | contribs) (→SQWareCentral for Oracle) |
||
Line 105: | Line 105: | ||
To customize variables contain in $gvsqw_RootexpdbCentral/action/oracle/etc/sqwc_DbRefVar.cfg,<br> | To customize variables contain in $gvsqw_RootexpdbCentral/action/oracle/etc/sqwc_DbRefVar.cfg,<br> | ||
put them into $gvsqw_RootexpdbCentral/action/oracle/etc_cust/sqwc_DbRefVar.cfg.<br> | put them into $gvsqw_RootexpdbCentral/action/oracle/etc_cust/sqwc_DbRefVar.cfg.<br> | ||
+ | The user can only have 'select' right on SQWareRepository.<br> | ||
[[SQWareCentral:oracle#sqwc_DbRefVar.cfg | For help on sqwc_DbRefVar.cfg for oracle]]<br> | [[SQWareCentral:oracle#sqwc_DbRefVar.cfg | For help on sqwc_DbRefVar.cfg for oracle]]<br> | ||
To check if connection to SQWareRepository is OK for SQWareCentral, reload environnement and test list generation:<br> | To check if connection to SQWareRepository is OK for SQWareCentral, reload environnement and test list generation:<br> |
Revision as of 23:28, 23 December 2010
Install sources of all modules on focal point
Prepare archive file of all modules
You must install on an Unix/Linux platform only.
The unix user must have /bin/ksh as shell.
#Create base directory of dbSQWare™ mkdir -p $HOME/dbSQWare #Move zip of lastest full version cp ~/downloads/dbSQWare_full_*.zip $HOME/dbSQWare/. #Unzip file cd $HOME/dbSQWare unzip dbSQWare_full_*.zip #Delete zip file rm -f dbSQWare_full_*.zip
Extract archives of all modules
#gunzip and extract archive of all modules for lvsqw_Archive in `ls SQWare*.tgz` do lvsqw_Module=$(echo "$lvsqw_Archive"|sed 's,_full_v..*tgz$,,') mkdir -p $HOME/dbSQWare/$lvsqw_Module cd $HOME/dbSQWare/$lvsqw_Module echo echo "extract $lvsqw_Archive for $lvsqw_Module :" gunzip -c ../$lvsqw_Archive |tar -xvf - done #Delete archive file cd $HOME/dbSQWare rm -f expdb*.tgz
You must have:
$HOME/dbSQWare/SQWareCentral
$HOME/dbSQWare/SQWareProduction
$HOME/dbSQWare/SQWareRepository
$HOME/dbSQWare/SQWareWeb
Modules configuration
SQWareRepository
If you want use the full capability of dbSQWare, you have to install it.
If you don't install SQWareRepository you can't use SQWareCentral nor SQWareWeb.
Module SQWareProduction can only run alone.
SQWareRepository for Oracle
Install Oracle schema with script ~/dbSQWare/SQWareRepository/oracle/v*/sql/sqwora_CreateIndicatorsTbsUsers.sql
Install tables with script ~/dbSQWare/SQWareRepository/oracle/v*/sqwora_CreateIndicatorsObjectsFull.sql
Complete table tsqw_Repository with your CMDB.
Sample of insert query:
insert into tsqw_Repository ...
SQWareRepository for Sybase
Create a Sybase database to store CMDB and indicators.
Install tables with script ~/dbSQWare/SQWareRepository/sybase/v*/sqwsyb_CreateIndicatorsObjectsFull.sql
Complete table tsqw_Repository with your CMDB.
Sample of insert query:
insert into tsqw_Repository ...
SQWareRepository for MsSql
Create a MsSql database to store CMDB and indicators.
Install tables with script ~/dbSQWare/SQWareRepository/mssql/v*/sqwmsq_CreateIndicatorsObjectsFull.sql
Complete table tsqw_Repository with your CMDB.
Sample of insert query:
insert into tsqw_Repository ...
SQWareRepository for MySql
Create a MySql database to store CMDB and indicators.
Install tables with script ~/dbSQWare/SQWareRepository/mysql/v*/sqwmys_CreateIndicatorsObjectsFull.sql
Complete table tsqw_Repository with your CMDB.
Sample of insert query:
insert into tsqw_Repository ...
SQWareRepository for Ingres
Create a MySql database to store CMDB and indicators.
Install tables with script ~/dbSQWare/SQWareRepository/ingres/v*/sqwing_CreateIndicatorsObjectsFull.sql
Complete table tsqw_Repository with your CMDB.
Sample of insert query:
insert into tsqw_Repository ...
SQWareCentral
It's the focal point of dbSQWare.
You must install SQWareRepository before installing SQWareCentral.
You must install on an Unix/Linux platform only.
The unix user must have /bin/ksh as shell.
SQWareCentral core
Make a link to current version (change this link to upgrade version).
cd ~/dbSQWare/SQWareCentral ln -s v1.2 prod
Put variable gvsqw_RootexpdbCentral into your .profile and source of SQWareCentral environnement.
export gvsqw_RootexpdbCentral=$HOME/dbSQWare/SQWareCentral/prod . $gvsqw_RootexpdbCentral/etc/.profile
Customize variables for your own environnement:
To customize variables contain in $gvsqw_RootexpdbCentral/etc/sqwc_GlobalVar.cfg,
put them into $gvsqw_RootexpdbCentral/etc_cust/sqwc_GlobalVar.cfg.
In general case, you just have to customize gvsqw_Mail_central (email adress to send report).
For help on sqwc_GlobalVar.cfg
SQWareCentral for Oracle
Install an Oracle client and configure it to be able to connect to SQWareRepository for Oracle you have installed.
When connection to SQWareRepository is OK, customize connection variables:
To customize variables contain in $gvsqw_RootexpdbCentral/action/oracle/etc/sqwc_DbRefVar.cfg,
put them into $gvsqw_RootexpdbCentral/action/oracle/etc_cust/sqwc_DbRefVar.cfg.
The user can only have 'select' right on SQWareRepository.
For help on sqwc_DbRefVar.cfg for oracle
To check if connection to SQWareRepository is OK for SQWareCentral, reload environnement and test list generation:
#to reload environnement reload #to test list generation $gvsqw_RootexpdbCentral/action/oracle/lst/sqwora_GenLstInstance.ksh
The command should return the instances list that you configured in SQWareRepository for Oracle.
To customize variables contain in $gvsqw_RootexpdbCentral/action/oracle/etc/sqwc_GlobalVar.cfg,
put them into $gvsqw_RootexpdbCentral/action/oracle/etc_cust/sqwc_GlobalVar.cfg.
In general case, you just have to customize gvsqw_UserUniqueOracle if you want to change user who owns SQWareProduction for Oracle on all host.
For help on sqwc_GlobalVar.cfg for oracle
To customize variables contain in $gvsqw_RootexpdbCentral/action/oracle/etc/sqwc_ExpVar.cfg,
put them into $gvsqw_RootexpdbCentral/action/oracle/etc_cust/sqwc_ExpVar.cfg.
In general case, you just have to customize gvsqw_Mail_oracle (email adress to send report).
For help on sqwc_ExpVar.cfg for oracle
After that, you can put in place automatic treatment for Oracle.
You can take example on $gvsqw_RootexpdbCentral/action/oracle/etc/CrontabRef.cfg
Attention, you must first put in place SQWareProduction for Oracle before to collect indicators for example!
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_UserUniqueOracle on all Oracle hosts.
$gvsqw_RootexpdbCentral/action/oracle/lst/sqwora_GenLstUnique.ksh should return the host/user list.
To be able to perform centralized commands of SQWareProduction, you must set up the SSH public key of user which you have installed SQWareCentral into ~/.ssh/authorized_keys of users who owns Oracle instances.
$gvsqw_RootexpdbCentral/action/oracle/lst/sqwora_GenLstInstance.ksh should return the host/user/instance list.