Search Postgresql Archives

configuration question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,
Im trying to setup my postgresql database for user authentication.

I have managed to install the libnss-pgsql module with the help of the following links below.
http://archives.postgresql.org/pgsql-general/2001-12/msg00760.php
http://archives.postgresql.org/pgsql-general/2001-12/msg00761.php

Im following the configuration steps from the link below (i had to translate it though)
http://www.claudineimatos.com/200703/autenticacao-centralizada-com-postgres-nss-e-pam/

my database shema can be found here - http://rafb.net/p/3CcM8G49.html

/etc/nss-pgsql.conf
connectionstring = hostaddr=localhost dbname=db user=db_nss password=xxx connect_timeout=1
getgroupmembersbyid = SELECT user_name FROM users WHERE gid = $1
getpwnam = SELECT user_name, passwd, 'desc' AS gecos, homedir, shell, uid, gid FROM users WHERE user_name=$1
getpwuid = SELECT user_name, passwd, 'desc' AS gecos, homedir, shell, uid, gid FROM users WHERE uid=$1
allusers = SELECT user_name, passwd, 'desc' AS gecos, homedir, shell, uid, gid FROM users
getgrnam = SELECT group_name, passwd, gid FROM groups WHERE group_name=$1
getgrid = SELECT group_name, passwd, gid FROM groups WHERE gid=$1
allgroups = SELECT group_name, passwd, gid FROM groups
groups_dyn = SELECT g.gid FROM users JOIN groups g USING (uid) where user_name = $1 and g.gid <>$2
getgroupmembersbygid = SELECT user_name FROM users JOIN user_groups g USING (uid) where g.id = $1

CREATE VIEW "shadow" AS (
SELECT user_name,
s.passwd,
DATE_PART('DAYS', lastchange-'2007-01-01') AS lastchange,
min,
max,
warn,
inact,
DATE_PART('DAYS', expire-'2007-01-01') AS expire
FROM
passwrd AS s
JOIN
users USING(uid)
);

/etc/nss-pgsql-root.conf
shadowconnectionstring = hostaddr= 127.0.0.1 dbname=db user=db connect_timeout=1
shadowbyname = SELECT user_name, passwd, lastchange, min, max, warn, inact, expire, '0' FROM shadow WHERE login = $1
shadow = SELECT user_name, passwd, lastchange, min, max, warn, inact, expire, '0' FROM shadow

edited /etc/nsswitch.conf and added the lines
passwd:     files pgsql
shadow:     files pgsql
group:      files pgsql

after those changes, its said that i should test it using the command #id myers but it returned id: myers: No such user
where did i go wrong?

steps i did can be found here - http://rafb.net/p/BdSYXr74.html

thanks in advance,
kris













[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux