Re: anyone knows about pam_pgsql ? - Mailing list 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=usernamepasswdcolumn=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@postgresql.org)
>

--
mag. peter pilsl

phone: +43 676 3574035
fax  : +43 676 3546512
email: pilsl@goldfisch.at
sms  : pilsl@max.mail.at

pgp-key available