FreePBX 2.9.0 authentication error due to wrong "password" column in table "ampusers"

I’ve installed from “http://mirror.freepbx.org/freepbx-2.9.0.tar.gz” and couldn’t access “http://localhost/admin” due to authentication error.

I’ve found out the cause was “password” column in table “ampusers” MUST be “password_sha1” VARCHAR(40).

I’ve solved this bug using:

ALTER TABLE ampusers CHANGE password password_sha1 VARCHAR(40);
UPDATE ampusers SET password_sha1=SHA1('admin') WHERE username='admin';

Please file a bug report.

http://www.freepbx.org/trac/ticket/5408