Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-28-2016, 12:42 AM
shibby2 shibby2 is offline
 
Join Date: Jul 2005
Posts: 303
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Regaining access to forum, please help..

Hey everyone, I have an old 'test' forum that I haven't used in about 3 years. I really need to gain access to it, but for some reason none of my passwords are working.

I've tried requesting a new password, but I never get an email, for whatever reason. I tried registering a new account so I could use tools.php, but registrations are disabled.

Is there any other way for me to gain access again? I'm all out of ideas.

Please help, I'm desperate!
Reply With Quote
  #2  
Old 01-28-2016, 12:51 AM
Max Taxable's Avatar
Max Taxable Max Taxable is offline
 
Join Date: Feb 2011
Posts: 3,134
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You have file access?
Reply With Quote
  #3  
Old 01-28-2016, 01:29 AM
Dragonsys's Avatar
Dragonsys Dragonsys is offline
 
Join Date: Jan 2008
Location: DFW, Texas
Posts: 743
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

can you access the DB? if so, blank out your password
Reply With Quote
Благодарность от:
Max Taxable
  #4  
Old 01-28-2016, 02:01 AM
shibby2 shibby2 is offline
 
Join Date: Jul 2005
Posts: 303
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes I have FTP access and database access via phpmyadmin.

What will removing the password encryption in the database do?
Reply With Quote
  #5  
Old 01-28-2016, 07:46 AM
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Location: CT - Down in a hole..
Posts: 3,057
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That wont work..

Why dont you just register a new user, than go into the usertable and change it to an admin..Change the userid in your config and bam..your in.

Think you can use this too:

https://hashkiller.co.uk/md5-decrypter.aspx
Reply With Quote
  #6  
Old 01-28-2016, 04:04 PM
shibby2 shibby2 is offline
 
Join Date: Jul 2005
Posts: 303
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Can't register a new user, because new registrations are turned off.

Is there any way I can turn on registrations via phpmyadmin? And, if I'm able to do that, would I be able to turn off 'email verification' for registrations in phpmyadmin also?

Oh yea, also, is the forums main email listed somewhere in the database? I'd like to know which email I used, so I can see why it's not sending any emails out.
Reply With Quote
  #7  
Old 01-28-2016, 05:34 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If you cannot register a new account and have absolutely no access to any other accounts, the final option is a database query.

MAKE A FULL DATABASE BACKUP BEFORE YOU MANUALLY EDIT THE DATABASE. VERIFY IT AS WELL.

Open the database in a tool like phpmyadmin.

Run the Query:

UPDATE user AS user
set password = MD5(concat(MD5('pass1234'), user.salt))
WHERE userid = 1

The above will reset the password of user with userid = 1 to pass1234. Change the userid if your Admin account is not userid 1.

*NOTE* - If you have a table prefix setup in your config.php file then you must put the table prefix in front of the first "user" on the first line.

Example:

UPDATE vb_user AS user
set password = MD5(concat(MD5('pass1234'), user.salt))
WHERE userid = 1

The above query is if vb_ is the table prefix.

You should be able to tell easily if there is a prefix if all the table names start with the same few characters.

Once the query is run the password will now be pass1234 or whatever you set.

(The above is NOT valid for 5.1.10 and up.)
Reply With Quote
2 благодарности(ей) от:
MarkFL, Simon Lloyd
  #8  
Old 01-28-2016, 05:55 PM
shibby2 shibby2 is offline
 
Join Date: Jul 2005
Posts: 303
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks Lynne, I'll give it a try!

--------------- Added [DATE]1454011190[/DATE] at [TIME]1454011190[/TIME] ---------------

Just to verify, where exactly do I paste that query? I'm not too great with databases.. I have a few different databases in my account, so I don't want to put it in the wrong place and risk screwing the others up.

Thanks again!


Nevermind, figured it out.. it worked!

Thank you sooooo much!
Reply With Quote
Благодарность от:
MarkFL
  #9  
Old 01-28-2016, 10:03 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Glad you got it working.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:05 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.15004 seconds
  • Memory Usage 2,248KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (4)post_thanks_box_bit
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit
  • (9)post_thanks_postbit_info
  • (9)postbit
  • (9)postbit_onlinestatus
  • (9)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete