pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruce Momjian <bruce@momjian.us>
To: Sava Chankov <sava.chankov@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: md5 password authentication does not work when db_user_namespace = on
Date: Fri, 15 Aug 2008 22:48:15 -0400 (EDT)
Message-ID: <200808160248.m7G2mFV08927@momjian.us> (raw)
In-Reply-To: <8834b7bc0806230713q573bfcdav98f361425dd72e92@mail.gmail.com>

Sava Chankov wrote:
> Hi,
> when I set db_user_namespace = on in postgresql.conf and my pg_hba.conf
> contains only the line:
> local   samerole    all    password
> users can be authenticated (I have created users as username@dbname).
> However, when I change pg_hba's METHOD to md5, it doesn't work anymore. I
> attach my postgresql.conf.

This is one of those bug reports where I knew the cause as soon as I
heard it.  Let me remind people how db_user_namespace works by adding
the database name to the client-supplied user name:

	http://www.postgresql.org/docs/8.3/static/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-S...

	$ psql -U bruce test
	psql (8.4devel)
	Type "help" for help.
	
	test=> select current_user;
	 current_user
	--------------
	 bruce@test
	(1 row)
	
	test=> \q
	$ psql -U postgres@ test
	psql (8.4devel)
	Type "help" for help.
	
	test=> select current_user;
	 current_user
	--------------
	 postgres
	(1 row)

The problem is that we use the username as part of the salt when we
store the md5-encrypted password.  When the client encrypts the password
it thinks the username is different from what the server thinks is the
username.

I can't think of any clean way to fix this.  Perhaps we should just
remove the db_user_namespace feature, or throw an error when MD5
encryption is used.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +



view thread (2+ messages)

Message-ID: <200808160248.m7G2mFV08927@momjian.us>
Permalink:  ../200808160248.m7G2mFV08927@momjian.us/
Also on:    postgresql.org/message-id/200808160248.m7G2mFV08927@momjian.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: bruce@momjian.us, sava.chankov@gmail.com
  Subject: Re: md5 password authentication does not work when db_user_namespace = on
  In-Reply-To: <200808160248.m7G2mFV08927@momjian.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox