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