Kita lanjut dengan Contoh yang ada:
Dibawah ini kode sql untuk
- Rate limit any sender mengirim 20 email dalam waktu 60 detik, Pesan lebih dari ini akan ter deferred.
- Rate limit any sender menerima lebih dari 50 email dalam waktu 60 detik, Pesan lebih dari ini akan ter Reject
sqlite3 /opt/zimbra/data/cbpolicyd/db/cbpolicyd.sqlitedb
.import File
BEGIN TRANSACTION; INSERT INTO "policies" VALUES(6, 'Zimbra', 0, 'Zimbra QA Test Policy', 0); DELETE FROM sqlite_sequence; INSERT INTO "sqlite_sequence" VALUES('policies', 6); INSERT INTO "sqlite_sequence" VALUES('policy_members', 6); INSERT INTO "sqlite_sequence" VALUES('policy_groups', 2); INSERT INTO "sqlite_sequence" VALUES('policy_group_members', 3); INSERT INTO "sqlite_sequence" VALUES('quotas', 4); INSERT INTO "sqlite_sequence" VALUES('quotas_limits', 5); INSERT INTO "sqlite_sequence" VALUES('checkhelo_blacklist', 4); INSERT INTO "policy_members" VALUES(6, 6, 'any', 'any', , 0); INSERT INTO "quotas" VALUES(3, 6, 'Sender:user@domain','Sender:user@domain', 60, 'DEFER', 'Deferring: Too many messages from sender in last 60', , 0); INSERT INTO "quotas" VALUES(4, 6, 'Recipient:@domain', 'Recipient:@domain', 60, 'REJECT', , , 0); INSERT INTO "quotas_limits" VALUES(4, 3, 'MessageCount', 20, , 0); INSERT INTO "quotas_limits" VALUES(5, 4, 'MessageCount', 50, , 0); COMMIT;
Tidak ada komentar:
Posting Komentar