Issue on loading data using JDBC data source

[Amitra Bhunia]

I have installed mid server and mySQL database in docker in 2 deferent container,

when I am tryin to connect the data base using data source from servicenow I am getting bellow error :

MID Server reported error: SQLState: null
java.sql.SQLException: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=127.0.0.1)(port=3306)(type=master) : Connection refused (Connection refused).

 below is my data source configuration:

I am able to connect the database and execute mySQL query from VS Code using below connection:

Please help me on establishing the connection if anyone have worked on this.

[Amitra Bhunia]

In my case both mid server and database both installed in my personal machine in docker.. In my organization project we used the ip of db server and that is working properly. Mid server is used in same db server so we did not find any firewall issue there. But I am facing the challenge in configuring the same in my personal machine using docker. 

[JensHappeningIT]

Hi @Amitra Bhunia ,

Was this ever solved? I got the same error but I do not use docker, I host mine via Wampserver. Can you let me know?

Many thanks in advance!

[Amitra Bhunia]

Hi,

It is not resolved yet. Have you installed mid server in WAMP?

Regards,

Amitra

[JensHappeningIT]

Hi,

No my mid server that I use to test is in VirtualBox. I use WAMP to host MySQL database

Kind regards,

Jens