From trever_Adams@bigfoot.com Tue Feb 1 21:43:18 2000 Received: from slkcpop3.slkc.uswest.net (slkcpop3.slkc.uswest.net [206.81.128.3]) by hub.org (8.9.3/8.9.3) with SMTP id QAA21491 for ; Tue, 1 Feb 2000 16:43:18 -0500 (EST) (envelope-from trever_Adams@bigfoot.com) Received: (qmail 10191 invoked by alias); 1 Feb 2000 21:42:31 -0000 Delivered-To: fixup-pgsql-admin@postgresql.org@fixme Received: (qmail 10170 invoked by uid 0); 1 Feb 2000 21:42:31 -0000 Received: from vdialup68.slkc.uswest.net (HELO bigfoot.com) (209.181.86.68) by pop.slkc.uswest.net with SMTP; 1 Feb 2000 21:42:31 -0000 Sender: quantumdot Message-ID: <38975346.87D8BB07@bigfoot.com> Date: Tue, 01 Feb 2000 14:42:30 -0700 From: Trever Adams X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.3.42 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: PAM authentication Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I am working on a project whereby all users can access databases, but obviously have to have rights for that database. The system includes more than database access (email, etc). I am hoping to write it so that all services use same user name and password (yes there is some virtual hosting going on here). LDAP seems to be my solution, and the OS I use has LDAP PAM support. Is this feature supported in Postgresql? Is it possible to add it? I imagine the backend code might be similar to that of Kerberos in that it takes username and domain. Trever -- For the finest in family and value oriented products: http://www.daysofyore.com From marcelo.silva@infocom.com.br Thu May 9 18:24:21 2002 Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 5E6AC47685D for ; Thu, 9 May 2002 14:24:21 -0400 (EDT) Received: from thor.infocom.com.br (200-204-62-132.dsl.telesp.net.br [200.204.62.132]) by postgresql.org (Postfix) with ESMTP id DABCC475BAD for ; Thu, 9 May 2002 14:22:31 -0400 (EDT) Received: from MARCELO (unknown [10.10.10.101]) by thor.infocom.com.br (Postfix) with SMTP id 9127290415 for ; Thu, 9 May 2002 15:02:27 -0300 (BRT) Message-ID: <001a01c1f783$50871110$650a0a0a@MARCELO> From: "Marcelo Henrique da Silva" To: Subject: PAM Authentication Date: Thu, 9 May 2002 14:59:50 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0017_01C1F76A.2B1B2D80" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200205/75 X-Sequence-Number: 4250 This is a multi-part message in MIME format. ------=_NextPart_000_0017_01C1F76A.2B1B2D80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, Somebody uses the PAM Authentication method? I'm currently using ther version 7.2.1 compiled with "--with-pam". The following lines are in my pg_hba.conf. If is missing something, ple= ase tell me what! local pam postgres= ql host all 10.10.10.1 255.255.255.0 pam postgresql Marcelo Henrique da Silva Infocom Network Services Brazil ------=_NextPart_000_0017_01C1F76A.2B1B2D80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi All,
 
    Somebody uses the PAM= =20 Authentication method?
    I'm currently using the= r version=20 7.2.1 compiled with "--with-pam".
    The following lines are= in my=20 pg_hba.conf. If is missing something, please tell me what!
 
local          &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;      pam=20     postgresql
host    all  &nbs= p;=20 10.10.10.1    255.255.255.0   =20 pam    postgresql
 
Marcelo Henrique da Silva
Infocom Network Services
Brazil
------=_NextPart_000_0017_01C1F76A.2B1B2D80-- From ecaillava@interlap.com.ar Fri Aug 23 15:02:48 2002 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1FE5F475B88 for ; Fri, 23 Aug 2002 11:02:48 -0400 (EDT) Received: from smtp5.arnet.com.ar (smtp5.arnet.com.ar [200.45.191.23]) by postgresql.org (Postfix) with SMTP id 19307475AFF for ; Fri, 23 Aug 2002 11:02:47 -0400 (EDT) Received: (qmail 17872 invoked from network); 23 Aug 2002 14:58:34 -0000 Received: ThePolice Version 0.02 by GCM Received: from unknown (HELO 219) (200.43.38.3) by smtp5.arnet.com.ar with SMTP; 23 Aug 2002 14:58:33 -0000 Message-ID: <000a01c24ab5$e0b4b370$db00a8c0@219> From: "Sub Director Sistemas Informaticos" To: Subject: PAM authentication Date: Fri, 23 Aug 2002 12:00:45 -0300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/281 X-Sequence-Number: 5395 I need to configure PostgreSQL to allow "domain users" granting permissions through PAM, using the system users list. Any body know how to do it ? Thanks in advance Eduardo From ecaillava@interlap.com.ar Fri Aug 23 15:29:35 2002 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9FAED475AFF for ; Fri, 23 Aug 2002 11:29:35 -0400 (EDT) Received: from smtp3.arnet.com.ar (smtp3.arnet.com.ar [200.45.191.14]) by postgresql.org (Postfix) with SMTP id 59D88475A8E for ; Fri, 23 Aug 2002 11:29:34 -0400 (EDT) Received: (qmail 19772 invoked from network); 23 Aug 2002 15:29:34 -0000 Received: from unknown (HELO 219) (200.43.38.3) by smtp3.arnet.com.ar with SMTP; 23 Aug 2002 15:29:31 -0000 Message-ID: <000c01c24ab9$a654b690$db00a8c0@219> From: "Sub Director Sistemas Informaticos" To: Subject: PAM authentication Date: Fri, 23 Aug 2002 12:27:47 -0300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/282 X-Sequence-Number: 5396 I need to configure PostgreSQL to allow "domain users" granting permissions through PAM, using the system users list. Any body know how to do it ? Thanks in advance Eduardo From brettn@bigpond.com Fri Jan 31 06:18:13 2003 X-Original-To: pgsql-admin@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 741DD4764FB for ; Fri, 31 Jan 2003 01:18:13 -0500 (EST) Received: from mta02bw.bigpond.com (unknown [144.135.24.138]) by postgresql.org (Postfix) with ESMTP id E91E54764C9 for ; Fri, 31 Jan 2003 01:18:10 -0500 (EST) Received: from AMD1200 ([144.135.24.69]) by mta02bw.bigpond.com (Netscape Messaging Server 4.15 mta02bw Jul 16 2002 22:47:55) with SMTP id H9KERU00.ATK for ; Fri, 31 Jan 2003 16:16:42 +1000 Received: from FLPP-p-144-134-125-128.prem.tmns.net.au ([144.134.125.128]) by bwmam01.mailsvc.email.bigpond.com(MailRouter V3.0n 2/5022070); 31 Jan 2003 16:16:42 Message-ID: <001301c2c8f0$2c54b3d0$0101a8c0@AMD1200> From: "Brett Northcott" To: Subject: PAM authentication Date: Fri, 31 Jan 2003 16:45:37 +1030 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/353 X-Sequence-Number: 7195 ok - fairly new to postgresql & tring to set up tcp/ip access using pam authentication using gentoo_linux 1.4_rc2 postgresql-7.3.1 my pg_hba.conf file has the entries # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD local all all trust host all all 127.0.0.1 255.255.255.255 trust host all all 192.168.1.1 255.255.255.0 pam postgresql my /etc/pam.d/postgresql file has the entries #%PAM-1.0 auth required pam_stack.so service=system-auth account required pam_stack.so service=system-auth when i try to connect (locally).... # psql test -U brett Password: (password entered - i know it is correct) psql: FATAL: PAM authentication failed for user "brett" i get the following entries in /var/log/auth.log - and a Jan 31 16:31:47 achilles unix_chkpwd[25987]: check pass; user unknown Jan 31 16:31:47 achilles postgresql(pam_unix)[25986]: authentication failure; logname= uid=70 euid=70 tty= ruser= rhost= user=brett 'brett' has a system level account. i can connect as user 'brett' if pg_hba.conf is set to 'trust', but never when pam is involved... any ideas? i've been mucking around with this for a couple of days & not getting very far regards, brett From tfrank@registrar.uoguelph.ca Sat Feb 1 17:17:36 2003 X-Original-To: pgsql-admin@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C4DCD474E5C for ; Sat, 1 Feb 2003 12:17:36 -0500 (EST) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id 55CA5474E53 for ; Sat, 1 Feb 2003 12:17:36 -0500 (EST) Received: by news.hub.org (Postfix, from userid 8) id 4250943A915; Sat, 1 Feb 2003 12:17:36 -0500 (EST) From: Tim Frank X-Newsgroups: comp.databases.postgresql.admin Subject: Re: PAM authentication Date: Sat, 01 Feb 2003 12:18:14 -0500 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 74 Message-ID: <3E3C0156.2060903@registrar.uoguelph.ca> References: <001301c2c8f0$2c54b3d0$0101a8c0@AMD1200> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org Cc: brettn@bigpond.com User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.2.1) Gecko/20021130 X-Accept-Language: en-us, en In-Reply-To: <001301c2c8f0$2c54b3d0$0101a8c0@AMD1200> To: pgsql-admin@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/7 X-Sequence-Number: 7205 Brett, There was a PAM thread back in early December where we discussed this. I posted a bunch of PAM testing combinations that did/didn't work. One of which was trying to use system accounts through "system-auth" which is really pam_unix.so. This method would not work for me in 7.3.1 no matter what I tried. I also never found a solution. Google has the full thread here http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=asqqr7%242mqo%241%40news.hub.org&rnum=1&prev=/groups%3Fq%3DPostgresql%2BPAM%2BTim%2BFrank%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3Dasqqr7%25242mqo%25241%2540news.hub.org%26rnum%3D1 I had a look through some of the authentication source as well, but I didn't know enough about it to figure out what the problem might be specifically with pam_unix.so. Probably not what you wanted to hear, but you aren't the only one. Tim Brett Northcott wrote: > ok - fairly new to postgresql & tring to set up tcp/ip access using pam > authentication > using gentoo_linux 1.4_rc2 > postgresql-7.3.1 > > > my pg_hba.conf file has the entries > > # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD > > local all all trust > host all all 127.0.0.1 255.255.255.255 trust > host all all 192.168.1.1 255.255.255.0 pam > postgresql > > > my /etc/pam.d/postgresql file has the entries > > #%PAM-1.0 > > auth required pam_stack.so service=system-auth > account required pam_stack.so service=system-auth > > > when i try to connect (locally).... > # psql test -U brett > Password: (password entered - i know it is correct) > psql: FATAL: PAM authentication failed for user "brett" > > > i get the following entries in /var/log/auth.log - and a > Jan 31 16:31:47 achilles unix_chkpwd[25987]: check pass; user unknown > Jan 31 16:31:47 achilles postgresql(pam_unix)[25986]: authentication > failure; logname= uid=70 euid=70 tty= ruser= rhost= user=brett > > 'brett' has a system level account. > i can connect as user 'brett' if pg_hba.conf is set to 'trust', but never > when pam is involved... > > any ideas? i've been mucking around with this for a couple of days & not > getting very far > > regards, > > brett > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) From gustavo-bartz@dextra.com.br Tue Apr 19 13:41:29 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7487053453 for ; Tue, 19 Apr 2005 10:41:29 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 80992-05 for ; Tue, 19 Apr 2005 13:41:25 +0000 (GMT) Received: from hm13.locaweb.com.br (hm13.locaweb.com.br [200.246.179.113]) by svr1.postgresql.org (Postfix) with SMTP id B1F6453444 for ; Tue, 19 Apr 2005 10:41:23 -0300 (ADT) Received: (qmail 20755 invoked from network); 19 Apr 2005 13:37:48 -0000 Received: from hm28.locaweb.com.br (200.246.179.93) by hm13.locaweb.com.br with QMTP; 19 Apr 2005 13:37:48 -0000 Received: (qmail 4327 invoked from network); 19 Apr 2005 13:41:23 -0000 Received: from unknown (HELO ?172.16.129.131?) (gustavo@dextra.com.br@200.171.95.238) by hm28.locaweb.com.br with SMTP; 19 Apr 2005 13:41:23 -0000 Message-ID: <42650A5D.5000304@dextra.com.br> Date: Tue, 19 Apr 2005 10:40:45 -0300 From: Dextra - Gustavo Bartz Guedes User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: PAM authentication Content-Type: multipart/alternative; boundary="------------080503010402070605050808" X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200504/259 X-Sequence-Number: 17272 This is a multi-part message in MIME format. --------------080503010402070605050808 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hi folks, I configured the PAM authentication via pam_ldap.so, the authentication works fine, but I get a lot of erros messagens in log such as: *pam_authenticate failed: Conversation error *Can anyone help me? Thanks. --------------080503010402070605050808 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hi folks,
I configured the PAM authentication via pam_ldap.so, the authentication works fine, but I get a lot of erros messagens in log such as:

pam_authenticate failed: Conversation error

Can anyone help me?

Thanks.
--------------080503010402070605050808--