Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
howtos:network_services:postfix_dovecot_mysql:postfix [2015/09/25 01:10 (UTC)] astrogeek [Configuring The Postfix MTA] fixed smtpd_tls_key_file path |
howtos:network_services:postfix_dovecot_mysql:postfix [2018/10/08 02:14 (UTC)] (current) astrogeek [Configuring The Postfix MTA] |
||
|---|---|---|---|
| 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' | ||
