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