Mail Proxy > Whitelist: Error 500

T

TDS

New Member
Oct 21, 2024
5
0
1
I have two PMG instances. One is working properly, one not.
After server transfer and backup restore I can't add entries to global whitelist.

GUI:
https://domain.tld/api2/json/config/whitelist/objects => 500 Internal Server Error
The frontend displays "Connection error".

SHELL:
::> pmgsh create /config/whitelist/domain --domain "facebookmail.com"
undefined ogroup: ERROR at /usr/share/perl5/PMG/RuleDB/WhoRegex.pm line 59.

All other things are working.
Comparing to my other system, the IDs in database for objects are different.

What can be done to resolve this issue?
 
could you please share:
* the journal output when you try to add items (just let `journalctl -f` run in a shell and copy the output after the error happens)
* the pmgproxy.log (/var/log/pmgproxy/pmgproxy.log) from that timefram
* `pmgdb dump` (sanitize/anonymize what you need to keep private)
 
Stoiko Ivanov said:
could you please share:
* the journal output when you try to add items (just let `journalctl -f` run in a shell and copy the output after the error happens)
* the pmgproxy.log (/var/log/pmgproxy/pmgproxy.log) from that timefram
* `pmgdb dump` (sanitize/anonymize what you need to keep private)
Click to expand...
Hopefully here are the right outputs and answers.

Journal doesn't show log after clicking on whitelist.

Code: 
::ffff:127.0.0.1 - root@pam [21/10/2024:10:25:24 +0200] "GET /api2/json/config/mail HTTP/1.1" 200 322
::ffff:127.0.0.1 - - [21/10/2024:10:25:24 +0200] "POST /api2/json/access/ticket HTTP/1.1" 200 502
::ffff:127.0.0.1 - root@pam [21/10/2024:10:25:24 +0200] "GET /api2/json/config/whitelist/objects HTTP/1.1" 500 13
::ffff:127.0.0.1 - root@pam [21/10/2024:10:25:29 +0200] "GET /api2/json/config/mail HTTP/1.1" 200 322
::ffff:127.0.0.1 - root@pam [21/10/2024:10:25:32 +0200] "GET /api2/json/config/whitelist/objects HTTP/1.1" 500 13

Code: 
RULE 4 (prio: 98, in, ACTIVE): Blacklist
  FROM group 25 (and=0, invert=0): Blacklist
    OBJECT Mail address 41: nomail@fromthisdomain.com
  ACTION group 41: Block
    OBJECT Block 70: block message
RULE 2 (prio: 96, in, ACTIVE): Block Viruses
  WHAT group 32 (and=0, invert=0): Virus
    OBJECT Virus Filter 61: active
  ACTION group 43: Notify Admin
    OBJECT Notification 72: notify __ADMIN__
  ACTION group 42: Quarantine
    OBJECT Quarantine 71: Move to quarantine.
RULE 3 (prio: 96, out, ACTIVE): Virus Alert
  WHAT group 32 (and=0, invert=0): Virus
    OBJECT Virus Filter 61: active
  ACTION group 44: Notify Sender
    OBJECT Notification 73: notify __SENDER__
  ACTION group 43: Notify Admin
    OBJECT Notification 72: notify __ADMIN__
  ACTION group 41: Block
    OBJECT Block 70: block message
RULE 1 (prio: 93, in, ACTIVE): Block Dangerous Files
  WHAT group 31 (and=0, invert=0): Dangerous Content
    OBJECT ContentType Filter 56: content-type=application/javascript
    OBJECT ContentType Filter 57: content-type=application/x-executable
    OBJECT ContentType Filter 55: content-type=application/x-java
    OBJECT ContentType Filter 54: content-type=application/x-ms-dos-executable
    OBJECT ContentType Filter 58: content-type=message/partial
    OBJECT Match Filename 59: filename=.*\.(vbs|pif|lnk|shs|shb)
    OBJECT Match Filename 60: filename=.*\.\{.+\}
  ACTION group 38: Remove attachments
    OBJECT Remove attachments 67: remove matching attachments
RULE 5 (prio: 90, in, ACTIVE): Modify Header
  ACTION group 36: Modify Spam Level
    OBJECT Header Attribute 65: modify field: X-SPAM-LEVEL:__SPAM_INFO__
RULE 13 (prio: 89, in, inactive): Quarantine Office Files
  WHAT group 30 (and=0, invert=0): Office Files
    OBJECT ContentType Filter 49: content-type=application/msword
    OBJECT ContentType Filter 47: content-type=application/vnd\.ms-excel
    OBJECT ContentType Filter 48: content-type=application/vnd\.ms-powerpoint
    OBJECT ContentType Filter 51: content-type=application/vnd\.oasis\.opendocument\..*
    OBJECT ContentType Filter 50: content-type=application/vnd\.openxmlformats-officedocument\..*
    OBJECT ContentType Filter 52: content-type=application/vnd\.stardivision\..*
    OBJECT ContentType Filter 53: content-type=application/vnd\.sun\.xml\..*
  ACTION group 46: Attachment Quarantine (remove matching)
    OBJECT Remove attachments 75: remove matching attachments
RULE 12 (prio: 87, in+out, inactive): Block Multimedia Files
  WHAT group 29 (and=0, invert=0): Multimedia
    OBJECT ContentType Filter 45: content-type=audio/.*
    OBJECT ContentType Filter 46: content-type=video/.*
  ACTION group 38: Remove attachments
    OBJECT Remove attachments 67: remove matching attachments
RULE 6 (prio: 85, in, ACTIVE): Whitelist
  FROM group 26 (and=0, invert=0): Whitelist
    OBJECT Mail address 42: mail@fromthisdomain.com
  ACTION group 40: Accept
    OBJECT Accept 69: accept message
RULE 9 (prio: 82, in, inactive): Block Spam (Level 10)
  WHAT group 35 (and=0, invert=0): Spam (Level 10)
    OBJECT Spam Filter 64: Level 10
  ACTION group 41: Block
    OBJECT Block 70: block message
RULE 8 (prio: 81, in, inactive): Quarantine/Mark Spam (Level 5)
  WHAT group 34 (and=0, invert=0): Spam (Level 5)
    OBJECT Spam Filter 63: Level 5
  ACTION group 37: Modify Spam Subject
    OBJECT Header Attribute 66: modify field: subject:SPAM: __SUBJECT__
  ACTION group 42: Quarantine
    OBJECT Quarantine 71: Move to quarantine.
RULE 7 (prio: 80, in, ACTIVE): Quarantine/Mark Spam (Level 3)
  WHAT group 33 (and=0, invert=0): Spam (Level 3)
    OBJECT Spam Filter 62: Level 3
  ACTION group 37: Modify Spam Subject
    OBJECT Header Attribute 66: modify field: subject:SPAM: __SUBJECT__
  ACTION group 42: Quarantine
    OBJECT Quarantine 71: Move to quarantine.
RULE 10 (prio: 70, out, ACTIVE): Block outgoing Spam
  WHAT group 34 (and=0, invert=0): Spam (Level 5)
    OBJECT Spam Filter 63: Level 5
  ACTION group 44: Notify Sender
    OBJECT Notification 73: notify __SENDER__
  ACTION group 41: Block
    OBJECT Block 70: block message
RULE 11 (prio: 60, out, inactive): Add Disclaimer
  ACTION group 45: Disclaimer
    OBJECT Disclaimer 74: disclaimer
 
TDS said:
After server transfer and backup restore I can't add entries to global whitelist.
Click to expand...
how did you do this?

TDS said:
Journal doesn't show log after clicking on whitelist.
Click to expand...
hm - strange - I'd expect pmgproxy/pgdaemon to at least wrtie the error-message in the logs
could you reboot the machine - and share the logs from the boot ?
 

Attachments

You have quite a few other processes running on this system (dovecot, bind, mysql, and ftp-server,....) - that should not be an issue - but it's a somewhat uncommon setup...

anyways - looking through the error you posted in the first link (the logs did not contain any other hint) - it seems the database restore did not work at all...

can you try restoring the backup to a fresh pmg machine and see if adding entries to the Smtp proxy whitelist works there?
do you see any errors when trying to restore the backup?
 
Stoiko Ivanov said:
You have quite a few other processes running on this system (dovecot, bind, mysql, and ftp-server,....) - that should not be an issue - but it's a somewhat uncommon setup...

anyways - looking through the error you posted in the first link (the logs did not contain any other hint) - it seems the database restore did not work at all...

can you try restoring the backup to a fresh pmg machine and see if adding entries to the Smtp proxy whitelist works there?
do you see any errors when trying to restore the backup?
Click to expand...
The setup is working on another server with same HW specs. There is also only one problem concerning the global whitelist.
Currently I'm not able to restore the backup once again because it's already deleted. Server move was a few months ago.
Is there a possibility to enable debug messages so we can the see anything in the logs what happened?
Or maybe another chance to recreate the whitelist filter entries?

The real problem is this:
Code: 
undefined ogroup: ERROR at /usr/share/perl5/PMG/RuleDB/WhoRegex.pm line 59.
 
TDS said:
The real problem is this:
Code: 
undefined ogroup: ERROR at /usr/share/perl5/PMG/RuleDB/WhoRegex.pm line 59.
Click to expand...
I agree - but this should not happen if the database restore was not completely off ...

Are the 2 systems in a cluster? (then you could consider simply setting up a fresh one and joining it.

regarding logs - no there is no additional debug-mode available ...
you can check if you find the restore task-log:
`find /var/log/pve -iname '*restore*'` - that file might have some hints
 
Finally I exported the working database from working server, stripped unneeded tables and commands and restored in buggy database.

Here is the SQL script for the configuration if anyone else is having same problem:
SQL: 
TRUNCATE TABLE public.attribut;
TRUNCATE TABLE public.object;
TRUNCATE TABLE public.objectgroup;
TRUNCATE TABLE public.objectgroup_attributes;
TRUNCATE TABLE public.rule;
TRUNCATE TABLE public.rule_attributes;
TRUNCATE TABLE public.rulegroup;

INSERT INTO public.attribut (object_id, name, value) VALUES (33, 'subject', '\x4e6f74696669636174696f6e3a205f5f5355424a4543545f5f');
INSERT INTO public.attribut (object_id, name, value) VALUES (33, 'body', '\x50726f786d6f78204e6f74696669636174696f6e3a0a0a53656e6465723a2020205f5f53454e4445525f5f0a52656365697665723a205f5f5245434549564552535f5f0a546172676574733a20205f5f544152474554535f5f0a0a5375626a6563743a205f5f5355424a4543545f5f0a0a4d61746368696e672052756c653a205f5f52554c455f5f0a0a5f5f52554c455f494e464f5f5f0a0a5f5f56495255535f494e464f5f5f0a5f5f5350414d5f494e464f5f5f0a');
INSERT INTO public.attribut (object_id, name, value) VALUES (33, 'attach', '\x4e');
INSERT INTO public.attribut (object_id, name, value) VALUES (34, 'subject', '\x4e6f74696669636174696f6e3a205f5f5355424a4543545f5f');
INSERT INTO public.attribut (object_id, name, value) VALUES (34, 'body', '\x50726f786d6f78204e6f74696669636174696f6e3a0a0a53656e6465723a2020205f5f53454e4445525f5f0a52656365697665723a205f5f5245434549564552535f5f0a546172676574733a20205f5f544152474554535f5f0a0a5375626a6563743a205f5f5355424a4543545f5f0a0a4d61746368696e672052756c653a205f5f52554c455f5f0a0a5f5f52554c455f494e464f5f5f0a0a5f5f56495255535f494e464f5f5f0a5f5f5350414d5f494e464f5f5f0a');
INSERT INTO public.attribut (object_id, name, value) VALUES (34, 'attach', '\x4e');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (1, 1001, 2, '\x6e6f6d61696c4066726f6d74686973646f6d61696e2e636f6d');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (2, 1001, 3, '\x6d61696c4066726f6d74686973646f6d61696e2e636f6d');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (3, 2000, 4, '\x30383a30302d31363a3030');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (4, 3003, 5, '\x636f6e74656e742d747970653a696d6167652f2e2a');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (5, 3003, 6, '\x636f6e74656e742d747970653a617564696f2f2e2a');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (6, 3003, 6, '\x636f6e74656e742d747970653a766964656f2f2e2a');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (7, 3003, 7, '\x636f6e74656e742d747970653a6170706c69636174696f6e2f766e645c2e6d732d657863656c');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (8, 3003, 7, '\x636f6e74656e742d747970653a6170706c69636174696f6e2f766e645c2e6d732d706f776572706f696e74');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (9, 3003, 7, '\x636f6e74656e742d747970653a6170706c69636174696f6e2f6d73776f7264');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (10, 3003, 7, '\x636f6e74656e742d747970653a6170706c69636174696f6e2f766e645c2e6f70656e786d6c666f726d6174732d6f6666696365646f63756d656e745c2e2e2a');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (11, 3003, 7, '\x636f6e74656e742d747970653a6170706c69636174696f6e2f766e645c2e6f617369735c2e6f70656e646f63756d656e745c2e2e2a');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (12, 3003, 7, '\x636f6e74656e742d747970653a6170706c69636174696f6e2f766e645c2e737461726469766973696f6e5c2e2e2a');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (13, 3003, 7, '\x636f6e74656e742d747970653a6170706c69636174696f6e2f766e645c2e73756e5c2e786d6c5c2e2e2a');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (14, 3003, 8, '\x636f6e74656e742d747970653a6170706c69636174696f6e2f782d6d732d646f732d65786563757461626c65');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (15, 3003, 8, '\x636f6e74656e742d747970653a6170706c69636174696f6e2f782d6a617661');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (16, 3003, 8, '\x636f6e74656e742d747970653a6170706c69636174696f6e2f6a617661736372697074');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (17, 3003, 8, '\x636f6e74656e742d747970653a6170706c69636174696f6e2f782d65786563757461626c65');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (18, 3003, 8, '\x636f6e74656e742d747970653a6170706c69636174696f6e2f782d6d732d646f732d65786563757461626c65');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (19, 3003, 8, '\x636f6e74656e742d747970653a6d6573736167652f7061727469616c');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (20, 3004, 8, '\x2e2a5c2e287662737c7069667c6c6e6b7c7368737c73686229');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (21, 3004, 8, '\x2e2a5c2e5c7b2e2b5c7d');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (22, 3001, 9, NULL);
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (23, 3000, 10, '\x33');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (24, 3000, 11, '\x35');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (25, 3000, 12, '\x3130');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (26, 4003, 13, '\x582d5350414d2d4c4556454c3a5f5f5350414d5f494e464f5f5f');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (27, 4003, 14, '\x7375626a6563743a5350414d3a205f5f5355424a4543545f5f');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (28, 4007, 15, '\x302c30');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (29, 4007, 16, '\x312c30');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (30, 4000, 17, NULL);
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (31, 4001, 18, NULL);
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (32, 4006, 19, NULL);
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (33, 4002, 20, '\x5f5f41444d494e5f5f');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (34, 4002, 21, '\x5f5f53454e4445525f5f');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (35, 4009, 22, '\x5468697320652d6d61696c20616e6420616e792061747461636865642066696c65732061726520636f6e666964656e7469616c20616e64206d6179206265206c6567616c6c792070726976696c656765642e20496620796f7520617265206e6f7420746865206164647265737365652c20616e7920646973636c6f737572652c20726570726f64756374696f6e2c20636f7079696e672c20646973747269627574696f6e2c206f72206f746865722064697373656d696e6174696f6e206f7220757365206f66207468697320636f6d6d756e69636174696f6e206973207374726963746c792070726f686962697465642e20496620796f7520686176652072656365697665642074686973207472616e736d697373696f6e20696e206572726f7220706c65617365206e6f74696679207468652073656e64657220696d6d6564696174656c7920616e64207468656e2064656c6574652074686973206d61696c2e3c62723e0a452d6d61696c207472616e736d697373696f6e2063616e6e6f742062652067756172616e7465656420746f20626520736563757265206f72206572726f72206672656520617320696e666f726d6174696f6e20636f756c6420626520696e7465726365707465642c20636f727275707465642c206c6f73742c2064657374726f7965642c20617272697665206c617465206f7220696e636f6d706c6574652c206f7220636f6e7461696e20766972757365732e205468652073656e646572207468657265666f726520646f6573206e6f7420616363657074206c696162696c69747920666f7220616e79206572726f7273206f72206f6d697373696f6e7320696e2074686520636f6e74656e7473206f662074686973206d657373616765207768696368206172697365206173206120726573756c74206f6620652d6d61696c207472616e736d697373696f6e206f72206368616e67657320746f207472616e736d69747465642064617465206e6f74207370656369666963616c6c7920617070726f766564206279207468652073656e6465722e3c62723e0a4966207468697320652d6d61696c206f722061747461636865642066696c657320636f6e7461696e20696e666f726d6174696f6e20776869636820646f206e6f742072656c61746520746f206f75722070726f66657373696f6e616c20616374697669747920776520646f206e6f7420616363657074206c696162696c69747920666f72207375636820696e666f726d6174696f6e2e0a');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (36, 4007, 23, '\x302c31');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (37, 4007, 24, '\x312c31');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (39, 1002, 1, '\x66616365626f6f6b6d61696c2e636f6d');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (40, 1002, 1, '\x6d61696c2e696e7374616772616d2e636f6d');
INSERT INTO public.object (id, objecttype, objectgroup_id, value) VALUES (41, 1002, 1, '\x6d61696c2d6d61696c2e66616365626f6f6b2e636f6d');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (1, 'GreyExclusion', '-', 'greylist');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (2, 'Blacklist', 'Global blacklist', 'who');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (3, 'Whitelist', 'Global whitelist', 'who');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (4, 'Office Hours', 'Usual office hours', 'when');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (5, 'Images', 'All kinds of graphic files', 'what');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (6, 'Multimedia', 'Audio and Video', 'what');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (7, 'Office Files', 'Common Office Files', 'what');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (8, 'Dangerous Content', 'executable files and partial messages', 'what');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (9, 'Virus', 'Matches virus infected mail', 'what');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (10, 'Spam (Level 3)', 'Matches possible spam mail', 'what');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (11, 'Spam (Level 5)', 'Matches possible spam mail', 'what');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (12, 'Spam (Level 10)', 'Matches possible spam mail', 'what');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (13, 'Modify Spam Level', 'Mark mail as spam by adding a header tag.', 'action');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (14, 'Modify Spam Subject', 'Mark mail as spam by modifying the subject.', 'action');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (15, 'Remove attachments', 'Remove matching attachments', 'action');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (16, 'Remove all attachments', 'Remove all attachments', 'action');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (17, 'Accept', 'Accept mail for Delivery', 'action');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (18, 'Block', 'Block mail', 'action');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (19, 'Quarantine', 'Move mail to quarantine', 'action');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (20, 'Notify Admin', 'Send notification', 'action');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (21, 'Notify Sender', 'Send notification', 'action');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (22, 'Disclaimer', 'Add Disclaimer', 'action');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (23, 'Attachment Quarantine (remove matching)', 'Remove matching attachments and move the whole mail to the attachment quarantine.', 'action');
INSERT INTO public.objectgroup (id, name, info, class) VALUES (24, 'Attachment Quarantine (remove all)', 'Remove all attachments and move the whole mail to the attachment quarantine.', 'action');
INSERT INTO public.rule (id, name, priority, active, direction, count) VALUES (1, 'Block Dangerous Files', 93, 1, 0, 0);
INSERT INTO public.rule (id, name, priority, active, direction, count) VALUES (2, 'Block Viruses', 96, 1, 0, 0);
INSERT INTO public.rule (id, name, priority, active, direction, count) VALUES (3, 'Virus Alert', 96, 1, 1, 0);
INSERT INTO public.rule (id, name, priority, active, direction, count) VALUES (4, 'Blacklist', 98, 1, 0, 0);
INSERT INTO public.rule (id, name, priority, active, direction, count) VALUES (6, 'Whitelist', 85, 1, 0, 0);
INSERT INTO public.rule (id, name, priority, active, direction, count) VALUES (8, 'Quarantine/Mark Spam (Level 5)', 81, 0, 0, 0);
INSERT INTO public.rule (id, name, priority, active, direction, count) VALUES (9, 'Block Spam (Level 10)', 82, 0, 0, 0);
INSERT INTO public.rule (id, name, priority, active, direction, count) VALUES (11, 'Add Disclaimer', 60, 0, 1, 0);
INSERT INTO public.rule (id, name, priority, active, direction, count) VALUES (12, 'Block Multimedia Files', 87, 0, 2, 0);
INSERT INTO public.rule (id, name, priority, active, direction, count) VALUES (13, 'Quarantine Office Files', 89, 0, 0, 0);
INSERT INTO public.rule (id, name, priority, active, direction, count) VALUES (10, 'Block outgoing Spam', 70, 1, 1, 596);
INSERT INTO public.rule (id, name, priority, active, direction, count) VALUES (7, 'Quarantine/Mark Spam (Level 3)', 80, 1, 0, 8825);
INSERT INTO public.rule (id, name, priority, active, direction, count) VALUES (5, 'Modify Header', 90, 1, 0, 107380);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (8, 1, 3);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (15, 1, 4);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (9, 2, 3);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (20, 2, 4);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (19, 2, 4);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (21, 3, 4);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (20, 3, 4);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (18, 3, 4);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (2, 4, 0);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (18, 4, 4);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (13, 5, 4);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (3, 6, 0);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (17, 6, 4);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (10, 7, 3);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (14, 7, 4);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (19, 7, 4);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (11, 8, 3);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (14, 8, 4);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (19, 8, 4);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (12, 9, 3);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (18, 9, 4);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (21, 10, 4);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (18, 10, 4);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (22, 11, 4);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (6, 12, 3);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (15, 12, 4);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (7, 13, 3);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (23, 13, 4);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (9, 3, 3);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (19, 3, 4);
INSERT INTO public.rulegroup (objectgroup_id, rule_id, grouptype) VALUES (11, 10, 3);
 
You must log in or register to reply here.
Top Bottom