Difference between revisions of "General:Installation"
Expdbtools (talk | contribs) (→SQWareRepository for Sybase) |
Expdbtools (talk | contribs) (→SQWareRepository for Oracle) |
||
Line 35: | Line 35: | ||
Complete 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 (oracle_sid, virt_host_name, host_name, username, port, comments, contact, status, client, upd_date, env) | |
− | + | values ( 'ORADB', 'VirtHost', 'Host', 'oracle', 1521, 'App 1', 'MyContact', 'ON', 'CLI1', trunc(sysdate), 'PRD'); | |
− | |||
− | |||
<br> | <br> | ||
Revision as of 10:50, 25 May 2011
Contents
- 1 Install sources of all modules on focal point
- 2 Modules configuration
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.
#Download dbSQWare™ archive from Download the latest stable versions #Move tgz of lastest full version cp ~/downloads/dbSQWare_full_*.tgz $HOME/.
Extract archive of all modules
#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:
$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
Minimum version of Oracle for SQWareRepository is 10gR2.
Install Oracle schema with script ~/dbSQWare/SQWareRepository/oracle/v*/sql/sqwora_CreateIndicatorsTbsUsers.sql
Install tables with script ~/dbSQWare/SQWareRepository/oracle/v*/sql/sqwora_CreateIndicatorsObjectsFull.sql
Complete table tsqw_Repository with your CMDB.
Sample of insert query:
insert into tsqw_Repository (oracle_sid, virt_host_name, host_name, username, port, comments, contact, status, client, upd_date, env) values ( 'ORADB', 'VirtHost', 'Host', 'oracle', 1521, 'App 1', 'MyContact', 'ON', 'CLI1', trunc(sysdate), 'PRD');
SQWareRepository for Sybase
Minimum version of Sybase for SQWareRepository is ASE15.
Create a Sybase database to store CMDB and indicators.
Install tables with script ~/dbSQWare/SQWareRepository/sybase/v*/sql/sqwsyb_CreateIndicatorsObjectsFull.sql
Complete table tsqw_Repository with your CMDB.
Sample of insert query:
insert into tsqw_Repository ( DataServer, Virt_Hostname, Hostname, Username, Port, Comments, Contact, Status, Client, Upd_date, Env ) values ( 'DBSYB1', 'srvlsyb_virt', 'srvlsyb', 'sybase', 5018, 'Example', 'mycontact', 'ON', 'CLIENT3', getdate(), 'TST' ) go
SQWareRepository for MsSql
Minimum version of MsSql for SQWareRepository is 2005.
Create a MsSql database to store CMDB and indicators.
Install tables with script ~/dbSQWare/SQWareRepository/mssql/v*/sql/sqwmsq_CreateIndicatorsObjectsFull.sql
Complete table tsqw_Repository with your CMDB.
Sample of insert query:
insert into tsqw_Repository ...
SQWareRepository for MySql
Minimum version of MySql for SQWareRepository is 5.1 .
Create a MySql database to store CMDB and indicators.
Install tables with script ~/dbSQWare/SQWareRepository/mysql/v*/sql/sqwmys_CreateIndicatorsObjectsFull.sql
Complete table tsqw_Repository with your CMDB.
Sample of insert query:
insert into tsqw_Repository (mysql_sid, virt_host_name, host_name, username, port, comments, contact, status, client, upd_date, env) values ('MYS_DB', 'srvlmys', 'srvlmys', 'mysql', 3306, 'Example', 'mycontact', 'ON', 'CLIENT1', now(), 'TST');
SQWareRepository for Ingres
Minimum version of MySql for SQWareRepository is 5.1 .
Create a MySql database to store CMDB and indicators.
Install tables with script ~/dbSQWare/SQWareRepository/ingres/v*/sql/sqwing_CreateIndicatorsObjectsFull.sql
Complete table tsqw_Repository with your CMDB.
Sample of insert query:
insert into tsqw_Repository (mysql_sid, virt_host_name, host_name, username, port, comments, contact, status, client, upd_date, env) values ('ING_DB', 'srvling', 'srvling', 'ingres', 4000, 'Example', 'mycontact', 'ON', 'CLIENT2', now(), 'TST');
SQWareCentral
It's the focal point of dbSQWare.
You must install SQWareRepository before installing SQWareCentral.
You must install on an Unix/Linux platform only.
The unix user must have /bin/ksh as shell.
SQWareCentral core
Make a link to current version (change this link to upgrade version).
cd ~/dbSQWare/SQWareCentral ln -s v3.1 prod
Put variable gvsqw_RootexpdbCentral into your .profile and source of SQWareCentral environnement.
export gvsqw_RootexpdbCentral=$HOME/dbSQWare/SQWareCentral/prod . $gvsqw_RootexpdbCentral/etc/.profile
Customize variables for your own environnement:
To customize variables contain in $gvsqw_RootexpdbCentral/etc/sqwc_GlobalVar.cfg,
put them into $gvsqw_RootexpdbCentral/etc_cust/sqwc_GlobalVar.cfg.
In general case, you just have to customize gvsqw_Mail_central (email adress to send report).
For help on sqwc_GlobalVar.cfg
SQWareCentral for Oracle
Install an Oracle client and configure it to be able to connect to SQWareRepository for Oracle you have installed.
When connection to SQWareRepository is OK, customize connection variables:
To customize variables contain in $gvsqw_RootexpdbCentral/action/oracle/etc/sqwc_DbRefVar.cfg,
put them into $gvsqw_RootexpdbCentral/action/oracle/etc_cust/sqwc_DbRefVar.cfg.
The user can only have 'select' right on SQWareRepository.
For help on sqwc_DbRefVar.cfg for oracle
To check if connection to SQWareRepository is OK for SQWareCentral, reload environnement and test list generation:
#to reload environnement reload #to test list generation $gvsqw_RootexpdbCentral/action/oracle/lst/sqwc_ListeOracleInstance.ksh
The command should return the instances list that you configured in SQWareRepository for Oracle.
To customize variables contain in $gvsqw_RootexpdbCentral/action/oracle/etc/sqwc_GlobalVar.cfg,
put them into $gvsqw_RootexpdbCentral/action/oracle/etc_cust/sqwc_GlobalVar.cfg.
In general case, you just have to customize gvsqw_UserUniqueOracle if you want to change user who owns SQWareProduction for Oracle on all host.
For help on sqwc_GlobalVar.cfg for oracle
To customize variables contain in $gvsqw_RootexpdbCentral/action/oracle/etc/sqwc_ExpVar.cfg,
put them into $gvsqw_RootexpdbCentral/action/oracle/etc_cust/sqwc_ExpVar.cfg.
In general case, you just have to customize gvsqw_Mail_oracle (email adress to send report).
For help on sqwc_ExpVar.cfg for oracle
After that, you can put in place automatic treatment for Oracle.
You can take example on $gvsqw_RootexpdbCentral/action/oracle/etc/CrontabRef.cfg
Attention, you must first put in place SQWareProduction for Oracle before to collect indicators for example!
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_UserUniqueOracle on all Oracle hosts.
$gvsqw_RootexpdbCentral/action/oracle/lst/sqwc_ListeOracleUnique.ksh should return the host/user list.
To be able to perform centralized commands of SQWareProduction, you must set up the SSH public key of user which you have installed SQWareCentral into ~/.ssh/authorized_keys of users who owns Oracle instances.
$gvsqw_RootexpdbCentral/action/oracle/lst/sqwc_ListeOracleInstance.ksh should return the host/user/instance list.
SQWareCentral for Sybase
Install an Sybase client and configure it to be able to connect to SQWareRepository for Sybase you have installed.
When connection to SQWareRepository is OK, customize connection variables:
To customize variables contain in $gvsqw_RootexpdbCentral/action/sybase/etc/sqwc_DbRefVar.cfg,
put them into $gvsqw_RootexpdbCentral/action/sybase/etc_cust/sqwc_DbRefVar.cfg.
The user can only have 'select' right on SQWareRepository.
For help on sqwc_DbRefVar.cfg for sybase
To check if connection to SQWareRepository is OK for SQWareCentral, reload environnement and test list generation:
#to reload environnement reload #to test list generation $gvsqw_RootexpdbCentral/action/sybase/lst/sqwc_ListeSybaseDataserver.ksh
The command should return the instances list that you configured in SQWareRepository for Sybase.
To customize variables contain in $gvsqw_RootexpdbCentral/action/sybase/etc/sqwc_GlobalVar.cfg,
put them into $gvsqw_RootexpdbCentral/action/sybase/etc_cust/sqwc_GlobalVar.cfg.
In general case, you just have to customize gvsqw_UserUniqueSybase if you want to change user who owns SQWareProduction for Sybase on all host.
For help on sqwc_GlobalVar.cfg for sybase
To customize variables contain in $gvsqw_RootexpdbCentral/action/sybase/etc/sqwc_ExpVar.cfg,
put them into $gvsqw_RootexpdbCentral/action/sybase/etc_cust/sqwc_ExpVar.cfg.
In general case, you just have to customize gvsqw_Mail_sybase (email adress to send report).
For help on sqwc_ExpVar.cfg for sybase
After that, you can put in place automatic treatment for Sybase.
You can take example on $gvsqw_RootexpdbCentral/action/sybase/etc/CrontabRef.cfg
Attention, you must first put in place SQWareProduction for Sybase before to collect indicators for example!
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_UserUniqueSybase on all Sybase hosts.
$gvsqw_RootexpdbCentral/action/sybase/lst/sqwc_ListeSybaseUnique.ksh should return the host/user list.
To be able to perform centralized commands of SQWareProduction, you must set up the SSH public key of user which you have installed SQWareCentral into ~/.ssh/authorized_keys of users who owns Sybase instances.
$gvsqw_RootexpdbCentral/action/sybase/lst/sqwc_ListeSybaseDataserver.ksh should return the host/user/instance list.
SQWareCentral for Mssql
Install an Mssql client and configure it to be able to connect to SQWareRepository for Mssql you have installed.
When connection to SQWareRepository is OK, customize connection variables:
To customize variables contain in $gvsqw_RootexpdbCentral/action/mssql/etc/sqwc_DbRefVar.cfg,
put them into $gvsqw_RootexpdbCentral/action/mssql/etc_cust/sqwc_DbRefVar.cfg.
The user can only have 'select' right on SQWareRepository.
For help on sqwc_DbRefVar.cfg for mssql
To check if connection to SQWareRepository is OK for SQWareCentral, reload environnement and test list generation:
#to reload environnement reload #to test list generation $gvsqw_RootexpdbCentral/action/mssql/lst/sqwc_ListeMssqlInstance.ksh
The command should return the instances list that you configured in SQWareRepository for Mssql.
To customize variables contain in $gvsqw_RootexpdbCentral/action/mssql/etc/sqwc_GlobalVar.cfg,
put them into $gvsqw_RootexpdbCentral/action/mssql/etc_cust/sqwc_GlobalVar.cfg.
In general case, you just have to customize gvsqw_UserUniqueMssql if you want to change user who owns SQWareProduction for Mssql on all host.
For help on sqwc_GlobalVar.cfg for mssql
To customize variables contain in $gvsqw_RootexpdbCentral/action/mssql/etc/sqwc_ExpVar.cfg,
put them into $gvsqw_RootexpdbCentral/action/mssql/etc_cust/sqwc_ExpVar.cfg.
In general case, you just have to customize gvsqw_Mail_mssql (email adress to send report).
For help on sqwc_ExpVar.cfg for mssql
After that, you can put in place automatic treatment for Mssql.
You can take example on $gvsqw_RootexpdbCentral/action/mssql/etc/CrontabRef.cfg
Attention, you must first put in place SQWareProduction for Mssql before to collect indicators for example!
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_UserUniqueMssql on all Mssql hosts.
$gvsqw_RootexpdbCentral/action/mssql/lst/sqwc_ListeMssqlUnique.ksh should return the host/user list.
To be able to perform centralized commands of SQWareProduction, you must set up the SSH public key of user which you have installed SQWareCentral into ~/.ssh/authorized_keys of users who owns Mssql instances.
$gvsqw_RootexpdbCentral/action/mssql/lst/sqwc_ListeMssqlInstance.ksh should return the host/user/instance list.
SQWareCentral for Mysql
Install an Mysql client and configure it to be able to connect to SQWareRepository for Mysql you have installed.
When connection to SQWareRepository is OK, customize connection variables:
To customize variables contain in $gvsqw_RootexpdbCentral/action/mysql/etc/sqwc_DbRefVar.cfg,
put them into $gvsqw_RootexpdbCentral/action/mysql/etc_cust/sqwc_DbRefVar.cfg.
The user can only have 'select' right on SQWareRepository.
For help on sqwc_DbRefVar.cfg for mysql
To check if connection to SQWareRepository is OK for SQWareCentral, reload environnement and test list generation:
#to reload environnement reload #to test list generation $gvsqw_RootexpdbCentral/action/mysql/lst/sqwc_ListeMysqlInstance.ksh
The command should return the instances list that you configured in SQWareRepository for Mysql.
To customize variables contain in $gvsqw_RootexpdbCentral/action/mysql/etc/sqwc_GlobalVar.cfg,
put them into $gvsqw_RootexpdbCentral/action/mysql/etc_cust/sqwc_GlobalVar.cfg.
In general case, you just have to customize gvsqw_UserUniqueMysql if you want to change user who owns SQWareProduction for Mysql on all host.
For help on sqwc_GlobalVar.cfg for mysql
To customize variables contain in $gvsqw_RootexpdbCentral/action/mysql/etc/sqwc_ExpVar.cfg,
put them into $gvsqw_RootexpdbCentral/action/mysql/etc_cust/sqwc_ExpVar.cfg.
In general case, you just have to customize gvsqw_Mail_mysql (email adress to send report).
For help on sqwc_ExpVar.cfg for mysql
After that, you can put in place automatic treatment for Mysql.
You can take example on $gvsqw_RootexpdbCentral/action/mysql/etc/CrontabRef.cfg
Attention, you must first put in place SQWareProduction for Mysql before to collect indicators for example!
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_UserUniqueMysql on all Mysql hosts.
$gvsqw_RootexpdbCentral/action/mysql/lst/sqwc_ListeMysqlUnique.ksh should return the host/user list.
To be able to perform centralized commands of SQWareProduction, you must set up the SSH public key of user which you have installed SQWareCentral into ~/.ssh/authorized_keys of users who owns Mysql instances.
$gvsqw_RootexpdbCentral/action/mysql/lst/sqwc_ListeMysqlInstance.ksh should return the host/user/instance list.
SQWareCentral for Ingres
Install an MySql client and configure it to be able to connect to SQWareRepository for Ingres you have installed.
When connection to SQWareRepository is OK, customize connection variables:
To customize variables contain in $gvsqw_RootexpdbCentral/action/ingres/etc/sqwc_DbRefVar.cfg,
put them into $gvsqw_RootexpdbCentral/action/ingres/etc_cust/sqwc_DbRefVar.cfg.
The user can only have 'select' right on SQWareRepository.
For help on sqwc_DbRefVar.cfg for ingres
To check if connection to SQWareRepository is OK for SQWareCentral, reload environnement and test list generation:
#to reload environnement reload #to test list generation $gvsqw_RootexpdbCentral/action/ingres/lst/sqwc_ListeIngresInstance.ksh
The command should return the instances list that you configured in SQWareRepository for Ingres.
To customize variables contain in $gvsqw_RootexpdbCentral/action/ingres/etc/sqwc_GlobalVar.cfg,
put them into $gvsqw_RootexpdbCentral/action/ingres/etc_cust/sqwc_GlobalVar.cfg.
In general case, you just have to customize gvsqw_UserUniqueIngres if you want to change user who owns SQWareProduction for Ingres on all host.
For help on sqwc_GlobalVar.cfg for ingres
To customize variables contain in $gvsqw_RootexpdbCentral/action/ingres/etc/sqwc_ExpVar.cfg,
put them into $gvsqw_RootexpdbCentral/action/ingres/etc_cust/sqwc_ExpVar.cfg.
In general case, you just have to customize gvsqw_Mail_ingres (email adress to send report).
For help on sqwc_ExpVar.cfg for ingres
After that, you can put in place automatic treatment for Ingres.
You can take example on $gvsqw_RootexpdbCentral/action/ingres/etc/CrontabRef.cfg
Attention, you must first put in place SQWareProduction for Ingres before to collect indicators for example!
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_UserUniqueIngres on all Ingres hosts.
$gvsqw_RootexpdbCentral/action/ingres/lst/sqwc_ListeIngresUnique.ksh should return the host/user list.
To be able to perform centralized commands of SQWareProduction, you must set up the SSH public key of user which you have installed SQWareCentral into ~/.ssh/authorized_keys of users who owns Ingres instances.
$gvsqw_RootexpdbCentral/action/ingres/lst/sqwc_ListeIngresInstance.ksh should return the host/user/instance list.
SQWareProduction
You have to configure this module on the focal point and deploy it with SQWareCentral command on all your hosts.
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 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.
SQWareWeb
You must install SQWareRepository and SQWareProduction before installing SQWareWeb.
You must install on an Unix/Linux platform only.
SQWareWeb works with apache 2, PHP 5.2 and PEAR libraries, install these.
SQWareWeb core
Copy SQWareWeb from the focal point ~/dbSQWare/SQWareWeb in your web environnement ~/SQWareWeb.
Make a link to current version (change this link to upgrade version).
cd ~/SQWareWeb ln -s v1.2 prod
Configure your httpd.conf (change ~ by your directory):
<Directory "~/SQWareWeb/prod"> Options Indexes FollowSymLinks AllowOverride all Order allow,deny Allow from all </Directory> DocumentRoot ~/SQWareWeb/prod
Customize SQWareWeb menu and icon:
#Put the default configuration in place cp -rp ~/SQWareWeb/custom_ref/* ~/SQWareWeb/custom/. #Customize your icon in ~/SQWareWeb/custom/images/client.png #Customize your home page vi ~/SQWareWeb/custom/index.html #Customize menu to show/hide RDBMS (put ; on beginning of the line) vi ~/SQWareWeb/custom/menu.ini
SQWareWeb for Oracle
Install an Oracle client and relink or compile PHP to recognize it.
Configure connection string to SQWareRepository in :
- ~/SQWareWeb/custom/menu.ini
- ~/SQWareWeb/custom/oracle/common.ini
The user can only have 'select' right on SQWareRepository.
SQWareWeb for Sybase
Install an Sybase client and relink or compile PHP to recognize it.
Configure connection string to SQWareRepository in :
- ~/SQWareWeb/custom/menu.ini
- ~/SQWareWeb/custom/sybase/common.ini
The user can only have 'select' right on SQWareRepository.
SQWareWeb for Mssql
Install an Mssql client and relink or compile PHP to recognize it.
Configure connection string to SQWareRepository in :
- ~/SQWareWeb/custom/menu.ini
- ~/SQWareWeb/custom/mssql/common.ini
The user can only have 'select' right on SQWareRepository.
SQWareWeb for Mysql
Install an Mysql client and relink or compile PHP to recognize it.
Configure connection string to SQWareRepository in :
- ~/SQWareWeb/custom/menu.ini
- ~/SQWareWeb/custom/mysql/common.ini
The user can only have 'select' right on SQWareRepository.
SQWareWeb for Ingres
Install an MySql client and relink or compile PHP to recognize it.
Configure connection string to SQWareRepository in :
- ~/SQWareWeb/custom/menu.ini
- ~/SQWareWeb/custom/ingres/common.ini
The user can only have 'select' right on SQWareRepository.