paris/clients/roles/desktop-precise/files/libnss-mysql.cfg

   1 getpwnam    SELECT username,'x',uid,gid,gecos,homedir,shell \
   2             FROM users \
   3             WHERE username= binary '%1$s' \
   4             LIMIT 1
   5 getpwuid    SELECT username,'x',uid,gid,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= binary '%1$s' \
  12             LIMIT 1
  13 getpwent    SELECT username,'x',uid,gid,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= binary '%1$s'
  33
  34 host       nss.bureautique.fr.auf
  35 database    auth
  36 username    nss-user
  37 password    tahiti2005
  38 timeout     3
  39 compress    0
  40