Skip to content

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.