Postfix virtual MySQL-Maps need config update (deprecated settings)
I just noticed that some Postfix-Virtual settings used by default for ispConfig based Postfix setup have been marked as deprecated:
http://www.postfix.org/mysql_table.5.html
QUOTE (link above):
-- BACKWARDS COMPATIBILITY --
Normally, the SQL query is specified via a single query
parameter (described in more detail below). When this
parameter is not specified in the map definition, Postfix
reverts to an older interface, with the SQL query con-
structed from the select_field, table, where_field and
additional_conditions parameters. The old interface will
be gradually phased out. To migrate to the new interface
set:
query = SELECT [select_field]
FROM [table]
WHERE [where_field] = '%s'
[additional_conditions]
Insert the value, not the name, of each legacy parameter.
Note that the additional_conditions parameter is optional
and if not empty, will always start with AND.