Bahmni-Mart Setup with MySQLWorkbench & DBeaver
Prerequisites:
- Generate public key using
- For latest DBeaver, Run this on your key to convert it to RSA private key.
MYSQL:
Tools:
Connecting using MySQLWorkbench:
Change the connection method to Standard TCP/IP over SSH, by default, connection method will be set to Standard (TCP/IP)
Hostname: “<DomainName>”
Username: “centos”
SSH key file path: “provide the path to id_rsa file”
MySQL Hostname: “localhost”
MySQL Server Port: “3306”
Username: “root”
Once all the details are added, Test Connection and ideally you see the “Connection Successful” popup.
POSTGRESS:
Tools:
Connecting to POSTGRESS using DBeaver:
Select postgress DB while creating a new connection
Select SSH tab and check “Use SSH Tunnel” option
Host/IP: “<DomainName>”
Port: 22
User Name: “centos”
Authentication Method: “Public Key”
Private Key: “provide the path to id_rsa file”
Once all the details are added, Test Connection and ideally you see the “Connection Successful” popup.
원문 정보
원문 보기 ↗Bahmni Wiki · CC BY-SA 4.0