[gull] User PostgreSQL sous RH8.0

florian at salamin.net florian at salamin.net
Thu Dec 18 08:54:02 CET 2003


Bonjour,

Je souhaite créer 2 utilisateurs PostgreSQL sur une machine RedHat 8.0
(voir extrait de log ci-dessous).J'ai motifié le fichier pg_hba.conf pour permettre la connexion au serveur
avec un loginname indépendant du compte utilisateur utilisé.Même apres un
-bash-2.05b$ pg_ctl reload
il m'est impossible de me loguer avec un compte utilisateur.

Est-ce que quelqu'un à une piste à me donner car là, je suis en train de
sécher :(
Merci,
Florian


--->8---
-bash-2.05b$ whoami
postgres
-bash-2.05b$ createuser -W safl_dbo
Shall the new user be allowed to create databases? (y/n) n
Shall the new user be allowed to create more new users? (y/n) y
Password:
CREATE USER
-bash-2.05b$ createuser -W safl_user
Shall the new user be allowed to create databases? (y/n) n
Shall the new user be allowed to create more new users? (y/n) n
Password:
CREATE USER
-bash-2.05b$ tail /usr/local/pgsql/data/pg_hba.conf

#local      all                                          trust
#host       all         127.0.0.1     255.255.255.255    trust

# Using sockets credentials for improved security. Not available everywhere,
# but works on Linux, *BSD (and probably some others)

# TYPE  DATABASE        IP_ADDRESS      MASK            AUTH_TYPE      
AUTH_ARGUMENTlocal   all     all                                     trust
#local          all                                             ident     
     sameuser-bash-2.05b$ createdb test
CREATE DATABASE
-bash-2.05b$ psql test
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

test=# \q
-bash-2.05b$ psql -W -U safl_dbo -d test
Password:
psql: FATAL 1:  IDENT authentication failed for user "safl_dbo"

-bash-2.05b$ psql -W -U safl_user -d test
Password:
psql: FATAL 1:  IDENT authentication failed for user "safl_user"

-bash-2.05b$ uname -a
Linux casa 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux
-bash-2.05b$ cat /etc/issue
Red Hat Linux release 8.0 (Psyche)
Kernel \r on an \m

-bash-2.05b$

--->8---






More information about the gull mailing list