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. > >
