I am running Debian woody and am trying to setup an access control database using the pam module pam_pgsql.so and PostgreSQL. I am testing the system using Apache 1.3. Basic functionality is working:

Apache PAM DSO loaded and configured
pam-pgsql working and configured
pam-pgsql called by /etc/pam.d/httpd
PostgreSQL simple user database working, configured, filled w/ test users
Apache authenticating correctly using pam-pgsql --> PostgreSQL database

My aim is:
I want to have a single user database that I can edit to give different users access to different services. I want to put a web front-end to this database where I can add/remove/edit users and grant/revoke access to different services w/ simple check boxes.

The trouble is:
Right now pam_pgsql does not support authentication by group (as far as I know) so I can't just make users in the database members of groups samba, apache or what have you. In order to have per service authentication, I would have to maintain a separate table for each service. This is clunky, and the point of this project is to consolidate everything so I don't have 20 password databases in different places with different formats that all need to be synced w/ shadow. Solliciting solutions!

Much obliged,

Johnny

I had started another thread relating to pam_pgsql access control to specific services. I mentioned that it does not support groups (although looking at the code I think any reasonable UNIX hacker could add it [i'm just a hack, not a hacker]). pam_ldap DOES support groups, however (er, I think it does anyway). The thing I don't like about LDAP is that I don't know much about how easy it is to administer an LDAP tree through a web interface. I also don't like having 5 different database systems on my machine if I can help it. I've heard it's possible to setup LDAP to use Postgres in the backend but that it could be difficult at times. Soliciting comments or ideally an offer for someone to add groups support to pam_pgsql...

Johnny

//Moderator note: invoked merge(threads)
//Moderator note: you have crossposted a message, which is against the LQ Rules. Cross-posting is considered bad netiquette on your part, a waste of resources on LQ's part and a waste of time for LQ members who take the time your question. Please do not do that again.

FUP to: http://www.linuxquestions.org/questi...hreadid=169319