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.
