User can not more login

From: Michelle Konzack <linux4michelle(at)freenet(dot)de>
To: pgSQL - General <pgsql-general(at)postgresql(dot)org>
Subject: User can not more login
Date: 2006-07-19 12:45:06
Message-ID: jxXn4.A.zR.mW1xEB@t1950ct.private
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello *,

I am searching for a weired error... Since all users are working fine,
I was now root and done a 'su - postgresql' to create a new user with

createuser --password devel.debian
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

Now the weired thing is, that the new user is visible in

/home/postgresql/data/global/1260

but not in

/home/postgresql/data/global/pg_pwd

All other users are there...
Here I have the striped output of

SELECT * FROM pg_shadow ORDER BY usename;
usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig
------------------+----------+-------------+----------+-----------+-------------------------------------+----------+-----------
devel.debian | 107 | f | f | f | | |
michelle.konzack | 100 | t | t | t | mdXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | |
omegasector | 103 | f | t | t | mdXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | |
peer.janssen | 102 | f | f | f | mdXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | |
pmc.omega | 105 | f | t | t | mdXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | |
root | 104 | f | f | f | mdXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | |
postgres | 1 | t | t | t | | |
tamay.dogan | 101 | t | t | t | mdXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | |
(9 rows)

Hmm, it does not create the password, even if it had ask me for it...
And if I continue with

createdb --encoding=utf-8 --owner=devel.debian devel.debian
CREATE DATABASE

and the I use 'psql -l'

List of databases
Name | Owner | Encoding
------------------+------------------+-----------
devel.debian | devel.debian | UNICODE
michelle.konzack | michelle.konzack | SQL_ASCII
omegasector | omegasector | UNICODE
peer.janssen | peer.janssen | UNICODE
root | root | SQL_ASCII
systemdb | root | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
(9 rows)

In endeffect, if I try to login as $USER devel.debian with

psql devel.debian
Password:
psql: FATAL: Password authentication failed for user "devel.debian"

How can this happen?
There is no difference between the user "debian.devel" or
"michelle.konzack" or any others...

It was realy weired, since I create the databases automaticaly from a
script while I create new SYSTEM users... Now it fails.

The used database is

psql (PostgreSQL) 7.4.7

contains support for command-line editing

Greetings
Michelle Konzack

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Volkan YAZICI 2006-07-19 12:50:15 Re: problem creating users via pythons script
Previous Message Volkan YAZICI 2006-07-19 12:13:25 Re: problem creating users via pythons script