General:Installation
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 ...