[pkgsrc/trunk]: pkgsrc Apply patch from dspam CVS to fix some errors when usi...

[xtraeme <xtraeme%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/466137d0b899
branches:  trunk
changeset: 482417:466137d0b899
user:      xtraeme <xtraeme%pkgsrc.org@localhost>
date:      Wed Oct 27 23:27:00 2004 +0000

description:
Apply patch from dspam CVS to fix some errors when using MySQL-4.1.x.

Bump PKGREVISION.

diffstat:

 doc/CHANGES                 |    3 +-
 mail/dspam/Makefile         |    3 +-
 mail/dspam/distinfo         |    3 +-
 mail/dspam/patches/patch-ab |  109 ++++++++++++++++++++++++++++++++++++++++++++
 4 files changed, 115 insertions(+), 3 deletions(-)

diffs (150 lines):

diff -r 49103d9d50de -r 466137d0b899 doc/CHANGES
--- a/doc/CHANGES       Wed Oct 27 22:46:11 2004 +0000
+++ b/doc/CHANGES       Wed Oct 27 23:27:00 2004 +0000
@@ -1,4 +1,4 @@
-$NetBSD: CHANGES,v 1.7580 2004/10/27 22:46:11 wiz Exp $
+$NetBSD: CHANGES,v 1.7581 2004/10/27 23:27:00 xtraeme Exp $
 
 Changes to the packages collection and infrastructure in 2004:
 
@@ -4902,3 +4902,4 @@
        Updated mtr-gtk to 0.65 [wiz 2004-10-27]
        Updated p5-xmltv to 0.5.36 [adrianp 2004-10-27]
        Updated pv to 0.8.6 [wiz 2004-10-28]
+       Updated dspam to 3.2.0nb1 [xtraeme 2004-10-28]
diff -r 49103d9d50de -r 466137d0b899 mail/dspam/Makefile
--- a/mail/dspam/Makefile       Wed Oct 27 22:46:11 2004 +0000
+++ b/mail/dspam/Makefile       Wed Oct 27 23:27:00 2004 +0000
@@ -1,6 +1,7 @@
-# $NetBSD: Makefile,v 1.11 2004/10/22 05:43:29 xtraeme Exp $
+# $NetBSD: Makefile,v 1.12 2004/10/27 23:27:00 xtraeme Exp $
 
 DISTNAME=      dspam-3.2.0
+PKGREVISION=   1
 CATEGORIES=    mail
 MASTER_SITES=  http://www.nuclearelephant.com/projects/dspam/sources/
 
diff -r 49103d9d50de -r 466137d0b899 mail/dspam/distinfo
--- a/mail/dspam/distinfo       Wed Oct 27 22:46:11 2004 +0000
+++ b/mail/dspam/distinfo       Wed Oct 27 23:27:00 2004 +0000
@@ -1,5 +1,6 @@
-$NetBSD: distinfo,v 1.3 2004/10/22 05:43:29 xtraeme Exp $
+$NetBSD: distinfo,v 1.4 2004/10/27 23:27:00 xtraeme Exp $
 
 SHA1 (dspam-3.2.0.tar.gz) = 45dd9addddf42bf8e891c3f35fd9009f4fae9a5f
 Size (dspam-3.2.0.tar.gz) = 617716 bytes
 SHA1 (patch-aa) = 0f5ca6fc4c03ea0b73ccd1214f047fec6ffe4cb3
+SHA1 (patch-ab) = 31711472c5b7b60cd8ecbe1427d56e2a86e28024
diff -r 49103d9d50de -r 466137d0b899 mail/dspam/patches/patch-ab
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/mail/dspam/patches/patch-ab       Wed Oct 27 23:27:00 2004 +0000
@@ -0,0 +1,109 @@
+$NetBSD: patch-ab,v 1.1 2004/10/27 23:27:00 xtraeme Exp $
+
+Fix for MySQL 4.1.x users:
+
+http://dspam.nuclearelephant.com/dspam-users/5709.html
+
+--- mysql_drv.c.orig   2004-10-28 01:01:32.000000000 +0200
++++ mysql_drv.c        2004-10-28 01:07:44.000000000 +0200
+@@ -512,10 +512,10 @@
+   struct _ds_spam_stat stat, stat2;
+   struct lht_node *node_lht;
+   struct lht_c c_lht;
+-  buffer *query, *insert;
++  buffer *query;
+   char scratch[1024];
+   struct passwd *p;
+-  int update_one = 0, insert_one = 0;
++  int update_one = 0;
+ 
+   if (s->dbh == NULL)
+   {
+@@ -546,14 +546,6 @@
+     return EUNKNOWN;
+   }
+ 
+-  insert = buffer_create(NULL);
+-  if (insert == NULL)
+-  {
+-    buffer_destroy(query);
+-    LOG (LOG_CRIT, ERROR_MEM_ALLOC);
+-    return EUNKNOWN;
+-  }
+-
+   if (s->control_token == 0)
+   {
+     node_lht = c_lht_first (freq, &c_lht);
+@@ -585,9 +577,6 @@
+ 
+   buffer_cat (query, scratch);
+ 
+-  buffer_copy (insert, "insert into dspam_token_data(uid, token, spam_hits, "
+-                       "innocent_hits, last_hit) values");
+-
+   node_lht = c_lht_first (freq, &c_lht);
+   while (node_lht != NULL)
+   {
+@@ -605,7 +594,7 @@
+ 
+     if (stat2.disk != 'Y')
+     {
+-      char ins[1024];
++      char insert[1024];
+ 
+       /* If we're processing a message with a MERGED group, assign it based on
+          an empty count and not the current count (since the current count
+@@ -615,25 +604,27 @@
+          on the actual count (so that tools like dspam_merge don't break) */
+ 
+       if (CTX->flags & DSF_MERGED) {
+-        snprintf (ins, sizeof (ins),
+-                  "%s(%d, '%llu', %d, %d, current_date())",
+-                   (insert_one) ? ", " : "",
++      snprintf (insert, sizeof (insert),
++              "insert into dspam_token_data(uid, token, spam_hits, "
++              "innocent_hits, last_hit) values(%d, '%llu', %d, %d, "
++              "current_date())",
+                    p->pw_uid, 
+                    node_lht->key, 
+                    stat.spam_hits > s->control_sh ? 1 : 0,
+                    stat.innocent_hits > s->control_ih ? 1 : 0);
+       } else {
+-        snprintf (ins, sizeof (ins),
+-                  "%s(%d, '%llu', %ld, %ld, current_date())",
+-                   (insert_one) ? ", " : "",
++      snprintf(insert, sizeof (insert),
++              "insert into dspam_token_data(uid, token, spam_hits, "
++              "innocent_hits, last_hit) values(%d, '%llu', %ld, %ld, "
++              "current_date())",
+                    p->pw_uid,
+                    node_lht->key,
+                    stat2.spam_hits, 
+                    stat2.innocent_hits);
+       }
+ 
+-      insert_one = 1;
+-      buffer_cat(insert, ins);
++      if (MYSQL_RUN_QUERY (s->dbh, insert))
++      stat2.disk = 'Y'; 
+     }
+ 
+     if (stat2.disk == 'Y')
+@@ -675,17 +666,6 @@
+     }
+   }
+ 
+-  if (insert_one)
+-  {
+-    if (MYSQL_RUN_QUERY (s->dbh, insert->data))
+-    {
+-      _mysql_drv_query_error (mysql_error (s->dbh), insert->data);
+-      buffer_destroy(insert);
+-      return EFAILURE;
+-    }
+-  }
+-
+-  buffer_destroy (insert);
+   buffer_destroy (query);
+   return 0;
+ }