http://ofbiz.116.s1.nabble.com/Installation-on-CentOS-5-6-with-PostgreSQL-tp4024345p4030000.html
> I use this script to create the postgres databases: I seem to recall
> that I had to do this prior to running ant.
>
> postgres@db02:~$ cat recreate_ofbis.sh
> #! /bin/bash
>
> dropdb ofbiztenant; dropdb ofbizolap; dropdb ofbiz
>
> for db in ofbiz ofbizolap ofbiztenant; do
> cmd="
> CREATE DATABASE $db
> WITH OWNER = ofbiz
> ENCODING = 'UTF8'
> TABLESPACE = pg_default
> LC_COLLATE = 'en_US.UTF-8'
> LC_CTYPE = 'en_US.UTF-8'
> CONNECTION LIMIT = -1;
> "
> psql -c "$cmd" -d postgres
> done
>
>
> On Thu, Nov 10, 2011 at 2:20 PM, Matt Warnock
> <
[hidden email]> wrote:
> > Yeah, i fell into that trap myself once, which is why I wanted to
> > respond right away. Hate to see others in that situation. It should be
> > documented more clearly, IMHO.
> >
> > Next thing is to make sure you can login to your ofbiz database using
> > psql -h <hostname> -U ofbiz <ofbizdb>
> > where: <hostname> is the host where the database is (can be localhost);
> > ofbiz is the username that has been created in postgres using
> > createuser; and <ofbizdb> is the database name that has been created
> > with createdb and is owned by user ofbiz. The database can/should be
> > empty, but it must exist and the ofbiz user must be able to connect to
> > it using the password you specify in the entity engine config file.
> >
> > If you don't specify a host (-h localhost), psql will use Unix sockets,
> > not TCP/IP, which is what ofbiz needs. By default, postgres may not
> > allow TCP/IP connections, even from localhost, so you may need to
> > edit /etc/postgresql/8.4/main/pg_hba.conf as I'm not sure what CentOS
> > uses by default, I'm on Debian.
> >
> > Once you can login to the DB using the ofbiz username and password, then
> > try "./ant run-install" again, and it should work.
> >
> >
> >
> > On Thu, 2011-11-10 at 13:49 -0800, champagroup wrote:
> >> Okay. It's funny but I don't see it written that way in the various
> >> instructions I came across. I tried it though, and I was able to get it to
> >> work. I had to modify permissions for ant, but it did build successfully.
> >> Thanks. Now I am experiencing issues with getting Ofbiz started. When I run
> >> ./startofbiz.sh, after a while it starts throwing out errors. I am seeing
> >>
> >> /2011-11-10 15:11:45,411 (org.ofbiz.service.job.JobPoller@de0a6c) [
> >> TransactionUtil.java:351:INFO ] [TransactionUtil.rollback] transaction
> >> rolled back
> >> 2011-11-10 15:11:45,411 (org.ofbiz.service.job.JobPoller@de0a6c) [
> >> TransactionUtil.java:276:WARN ] [TransactionUtil.commit] Not committing
> >> transaction, status is No Transaction (6)
> >> 2011-11-10 15:11:45,426 (org.ofbiz.service.job.JobPoller@de0a6c) [
> >> GenericDelegator.java:1295:ERROR]
> >> ---- exception report
> >> ----------------------------------------------------------
> >> Failure in storeByCondition operation for entity [JobSandbox]:
> >> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
> >> occured in updateByCondition (Unable to esablish a connection with the
> >> database. (Unable to acquire a new connection from the pool)). Rolling back
> >> transaction.
> >> Exception: org.ofbiz.entity.GenericDataSourceException
> >> Message: Generic Entity Exception occured in updateByCondition (Unable to
> >> esablish a connection with the database. (Unable to acquire a new connection
> >> from the pool))
> >> ---- cause
> >> ---------------------------------------------------------------------
> >> Exception: org.ofbiz.entity.GenericDataSourceException
> >> Message: Unable to esablish a connection with the database. (Unable to
> >> acquire a new connection from the pool)
> >> ---- cause
> >> ---------------------------------------------------------------------
> >> Exception: java.sql.SQLException
> >> Message: Unable to acquire a new connection from the pool
> >> ---- cause
> >> ---------------------------------------------------------------------
> >> Exception: org.postgresql.util.PSQLException
> >> Message: FATAL: Ident authentication failed for user "ofbiz"/
> >>
> >> I take it that there is something wrong with authentication, but how do I
> >> make sure to set that up properly?
> >>
> >>
> >> --
> >> View this message in context:
http://ofbiz.135035.n4.nabble.com/Installation-on-CentOS-5-6-with-PostgreSQL-tp4024345p4029536.html> >> Sent from the OFBiz - User mailing list archive at Nabble.com.
> >
> > --
> > Matt Warnock <
[hidden email]>
> > RidgeCrest Herbals, Inc.
> >
> >