General:Commissioning vmsqwarebox

Work In Progress

Generalty

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 :

   2 vCPU
   4 Go de RAM
   2 Go de swap
 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) :

hostnamectl set-hostname "vmsqwarebox"

Changing the IP and setup the DNS :

#Check the addresses
ip addr

#Editing network cards (IP + DNS)
nmtui

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

vi /etc/hosts

Restart the network service :

#CentOS 7
systemctl restart network

Rocky Linux 8 et 9
systemctl restart NetworkManager

Check that everything is working properly before going any further :

#restart the VM
shutdown -r now

Then :

1. Modify the Postfix configuration to be compatible with your environment
2. Configure your DNS to resolve the vmsqwarebox alias or the name you gave the VM
3. 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

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

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

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

Managing unix account

passwd dbsqware
passwd oracle
passwd sybase
passwd mssql
passwd mysql
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) :

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

The conf file for the unix mysql user :

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

Customization

SQWareRepository

The MariaDB access account for reporting indicators :

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

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

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

SQWareWeb

Replace the following file with your logo:

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

Customize the databse access :

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

SQWareProduction

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

/home/dbsqware/dbSQWare/SQWareProduction/generic/etc_cust/sqwgen_GlobalVar.cfg
/home/dbsqware/dbSQWare/SQWareProduction/oracle/etc_cust/sqwora_GlobalVar.cfg
/home/dbsqware/dbSQWare/SQWareProduction/mssql/etc_cust/sqwmsq_GlobalVar.cfg
/home/dbsqware/dbSQWare/SQWareProduction/postgres/etc_cust/sqwpg_GlobalVar.cfg
/home/dbsqware/dbSQWare/SQWareProduction/mysql/etc_cust/sqwmys_GlobalVar.cfg
...

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

Accès aux bdd clientes

Configurer les flux FW si nécessaire (voir la section « dbSQWare Concepts » qui explique la matrice des flux):

vmsqwarebox => bdd clientes en 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)

Voici les prérequis pour les machines sur lesquelles on fera tourner SQWareProduction en local (Unix only) :

- vérifier que bash installé
- vérifier que rsync installé
	# il existe des packages pour la plupart des plateformes
	# vérifier qu'il est accéssible par le chemin /usr/bin/rsync (faire un lien symbolique si nécessaire)
- vérifier que sendmail/postfix est paramétré et démarré

Soit en résumé (sous RH ou CentOS):

yum install bash rsync

Soit en résumé (sous Debian ou Ubuntu):

apt install bash rsync