admin details on database not seeking

resif
@resif
4 years ago
187 posts
i lost my admin pass and trying confugire it ont db
like on screenhsots my admin user details not seeking like pass and email
updated by @resif: 12/18/20 07:06:00PM
paul
@paul
4 years ago
4,331 posts
Those details are on the jr_jruser_item_key table all under _item_id = 1 so do a search for all rows where _item_id = 1 to see all entries. Note that the password entry on the table is hashed so you will not see anything usable to log in. What I suggest is making sure that the email on the table is one that you can receive, then click on the login page 'forgot password' link. You can then follow the instructions in the received email to reset your password.
hth


--
Paul Asher - JR Developer and System Import Specialist
resif
@resif
4 years ago
187 posts
paul:
Those details are on the jr_jruser_item_key table all under _item_id = 1 so do a search for all rows where _item_id = 1 to see all entries. Note that the password entry on the table is hashed so you will not see anything usable to log in. What I suggest is making sure that the email on the table is one that you can receive, then click on the login page 'forgot password' link. You can then follow the instructions in the received email to reset your password.
hth

okay thank you i saw now my admin mail.. but my domain and vps hosting ip changed so i need to configure it for smtp... what do i need...
paul
@paul
4 years ago
4,331 posts
Email configration is in the Email Support module Delivery Settings tab.
But are you saying that you cannot receive the 'Forgot Password' email because these settings are wrong?


--
Paul Asher - JR Developer and System Import Specialist
resif
@resif
4 years ago
187 posts
hey what is wrong again. i told my hosting(ip) and domain name changed... how can i get forgot password mail over old smtp settings with old domain and hosting ip smtp settings...
i need tot change smtp settings to get forgot pass mail...
updated by @resif: 09/19/20 04:54:22AM
paul
@paul
4 years ago
4,331 posts
It would be easiest to change if logged in!!

Do you have the login password for another user? If so, find that user on the jr_jruser_item_key table then copy the hashed password. Then paste it into the admin hashed password value. You should then be able to login as admin using that password.


--
Paul Asher - JR Developer and System Import Specialist

Tags