sample/freebsd/libnss-mysql.cfg

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