Package: libapache2-mod-auth-mysql
Version: 4.3.9-2.dotdeb.0
Severity: normal
Tags: l10n
the module ignores charset / collation settings in /etc/my.cnf
this causes queries to fail if groups are searched in blob fields which
are stored in utf8 format:
ERROR 1267 (HY000): Illegal mix of collations
(latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for
operation 'find_in_set'
genereated query:
SELECT count(*) FROM be_users, be_groups WHERE username='testuser' and
FIND_IN_SET('Members',title) AND be_groups.deleted=0;
this query will work in the mysql command line client, phpMyAdmin and so
on. it does not work with the module only.
changing the name of the group field (in above case 'title') to the
expected swedisch charset will make it work, but this is only a
workaround.
-- System Information:
Debian Release: 3.1
Architecture: i386 (i686)
Kernel: Linux 2.6.8-2-k7
Locale: LANG=de_CH, LC_CTYPE=de_CH (charmap=ISO-8859-1)
Versions of packages libapache2-mod-auth-mysql depends on:
ii apache2-common 2.0.54-5 next generation, scalable, extenda
ii libc6 2.3.2.ds1-22 GNU C Library: Shared libraries an
ii libmysqlclient14 4.1.15-0.dotdeb.1 mysql database client library
-- no debconf information
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
