- 1 minute to read
- Print
- DarkLight
- PDF
How to modify Database Proxy port number
- 1 minute to read
- Print
- DarkLight
- PDF
On the Database Proxy installation, this configuration is automatic with a default port number. Perform these steps only if the port number that you use isn’t the default number.
This article will guide you through a step-by-step process on how to set up a database to use it as a Database Proxy. This configuration is only necessary when the port number that you use in your database isn’t the default number.
Requirements
- Be an admin user
- Start an SSH admin session into the vault. Access the How to access a SSH admin session into the senhasegura platform document to know how to perform this action.
Set up the database
The command line must be typed inside an SSH admin session into the vault, using an application of your preference.
- With the SSH admin session initialized.Caution
The values
bind-port
andlisten_port
, must be filled in with the port number used in your database.
MS SQL Server database
- At the session home screen, open the file proxy-db-mssql.conf, type:
vim/etc/senhasegura/proxy-db-mssql.conf
- Change the
bind-port
value according to the used port number. - Press ESC.
- Type
:wq
. - Press Enter.
- At the home screen type:
systemctl restart proxy-db-mssql
- Close the SSH admin session.
PostgreSQL database
- At the session home screen, open the file pgbouncer.ini, type:
vim/etc/senhasegura/pgbouncer.ini
- Change the
listen_port
value according to the used port number. - Press ESC.
- Type
:wq
. - Press Enter.
- At the home screen type:
systemctl restart proxy-db-postgresql
- Close the SSH admin session.
Oracle database
- At the session home screen, open the file proxy-db-oracle.conf, type:
vim/etc/senhasegura/proxy-db-oracle.conf
- Change the
bind-port
value according to the used port number. - Press ESC.
- Type
:wq
. - Press Enter.
- At the home screen type:
systemctl restart proxy-db-oracle
- Close the SSH admin session.
After all these steps, the database setup is finished.
Next:
How to configure the Database Proxy access device
Database Proxy
Do you still have questions? Reach out to the senhasegura Community.