Difference between revisions of "General:Installation"

From Wiki_dbSQWare
Jump to: navigation, search
(→‎For Oracle)
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 21: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 ...


Retrieved from "https://wiki.dbsqware.com/index.php?title=General:Installation&oldid=1776"