[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/03/08 08:44 (UTC)] – Errata and link updates 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 ====== |
+ | |||
+ | 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 40: | Line 42: | ||
< | < | ||
====== Configuring The Postfix MTA ====== | ====== Configuring The Postfix MTA ====== | ||
- | |||
- | This page is supplemental to main article: [[howtos: | ||
You must become familiar with the [[http:// | You must become familiar with the [[http:// | ||
Line 100: | 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 145: | 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 155: | 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 164: | 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 181: | 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=' |