FROM printers pr, machine m, serverhosts sh
WHERE pr.rm = m.mach_id
AND (pr.type = 'CLUSTER' or pr.type = 'DORM') AND m.name <> :spoolhost AND
- m.mach_id = sh.mach_id AND sh.service = 'CUPS-PRINT' AND
+ m.mach_id = sh.mach_id AND (sh.service = 'CUPS-PRINT' OR sh.service = 'CUPS-CLUSTER') AND
sh.enable = 1 AND m.mach_id = sh.mach_id;
EXEC SQL OPEN csr_remote_printers;
WHERE pr.rm = m.mach_id
AND m.mach_id = sh.mach_id AND sh.enable = 1
AND (pr.type = 'DORM' or pr.type = 'CLUSTER')
- AND (sh.service = 'CUPS-PRINT' OR sh.service = 'PRINT');
+ AND (sh.service = 'CUPS-PRINT' OR sh.service = 'PRINT' OR sh.service = 'CUPS-CLUSTER');
EXEC SQL OPEN csr_duplexqs;
while (1)
{
SELECT UNIQUE rp, ka, ac, lpc_acl
FROM printers
WHERE (ac != 0 OR lpc_acl != 0) AND rm in (SELECT m.mach_id FROM machine m, serverhosts sh
- WHERE m.mach_id = sh.mach_id AND sh.service = 'CUPS-PRINT' AND sh.enable = 1);
+ WHERE m.mach_id = sh.mach_id AND (sh.service = 'CUPS-PRINT' OR sh.service = 'CUPS-CLUSTER') AND sh.enable = 1);
EXEC SQL OPEN csr_lpc;
while (1)
{
EXEC SQL DECLARE csr_hosts CURSOR FOR
SELECT m.name FROM machine m, serverhosts sh
- WHERE m.mach_id = sh.mach_id AND sh.service = 'CUPS-PRINT' AND sh.enable = 1;
+ WHERE m.mach_id = sh.mach_id AND (sh.service = 'CUPS-PRINT' OR sh.service = 'CUPS-CLUSTER')
+ AND sh.enable = 1;
EXEC SQL OPEN csr_hosts;
while (1)
{
FROM printers pr, machine m, serverhosts sh
WHERE pr.rm = m.mach_id
AND pr.type != 'ALIAS' AND m.name <> :spoolhost AND
- m.mach_id = sh.mach_id AND sh.service = 'CUPS-PRINT' AND
- sh.enable = 1 AND m.mach_id = sh.mach_id;
+ m.mach_id = sh.mach_id AND (sh.service = 'CUPS-PRINT' OR sh.service = 'CUPS-CLUSTER')
+ AND sh.enable = 1 AND m.mach_id = sh.mach_id;
EXEC SQL OPEN csr_remote_printers;
while (1)
FROM printers pr, machine m, serverhosts sh
WHERE pr.rm = m.mach_id
AND m.mach_id = sh.mach_id AND sh.enable = 1
- AND (sh.service = 'CUPS-PRINT' OR sh.service = 'PRINT');
+ AND (sh.service = 'CUPS-PRINT' OR sh.service = 'PRINT' OR sh.service = 'CUPS-CLUSTER');
EXEC SQL OPEN csr_duplexqs;
while (1)
{
SELECT UNIQUE rp, ka, ac, lpc_acl
FROM printers
WHERE (ac != 0 OR lpc_acl != 0) AND rm in (SELECT m.mach_id FROM machine m, serverhosts sh
- WHERE m.mach_id = sh.mach_id AND sh.service = 'CUPS-PRINT' AND sh.enable = 1);
+ WHERE m.mach_id = sh.mach_id AND (sh.service = 'CUPS-PRINT' OR sh.service = 'CUPS-CLUSTER')
+ AND sh.enable = 1);
EXEC SQL OPEN csr_lpc;
while (1)
{