Thread: User can not more login

User can not more login

From
Michelle Konzack
Date:
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)


Re: User can not more login

From
Chris
Date:
Michelle Konzack wrote:
> 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

--password asks for YOUR password not the new one.

You need to use:

-P or --pwprompt

see createuser --help for more info.

--
Postgresql & php tutorials
http://www.designmagick.com/

Re: User can not more login

From
Michelle Konzack
Date:
Am 2006-08-14 16:32:08, schrieb Chris:

> --password asks for YOUR password not the new one.

SCHEISE!!!  :-/

Thanks
    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)