Your message dated Mon, 31 Mar 2008 18:47:06 +0000 with message-id <[EMAIL PROTECTED]> and subject line Bug#471255: fixed in dbmail 2.2.10-1 has caused the Debian Bug report #471255, regarding dbmail-users gives SQL Errors with PostgreSQL 8.3 to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [EMAIL PROTECTED] immediately.) -- 471255: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=471255 Debian Bug Tracking System Contact [EMAIL PROTECTED] with problems
--- Begin Message ---Package: dbmail Version: 2.2.9-1 Severity: important Tags: patch -- System Information: Debian Release: lenny/sid APT prefers testing APT policy: (500, 'testing') Architecture: amd64 (x86_64) Kernel: Linux 2.6.18-4-xen-vserver-amd64 (SMP w/1 CPU core) Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Shell: /bin/sh linked to /bin/bash Versions of packages dbmail depends on: ii adduser 3.106 add and remove users and groups ii debconf [debconf-2.0] 1.5.19 Debian configuration management sy ii libc6 2.7-6 GNU C Library: Shared libraries ii libglib2.0-0 2.14.6-1 The GLib library of C routines ii libgmime-2.0-2 2.2.17-1 MIME library ii libldap-2.4-2 2.4.7-5 OpenLDAP libraries ii libsieve2-1 2.2.3-1 a library for parsing, sorting and ii libsqlite3-0 3.5.6-3 SQLite 3 shared library ii ucf 3.005 Update Configuration File: preserv ii zlib1g 1:1.2.3.3.dfsg-11 compression library - runtime dbmail recommends no packages. -- debconf information excluded Typical Error Message : Mar 16 23:52:35 vserver1.local dbmail-users[7120]: Error:[sql] dbpgsql.c,db_query(+287): query failed [SELECT alias FROM dbmail_aliases WHERE deliver_to = 5 ORDER BY alias DESC] : [ERROR: operator does not exist: character varying = integer LINE 1: SELECT alias FROM dbmail_aliases WHERE deliver_to = 5 ORDER ... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. ] The attached Patch fixes the issue - and allows dbmail-2.2.9-1 to work flawlessly.
--- End Message ---
--- Begin Message ---Source: dbmail Source-Version: 2.2.10-1 We believe that the bug you reported is fixed in the latest version of dbmail, which is due to be installed in the Debian FTP archive: dbmail-mysql_2.2.10-1_i386.deb to pool/main/d/dbmail/dbmail-mysql_2.2.10-1_i386.deb dbmail-pgsql_2.2.10-1_i386.deb to pool/main/d/dbmail/dbmail-pgsql_2.2.10-1_i386.deb dbmail_2.2.10-1.diff.gz to pool/main/d/dbmail/dbmail_2.2.10-1.diff.gz dbmail_2.2.10-1.dsc to pool/main/d/dbmail/dbmail_2.2.10-1.dsc dbmail_2.2.10-1_i386.deb to pool/main/d/dbmail/dbmail_2.2.10-1_i386.deb dbmail_2.2.10.orig.tar.gz to pool/main/d/dbmail/dbmail_2.2.10.orig.tar.gz A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to [EMAIL PROTECTED], and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Paul J Stevens <[EMAIL PROTECTED]> (supplier of updated dbmail package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing [EMAIL PROTECTED]) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Format: 1.7 Date: Mon, 24 Mar 2008 15:45:41 +0100 Source: dbmail Binary: dbmail dbmail-pgsql dbmail-mysql Architecture: source i386 Version: 2.2.10-1 Distribution: unstable Urgency: low Maintainer: Paul J Stevens <[EMAIL PROTECTED]> Changed-By: Paul J Stevens <[EMAIL PROTECTED]> Description: dbmail - base package for the dbmail email solution dbmail-mysql - MySQL module for Dbmail dbmail-pgsql - PostgreSQL module for Dbmail Closes: 470182 471255 Changes: dbmail (2.2.10-1) unstable; urgency=low . * new upstream release (Closes: #471255). * accept Ubuntu changes: - move adduser from Depends to Pre-Depends. Closes: #470182 - remove user dbmail after package removal Files: 8f4a2b906e818f6cf7e2326e698c61cb 1117 mail optional dbmail_2.2.10-1.dsc cd255326f410848e27e0a82a43fa2424 900636 mail optional dbmail_2.2.10.orig.tar.gz f285f37e3ab2b31230d694f1e9e8310f 799 mail optional dbmail_2.2.10-1.diff.gz ae8b36c7b2e1a01f19f68005951fbb16 311448 mail optional dbmail_2.2.10-1_i386.deb 9ab0901aa049f053817f142df40645b2 17060 mail optional dbmail-pgsql_2.2.10-1_i386.deb cf9fe486043e6f9253db70bd704344ee 17562 mail optional dbmail-mysql_2.2.10-1_i386.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iQEVAwUBR/EtpGz0hbPcukPfAQIvqggAlB7ietIu6gBc/lJv/6HawVD3U/pXc5Ss V3jr/UAvEeq0mwoz0kUb0xtNSQXshC+/lSghlv6MTg+N+qJ8K1VKybwHoKQWfjMl MJI5U1i2qHTFzJ3CGRETgn+IeYXl0lrX7QgUfuHgN6jJyYWAlYsPhcf0/5CJryyz WJx7tnT0aSNHesAri76Rfz40ErJdEq6nKXr2MhjVjLeuoRffjyMUkuxIDWL/w30/ C4qLtabNc8WrN0gSRS6LDKgFGWYBZNg5F/MbqYP024Flr//0COftQ6WcdwFB2XTx ZbMInn3wfOEswiHD/1sK1537Dq/TWWnU+15JdYtfbmCcFC4/DK6h4g== =FZNq -----END PGP SIGNATURE-----
--- End Message ---
