Thanks for your help we are making progress now
I can logon to the db with the username ofbiz from pgadmin...
I just tried
<inline-jdbc
jdbc-driver="org.postgresql.Driver"
jdbc-uri="jdbc:postgresql://10.73.65.114/ofbiz-current?ssl=true"
jdbc-username="ofbiz"
jdbc-password="ofbiz"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="20"/>
with 10.73.65.125 specifically added to my hba.conf file ...
now I am getting security certificate errors from ofbiz and geronimo
Once again I have attached the ofbiz.log file
http://www.nabble.com/file/7470/ofbiz.log ofbiz.log
cjhowe wrote:
>
> 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.
>> >
>> >
>>
>>
>
>
>
--
View this message in context:
http://www.nabble.com/postgres-ssl-enabled-connection-tf3470806.html#a9705307
Sent from the OFBiz - User mailing list archive at Nabble.com.
