Whitelist - Revision history

Ledhed at 14:37, 3 April 2007

2007-04-03T14:37:44Z

Ledhed at 14:36, 3 April 2007

2007-04-03T14:36:58Z

Ledhed at 14:28, 3 April 2007

2007-04-03T14:28:30Z

Ledhed at 14:28, 3 April 2007

2007-04-03T14:28:02Z

Ledhed at 14:27, 3 April 2007

2007-04-03T14:27:49Z

Ledhed at 14:22, 3 April 2007

2007-04-03T14:22:28Z

Ledhed at 14:22, 3 April 2007

2007-04-03T14:22:09Z

Ledhed at 14:17, 3 April 2007

2007-04-03T14:17:53Z

Ledhed at 14:06, 3 April 2007

2007-04-03T14:06:23Z

New page

Creating an email whitelist.

Reference: http://hardware.newsforge.com/article.pl?sid=04/12/02/1728210&tid=126

== Postfix MySQL Maps ==
''' ''protected_users.cf'' '''
dbname = postfix
hosts = localhost
user = postfix
password = ********
table = protected_users
select_field = class
where_field = recipient

''' ''whitelist.cf'' '''
dbname = postfix
hosts = localhost
user = postfix
password = ********
table = whitelist
select_field = action
where_field = sender

== Main.cf ==

=== SMTPD_RECIPIENT_RESTRICTIONS ===
Edit /etc/postfix/main.cf
Add this line to the ''' ''smtpd_recipient_restrictions'' ''' section.
mysql:/etc/postfix/protected_users.cf

=== SMTPD_RESTRICTION_CLASSES ===
Create a restriction class.
Add these lines anywhere in main.cf
smtpd_restriction_classes = whitelist
whitelist = check_sender_access mysql:/etc/postfix/whitelist.cf, reject

== MySQL ==
Create the 2 tables needed by postfix.

''' '' Protected Users Table '' '''
CREATE TABLE `protected_users` (
`recipient` VARCHAR( 50 ) NOT NULL ,
`class` VARCHAR( 10 ) NOT NULL,
UNIQUE ( `recipient` )
);

''' '' Whitelist Table '' '''
CREATE TABLE `whitelist` (
`sender` VARCHAR( 50 ) NOT NULL ,
`action` VARCHAR( 2 ) NOT NULL ,
UNIQUE ( `sender` )
);

[[Category:Postfix]]

@@ Line 2: / Line 2: @@
 This is great for email accounts for young children.
-This HowTo is for archival purposes, all of this information was derived from:
+All of this information was derived from:
 [http://hardware.newsforge.com/article.pl?sid=04/12/02/1728210&tid=126 A child-safe SMTP whitelist with Postfix and MySQL]<br>
 Special Thanks to Scott Merrill for his excellent HowTo.

@@ Line 2: / Line 2: @@
 This is great for email accounts for young children.
-This HowTo is for archival purposes, all of this information was derived from Scott Merrill's<br>
+This HowTo is for archival purposes, all of this information was derived from:
 [http://hardware.newsforge.com/article.pl?sid=04/12/02/1728210&tid=126 A child-safe SMTP whitelist with Postfix and MySQL]<br>
 Special Thanks to Scott Merrill for his excellent HowTo.

@@ Line 3: / Line 3: @@
 This HowTo is for archival purposes, all of this information was derived from Scott Merrill's<br>
-[http://hardware.newsforge.com/article.pl?sid=04/12/02/1728210&tid=126 A child-safe SMTP whitelist with Postfix and MySQL]
+[http://hardware.newsforge.com/article.pl?sid=04/12/02/1728210&tid=126 A child-safe SMTP whitelist with Postfix and MySQL]<br>
 Special Thanks to Scott Merrill for his excellent HowTo.

← Older revision		Revision as of 14:27, 3 April 2007
Line 2:		Line 2:
	This is great for email accounts for young children.		This is great for email accounts for young children.

−	~~Reference:~~ http://hardware.newsforge.com/article.pl?sid=04/12/02/1728210&tid=126	+	This HowTo is for archival purposes, all of this information was derived from Scott Merrill's<br>
		+	[http://hardware.newsforge.com/article.pl?sid=04/12/02/1728210&tid=126 A child-safe SMTP whitelist with Postfix and MySQL]
		+	Special Thanks to Scott Merrill for his excellent HowTo.

← Older revision		Revision as of 14:22, 3 April 2007
Line 1:		Line 1:
−	The following information can be used to protect an email account in such a way that only messages from whitelisted (approved) senders will be accepted. This is great for email accounts for young children.	+	The following information can be used to protect an email account in such a way that only messages from whitelisted (approved) senders will be accepted.<br>
		+	This is great for email accounts for young children.

	Reference: http://hardware.newsforge.com/article.pl?sid=04/12/02/1728210&tid=126		Reference: http://hardware.newsforge.com/article.pl?sid=04/12/02/1728210&tid=126

@@ Line 8: / Line 8: @@
 == Postfix MySQL Maps ==
 ''' ''protected_users.cf'' '''
@@ Line 17: / Line 18: @@
   select_field = class
   where_field = recipient
 ''' ''whitelist.cf'' '''

@@ Line 5: / Line 5: @@
 == Postfix MySQL Maps ==
 ''' ''protected_users.cf'' '''
-  dbname = postfix
+  dbname = mail
   hosts = localhost
   user = postfix
@@ Line 16: / Line 17: @@
 ''' ''whitelist.cf'' '''
-  dbname = postfix
+  dbname = mail
   hosts = localhost
   user = postfix
@@ Line 24: / Line 25: @@
   where_field = sender
 == Main.cf ==
 === SMTPD_RECIPIENT_RESTRICTIONS ===
 Add this line to the ''' ''smtpd_recipient_restrictions'' ''' section.
   mysql:/etc/postfix/protected_users.cf
@@ Line 56: / Line 61: @@
   UNIQUE ( `sender` )
   );
 [[Category:Postfix]]