Muthafucka... locked outta SimpleMachine Forum

Garrett

Garrett

music LOUD
Feb 4, 2008
3,847
131
0
I installed a Simple Machine forum and for some reason the auto-generated password isnt working for my admin account anymore nor is it sending me an email to reset it. I was logged in, then when I went to go back in, it logged me out.

Am I fucked? Re-install? Can I change it via PhpMyadmin somehow?

Have any tutorials you can link me to that explain how to back up the databases.... then reinstall so I keep my members? I think thats something I should learn how to do anyways.
 


More familiar with vbulletin, but the process should be the same... phpmyadmin, root (admin, superadmin) user, change pw.

If not, you can always have the host revert to yesterday's backup.
 
Matt's process is correct... and easiest. A similar thing happened to a client of mine earlier this year: I was taking over the management of a few of their sites, one of which included an SMF forum.

I can't remember the exact table names, but if you need a hand, shoot me a PM. Log in with phpMyAdmin (if you don't have a way to admin your db, you can install a small script called SQL Buddy - it's a very light version of phpMyAdmin), find the users table, select the admin account, and hit edit. The "pass" field contains the MD5 encrypted password for the user. Replace this with the MD5 hash of your new password.

If you're unfamiliar with doing this, use the following PHP code in a new file, changing the appropriate variable:
PHP: 
<?
$hashme = "newPassword";
echo md5($hashme); //will output new MD5 password hash
?>

While you're in phpMyAdmin/SQL Buddy, it's best to double check that the e-mail address is correct as well. Again, if you need a hand, I'm available by PM.
 
Perma said:
The "pass" field contains the MD5 encrypted password for the user. Replace this with the MD5 hash of your new password.

If you're unfamiliar with doing this, use the following PHP code in a new file, changing the appropriate variable:
PHP: 
<?
$hashme = "newPassword";
echo md5($hashme); //will output new MD5 password hash
?>
While you're in phpMyAdmin/SQL Buddy, it's best to double check that the e-mail address is correct as well. Again, if you need a hand, I'm available by PM.
Click to expand...

SMF doesn't use MD5 for passwords.

Garrett, check out this thread: Reset admin password.
 
hmmmm... when I select the database, then the members table, and paste this in.

UPDATE mycorrectprefix_members SET passwd = SHA1(CONCAT(LOWER(admin), 'mynewsupersecretpassword')) WHERE id_member = 1
Click to expand...

I get this error.

#1054 - Unknown column 'admin' in 'field list'
Click to expand...
 
Corey said:
Add apostrophes around the the username.
Code: 
UPDATE mycorrectprefix_members SET passwd =  SHA1(CONCAT(LOWER('admin'), 'mynewsupersecretpassword')) WHERE id_member =  1
Click to expand...

worked perfectly... thanks man!!!
 
You must log in or register to reply here.
Top Bottom