Reset Password Doesn't Work

[fchintc]

Hi,

I am using CMSMS 1.1.4.1 and after transfer of the site to another, the login password does not work. The following SQL command to reset the password to 'admin' does not work:-

UPDATE cms_users SET password = '21232f297a57a5a743894a0e4a801fc3' WHERE user_id = 1;

Any ideas how to solve the problem?

Thanks.

- Frederick

[alby]

I am using CMSMS 1.1.4.1 and after transfer of the site to another, the login password does not work. The following SQL command to reset the password to 'admin' does not work:-

UPDATE cms_users SET password = '21232f297a57a5a743894a0e4a801fc3' WHERE user_id = 1;

Any ideas how to solve the problem?

Check with phpmyadmin if your admin user has user_id = 1

Alby

[fchintc]

>> Check with phpmyadmin if your admin user has user_id = 1

Yes. Does using PHP 5.x and MYSQL 5.x have any affect on CMSMS? My previous web site was hosted using PHP 4.x and MYSQL 4.x.

- Frederick

[tsw]

'does not work'

meaning it gives you an error or the update is successfull, but you still cant login?

[fchintc]

>> meaning it gives you an error or the update is successfull, but you still cant login?

OK, here is what happened.

1.  Created new web site. (Before that, dump database into SQL script and copied out all folders from previous web site.)
2.  Recreated tables and data from previous into new database, using SQL script.
3.  Copied back folders.
4.  Used Firefox to call admin/login.php.
5.  Entered existing name (XXX) and password (YYY). (No error message, same login page displayed.)
6.  Thought password messed up somehow. Surfed to CMSMS forum to look for answer to reset password.
7.  Found that UPDATE cms_users SET password = '21232f297a57a5a743894a0e4a801fc3' WHERE user_id = 1 should reset password to "admin".
8.  Used SQL to run script above. (Message 1 row affected)
9.  Used Firefox to call admin/login.php and entered my previous user name (XXX) and "admin" for password. (Message: Username or password incorrect)
10.  Checked contents of cms_users table. User name (XXX) is correct and password is "21232f297a57a5a743894a0e4a801fc3".
11.  Interestingly, if I entered my user name (XXX) and using the password before I performed the password reset (YYY), no error message for incorrect username or password is displayed.

Thanks.

- Frederick