Your message dated Thu, 06 Jan 2011 21:48:08 +0000
with message-id <[email protected]>
and subject line Bug#605513: fixed in pwman3 0.0.8-1
has caused the Debian Bug report #605513,
regarding pwman3: filter command does not work with sqlite backend
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.)
--
605513: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=605513
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: pwman3
Version: 0.0.7-2
Severity: normal
Tags: patch
filter command does not work when using the sqlite backend (which is the
default) because sqlite does not support OUTER JOIN
See it in action :
$ pwman3
Pwman3 0.0.7 (c) Ivan Kelly <[email protected]>
pwman> list
Current tags: None
Please enter your password:
1. u...@host1 host1, user
2. u...@host2 host2, user
3. r...@host2 host2, root
pwman> filter root
Current tags: root
pwman> list
Current tags: root
Error: SQLite: RIGHT and FULL OUTER JOINs are not currently supported
LEFT JOIN can be used instead (this is the case for mysql & postgresql backend)
in /usr/share/pyshared/pwman/data/drivers/sqlite.py
Here is the patch :
$ diff -u sqlite.py.dist sqlite.py.patched
--- sqlite.py.dist 2010-11-30 21:41:54.000000000 +0100
+++ sqlite.py.patched 2010-11-30 21:46:52.000000000 +0100
@@ -67,7 +67,7 @@
else:
first = False
- sql += ("SELECT NODE FROM LOOKUP OUTER JOIN TAGS ON TAG =
TAGS.ID "
+ sql += ("SELECT NODE FROM LOOKUP LEFT JOIN TAGS ON TAG =
TAGS.ID "
+ " WHERE TAGS.DATA = ?")
params.append(cPickle.dumps(t))
sql += ") EXCEPT SELECT DATA FROM TAGS WHERE "
@@ -164,7 +164,7 @@
sql += " INTERSECT "
else:
first = False
- sql += ("SELECT NODE FROM LOOKUP OUTER JOIN TAGS ON TAG =
TAGS.ID"
+ sql += ("SELECT NODE FROM LOOKUP LEFT JOIN TAGS ON TAG =
TAGS.ID"
+ " WHERE TAGS.DATA = ? ")
params.append(cPickle.dumps(t))
-G.-
-- System Information:
Debian Release: squeeze/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.32-5-openvz-686 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages pwman3 depends on:
ii python 2.6.6-3+squeeze1 interactive high-level object-orie
ii python-crypto 2.1.0-2 cryptographic algorithms and proto
ii python-support 1.0.10 automated rebuilding support for P
Versions of packages pwman3 recommends:
ii python-mysqldb 1.2.2-10+b1 A Python interface to MySQL
ii python-pygresql 1:4.0-2+b1 PostgreSQL module for Python
Versions of packages pwman3 suggests:
pn mysql-server | postgresql <none> (no description available)
-- no debconf information
--- End Message ---
--- Begin Message ---
Source: pwman3
Source-Version: 0.0.8-1
We believe that the bug you reported is fixed in the latest version of
pwman3, which is due to be installed in the Debian FTP archive:
pwman3_0.0.8-1.debian.tar.gz
to main/p/pwman3/pwman3_0.0.8-1.debian.tar.gz
pwman3_0.0.8-1.dsc
to main/p/pwman3/pwman3_0.0.8-1.dsc
pwman3_0.0.8-1_all.deb
to main/p/pwman3/pwman3_0.0.8-1_all.deb
pwman3_0.0.8.orig.tar.gz
to main/p/pwman3/pwman3_0.0.8.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.
Emmanuel Bouthenot <[email protected]> (supplier of updated pwman3 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: SHA512
Format: 1.8
Date: Sun, 05 Sep 2010 17:09:52 +0200
Source: pwman3
Binary: pwman3
Architecture: source all
Version: 0.0.8-1
Distribution: unstable
Urgency: low
Maintainer: Emmanuel Bouthenot <[email protected]>
Changed-By: Emmanuel Bouthenot <[email protected]>
Description:
pwman3 - console password managment application
Closes: 594928 605513
Changes:
pwman3 (0.0.8-1) unstable; urgency=low
.
* New upstream release:
- a patch for a better output in list mode (detection of the
number of columns and rows used by the terminal) has been merged
upstream. Thanks to Dominic Hargreaves for the suggestion (Closes:
#594928).
* Remove uselsess build dependency on python-dev.
* Update Standards-Version to 3.9.1.
* Update uploader email.
* Update Vcs-Browser and Vcs-Git fields.
* Switch to dpkg-source 3.0 (quilt) format.
* Remove unneeded DMUA field.
* Update copyright file (new year changes, new copyright holders).
* Add a patch to fix the filter command when used with the sqlite backend.
Thanks to Guillaume L. for the patch (Closes: #605513).
* Remove unused lintian override.
Checksums-Sha1:
6774058ab3d79c803e8bd0d3ff9d074b1bef2e7c 1803 pwman3_0.0.8-1.dsc
2684b9c258022aaedf0958c61efce9f917d8c18f 30880 pwman3_0.0.8.orig.tar.gz
edbbca31d8a62f4877d3ba6e28479d15c1ba636e 4305 pwman3_0.0.8-1.debian.tar.gz
5c77201a74c23312686205f54375c7781a3b8315 35254 pwman3_0.0.8-1_all.deb
Checksums-Sha256:
3e8a7a9d8e1aa22f2f9da5617be94ffe443f1bab5a4eaa19250bc5060a6468e3 1803
pwman3_0.0.8-1.dsc
e68d5336b21466de9ab8895661f0966697f0054a7002f364f6c78f8312bf1e6b 30880
pwman3_0.0.8.orig.tar.gz
974057975bc07a5ee639e319eae0ed13f39f6089d897b872ccd3eba1e2728637 4305
pwman3_0.0.8-1.debian.tar.gz
e059bfbad07d284fd412c1adb76ae4b1b2dee63ffaa88b388cb856a3029b193e 35254
pwman3_0.0.8-1_all.deb
Files:
e35985db1b9f9f0efebef5ff5d7f957b 1803 utils optional pwman3_0.0.8-1.dsc
abaf67da405087707a59ac95b8692fe6 30880 utils optional pwman3_0.0.8.orig.tar.gz
d42bc475460c2f88bc984dedc9ce063b 4305 utils optional
pwman3_0.0.8-1.debian.tar.gz
6e37e9f4c389d34ef17c889daaa39fcc 35254 utils optional pwman3_0.0.8-1_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
iQIcBAEBCgAGBQJNJjYBAAoJEEsHdyOSnULDX2cP/RT45yx9CsPFN9uTDlRQzTts
e4WuNWM/h/GTZ5NBFmwPp6QVxw7HSw1gQ+v6vNhmFY8kM8rBPB6J4lqgAtxTJ3lL
KNUSR/AGlzlyr1AF64mkMky2ZJahrskaMyVdG70ZZxCIxP7fXUC5XbVU4kXz+17f
7MQTjubY1NXE44tcUwM5ys4AbA4jbOVCBhfftyyEqc+iqgLonZUBBOZDgReKoGHJ
T7FdLSS+jWu4wsCYpck8vdTXLaIpQbLbfqb1HFAd/Zh32OwaJfumuZA95wwguoXp
UGQurBrW8hwXKw5vW7RzeN+nzx1nBOv8RsQgHHXiudEmMSGJu/Y6TmOJZZrzkNOG
3yjg2fOEG3rbv0ACny7WY3nY8l5AxJZ2nsKiwIU1wqzasGeQwbVnkmd203rNWCXb
CI3WvPcJE49LofsUussQyqgSa14ElFP6+BCALLe3eA2c6pYTtNT5WSg1yNYE5q5E
ObF9OBNFDHf9Mq5gvPNL+zN4tMWuOjH0BvEG79I/0slEBaaSQReBeNbVjd4blvCS
hPOiVi4YxjOyXQRpnyw5PwZyHSYPUokYO91pUaaQrr9Seo/sOILH10pyRfbnOUBZ
oIpGsEKIRO5VU+jWoGU5eNevDiGnLXmPbtQbIMm6goJVwxI6rGjRu0pXCv7aTNXQ
jCmECdb5xy3s65HAwZSC
=c9KK
-----END PGP SIGNATURE-----
--- End Message ---
