Re: anyone knows about pam_pgsql ?

From: Peter Pilsl <pilsl(at)goldfisch(dot)at>
To: Tommi Mäkitalo <t(dot)maekitalo(at)epgmbh(dot)de>
Cc: postgres mailinglist <pgsql-general(at)postgresql(dot)org>
Subject: Re: anyone knows about pam_pgsql ?
Date: 2001-11-25 14:28:57
Message-ID: 20011125152857.C78293@i3.atat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

thnx a lot for your reply. I would like to give the nss a try, but I
dont have the slightest idea how to use it (in case I managed to
compile).

I just know how to use pam by adding a appropriate login-file to /etc/pam.d/ that contains things like:
auth required /lib/security/pam_securetty.so
auth required /lib/security/pam_stack.so service=system-auth
auth required /lib/security/pam_nologin.so
account required /lib/security/pam_stack.so service=system-auth
password required /lib/security/pam_stack.so service=system-auth
session required /lib/security/pam_stack.so service=system-auth
session optional /lib/security/pam_console.so

how would look this enty in case I'm using one of the nss-pgsql-tools ?

sorry, but I'm really 100% newbie on nss.

thnx,
peter

On Tue, Nov 20, 2001 at 04:00:41PM +0100, Tommi Mäkitalo wrote:
> Hello Peter,
>
> there is another pam-module, which might work. You can find it in
> http://sourceforge.net/projects/sysauth-pgsql. I'm not sure how good
> this work. I tried nss-pgsql version 0.9.0 from the same author and run
> into massive problems. Maybe version 1.0.0 is better. I didn't try it.
> My solution was to create my own version of nss-pgsql. If you need it,
> you can find it on my homepage http://www.maekitalo.de.
>
> Tommi
>
>
>
> Peter Pilsl wrote:
>
> >trying for days now to get documentation about this tool that would
> >allow me to authenticate users for different services via a
> >postgres-database on my linuxsystem.
> >
> >I obtained two versions: 0.03 which I cant even compile and 0.9.3
> >which I can compile but there is not a single byte docs coming with
> >it, so I tried based on two postings from googles and failed ...
> >
> >#%PAM-1.0
> >
> >auth sufficient /usr/local/lib/pam_pgsql.so user=peter passwd=xxxx host=limpio.local db=auth table=users usercolumn=username passwdcolumn=userpass crypt=1 where=status=1
> >
> >
> >the failmessage was (definitely OT here ...)
> >Nov 20 12:59:54 lupo imapd[14134]: accepted connection
> >Nov 20 12:59:58 lupo imapd[14134]: PAM unable to dlopen(/usr/local/lib/pam_pgsql.so)
> >Nov 20 12:59:58 lupo imapd[14134]: PAM [dlerror: /usr/local/lib/pam_pgsql.so: undefined symbol: sqlca]
> >Nov 20 12:59:58 lupo imapd[14134]: PAM adding faulty module: /usr/local/lib/pam_pgsql.so
> >Nov 20 13:00:01 lupo master[26807]: process 14134 exited, status 0
> >
> >thnx,
> >peter
> >
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

--
mag. peter pilsl

phone: +43 676 3574035
fax : +43 676 3546512
email: pilsl(at)goldfisch(dot)at
sms : pilsl(at)max(dot)mail(dot)at

pgp-key available

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Pilsl 2001-11-25 14:30:44 undefined reference : sqlescape
Previous Message Lee Crampton 2001-11-25 11:54:20 Re: Setting up MAKE file for Postgres and C++/Newbie question