vb.org Archive - Force admin password

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB5 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=262)

- - Force admin password (https://vborg.vbsupport.ru/showthread.php?t=315611)

PiotrGT

11-25-2014 11:49 AM

Force admin password

My VPS is unable to send emails therefore i cannot change my password and because of this im unable to access the admin panel. This is going to be my first login after the vb4 upgrade.

Is there a way to force a password via phpmyadmin or any other way to get myself into the admin panel?

Lynne

11-25-2014 05:08 PM

What is your userid? You can run a query like this:

Code:

UPDATE user AS user 

SET token = concat(MD5(concat(MD5('pass1234'), user.token)),' ', user.token), scheme = 'legacy' 

WHERE userid = xxx;



The above will reset the password to pass1234. Change the xxxxx to your userid (usually 1).

If you have a database prefix, then add that in front of the first "user" table name.

PiotrGT

11-26-2014 06:39 AM

Okay we did this and we are still unable to login - the request did process through phpmyadmin.

Error:
You have entered an invalid username or password. Please enter the correct details and try again. Don't forget that the password is case sensitive. Forgotten your password? Click here!

You have used 2 out of 5 login attempts. After all 5 have been used, you will be unable to login for 15 minutes.

Is there another way?

Lynne

11-26-2014 04:40 PM

Did you change your domain (and perhaps your cookies are set incorrectly)?

And wait a sec.... you are posting in the vB5 section, so I gave you the vb5 query.

If you really mean vB4, and not vB5, then use this query to change the password:

Code:

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.

PiotrGT

11-26-2014 06:49 PM

Thanks Lynne! It's fine now - my friend took care of this. I'm just his translator :)
We are almost done with the phpbb3 to vb4 to vb5 migration.
Now we just need to get the mail server going and sort out the issue with attachments - the images that are inline just show some BBcode like code and there is a list of all images in the attachment list (all images load once clicked on) - i already started a thread on this.

All times are GMT. The time now is 11:26 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02438 seconds Memory Usage 1,714KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: