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@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@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@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@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@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l