Обсуждение: Need help configuring PAM
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
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