Topic on Project:Support desk

There is no user by the name "WikiSysop"

6
Summary by Hvdeynde

Osnard pointed me in the right direction. I disabled the Extension:LDAP_Authentication (for now) and can now use the account again.

Hvdeynde (talkcontribs)

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?

Malyacko (talkcontribs)

On an unrelated note, you are using an old unsupported version which has security issues. Please upgrade to a supported version.

2002:43F4:3186:1234:B8A3:4DE:ED5E:70E3 (talkcontribs)

Could you provide a link to your wiki?

Hvdeynde (talkcontribs)

No, it's not accessible to the outside world.

Osnard (talkcontribs)

Do you use Extension:LDAP_Authentication? Maybe the username is being normalized to lowercase. You could try creating a user "Wikisysop" (with lower case "s").

Hvdeynde (talkcontribs)

I had indeed tried to use that extension, but abandoned that little project for more urgent matters. When I comment out the settings in LocalSettings.php, the account works again.

Thanks, Osnard!