Difference between revisions of "General:Installation"

From Wiki_dbSQWare
Jump to: navigation, search
(Prepare archive file of all modules)
(Prepare archive file of all modules)
Line 1: Line 1:
 
== Install sources of all modules on focal point ==
 
== Install sources of all modules on focal point ==
 
=== Prepare archive file of all modules ===
 
=== Prepare archive file of all modules ===
'''You must install on an Unix/Linux platform only.'''<br><br>
+
'''You must install on an Unix/Linux platform only.'''<br>
 +
The unix user must have /bin/ksh as shell.<br><br>
 
  #Create base directory of dbSQWare™
 
  #Create base directory of dbSQWare™
 
  mkdir -p $HOME/dbSQWare
 
  mkdir -p $HOME/dbSQWare

Revision as of 22:17, 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 ...