diff options
author | V3n3RiX <venerix@redcorelinux.org> | 2017-10-09 18:53:29 +0100 |
---|---|---|
committer | V3n3RiX <venerix@redcorelinux.org> | 2017-10-09 18:53:29 +0100 |
commit | 4f2d7949f03e1c198bc888f2d05f421d35c57e21 (patch) | |
tree | ba5f07bf3f9d22d82e54a462313f5d244036c768 /mail-filter/gld/files |
reinit the tree, so we can have metadata
Diffstat (limited to 'mail-filter/gld/files')
-rw-r--r-- | mail-filter/gld/files/gld.rc | 22 | ||||
-rw-r--r-- | mail-filter/gld/files/tables.sql | 15 |
2 files changed, 37 insertions, 0 deletions
diff --git a/mail-filter/gld/files/gld.rc b/mail-filter/gld/files/gld.rc new file mode 100644 index 000000000000..7df142e1433d --- /dev/null +++ b/mail-filter/gld/files/gld.rc @@ -0,0 +1,22 @@ +#!/sbin/openrc-run +# Copyright 1999-2004 Gentoo Foundation +# Distributed under the terms of the GNU General Public License v2 + +depend() { + need net # in case mysql daemon is not local + use dns mysql postgresql + before postfix + provide postfix_greylist +} + +start() { + ebegin "Starting gld" + start-stop-daemon --start --quiet --exec /usr/bin/gld + eend $? +} + +stop() { + ebegin "Stopping gld" + start-stop-daemon --stop --quiet --name gld + eend $? +} diff --git a/mail-filter/gld/files/tables.sql b/mail-filter/gld/files/tables.sql new file mode 100644 index 000000000000..245e9a059e36 --- /dev/null +++ b/mail-filter/gld/files/tables.sql @@ -0,0 +1,15 @@ +CREATE TABLE `greylist` ( + `ip` CHAR( 39 ) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'IP of Sending Host', + `sender` CHAR( 242 ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Address of Sender', + `recipient` CHAR( 242 ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Address of Recipient', + `first` INT( 11 ) NOT NULL DEFAULT '0' COMMENT 'Date, when this Sender has first been seen', + `last` INT( 11 ) NOT NULL DEFAULT '0' COMMENT 'Date, when this sender has last been seen', + `n` INT( 11 ) NOT NULL DEFAULT '0' COMMENT 'Sequence number', + PRIMARY KEY ( `ip` , `sender` , `recipient` ) +) ENGINE = MYISAM CHARACTER SET latin1 COLLATE latin1_general_ci COMMENT = 'GLD Greylist Table'; + +CREATE TABLE `whitelist` ( + `mail` CHAR( 242 ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Adress which is whitelisted', + `comment` CHAR( 242 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'A comment, about why this adress is whitelisted', + PRIMARY KEY ( `mail` ) +) ENGINE = MYISAM CHARACTER SET latin1 COLLATE latin1_general_ci COMMENT = 'GLD Whitelist Table'; |