summaryrefslogtreecommitdiff
path: root/mail/dbmail/files/patch-0008-Add-primary-key-constraint-to-dbmail_authlog
diff options
context:
space:
mode:
authorMuhammad Moinur Rahman <bofh@FreeBSD.org>2017-02-24 21:15:52 +0000
committerMuhammad Moinur Rahman <bofh@FreeBSD.org>2017-02-24 21:15:52 +0000
commit9eff14e4885b86d6f5a8b35c69ebaabd9e74df06 (patch)
tree443206cca0976456f3fd02dad4c4ebfe294c5904 /mail/dbmail/files/patch-0008-Add-primary-key-constraint-to-dbmail_authlog
parentdevel/py-pathlib2: add missing dependency (diff)
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
Notes
Notes: svn path=/head/; revision=434749
Diffstat (limited to 'mail/dbmail/files/patch-0008-Add-primary-key-constraint-to-dbmail_authlog')
-rw-r--r--mail/dbmail/files/patch-0008-Add-primary-key-constraint-to-dbmail_authlog26
1 files changed, 26 insertions, 0 deletions
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 <ahicks@p-o.co.uk>
+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)
+