Password reset not working - new password dos't seem to take

ℹ️ Support
1

Hi

I am trying to test the RSS plugin on my personal install, but I can’t seem to log in. I am trying the password reset - the email gets sent and the reset appears successfully but then when I come to login the password doesn’t work.

I know how to change this in the DB but am just intrigued as to why it isn’t working for me :smile:

A
x

2

I haven’t used the rss plugin, but to change your password in the database, you can go search for your email address in the phplist_admin table, and update the password (plain text is fine).

    SELECT 
    *
FROM
    phplist_admin
where
    email = 'youremail@yourdomain.com';

Then…

   UPDATE `phplist_admin` 
SET 
    `password` = 'newpassword'
WHERE
    `id` = 'idvaluefromabove';

I usually use MySQL Workbench to do this, it has a decent human interface.

3

Sure, I am okay to change that in the db, but intrigued as to why the usual method might not work. After all, many users are not able to edit a DB… Can anyone replicate this issue?

4

I thought it was MD5.

SET ‘password=MD5’(‘newpassword’)

5

The hash algorithm used for a new installation of phplist is sha256. If someone upgrades from phplist 2 and has been using encrypted user passwords then those will have been using md5 and I think that algorithm is kept.

1 Like