Postfix Cyrus Web cyradm HOWTO

#

select_field = dest

where_field = alias

additional_conditions = and status = '1'

The file

/etc/postfix/mysql canonical.cf

:

# mysql config file for canonical lookups on postfix

# comments are ok.

#

# the user name and password to log into the mysql server

hosts = localhost

user = mail

password = secret

# the database name on the servers

dbname = mail

# the table name

table = virtual

#

select_field = alias

where_field = username

# Return the first match only

additional_conditions = and status = '1' limit 1

Finally the file

/etc/postfix/mysql mydestination.cf

:

# mysql config file for local domain (like sendmail's sendmail.cw) lookups on postfix

# comments are ok.

#

# the user name and password to log into the mysql server

hosts = localhost

user = mail

password = secret

# the database name on the servers

dbname = mail

# the table name

table = domain

#

select_field = domain_name

where_field = domain_name

25