Re: Installation on CentOS 5.6 with PostgreSQL

Posted by Mike Z on Nov 10, 2011; 11:58pm
URL: http://ofbiz.116.s1.nabble.com/Installation-on-CentOS-5-6-with-PostgreSQL-tp4024345p4029955.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.
>
>