18 January 2026:
Sahi Pro is an enterprise grade test automation platform which can automate web, mobile, API, windows and java based applications and SAP.
This forum is now archived and is in read-only mode. Please continue discussions on our improved new Sahi Pro Community forum.
Sahi Pro is an enterprise grade test automation platform which can automate web, mobile, API, windows and java based applications and SAP.
DB Connection string for SSH
keats
Members
Can anyone please pass me the url to connect to Database thru ssh.
I was using the following string all this while,
var $db = _getDB("com.mysql.jdbc.Driver","jdbc:mysql://HOST:PORT/DBNAME","USER","PASSWORD");
Now the way the database is connected different and its on a private ip address.
The following command line works,
ssh -i ~/keypair1.pem ec2-user@HOST-t "mysql -uUSER -pPASWORD -DDATABASENAME--execute='SELECT * FROM tablename'"
But I do not know how to get a simple connection string for this.
Can someone let me know what is the solution.
I also tried to use _execute(ssh -i ~/keypair1.pem ec2-user@HOST-t "mysql -uUSER -pPASWORD -DDATABASENAME--execute='SELECT * FROM tablename'")
This returns "RUNNING" all the time.
Don't understand what is happening.
I was using the following string all this while,
var $db = _getDB("com.mysql.jdbc.Driver","jdbc:mysql://HOST:PORT/DBNAME","USER","PASSWORD");
Now the way the database is connected different and its on a private ip address.
The following command line works,
ssh -i ~/keypair1.pem ec2-user@HOST-t "mysql -uUSER -pPASWORD -DDATABASENAME--execute='SELECT * FROM tablename'"
But I do not know how to get a simple connection string for this.
Can someone let me know what is the solution.
I also tried to use _execute(ssh -i ~/keypair1.pem ec2-user@HOST-t "mysql -uUSER -pPASWORD -DDATABASENAME--execute='SELECT * FROM tablename'")
This returns "RUNNING" all the time.
Don't understand what is happening.