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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 1 | next ›
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedSep 8, '07 at 1:06a
activeSep 8, '07 at 1:06a
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Yanot panara: 1 post

People

Translate

site design / logo © 2022 Grokbase