pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPAM authentication
7+ messages / 6 participants
[nested] [flat]
* PAM authentication
@ 2000-02-01 21:42 Trever Adams <trever_Adams@bigfoot.com>
0 siblings, 0 replies; 7+ messages in thread
From: Trever Adams @ 2000-02-01 21:42 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* PAM Authentication
@ 2002-05-09 17:59 Marcelo Henrique da Silva <marcelo.silva@infocom.com.br>
0 siblings, 0 replies; 7+ messages in thread
From: Marcelo Henrique da Silva @ 2002-05-09 17:59 UTC (permalink / raw)
To: pgsql-admin
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, please tell me what!
local pam postgresql
host all 10.10.10.1 255.255.255.0 pam postgresql
Marcelo Henrique da Silva
Infocom Network Services
Brazil
^ permalink raw reply [nested|flat] 7+ messages in thread
* PAM authentication
@ 2002-08-23 15:00 Sub Director Sistemas Informaticos <ecaillava@interlap.com.ar>
0 siblings, 0 replies; 7+ messages in thread
From: Sub Director Sistemas Informaticos @ 2002-08-23 15:00 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* PAM authentication
@ 2002-08-23 15:27 Sub Director Sistemas Informaticos <ecaillava@interlap.com.ar>
0 siblings, 0 replies; 7+ messages in thread
From: Sub Director Sistemas Informaticos @ 2002-08-23 15:27 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* PAM authentication
@ 2003-01-31 06:15 Brett Northcott <brettn@bigpond.com>
0 siblings, 1 reply; 7+ messages in thread
From: Brett Northcott @ 2003-01-31 06:15 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: PAM authentication
@ 2003-02-01 17:18 Tim Frank <tfrank@registrar.uoguelph.ca>
parent: Brett Northcott <brettn@bigpond.com>
0 siblings, 0 replies; 7+ messages in thread
From: Tim Frank @ 2003-02-01 17:18 UTC (permalink / raw)
To: pgsql-admin; +Cc: brettn@bigpond.com
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...
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)
^ permalink raw reply [nested|flat] 7+ messages in thread
* PAM authentication
@ 2005-04-19 13:40 Dextra - Gustavo Bartz Guedes <gustavo-bartz@dextra.com.br>
0 siblings, 0 replies; 7+ messages in thread
From: Dextra - Gustavo Bartz Guedes @ 2005-04-19 13:40 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2005-04-19 13:40 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-02-01 21:42 PAM authentication Trever Adams <trever_Adams@bigfoot.com>
2002-05-09 17:59 PAM Authentication Marcelo Henrique da Silva <marcelo.silva@infocom.com.br>
2002-08-23 15:00 PAM authentication Sub Director Sistemas Informaticos <ecaillava@interlap.com.ar>
2002-08-23 15:27 PAM authentication Sub Director Sistemas Informaticos <ecaillava@interlap.com.ar>
2003-01-31 06:15 PAM authentication Brett Northcott <brettn@bigpond.com>
2003-02-01 17:18 ` Tim Frank <tfrank@registrar.uoguelph.ca>
2005-04-19 13:40 PAM authentication Dextra - Gustavo Bartz Guedes <gustavo-bartz@dextra.com.br>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox