#4 MySQL 4.1.x and DEFAULT CHARACTER SET
I have MySQL 4.1.x installed and they changed the
default charset, so mod_auth_mysql doesn`t work
anymore. I had to make some changes in the source, I`ll
paste here the code I added, in hope that someone can
change it, I`m not a C coder. You can either add these
lines to your source, or, modify the column collation
to whatever you need.
Code changes ( I won`t add a patch file, as this is
some crappy code ) :
[line 691]
SNPRINTF(query,sizeof(query)-1,"SET CHARACTER SET
latin2");
if (mysql_query(mysql_handle, query) != 0) {
LOG_ERROR2(APLOG_ERR, 0, r, "MySQL ERROR: %s:
%s", mysql_error(mysql_handle), r->uri);
return NULL;
}
[line 782]
SNPRINTF(query,sizeof(query)-1,"SET CHARACTER SET
latin2");
if (mysql_query(mysql_handle, query) != 0) {
LOG_ERROR2(APLOG_ERR, 0, r, "MySQL ERROR: %s:
%s", mysql_error(mysql_handle), r->uri);
return NULL;
}
Logged In: YES
user_id=1049703
Alex,
Thanks for posting the bug report and patch. And your code
looks just fine.
We'll have to figure out the best way to fix this. If anyone
has any suggestions on what they would like to see, we would
appreciate them.
Jerry
Logged In: YES
user_id=1049703
Alex,
Thanks for posting the bug report and patch. And your code
looks just fine.
We'll have to figure out the best way to fix this. If anyone
has any suggestions on what they would like to see, we would
appreciate them.
Jerry
Logged In: YES
user_id=1049703
Moved to Feature Requests.
It isn't a bug in mod_auth_mysql, but a request for a change
to support new features in MySQL.
Jerry
Logged In: YES
user_id=1049703
This change will be implemented in the next release of
mod_auth_mysql, planned for early to middle January.
Jerry
Logged In: YES
user_id=1049703
This has been added to the 2.9.0 Beta version of the code.
To allow for different character sets, a new parameter
AuthMySQLCharacterSet has been added. Thanks for the patch.
Closing.