Pastebin

Paste #8158: libnss-pgsql2 nss-pgsql.conf

< previous paste - next paste>

Pasted by userdb

Download View as text

connectionstring = host=localhost dbname=sohosting user=sohostingnss password=************** connect_timeout=300

getgroupmembersbygid = SELECT username FROM backupuser WHERE unix_gid = $1 AND enabled

getpwnam = SELECT username, 'x', unix_gecos, unix_homedir, unix_shell, unix_uid, unix_gid FROM backupuser WHERE username = $1 AND enabled

getpwuid = SELECT username, 'x', unix_gecos, unix_homedir, unix_shell, unix_uid, unix_gid FROM backupuser WHERE unix_uid = $1 AND enabled

allusers = SELECT username, 'x', unix_gecos, unix_homedir, unix_shell, unix_uid, unix_gid FROM backupuser WHERE enabled

getgrnam = SELECT unix_groupname, 'x', unix_gid, '' AS members FROM backupuser WHERE unix_groupname = $1 AND enabled

getgrgid = SELECT unix_groupname, 'x', unix_gid, '' AS members FROM backupuser WHERE unix_gid = $1 AND enabled

groups_dyn = SELECT unix_gid FROM backupuser WHERE username = $1 AND unix_gid <> $2 AND enabled
allgroups = SELECT unix_groupname, 'x', unix_gid, '' AS members FROM backupuser t1 WHERE enabled

New Paste


Do not write anything in this field if you're a human.

Go to most recent paste.