sample/minimal/libnss-mysql.cfg

   1 getpwnam    SELECT username,'x',uid,'5000','MySQL User', \
   2                    CONCAT('/home/',username),'/bin/bash' \
   3             FROM users \
   4             WHERE username='%1$s' \
   5             LIMIT 1
   6 getpwuid    SELECT username,'x',uid,'5000','MySQL User', \
   7                    CONCAT('/home/',username),'/bin/bash' \
   8             FROM users \
   9             WHERE uid='%1$u' \
  10             LIMIT 1
  11 getspnam    SELECT username,password,'1','0','99999','0','0','-1','0' \
  12             FROM users \
  13             WHERE username='%1$s' \
  14             LIMIT 1
  15 getpwent    SELECT username,'x',uid,'5000','MySQL User', \
  16                    CONCAT('/home/',username),'/bin/bash' \
  17             FROM users
  18 getspent    SELECT username,password,'1','0','99999','0','0','-1','0' \
  19             FROM users
  20 getgrnam    SELECT name,password,gid \
  21             FROM groups \
  22             WHERE name='%1$s' \
  23             LIMIT 1
  24 getgrgid    SELECT name,password,gid \
  25             FROM groups \
  26             WHERE gid='%1$u' \
  27             LIMIT 1
  28 getgrent    SELECT name,password,gid \
  29             FROM groups
  30 memsbygid   SELECT username \
  31             FROM grouplist \
  32             WHERE gid='%1$u'
  33 gidsbymem   SELECT gid \
  34             FROM grouplist \
  35             WHERE username='%1$s'
  36
  37 host        localhost
  38 database    auth
  39 username    nss-user
  40 password    userpass
  41