[Mediawiki-l] sysop password forgotten

[Rob Church]

Far easier alternative - set the email address of the sysop user to be
yours, and request a new password from the login screen.

Alternatively, register a new account and manually create the rows in
user_groups which will turn it into a sysop and a bureaucrat.


Rob Church

On 08/12/05, Hans Voss <hans.voss at gmail.com> wrote:
> Got it. I'll need to translate from dutch as I go along:
> Procedure assumes:
> *Linux with command prompt access
> *access to php interpreter
> *access to the wiki HTML source (LocalSettings.php file).
> *mysql. Instead of direct mysql commandline access you could use
> something like phpMyAdmin
>
> Settings like 'which database inside mysql is used' and 'what user and
> password are required to access that database in mysql' can be found
> by accessing the LocalSettings.php file in the wiki install.
>
> First you'll need access to the command prompt of the machine.
> No root access required
> start the mysql client: $ mysql -p -u wikiuser wikidb
> Type the following query:
>   SELECT user_id, user_name, user_password
>   FROM user WHERE user_name = "WikiSysop";
>
> this should get you something like:
> +---------+-----------+----------------------------------+
> | user_id | user_name | user_password                    |
> +---------+-----------+----------------------------------+
> |       15 | WikiSysop     | e4bda1f6162596e744463e1d17c9cc0c |
> +---------+-----------+----------------------------------+
> (best viewed in non-proportional font type like Courier)
>
> >From the documentation I found how the password hash is created and I
> wrote a small php program to do just that. (It's not user friendly but
> it works).
>
> Create a file (for example mypwd.php) with approximately the following content:
> <?php
> # select user_id from user where user_name = "name of user";
> $a=md5 ( "MyNewPa$$wordHere" );  # the new password you want
> echo "\n\n";
> # IN FRONT OF the minus sign ('-') enter the user_id found with the mysql query.
> # (so replace the '5' with the id found).
> echo md5 ( "5-{$a}"  );
> echo "\n";
> # call with php mypwd.php
> ?>
> The results the actual hash value that needs to be entered into the database.
>
> start mysql client again and enter the following query:
> UPDATE user SET user_passwd = "new hash value" WHERE user_id = <userid-of-user>
>
> This should do the trick.
> If this procedure is too much over your head, you might ask your
> system admin to help you out.
>
>
> Hope this helps.
> On 12/8/05, Hans Voss <hans.voss at gmail.com> wrote:
> > Yes there is. I have to look it up.
> > It has to evolve some direct database hacking and php scripting.
> > Procedure is for linux and you'll want access to the command prompt.
> >
> > I'll mail the solution once I found it.
> >
> > On 12/8/05, Markus Herrmann <HerrmanM at klilu.de> wrote:
> > > hey guys,
> > >
> > > your are my last chance.
> > >
> > > the guy who has set up the wiki here in my foundation is gone.
> > >
> > > and now it's up to me the administrate the wiki. so i need the sysop
> > > password. but i couldn't find it!
> > >
> > > is there any opportunity to recover the old password? or to change it?
> > >
> > > thx so far!
> > >
> > > ey i'm german! sry for my english ;-)
> > >
> > > greetz markus
> > > _______________________________________________
> > > MediaWiki-l mailing list
> > > MediaWiki-l at Wikimedia.org
> > > http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
> > >
> >
> >
> > --
> > ----
> > Met vriendelijke groeten / With kind regards
> > Hans Voss
> > ---------------------------------------
> > skype: hans.voss
> > google talk enabled
> > I am looking for people to invite to Gmail. I have 100 invitations left.
> >
>
>
> --
> ----
> Met vriendelijke groeten / With kind regards
> Hans Voss
> ---------------------------------------
> skype: hans.voss
> google talk enabled
> I am looking for people to invite to Gmail. I have 100 invitations left.
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>