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