after i managed to successfully authenticate the users i tried to use the groups feature as well (using typo3 cms).
but the group query fails as of this error:
ERROR 1267 (HY000): Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'find_in_set'
the mysql find_in_set function is used to find the configured group (in .htaccess 'require group Members') in the group field in my table ('title'):
SELECT count(*) FROM be_users, be_groups WHERE username='testuser' and FIND_IN_SET('Members',title) AND be_groups.deleted=0;
the query itself works on almost any client (dbvis, phpmyadmin, and the mysql command line tool if the charset is set to utf8). the query fails when the charset is set to latin1 (which is the command line tool default).
#default-character-set=utf8
is there a way to tell auth_mod_mysql which charset to use??
the table and database is created with utf8(_general_ci) and i do not really intend to change that.
any hints would be welcome :)
thanks a lot
ossi
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
after lookong in the docs on the configure page i noticed i am using some other auth_mysql module?
there is an option 'AuthMySQLCharacterSet' which is not available in my version ( Invalid command 'AuthMySQLCharacterSet')
also the options available look like Auth_MySQL_...
so if someone knows where the debian (sarge) module comes from... tell me :-)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
hallo
after i managed to successfully authenticate the users i tried to use the groups feature as well (using typo3 cms).
but the group query fails as of this error:
ERROR 1267 (HY000): Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'find_in_set'
the mysql find_in_set function is used to find the configured group (in .htaccess 'require group Members') in the group field in my table ('title'):
SELECT count(*) FROM be_users, be_groups WHERE username='testuser' and FIND_IN_SET('Members',title) AND be_groups.deleted=0;
the query itself works on almost any client (dbvis, phpmyadmin, and the mysql command line tool if the charset is set to utf8). the query fails when the charset is set to latin1 (which is the command line tool default).
#default-character-set=utf8
is there a way to tell auth_mod_mysql which charset to use??
the table and database is created with utf8(_general_ci) and i do not really intend to change that.
any hints would be welcome :)
thanks a lot
ossi
well well well
after lookong in the docs on the configure page i noticed i am using some other auth_mysql module?
there is an option 'AuthMySQLCharacterSet' which is not available in my version ( Invalid command 'AuthMySQLCharacterSet')
also the options available look like Auth_MySQL_...
so if someone knows where the debian (sarge) module comes from... tell me :-)
There are at least two other versions of mod_auth_mysql running around. Yes, it does look like you are using one of the other versions.