[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 09:47 (UTC)] – First complete version 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 39: | 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 97: | 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 142: | 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 152: | 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 161: | 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 178: | 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 197: | 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 206: | Line 211: | ||
[[howtos: | [[howtos: | ||
+ | |||
+ | ====== Sources ====== | ||
+ | * Based primarily on [[http:// | ||
+ | * Originally written by [[wiki: | ||
{{tag> | {{tag> |