Hi Nick, I have incorporated your recommended changes to the schema in the trunk here: http://exim4u.org/svn/exim4u_src/trunk/mysql_setup/mysql.sql I have also added a script to update existing installations: http://exim4u.org/svn/exim4u_src/trunk/mysql_migrate/mysql_expand_crypt.sql Thanks for the feedback and recommendations! Gordon On 12/20/2011 08:44 AM, Nick Keefen wrote:
hi list!
probably encountered by many, and mentioned a few times on this mailing list, but AFAIK never actually fixed - i just downloaded the latest stable release 2.0.1 and tried it with PHP 5.3.6-13ubuntu3.3 in Ubuntu 11.10.
Create the default DB, log in with siteadmin/CHANGE, change the password. It fails right away and won't let you in any more.
The below thread mentions a hack to disable salt. Doesn't seem like the right thing to do, and didn't help me either.
http://users.exim4u.org/Fwd-Re-crypt-field-not-been-populated-during-user-cr...
A short dig into the code shows that crypt_password('any string') with the default MD5 method returns a 200 symbol line instead of the old 48 symbols, probably due to the new MD5 code in PHP 5.3.
The problem here is the default exim4u database schema:
crypt varchar(48) default NULL,
The default field size is simply too short - the new encrypted password was not saved properly, which killed it.
Increase crypt to varchar(255) and it'll work right away. No code hacking necessary.
I believe this should be updated in the installation SQL file as well.
Regards, Nick Keefen, NK Support http://www.nksupport.com/
_______________________________________________ users mailing list users(a)exim4u.org https://exim4u.org/mailman/listinfo/users