#4 MySQL 4.1.x and DEFAULT CHARACTER SET

closed
None
5
2005-02-25
2004-10-12
No

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;
}

Discussion

  • Jerry Stuckle

    Jerry Stuckle - 2004-10-12

    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

     
  • Jerry Stuckle

    Jerry Stuckle - 2004-10-12

    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

     
  • Jerry Stuckle

    Jerry Stuckle - 2004-10-12
    • assigned_to: nobody --> jstuckle
     
  • Jerry Stuckle

    Jerry Stuckle - 2004-12-16

    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

     
  • Jerry Stuckle

    Jerry Stuckle - 2004-12-16

    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

     
  • Jerry Stuckle

    Jerry Stuckle - 2005-02-25
    • status: open --> closed
     
  • Jerry Stuckle

    Jerry Stuckle - 2005-02-25

    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.

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks