[Freeipa-users] freeipa and postgresql

[Stephen Gallagher]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 09/15/2010 11:10 AM, Fereyre Jerome wrote:
> If i stay as the root user system and do :
>     kinit jeradm;
>     psql -d postgres -h ipa0
> 
> Postgresql prevent me from connecting to the database and in the log i
> have messages like
>     [ipa0][postgres] FATAL:  GSSAPI authentication failed for user "root"
>     [ipa0][postgres] LOG:  provided username (root) and authenticated
> username (jeradm) don't match
> 
> In my rookie comprehension of kerberos, psql will have to use my ticket
> to identify the user to use for connection... but
> it keep using my current linux user account ...
> 
> I think that i haved missed something....


try doing:

kinit jeradm
psql -d postgres -h ipa0 -U jeradm

That tells psql that you're trying to log in as user jeradm instead of
root (by default it assumes it should use your logged-in username)

- -- 
Stephen Gallagher
RHCE 804006346421761

Delivering value year after year.
Red Hat ranks #1 in value among software vendors.
http://www.redhat.com/promo/vendor/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAkyQ44sACgkQeiVVYja6o6NUOgCeN9cY4d9HCpWoV0QINH7SaI1A
IlgAn1FS2jIm9T0uZHxTf4jmBqf/lC4g
=bzkP
-----END PGP SIGNATURE-----