Replies: 3 comments 4 replies
-
Was your MySql 5 also running on Docker? Also, if your containers are running on the same host, I would use Docker's DNS system instead of hardcoding the IP address in jdbc string. For Mirth logs do |
Beta Was this translation helpful? Give feedback.
-
Nothing in the logs looks out of place..... INFO 2021-11-23 21:13:39,635 [Main Server Thread] com.mirth.connect.server.Mirth: Mirth Connect 3.12.0 (Built on September 2, 2021) server successfully started. MySQL 5.7.31 was also running via Docker - and as that worked, I assume that the IP address is fine. If I purposefully change the username or password then I get an error saying that Mirth cant talk to MySQL...therefore when the username/password is correct, and I DONT get an error, I have to assume that I am connected - but the GetTables button doesnt respond with anything. Mat |
Beta Was this translation helpful? Give feedback.
-
I am confused. If I use MySQL 5.7 via Docker then I can read the tables from my MySQL databases using the GetTables button Mirth is setup with all the defaults. |
Beta Was this translation helpful? Give feedback.
-
Evening all,
I am having trouble getting Mirth Connect to talk to MySQL 8. I am trying to write to a database. Code is fine on MySQL 5.7.28
Running Mirth 3.12 in Docker.
Running MySQL 8.0.26 in Docker
Database Driver is com.mysql.cj.jdbc.Driver
URL is jdbc:mysql:https://192.168.0.12:3306/patient_hl7?allowPublicKeyRetrieval=true&sslMode=D ISABLED
I am usin the Get Tables trick to make sure I can access the database. This works fine on MySQL 5.7
However if I run a MySQL 8.0.26 docker image using the same connection string then I dont get an error connecting to it, but nothing is returned in the Get Tables view.
I know the "allowPublicKeyRetrieval" bit is needed as without it, I get an exception in Mirth Connect. We also use that on our SQL connection string from within our own product to talk to the database in C#. Basically, I know the URL is correct.
Works on MySQL 5.7 but nothing returned on MySQL 8.
Any ideas where I can start looking?
Are there log files in Mirth somewhere in the Docker image? (I am new to Mirth - taking over an existing system from another developer)
Thanks in advance
Mat
Beta Was this translation helpful? Give feedback.
All reactions