----- Forwarded message from ossi <[EMAIL PROTECTED]> ----- From: ossi <[EMAIL PROTECTED]> To: 'Matthew Palmer' <[EMAIL PROTECTED]> Subject: AW: Bug#356530: libapache2-mod-auth-mysql: module does not respect collation and/or charset settings Date: Mon, 13 Mar 2006 08:46:07 +0100
Hallo Thanks for your answer :) It is true some packages seem not be be sarge-original. I will try to get my gold old virtual pc running, but I cannot promise those packages aint the same wrong ones (same configurations all over). I agree the thing with the blob is strange. But I authenticate the users against an existing user/group structure (typo3). And the group field is a blob for whatever reason. Not much choice. I have no real c programming skills. So I dont know what's possible to tweak. But I accidentally posted this bug into the wrong bug-tracker (another auth_mysql module): http://modauthmysql.sourceforge.net/CONFIGURE This module has an option: AuthMySQLCharacterSet <no default> Which might be the way to go? I dont know why the setting in the [client] section of /etc/my.cnf is ignored. Might be some bug in a library as well (since I set any mysql variable to utf8 too, so where the Swedish comes from...?). Maybe the database was installed with different settings and changing the system default language / charsets affected this in some way? Well short version: I just dont know :) To live in a safer world the clients need to make sure things are correct (since that other module seem to have similar problems). I will try to reproduce this with another Debian system. But I cannot promise this is done quickly (since the linux noob: it is me!) If I can help you with additional tests or information please ask. Thanks a lot Kind regards Ossi -----Ursprüngliche Nachricht----- Von: Matthew Palmer [mailto:[EMAIL PROTECTED] Gesendet: Sonntag, 12. März 2006 21:02 An: ossi petz; [EMAIL PROTECTED] Betreff: Re: Bug#356530: libapache2-mod-auth-mysql: module does not respect collation and/or charset settings On Sun, Mar 12, 2006 at 04:23:41PM +0100, ossi petz wrote: > Package: libapache2-mod-auth-mysql > Version: 4.3.9-2.dotdeb.0 This is not a Debian-released version of this package. Can you please attempt to reproduce this bug on an entirely Debian system, just for completeness? > 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: Considering that the list of groups is supposed to be text anyway, shouldn't the field (if you've got *that* many groups) be a TEXT type rather than a BLOB? At any rate, you sound like you know a fair bit more about this sort of thing than me -- can you provide a patch or suggestion for where to start looking in the API for a solution to this problem? The module doesn't set any fancy MySQL options or anything, it just uses the standard function calls to talk to MySQL. What do I have to call to make this all work (and I wonder why it isn't some sort of default)? - Matt ----- End forwarded message -----
