Difference between revisions of "General:Installation"

From Wiki_dbSQWare
Jump to: navigation, search
(→‎Modules configuration)
m (Ymauger moved page Installation to General:Installation)
 
(21 intermediate revisions by one other user not shown)
Line 1: Line 1:
 
== Install sources of all modules on focal point ==
 
== Install sources of all modules on focal point ==
 
=== Before install ===
 
=== Before install ===
 +
<br>
 +
[http://wikifr.dbsqware.com/index.php?title=DbSQWare:InstallationSocle Vervion française disponible ici.]<br>
 +
<br>
 
'''You must install on an Unix/Linux platform only (CentOS or RedHat are good).'''<br>
 
'''You must install on an Unix/Linux platform only (CentOS or RedHat are good).'''<br>
 
The unix user must have /bin/ksh as shell (no bash !).<br>
 
The unix user must have /bin/ksh as shell (no bash !).<br>
Line 10: Line 13:
 
  grant all privileges on dbsqware_db.* to 'dbsqware_user'@'%' identified by 'dbSQWareMysPwd' with grant option;
 
  grant all privileges on dbsqware_db.* to 'dbsqware_user'@'%' identified by 'dbSQWareMysPwd' with grant option;
 
  flush privileges;
 
  flush privileges;
−
Install apache (>=2.2) with PHP 5.3 (with support of mysqli).<br>
+
Install apache (>=2.2) with PHP 5.x (with support of mysqli).<br>
  
 
=== Prepare archive file of all modules ===
 
=== Prepare archive file of all modules ===
Line 29: Line 32:
 
  passwd dbsqware
 
  passwd dbsqware
  
−
Download dbSQWare™ archive from [[Downloads | Download the latest stable versions]]
+
Download latest dbSQWare archive from support site.
 
  #Move tgz of lastest full version
 
  #Move tgz of lastest full version
 
  su - dbsqware
 
  su - dbsqware
Line 59: Line 62:
 
==== Configure SQWareRepository credentials ====
 
==== Configure SQWareRepository credentials ====
 
Create custom configuration file:
 
Create custom configuration file:
−
  grep '^export gvsqw_' $HOME/dbSQWare/SQWareProduction/generic/etc/sqwgen_DbRefVar.cfg \
+
  grep -v '^#' $HOME/dbSQWare/SQWareProduction/generic/etc/.my_SQWareRepository.cnf \
−
  > $HOME/dbSQWare/SQWareProduction/generic/etc_cust/sqwgen_DbRefVar.cfg
+
  > $HOME/dbSQWare/SQWareProduction/generic/etc_cust/.my_SQWareRepository.cnf
 
Put custom parameters:
 
Put custom parameters:
−
  cat $HOME/dbSQWare/SQWareProduction/generic/etc_cust/sqwgen_DbRefVar.cfg
+
  cat $HOME/dbSQWare/SQWareProduction/generic/etc_cust/.my_SQWareRepository.cnf
−
  export gvsqw_DbRefPort='3306'
+
[client]
−
  export gvsqw_DbRefHost='SQWareRepositoryHost'
+
  host = SQWareRepositoryHost
−
  export gvsqw_DbRefDatabase='dbsqware_db'
+
  port = 3306
−
  export gvsqw_DbRefUser='dbsqware_user'
+
  database = dbsqware_db
−
  export gvsqw_DbRefPass='dbSQWareMysPwd'
+
  user = dbsqware_user
 +
  password = dbSQWareMysPwd
  
 
==== Install SQWareRepository ====
 
==== Install SQWareRepository ====
Line 76: Line 80:
 
It's the focal point of dbSQWare.<br>
 
It's the focal point of dbSQWare.<br>
 
You must install SQWareRepository before installing SQWareCentral.<br>
 
You must install SQWareRepository before installing SQWareCentral.<br>
−
'''You must install on an Unix/Linux platform only.'''<br>
+
==== SQWareCentral environnement ====
−
The unix user must have /bin/ksh as shell.<br>
+
Put variable gvsqw_SQWareCentralPath into your .profile and source of SQWareCentral environnement.<br>
−
<br>
+
$ cat /home/dbsqware/.profile
−
==== SQWareCentral '''core''' ====
+
  export gvsqw_Env='PRD'
−
Make a link to current version (change this link to upgrade version).<br>
+
export gvsqw_SQWareCentralPath=$HOME/dbSQWare/SQWareCentral
−
cd ~/dbSQWare/SQWareCentral
+
export gvsqw_SQWareProductionPath=$HOME/dbSQWare/SQWareProduction
−
ln -s v3.1 prod
+
  . $gvsqw_SQWareCentralPath/etc/.profile
−
Put variable gvsqw_RootexpdbCentral into your .profile and source of SQWareCentral environnement.<br>
+
Reload your .profile:
−
  export gvsqw_RootexpdbCentral=$HOME/dbSQWare/SQWareCentral/prod
+
. $HOME/.profile
−
  . $gvsqw_RootexpdbCentral/etc/.profile
+
Customize variables for your own environnement !<br>
−
Customize variables for your own environnement:<br>
+
To customize variables contain in $HOME/dbSQWare/SQWareProduction/generic/etc/sqwgen_GlobalVar.cfg,<br>
−
To customize variables contain in $gvsqw_RootexpdbCentral/etc/sqwc_GlobalVar.cfg,<br>
+
put them into $HOME/dbSQWare/SQWareProduction/generic/etc_cust/sqwgen_GlobalVar.cfg.<br>
−
put them into $gvsqw_RootexpdbCentral/etc_cust/sqwc_GlobalVar.cfg.<br>
+
In general case, you just have to customize '''gvsqw_GlobalMail''' (email adress to send report).<br>
−
In general case, you just have to customize gvsqw_Mail_central (email adress to send report).<br>
+
[[SQWareProduction:etc:sqwgen_GlobalVar.cfg | For help on sqwgen_GlobalVar.cfg]]<br>
−
[[SQWareCentral:etc:sqwc_GlobalVar.cfg | For help on sqwc_GlobalVar.cfg]]<br>
 
−
<br>
 
−
{{SQWareCentral_installation|Oracle|Oracle|oracle|Instance}}
 
−
{{SQWareCentral_installation|Sybase|Sybase|sybase|Dataserver}}
 
−
{{SQWareCentral_installation|Mssql|Mssql|mssql|Instance}}
 
−
{{SQWareCentral_installation|Mysql|Mysql|mysql|Instance}}
 
−
{{SQWareCentral_installation|Ingres|MySql|ingres|Instance}}
 
−
<br>
 
  
−
=== SQWareProduction ===
+
==== SQWareCentral automation ====
−
You have to configure this module on the focal point and deploy it with SQWareCentral command on all your hosts.
+
You can put in place some jobs in crontab to automate glogal tasks.
−
{{SQWareProduction_installation|Oracle|Oracle|oracle|Instance|ora|Ora|-I $ORACLE_SID}}
+
Take in example the file $SQWareCentralPath/etc/CrontabRef.cfg:
−
{{SQWareProduction_installation|Sybase|Sybase|sybase|Dataserver|syb|Syb|-S $DSQUERY}}
+
###########################
−
{{SQWareProduction_installation|Mssql|Mssql|mssql|Instance|msq|Msq|-S $AliasFreeTds}}
+
## mm(0-59) hh(0-23) dd(1-31) MM(0-12) DAY(0-sunday, 1-monday, ...) command
−
{{SQWareProduction_installation|Mysql|Mysql|mysql|Instance|mys|Mys|-I $MYSQL_SID}}
+
## Generic cron for SQWareCentral
−
{{SQWareProduction_installation|Ingres|MySql|ingres|Instance|ing|Ing|-I $INGRES_SID}}
+
############
−
<br>
+
# Generate all ref files (RefFileInstances,RefFileDb,RefFileCMDB,...)
 +
00 02,08    * * * ksh -c '. ~/.profile 2>&1 >/dev/null;$gvsqw_SQWareCentralPath/bin/sqwctl_GenRef_AllFiles.ksh 2>&1 >$HOME/admin/SQWareCentral/logs/sqwctl_GenRef_AllFiles.log'
 +
# Check indicators
 +
00 07      * * * ksh -c '. ~/.profile 2>&1 >/dev/null;$gvsqw_SQWareCentralPath/bin/sqwctl_CheckIndicators.ksh 2>&1 >$HOME/admin/SQWareCentral/logs/sqwctl_CheckIndicators.log'
 +
# Gather indicators
 +
00 03      * * * ksh -c '. ~/.profile 2>&1 >/dev/null;$gvsqw_SQWareCentralPath/bin/sqwctl_GatherIndicators.ksh 2>&1 >$HOME/admin/SQWareCentral/logs/sqwctl_GatherIndicators.log'
 +
# Retry gather indicators if not exists
 +
00 09,12,17 * * * ksh -c '. ~/.profile 2>&1 >/dev/null;$gvsqw_SQWareCentralPath/bin/sqwctl_GatherIndicators.ksh Repind 2>&1 >$HOME/admin/SQWareCentral/logs/sqwctl_GatherIndicators_Repind.log'
 +
# Check started instances Oracle
 +
00 06      * * * ksh -c '. ~/.profile 2>&1 >/dev/null;$gvsqw_SQWareCentralPath/bin/sqwctl_TrtAuto.ksh -T oracle -A sqwora_StartedInstancesOn.ksh -F GenLstUniqueOn -Exec 2>&1 >$HOME/admin/SQWareCentral/logs/StartedInstancesOracle.log'
  
 
=== SQWareWeb ===
 
=== SQWareWeb ===
−
You must install SQWareRepository and SQWareProduction before installing SQWareWeb.<br>
 
 
'''You must install on an Unix/Linux platform only.'''<br>
 
'''You must install on an Unix/Linux platform only.'''<br>
−
SQWareWeb works with apache 2, PHP 5.2 and PEAR libraries, install these.<br>
+
SQWareWeb works with apache >=2.2, PHP 5.x with mysqli support, install these.<br>
 
<br>
 
<br>
−
==== SQWareWeb '''core''' ====
+
==== SQWareWeb '''apache''' ====
−
Copy SQWareWeb from the focal point ~/dbSQWare/SQWareWeb in your web environnement ~/SQWareWeb.<br>
+
Configure your httpd.conf for "sqwareweb" by example:<br>
−
Make a link to current version (change this link to upgrade version).<br>
+
NameVirtualHost *:80
−
  cd ~/SQWareWeb
+
ServerAdmin admin@mydomain.com
−
  ln -s v1.2 prod
+
RewriteEngine  On
−
Configure your httpd.conf (change ~ by your directory):<br>
+
ErrorLog /home/dbsqware/apache/logs/error_log
−
  <Directory "~/SQWareWeb/prod">
+
  CustomLog /home/dbsqware/apache/logs/access_log common
 +
  RewriteLog /home/dbsqware/apache/logs/rewrite.log
 +
RewriteLogLevel 0
 +
  <Directory "/home/dbsqware/dbSQWare/SQWareWeb">
 
     Options Indexes FollowSymLinks
 
     Options Indexes FollowSymLinks
−
     AllowOverride all
+
     AllowOverride All
 
     Order allow,deny
 
     Order allow,deny
 
     Allow from all
 
     Allow from all
 
  </Directory>
 
  </Directory>
−
  DocumentRoot ~/SQWareWeb/prod
+
  <VirtualHost *:80>
−
Customize SQWareWeb menu and icon:<br>
+
    ServerAdmin admin@mydomain.com
−
  #Put the default configuration in place
+
    DocumentRoot /home/dbsqware/dbSQWare/SQWareWeb
−
  cp -rp ~/SQWareWeb/custom_ref/* ~/SQWareWeb/custom/.
+
    ServerName sqwareweb
−
   
+
    ServerAlias sqwareweb
−
  #Customize your icon in ~/SQWareWeb/custom/images/client.png
+
</VirtualHost>
 +
DocumentRoot /home/dbsqware/dbSQWare/SQWareWeb
 +
Don't forget parameters like:
 +
LoadModule php5_module        modules/libphp5.so
 +
User dbsqware
 +
Group dba
 +
AddType application/x-httpd-php .php
 +
Configure your php.ini (don't forget to restart apache after):<br>
 +
error_reporting = E_ALL & ~E_DEPRECATED
 +
[MySQLi]
 +
mysqli.max_persistent = -1
 +
mysqli.allow_persistent = On
 +
mysqli.max_links = -1
 +
mysqli.cache_size = 2000
 +
mysqli.default_port = 3306
 +
mysqli.reconnect = Off
 +
[Session]
 +
session.save_handler = files
 +
session.use_cookies = 1
 +
session.use_only_cookies = 1
 +
session.name = PHPSESSID
 +
session.auto_start = 0
 +
session.cookie_lifetime = 0
 +
session.cookie_path = /
 +
session.cookie_domain =
 +
session.cookie_httponly =
 +
session.serialize_handler = php
 +
session.gc_probability = 1
 +
session.gc_divisor = 1000
 +
session.gc_maxlifetime = 1440
 +
session.bug_compat_42 = Off
 +
session.bug_compat_warn = Off
 +
session.referer_check =
 +
session.entropy_length = 0
 +
session.cache_limiter = nocache
 +
session.cache_expire = 180
 +
session.use_trans_sid = 0
 +
session.hash_function = 0
 +
session.hash_bits_per_character = 5
 +
'''This is the minimal configuration, you can change many parameters in apache and php ...'''<br>
 +
<br>
 +
Now, you can test if apache/PHP are ready for you web site (put the good alias):
 +
http://sqwareweb/phpinfo.php
 +
 
 +
==== SQWareWeb '''customization''' ====
 +
Configure SQWareWeb by default:
 +
  #Put default files in place
 +
  $HOME/dbSQWare/SQWareWeb/exploit/bin/PatchCustom.ksh
 +
 
 +
Configure SQWareRepository access:
 +
vi ~/dbSQWare/SQWareWeb/custom/menu.ini
 +
[db]
 +
  MysqlHost="SQWareRepositoryHost"
 +
MysqlUser="dbsqware_user"
 +
MysqlPass="dbSQWareMysPwd"
 +
MysqlDb="dbsqware_db"
 +
MysqlPort=3306
 +
 
 +
Customize SQWareWeb:
 +
  #Customize your icon in ~/dbSQWare/SQWareWeb/custom/images/client.png
 
   
 
   
 
  #Customize your home page
 
  #Customize your home page
−
  vi ~/SQWareWeb/custom/index.html
+
  vi ~/dbSQWare/SQWareWeb/custom/index.html
 
   
 
   
−
  #Customize menu to show/hide RDBMS (put ; on beginning of the line)
+
  #Customize webdba title if you want
−
  vi ~/SQWareWeb/custom/menu.ini
+
vi ~/dbSQWare/SQWareWeb/custom/title.html
−
<br>
+
 
−
{{SQWareWeb_installation|Oracle|Oracle|oracle|Instance}}
+
Now, you can test you web site (put the good alias):
−
{{SQWareWeb_installation|Sybase|Sybase|sybase|Dataserver}}
+
  http://sqwareweb/
−
{{SQWareWeb_installation|Mssql|Mssql|mssql|Instance}}
+
 
−
{{SQWareWeb_installation|Mysql|Mysql|mysql|Instance}}
+
One admin user is created by SQWareRepository install to access SQWareWeb and admin console:
−
{{SQWareWeb_installation|Ingres|MySql|ingres|Instance}}
+
user : default_admin
 +
pass : OctopusDBA.001
 +
 
 +
Change this name and password (and create other users if necessary):
 +
http://sqwareweb/templates/adminAccessLogins_general.html
 +
 
 +
You can now populate your repository of instance to manage:
 +
http://sqwareweb/templates/adminRepoRepository_general.html
 +
 
 +
=== SQWareProduction ===
 +
You have to configure this module on the focal point and deploy it with SQWareCentral command on all your hosts.
 +
==== SQWareProduction generic ====
 +
You have to customize SQWareProduction generic (impact all RDBMS) on the focal point $HOME/dbSQWare/SQWareProduction/generic/*.<br>
 +
 
 +
===== Variables customization =====
 +
Customize if necessary variables contain in $HOME/dbSQWare/SQWareProduction/generic/etc/sqwgen_GlobalVar.cfg,<br>
 +
put them into $HOME/dbSQWare/SQWareProduction/generic/etc_cust/sqwgen_GlobalVar.cfg.<br>
 +
[[SQWareProduction:generic#sqwgen_GlobalVar.cfg | For help on sqwgen_GlobalVar.cfg]]<br>
 +
 
 +
{{SQWareProduction_installation|Oracle|Oracle|oracle|Instance|ora|Ora|-I $ORACLE_SID}}
 +
{{SQWareProduction_installation|Sybase|Sybase|sybase|Dataserver|syb|Syb|-S $DSQUERY}}
 +
{{SQWareProduction_installation|Mssql|Mssql|mssql|Instance|msq|Msq|-S $AliasFreeTds}}
 +
{{SQWareProduction_installation|Mysql|Mysql|mysql|Instance|mys|Mys|-I $MYSQL_SID}}
 +
{{SQWareProduction_installation|PostgreSQL|PostgreSQL|postgres|Instance|pg|Pg|-I $PG_SID}}
 +
{{SQWareProduction_installation|DB2|DB2|db2|Instance|db2|Db2|-I $DB2_SID}}
 +
{{SQWareProduction_installation|Ingres|MySql|ingres|Instance|ing|Ing|-I $INGRES_SID}}
 
<br>
 
<br>

Latest revision as of 12:26, 20 February 2024

Contents

Install sources of all modules on focal point

Before install


Vervion française disponible ici.

You must install on an Unix/Linux platform only (CentOS or RedHat are good).
The unix user must have /bin/ksh as shell (no bash !).
Install a MySQL instance (>=5.1), create a database and a user for the repository.
Provide between 500 Mb and 1 Gb for 100 managed instances ...
Exemple of commands: 

create database dbsqware_db;
grant all privileges on dbsqware_db.* to 'dbsqware_user'@'localhost' identified by 'dbSQWareMysPwd' with grant option;
grant all privileges on dbsqware_db.* to 'dbsqware_user'@'%' identified by 'dbSQWareMysPwd' with grant option;
flush privileges;

Install apache (>=2.2) with PHP 5.x (with support of mysqli).

Prepare archive file of all modules

You must install on an Unix/Linux platform only.
Create a unix user (dbsqware) in dba group with /bin/ksh as shell (no bash !).

su -
#Add unix group
groupadd dba
##To fix gid ...
groupadd -g 500 dba
#Add unix user
useradd -g dba -s /bin/ksh -d /home/dbsqware dbsqware
##To fix uid ...
useradd -u 501 -g dba -s /bin/ksh -d /home/dbsqware dbsqware
#Change owner
chown dbsqware:dba /home/dbsqware
#Add password to user
passwd dbsqware

Download latest dbSQWare archive from support site. 

#Move tgz of lastest full version
su - dbsqware
cp ~/downloads/dbSQWare_full_*.tgz $HOME/.

Extract archive of all modules

su - dbsqware
#gunzip and extract archive of all modules
cd $HOME
gunzip -c dbSQWare_full_*.tgz |tar -xvf -

#Delete archive file
rm -f $HOME/dbSQWare_full_*.tgz

You must have: 

$ ls -l
total 16
lrwxrwxrwx  1 dbsqware dba   24 20xx-04-05 18:12 generic -> SQWareProduction/generic
drwxr-x--- 13 dbsqware dba 4096 20xx-04-05 18:11 SQWareCentral
drwxr-x--- 10 dbsqware dba 4096 20xx-04-05 18:11 SQWareProduction
drwxr-x--- 11 dbsqware dba 4096 20xx-04-05 18:11 SQWareRepository
drwxr-x--- 10 dbsqware dba 4096 20xx-04-05 18:11 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.
Make all actions with dbsqware unix user.

Configure SQWareRepository credentials

Create custom configuration file: 

grep -v '^#' $HOME/dbSQWare/SQWareProduction/generic/etc/.my_SQWareRepository.cnf \
> $HOME/dbSQWare/SQWareProduction/generic/etc_cust/.my_SQWareRepository.cnf

Put custom parameters: 

cat $HOME/dbSQWare/SQWareProduction/generic/etc_cust/.my_SQWareRepository.cnf
[client]
host = SQWareRepositoryHost
port = 3306
database = dbsqware_db
user = dbsqware_user
password = dbSQWareMysPwd

Install SQWareRepository

Install MySQL schema for SQWareRepository: 

$HOME/dbSQWare/SQWareCentral/menu/sqwctl_InstallFullRepository.ksh

SQWareCentral

It's the focal point of dbSQWare.
You must install SQWareRepository before installing SQWareCentral.

SQWareCentral environnement

Put variable gvsqw_SQWareCentralPath into your .profile and source of SQWareCentral environnement.

$ cat /home/dbsqware/.profile
export gvsqw_Env='PRD'
export gvsqw_SQWareCentralPath=$HOME/dbSQWare/SQWareCentral
export gvsqw_SQWareProductionPath=$HOME/dbSQWare/SQWareProduction
. $gvsqw_SQWareCentralPath/etc/.profile

Reload your .profile: 

. $HOME/.profile

Customize variables for your own environnement !
To customize variables contain in $HOME/dbSQWare/SQWareProduction/generic/etc/sqwgen_GlobalVar.cfg,
put them into $HOME/dbSQWare/SQWareProduction/generic/etc_cust/sqwgen_GlobalVar.cfg.
In general case, you just have to customize gvsqw_GlobalMail (email adress to send report).
For help on sqwgen_GlobalVar.cfg

SQWareCentral automation

You can put in place some jobs in crontab to automate glogal tasks. Take in example the file $SQWareCentralPath/etc/CrontabRef.cfg: 

###########################
## mm(0-59) hh(0-23) dd(1-31) MM(0-12) DAY(0-sunday, 1-monday, ...) command
## Generic cron for SQWareCentral
############
# Generate all ref files (RefFileInstances,RefFileDb,RefFileCMDB,...)
00 02,08    * * * ksh -c '. ~/.profile 2>&1 >/dev/null;$gvsqw_SQWareCentralPath/bin/sqwctl_GenRef_AllFiles.ksh 2>&1 >$HOME/admin/SQWareCentral/logs/sqwctl_GenRef_AllFiles.log'
# Check indicators
00 07       * * * ksh -c '. ~/.profile 2>&1 >/dev/null;$gvsqw_SQWareCentralPath/bin/sqwctl_CheckIndicators.ksh 2>&1 >$HOME/admin/SQWareCentral/logs/sqwctl_CheckIndicators.log'
# Gather indicators
00 03       * * * ksh -c '. ~/.profile 2>&1 >/dev/null;$gvsqw_SQWareCentralPath/bin/sqwctl_GatherIndicators.ksh 2>&1 >$HOME/admin/SQWareCentral/logs/sqwctl_GatherIndicators.log'
# Retry gather indicators if not exists
00 09,12,17 * * * ksh -c '. ~/.profile 2>&1 >/dev/null;$gvsqw_SQWareCentralPath/bin/sqwctl_GatherIndicators.ksh Repind 2>&1 >$HOME/admin/SQWareCentral/logs/sqwctl_GatherIndicators_Repind.log'
# Check started instances Oracle
00 06       * * * ksh -c '. ~/.profile 2>&1 >/dev/null;$gvsqw_SQWareCentralPath/bin/sqwctl_TrtAuto.ksh -T oracle -A sqwora_StartedInstancesOn.ksh -F GenLstUniqueOn -Exec 2>&1 >$HOME/admin/SQWareCentral/logs/StartedInstancesOracle.log'

SQWareWeb

You must install on an Unix/Linux platform only.
SQWareWeb works with apache >=2.2, PHP 5.x with mysqli support, install these.

SQWareWeb apache

Configure your httpd.conf for "sqwareweb" by example:

NameVirtualHost *:80
ServerAdmin admin@mydomain.com
RewriteEngine   On
ErrorLog /home/dbsqware/apache/logs/error_log
CustomLog /home/dbsqware/apache/logs/access_log common
RewriteLog /home/dbsqware/apache/logs/rewrite.log
RewriteLogLevel 0
<Directory "/home/dbsqware/dbSQWare/SQWareWeb">
   Options Indexes FollowSymLinks
   AllowOverride All
   Order allow,deny
   Allow from all
</Directory>
<VirtualHost *:80>
   ServerAdmin admin@mydomain.com
   DocumentRoot /home/dbsqware/dbSQWare/SQWareWeb
   ServerName sqwareweb
   ServerAlias sqwareweb
</VirtualHost>
DocumentRoot /home/dbsqware/dbSQWare/SQWareWeb

Don't forget parameters like: 

LoadModule php5_module        modules/libphp5.so
User dbsqware
Group dba
AddType application/x-httpd-php .php

Configure your php.ini (don't forget to restart apache after):

error_reporting = E_ALL & ~E_DEPRECATED
[MySQLi]
mysqli.max_persistent = -1
mysqli.allow_persistent = On
mysqli.max_links = -1
mysqli.cache_size = 2000
mysqli.default_port = 3306
mysqli.reconnect = Off
[Session]
session.save_handler = files
session.use_cookies = 1
session.use_only_cookies = 1
session.name = PHPSESSID
session.auto_start = 0
session.cookie_lifetime = 0
session.cookie_path = /
session.cookie_domain =
session.cookie_httponly =
session.serialize_handler = php
session.gc_probability = 1
session.gc_divisor = 1000
session.gc_maxlifetime = 1440
session.bug_compat_42 = Off
session.bug_compat_warn = Off
session.referer_check =
session.entropy_length = 0
session.cache_limiter = nocache
session.cache_expire = 180
session.use_trans_sid = 0
session.hash_function = 0
session.hash_bits_per_character = 5

This is the minimal configuration, you can change many parameters in apache and php ...

Now, you can test if apache/PHP are ready for you web site (put the good alias): 

http://sqwareweb/phpinfo.php

SQWareWeb customization

Configure SQWareWeb by default: 

#Put default files in place
$HOME/dbSQWare/SQWareWeb/exploit/bin/PatchCustom.ksh

Configure SQWareRepository access: 

vi ~/dbSQWare/SQWareWeb/custom/menu.ini
[db]
MysqlHost="SQWareRepositoryHost"
MysqlUser="dbsqware_user"
MysqlPass="dbSQWareMysPwd"
MysqlDb="dbsqware_db"
MysqlPort=3306

Customize SQWareWeb: 

#Customize your icon in ~/dbSQWare/SQWareWeb/custom/images/client.png

#Customize your home page
vi ~/dbSQWare/SQWareWeb/custom/index.html

#Customize webdba title if you want
vi ~/dbSQWare/SQWareWeb/custom/title.html

Now, you can test you web site (put the good alias): 

http://sqwareweb/

One admin user is created by SQWareRepository install to access SQWareWeb and admin console: 

user : default_admin
pass : OctopusDBA.001

Change this name and password (and create other users if necessary): 

http://sqwareweb/templates/adminAccessLogins_general.html

You can now populate your repository of instance to manage: 

http://sqwareweb/templates/adminRepoRepository_general.html

SQWareProduction

You have to configure this module on the focal point and deploy it with SQWareCentral command on all your hosts.

SQWareProduction generic

You have to customize SQWareProduction generic (impact all RDBMS) on the focal point $HOME/dbSQWare/SQWareProduction/generic/*.

Variables customization

Customize if necessary variables contain in $HOME/dbSQWare/SQWareProduction/generic/etc/sqwgen_GlobalVar.cfg,
put them into $HOME/dbSQWare/SQWareProduction/generic/etc_cust/sqwgen_GlobalVar.cfg.
For help on sqwgen_GlobalVar.cfg

SQWareProduction for Oracle

You have to customize SQWareProduction for Oracle on the focal point $HOME/dbSQWare/SQWareProduction/oracle/*.

Variables customization

Customize if necessary variables contain in $HOME/dbSQWare/SQWareProduction/oracle/etc/sqwora_GlobalVar.cfg,
put them into $HOME/dbSQWare/SQWareProduction/oracle/etc_cust/sqwora_GlobalVar.cfg.
For help on sqwora_GlobalVar.cfg

Deployement

After that, you can deploy SQWareProduction for Oracle on all your hosts.
Attention, you must have install rsync on all your hosts.
SQWareProduction for Oracle will be deploy in ~$gvsqw_UserUnique/SQWareProduction/oracle 

#Use SQWareCentral
depl_ora

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_UserUnique on all Oracle hosts.

Users customization

You must install on an Unix/Linux platform only.
The unix user must have /bin/ksh as shell. User must also have access to a MySQL client (to load indicators).
Put these lines in .profile of user that own instance (change ~$gvsqw_UserUnique).

export gvsqw_OraBin=~$gvsqw_UserUnique/SQWareProduction/oracle/bin
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_OraBin/../etc/.profile_confort ]
then
   . $gvsqw_OraBin/../etc/.profile_confort
fi
Test your environnement

To test your new environnement:

#reload your profile
. ~/.profile
#to go in SQWareProduction scripts
bin
#to see your customizations
cetc

To check if connection to SQWareRepository is OK for SQWareProduction:

#to go in SQWareProduction scripts
bin
#gather indicators
./sqwora_GatherIndicators.ksh -I $ORACLE_SID

The command should gather indicator and insert it in SQWareRepository.

SQWareProduction for Sybase

You have to customize SQWareProduction for Sybase on the focal point $HOME/dbSQWare/SQWareProduction/sybase/*.

Variables customization

Customize if necessary variables contain in $HOME/dbSQWare/SQWareProduction/sybase/etc/sqwsyb_GlobalVar.cfg,
put them into $HOME/dbSQWare/SQWareProduction/sybase/etc_cust/sqwsyb_GlobalVar.cfg.
For help on sqwsyb_GlobalVar.cfg

Deployement

After that, you can deploy SQWareProduction for Sybase on all your hosts.
Attention, you must have install rsync on all your hosts.
SQWareProduction for Sybase will be deploy in ~$gvsqw_UserUnique/SQWareProduction/sybase 

#Use SQWareCentral
depl_syb

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_UserUnique on all Sybase hosts.

Users customization

You must install on an Unix/Linux platform only.
The unix user must have /bin/ksh as shell. User must also have access to a MySQL client (to load indicators).
Put these lines in .profile of user that own instance (change ~$gvsqw_UserUnique).

export gvsqw_SybBin=~$gvsqw_UserUnique/SQWareProduction/sybase/bin
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_SybBin/../etc/.profile_confort ]
then
   . $gvsqw_SybBin/../etc/.profile_confort
fi
Test your environnement

To test your new environnement:

#reload your profile
. ~/.profile
#to go in SQWareProduction scripts
bin
#to see your customizations
cetc

To check if connection to SQWareRepository is OK for SQWareProduction:

#to go in SQWareProduction scripts
bin
#gather indicators
./sqwsyb_GatherIndicators.ksh -S $DSQUERY

The command should gather indicator and insert it in SQWareRepository.

SQWareProduction for Mssql

You have to customize SQWareProduction for Mssql on the focal point $HOME/dbSQWare/SQWareProduction/mssql/*.

Variables customization

Customize if necessary variables contain in $HOME/dbSQWare/SQWareProduction/mssql/etc/sqwmsq_GlobalVar.cfg,
put them into $HOME/dbSQWare/SQWareProduction/mssql/etc_cust/sqwmsq_GlobalVar.cfg.
For help on sqwmsq_GlobalVar.cfg

Deployement

After that, you can deploy SQWareProduction for Mssql on all your hosts.
Attention, you must have install rsync on all your hosts.
SQWareProduction for Mssql will be deploy in ~$gvsqw_UserUnique/SQWareProduction/mssql 

#Use SQWareCentral
depl_msq

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_UserUnique on all Mssql hosts.

Users customization

You must install on an Unix/Linux platform only.
The unix user must have /bin/ksh as shell. User must also have access to a MySQL client (to load indicators).
Put these lines in .profile of user that own instance (change ~$gvsqw_UserUnique).

export gvsqw_MsqBin=~$gvsqw_UserUnique/SQWareProduction/mssql/bin
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_MsqBin/../etc/.profile_confort ]
then
   . $gvsqw_MsqBin/../etc/.profile_confort
fi
Test your environnement

To test your new environnement:

#reload your profile
. ~/.profile
#to go in SQWareProduction scripts
bin
#to see your customizations
cetc

To check if connection to SQWareRepository is OK for SQWareProduction:

#to go in SQWareProduction scripts
bin
#gather indicators
./sqwmsq_GatherIndicators.ksh -S $AliasFreeTds

The command should gather indicator and insert it in SQWareRepository.

SQWareProduction for Mysql

You have to customize SQWareProduction for Mysql on the focal point $HOME/dbSQWare/SQWareProduction/mysql/*.

Variables customization

Customize if necessary variables contain in $HOME/dbSQWare/SQWareProduction/mysql/etc/sqwmys_GlobalVar.cfg,
put them into $HOME/dbSQWare/SQWareProduction/mysql/etc_cust/sqwmys_GlobalVar.cfg.
For help on sqwmys_GlobalVar.cfg

Deployement

After that, you can deploy SQWareProduction for Mysql on all your hosts.
Attention, you must have install rsync on all your hosts.
SQWareProduction for Mysql will be deploy in ~$gvsqw_UserUnique/SQWareProduction/mysql 

#Use SQWareCentral
depl_mys

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_UserUnique on all Mysql hosts.

Users customization

You must install on an Unix/Linux platform only.
The unix user must have /bin/ksh as shell. User must also have access to a MySQL client (to load indicators).
Put these lines in .profile of user that own instance (change ~$gvsqw_UserUnique).

export gvsqw_MysBin=~$gvsqw_UserUnique/SQWareProduction/mysql/bin
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_MysBin/../etc/.profile_confort ]
then
   . $gvsqw_MysBin/../etc/.profile_confort
fi
Test your environnement

To test your new environnement:

#reload your profile
. ~/.profile
#to go in SQWareProduction scripts
bin
#to see your customizations
cetc

To check if connection to SQWareRepository is OK for SQWareProduction:

#to go in SQWareProduction scripts
bin
#gather indicators
./sqwmys_GatherIndicators.ksh -I $MYSQL_SID

The command should gather indicator and insert it in SQWareRepository.

SQWareProduction for PostgreSQL

You have to customize SQWareProduction for PostgreSQL on the focal point $HOME/dbSQWare/SQWareProduction/postgres/*.

Variables customization

Customize if necessary variables contain in $HOME/dbSQWare/SQWareProduction/postgres/etc/sqwpg_GlobalVar.cfg,
put them into $HOME/dbSQWare/SQWareProduction/postgres/etc_cust/sqwpg_GlobalVar.cfg.
For help on sqwpg_GlobalVar.cfg

Deployement

After that, you can deploy SQWareProduction for PostgreSQL on all your hosts.
Attention, you must have install rsync on all your hosts.
SQWareProduction for PostgreSQL will be deploy in ~$gvsqw_UserUnique/SQWareProduction/postgres 

#Use SQWareCentral
depl_pg

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_UserUnique on all PostgreSQL hosts.

Users customization

You must install on an Unix/Linux platform only.
The unix user must have /bin/ksh as shell. User must also have access to a MySQL client (to load indicators).
Put these lines in .profile of user that own instance (change ~$gvsqw_UserUnique).

export gvsqw_PgBin=~$gvsqw_UserUnique/SQWareProduction/postgres/bin
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_PgBin/../etc/.profile_confort ]
then
   . $gvsqw_PgBin/../etc/.profile_confort
fi
Test your environnement

To test your new environnement:

#reload your profile
. ~/.profile
#to go in SQWareProduction scripts
bin
#to see your customizations
cetc

To check if connection to SQWareRepository is OK for SQWareProduction:

#to go in SQWareProduction scripts
bin
#gather indicators
./sqwpg_GatherIndicators.ksh -I $PG_SID

The command should gather indicator and insert it in SQWareRepository.

SQWareProduction for DB2

You have to customize SQWareProduction for DB2 on the focal point $HOME/dbSQWare/SQWareProduction/db2/*.

Variables customization

Customize if necessary variables contain in $HOME/dbSQWare/SQWareProduction/db2/etc/sqwdb2_GlobalVar.cfg,
put them into $HOME/dbSQWare/SQWareProduction/db2/etc_cust/sqwdb2_GlobalVar.cfg.
For help on sqwdb2_GlobalVar.cfg

Deployement

After that, you can deploy SQWareProduction for DB2 on all your hosts.
Attention, you must have install rsync on all your hosts.
SQWareProduction for DB2 will be deploy in ~$gvsqw_UserUnique/SQWareProduction/db2 

#Use SQWareCentral
depl_db2

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_UserUnique on all DB2 hosts.

Users customization

You must install on an Unix/Linux platform only.
The unix user must have /bin/ksh as shell. User must also have access to a MySQL client (to load indicators).
Put these lines in .profile of user that own instance (change ~$gvsqw_UserUnique).

export gvsqw_Db2Bin=~$gvsqw_UserUnique/SQWareProduction/db2/bin
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_Db2Bin/../etc/.profile_confort ]
then
   . $gvsqw_Db2Bin/../etc/.profile_confort
fi
Test your environnement

To test your new environnement:

#reload your profile
. ~/.profile
#to go in SQWareProduction scripts
bin
#to see your customizations
cetc

To check if connection to SQWareRepository is OK for SQWareProduction:

#to go in SQWareProduction scripts
bin
#gather indicators
./sqwdb2_GatherIndicators.ksh -I $DB2_SID

The command should gather indicator and insert it in SQWareRepository.

SQWareProduction for Ingres

You have to customize SQWareProduction for Ingres on the focal point $HOME/dbSQWare/SQWareProduction/ingres/*.

Variables customization

Customize if necessary variables contain in $HOME/dbSQWare/SQWareProduction/ingres/etc/sqwing_GlobalVar.cfg,
put them into $HOME/dbSQWare/SQWareProduction/ingres/etc_cust/sqwing_GlobalVar.cfg.
For help on sqwing_GlobalVar.cfg

Deployement

After that, you can deploy SQWareProduction for Ingres on all your hosts.
Attention, you must have install rsync on all your hosts.
SQWareProduction for Ingres will be deploy in ~$gvsqw_UserUnique/SQWareProduction/ingres 

#Use SQWareCentral
depl_ing

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_UserUnique on all Ingres hosts.

Users customization

You must install on an Unix/Linux platform only.
The unix user must have /bin/ksh as shell. User must also have access to a MySQL client (to load indicators).
Put these lines in .profile of user that own instance (change ~$gvsqw_UserUnique).

export gvsqw_IngBin=~$gvsqw_UserUnique/SQWareProduction/ingres/bin
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_IngBin/../etc/.profile_confort ]
then
   . $gvsqw_IngBin/../etc/.profile_confort
fi
Test your environnement

To test your new environnement:

#reload your profile
. ~/.profile
#to go in SQWareProduction scripts
bin
#to see your customizations
cetc

To check if connection to SQWareRepository is OK for SQWareProduction:

#to go in SQWareProduction scripts
bin
#gather indicators
./sqwing_GatherIndicators.ksh -I $INGRES_SID

The command should gather indicator and insert it in SQWareRepository.

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