Re: [Gnumed-devel] pg_hba.conf, pg_ident.conf, dh-install_gnumed_server.sh, v , net_install-gnumed_server.sh, v

[Karsten Hilbert]

On Thu, Aug 21, 2008 at 10:30:14PM -0400, Geordie wrote:

> is mailx important for I do not have it installed

Only for some optional helper scripts which handle database
backup.

> dropdb: could not connect to database postgres: FATAL:  password 
> authentication failed for user "postgres"

This has to do with how pg_hba.conf is set up.

> Cannot bootstrap bundles.
> Please check the log file for details.
> Bootstrapping "gnumed_v2" did not finish successfully. Aborting.
> address@hidden:~/.gnumed/server-installation/GNUmed-v8/server/bootstrap#  
> /home/Geordie/.gnumed/server-installation
> There is nothing
You ran under root so you need to look at /root/.gnumed/server...

> /home/Geordie/.gnumed/server-installation
> has nothing in it
You ran under root so you need to look at /root/.gnumed/server...

> [sudo] password for Geordie:
> Geordie is not in the sudoers file.  This incident will be reported.
> 
> I will report that I put Geordie in the sodoers list at least I think I 
> formatted right

Apparently sudo isn't set up right for you yet.

>  /etc/postgresql/8.3/main/pg_hba.conf
> 
> # PostgreSQL Client Authentication Configuration File
> # ===================================================
> # Put your actual configuration here
> 
> # allow anyone knowing the proper password to log into
> # our GNUmed databases
> local   samegroup      +gm-logins                    md5
> # ----------------------------------
> # allow some people to impersonate "postgres" when connecting to template1
> local   template1       postgres                        ident postgres-alikes
> # replace N with the database version you want to install
> local   gnumed_vN     postgres                       ident postgres-alikes
> 
> # allow real "postgres" to connect to all other databases, too
> local   all             postgres                                ident sameuser
> 
> # allow some people to impersonate "gm-dbo"
> local   template1         gm-dbo                           ident gm-dbo-alikes
> #
> # DO NOT DISABLE!
> # If you change this first entry you will need to make sure that the
> # database
> # super user can access the database using some other method.
> # Noninteractive
> # access to all databases is required during automatic maintenance
> # (autovacuum, daily cronjob, replication, and similar tasks).
> #
> # Database administrative login by UNIX sockets
> local   all         postgres                          ident sameuser
> 
> # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
> 
> # "local" is for Unix domain socket connections only
> local   all         all                               ident sameuser
> # IPv4 local connections:
> host    all         all         127.0.0.1/32          md5
> # IPv6 local connections:
> host    all         all         ::1/128               md5

pg_hba.conf is not set up right. Read

        http://wiki.gnumed.de/bin/view/Gnumed/ConfigurePostgreSQL

and follow that advice. Use a unmodified pg_hba.conf and
just apply the one line change.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346