Freshly created user cannot connect

From: Thiemo Kellner <thiemo(at)thiam(dot)ch>
To: pgsql-novice(at)postgresql(dot)org
Subject: Freshly created user cannot connect
Date: 2003-08-08 22:10:55
Message-ID: 200308090010.55963.thiemo@thiam.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

maybe I am a bit stupid, though it is quite a long time since I had to
administer. However, the problem is such:

I'd like to put the GnuMed (http://www.gnumed.org) repository onto a separate
database. Therefore I created a script gnumed_install.sql that should do the
tirck. Below the beginning of the script creating database owner/dba and
connecting to it as freshly created user and creating the database. I make it
run as postgres (superuser) on template1.

**
-- Thiemo Kellner, 2003-08-09, thiemo(at)thiam(dot)ch
-- This code may be used or altered freely. I do not take any liability.

-- put the lines below (without line comment --) into pg_hba.conf
--host GNUMED GNUMED_DBA 0.0.0.0 0.0.0.0 md5
--host template1 GNUMED_DBA 0.0.0.0 0.0.0.0 md5

-- force terminate + exit(3) on errors if non-interactive
\unset ON_ERROR_STOP

-- Create a user the data base belongs to
drop user GNUMED_DBA;
create user GNUMED_DBA
encrypted password 'xyz'
createuser
createdb
;

\set ON_ERROR_STOP 1

-- Create the data base that is to contain the GnuMed repository
-- as the GnuMed repository owner (gnumed_dba)
\connect template1 GNUMED_DBA

create database GNUMED;

-- Revoke the right to create data bases from the the GnuMed repository owner
-- (gnumed_dba). One data base is enough ;)
\connect template1 postgres

alter user GNUMED_DBA
nocreatedb
;
-- remove the line below from pg_hba.conf
--host template1 GNUMED_DBA 0.0.0.0 0.0.0.0 md5
\echo Please change pg_hba.conf such that gnumed_dba only may connect to
\echo its own repository

-- Populate the GnuMed repository with its objects
***

The script create the new user but connecting with it fails:
template1=# \i gnumed_install.sql
DROP USER
CREATE USER
Passwort:
psql:gnumed_install.sql:24: \connect: FATAL: Password authentication failed
for user "GNUMED_DBA"

I neither can connect with this user by
# psql -d template1 -h nyffeltrach -U GNUMED_DBA
giving me the same error:
Passwort:
psql: FATAL: Password authentication failed for user "GNUMED_DBA"

Does anybody have an idea what I am doing wrong? All my other users have been
created with the same statement options.

Cheers,

Thiemo

--
root ist die Wurzel allen Übels

Browse pgsql-novice by date

  From Date Subject
Next Message John T. Yocum 2003-08-09 05:22:47 CURRENT TIME causes server to shutdown connection
Previous Message Bruce Momjian 2003-08-08 17:44:15 Re: COPY and text encodings