pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Enrico Scholz <enrico.scholz@informatik.tu-chemnitz.de>
To: pgsql-admin@postgresql.org
Subject: Truncation of krb5 principals
Date: Tue, 15 Jun 2004 18:22:22 +0200
Message-ID: <87n034dc5d.fsf@kosh.ultra.csn.tu-chemnitz.de> (raw)

Hello,

I am using krb5 authorization and have a problem with the mangling of krb5
principal names. E.g. on authentication, the principals 'foo/www@XYZ.ORG'
and 'foo/mail@ABC.COM' will be both rewritten to the local username 'foo',
which is completely unwanted and might be a security problem.

In the archives, I read that this happens because '/' and '@' are
forbidden characters for usernames. An authname-to-username mapping
table was a proposed solutions, but although the discussion[1] was some
time ago in 2002, I can not find such a thing in recent postgresql
7.4.2.

When the authname -> username table would be too complicated to
implement, would it be possible to use something like OpenLDAP's
'sasl-regexp' feature? E.g. in postgresql.conf it could be written

| sasl-regexp "([^/]*)/www@XYZ.ORG"  "$1_www_XYZ_ORG"
| sasl-regexp "([^/]*)/mail@ABC.COM" "$1_mail_ABC_COM"

which maps the principals above into valid SQL usernames.




Enrico

Footnotes: 
[1]  http://groups.google.com/groups?&selm=8149.1021471997%40sss.pgh.pa.us



Message-ID: <87n034dc5d.fsf@kosh.ultra.csn.tu-chemnitz.de>
Permalink:  ../87n034dc5d.fsf@kosh.ultra.csn.tu-chemnitz.de/
Also on:    postgresql.org/message-id/87n034dc5d.fsf@kosh.ultra.csn.tu-chemnitz.de

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: enrico.scholz@informatik.tu-chemnitz.de
  Subject: Re: Truncation of krb5 principals
  In-Reply-To: <87n034dc5d.fsf@kosh.ultra.csn.tu-chemnitz.de>
  References: <87n034dc5d.fsf@kosh.ultra.csn.tu-chemnitz.de>

* 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