You forgot the closing brackets!
UPDATE user SET user_password=md5(concat(user_id,'-',md5('mynewpassword'))) where user_name ='WikiSysop' ;
-Arthur
-----Original Message----- From: mediawiki-l-bounces@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of Vinayak Nagaraj Sent: 08 December 2005 16:53 To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] sysop password forgotten
The correct specification would be
UPDATE user SET user_password=md5(concat(user_id,'-',md5('mynewpassword') where user_name ='WikiSysop' ;
Vinayak
Max de Mendizabal wrote:
Or you could try from the mysql prompt
UPDATE user SET user_password=md5('mynewpassword') where user_name='WikiSysop' ;
After you quit the mysql prompt delete the log created (because mysql will keep the unencrypted password there).
Max
On Thu, 8 Dec 2005, Hans Voss 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
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Oops :-)
Arthur Guy wrote:
You forgot the closing brackets!
UPDATE user SET user_password=md5(concat(user_id,'-',md5('mynewpassword'))) where user_name ='WikiSysop' ;
-Arthur
-----Original Message----- From: mediawiki-l-bounces@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of Vinayak Nagaraj Sent: 08 December 2005 16:53 To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] sysop password forgotten
The correct specification would be
UPDATE user SET user_password=md5(concat(user_id,'-',md5('mynewpassword') where user_name ='WikiSysop' ;
Vinayak
Max de Mendizabal wrote:
Or you could try from the mysql prompt
UPDATE user SET user_password=md5('mynewpassword') where user_name='WikiSysop' ;
After you quit the mysql prompt delete the log created (because mysql will keep the unencrypted password there).
Max
On Thu, 8 Dec 2005, Hans Voss 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
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l _______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org