Notepad:Postfix - Revision history

Lax: /* Configure Postfix */

2015-04-27T18:26:38Z

Configure Postfix

← Older revision		Revision as of 18:26, 27 April 2015
Line 118:		Line 118:
	postconf -e 'virtual_maildir_limit_message = "The user you are trying to reach is over quota."'		postconf -e 'virtual_maildir_limit_message = "The user you are trying to reach is over quota."'
	postconf -e 'virtual_overquota_bounce = yes'		postconf -e 'virtual_overquota_bounce = yes'
	postconf -e 'proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks $virtual_mailbox_limit_maps'		postconf -e 'proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains \
			$virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps \
			$sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks $virtual_mailbox_limit_maps'

Lax: /* Configure Postfix */

2015-04-27T18:26:07Z

Configure Postfix

← Older revision		Revision as of 18:26, 27 April 2015
Line 94:		Line 94:

	= Configure Postfix =		= Configure Postfix =

			postconf -e 'myhostname = server1.example.com'
			postconf -e 'mydestination = server1.example.com, localhost, localhost.localdomain'
			postconf -e 'mynetworks = 127.0.0.0/8'
			postconf -e 'virtual_alias_domains ='
			postconf -e 'virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf'
			postconf -e 'virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf'
			postconf -e 'virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf'
			postconf -e 'virtual_mailbox_base = /home/vmail'
			postconf -e 'virtual_uid_maps = static:5000'
			postconf -e 'virtual_gid_maps = static:5000'
			postconf -e 'smtpd_sasl_auth_enable = yes'
			postconf -e 'broken_sasl_auth_clients = yes'
			postconf -e 'smtpd_sasl_authenticated_header = yes'
			postconf -e 'smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination'
			postconf -e 'smtpd_use_tls = yes'
			postconf -e 'smtpd_tls_cert_file = /etc/postfix/smtpd.cert'
			postconf -e 'smtpd_tls_key_file = /etc/postfix/smtpd.key'
			postconf -e 'transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf'
			postconf -e 'virtual_maildir_extended = yes'
			postconf -e 'virtual_mailbox_limit_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailbox_limit_maps.cf'
			postconf -e 'virtual_mailbox_limit_override = yes'
			postconf -e 'virtual_maildir_limit_message = "The user you are trying to reach is over quota."'
			postconf -e 'virtual_overquota_bounce = yes'
			postconf -e 'proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks $virtual_mailbox_limit_maps'

Lax at 18:25, 27 April 2015

2015-04-27T18:25:10Z

← Older revision		Revision as of 18:25, 27 April 2015
Line 92:		Line 92:
	groupadd -g 5000 vmail		groupadd -g 5000 vmail
	useradd -g vmail -u 5000 vmail -d /home/vmail -m		useradd -g vmail -u 5000 vmail -d /home/vmail -m

			= Configure Postfix =

Lax at 18:17, 27 April 2015

2015-04-27T18:17:21Z

← Older revision		Revision as of 18:17, 27 April 2015
Line 1:		Line 1:
	From [https://www.howtoforge.com/virtual-users-and-domains-with-postfix-courier-mysql-and-squirrelmail-ubuntu-12.10 \| Postfix and MySQL]		From [https://www.howtoforge.com/virtual-users-and-domains-with-postfix-courier-mysql-and-squirrelmail-ubuntu-12.10 Postfix and MySQL]
	= MySQL Postfix =		= MySQL Postfix =

Lax at 18:16, 27 April 2015

2015-04-27T18:16:56Z

← Older revision		Revision as of 18:16, 27 April 2015
Line 1:		Line 1:
	From [https://www.howtoforge.com/virtual-users-and-domains-with-postfix-courier-mysql-and-squirrelmail-ubuntu-12.10 Postfix and MySQL]		From [https://www.howtoforge.com/virtual-users-and-domains-with-postfix-courier-mysql-and-squirrelmail-ubuntu-12.10 \| Postfix and MySQL]
	= MySQL Postfix =		= MySQL Postfix =

Lax at 18:16, 27 April 2015

2015-04-27T18:16:27Z

← Older revision		Revision as of 18:16, 27 April 2015
Line 1:		Line 1:
			From [https://www.howtoforge.com/virtual-users-and-domains-with-postfix-courier-mysql-and-squirrelmail-ubuntu-12.10 Postfix and MySQL]
	= MySQL Postfix =		= MySQL Postfix =

Lax: /* Config Files */

2015-04-27T18:15:02Z

Config Files

← Older revision		Revision as of 18:15, 27 April 2015
Line 34:		Line 34:

	= Config Files =		= Config Files =
	vi /etc/postfix/mysql-virtual_domains.cf		* /etc/postfix/mysql-virtual_domains.cf

	user = mail_admin		user = mail_admin
Line 42:		Line 42:
	hosts = 127.0.0.1		hosts = 127.0.0.1

	vi /etc/postfix/mysql-virtual_forwardings.cf		* /etc/postfix/mysql-virtual_forwardings.cf

	user = mail_admin		user = mail_admin
Line 50:		Line 50:
	hosts = 127.0.0.1		hosts = 127.0.0.1

	vi /etc/postfix/mysql-virtual_mailboxes.cf		* /etc/postfix/mysql-virtual_mailboxes.cf

	user = mail_admin		user = mail_admin
Line 58:		Line 58:
	hosts = 127.0.0.1		hosts = 127.0.0.1

	vi /etc/postfix/mysql-virtual_email2email.cf		* /etc/postfix/mysql-virtual_email2email.cf

	user = mail_admin		user = mail_admin
Line 66:		Line 66:
	hosts = 127.0.0.1		hosts = 127.0.0.1

	vi /etc/postfix/mysql-virtual_transports.cf		* /etc/postfix/mysql-virtual_transports.cf

	user = mail_admin		user = mail_admin
Line 74:		Line 74:
	hosts = 127.0.0.1		hosts = 127.0.0.1

	vi /etc/postfix/mysql-virtual_mailbox_limit_maps.cf		* /etc/postfix/mysql-virtual_mailbox_limit_maps.cf

	user = mail_admin		user = mail_admin

Lax at 18:14, 27 April 2015

2015-04-27T18:14:11Z

@@ Line 1: / Line 1: @@
-In mysql
+= MySQL Postfix =
   GRANT SELECT, INSERT, UPDATE, DELETE ON mail.* TO 'mail_admin'@'localhost' IDENTIFIED BY 'mail_admin_password';
@@ Line 32: / Line 32: @@
   UNIQUE KEY domain (domain)
   ) ENGINE=MyISAM;

Lax: Created page with "In mysql GRANT SELECT, INSERT, UPDATE, DELETE ON mail.* TO 'mail_admin'@'localhost' IDENTIFIED BY 'mail_admin_password'; GRANT SELECT, INSERT, UPDATE, DELETE ON mail.* TO '..."

2015-04-27T18:09:08Z

Created page with "In mysql GRANT SELECT, INSERT, UPDATE, DELETE ON mail.* TO 'mail_admin'@'localhost' IDENTIFIED BY 'mail_admin_password'; GRANT SELECT, INSERT, UPDATE, DELETE ON mail.* TO '..."

New page

In mysql

GRANT SELECT, INSERT, UPDATE, DELETE ON mail.* TO 'mail_admin'@'localhost' IDENTIFIED BY 'mail_admin_password';
GRANT SELECT, INSERT, UPDATE, DELETE ON mail.* TO 'mail_admin'@'localhost.localdomain' IDENTIFIED BY 'mail_admin_password';
FLUSH PRIVILEGES;

Still on the MySQL shell, we create the tables needed by Postfix and Courier:

USE mail;

CREATE TABLE domains (
domain varchar(50) NOT NULL,
PRIMARY KEY (domain) )
ENGINE=MyISAM;

CREATE TABLE forwardings (
source varchar(80) NOT NULL,
destination TEXT NOT NULL,
PRIMARY KEY (source) )
ENGINE=MyISAM;

CREATE TABLE users (
email varchar(80) NOT NULL,
password varchar(20) NOT NULL,
quota INT(10) DEFAULT '10485760',
PRIMARY KEY (email)
) ENGINE=MyISAM;

CREATE TABLE transport (
domain varchar(128) NOT NULL default '',
transport varchar(128) NOT NULL default '',
UNIQUE KEY domain (domain)
) ENGINE=MyISAM;