Need help configuring PAM - Mailing list pgsql-novice

From yanot panara
Subject Need help configuring PAM
Date
Msg-id 1c0afa540709071805k5d574e6eof6f46735dcac4b31@mail.gmail.com
Whole thread Raw
List pgsql-novice
Hi,

I wanted to use user accounts in my PostgreSql database for system authentication.

I have installed the following:
Fedora Core 6
Postgresql 8.2.4
pam-pgsql-0.6.3(found  at  http://sourceforge.net/projects/pam-pgsql/ )

Table for the accounts from my database.

test=# select * from account;
 user_id | user_name | first_name | last_name | user_pass | account_type
---------+-----------+------------+-----------+-----------+--------------
      1 | admin     | admin      | admin     | admin     | admin


I tried the following configuration.

/etc/pam.d/gdm
auth      include      system-auth
auth        required    pam_pgsql.so
account     required    pam_pgsql.so
password    required    pam_pgsql.so

/etc/pam_pgsql.conf
database = test
host = 10.10.30.247
port = 5432
user = postgres
table = account
user_column = user_name
pwd_column = user_pass
debug

Which resulted to a prompt saying authentication failed.

I then tried the following.

/etc/pam.d/gdm
auth        required    pam_pgsql.so
account     required    pam_pgsql.so
password    required    pam_pgsql.so

/etc/pam_pgsql.conf
database = test
host = 10.10.30.247
port = 5432
user = postgres
table = account
user_column = user_name
pwd_column = user_pass
debug

Which resulted to a lockdown or me not being able to login even with the system account,i managed to fix the lockdown problem but I am still unable to come up with  a solution for my configuration to work.Hopefully somebody can help me.

Thanks,
kris




pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: performance issues and default settings
Next
From: "Jason Tan Boon Teck"
Date:
Subject: pg_restore and pgadmin3