You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Ayodeji Enitan WAZIRI <aw...@softalliance.com> on 2022/07/06 15:59:19 UTC
Docker MySql Data load Error
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.
Re: Docker MySql Data load Error
Posted by Ayodeji Enitan WAZIRI <aw...@softalliance.com>.
Hi Daniel,
It worked.
The Ofbiz files and the database have to be in the same container for it to
loadAll.
Thanks and Regards
On Wed, Jul 6, 2022 at 6:14 PM Daniel Watford <da...@foomoo.co.uk> wrote:
> 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 <
> awaziri@softalliance.com>
> 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
>
--
***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.
Re: Docker MySql Data load Error
Posted by Daniel Watford <da...@foomoo.co.uk>.
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 <aw...@softalliance.com>
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