Difference between revisions of "General:Commissioning vmsqwarebox"
m |
Dtavernier (talk | contribs) (→Configuration) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 15: | Line 15: | ||
<br> | <br> | ||
VM Sizing : | VM Sizing : | ||
| − | < | + | <syntaxhighlight lang="sh" line> |
2 vCPU | 2 vCPU | ||
4 Go de RAM | 4 Go de RAM | ||
2 Go de swap | 2 Go de swap | ||
100 Go de disque | 100 Go de disque | ||
| − | </ | + | </syntaxhighlight> |
<br> | <br> | ||
The password of all unix and database accounts is set to the unique value of '''sqw''' (there is no GUI!).<br> | The password of all unix and database accounts is set to the unique value of '''sqw''' (there is no GUI!).<br> | ||
| Line 29: | Line 29: | ||
Changing the machine name (optional) : | Changing the machine name (optional) : | ||
| − | < | + | <syntaxhighlight lang="sh" line> |
hostnamectl set-hostname "vmsqwarebox" | hostnamectl set-hostname "vmsqwarebox" | ||
| − | </ | + | </syntaxhighlight> |
<br> | <br> | ||
Changing the IP and setup the DNS : | Changing the IP and setup the DNS : | ||
| − | < | + | <syntaxhighlight lang="sh" line> |
#Check the addresses | #Check the addresses | ||
ip addr | ip addr | ||
| Line 40: | Line 40: | ||
#Editing network cards (IP + DNS) | #Editing network cards (IP + DNS) | ||
nmtui | nmtui | ||
| − | </ | + | </syntaxhighlight> |
<br> | <br> | ||
Editing the hosts file (keep the vmsqwarebox entry with the correct IP so you don't have to change everything!) : | Editing the hosts file (keep the vmsqwarebox entry with the correct IP so you don't have to change everything!) : | ||
| − | < | + | <syntaxhighlight lang="sh" line> |
vi /etc/hosts | vi /etc/hosts | ||
| − | </ | + | </syntaxhighlight> |
<br> | <br> | ||
Restart the network service : | Restart the network service : | ||
| − | < | + | <syntaxhighlight lang="sh" line> |
#CentOS 7 | #CentOS 7 | ||
systemctl restart network | systemctl restart network | ||
| − | Rocky Linux 8 et 9 | + | #Rocky Linux 8 et 9 |
systemctl restart NetworkManager | systemctl restart NetworkManager | ||
| − | </ | + | </syntaxhighlight> |
<br> | <br> | ||
Check that everything is working properly before going any further : | Check that everything is working properly before going any further : | ||
| − | < | + | <syntaxhighlight lang="sh" line> |
#restart the VM | #restart the VM | ||
shutdown -r now | shutdown -r now | ||
| − | </ | + | </syntaxhighlight> |
<br> | <br> | ||
Then : | Then : | ||
| Line 73: | Line 73: | ||
====Licence==== | ====Licence==== | ||
Delete old files to generate the new key | Delete old files to generate the new key | ||
| − | < | + | <syntaxhighlight lang="sh" line> |
Cleanup : | 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/*.valid | ||
| Line 84: | Line 84: | ||
$ ls -l /home/dbsqware/dbSQWare/SQWareCentral/etc_cust/*.lic | $ 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 | -rw-r--r-- 1 dbsqware dba 295 Dec 8 17:07 /home/dbsqware/dbSQWare/SQWareCentral/etc_cust/yc2eaada-qaba-abav-msqw-areboxqc5edj.lic | ||
| − | </ | + | </syntaxhighlight> |
=> Give the name of this key to support so that they can send you a valid key for your environment ! | => Give the name of this key to support so that they can send you a valid key for your environment ! | ||
<br> | <br> | ||
====Managing unix account==== | ====Managing unix account==== | ||
| − | < | + | <syntaxhighlight lang="sh" line> |
passwd dbsqware | passwd dbsqware | ||
passwd oracle | passwd oracle | ||
| Line 96: | Line 96: | ||
passwd mysql | passwd mysql | ||
passwd postgres | passwd postgres | ||
| − | </ | + | </syntaxhighlight> |
=> Secure the dbsqware account in particular because it is this account that will be able to connect to the others via ssh | => Secure the dbsqware account in particular because it is this account that will be able to connect to the others via ssh | ||
<br> | <br> | ||
| Line 102: | Line 102: | ||
====MariaDB==== | ====MariaDB==== | ||
The MariaDB access account (admin user, equivalent to root) : | The MariaDB access account (admin user, equivalent to root) : | ||
| − | < | + | <syntaxhighlight lang="sh" line> |
SET PASSWORD FOR 'mysql'@'localhost' = PASSWORD('newpass'); | SET PASSWORD FOR 'mysql'@'localhost' = PASSWORD('newpass'); | ||
SET PASSWORD FOR 'mysql'@'%' = PASSWORD('newpass'); | SET PASSWORD FOR 'mysql'@'%' = PASSWORD('newpass'); | ||
| − | </ | + | </syntaxhighlight> |
<br> | <br> | ||
The conf file for the unix mysql user : | The conf file for the unix mysql user : | ||
| − | < | + | <syntaxhighlight lang="sh" line> |
echo "[client] | echo "[client] | ||
password = newpass | password = newpass | ||
" > $HOME/.my.cnf | " > $HOME/.my.cnf | ||
| − | </ | + | </syntaxhighlight> |
<br> | <br> | ||
| Line 120: | Line 120: | ||
===SQWareRepository=== | ===SQWareRepository=== | ||
The MariaDB access account for reporting indicators : | The MariaDB access account for reporting indicators : | ||
| − | < | + | <syntaxhighlight lang="sh" line> |
SET PASSWORD FOR 'dbsqware_user'@'localhost' = PASSWORD('newpassWeb'); | SET PASSWORD FOR 'dbsqware_user'@'localhost' = PASSWORD('newpassWeb'); | ||
SET PASSWORD FOR 'dbsqware_user'@'%' = PASSWORD('newpassWeb'); | SET PASSWORD FOR 'dbsqware_user'@'%' = PASSWORD('newpassWeb'); | ||
| − | </ | + | </syntaxhighlight> |
<br> | <br> | ||
If you change the VM name and/or password, etc ... edit the following file : | If you change the VM name and/or password, etc ... edit the following file : | ||
| − | < | + | <syntaxhighlight lang="sh" line> |
/home/dbsqware/dbSQWare/SQWareCentral/etc_cust/.my_SQWareRepository.cnf | /home/dbsqware/dbSQWare/SQWareCentral/etc_cust/.my_SQWareRepository.cnf | ||
| − | </ | + | </syntaxhighlight> |
<br> | <br> | ||
===SQWareWeb=== | ===SQWareWeb=== | ||
Replace the following file with your logo: | Replace the following file with your logo: | ||
| − | < | + | <syntaxhighlight lang="sh" line> |
/home/dbsqware/dbSQWare/SQWareWeb/custom/images/client.png | /home/dbsqware/dbSQWare/SQWareWeb/custom/images/client.png | ||
| − | </ | + | </syntaxhighlight> |
<br> | <br> | ||
| − | Customize the databse access :< | + | Customize the databse access :<syntaxhighlight lang="sh" line> |
vi /home/dbsqware/dbSQWare/SQWareWeb/custom/sqwareweb.ini | vi /home/dbsqware/dbSQWare/SQWareWeb/custom/sqwareweb.ini | ||
[db] | [db] | ||
| Line 143: | Line 143: | ||
MysqlUser="dbsqware_user" | MysqlUser="dbsqware_user" | ||
MysqlPass="newpassWeb" | MysqlPass="newpassWeb" | ||
| − | </ | + | </syntaxhighlight> |
<br> | <br> | ||
===SQWareProduction=== | ===SQWareProduction=== | ||
Global customization your standard (mail, path, ...) : | Global customization your standard (mail, path, ...) : | ||
| − | < | + | <syntaxhighlight lang="sh" line> |
/home/dbsqware/dbSQWare/SQWareProduction/generic/etc_cust/sqwgen_GlobalVar.cfg | /home/dbsqware/dbSQWare/SQWareProduction/generic/etc_cust/sqwgen_GlobalVar.cfg | ||
/home/dbsqware/dbSQWare/SQWareProduction/oracle/etc_cust/sqwora_GlobalVar.cfg | /home/dbsqware/dbSQWare/SQWareProduction/oracle/etc_cust/sqwora_GlobalVar.cfg | ||
| Line 155: | Line 155: | ||
/home/dbsqware/dbSQWare/SQWareProduction/mysql/etc_cust/sqwmys_GlobalVar.cfg | /home/dbsqware/dbSQWare/SQWareProduction/mysql/etc_cust/sqwmys_GlobalVar.cfg | ||
... | ... | ||
| − | </ | + | </syntaxhighlight> |
===SQWareCentral=== | ===SQWareCentral=== | ||
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.]] | 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.]] | ||
| Line 165: | Line 165: | ||
Configure firewall if needed (see section [[General:Concepts|« dbSQWare Concepts »]] who presents the network flow matrix) : | Configure firewall if needed (see section [[General:Concepts|« dbSQWare Concepts »]] who presents the network flow matrix) : | ||
| − | < | + | <syntaxhighlight lang="sh" line> |
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 with client database accessed by SQL (classiquement: 1521 pour Oracle, 1433 pour MsSql, 3306 pour MySQL, ...), si besoin, obligatoire 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) | vmsqwarebox => hosts with client database accessed directly in unix (ssh, port 22 by default) to have 100% of the features (useless for mssql) | ||
| − | </ | + | </syntaxhighlight> |
<br> | <br> | ||
Here are the prerequisites for the machines on which SQWareProduction will be running locally (Unix only): | Here are the prerequisites for the machines on which SQWareProduction will be running locally (Unix only): | ||
| − | < | + | <syntaxhighlight lang="sh" line> |
- Ensure that bash is installed | - Ensure that bash is installed | ||
- Ensure that rsync is installed | - Ensure that rsync is installed | ||
| Line 177: | Line 177: | ||
# Ensure that it is accessible via the path /usr/bin/rsync (create a symbolic link if necessary) | # Ensure that it is accessible via the path /usr/bin/rsync (create a symbolic link if necessary) | ||
- Ensure that sendmail/postfix is configured and running | - Ensure that sendmail/postfix is configured and running | ||
| − | </ | + | </syntaxhighlight> |
<br> | <br> | ||
Briefly (for RH, RL or CentOS): | Briefly (for RH, RL or CentOS): | ||
| − | < | + | <syntaxhighlight lang="sh" line> |
yum install bash rsync | yum install bash rsync | ||
| − | </ | + | </syntaxhighlight> |
Briefly (Debian and Ubuntu): | Briefly (Debian and Ubuntu): | ||
| − | < | + | <syntaxhighlight lang="sh" line> |
apt install bash rsync | apt install bash rsync | ||
| − | </ | + | </syntaxhighlight> |
<br> | <br> | ||
Latest revision as of 10:38, 28 April 2025
Generalties
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
