Posted by
Matt Warnock on
URL: http://ofbiz.116.s1.nabble.com/Installation-on-CentOS-5-6-with-PostgreSQL-tp4024345p4029982.html
That assumes that the postgresql server is named "ofbiz" as well (which
seems weird, I'd expect sql or dbms or something). It also assumes that
postgres is configured to listen on its external host interfaces, and to
respond to queries from the host where ofbiz is installed, neither of
which is default behavior for postgresql.
Default behavior for postgres is that it only listens on localhost
(127.0.0.*). So if "ofbiz" resolves to a real public or private host IP
address (not localhost or 127.0.0.1), then postgres isn't listening.
You can test with the numeric addresses to see if that is the issue. If
you need to open postgres to listen on a non-localhost interface, change
the "listen" line in /etc/postgresql/8.4/main/postgresql.conf.
Is the postgresql server on the same server as the ofbiz install (i.e.
localhost)? If so, you don't need to reconfigure postgresql, just
change "-h ofbiz" to "-h localhost" in the line you gave, and it will
probably just work, assuming that the ofbiz user and database exist.
On Thu, 2011-11-10 at 15:26 -0800, champagroup wrote:
--
Matt Warnock <
[hidden email]>
RidgeCrest Herbals, Inc.