Your message dated Sat, 13 Jan 2018 12:19:29 +0000
with message-id <e1eakmx-0005yt...@fasolo.debian.org>
and subject line Bug#850085: fixed in kmymoney 4.8.1.1-1
has caused the Debian Bug report #850085,
regarding kmymoney: MySQL backend not working
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 ow...@bugs.debian.org
immediately.)


-- 
850085: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=850085
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Package: kmymoney
Version: 4.8.0-2
Severity: normal
Tags: patch upstream

Hello,

The MySQL backend of KMyMoney doesn't work currently, because one of the
database fields is called "order" and the name is quoted in
a MySQL-unsafe manner. This was tracked in the upstream bug #365615 [1]
and was patched for 4.8 in 20191b3d1b662cd8e0d5775799ff51a39cd68e47 [2].
Please consider applying the patch in Debian.

[1] https://bugs.kde.org/show_bug.cgi?id=365615
[2] 
https://cgit.kde.org/kmymoney.git/commit/?id=20191b3d1b662cd8e0d5775799ff51a39cd68e47

Note: it is possible to work-around this issue on the MySQL server side
by issuing SET GLOBAL sql_mode = 'ANSI_QUOTES';. This affects all users,
databases and session thought, see [3].

[3] https://dev.mysql.com/doc/refman/5.5/en/sql-mode.html#sqlmode_ansi_quotes


-- System Information:
Debian Release: stretch/sid
  APT prefers testing
  APT policy: (990, 'testing'), (990, 'stable'), (500, 'unstable'), (100, 
'experimental')
Architecture: i386 (x86_64)
Foreign Architectures: amd64

Kernel: Linux 4.8.0-1-amd64 (SMP w/4 CPU cores)
Locale: LANG=pl_PL, LC_CTYPE=pl_PL (charmap=ISO-8859-2) (ignored: LC_ALL set to 
pl_PL)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages kmymoney depends on:
ii  kde-runtime             4:16.08.3-1
ii  kdepim-runtime          4:16.04.2-2
ii  kmymoney-common         4.8.0-2
ii  libakonadi-kde4         4:4.14.10-7
ii  libalkimia5             5.0.0-3
ii  libaqbanking35          5.6.12-1
ii  libaqbanking35-plugins  5.6.12-1
ii  libc6                   2.24-8
ii  libgcc1                 1:6.2.1-5
ii  libgmp10                2:6.1.2+dfsg-1
ii  libgpgme++2v5           4:4.14.10-7
ii  libgwengui-cpp0         4.15.3-5
ii  libgwengui-qt4-0        4.15.3-5
ii  libgwenhywfar60         4.15.3-5
ii  libical2                2.0.0-0.5+b1
ii  libkabc4                4:4.14.10-7
ii  libkcmutils4            4:4.14.26-1
ii  libkdecore5             4:4.14.26-1
ii  libkdeui5               4:4.14.26-1
ii  libkfile4               4:4.14.26-1
ii  libkholidays4           4:4.14.10-7
ii  libkhtml5               4:4.14.26-1
ii  libkio5                 4:4.14.26-1
ii  libkpimidentities4      4:4.14.10-7
ii  libkrosscore4           4:4.14.26-1
ii  libofx6                 1:0.9.10-1+b1
ii  libqt4-dbus             4:4.8.7+dfsg-11
ii  libqt4-declarative      4:4.8.7+dfsg-11
ii  libqt4-network          4:4.8.7+dfsg-11
ii  libqt4-sql              4:4.8.7+dfsg-11
ii  libqt4-svg              4:4.8.7+dfsg-11
ii  libqt4-xml              4:4.8.7+dfsg-11
ii  libqtcore4              4:4.8.7+dfsg-11
ii  libqtgui4               4:4.8.7+dfsg-11
ii  libstdc++6              6.2.1-5

Versions of packages kmymoney recommends:
ii  gnupg-agent   2.1.16-3
pn  pinentry-qt4  <none>

kmymoney suggests no packages.

-- no debconf information

--- End Message ---
--- Begin Message ---
Source: kmymoney
Source-Version: 4.8.1.1-1

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

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 850...@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Pino Toscano <p...@debian.org> (supplier of updated kmymoney 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 ftpmas...@ftp-master.debian.org)


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

Format: 1.8
Date: Sat, 13 Jan 2018 12:58:47 +0100
Source: kmymoney
Binary: kmymoney kmymoney-common
Architecture: source
Version: 4.8.1.1-1
Distribution: unstable
Urgency: medium
Maintainer: Debian KDE Extras Team <pkg-kde-extras@lists.alioth.debian.org>
Changed-By: Pino Toscano <p...@debian.org>
Description:
 kmymoney   - personal finance manager for KDE
 kmymoney-common - KMyMoney architecture independent files
Closes: 850085
Changes:
 kmymoney (4.8.1.1-1) unstable; urgency=medium
 .
   * Team upload.
   * New upstream release:
     - the MySQL backend works again (Closes: #850085)
   * Update the patches:
     - upstream_cmake-do-not-install-the-appdata-as-executable.patch: drop,
       backported from upstream
     - upstream_cmake-fix-appdata-installation-directory.patch: drop, backported
       from upstream
     - upstream_Added-versioning-to-kmm_payeeidentifier-library.patch: drop,
       backported from upstream
     - upstream_Fix-duplicated-symbol-compile-error-on-Windows.patch: drop,
       backported from upstream
     - upstream_Fix-Compile-error-on-Fedora-26.patch: drop, backported from
       upstream
     - upstream_Fix-compilation-with-CMake-3.9.patch: drop, backported from
       upstream
   * Update install files.
   * Move the appdata file to the metainfo directory.
   * Remove the kmymoney-dev binary, since there is no stable API/ABI
     - make sure to not ship development stuff
   * Drop man-*.docbook translations, since they only helper for translating
     man pages.
   * Update lintian overrides.
   * Bump Standards-Version to 4.1.3, no changes required.
   * Make sure to call dh_auto_configure using the 'kde' buildsystem.
   * Use the ${perl:Depends} substvar in kmymoney-common.
   * Switch Homepage to https://kmymoney.org/.
   * Add pinentry-x11 as alternative for the pinentry-qt recommend, so other
     pinentry GUIs can be used.
Checksums-Sha1:
 138f186f70c425e26bc295bcb5e8033962957f4b 2294 kmymoney_4.8.1.1-1.dsc
 c0adebecc1069396f043a199247a1b6c8eb7f210 20963444 kmymoney_4.8.1.1.orig.tar.xz
 fe50e3c1881c4488fb6f10f69b5b61b3985a73ea 10832 kmymoney_4.8.1.1-1.debian.tar.xz
 4f33102082fcc41dedef7da373c94069b8e5eed3 20711 
kmymoney_4.8.1.1-1_source.buildinfo
Checksums-Sha256:
 8857b336ca58679b147380593cfca595b43e7de97836e0bd1c4985250a999d54 2294 
kmymoney_4.8.1.1-1.dsc
 2b1cbd141d51a3f4147c30c00c7d21022e761d8121f5a206092cf3548f805a34 20963444 
kmymoney_4.8.1.1.orig.tar.xz
 4f08e0561285cbdf117e2bed48e268d4e569e105f07d9b29413f7d370c269926 10832 
kmymoney_4.8.1.1-1.debian.tar.xz
 cc6851ed0f597ee6ed351be843d414878eec2568ebb9478fd21c01b1b5aa9d82 20711 
kmymoney_4.8.1.1-1_source.buildinfo
Files:
 5b8141f121555d434f9a7c9760fe7198 2294 kde optional kmymoney_4.8.1.1-1.dsc
 d7327184855fd88942e33428ce205b31 20963444 kde optional 
kmymoney_4.8.1.1.orig.tar.xz
 7c2b5e5999378d43e2af374f5c8f8fa7 10832 kde optional 
kmymoney_4.8.1.1-1.debian.tar.xz
 75df5290524795c52ebf4a548698bbf1 20711 kde optional 
kmymoney_4.8.1.1-1_source.buildinfo

-----BEGIN PGP SIGNATURE-----

iQIzBAEBCgAdFiEEXyqfuC+mweEHcAcHLRkciEOxP00FAlpZ9QAACgkQLRkciEOx
P03FLg/+NPFXcJFZak13EQyNdm7a+S7XgFzJkTx95vHLp8UYogcdYa1fhe4oCo4z
vjJKfn+DCpIINWgeJoFehLjB967UjgfiJeLzQ9bcpn77bQ4c8BVfCtkpWuf2BOw4
nqW5TwdsKHgDZUHX1YXSJGMndqKjgdrgf3XL6bAmPUrS72sflpkwzaU+9qItkcHC
7t+AiNHrFfnl7qR2PDC0F4i5LDm360ZDU52p9qJUyGaR6UKVgXo5AeM1hZDIWE0n
gqv24oiqmMv9XVqpkywrebmIIYzo9SXsPYIKyOu+mqSR7JrAmNaxNQMXR03sx1VF
UsWbpDj4G8aTXyXsHTnS/sL0X8ky9FFXKvgghP5HJJu9pOhsHl2yttbUEhL3M9jE
aZqCCuFc2R6tl0076KICNDiYqytj7bfy/2xEny20jFdwgp4xa6NO92uoi1TW+bij
JHye27mTusqVlVlTjp1K8GqJDnpVkI4rNzjM6p8sLD3TogB7SVjKy71qGEgMBgq2
AbFlrAz1ohn/tz8xUasoMvKYw8z6t7hec+Ok2wi1T4NDmAdb+SdyMpD1G/69png4
8VZsGkL1O29Kt5+IDZJAUBKiXUs8EbZXDwr7AWOiKjcUMXtm8/CiuWajOFYkOWwe
At4sQBoU1U5d9RX16FbE1w42rlWv8AS4zLgYTLcSkr1YFhqNLhs=
=cXeA
-----END PGP SIGNATURE-----

--- End Message ---
_______________________________________________
pkg-kde-extras mailing list
pkg-kde-extras@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-kde-extras

Reply via email to