diff options
| author | Oleksii Samorukov <samm@FreeBSD.org> | 2024-04-04 11:34:53 +0200 |
|---|---|---|
| committer | Oleksii Samorukov <samm@FreeBSD.org> | 2024-04-04 11:37:40 +0200 |
| commit | add1cc6abc1b6c500ee0bf3666cbe5ac54deec96 (patch) | |
| tree | 2ac263f6180c31a407d88d9102e7ac77647ad20d /mail/exilog/files/patch-doc_mysql-db-script.sql | |
| parent | cad/kicad-devel: Update to the current commits (diff) | |
mail/exilog: fix to be compatible with new exim msgid format
Recently exim changed msgid format, so tool does not work correctly
anymore. I tried to contact upstream but no reply so far. Also some
minor changes to make portlint happy
Diffstat (limited to 'mail/exilog/files/patch-doc_mysql-db-script.sql')
| -rw-r--r-- | mail/exilog/files/patch-doc_mysql-db-script.sql | 92 |
1 files changed, 92 insertions, 0 deletions
diff --git a/mail/exilog/files/patch-doc_mysql-db-script.sql b/mail/exilog/files/patch-doc_mysql-db-script.sql new file mode 100644 index 000000000000..6d1fb9496dcc --- /dev/null +++ b/mail/exilog/files/patch-doc_mysql-db-script.sql @@ -0,0 +1,92 @@ +--- doc/mysql-db-script.sql.orig 2005-07-22 08:57:03 UTC ++++ doc/mysql-db-script.sql +@@ -15,12 +15,12 @@ + + CREATE TABLE `deferrals` ( + `server` varchar(32) NOT NULL default '', +- `message_id` varchar(16) binary NOT NULL default '', ++ `message_id` varchar(23) binary NOT NULL default '', + `timestamp` bigint(20) NOT NULL default '0', + `rcpt` varchar(200) NOT NULL default '', + `rcpt_intermediate` varchar(200) default NULL, + `rcpt_final` varchar(200) NOT NULL default '', +- `host_addr` varchar(15) default NULL, ++ `host_addr` varchar(45) default NULL, + `host_dns` varchar(255) default NULL, + `tls_cipher` varchar(128) default NULL, + `router` varchar(128) default NULL, +@@ -43,12 +43,12 @@ CREATE TABLE `deferrals` ( + + CREATE TABLE `deliveries` ( + `server` varchar(32) NOT NULL default '', +- `message_id` varchar(16) binary NOT NULL default '', ++ `message_id` varchar(23) binary NOT NULL default '', + `timestamp` bigint(20) NOT NULL default '0', + `rcpt` varchar(200) NOT NULL default '', + `rcpt_intermediate` varchar(200) default NULL, + `rcpt_final` varchar(200) NOT NULL default '', +- `host_addr` varchar(15) default NULL, ++ `host_addr` varchar(45) default NULL, + `host_dns` varchar(255) default NULL, + `tls_cipher` varchar(128) default NULL, + `router` varchar(128) default NULL, +@@ -71,12 +71,12 @@ CREATE TABLE `deliveries` ( + + CREATE TABLE `errors` ( + `server` varchar(32) NOT NULL default '', +- `message_id` varchar(16) binary NOT NULL default '', ++ `message_id` varchar(23) binary NOT NULL default '', + `timestamp` bigint(20) NOT NULL default '0', + `rcpt` varchar(200) NOT NULL default '', + `rcpt_intermediate` varchar(200) default NULL, + `rcpt_final` varchar(200) NOT NULL default '', +- `host_addr` varchar(15) default NULL, ++ `host_addr` varchar(45) default NULL, + `host_dns` varchar(255) default NULL, + `tls_cipher` varchar(128) default NULL, + `router` varchar(128) default NULL, +@@ -99,12 +99,12 @@ CREATE TABLE `errors` ( + + CREATE TABLE `messages` ( + `server` varchar(32) NOT NULL default '', +- `message_id` varchar(16) binary NOT NULL default '', ++ `message_id` varchar(23) binary NOT NULL default '', + `timestamp` bigint(20) default NULL, + `msgid` varchar(255) default NULL, + `completed` bigint(20) default NULL, + `mailfrom` varchar(255) default NULL, +- `host_addr` varchar(15) default NULL, ++ `host_addr` varchar(45) default NULL, + `host_rdns` varchar(255) default NULL, + `host_ident` varchar(255) default NULL, + `host_helo` varchar(255) default NULL, +@@ -132,7 +132,7 @@ CREATE TABLE `messages` ( + + CREATE TABLE `queue` ( + `server` varchar(32) NOT NULL default '', +- `message_id` varchar(16) binary NOT NULL default '', ++ `message_id` varchar(23) binary NOT NULL default '', + `mailfrom` varchar(255) NOT NULL default '', + `timestamp` bigint(20) NOT NULL default '0', + `num_dsn` int(11) NOT NULL default '0', +@@ -162,9 +162,9 @@ CREATE TABLE `queue` ( + + CREATE TABLE `rejects` ( + `server` varchar(32) NOT NULL default '', +- `message_id` varchar(16) binary default NULL, ++ `message_id` varchar(23) binary default NULL, + `timestamp` bigint(20) NOT NULL default '0', +- `host_addr` varchar(15) NOT NULL default '', ++ `host_addr` varchar(45) NOT NULL default '', + `host_rdns` varchar(255) NOT NULL default '', + `host_ident` varchar(255) default NULL, + `host_helo` varchar(255) default NULL, +@@ -188,7 +188,7 @@ CREATE TABLE `rejects` ( + + CREATE TABLE `unknown` ( + `server` varchar(32) NOT NULL default '', +- `message_id` varchar(16) binary NOT NULL default '', ++ `message_id` varchar(23) binary NOT NULL default '', + `timestamp` bigint(20) NOT NULL default '0', + `line` varchar(255) NOT NULL default '', + PRIMARY KEY (`server`,`message_id`,`timestamp`,`line`), |