postgres ssl enabled connection

[Sam Benz]

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

[cjhowe]

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 <[hidden email]> 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.
>
>

[Sam Benz]

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)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 <[e-mail]> 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.
>
>

[cjhowe]

first make sure you have a user on your postgres server for
ofbiz@10.73.65.125 (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 <[hidden email]> 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 <[hidden email]> 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.
>
>

[cjhowe]

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 <[hidden email]> wrote:

> first make sure you have a user on your postgres server for
> ofbiz@10.73.65.125 (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 <[hidden email]> 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 <[hidden email]> 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.
> >
> >
>
>

[Sam Benz]

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 <[hidden email]> wrote:

>
> first make sure you have a user on your postgres server for
> ofbiz@10.73.65.125 (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 <[hidden email]> 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 <[hidden email]> 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.
> >
> >
>
>

[Sam Benz]

my bad... 192.168.1.4 is incorrect but I corrected the address and the
result is the same though

On 3/27/07, Samuel Benz <[hidden email]> wrote:

>
> I tried it...
>
> Here is a sample...
>
>  <inline-jdbc
>                 jdbc-driver="org.postgresql.Driver"
>                 ssl="true"
>                 jdbc-uri="jdbc:postgresql://10.73.65.114/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 < [hidden email]> wrote:
> >
> > first make sure you have a user on your postgres server for
> > ofbiz@10.73.65.125 (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 <[hidden email]> 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 < [hidden email]> 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.
> > >
> > >
> >
> >
>

[Sam Benz]

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 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 <[e-mail]> wrote:

> first make sure you have a user on your postgres server for
> ofbiz@10.73.65.125 (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 <[e-mail]> 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 <[e-mail]> 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.
> >
> >
>
>

[cjhowe]

I often times get confused which side is needing the trusting, but my
belief is that you need to put the postgres server's certificate into
ofbiz's truststore...

steps for this should be similar to the heading "SSL" in the following
link http://docs.ofbiz.org/display/OFBIZ/Google+Checkout+Integration
just replace checkout.google.com with the location of your postgres
server.

--- Sam Benz <[hidden email]> wrote:

>
> 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 <[hidden email]> wrote:
> >
> >> first make sure you have a user on your postgres server for
> >> ofbiz@10.73.65.125 (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 <[hidden email]> 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
>

=== message truncated ===

[Sam Benz]

I have imported postgres's server.crt into ofbiz's keystore using keytool. now I am getting the following error in my postgrestql log file 'could not accept SSL connection: sslv3 alert certificate unknown'

I have been looking through both postgres and ofbiz documentation and I have exported a certificate file from ofbizssl.jks to the postgres data directory (where root.crt is stored) but I can't find any docs about the keystore in postgres.

Thanks again,

Sam

cjhowe wrote

I often times get confused which side is needing the trusting, but my
belief is that you need to put the postgres server's certificate into
ofbiz's truststore...

steps for this should be similar to the heading "SSL" in the following
link http://docs.ofbiz.org/display/OFBIZ/Google+Checkout+Integration
just replace checkout.google.com with the location of your postgres
server.

--- Sam Benz <[e-mail]> wrote:

>
> 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 <[e-mail]> wrote:
> >
> >> first make sure you have a user on your postgres server for
> >> ofbiz@10.73.65.125 (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 <[e-mail]> 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
>
=== message truncated ===

[Shi Jinghai]

Hi Sam,

The keystores should look like this:
postgress keystore              ---       ofbiz ssl keystore
postgress public&private key             ofbiz public&private key
ofbiz public key                         postgress public key

please read this
ref:http://www-128.ibm.com/developerworks/edu/j-dw-javajsse-i.html

Regards,

Shi Jinghai/Beijing Langhua Ltd.


在 2007-03-29四的 18:41 -0700，Sam Benz写道：

> I have imported postgres's server.crt into ofbiz's keystore using keytool.
> now I am getting the following error in my postgrestql log file 'could not
> accept SSL connection: sslv3 alert certificate unknown'
>
> I have been looking through both postgres and ofbiz documentation and I have
> exported a certificate file from ofbizssl.jks to the postgres data directory
> (where root.crt is stored) but I can't find any docs about the keystore in
> postgres.
>
> Thanks again,
>
> Sam
>
>
> cjhowe wrote:
> >
> > I often times get confused which side is needing the trusting, but my
> > belief is that you need to put the postgres server's certificate into
> > ofbiz's truststore...
> >
> > steps for this should be similar to the heading "SSL" in the following
> > link http://docs.ofbiz.org/display/OFBIZ/Google+Checkout+Integration
> > just replace checkout.google.com with the location of your postgres
> > server.
> >
> > --- Sam Benz <[hidden email]> wrote:
> >
> >>
> >> 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 <[hidden email]> wrote:
> >> >
> >> >> first make sure you have a user on your postgres server for
> >> >> ofbiz@10.73.65.125 (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 <[hidden email]> 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
> >>
> > === message truncated ===
> >
> >
> >
>

[cjhowe]

postgres's server.crt needs to be in ofbiz's TRUST store
(ofbiztrust.jks)

This postgres message 'confirms' that the error comes from the client
not trusting postgres...
http://archives.postgresql.org/pgsql-jdbc/2003-03/msg00278.php

--- Sam Benz <[hidden email]> wrote:

>
> I have imported postgres's server.crt into ofbiz's keystore using
> keytool.
> now I am getting the following error in my postgrestql log file
> 'could not
> accept SSL connection: sslv3 alert certificate unknown'
>
> I have been looking through both postgres and ofbiz documentation and
> I have
> exported a certificate file from ofbizssl.jks to the postgres data
> directory
> (where root.crt is stored) but I can't find any docs about the
> keystore in
> postgres.
>
> Thanks again,
>
> Sam
>
>
> cjhowe wrote:
> >
> > I often times get confused which side is needing the trusting, but
> my
> > belief is that you need to put the postgres server's certificate
> into
> > ofbiz's truststore...
> >
> > steps for this should be similar to the heading "SSL" in the
> following
> > link
> http://docs.ofbiz.org/display/OFBIZ/Google+Checkout+Integration
> > just replace checkout.google.com with the location of your postgres
> > server.
> >
> > --- Sam Benz <[hidden email]> wrote:
> >
> >>
> >> 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 <[hidden email]> wrote:
> >> >
> >> >> first make sure you have a user on your postgres server for
> >> >> ofbiz@10.73.65.125 (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 <[hidden email]> 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)
>
=== message truncated ===