Posted by
Matt Warnock on
URL: http://ofbiz.116.s1.nabble.com/Installation-on-CentOS-5-6-with-PostgreSQL-tp4024345p4029646.html
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.