[Postfixadmin-devel] New feature request

[<to...@st...>]

I will be interested in a postfixadmin new feature.

I've managed whitelist and blacklist implemented in postfix into =20
smtpd_recipient_restrictions stage, like this:

smtpd_recipient_restrictions =3D
......usual stuff
=09    permit_mynetworks,
=09    permit_sasl_authenticated,
=09    reject_unauth_destination,
=09    check_helo_access proxy:mysql:/etc/postfix/mysql-hello.cf,
=09    check_sender_access proxy:mysql:/etc/postfix/mysql-sender.cf,
=09    check_client_access proxy:mysql:/etc/postfix/mysql-client.cf,
=09    reject_rbl_client list.dsbl.org,
=09    reject_rbl_client zen.spamhaus.org,
=09    reject_rbl_client relays.mail-abuse.org,
=09    check_policy_service inet:127.0.0.1:12525,
=09    permit

This is allowed to whitelist client from rbl checks later, or =20
radically blacklist client or mailfrom based on enveloppe sender.

the mysql-hello table prohibit use of our domain in helo command from =20
the outside (unless clients are authenticated)

I will need a user friendly interface to manage these lists.
Many people manage kind of list and i think it will be a nice addons to PA.

For helo checking,  that entry should be dependant from domain table. =20
(a new domain should add also an entry to postfix_hello table)

I know that it's a lot to ask, so if you think that feature is not =20
interesting in PA future, no problem, and thanks to reading this mail =20
anyway !


below table structure and postfix mysql lookups:


--=20
-- Table structure for table `postfix_access`
--=20

CREATE TABLE `postfix_access` (
   `id` int(10) unsigned NOT NULL auto_increment,
   `source` varchar(128) NOT NULL default '',
   `access` varchar(128) NOT NULL default '',
   `type` enum('recipient','sender','client') NOT NULL default 'sender',
   PRIMARY KEY  (`id`)
) ENGINE=3DMyISAM  DEFAULT CHARSET=3Dlatin1 ;

-- --------------------------------------------------------

--=20
-- Table structure for table `postfix_hello`
--=20

CREATE TABLE `postfix_hello` (
   `id` int(10) unsigned NOT NULL auto_increment,
   `source` varchar(128) NOT NULL default '',
   `access` varchar(128) NOT NULL default '',
   PRIMARY KEY  (`id`)
) ENGINE=3DMyISAM  DEFAULT CHARSET=3Dlatin1 ;



/etc/postfix/mysql-sender.cf:

user =3D postfix
password =3D ****
hosts =3D localhost
dbname =3D postfix
query =3D SELECT access FROM postfix_access WHERE source=3D'%s'  AND type =
=20
=3D 'sender'


/etc/postfix/mysql-client.cf:

user =3D postfix
password =3D *****
hosts =3D localhost
dbname =3D postfix
query =3D SELECT access FROM postfix_access WHERE source=3D'%s'  AND type =
=20
=3D 'client'


/etc/postfix/mysql-hello.cf:

user =3D postfix
password =3D ****
hosts =3D localhost
dbname =3D postfix
query =3D SELECT access FROM postfix_hello WHERE source=3D'%s'







Complete setup is available at this address (in french):
http://starbridge.org/spip/spip.php?article12



Tonio