Prereq: "3.0.6" diff -cr --new-file /var/tmp/postfix-3.0.6/src/global/mail_version.h ./src/global/mail_version.h *** /var/tmp/postfix-3.0.6/src/global/mail_version.h 2016-08-27 18:54:46.000000000 -0400 --- ./src/global/mail_version.h 2016-10-01 19:26:42.000000000 -0400 *************** *** 20,27 **** * Patches change both the patchlevel and the release date. Snapshots have no * patchlevel; they change the release date only. */ ! #define MAIL_RELEASE_DATE "20160828" ! #define MAIL_VERSION_NUMBER "3.0.6" #ifdef SNAPSHOT #define MAIL_VERSION_DATE "-" MAIL_RELEASE_DATE --- 20,27 ---- * Patches change both the patchlevel and the release date. Snapshots have no * patchlevel; they change the release date only. */ ! #define MAIL_RELEASE_DATE "20161001" ! #define MAIL_VERSION_NUMBER "3.0.7" #ifdef SNAPSHOT #define MAIL_VERSION_DATE "-" MAIL_RELEASE_DATE diff -cr --new-file /var/tmp/postfix-3.0.6/HISTORY ./HISTORY *** /var/tmp/postfix-3.0.6/HISTORY 2016-08-27 19:06:57.000000000 -0400 --- ./HISTORY 2016-10-01 19:36:30.000000000 -0400 *************** *** 21736,21744 **** 20160204 ! Documentation (introduced: Postfix 3.0): wrong paramester name in lmtp_address_verify_target description. File: ! proto/posconf.proto 20160310 --- 21736,21744 ---- 20160204 ! Documentation (introduced: Postfix 3.0): wrong parameter name in lmtp_address_verify_target description. File: ! proto/postconf.proto 20160310 *************** *** 21772,21776 **** Bugfix (introduced: Postfix 3.0): the tls_session_ticket_cipher documentation says aes-256-cbc, but the implementation was ! using aes-128-cbc (note that Postfix SMTP server and client ! processes have a limited life time). --- 21772,21798 ---- Bugfix (introduced: Postfix 3.0): the tls_session_ticket_cipher documentation says aes-256-cbc, but the implementation was ! using aes-128-cbc (note that Postfix session ticket keys ! are rotated after 1/2 hour, to limit the impact of attacks ! on session ticket keys). ! ! 20160911 ! ! Bugfix (introduced: Postfix 3.0): the SMTP daemon did not ! reset a previous session's command counts before rejecting ! a client that exceeds request or concurrency rates. File: ! smtpd/smtpd.c. ! ! 20160917 ! ! Bugfix (introduced: Postfix 3.0): the unionmap did not ! propagate table lookup errors. Based on patch by Roel van ! Meer. Files: util/dict_union.c, util/dict_union_test.*. ! ! 20160925 ! ! Workaround (problem introduced: Postfix 2.11): to avoid ! false "not found" errors with MySQL map queries that contain ! UTF8-encoded text, specify "option_group = client" in Postfix ! MySQL configuration files. This will be the default setting ! with Postfix 3.2 and later. diff -cr --new-file /var/tmp/postfix-3.0.6/README_FILES/MYSQL_README ./README_FILES/MYSQL_README *** /var/tmp/postfix-3.0.6/README_FILES/MYSQL_README 2015-01-29 17:33:49.000000000 -0500 --- ./README_FILES/MYSQL_README 2016-10-01 19:01:51.000000000 -0400 *************** *** 94,101 **** --- 94,113 ---- # Don't forget the leading "AND"! additional_conditions = AND status = 'paid' + # This is necessary to make UTF8 queries work for Postfix 2.11 .. 3.1, + # and is the default setting as of Postfix 3.2, + option_group = client + AAddddiittiioonnaall nnootteess + Postfix 3.2 and later read [[cclliieenntt]] option group settings by default. To + disable this, specify no ooppttiioonn__ffiillee and specify "ooppttiioonn__ggrroouupp ==" (i.e. an + empty value). + + Postfix 3.1 and earlier don't read [[cclliieenntt]] option group settings unless a non- + empty ooppttiioonn__ffiillee or ooppttiioonn__ggrroouupp value are specified. To enable this, specify, + for example "ooppttiioonn__ggrroouupp == cclliieenntt". + The MySQL configuration interface setup allows for multiple mysql databases: you can use one for a virtual table, one for an access table, and one for an aliases table if you want. diff -cr --new-file /var/tmp/postfix-3.0.6/RELEASE_NOTES ./RELEASE_NOTES *** /var/tmp/postfix-3.0.6/RELEASE_NOTES 2015-07-19 18:24:25.000000000 -0400 --- ./RELEASE_NOTES 2016-10-01 19:36:19.000000000 -0400 *************** *** 16,21 **** --- 16,29 ---- If you upgrade from Postfix 2.10 or earlier, read RELEASE_NOTES-2.11 before proceeding. + Workaround - UTF8 support in Postfix MySQL queries + -------------------------------------------------- + + Someone reported false "not found" errors with MySQL map queries + that contain UTF8-encoded text. To avoid such errors, specify + "option_group = client" in Postfix MySQL configuration files. This + will be the default setting with Postfix 3.2 and later. + Incompatible change with Postfix 3.0.2 -------------------------------------- diff -cr --new-file /var/tmp/postfix-3.0.6/html/MYSQL_README.html ./html/MYSQL_README.html *** /var/tmp/postfix-3.0.6/html/MYSQL_README.html 2015-01-29 17:33:47.000000000 -0500 --- ./html/MYSQL_README.html 2016-10-01 19:01:51.000000000 -0400 *************** *** 130,139 **** --- 130,152 ---- where_field = alias # Don't forget the leading "AND"! additional_conditions = AND status = 'paid' + + # This is necessary to make UTF8 queries work for Postfix 2.11 .. 3.1, + # and is the default setting as of Postfix 3.2, + option_group = client

Additional notes

+

Postfix 3.2 and later read [client] option group settings + by default. To disable this, specify no option_file and + specify "option_group =" (i.e. an empty value).

+ +

Postfix 3.1 and earlier don't read [client] option group + settings unless a non-empty option_file or option_group + value are specified. To enable this, specify, for example + "option_group = client".

+

The MySQL configuration interface setup allows for multiple mysql databases: you can use one for a virtual table, one for an access table, and one for an aliases table if you want.

diff -cr --new-file /var/tmp/postfix-3.0.6/html/mysql_table.5.html ./html/mysql_table.5.html *** /var/tmp/postfix-3.0.6/html/mysql_table.5.html 2015-01-29 17:21:04.000000000 -0500 --- ./html/mysql_table.5.html 2016-10-01 19:18:36.000000000 -0400 *************** *** 232,237 **** --- 232,242 ---- option_group Read options from the given group. + Postfix 3.1 and earlier don't read [client] option group set- + tings unless a non-empty option_file or option_group value are + specified. To enable this, specify, for example, "option_group = + client". + This parameter is available with Postfix 2.11 and later. tls_cert_file *************** *** 240,276 **** This parameter is available with Postfix 2.11 and later. tls_key_file ! File containing the private key corresponding to tls_cert_file. This parameter is available with Postfix 2.11 and later. tls_CAfile ! File containing certificates for all of the X509 Certification ! Authorities the client will recognize. Takes precedence over tls_CApath. This parameter is available with Postfix 2.11 and later. tls_CApath ! Directory containing X509 Certification Authority certificates in separate individual files. This parameter is available with Postfix 2.11 and later. tls_verify_cert (default: no) ! Verify that the server's name matches the common name in the certificate. This parameter is available with Postfix 2.11 and later. OBSOLETE QUERY INTERFACE ! This section describes an interface that is deprecated as of Postfix ! 2.2. It is replaced by the more general query interface described ! above. If the query parameter is defined, the legacy parameters ! described here ignored. Please migrate to the new interface as the legacy interface may be removed in a future release. ! The following parameters can be used to fill in a SELECT template statement of the form: SELECT [select_field] --- 245,281 ---- This parameter is available with Postfix 2.11 and later. tls_key_file ! File containing the private key corresponding to tls_cert_file. This parameter is available with Postfix 2.11 and later. tls_CAfile ! File containing certificates for all of the X509 Certification ! Authorities the client will recognize. Takes precedence over tls_CApath. This parameter is available with Postfix 2.11 and later. tls_CApath ! Directory containing X509 Certification Authority certificates in separate individual files. This parameter is available with Postfix 2.11 and later. tls_verify_cert (default: no) ! Verify that the server's name matches the common name in the certificate. This parameter is available with Postfix 2.11 and later. OBSOLETE QUERY INTERFACE ! This section describes an interface that is deprecated as of Postfix ! 2.2. It is replaced by the more general query interface described ! above. If the query parameter is defined, the legacy parameters ! described here ignored. Please migrate to the new interface as the legacy interface may be removed in a future release. ! The following parameters can be used to fill in a SELECT template statement of the form: SELECT [select_field] *************** *** 279,285 **** [additional_conditions] The specifier %s is replaced by the search string, and is escaped so if ! it contains single quotes or other odd characters, it will not cause a parse error, or worse, a security problem. select_field --- 284,290 ---- [additional_conditions] The specifier %s is replaced by the search string, and is escaped so if ! it contains single quotes or other odd characters, it will not cause a parse error, or worse, a security problem. select_field diff -cr --new-file /var/tmp/postfix-3.0.6/man/man5/mysql_table.5 ./man/man5/mysql_table.5 *** /var/tmp/postfix-3.0.6/man/man5/mysql_table.5 2015-01-29 17:21:01.000000000 -0500 --- ./man/man5/mysql_table.5 2016-10-01 19:18:36.000000000 -0400 *************** *** 264,269 **** --- 264,274 ---- .IP "\fBoption_group\fR" Read options from the given group. .sp + Postfix 3.1 and earlier don't read \fB[client]\fR option + group settings unless a non\-empty \fBoption_file\fR or + \fBoption_group\fR value are specified. To enable this, + specify, for example, "\fBoption_group = client\fR". + .sp This parameter is available with Postfix 2.11 and later. .IP "\fBtls_cert_file\fR" File containing client's X509 certificate. diff -cr --new-file /var/tmp/postfix-3.0.6/proto/MYSQL_README.html ./proto/MYSQL_README.html *** /var/tmp/postfix-3.0.6/proto/MYSQL_README.html 2015-01-29 17:33:24.000000000 -0500 --- ./proto/MYSQL_README.html 2016-10-01 18:36:50.000000000 -0400 *************** *** 130,139 **** --- 130,152 ---- where_field = alias # Don't forget the leading "AND"! additional_conditions = AND status = 'paid' + + # This is necessary to make UTF8 queries work for Postfix 2.11 .. 3.1, + # and is the default setting as of Postfix 3.2, + option_group = client

Additional notes

+

Postfix 3.2 and later read [client] option group settings + by default. To disable this, specify no option_file and + specify "option_group =" (i.e. an empty value).

+ +

Postfix 3.1 and earlier don't read [client] option group + settings unless a non-empty option_file or option_group + value are specified. To enable this, specify, for example + "option_group = client".

+

The MySQL configuration interface setup allows for multiple mysql databases: you can use one for a virtual table, one for an access table, and one for an aliases table if you want.

diff -cr --new-file /var/tmp/postfix-3.0.6/proto/mysql_table ./proto/mysql_table *** /var/tmp/postfix-3.0.6/proto/mysql_table 2015-01-29 07:16:38.000000000 -0500 --- ./proto/mysql_table 2016-10-01 19:18:24.000000000 -0400 *************** *** 252,257 **** --- 252,262 ---- # .IP "\fBoption_group\fR" # Read options from the given group. # .sp + # Postfix 3.1 and earlier don't read \fB[client]\fR option + # group settings unless a non-empty \fBoption_file\fR or + # \fBoption_group\fR value are specified. To enable this, + # specify, for example, "\fBoption_group = client\fR". + # .sp # This parameter is available with Postfix 2.11 and later. # .IP "\fBtls_cert_file\fR" # File containing client's X509 certificate. diff -cr --new-file /var/tmp/postfix-3.0.6/src/smtpd/smtpd.c ./src/smtpd/smtpd.c *** /var/tmp/postfix-3.0.6/src/smtpd/smtpd.c 2015-07-19 18:34:26.000000000 -0400 --- ./src/smtpd/smtpd.c 2016-09-11 09:42:48.000000000 -0400 *************** *** 4790,4795 **** --- 4790,4804 ---- case 0: /* + * Reset the per-command counters. + */ + for (cmdp = smtpd_cmd_table; /* see below */ ; cmdp++) { + cmdp->success_count = cmdp->total_count = 0; + if (cmdp->name == 0) + break; + } + + /* * In TLS wrapper mode, turn on TLS using code that is shared with * the STARTTLS command. This code does not return when the handshake * fails. *************** *** 4961,4975 **** #endif /* - * Reset the per-command counters. - */ - for (cmdp = smtpd_cmd_table; /* see below */ ; cmdp++) { - cmdp->success_count = cmdp->total_count = 0; - if (cmdp->name == 0) - break; - } - - /* * The command read/execute loop. */ for (;;) { --- 4970,4975 ---- diff -cr --new-file /var/tmp/postfix-3.0.6/src/util/dict_union.c ./src/util/dict_union.c *** /var/tmp/postfix-3.0.6/src/util/dict_union.c 2014-10-20 19:53:04.000000000 -0400 --- ./src/util/dict_union.c 2016-09-17 08:07:15.000000000 -0400 *************** *** 81,91 **** for (cpp = dict_union->map_union->argv; (dict_type_name = *cpp) != 0; cpp++) { if ((map = dict_handle(dict_type_name)) == 0) msg_panic("%s: dictionary \"%s\" not found", myname, dict_type_name); ! if ((result = dict_get(map, query)) == 0) ! continue; ! if (VSTRING_LEN(dict_union->re_buf) > 0) ! VSTRING_ADDCH(dict_union->re_buf, ','); ! vstring_strcat(dict_union->re_buf, result); } DICT_ERR_VAL_RETURN(dict, DICT_ERR_NONE, VSTRING_LEN(dict_union->re_buf) > 0 ? --- 81,93 ---- for (cpp = dict_union->map_union->argv; (dict_type_name = *cpp) != 0; cpp++) { if ((map = dict_handle(dict_type_name)) == 0) msg_panic("%s: dictionary \"%s\" not found", myname, dict_type_name); ! if ((result = dict_get(map, query)) != 0) { ! if (VSTRING_LEN(dict_union->re_buf) > 0) ! VSTRING_ADDCH(dict_union->re_buf, ','); ! vstring_strcat(dict_union->re_buf, result); ! } else if (map->error != 0) { ! DICT_ERR_VAL_RETURN(dict, map->error, 0); ! } } DICT_ERR_VAL_RETURN(dict, DICT_ERR_NONE, VSTRING_LEN(dict_union->re_buf) > 0 ?