Hi Ayodeji, As a first step I would try to prove you can reach the MySQL server from the same location as where ofbiz is running.
Try running the mysql client and connect to your database. If you run in to problems at this stage then you may need to ensure ports are forwarded from your MySQL container to your docker host. It has been quite some time since I last did this, but this repository has experimental information for connecting to PostgreSQL from OFBiz: danwatford/docker-postgres-ofbiz (github.com) <https://github.com/danwatford/docker-postgres-ofbiz> On Wed, 6 Jul 2022 at 16:57, Ayodeji Enitan WAZIRI <[email protected]> wrote: > Hi community, > I am trying to connect Ofbiz to a Mysql docker instance and I keep getting > the following errors when I try to loadAll. > > - org.apache.ofbiz.entity.GenericDataSourceException: Unable to > establish a connection with the database. (Unable to acquire a new > connection from the pool) > - java.sql.SQLException: Unable to acquire a new connection from the > pool > - java.sql.SQLNonTransientConnectionException: Could not create > connection to database server. Attempted reconnect 3 times. Giving up. > - com.mysql.cj.exceptions.CJCommunicationsException: Communications link > failure > - javax.net.ssl.SSLHandshakeException: Remote host terminated the > handshake > - java.io.EOFException: SSL peer shut down incorrectly > > I followed all the steps listed at > > https://cwiki.apache.org/confluence/display/OFBIZ/How+to+migrate+OFBiz+from+Derby+to+MySQL+database > How can i solve this problem? > > Thanks and Regards > > -- > > > ***DISCLAIMER****: > - *The content of this email is confidential and > intended for > the recipient specified in the message only. It is strictly > forbidden to share > any part of this message with any third party, without > the written consent of > the sender. If you received this message in error, > please reply to this message > and follow with its deletion to ensure such a > mistake does not occur in the > future. > -- Daniel Watford
