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 [EMAIL PROTECTED] 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
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
