Environment
- Mediawiki: 1.26.2
- PHP: 5.5.9-1ubuntu4.21 (apache2handler)
- MySQL: 5.5.54-0ubuntu0.14.04.1
I can no longer log in using WikiSysop. (Error message: "Login error - Incorrect password entered. Please try again.")
When I try to reset the password, from the "Reset password" special page, I receive the error 'There is no user by the name "WikiSysop". Usernames are case sensitive. Check your spelling, or create a new account.'
And yet the user exists in the database and has been assigned to the proper groups:
mysql> select * from mw_user where user_name='WikiSysop'\G *************************** 1. row *************************** user_id: 1 user_name: WikiSysop user_real_name: user_password: :pbkdf2:sha256:10000:128:l/NWTJPk97qdVxhgnLcWhg==:N4gbsbSM1Q/K+O5ZQhNleJjR44bM7KSSN9h4qUfS7PwWvMwpicMTz0vGu7ZSVfcJgVu6oej0gEZRdb5i37QXV8OdgJrizJQrzzeinK5cgZRUtcYqwo7y7rDatMRxlsg9ezZNMlTzcoT+aSl+HEZjV1tOqHgYYkMwWuF4qls0Cv0= user_newpassword: user_newpass_time: NULL user_email: my-email@my-comp.com user_touched: 20151222110537 user_token: 224f7d0c9212d68d33dfb035f924118e user_email_authenticated: 20131127134624 user_email_token: 31e2e277a9afdd5b9d4d8c7022b3f42e user_email_token_expires: 20131204134602 user_registration: 20110310162835 user_editcount: 47 user_password_expires: NULL 1 row in set (0.00 sec) mysql> select * from mw_user_groups where ug_user=1\G *************************** 1. row *************************** ug_user: 1 ug_group: bureaucrat *************************** 2. row *************************** ug_user: 1 ug_group: sysop 2 rows in set (0.00 sec)
I tried recreating the user but that didn't work either:
# php createAndPromote.php --bureaucrat --sysop WikiSysop mypassword wikidb-mw_: Creating and promoting User:WikiSysop into sysop, bureaucrat... [a3a7d65c] [no req] PasswordError from line 2415 of /var/www/html/mediawiki-1.26.2/includes/User.php: You cannot change passwords on this wiki. Backtrace: #0 /var/www/html/mediawiki-1.26.2/maintenance/createAndPromote.php(112): User->setPassword(string) #1 /var/www/html/mediawiki-1.26.2/maintenance/doMaintenance.php(103): CreateAndPromote->execute() #2 /var/www/html/mediawiki-1.26.2/maintenance/createAndPromote.php(142): require_once(string) #3 {main}
Anyone any idea what may be wrong?