From 9eff14e4885b86d6f5a8b35c69ebaabd9e74df06 Mon Sep 17 00:00:00 2001 From: Muhammad Moinur Rahman Date: Fri, 24 Feb 2017 21:15:52 +0000 Subject: mail/dbmail: adopt latest fixes from git: - login_disabled option before starttls for pop3 - fix compiler warnings for GCC5 - Fix IMAP mailbox maintanence - prevent assertion in p_string_erase - improve crypt authentication, also don't segfault when spasswd is empty - simplify log_query_time duration logic - Disconnect IMAP clients if only few free FDs left - Add primary key constraint to dbmail_authlog - Rework temporary connection failures - Give sensible default for retry 120s - Add retries for binding and searching - Bump search timeout to 60s - Increase ldap timeout to 600s 10 mins - Refactor deprecated functions - Get timeout from config - Remove redundant event_assign - Remove deprecated non functioning g_mem_profile - Add definition for authldap_free - Revert inadvertent event_assign removal - Reduce failed LDAP connection for search to error - Update LDAP to non deprecated search - Clear the ldap connection - Update ldap deprecated unbind - Fix typo - Update to ldap_unbind_ext_s and remove redundant sigaction - Rebalance commit rollback - Ensure mailbox2dbmail is using Python 2 - Tidy mailbox2dbmail man page - Update description of pid file location in server man page - Boundaries fixups ordering of parts do not add newline on - Prepend headers during delivery - Allow for systems that don't use proc PR: 210274 Submitted by: fluffy --- ...08-Add-primary-key-constraint-to-dbmail_authlog | 26 ++++++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100644 mail/dbmail/files/patch-0008-Add-primary-key-constraint-to-dbmail_authlog (limited to 'mail/dbmail/files/patch-0008-Add-primary-key-constraint-to-dbmail_authlog') diff --git a/mail/dbmail/files/patch-0008-Add-primary-key-constraint-to-dbmail_authlog b/mail/dbmail/files/patch-0008-Add-primary-key-constraint-to-dbmail_authlog new file mode 100644 index 000000000000..5b2c8001e631 --- /dev/null +++ b/mail/dbmail/files/patch-0008-Add-primary-key-constraint-to-dbmail_authlog @@ -0,0 +1,26 @@ +From 024ba19d1c83bee22b6b5901d2fff586d9391cf3 Mon Sep 17 00:00:00 2001 +From: Alan Hicks +Date: Tue, 24 Feb 2015 11:27:45 +0000 +Subject: [PATCH 08/33] Add primary key constraint to dbmail_authlog + +--- + sql/postgresql/create_tables.pgsql | 3 ++- + 1 file changed, 2 insertions(+), 1 deletion(-) + +diff --git sql/postgresql/create_tables.pgsql sql/postgresql/create_tables.pgsql +index da3b694..45740fd 100644 +--- sql/postgresql/create_tables.pgsql ++++ sql/postgresql/create_tables.pgsql +@@ -46,7 +46,8 @@ CREATE TABLE dbmail_authlog ( + dst_port INT8, + status VARCHAR(32) DEFAULT 'active', + bytes_rx INT8 DEFAULT '0' NOT NULL, +- bytes_tx INT8 DEFAULT '0' NOT NULL ++ bytes_tx INT8 DEFAULT '0' NOT NULL, ++ PRIMARY KEY (id) + ); + + +-- +2.10.1 (Apple Git-78) + -- cgit v1.2.3