my bad... 192.168.1.4 is incorrect but I corrected the address and the
result is the same though
On 3/27/07, Samuel Benz <[EMAIL PROTECTED]> wrote:
I tried it...
Here is a sample...
<inline-jdbc
jdbc-driver="org.postgresql.Driver"
ssl="true"
jdbc-uri="jdbc:postgresql://10.73.65.114/ofbiz-current"
jdbc-username="ofbiz"
jdbc-password="ofbiz"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="20"/>
I also tried it with jdbc-ssl="true"
The results were exactly the same.
On 3/27/07, Chris Howe < [EMAIL PROTECTED]> wrote:
>
> first make sure you have a user on your postgres server for
> [EMAIL PROTECTED] (or @ domain that resolves to 10.73.65.125)
>
> then in your ofbiz.home/framework/entity/config/entityengine.xml file
> for your localpostgres datasource in the inline-jdbc element add
> ssl="true"
>
> then report back :)
>
> --- Sam Benz <[EMAIL PROTECTED]> wrote:
>
> >
> > I have not found any errors from postgres but I have attached the log
> > file
> > from ofbiz framework/logs/ofbiz.log
> >
> >
> > here are a few relevant lines
> >
> >
> > 2007-03-26 19:00:08,280 (main) [ ConnectionFactory.java:85 :ERROR]
> > ---- runtime exception report
> > --------------------------------------------------
> > There was an error getting a Minerva datasource.
> > Exception: java.lang.RuntimeException
> > Message: Could not create connection
> > ---- stack trace
> > ---------------------------------------------------------------
> > java.lang.RuntimeException: Could not create connection
> >
> org.ofbiz.minerva.pool.ObjectPool.createNewObject (ObjectPool.java:944)
> > org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630)
> >
> org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(
> XAPoolDataSource.java:355)
> >
> org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection (
> MinervaConnectionFactory.java:46)
> >
> org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(
> ConnectionFactory.java:82)
> >
> org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(
> GeronimoTransactionFactory.java :100)
> >
> org.ofbiz.entity.transaction.TransactionFactory.getConnection(
> TransactionFactory.java:95)
> >
> org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(
> ConnectionFactory.java:72)
> >
> org.ofbiz.entity.jdbc.DatabaseUtil.getConnection (DatabaseUtil.java:98)
> >
> org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(DatabaseUtil.java:827)
> > org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:136)
> > org.ofbiz.entity.jdbc.DatabaseUtil.checkDb (DatabaseUtil.java:125)
> > org.ofbiz.entity.datasource.GenericDAO.checkDb(GenericDAO.java:1087)
> >
> org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(
> GenericHelperDAO.java:198)
> > org.ofbiz.entity.GenericDelegator .<init>(GenericDelegator.java:184)
> >
> org.ofbiz.entity.GenericDelegator.getGenericDelegator(
> GenericDelegator.java:116)
> > org.ofbiz.guiapp.xui.XuiContainer.start(XuiContainer.java:66)
> >
> org.ofbiz.base.container.ContainerLoader.start (ContainerLoader.java:80)
> > org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
> > org.ofbiz.base.start.Start.startServer(Start.java:314)
> > org.ofbiz.base.start.Start.start(Start.java:318)
> > org.ofbiz.base.start.Start.main(Start.java:404)
> >
>
>
--------------------------------------------------------------------------------
> >
> > 2007-03-26 19:00:08,283 (main) [ ConnectionFactory.java:74 :ERROR]
> > *******
> > ERROR: No database connection found for helperName "localpostgres"
> > 2007-03-26 19:00:08,287 (main) [ DatabaseUtil.java:835:ERROR]
> > Unable
> > to esablish a connection with the database... Error
> > was:org.ofbiz.entity.GenericEntityException: No connection available
> > for
> > helper named [localpostgres]
> > 2007-03-26 19:00:08,288 (main) [ DatabaseUtil.java:143:ERROR]
> > Could
> > not get table name information from the database, aborting.
> > 2007-03-26 19:00:09,087 (main) [XAConnectionFactory.java:371:ERROR]
> > Can't
> > get an XAConnection
> > org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for
> > host
> > " 10.73.65.125", user "ofbiz", database "ofbiz-current", SSL off
> > at
> >
> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(
> ConnectionFactoryImpl.java :275)
> > at
> >
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(
> ConnectionFactoryImpl.java:94)
> > at
> >
> org.postgresql.core.ConnectionFactory.openConnection(
> ConnectionFactory.java :65)
> > at
> >
> org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(
> AbstractJdbc2Connection.java:116)
> > at
> >
> org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(
> AbstractJdbc3Connection.java :30)
> > at
> > org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
> > at org.postgresql.Driver.makeConnection(Driver.java:369)
> > at org.postgresql.Driver.connect (Driver.java:245)
> > http://www.nabble.com/file/7467/ofbiz.log ofbiz.log
> >
> >
> > cjhowe wrote:
> > >
> > > I'm not sure I can offer much assistance in your issue, but it may
> > help
> > > others if you could share what error(s) you receive both from ofbiz
> > and
> > > from postrgres.
> > >
> > >
> > > --- Sam Benz < [EMAIL PROTECTED]> wrote:
> > >
> > >>
> > >> Hello everyone.
> > >>
> > >> Ofbiz is not able to connect to my postgres database when I
> > >> configure my
> > >> hba.conf file to require an SSL connection. How do I configure the
> > >> entityengine to use SSL to connect to my postgres DB?
> > >>
> > >> Thank you.
> > >>
> > >> Sincerely,
> > >>
> > >> Sam Benz
> > >> --
> > >> View this message in context:
> > >>
> > >
> >
>
> http://www.nabble.com/postgres-ssl-enabled-connection-tf3470806.html#a9685670
> > >> Sent from the OFBiz - User mailing list archive at Nabble.com.
> > >>
> > >>
> > >
> > >
> > >
> >
> > --
> > View this message in context:
> >
> http://www.nabble.com/postgres-ssl-enabled-connection-tf3470806.html#a9702592
>
> > Sent from the OFBiz - User mailing list archive at Nabble.com.
> >
> >
>
>
