General:Installation: Difference between revisions

From Wiki_dbSQWare
Jump to navigation Jump to search
No edit summary
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 ===
  #Create base directory of expdbTools®
  #Create base directory of dbSQWare™
  mkdir -p $HOME/expdbTools
  mkdir -p $HOME/dbSQWare
   
   
  #Move zip of lastest full version
  #Move zip of lastest full version
  cp ~/downloads/expdbTools_full_*.zip $HOME/expdbTools/.
  cp ~/downloads/dbSQWare_full_*.zip $HOME/dbSQWare/.
   
   
  #Unzip file
  #Unzip file
  cd $HOME/expdbTools
  cd $HOME/dbSQWare
  unzip expdbTools_full_*.zip
  unzip dbSQWare_full_*.zip
   
   
  #Delete zip file
  #Delete zip file
  rm -f expdbTools_full_*.zip
  rm -f dbSQWare_full_*.zip
<br>
<br>
=== Extract archives of all modules ===
=== Extract archives of all modules ===
  #gunzip and extract archive of all modules
  #gunzip and extract archive of all modules
  for lvsqw_Archive in `ls expdb*.tgz`
  for lvsqw_Archive in `ls SQWare*.tgz`
  do
  do
     lvsqw_Module=$(echo "$lvsqw_Archive"|sed 's,_full_v..*tgz$,,')
     lvsqw_Module=$(echo "$lvsqw_Archive"|sed 's,_full_v..*tgz$,,')
     mkdir -p $HOME/expdbTools/$lvsqw_Module
     mkdir -p $HOME/dbSQWare/$lvsqw_Module
     cd $HOME/expdbTools/$lvsqw_Module
     cd $HOME/dbSQWare/$lvsqw_Module
     echo  
     echo  
     echo "extract $lvsqw_Archive for $lvsqw_Module :"
     echo "extract $lvsqw_Archive for $lvsqw_Module :"
Line 27: Line 27:
   
   
  #Delete archive file
  #Delete archive file
  cd $HOME/expdbTools
  cd $HOME/dbSQWare
  rm -f expdb*.tgz
  rm -f expdb*.tgz
<br>
<br>
Line 33: Line 33:
=== expdbDB ===
=== expdbDB ===
If you want use the full capability of dbSQWare, you have to install it.<br>
If you want use the full capability of dbSQWare, you have to install it.<br>
If you don't install expdbDB you can't use SQWareCentral nor SQWareWeb.<br>
If you don't install SQWareRepository you can't use SQWareCentral nor SQWareWeb.<br>
Module SQWareProduction can only run alone.<br>
Module SQWareProduction can only run alone.<br>
==== For Oracle ====
==== For Oracle ====
Install Oracle schema with script ~/expdbTools/SQWareRepository/oracle/v*/edtd_CreateUserIndicator.sql<br>
Install Oracle schema with script ~/dbSQWare/SQWareRepository/oracle/v*/sql/sqwora_CreateIndicatorsTbsUsers.sql<br>
Install tables with script ~/expdbTools/SQWareRepository/oracle/v*/edtd_CreateTablesIndicators.sql<br>
Install tables with script ~/dbSQWare/SQWareRepository/oracle/v*/sqwora_CreateIndicatorsObjectsFull.sql<br>
Populate table tsqw_Repository with your CMDB.<br>
Complete table tsqw_Repository with your CMDB.<br>
Sample of insert query:<br>
Sample of insert query:<br>
  insert into tsqw_Repository ...
  insert into tsqw_Repository ...
Line 45: Line 45:
==== For Sybase ====
==== For Sybase ====
Create a Sybase database to store CMDB and indicators.<br>
Create a Sybase database to store CMDB and indicators.<br>
Install tables with script ~/expdbTools/SQWareRepository/sybase/v*/edtd_CreateTablesIndicators.sql<br>
Install tables with script ~/dbSQWare/SQWareRepository/sybase/v*/sqwsyb_CreateIndicatorsObjectsFull.sql<br>
Populate table tsqw_Repository with your CMDB.<br>
Complete table tsqw_Repository with your CMDB.<br>
Sample of insert query:<br>
Sample of insert query:<br>
  insert into tsqw_Repository ...
  insert into tsqw_Repository ...
Line 52: Line 52:
==== For MsSql ====
==== For MsSql ====
Create a MsSql database to store CMDB and indicators.<br>
Create a MsSql database to store CMDB and indicators.<br>
Install tables with script ~/expdbTools/SQWareRepository/mssql/v*/edtd_CreateTablesIndicators.sql<br>
Install tables with script ~/dbSQWare/SQWareRepository/mssql/v*/sqwmsq_CreateIndicatorsObjectsFull.sql<br>
Populate table tsqw_Repository with your CMDB.<br>
Complete table tsqw_Repository with your CMDB.<br>
Sample of insert query:<br>
Sample of insert query:<br>
  insert into tsqw_Repository ...
  insert into tsqw_Repository ...
Line 59: Line 59:
==== For MySql ====
==== For MySql ====
Create a MySql database to store CMDB and indicators.<br>
Create a MySql database to store CMDB and indicators.<br>
Install tables with script ~/expdbTools/SQWareRepository/mysql/v*/edtd_CreateTablesIndicators.sql<br>
Install tables with script ~/dbSQWare/SQWareRepository/mysql/v*/sqwmys_CreateIndicatorsObjectsFull.sql<br>
Populate table tsqw_Repository with your CMDB.<br>
Complete table tsqw_Repository with your CMDB.<br>
Sample of insert query:<br>
Sample of insert query:<br>
  insert into tsqw_Repository ...
  insert into tsqw_Repository ...
Line 66: Line 66:
==== For Ingres ====
==== For Ingres ====
Create a MySql database to store CMDB and indicators.<br>
Create a MySql database to store CMDB and indicators.<br>
Install tables with script ~/expdbTools/SQWareRepository/ingres/v*/edtd_CreateTablesIndicators.sql<br>
Install tables with script ~/dbSQWare/SQWareRepository/ingres/v*/sqwing_CreateIndicatorsObjectsFull.sql<br>
Populate table tsqw_Repository with your CMDB.<br>
Complete table tsqw_Repository with your CMDB.<br>
Sample of insert query:<br>
Sample of insert query:<br>
  insert into tsqw_Repository ...
  insert into tsqw_Repository ...
<br>
<br>

Revision as of 22:38, 23 December 2010

Install sources of all modules on focal point

Prepare archive file of all modules

#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


Modules configuration

expdbDB

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.

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


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


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


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


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