linking postgre to AD

I am looking into using PostgreSQL on the backend here. I work for a Bible College. We are putting together a
new software package. The database would be on a LInux box but our domain is M$ so we use active
directory. I saw that there is a PAM module for Postgre. My question is with applications that will both be
standalone and web what is teh best way for me to authenticate to active directory. C

Is there a Postgre function that will allow me to do this?
Does anyone have any other ideas that will work?

Thank you in advance for any feedback.

Jason Tesser
Web/Multimedia Programmer
Northland Ministries Inc.
(715)324-6900 x3050


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

re: linking postgre to AD

On Fri, Nov 21, 2003 at 06:27:01AM -0600, Jason Tesser wrote:
[color=blue]
> I am looking into using PostgreSQL on the backend here. I work for a Bible College. We are putting together a
> new software package. The database would be on a LInux box but our domain is M$ so we use active
> directory. I saw that there is a PAM module for Postgre. My question iswith applications that will both be
> standalone and web what is teh best way for me to authenticate to active directory. C[/color]
[color=blue]
> Is there a Postgre function that will allow me to do this?
> Does anyone have any other ideas that will work? [/color]

I'm not quite clear what you want to do. If you want to authenticate
against an Active Directory server, then you need to talk LDAP to it,
probably using the PAM LDAP module. There's a fair amount of
documentation on this out on the interweb.

If you want to use AD for client authentication in Postgres, section
6.2.5 of the Administrator's Guide details how to use PAM for Postgres
client authentication.

Then again, I've not tried this myself...

Dave
--
Mail: Alex Page <alex.page@cancer.org.uk>
Real: Systems/Network Assistant, Epidemiology Unit, Oxford
Tel: 01865 302 223 (external) / 223 (internal)
PGP: 8868 21D7 3D35 DD77 9D06 BF0A 0746 2DE6 55EA 367E

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQE/vg4aB0Yt5lXqNn4RApBQAKDysDWME70m6Fgpv32i5jJfCjQRkg CfRXZX
+m8BvbdNYBAXUk7FXljMBP8=
=5rSk
-----END PGP SIGNATURE-----

re: linking postgre to AD

Jason Tesser wrote:
[color=blue]
> I saw that there is a PAM module for Postgre.[/color]

Just out of curiosity, where did you get the notion that the shorthand
for PostgreSQL is "Postgre" and not "Postgres" ?

Marc, would it be possible to have a TIP that reads:

"Postgres + SQL = PostgreSQL"

In fact, could you use the above in replacement of this one:

---|
V
[color=blue]
> TIP 4: Don't 'kill -9' the postmaster[/color]

Mike Mascari
mascarm@mascari.com






---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly