X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/blobdiff_plain/ea998f5e95432b8fba567f64f0889853009e67c6..646eea805f8862d2dc350b66c0ef4f97a5eb7f47:/gen/dhcp.pc diff --git a/gen/dhcp.pc b/gen/dhcp.pc index 31c49cc1..19de4a3a 100644 --- a/gen/dhcp.pc +++ b/gen/dhcp.pc @@ -70,13 +70,15 @@ int main(int argc, char **argv) /* Get print spoolers for allow lists. */ EXEC SQL SELECT COUNT(service) INTO :alcount FROM serverhosts sh, machine m - WHERE sh.service = 'PRINT' AND sh.mach_id = m.mach_id + WHERE (sh.service = 'PRINT' OR sh.service = 'CUPS-PRINT') + AND sh.mach_id = m.mach_id AND m.status = 1 AND m.address != 'unassigned'; allowlist = malloc(alcount * sizeof(*allowlist)); EXEC SQL DECLARE csr_spool CURSOR FOR SELECT m.address, sh.value3 FROM machine m, serverhosts sh - WHERE m.mach_id = sh.mach_id AND sh.service = 'PRINT' + WHERE m.mach_id = sh.mach_id AND + (sh.service = 'PRINT' OR sh.service = 'CUPS-PRINT') AND m.status = 1 AND m.address != 'unassigned'; EXEC SQL OPEN csr_spool; for (i = 0; i < alcount; i++)