Your message dated Mon, 26 Jan 2009 08:32:21 +0000
with message-id <[email protected]>
and subject line Bug#367535: fixed in pam-mysql 0.7~RC1-3
has caused the Debian Bug report #367535,
regarding libpam-mysql: Problem with "varchar" in WHERE statement
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.)
--
367535: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=367535
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: libpam-mysql
Version: 0.6.2-1
Severity: normal
This is a fragment of config:
auth required /lib/security/pam_mysql.so user=vsftp passwd=xxx db=system
table=passwd \
usercolumn=passwd.id passwdcolumn=passwd.clear [where=passwd.type="ftp"]
Result in /var/log/auth.log:
May 16 18:26:27 localhost vsftpd: pam_mysql - MySQL error(You have an error in
your SQL syntax;
check the manual that corresponds to your MySQL server version for the right
syntax to use
near '\"ftp\")' at line 1)
Result in /var/log/mysql/mysql.log:
060516 18:26:27 1403 Connect vs...@localhost on system
1403 Init DB system
1403 Query SELECT passwd.clear FROM passwd WHERE passwd.id
= 'username' AND (passwd.type=\"ftp\")
Apparently, the problem is releated to \" surrounding "ftp" in config's
additional conditions.
Changing " to ' doesn't solve the problem.
Example of config which contains WHERE cause with TINYINT arument:
auth required /lib/security/pam_mysql.so user=vsftp passwd=xxx db=system
table=passwd \
usercolumn=passwd.id passwdcolumn=passwd.clear where=passwd.type=1
This works perfectly.
-- System Information:
Debian Release: testing/unstable
APT prefers testing
APT policy: (500, 'testing'), (500, 'stable')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.13.2
Locale: LANG=pl_PL, LC_CTYPE=pl_PL (charmap=ISO-8859-2)
Versions of packages libpam-mysql depends on:
ii libc6 2.3.6-7 GNU C Library: Shared libraries
ii libmysqlclient15off 5.0.20-1 mysql database client library
ii zlib1g 1:1.2.3-11 compression library - runtime
libpam-mysql recommends no packages.
-- no debconf information
--- End Message ---
--- Begin Message ---
Source: pam-mysql
Source-Version: 0.7~RC1-3
We believe that the bug you reported is fixed in the latest version of
pam-mysql, which is due to be installed in the Debian FTP archive:
libpam-mysql_0.7~RC1-3_i386.deb
to pool/main/p/pam-mysql/libpam-mysql_0.7~RC1-3_i386.deb
pam-mysql_0.7~RC1-3.diff.gz
to pool/main/p/pam-mysql/pam-mysql_0.7~RC1-3.diff.gz
pam-mysql_0.7~RC1-3.dsc
to pool/main/p/pam-mysql/pam-mysql_0.7~RC1-3.dsc
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.
Lars Bahner <[email protected]> (supplier of updated pam-mysql 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: Mon, 26 Jan 2009 08:36:06 +0100
Source: pam-mysql
Binary: libpam-mysql
Architecture: source i386
Version: 0.7~RC1-3
Distribution: experimental
Urgency: low
Maintainer: Paweł Więcek <[email protected]>
Changed-By: Lars Bahner <[email protected]>
Description:
libpam-mysql - PAM module allowing authentication from a MySQL server
Closes: 238478 367535 368653 490772
Changes:
pam-mysql (0.7~RC1-3) experimental; urgency=low
.
* debconf
* more cleanup
* added -f switch to rm in rules (closes: #490772)
* New version fixes bugs (closes: #367535, #368653, #238478)
Checksums-Sha1:
48231914344071e949ae782764a67b3e10d7e183 1077 pam-mysql_0.7~RC1-3.dsc
031698222cea0f42d6510ac195fdb8f9517de5d8 4315 pam-mysql_0.7~RC1-3.diff.gz
70ddca7dc3b711e05503f39c9b80d1ec0ea8ca78 33248 libpam-mysql_0.7~RC1-3_i386.deb
Checksums-Sha256:
6dbd6a74d751c618597c4ca2819750260a001817c0b4ba74d5472f3581f92db9 1077
pam-mysql_0.7~RC1-3.dsc
f0c30656095f27cce1153b41e303098505df19762b73ddde2065de8204fac8ed 4315
pam-mysql_0.7~RC1-3.diff.gz
411fadb62d1b9e872d25d0d106ce00dacbe4244fa31588b28a5fd6e7569a5679 33248
libpam-mysql_0.7~RC1-3_i386.deb
Files:
81cae625b35f6622fe2471649394f220 1077 admin extra pam-mysql_0.7~RC1-3.dsc
c6621d26e24381365889e0221d6347d6 4315 admin extra pam-mysql_0.7~RC1-3.diff.gz
be72b96fffa9442c73fdcc974c64a3b2 33248 admin extra
libpam-mysql_0.7~RC1-3_i386.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
iEYEARECAAYFAkl9ah0ACgkQmXJ8FFTsuK/TSQCgsb0ZwNObqEcjkjnT+yniTgsA
wX0An0Tuj3TvNiQR396gQ+3QQwD+peFg
=mK1v
-----END PGP SIGNATURE-----
--- End Message ---
