Public bug reported: Hello,
I'm running Ubuntu server 10.04 AMD64 with libapache2-mod-auth-mysql (4.3.9-12ubuntu1). Encryption is set to PHP_MD5. Accounts passwors are md5 encoded using PHP and stored in a mysql database (5.1.63-0ubuntu0.10.04.1). The database is in UTF-8 (utf8_general_ci) so the mysql connection. If, a password doesn't contain any special caracter (accentued one : eg. àéèùïë ...), auth will work fine. It it contain one or more, it doesn't work (auth is refused). I tested the auth using PHP and MD5, but it seems that auth-mysql PHP_MD5 either doesn't like special chars and/or utf-8. I can't upgrade this server to precise yet so I don't know if it works under Ubuntu 12.04 but looking at the changelog, it shouldn't work as well. Is there a way to fix it ? Regards, Guillaume ** Affects: mod-auth-mysql (Ubuntu) Importance: Undecided Status: New ** Description changed: Hello, I'm running Ubuntu server 10.04 AMD64 with libapache2-mod-auth-mysql (4.3.9-12ubuntu1). Encryption is set to PHP_MD5. - Accounts passwors are md5 encoded using PHP et stored in a mysql database (5.1.63-0ubuntu0.10.04.1). + Accounts passwors are md5 encoded using PHP and stored in a mysql database (5.1.63-0ubuntu0.10.04.1). The database is in UTF-8 (utf8_general_ci) so the mysql connection. If, a password doesn't contain any special caracter (accentued one : eg. àéèùïë ...), auth will work fine. It it contain one or more, it doesn't work (auth is refused). I tested the auth using PHP and MD5, but it seems that auth-mysql PHP_MD either doesn't like special chars and/or utf-8. I can't upgrade this server to precise yet so I don't know if it works under Ubuntu 12.04 but looking at the changelog, it shouldn't work as well. Is there a way to fix it ? Regards, Guillaume ** Description changed: Hello, I'm running Ubuntu server 10.04 AMD64 with libapache2-mod-auth-mysql (4.3.9-12ubuntu1). Encryption is set to PHP_MD5. Accounts passwors are md5 encoded using PHP and stored in a mysql database (5.1.63-0ubuntu0.10.04.1). The database is in UTF-8 (utf8_general_ci) so the mysql connection. If, a password doesn't contain any special caracter (accentued one : eg. àéèùïë ...), auth will work fine. It it contain one or more, it doesn't work (auth is refused). - I tested the auth using PHP and MD5, but it seems that auth-mysql PHP_MD - either doesn't like special chars and/or utf-8. + I tested the auth using PHP and MD5, but it seems that auth-mysql + PHP_MD5 either doesn't like special chars and/or utf-8. I can't upgrade this server to precise yet so I don't know if it works under Ubuntu 12.04 but looking at the changelog, it shouldn't work as well. Is there a way to fix it ? Regards, Guillaume -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1042263 Title: Error with special characters in users passwords To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mod-auth-mysql/+bug/1042263/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs