Forum OpenACS Q&A: Missing or Erroneous pg_hba.conf file

Collapse
1: Missing or Erroneous pg_hba.conf file
Posted by Carlos Villarreal on 11/15/01 09:13 PM
Hi, I'm new to the comunity and to the non-windows world in general,
so I would really apretiate your help on this. I've read a lot of
threads on the subject and I thought I did everything by the book,
but something is wrong in my setup...

I followed the instructions on installing OpenACS on Red Hat 7.1
(http://www.xc.org/jonathan/openacs/whichfilesdoineed.html), I
uninstalled PostgreSQL 7.0.3 and Apache 1.3.14 before installing the
RPMs but the install failed becouse of a missing or erroneous
pg_hba.conf file.

Where can I get this file and what do I do now ?? please help, I'm a
newbie here :o)

Here's the whole enchilada:

[root@linux-des2 openACS]# rpm -Uvh *rpm

Preparing...########################################## [100%]

1:libxml2  ########################################### [ 12%]

2:aolserver ########################################## [ 25%]

3:postgresql-libs #################################### [ 37%]

4:aolserver-postgresql ############################### [ 50%]

5:postgresql ######################################### [ 62%]

6:postgresql-server ################################## [ 75%]

7:openacs  ########################################### [ 87%]

Creating postgres user and database acs

psql: Missing or erroneous pg_hba.conf file, see postmaster log for
details

createuser: creation of user "acs" failed

psql: Missing or erroneous pg_hba.conf file, see postmaster log for
details

createdb: database creation failed

Adding plpgsql language to database acs

psql: Missing or erroneous pg_hba.conf file, see postmaster log for
details

createlang: external error

psql: Missing or erroneous pg_hba.conf file, see postmaster log for
details

/var/tmp/rpm-tmp.2903: ERROR: Postgresql user/database acs was not
correctly sep

psql: Missing or erroneous pg_hba.conf file, see postmaster log for
details

createlang: external error

error: execution of %post scriptlet from openacs-3.2.5-2 failed, exit
status 4

8:postgresql-tcl ########################################### [100%]

psql: Missing or erroneous pg_hba.conf file, see postmaster log for
details

createlang: external error

psql: Missing or erroneous pg_hba.conf file, see postmaster log for
details

You have new mail in /var/spool/mail/root

[root@linux-des2 openACS]#

Thank you.
Carlos

P.S. sorry for the long post.

Collapse
2: Response to Missing or Erroneous pg_hba.conf file (response to 1)
Posted by Jun Yamog on 11/19/01 10:37 AM
Hi Carlos,

You can start by looking if pg_hba.conf is really existing or not.  I dont have an RPM install of Postgres but I believe it must be in /var/lib/pgsql.  You can also try "locate pg_hba.conf" to locate the file.

If the file is not existing and no other files are in /var/lib/pgsql you may have to reinitialize the database via initdb.  Or maybe doing a "/etc/rc.d/init.d/postgres restart" may detect that there is no database initialize and it will do it for you.  Hope this help, post some more if you need further help.

Collapse
3: Response to Missing or Erroneous pg_hba.conf file (response to 1)
Posted by Carlos Villarreal on 11/19/01 10:10 PM
Hi,

I tried "locate pg_hba.conf" and all I got was this file:

/usr/share/pgsql/pg_hba.conf.sample

I did the restart thing but there still is no pg_hba.conf, so I think that I can copy the sample to the location where it should be (and I don't know where) and maybe that way this would work, but when I get the .conf file finaly working, do I have to re-install the openACS rpms? or just the postgresql rpms? or everything again?

Thanks for the help.... and the patience

Collapse
4: Correction from my last post (response to 1)
Posted by Carlos Villarreal on 11/19/01 10:15 PM
Wait, it looks like the restart did work, pg_hba.conf was generated at /var/lib/pgsql/data ... which brings me to my next question... now what ? ... reinstall openacs ??

Thank you.