1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
|
getpwnam SELECT username,'*',uid,gid,pwchange,class,gecos,homedir,shell, \
expire \
FROM users \
WHERE username='%1$s' \
LIMIT 1
getpwuid SELECT username,'*',uid,gid,pwchange,class,gecos,homedir,shell, \
expire \
FROM users \
WHERE uid='%1$u' \
LIMIT 1
getpwent SELECT username,'*',uid,gid,pwchange,class,gecos,homedir,shell, \
expire \
FROM users
getgrnam SELECT name,password,gid \
FROM groups \
WHERE name='%1$s' \
LIMIT 1
getgrgid SELECT name,password,gid \
FROM groups \
WHERE gid='%1$u' \
LIMIT 1
getgrent SELECT name,password,gid \
FROM groups
memsbygid SELECT username \
FROM grouplist \
WHERE gid='%1$u'
gidsbymem SELECT gid \
FROM grouplist \
WHERE username='%1$s'
host localhost
database auth
username nss-user
password userpass
#socket /var/lib/mysql/mysql.sock
#port 3306
|