Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
howtos:network_services:postfix_dovecot_mysql:postfix [2015/03/08 08:47 (UTC)] astrogeek Errata |
howtos:network_services:postfix_dovecot_mysql:postfix [2018/10/08 02:14 (UTC)] (current) astrogeek [Configuring The Postfix MTA] |
||
|---|---|---|---|
| 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 = /etc/ssl/localcerts/dove.pem | smtpd_tls_cert_file = /etc/ssl/localcerts/dove.pem | ||
| - | 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='%s' | query = SELECT 1 FROM virtual_domains WHERE name='%s' | ||
| 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='%s' | query = SELECT 1 FROM virtual_users WHERE email='%s' | ||
| 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='%s' | query = SELECT destination FROM virtual_aliases WHERE source='%s' | ||
