sample/complex/libnss-mysql.cfg

   1 getpwnam    SELECT LOWER(services.username),'x',uid,gid, \
   2                    CONCAT_WS(' ',first_name,middle_initial,last_name), \
   3                    service_defs.homedir,service_defs.shell \
   4             FROM services \
   5             LEFT JOIN customer USING(cust_num) \
   6             LEFT JOIN service_defs ON services.product=service_defs.name \
   7             WHERE services.username='%1$s' AND \
   8                   expire > CURDATE() AND \
   9                   suspended='N' \
  10             LIMIT 1
  11 getpwuid    SELECT LOWER(services.username),'x',uid,gid, \
  12                    CONCAT_WS(" ",first_name,middle_initial,last_name), \
  13                    service_defs.homedir,service_defs.shell \
  14             FROM services \
  15             LEFT JOIN customer USING(cust_num) \
  16             LEFT JOIN service_defs ON services.product=service_defs.name \
  17             WHERE services.uid='%1$u' AND \
  18                   expire > CURDATE() AND \
  19                   suspended='N' \
  20             LIMIT 1
  21 getspnam    SELECT LOWER(username),password,1,0,99999,0,0,-1,0 \
  22             FROM services \
  23             WHERE username='%1$s' AND \
  24                   expire > CURDATE() AND \
  25                   suspended='N' \
  26             LIMIT 1
  27 getpwent    SELECT LOWER(services.username),'x',uid,gid, \
  28             CONCAT_WS(" ",first_name,middle_initial,last_name), \
  29             service_defs.homedir,service_defs.shell \
  30             FROM services \
  31             LEFT JOIN customer USING(cust_num) \
  32             LEFT JOIN service_defs ON services.product=service_defs.name \
  33             WHERE expire > CURDATE() AND \
  34                   suspended='N'
  35 getspent    SELECT LOWER(username),password,1,0,99999,0,0,-1,0 \
  36             FROM services \
  37             WHERE expire > CURDATE() AND \
  38                   suspended='N'
  39
  40 host        localhost
  41 database    auth
  42 username    nss-user
  43 password    userpass
  44