I tried it...
Here is a sample...
<inline-jdbc
jdbc-driver="org.postgresql.Driver"
ssl="true"
jdbc-uri="jdbc:postgresql://192.168.1.4/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.
>
>
