[2024-feb-29] Sad news: Eric Layton aka Nocturnal Slacker aka vtel57 passed away on Feb 26th, shortly after hospitalization. He was one of our Wiki's most prominent admins. He will be missed.
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
howtos:network_services:postfix_dovecot_mysql:postfix [2015/02/16 06:59 (UTC)] – astrogeek | howtos:network_services:postfix_dovecot_mysql:postfix [2018/10/08 02:14 (UTC)] (current) – [Configuring The Postfix MTA] astrogeek | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Installing The Postfix MTA ===== | + | ====== Installing The Postfix MTA ====== |
- | <note important> | + | This page is supplemental to main article: [[howtos: |
Postfix is a popular and secure mail transport agent, or MTA. | Postfix is a popular and secure mail transport agent, or MTA. | ||
Line 41: | Line 41: | ||
Copy the package file to the target platform if necessary and install: | Copy the package file to the target platform if necessary and install: | ||
< | < | ||
- | ===== Configuring The Postfix MTA ===== | + | ====== Configuring The Postfix MTA ====== |
You must become familiar with the [[http:// | You must become familiar with the [[http:// | ||
Line 87: | Line 88: | ||
relay_domains = | relay_domains = | ||
+ | # We have no local users, so no local notifications # | ||
biff = no | biff = no | ||
- | append_dot_mydomain = no | ||
</ | </ | ||
Line 99: | Line 100: | ||
# SSL certificates will be created at these locations when we configure dovecot # | # SSL certificates will be created at these locations when we configure dovecot # | ||
smtpd_tls_cert_file = / | smtpd_tls_cert_file = / | ||
- | smtpd_tls_key_file = /etc/ssl/localcerts/dove.key | + | smtpd_tls_key_file = /etc/ssl/private/dove.key |
#Accept only secure smtp connections | #Accept only secure smtp connections | ||
Line 144: | Line 145: | ||
user= mailuser | user= mailuser | ||
password = {your mailuser password} | password = {your mailuser password} | ||
- | host = localhost | + | hosts = localhost |
dbname = mailserver | dbname = mailserver | ||
query = SELECT 1 FROM virtual_domains WHERE name=' | query = SELECT 1 FROM virtual_domains WHERE name=' | ||
Line 154: | Line 155: | ||
This will return true (1) if the domain is found, NULL if not found, and an error message if the query or connection is not correctly configured. | This will return true (1) if the domain is found, NULL if not found, and an error message if the query or connection is not correctly configured. | ||
+ | |||
+ | Also note that other database connection options are available, for example if you are connecting to a remote database server, or multiple servers. See the mysql_table man page from the postfix package for complete connect parameter information. | ||
Next, we must tell postfix how to identify valid virtual mail box users. This query must also only return true if the mail box exists in the database. | Next, we must tell postfix how to identify valid virtual mail box users. This query must also only return true if the mail box exists in the database. | ||
Line 163: | Line 166: | ||
user= mailuser | user= mailuser | ||
password = {your mailuser password} | password = {your mailuser password} | ||
- | host = localhost | + | hosts = localhost |
dbname = mailserver | dbname = mailserver | ||
query = SELECT 1 FROM virtual_users WHERE email=' | query = SELECT 1 FROM virtual_users WHERE email=' | ||
Line 180: | Line 183: | ||
user= mailuser | user= mailuser | ||
password = {your mailuser password} | password = {your mailuser password} | ||
- | host = localhost | + | hosts = localhost |
dbname = mailserver | dbname = mailserver | ||
query = SELECT destination FROM virtual_aliases WHERE source=' | query = SELECT destination FROM virtual_aliases WHERE source=' | ||
Line 199: | Line 202: | ||
</ | </ | ||
- | After creating the aliases file, you must use the postmap | + | After creating the aliases file, you must use the newaliases |
- | < | + | < |
This will create the file / | This will create the file / | ||
Line 208: | Line 211: | ||
[[howtos: | [[howtos: | ||
+ | |||
+ | ====== Sources ====== | ||
+ | * Based primarily on [[http:// | ||
+ | * Originally written by [[wiki: | ||
{{tag> | {{tag> |