sample/solaris/libnss-mysql.cfg

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