From: zacheiss Date: Thu, 20 Nov 2008 16:30:06 +0000 (+0000) Subject: Include CUPS-PRINT servers in generated tftp config files, too. X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/commitdiff_plain/646eea805f8862d2dc350b66c0ef4f97a5eb7f47 Include CUPS-PRINT servers in generated tftp config files, too. --- diff --git a/gen/boot.pc b/gen/boot.pc index f7f12757..79f12be6 100644 --- a/gen/boot.pc +++ b/gen/boot.pc @@ -58,13 +58,14 @@ int main(int argc, char **argv) EXEC SQL WHENEVER SQLERROR DO sqlerr(); /* Get print spoolers for allow lists. */ - EXEC SQL SELECT COUNT(service) INTO :alcount FROM serverhosts - WHERE service = 'PRINT'; + EXEC SQL SELECT COUNT(service) INTO :alcount FROM serverhosts sh + WHERE sh.service = 'PRINT' or sh.service = 'CUPS-PRINT'; 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'); EXEC SQL OPEN csr_spool; for (i = 0; i < alcount; i++) { 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++)