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
