Your message dated Wed, 22 Apr 2009 22:47:17 +0000
with message-id <[email protected]>
and subject line Bug#227251: fixed in planner 0.14.4-1
has caused the Debian Bug report #227251,
regarding planner: Single quotes not escaped writing to database
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.)


-- 
227251: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=227251
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: planner
Version: 0.11-4
Severity: normal

When planner writes the tasks to the database, a task name with a ' in
it will not be written.  The SQL string that planner is building to
INSERT the data is not properly escaping strings contining ' or \.

Of course in this case it is not a security issue (i.e. SQL injection)
because anyone using planner to write to that database could use psql
and inject whatever directly.

Thanks,
            Andrew McMillan.

-- System Information:
Debian Release: testing/unstable
Architecture: i386
Kernel: Linux kant.mcmillan.net.nz 2.6.1-rc2-kant #1 Thu Jan 8 08:00:22 NZDT 
2004 i686
Locale: LANG=C, LC_CTYPE=C

Versions of packages planner depends on:
ii  libart-2.0-2               2.3.16-1      Library of functions for 2D graphi
ii  libatk1.0-0                1.4.1-1       The ATK accessibility toolkit
ii  libaudiofile0              0.2.3-4       The Audiofile Library
ii  libbonobo2-0               2.4.2.0-1     Bonobo CORBA interfaces library
ii  libbonoboui2-0             2.4.2-1       The Bonobo UI library
ii  libbz2-1.0                 1.0.2-1       A high-quality block-sorting file 
ii  libc6                      2.3.2.ds1-10  GNU C Library: Shared libraries an
ii  libesd-alsa0 [libesd0]     0.2.29-1      Enlightened Sound Daemon (ALSA) - 
ii  libfontconfig1             2.2.1-13      generic font configuration library
ii  libfreetype6               2.1.7-1.1     FreeType 2 font engine, shared lib
ii  libgconf2-4                2.4.0.1-3     GNOME configuration database syste
ii  libgcrypt1                 1.1.12-4      LGPL Crypto library - runtime libr
ii  libglade2-0                2.0.1-6       Library to load .glade files at ru
ii  libglib2.0-0               2.2.3-1       The GLib library of C routines
ii  libgnome2-0                2.4.0-4       The GNOME 2 library - runtime file
ii  libgnomecanvas2-0          2.4.0-1       A powerful object-oriented display
ii  libgnomeprint2.2-0         2.4.2-2       The GNOME 2.2 print architecture -
ii  libgnomeprintui2.2-0       2.4.2-1       The GNOME 2.2 print architecture U
ii  libgnomeui-0               2.4.0.1-6     The GNOME 2 libraries (User Interf
ii  libgnomevfs2-0             2.4.1-4.1     The GNOME virtual file-system libr
ii  libgnomevfs2-common        2.4.1-4.1     The GNOME virtual file-system libr
ii  libgnutls7                 0.8.12-3.1    GNU TLS library - runtime library
ii  libgsf-1                   1.8.2-5       Structured File Library - runtime 
ii  libgtk2.0-0                2.2.4-3       The GTK+ graphical user interface 
ii  libjpeg62                  6b-9          The Independent JPEG Group's JPEG 
ii  liborbit2                  1:2.8.3-2     libraries for ORBit2 - a CORBA ORB
ii  libpango1.0-0              1.2.5-2.1     Layout and rendering of internatio
ii  libpopt0                   1.7-4         lib for parsing cmdline parameters
ii  libpq3                     7.4.1-1       Shared library libpq.so.3 for Post
ii  libtasn1-0                 0.1.2-1       Manage ASN.1 structures (runtime)
ii  libxml2                    2.6.3-1       GNOME XML library
ii  libxslt1.1                 1.1.2-1       XSLT processing library - runtime 
ii  scrollkeeper               0.3.14-2      A free electronic cataloging syste
ii  xlibs                      4.3.0-0pre1v4 X Window System client libraries
ii  zlib1g                     1:1.2.1-3     compression library - runtime

-- no debconf information



--- End Message ---
--- Begin Message ---
Source: planner
Source-Version: 0.14.4-1

We believe that the bug you reported is fixed in the latest version of
planner, which is due to be installed in the Debian FTP archive:

planner-dev_0.14.4-1_i386.deb
  to pool/main/p/planner/planner-dev_0.14.4-1_i386.deb
planner_0.14.4-1.diff.gz
  to pool/main/p/planner/planner_0.14.4-1.diff.gz
planner_0.14.4-1.dsc
  to pool/main/p/planner/planner_0.14.4-1.dsc
planner_0.14.4-1_i386.deb
  to pool/main/p/planner/planner_0.14.4-1_i386.deb
planner_0.14.4.orig.tar.gz
  to pool/main/p/planner/planner_0.14.4.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.
Xavier Oswald <[email protected]> (supplier of updated planner 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.8
Date: Wed, 22 Apr 2009 23:05:52 +0200
Source: planner
Binary: planner planner-dev
Architecture: source i386
Version: 0.14.4-1
Distribution: unstable
Urgency: low
Maintainer: Xavier Oswald <[email protected]>
Changed-By: Xavier Oswald <[email protected]>
Description: 
 planner    - project management application
 planner-dev - Planner development library
Closes: 227251 516747
Changes: 
 planner (0.14.4-1) unstable; urgency=low
 .
   * New upstream release
   * New maintainer is me
   * Update debian/compat to 7
   * debian/control:
     - Remove DM flag
     + Update debhelper to 7
     + Update Standards-Version to 3.8.1
   * Update debian/copyright
   * Fix lintian warnings:
     W: planner: command-with-path-in-maintainer-script postrm:38
     /usr/bin/update-mime-database
     W: planner: command-with-path-in-maintainer-script postinst:33
     /usr/bin/update-mime-database
     W: planner: desktop-mimetype-without-update-call
     /usr/share/applications/planner.desktop
   * Fix FTBFS in unstable(Closes: #516747) fixed upstream
   * Fix Single quotes problems with databases  (Closes: #227251) fixed upstream
Checksums-Sha1: 
 059c2cda0411099855c03f603d5a38dc00de55f3 1552 planner_0.14.4-1.dsc
 827bf6670b5b53ae4cf1e0e958beb3a24041d123 4443689 planner_0.14.4.orig.tar.gz
 ecf4d72074f74bdb5e46726d8a62bb22a803e27e 9172 planner_0.14.4-1.diff.gz
 45c5270828ef0d9cad0b1761496fe29f879a00b7 3758462 planner_0.14.4-1_i386.deb
 d83db756646e66fcc750f70e325cc1a739308239 55304 planner-dev_0.14.4-1_i386.deb
Checksums-Sha256: 
 1f3e305cd8e58adeac2ffc7e496215bcd527edd32725117978fa4b96553ce8b6 1552 
planner_0.14.4-1.dsc
 ac427140d42725d6bf622ec6fa39c594e6505573a1af7554980484fe32c8c46a 4443689 
planner_0.14.4.orig.tar.gz
 9613da4e3e18162da9839b1cff82df81e9c089c2791f70b8310f0578731c65cd 9172 
planner_0.14.4-1.diff.gz
 cc002984f42f044fa747263952c86b5fc7af931af9bf2ecd3df92bee348381b9 3758462 
planner_0.14.4-1_i386.deb
 4ef830780e1dd94a6695d1e4f31e8ca651502f1048f3570a5685299f342d8e68 55304 
planner-dev_0.14.4-1_i386.deb
Files: 
 afd6c4ee0342bbcf235321f4791c2963 1552 gnome optional planner_0.14.4-1.dsc
 65f89cc853fcad9c81a0718be74d1f3a 4443689 gnome optional 
planner_0.14.4.orig.tar.gz
 91f4ac334f8742c02111e09aaf0f6228 9172 gnome optional planner_0.14.4-1.diff.gz
 ce1b12ec954539a4f7ff2bdde4a77486 3758462 gnome optional 
planner_0.14.4-1_i386.deb
 9f20a089397ea60b4101e154cac70777 55304 libdevel optional 
planner-dev_0.14.4-1_i386.deb

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAknvm50ACgkQpDDGqoi7tR6wfQCeOkGMSXu7aDdhHk4MzRfmSAPs
+sYAniJOKr3NnJf4szbTB+lPwl3/TVaA
=L0CD
-----END PGP SIGNATURE-----



--- End Message ---

Reply via email to