[Bug 1042263] [NEW] Error with special characters in users passwords

[Guillaume Hilt]

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
Server Team, which is subscribed to mod-auth-mysql in 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