Actually, looking into the Minerva implementation, all of the inline-jdbc attributes are set specifically and ssl isn't one of them, so you may try appending ?ssl=true to the jdbc-uri ie: jdbc-uri="jdbc:postgresql://127.0.0.1/ofbiz?ssl=true"
--- 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. > > > > > >
