Tarlika, now I have tried the steps from Opentaps.org and the ones supplied by you earlier and I still get stuck in the verification paragraph of the tutorial at Opentaps.org. I've been discussing another issue with Si Chen and some others and I see some kind of pattern. Don't know if it's Ubuntu (love it) or some human error (me then). My only hope is someone with the same problem. Please keep me posted on any progress
Carl T E Schmitz wrote: > > carlj wrote: >>> I am trying to use Postgre instead of default derby DB. I followed the >>>instructions from Undersun, but have little problem connecting to the >>>database. OFBiz can not connect to it. >>> >>>*My configuration is:* Postgre SQL 7.4.8. >>>*JDBC client database file:* in /ofbiz/framework/entity/lib/jdbc called >>>pg74.216.jdbc3.jar >>>*entityengine.xml has being modified to:* >>> >>> >>>*Error I have:** Exception: org.ofbiz.entity.GenericDataSourceException >>>Message: Unable to esablish a connection with the database. Connection was >>>null!* > > Hello Вадим + Carl, > I am running OFBiz with PostgreSQl 7.4. It was pretty straightforward to > set up. I am running an OFBiz revision from last year but hopefully the > following will still be of applicable: > > There are only 2 things to set up in OFBiz: > - entityengine.xml > - drop the appropriate driver jar into framework/entity/lib/jdbc > > Of course, you need to create the PostgreSQL user + DB before starting > OFBiz: > createuser myuser ... > createdb mydb > > The user needs to have the permission to create tables. > > In entityengine.xml set up the datasource : > > <datasource name="localpostgres" > ... > <inline-jdbc > jdbc-driver="org.postgresql.Driver" > jdbc-uri="jdbc:postgresql://<my-ip>:5432/mydb" > jdbc-username="myuser" > jdbc-password="mypass" > isolation-level="ReadCommitted" > pool-minsize="2" > pool-maxsize="20"/> > > Comment out the jndi-jdbc stuff. > > load the seed data: > java -jar ofbiz.jar -install -readers=seed > and to get started the demo data: > java -jar ofbiz.jar -install -readers=demo > > Start OFBiz: > ./startofbiz.sh > > And Bob's your uncle. > > -- > > > Regards, > > Tarlika Elisabeth Schmitz > > -- View this message in context: http://www.nabble.com/Users---Using-PostgreSQL-tf1009995.html#a5561795 Sent from the OFBiz - User forum at Nabble.com.
