Home > mailing lists

PostgreSQL with Kerberos and Active Directory - Mailing list pgsql-general

From	Idan Miller
Subject	PostgreSQL with Kerberos and Active Directory
Date	August 30, 2007 11:07:19
Msg-id	67cee7200708300407i218d5088o559232b4503544fa@mail.gmail.com Whole thread Raw
Responses	Re: PostgreSQL with Kerberos and Active Directory
List	pgsql-general

Hi everyone,

I'm trying to configure PostgreSQL version 8.2.4 with Kerberos and Active Directory.

The AD is run on a windows 2003 server, and the postgre on gentoo.

The gentoo computer name is postgre and it's added to the windows 2003 server AD domain.

I did the following:

- I compiled postgre with kerberos support and installed it on the gentoo machine.

- I created a keytab for the user postgres/postgre on the windows 2003 server machine and copied it to the gentoo machine.

- I configured the postgresql.conf to point to the keytab.

- I configured pg_hba.conf to authenticate remote users by kerberos.

- I followed additional configurations from the howto in the mailing list archives.

Now, when trying to log in with an AD user to postgre I get:

psq: krb5_sendauth: Bad application version was sent (via sendauth)

Any help will be appreciated.

Thanks,

Idan.

From: "Scott Marlowe"
Date: 30 August 2007, 10:37:01
Subject: Re: What kind of locks does vacuum process hold on the db?

From: Magnus Hagander
Date: 30 August 2007, 11:22:23
Subject: Re: PostgreSQL with Kerberos and Active Directory