Are the OLAP and tenant databases used at all if you aren't running multi-tenant? Running "./ant run-install" didn't seem to create any tables there when I tested it a year or so ago back.
On Thu, 2011-11-10 at 15:58 -0800, Mike wrote: > 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 > <[email protected]> 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 <[email protected]> > > RidgeCrest Herbals, Inc. > > > > -- Matt Warnock <[email protected]> RidgeCrest Herbals, Inc.
