General:PatchUpgrade: Difference between revisions
Jump to navigation
Jump to search
Created page with "==Limites de cette section== Cette section part du principe que vous avez une installation de dbSQWare à la norme décrite dans les sections Général:Concepts | « Concept..." |
|||
| (7 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== | ==Limitations of this section== | ||
This section assumes you have a dbSQWare installation that meets the standard described in sections [[General:Concepts | « Concepts »]] and [[General:BaseInstallation | « Base Installation »]].<br> | |||
In other words, you should only have touched the trees dedicated to customization (ie: directories of the form *_cust) because the standard tool trees will be overwritten.<br> | |||
If so, a patch or upgrade will be handled the same way and should take less than 10 minutes in most cases.<br> | |||
<br> | <br> | ||
{{Warning | | {{Warning | This procedure is only valid for dbSQWare versions greater than or equal to v3.0! Upgrading from v1.x or v2.x to v3.x requires a major architecture and repository change (we recommend contacting support).<br> | ||
Upgrading to v202x requires a few additional commands (a few minutes), please contact support.}} | |||
<br> | <br> | ||
== | ==Express patch/upgrade release (from v3.0.04)== | ||
=== | ===Steps=== | ||
Here's a quick description of the steps we'll take: | |||
* | *Retrieve the latest version (http://support.dbsqware.com 'dbSQWare support' website) | ||
*Patch | *Patch | ||
* | *Deploy the patched version of SQWareProduction | ||
<br> | <br> | ||
=== | ===Central point update (SQWareCentral)=== | ||
Install the archive in the home of the dbsqware user : | |||
<pre> | <pre> | ||
$ cd | $ cd | ||
| Line 101: | Line 102: | ||
<br> | <br> | ||
=== | ===Deploying the patched version of SQWareProduction=== | ||
Then deploy the SQWareProduction you are using : | |||
<pre> | <pre> | ||
depl_ora => | depl_ora => for Oracle | ||
depl_syb => | depl_syb => for Sybase ASE | ||
depl_rs => | depl_rs => for Sybase RS | ||
depl_mys => | depl_mys => for Mysql | ||
depl_msq => | depl_msq => for Mssql | ||
depl_db2 => | depl_db2 => for DB2 | ||
depl_pg => | depl_pg => for PostgreSQL | ||
depl_ter => | depl_ter => for Teradata | ||
depl_cas => | depl_cas => for Cassandra | ||
depl_ing => | depl_ing => for Ingres | ||
depl_ada => | depl_ada => for Adabas | ||
</pre> | </pre> | ||
<br> | <br> | ||
''' | '''There you go, it's over!''' | ||
<br> | <br> | ||
<br> | <br> | ||
| Line 123: | Line 124: | ||
<br> | <br> | ||
== | ==Detailled, step-by-step patch/upgrade procedure== | ||
=== | ===Steps=== | ||
Here's a quick description of the steps we'll take: | |||
* | *Get the latest version | ||
*Patch | *Patch the central point (SQWareCentral) | ||
*Patch | *Patch the repository (SQWareRepository) | ||
*Patch | *Patch the web (SQWareWeb) | ||
* | *Deploy the patched version of SQWareProduction | ||
<br> | <br> | ||
=== | ===Central point update (SQWareCentral)=== | ||
Install the archive in the home of the dbsqware user : | |||
<pre> | <pre> | ||
$ cd | $ cd | ||
| Line 157: | Line 158: | ||
<br> | <br> | ||
Reloading the environnement : | |||
<pre> | <pre> | ||
$ reload | $ reload | ||
| Line 218: | Line 219: | ||
<br> | <br> | ||
=== | ===Web update (SQWareWeb)=== | ||
Still from the central point with the dbsqware user, launch the patch script: | |||
<pre> | <pre> | ||
$ /home/dbsqware/dbSQWare/SQWareWeb/exploit/bin/PatchCustom.ksh | $ /home/dbsqware/dbSQWare/SQWareWeb/exploit/bin/PatchCustom.ksh | ||
| Line 225: | Line 226: | ||
<br> | <br> | ||
=== | ===Deploying the patched version of SQWareProduction=== | ||
Then deploy the SQWareProduction packages you are using : | |||
<pre> | <pre> | ||
depl_ora => | depl_ora => for Oracle | ||
depl_syb => | depl_syb => for Sybase ASE | ||
depl_rs => | depl_rs => for Sybase RS | ||
depl_mys => | depl_mys => for Mysql | ||
depl_msq => | depl_msq => for Mssql | ||
depl_db2 => | depl_db2 => for DB2 | ||
depl_pg => | depl_pg => for PostgreSQL | ||
depl_ter => | depl_ter => for Teradata | ||
depl_cas => | depl_cas => for Cassandra | ||
depl_ing => | depl_ing => for Ingres | ||
depl_ada => | depl_ada => for Adabas | ||
</pre> | </pre> | ||
<br> | <br> | ||
Latest revision as of 11:01, 9 April 2025
Limitations of this section
This section assumes you have a dbSQWare installation that meets the standard described in sections « Concepts » and « Base Installation ».
In other words, you should only have touched the trees dedicated to customization (ie: directories of the form *_cust) because the standard tool trees will be overwritten.
If so, a patch or upgrade will be handled the same way and should take less than 10 minutes in most cases.
Express patch/upgrade release (from v3.0.04)
Steps
Here's a quick description of the steps we'll take:
- Retrieve the latest version (http://support.dbsqware.com 'dbSQWare support' website)
- Patch
- Deploy the patched version of SQWareProduction
Central point update (SQWareCentral)
Install the archive in the home of the dbsqware user :
$ cd $ tar zxvf dbSQWare_full_latest.tgz dbSQWare/ dbSQWare/SQWareProduction/ dbSQWare/SQWareProduction/ingres/ dbSQWare/SQWareProduction/ingres/tools/ ... dbSQWare/SQWareProduction/oracle/ dbSQWare/SQWareProduction/oracle/tools/ dbSQWare/SQWareProduction/oracle/tools/sqwora_RmanConfigure.ksh ... dbSQWare/SQWareCentral/ dbSQWare/SQWareCentral/lib/ dbSQWare/SQWareCentral/lib/sqwctl_MenuAction.lib ... dbSQWare/SQWareWeb/custom_ref/ dbSQWare/SQWareWeb/custom_ref/ingres/ ...
Patch global :
$ dbspatch ################################################################### # SQWareCentral module of dbSQWare # Copyright (C) 2010-2021, dbSQWare (www.dbsqware.com) # dbSQWare is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # CGU/CGA for more details. # You should have received a copy of the CGU/CGA # along with this program. If not, see <http://www.dbsqware.com/licenses/>. # For information : contact@dbsqware.com or www.dbsqware.com ################################################################### # SqwVersion=2020.08 # For help type 'show <-h|-help|--help>' Sourcing sqwctl_Global.lib v2020.08 SQWareCentral (dbSQWare) ... eval global vars: gvsqw_MySqlCnfFile="$gvsqw_GenPath/../../generic/etc_cust/.my_SQWareRepository.cnf" => gvsqw_MySqlCnfFile=/home/dbsqware/dbSQWare/SQWareCentral/menu/../../generic/etc_cust/.my_SQWareRepository.cnf Checks before install: SQWareRepository source to install: /home/dbsqware/dbSQWare/SQWareRepository Connect string to repository: MySQL_Command="mysql -N -s --defaults-file='/home/dbsqware/dbSQWare/SQWareCentral/menu/../../generic/etc_cust/.my_SQWareRepository.cnf'" [client] host = CentralHost port = 3306 database = dbsqware_db user = dbsqware_user 5.6.22 Major version of Repository, 56, 5.6.22 Checks for install mode (full or patch): 215 SQL found to be successfull installed. You will make a patch install. Do you want to patch SQWareRepository [y-Y-o-O-n-N]? y Query OK, 1 row affected Bye CheckNb: OK lic=150 real=118 CheckDate: OK lic=2021-12-31 real=2021-08-18 expire_days=135 Summary of returns: END_TRT Code: 0 --> SQWareRepository source to install: /home/dbsqware/dbSQWare/SQWareRepository ! patch SQWareRepository END_TRT Code: 0 --> $gvsqw_SQWareRepositoryPath/teradata/sql/patch_v2020.01/061_tsqw_VolThresholdDef_insert.sql executed successfully. Treatment Install SQWareRepository proceeded successfully Begining : 18/08/2021 16:45:38 End : 18/08/2021 16:45:56
Deploying the patched version of SQWareProduction
Then deploy the SQWareProduction you are using :
depl_ora => for Oracle depl_syb => for Sybase ASE depl_rs => for Sybase RS depl_mys => for Mysql depl_msq => for Mssql depl_db2 => for DB2 depl_pg => for PostgreSQL depl_ter => for Teradata depl_cas => for Cassandra depl_ing => for Ingres depl_ada => for Adabas
There you go, it's over!
Detailled, step-by-step patch/upgrade procedure
Steps
Here's a quick description of the steps we'll take:
- Get the latest version
- Patch the central point (SQWareCentral)
- Patch the repository (SQWareRepository)
- Patch the web (SQWareWeb)
- Deploy the patched version of SQWareProduction
Central point update (SQWareCentral)
Install the archive in the home of the dbsqware user :
$ cd $ tar zxvf dbSQWare_full_latest.tgz dbSQWare/ dbSQWare/SQWareProduction/ dbSQWare/SQWareProduction/ingres/ dbSQWare/SQWareProduction/ingres/tools/ ... dbSQWare/SQWareProduction/oracle/ dbSQWare/SQWareProduction/oracle/tools/ dbSQWare/SQWareProduction/oracle/tools/sqwora_RmanConfigure.ksh ... dbSQWare/SQWareCentral/ dbSQWare/SQWareCentral/lib/ dbSQWare/SQWareCentral/lib/sqwctl_MenuAction.lib ... dbSQWare/SQWareWeb/custom_ref/ dbSQWare/SQWareWeb/custom_ref/ingres/ ...
Reloading the environnement :
$ reload ################################################################### # SQWareCentral module of dbSQWare # Copyright (C) 2010-2021, dbSQWare (www.dbsqware.com) # dbSQWare is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # CGU/CGA for more details. # You should have received a copy of the CGU/CGA # along with this program. If not, see <http://www.dbsqware.com/licenses/>. # For information : contact@dbsqware.com or www.dbsqware.com ################################################################### # SqwVersion=2020.08 # For help type 'show <-h|-help|--help>' Sourcing sqwctl_Global.lib v2020.08 SQWareCentral (dbSQWare) ... eval global vars: gvsqw_MySqlCnfFile="$gvsqw_GenPath/../../generic/etc_cust/.my_SQWareRepository.cnf" => gvsqw_MySqlCnfFile=/home/dbsqware/dbSQWare/SQWareCentral/menu/../../generic/etc_cust/.my_SQWareRepository.cnf Checks before install: SQWareRepository source to install: /home/dbsqware/dbSQWare/SQWareRepository Connect string to repository: MySQL_Command="mysql -N -s --defaults-file='/home/dbsqware/dbSQWare/SQWareCentral/menu/../../generic/etc_cust/.my_SQWareRepository.cnf'" [client] host = CentralHost port = 3306 database = dbsqware_db user = dbsqware_user 5.6.22 Major version of Repository, 56, 5.6.22 Checks for install mode (full or patch): 215 SQL found to be successfull installed. You will make a patch install. Do you want to patch SQWareRepository [y-Y-o-O-n-N]? y Query OK, 1 row affected Bye CheckNb: OK lic=150 real=118 CheckDate: OK lic=2021-12-31 real=2021-08-18 expire_days=135 Summary of returns: END_TRT Code: 0 --> SQWareRepository source to install: /home/dbsqware/dbSQWare/SQWareRepository ! patch SQWareRepository END_TRT Code: 0 --> $gvsqw_SQWareRepositoryPath/teradata/sql/patch_v2020.01/061_tsqw_VolThresholdDef_insert.sql executed successfully. Treatment Install SQWareRepository proceeded successfully Begining : 18/08/2021 16:45:38 End : 18/08/2021 16:45:56
Web update (SQWareWeb)
Still from the central point with the dbsqware user, launch the patch script:
$ /home/dbsqware/dbSQWare/SQWareWeb/exploit/bin/PatchCustom.ksh
Deploying the patched version of SQWareProduction
Then deploy the SQWareProduction packages you are using :
depl_ora => for Oracle depl_syb => for Sybase ASE depl_rs => for Sybase RS depl_mys => for Mysql depl_msq => for Mssql depl_db2 => for DB2 depl_pg => for PostgreSQL depl_ter => for Teradata depl_cas => for Cassandra depl_ing => for Ingres depl_ada => for Adabas