Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 7852D632229 for ; Tue, 13 Jan 2009 20:38:35 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 65688-03-2 for ; Tue, 13 Jan 2009 20:38:29 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from col0-omc1-s5.col0.hotmail.com (col0-omc1-s5.col0.hotmail.com [65.55.34.15]) by mail.postgresql.org (Postfix) with ESMTP id E3831632213 for ; Tue, 13 Jan 2009 20:38:27 -0400 (AST) Received: from COL120-W28 ([65.55.34.8]) by col0-omc1-s5.col0.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Tue, 13 Jan 2009 16:38:26 -0800 Message-ID: Content-Type: multipart/alternative; boundary="_aeb6feda-f276-4b4f-b51e-a7563f8f0ac7_" X-Originating-IP: [66.160.12.194] From: dx k9 To: posgres support Subject: initdb Date: Tue, 13 Jan 2009 19:38:25 -0500 Importance: Normal MIME-Version: 1.0 X-OriginalArrivalTime: 14 Jan 2009 00:38:26.0341 (UTC) FILETIME=[69B5B550:01C975E0] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200901/42 X-Sequence-Number: 31089 --_aeb6feda-f276-4b4f-b51e-a7563f8f0ac7_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable I just tried initdb with the -A pam option and no -W. As expected=2C I can= 't log into the instance. There is a MD5 hash and postgres still defaults= to password authentication even though I did not use the -W. Is this a bu= g? And I can't log into it because I have no idea what password it used.= Even if I did=2C it's not set up how I want it to be. I want to log in w= ith PAM. =20 In our company=2C behind the scenes pam uses openldap. It works fine addin= g a user with out a password still works fine. It's the postgres user that= I'm concerned with. The way it is now if we change the postgres password = in openldap we'd be at a loss connecting since it's using MD5. One thing I was thinking of is using a different username for the super use= r like -U Tom for the initdb. Then=2C just adding the user postgres later = via my method I know works. We add the user=2C just not specifiying a pass= word. When we log in with that user the defaul goes to ldap and we can eas= ily log in. =20 Maybe things have changed with version 8.3x and there is something else I s= hould do to specifically configure ldap instead of pam. I did notice ldap = in the pg_hba as an alternative method and don't remember that as a specifi= c method before=2C just pam. Thanks=2C ~DjK _________________________________________________________________ Windows Live=99 Hotmail=AE: Chat. Store. Share. Do more with mail.=20 http://windowslive.com/howitworks?ocid=3DTXT_TAGLM_WL_t1_hm_justgotbetter_h= owitworks_012009= --_aeb6feda-f276-4b4f-b51e-a7563f8f0ac7_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable I just tried initdb with the -A pam option and no -W. =3B As expected= =2C I can't log into the instance. =3B There is =3B a MD5 hash and = postgres still defaults to password authentication even though I did not us= e the -W. =3B Is this a bug?  =3B =3B And I can't log into it b= ecause I have no idea what password it used. =3B Even if I did=2C it's = not set up how I want it to be. =3B I want to log in with PAM. =3B =

In our company=2C behind the scenes pam uses openldap. =3B It w= orks fine adding a user with out a password still works fine. =3B It's = the postgres user that I'm concerned with. =3B The way it is now if we = change the postgres password in openldap we'd be at a loss connecting since= it's using MD5.

One thing I was thinking of is using a different us= ername for the super user like -U Tom for the initdb. =3B Then=2C just = adding the user postgres later via my method I know works. =3B We add t= he user=2C just not specifiying a password. =3B When we log in with tha= t user the defaul goes to ldap and we can easily log in. =3B

Ma= ybe things have changed with version 8.3x and there is something else I sho= uld do to specifically configure ldap instead of pam. =3B I did notice = ldap in the pg_hba as an alternative method and don't remember that as a sp= ecific method before=2C just pam.

Thanks=2C
~DjK




Windows Live=99 Hotmail=AE: Chat. Store. Share. Do more with mail. = See how it works. = --_aeb6feda-f276-4b4f-b51e-a7563f8f0ac7_--