Difference between revisions of "General:Commissioning vmsqwarebox"

Latest revision as of 10:38, 28 April 2025

Generalties

Warning:
Before anything, don't go further if you don't have read the first section "dbSQWare Concepts " !.

Limitations of this section

This section shows you how to put into service the pre-configured dbSQWare VM delivered in the form of an ovf.
The vmsqwarebox aims to save you time on installing the central base.

Find the vmsqwarebox download link on the support site, ticket id=95.

VM Features

The vmsqwarebox is configured with IP 192.168.230.28 by default.
This is a Rocky Linux release 64 bits.

VM Sizing :

1    2 vCPU
2    4 Go de RAM
3    2 Go de swap
4  100 Go de disque

The password of all unix and database accounts is set to the unique value of sqw (there is no GUI!).

Configuration

System

Changing the machine name (optional) :

1 hostnamectl set-hostname "vmsqwarebox"

Changing the IP and setup the DNS :

1 #Check the addresses
2 ip addr
3 
4 #Editing network cards (IP + DNS)
5 nmtui

Editing the hosts file (keep the vmsqwarebox entry with the correct IP so you don't have to change everything!) :

1 vi /etc/hosts

Restart the network service :

1 #CentOS 7
2 systemctl restart network
3 
4 #Rocky Linux 8 et 9
5 systemctl restart NetworkManager

Check that everything is working properly before going any further :

1 #restart the VM
2 shutdown -r now

Then :

Modify the Postfix configuration to be compatible with your environment
Configure your DNS to resolve the vmsqwarebox alias or the name you gave the VM
Verify that the URL http://vmsqwarebox or https://vmsqwarebox (the name you gave the VM) works

The default console access user is admin and its password is sqw (don't forget to change it!).

Password + licence

Licence

Delete old files to generate the new key

 1 Cleanup :
 2 dbsqware@vmsqwarebox:/home/dbsqware $ rm -f /home/dbsqware/dbSQWare/SQWareCentral/etc_cust/*.valid
 3 dbsqware@vmsqwarebox:/home/dbsqware $ rm -f /home/dbsqware/dbSQWare/SQWareCentral/etc_cust/*.invalid
 4 dbsqware@vmsqwarebox:/home/dbsqware $ rm -f /home/dbsqware/dbSQWare/SQWareCentral/etc_cust/*.lic
 5 
 6 Generating the new key (after deleting old files) :
 7 $ dbspatch
 8 
 9 $ ls -l /home/dbsqware/dbSQWare/SQWareCentral/etc_cust/*.lic
10 -rw-r--r-- 1 dbsqware dba 295 Dec  8 17:07 /home/dbsqware/dbSQWare/SQWareCentral/etc_cust/yc2eaada-qaba-abav-msqw-areboxqc5edj.lic

=> Give the name of this key to support so that they can send you a valid key for your environment !

Managing unix account

1 passwd dbsqware
2 passwd oracle
3 passwd sybase
4 passwd mssql
5 passwd mysql
6 passwd postgres

=> Secure the dbsqware account in particular because it is this account that will be able to connect to the others via ssh

MariaDB

The MariaDB access account (admin user, equivalent to root) :

1 SET PASSWORD FOR 'mysql'@'localhost' = PASSWORD('newpass');
2 SET PASSWORD FOR 'mysql'@'%' = PASSWORD('newpass');

The conf file for the unix mysql user :

1 echo "[client]
2 password = newpass
3 " > $HOME/.my.cnf

Customization

SQWareRepository

The MariaDB access account for reporting indicators :

1 SET PASSWORD FOR 'dbsqware_user'@'localhost' = PASSWORD('newpassWeb');
2 SET PASSWORD FOR 'dbsqware_user'@'%' = PASSWORD('newpassWeb');

If you change the VM name and/or password, etc ... edit the following file :

1 /home/dbsqware/dbSQWare/SQWareCentral/etc_cust/.my_SQWareRepository.cnf

SQWareWeb

Replace the following file with your logo:

1 /home/dbsqware/dbSQWare/SQWareWeb/custom/images/client.png

Customize the databse access :

1 vi /home/dbsqware/dbSQWare/SQWareWeb/custom/sqwareweb.ini
2 [db]
3 MysqlHost="localhost"
4 MysqlUser="dbsqware_user"
5 MysqlPass="newpassWeb"

SQWareProduction

Global customization your standard (mail, path, ...) :

1 /home/dbsqware/dbSQWare/SQWareProduction/generic/etc_cust/sqwgen_GlobalVar.cfg
2 /home/dbsqware/dbSQWare/SQWareProduction/oracle/etc_cust/sqwora_GlobalVar.cfg
3 /home/dbsqware/dbSQWare/SQWareProduction/mssql/etc_cust/sqwmsq_GlobalVar.cfg
4 /home/dbsqware/dbSQWare/SQWareProduction/postgres/etc_cust/sqwpg_GlobalVar.cfg
5 /home/dbsqware/dbSQWare/SQWareProduction/mysql/etc_cust/sqwmys_GlobalVar.cfg
6 ...

SQWareCentral

Since version 2025.02 you have several prompts available that you can set up per user, choose a prompt for the dbsqware user.

Increased disk space

When you set up the vmsqwarebox, the machine is sized to the minimum, we advise you to increase the spaces.
FAQ : Increasing a FS on the vmsqwarebox VM

Access to client databases

Configure firewall if needed (see section « dbSQWare Concepts » who presents the network flow matrix) :

1 vmsqwarebox => hosts with client database accessed by SQL (classiquement: 1521 pour Oracle, 1433 pour MsSql, 3306 pour MySQL, ...), si besoin, obligatoire pour mssql
2 vmsqwarebox => hosts with client database accessed directly in unix (ssh, port 22 by default) to have 100% of the features (useless for mssql)

Here are the prerequisites for the machines on which SQWareProduction will be running locally (Unix only):

1 - Ensure that bash is installed
2 - Ensure that rsync is installed
3       # There are packages for most platforms
4       # Ensure that it is accessible via the path /usr/bin/rsync (create a symbolic link if necessary)
5 - Ensure that sendmail/postfix is configured and running

Briefly (for RH, RL or CentOS):

1 yum install bash rsync

Briefly (Debian and Ubuntu):

1 apt install bash rsync

@@ Line 1: / Line 1: @@
-Work In Progress
+==Generalties==
-==Generalty==
 <br>
-{{Warning | Avant toutes choses, n'allez pas plus loin si vous n'avez pas lu la section [[DbSQWare:Concepts|"Concepts dbSQWare"]] !}}
+{{Warning | Before anything, don't go further if you don't have read the first section [[General:Concepts|"dbSQWare Concepts "]] !}}
-===Limites de cette section===
+===Limitations of this section===
-Cette section vous présente comment mettre en service la VM dbSQWare pré-paramétrée et livrée sous forme d'un ovf.<br>
+This section shows you how to put into service the pre-configured dbSQWare VM delivered in the form of an ovf.<br>
-La vmsqwarebox a pour but de vous faire gagner du temps sur l'installation du socle central.<br>
+The vmsqwarebox aims to save you time on installing the central base.<br>
 <br>
-'''Retrouvez le lien de téléchargement de la vmsqwarebox sur le site du support, ticket id=95.'''<br>
+'''Find the vmsqwarebox download link on the support site, ticket id=95.'''<br>
 <br>
-===Caractéristiques de la VM===
+===VM Features===
-La vmsqwarebox est paramétrée avec l'IP 192.168.230.28 par défaut.<br>
+The vmsqwarebox is configured with IP 192.168.230.28 by default.<br>
-Il s'agit d'une Rocky Linux release 8.8 (Green Obsidian) 64 bits.<br>
+This is a Rocky Linux release 64 bits.<br>
 <br>
-Dimensionnement VM:
+VM Sizing :
-<pre>
+<syntaxhighlight lang="sh" line>
 vCPU
 Go de RAM
 Go de swap
 Go de disque
-</pre>
+</syntaxhighlight>
 <br>
-Le mdp de tous les comptes unix et bdd sont à la valeur unique de '''sqw''' (pas d'interface graphique !).<br>
+The password of all unix and database accounts is set to the unique value of '''sqw''' (there is no GUI!).<br>
 <br>
 ==Configuration==
-===Système===
+===System===
-Modification du nom de la machine (facultatif) :
+Changing the machine name (optional) :
-<pre>
+<syntaxhighlight lang="sh" line>
 hostnamectl set-hostname "vmsqwarebox"
-</pre>
+</syntaxhighlight>
 <br>
-Modification de l'IP + DNS :
+Changing the IP and setup the DNS :
-<pre>
+<syntaxhighlight lang="sh" line>
-#Voir les adresses
+#Check the addresses
 ip addr
-#Modif cartes réseau (IP + DNS)
+#Editing network cards (IP + DNS)
 nmtui
-</pre>
+</syntaxhighlight>
 <br>
-Modification du fichier hosts (conserver l'entree vmsqwarebox avec la bonne IP pour ne pas avoir à tout modifier !) :
+Editing the hosts file (keep the vmsqwarebox entry with the correct IP so you don't have to change everything!) :
-<pre>
+<syntaxhighlight lang="sh" line>
 vi /etc/hosts
-</pre>
+</syntaxhighlight>
 <br>
-Redémarrer le service réseau :
+Restart the network service :
-<pre>
+<syntaxhighlight lang="sh" line>
 #CentOS 7
 systemctl restart network
-Rocky Linux 8 et 9
+#Rocky Linux 8 et 9
 systemctl restart NetworkManager
-</pre>
+</syntaxhighlight>
 <br>
-Vérifier que tout fonctionne bien avant d'aller plus loin :
+Check that everything is working properly before going any further :
-<pre>
+<syntaxhighlight lang="sh" line>
-#redémarrage de la VM
+#restart the VM
 shutdown -r now
-</pre>
+</syntaxhighlight>
 <br>
-Puis:
+Then :
-# Modifier la conf postfix pour quelle soit compatible avec votre environnement
+# Modify the Postfix configuration to be compatible with your environment
-# configurer vos DNS pour résoudre l'alias vmsqwarebox ou le nom que vous aurez donné à la VM
+# Configure your DNS to resolve the vmsqwarebox alias or the name you gave the VM
-# vérifiez que l'URL http://vmsqwarebox ou https://vmsqwarebox (le nom que vous aurez donné à la VM) fonctionne
+# Verify that the URL http://vmsqwarebox or https://vmsqwarebox (the name you gave the VM) works
 <br>
-Le user par défaut d'accès à la console est '''admin''' et son mdp '''sqw''' (n'oubliez pas de le changer !).<br>
+The default console access user is '''admin''' and its password is '''sqw''' (don't forget to change it!).<br>
 <br>
-===Mots de passe + licence ===
+===Password + licence ===
 ====Licence====
-Effacer les anciens fichiers pour générer la nouvelle clé
+Delete old files to generate the new key
-<pre>
+<syntaxhighlight lang="sh" line>
-Ménage :
+Cleanup :
 dbsqware@vmsqwarebox:/home/dbsqware $ rm -f /home/dbsqware/dbSQWare/SQWareCentral/etc_cust/*.valid
 dbsqware@vmsqwarebox:/home/dbsqware $ rm -f /home/dbsqware/dbSQWare/SQWareCentral/etc_cust/*.invalid
 dbsqware@vmsqwarebox:/home/dbsqware $ rm -f /home/dbsqware/dbSQWare/SQWareCentral/etc_cust/*.lic
-Génération de la nouvelle clé :
+Generating the new key (after deleting old files) :
 $ dbspatch
 $ ls -l /home/dbsqware/dbSQWare/SQWareCentral/etc_cust/*.lic
 -rw-r--r-- 1 dbsqware dba 295 Dec  8 17:07 /home/dbsqware/dbSQWare/SQWareCentral/etc_cust/yc2eaada-qaba-abav-msqw-areboxqc5edj.lic
-</pre>
+</syntaxhighlight>
-=> Donnez le nom de cette clé au support pour qu'il vous transmette une clé valide pour votre environnement !
+=> Give the name of this key to support so that they can send you a valid key for your environment !
 <br>
-====Comptes unix====
-<pre>
+====Managing unix account====
+<syntaxhighlight lang="sh" line>
 passwd dbsqware
 passwd oracle
@@ Line 97: / Line 96: @@
 passwd mysql
 passwd postgres
-</pre>
+</syntaxhighlight>
-=> sécurisez en particulier le compte dbsqware car c'est lui qui va pouvoir se connecter sur les autres en ssh
+=> Secure the dbsqware account in particular because it is this account that will be able to connect to the others via ssh
 <br>
 ====MariaDB====
-Le compte d'accès MariaDB (user admin, équivalent à root) :
+The MariaDB access account (admin user, equivalent to root) :
-<pre>
+<syntaxhighlight lang="sh" line>
 SET PASSWORD FOR 'mysql'@'localhost' = PASSWORD('newpass');
 SET PASSWORD FOR 'mysql'@'%' = PASSWORD('newpass');
-</pre>
+</syntaxhighlight>
 <br>
-Le fichier de conf pour le user unix mysql :
-<pre>
+The conf file for the unix mysql user :
+<syntaxhighlight lang="sh" line>
 echo "[client]
 password = newpass
 " > $HOME/.my.cnf
-</pre>
+</syntaxhighlight>
 <br>
-==Personnalisation==
+==Customization==
 ===SQWareRepository===
-Le compte d'accès MariaDB pour remontée des indicateurs :
+The MariaDB access account for reporting indicators :
-<pre>
+<syntaxhighlight lang="sh" line>
 SET PASSWORD FOR 'dbsqware_user'@'localhost' = PASSWORD('newpassWeb');
 SET PASSWORD FOR 'dbsqware_user'@'%' = PASSWORD('newpassWeb');
-</pre>
+</syntaxhighlight>
 <br>
-Si vous changez le nom de la VM et/ou les passwd etc ..., modifiez le fichier suivant :
+If you change the VM name and/or password, etc ... edit the following file :
-<pre>
+<syntaxhighlight lang="sh" line>
 /home/dbsqware/dbSQWare/SQWareCentral/etc_cust/.my_SQWareRepository.cnf
-</pre>
+</syntaxhighlight>
 <br>
 ===SQWareWeb===
-Remplacez le fichier suivant par votre logo :
+Replace the following file with your logo:
-<pre>
+<syntaxhighlight lang="sh" line>
 /home/dbsqware/dbSQWare/SQWareWeb/custom/images/client.png
-</pre>
+</syntaxhighlight>
 <br>
-Personnaliser l'accès à la db :
+Customize the databse access :<syntaxhighlight lang="sh" line>
-<pre>
 vi /home/dbsqware/dbSQWare/SQWareWeb/custom/sqwareweb.ini
 [db]
-MysqlHost="vmsqwarebox"
+MysqlHost="localhost"
 MysqlUser="dbsqware_user"
 MysqlPass="newpassWeb"
-</pre>
+</syntaxhighlight>
 <br>
 ===SQWareProduction===
-Personnalisation globale a la norme du parc (mail, path, ...) :
+Global customization your standard (mail, path, ...) :
-<pre>
+<syntaxhighlight lang="sh" line>
 /home/dbsqware/dbSQWare/SQWareProduction/generic/etc_cust/sqwgen_GlobalVar.cfg
 /home/dbsqware/dbSQWare/SQWareProduction/oracle/etc_cust/sqwora_GlobalVar.cfg
@@ Line 156: / Line 155: @@
 /home/dbsqware/dbSQWare/SQWareProduction/mysql/etc_cust/sqwmys_GlobalVar.cfg
 ...
-</pre>
+</syntaxhighlight>
 ===SQWareCentral===
-Depuis la version 2025.02 vous avez à votre disposition plusieurs prompts que vous pouvez mettre en place par utilisateur.
+Since version 2025.02 you have several prompts available that you can set up per user, [[FAQ:PromptChoice|choose a prompt for the dbsqware user.]]
+===Increased disk space===
-=== ===
+When you set up the vmsqwarebox, the machine is sized to the minimum, we advise you to increase the spaces.<br>
+[[FAQ:Aug_FS_VM_vmsqwarebox | FAQ : Increasing a FS on the vmsqwarebox VM]]<br>
-===Augmentation de l'espace===
-Lorsque vous mettez en place la vmsqwarebox, la machine est taillée au minimum, nous vous conseillons d'augmenter les espaces.<br>
-[[Général:FAQ_Aug_FS_VM_CentOS7| FAQ : Augmentation d'un FS sur la VM CentOS 7]]<br>
-==Accès aux bdd clientes==
+==Access to client databases==
-Configurer les flux FW si nécessaire (voir la section [[Général:Concepts|« dbSQWare Concepts »]] qui explique la matrice des flux):
+Configure firewall if needed (see section [[General:Concepts|« dbSQWare Concepts »]] who presents the network flow matrix) :
-<pre>
+<syntaxhighlight lang="sh" line>
-vmsqwarebox => bdd clientes en SQL (classiquement: 1521 pour Oracle, 1433 pour MsSql, 3306 pour MySQL, ...), si besoin, obligatoire pour mssql
+vmsqwarebox => hosts with client database accessed by SQL (classiquement: 1521 pour Oracle, 1433 pour MsSql, 3306 pour MySQL, ...), si besoin, obligatoire pour mssql
-vmsqwarebox => hosts des bdd sous unix (ssh port 22) pour avoir 100% des fonctionnalités (inutile pour mssql)
+vmsqwarebox => hosts with client database accessed directly in unix (ssh, port 22 by default) to have 100% of the features (useless for mssql)
-</pre>
+</syntaxhighlight>
 <br>
-Voici les prérequis pour les machines sur lesquelles on fera tourner SQWareProduction en local (Unix only) :
+Here are the prerequisites for the machines on which SQWareProduction will be running locally (Unix only):
-<pre>
+<syntaxhighlight lang="sh" line>
-- vérifier que bash installé
+- Ensure that bash is installed
-- vérifier que rsync installé
+- Ensure that rsync is installed
-	# il existe des packages pour la plupart des plateformes
+      # There are packages for most platforms
-	# vérifier qu'il est accéssible par le chemin /usr/bin/rsync (faire un lien symbolique si nécessaire)
+      # Ensure that it is accessible via the path /usr/bin/rsync (create a symbolic link if necessary)
-- vérifier que sendmail/postfix est paramétré et démarré
+- Ensure that sendmail/postfix is configured and running
-</pre>
+</syntaxhighlight>
 <br>
-Soit en résumé (sous RH ou CentOS):
+Briefly (for RH, RL or CentOS):
-<pre>
+<syntaxhighlight lang="sh" line>
 yum install bash rsync
-</pre>
+</syntaxhighlight>
-Soit en résumé (sous Debian ou Ubuntu):
+Briefly  (Debian and Ubuntu):
-<pre>
+<syntaxhighlight lang="sh" line>
 apt install bash rsync
-</pre>
+</syntaxhighlight>
 <br>

Difference between revisions of "General:Commissioning vmsqwarebox"

Latest revision as of 10:38, 28 April 2025

Contents

Generalties

Limitations of this section

VM Features

Configuration

System

Password + licence

Licence

Managing unix account

MariaDB

Customization

SQWareRepository

SQWareWeb

SQWareProduction

SQWareCentral

Increased disk space

Access to client databases

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

dbSQWare

General

SQWareProduction

Appendices

Tools