Forum Discussion

Jagadeesh16's avatar
Jagadeesh16
New Contributor
7 years ago

Unable to connect to my localhost DB (MySQL DATABASE) using SOAPUI

Hi Team, I am new to SoapUI and trying to connect my local database to execute some test cases. I keep on getting the below error message when I check my connection. I have added the driver .jar ...
  • Jagadeesh16's avatar
    Jagadeesh16
    7 years ago

    Hi ,

    After doing some investigation I happened to find the issue. It was related to my db, it was allowing to connect only via SSH and it was refusing all other connections from external clients. My network admin opened the port to accept all external connections and that resolved the issue.

     

    Thank you so much for your time.

TNeuschwanger's avatar
TNeuschwanger
Champion Level 1
7 years ago

hello jagadeesh16.  without a little more context for your error, it is a little hard to debug...  Have you ever connected to your target database?  Did you used to connect but now you are unable to?  What might be the jdbc connection string you used?  For localhost, ssl might not be issue but you might have to review connection parameters for the database you are connecting to and adjust accordingly.  

 

I seem to have encountered a similar error in the past, but it had to do with ssl.  I adjusted the connection paramerters for ssl and was able to connect.

 

example:

connectionStr=jdbc:mysql://xxxxxxxxxx:port/dbname?verifyServerCertificate=false&requireSSL=true&useSSL=true

  • Jagadeesh16's avatar
    Jagadeesh16
    New Contributor
    7 years ago

    Hi ,

    After doing some investigation I happened to find the issue. It was related to my db, it was allowing to connect only via SSH and it was refusing all other connections from external clients. My network admin opened the port to accept all external connections and that resolved the issue.

     

    Thank you so much for your time.