Did you add he node and then adjust the rules ? -- Jeremy McSpadden Flux Labs | http://www.fluxlabs.net<http://www.fluxlabs.net/> | Endless Solutions Office : 850-250-5590x501<tel:850-250-5590;501> | Cell : 850-890-2543<tel:850-890-2543> | Fax : 850-254-2955<tel:850-254-2955>
On Nov 7, 2014, at 8:41 AM, ManicD <[email protected]<mailto:[email protected]>> wrote: OK, from what i'm seeing the spamactions and the highspamactions rules are still not loading. I have checked the postgresql through navicat and seen the views that are setup to list the rules in the database are not correctly outputting the list of rules, in fact only the default rules are listed. I dont actually understand the SQL statement that creates the view. Its this one ========== baruwa/config/sql/integration.sql ========== SELECT row_number, oldtable.*, character(50) 'spamactions' AS name FROM (SELECT ARRAY_TO_STRING(ARRAY['To: ', name, ' ', CASE WHEN spam_actions=1 THEN 'deliver' WHEN spam_actions=3 THEN 'delete' END], ' ') ruleset from maildomains WHERE status='t' AND spam_actions != 2 UNION ALL SELECT ARRAY_TO_STRING(ARRAY['FromOrTo:', 'default', 'store'], ' ')) AS oldtable CROSS JOIN (SELECT ARRAY(SELECT ARRAY_TO_STRING(ARRAY['To:', name, ' ', CASE WHEN spam_actions=1 THEN 'deliver' WHEN spam_actions=3 THEN 'delete' END], ' ') ruleset from maildomains WHERE status='t' AND spam_actions != 2 UNION ALL SELECT ARRAY_TO_STRING(ARRAY['FromOrTo:', 'default', 'store'], ' ')) AS id) AS oldids CROSS JOIN generate_series(1, (SELECT COUNT(*) FROM (SELECT id FROM maildomains WHERE status='t' AND spam_actions != 2 UNION ALL SELECT 1) AS td)) AS row_number WHERE oldids.id[row_number] = oldtable.ruleset ORDER BY row_number; ========= and the output is a single row with the default rule in it. The same occurs with the high spam actions. Anyone with any ideas? -- View this message in context: http://baruwa-users-list.963389.n3.nabble.com/Issues-with-low-spam-delivery-tp4027481p4027522.html Sent from the Baruwa users list mailing list archive at Nabble.com<http://Nabble.com>. _______________________________________________ http://pledgie.com/campaigns/12056
_______________________________________________ http://pledgie.com/campaigns/12056
