Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jul 2010
Posts: 13
J
stranger
stranger
J Offline
Joined: Jul 2010
Posts: 13
Hey, is there an MD5 value or something similar so I can manually reset an admin password in phpMyAdmin?

I tried to change the register email and resend the password but it didn't work.

Thanks in advance.

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Start at MyFeeds>Edit Profile
After you login as the admin.
On the forum not Phpmyadmin.

Last edited by Ruben; 07/21/2010 4:31 PM. Reason: Added comment

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jul 2010
Posts: 13
J
stranger
stranger
J Offline
Joined: Jul 2010
Posts: 13
That's the issue - can't login as Admin... I can't login to the forum using the admin user - so I want to reset it using the only thing I do have access to - phpMyAdmin or FTP...

Joined: Mar 2008
Posts: 262
enthusiast
enthusiast
Joined: Mar 2008
Posts: 262
Not sure if it word work, but do you have another user that you could change the admin to in the database?


Ian
http://www.firstgenmc.com/ubbthreads

"Experience is a hard teacher because she gives the test first, the lesson afterwords."
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
There are ways around this issue.
But I don't want to lead you down a path that opens more issues.
So I would suggest that you open a support ticket and have Rick reset it for you.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
If you want to just generate an MD5 password to reset it, go to here (my site) and select "Encode" and "MD5" and type in a temporary password and click calculate and then it'll give you an MD5 hash.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jul 2010
Posts: 13
J
stranger
stranger
J Offline
Joined: Jul 2010
Posts: 13
Ruben, Thanks - I'm working on getting the license and pass from my client. I feel
Quote
open a support ticket and have Rick reset it for you
is ridiculous. I can't find anything via Google so here I am and that's the solution??? I would prefer to have access to this knowledge is all.

Gizmo, That would be too much to ask lol. I did try this thinking it should be easy peas - no tomato... Must be a ubb thing wink I was hoping for some kind of work around besides tracking down the purchaser of the license and having them provide me a login so I can post a silly ticket 'hey I can't login as the new admin'.

I'm just happy the site is setup and seemingly working on the new server! Now to gain admin access.




Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
If you have the admin userid then you can use phpmyadmin to change the password to something else with the following query:

SQL Query
update ubbt_USERS 
set USER_PASSWORD=md5('newpassword') 
where USER_ID='#'

Change newpassword to the actual password you want to use and change the # to the userid of the admin user.

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Like I said Rick would help.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Originally Posted by jarmerson
Ruben, Thanks - I'm working on getting the license and pass from my client. I feel
Quote
open a support ticket and have Rick reset it for you
is ridiculous. I can't find anything via Google so here I am and that's the solution??? I would prefer to have access to this knowledge is all.

Gizmo, That would be too much to ask lol. I did try this thinking it should be easy peas - no tomato... Must be a ubb thing wink I was hoping for some kind of work around besides tracking down the purchaser of the license and having them provide me a login so I can post a silly ticket 'hey I can't login as the new admin'.

I'm just happy the site is setup and seemingly working on the new server! Now to gain admin access.

BTW, it is not ridiculous. How is anyone supposed to know you are a legit user to make admin changes without a license number and password.
How would you like it if I said I needed to change all of the settings on your site. Just because I have ftp access.
Trying not to be a jerk but there needs to be some security to the software.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Yeah, but then again, if he has access to change values through MySQL, the last thing the forum owner would have to worry about would be him changing a password Ruben tongue


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jan 2008
Posts: 514
addict
addict
Joined: Jan 2008
Posts: 514
True enough but I can see Ruben's point as well. No one wants anyone to backdoor their forums like that. Unless it is absolutely necessary.

Dunny

Last edited by Dunny; 07/22/2010 2:04 AM.
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
One reason that I'm surprised we don't salt our MD5 :/


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
it's a comin

Joined: Jun 2006
Posts: 1,344
G
veteran
veteran
G Offline
Joined: Jun 2006
Posts: 1,344
Originally Posted by Ruben
Originally Posted by jarmerson
Ruben, Thanks - I'm working on getting the license and pass from my client. I feel
Quote
open a support ticket and have Rick reset it for you
is ridiculous. I can't find anything via Google so here I am and that's the solution??? I would prefer to have access to this knowledge is all.

Gizmo, That would be too much to ask lol. I did try this thinking it should be easy peas - no tomato... Must be a ubb thing wink I was hoping for some kind of work around besides tracking down the purchaser of the license and having them provide me a login so I can post a silly ticket 'hey I can't login as the new admin'.

I'm just happy the site is setup and seemingly working on the new server! Now to gain admin access.

BTW, it is not ridiculous. How is anyone supposed to know you are a legit user to make admin changes without a license number and password.
How would you like it if I said I needed to change all of the settings on your site. Just because I have ftp access.
Trying not to be a jerk but there needs to be some security to the software.


I agree, one can never know this. Thats why I didnt post the info as I have had to use it in the past on other forum software when the owner locked them self out.

Originally Posted by Gizmo
One reason that I'm surprised we don't salt our MD5 :/


I agree

Originally Posted by Rick
it's a comin


Nice, thank you Rick wink

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Originally Posted by Gizmo
Yeah, but then again, if he has access to change values through MySQL, the last thing the forum owner would have to worry about would be him changing a password Ruben tongue
I guess I march to a different drummer.
I would leave it to Rick to determine if a password reset is needed and how to accomplice it. After verifying the license info.
If Rick wants to publicly display how to do it then that is his choice also.

My 2 cents


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Well, I figure that if he can completely delete all information or assign a new user admin access; changing a password is the least of anyones worries...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jan 2008
Posts: 514
addict
addict
Joined: Jan 2008
Posts: 514
Point noted Gizmo.. though I hadn't realized until I read the original post again that he pretty much had the access he/she needed. But any admin can run an sql query right from the control panel...

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Any of the SQL commands posted on the forums have potential to do harm if not done correctly, not just a password change wink This particular one won't work too much longer and in v8 you'll be able to have more control over who can run SQL commands from the control panel, rather than just all admins.

Joined: Jul 2010
Posts: 13
J
stranger
stranger
J Offline
Joined: Jul 2010
Posts: 13
Rick THANK YOU!! This worked like a charm smile I guess maybe there was a bird in your ear or something.

Ruben, sorry if I came off hot about the situation. I understand where you are coming from. I was given both FTP and phpMyAdmin.

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Originally Posted by jarmerson
Rick THANK YOU!! This worked like a charm smile I guess maybe there was a bird in your ear or something.

Ruben, sorry if I came off hot about the situation. I understand where you are coming from. I was given both FTP and phpMyAdmin.

No problem. We all get a little impatient when the software is not working as expected.
Even I fly off the handle at times.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
hehe.. your trigger is a screwed up featured member image laugh

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
You bet ya!
One day it will be fixed.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 1,344
G
veteran
veteran
G Offline
Joined: Jun 2006
Posts: 1,344
Originally Posted by Sirdude
hehe.. your trigger is a screwed up featured member image laugh


You had to go there, lol. That is Ruben's mission!!

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Nag Nag Nag, that is all I have in life now.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 1,344
G
veteran
veteran
G Offline
Joined: Jun 2006
Posts: 1,344
lol, you aint nagging wink

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Yes I am!
I personally am tired of the repeated server errors.
Can't keep up with them anymore.
Just hoping v8 will clean it up.
Then maybe I can address some of the real errors.
Since they roll off faster than roger rabbit.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jan 2008
Posts: 514
addict
addict
Joined: Jan 2008
Posts: 514
I don't know I haven't had any real issues with mine..though I usually keep my mods to a minimum. The only mod I actually have running is Gizmo's IRC connect script. So my DB usually stays pretty consistent.

Dunny

Joined: Jan 2010
Posts: 34
newbie
newbie
Joined: Jan 2010
Posts: 34
Ruben. Try this.

Joined: Jul 2006
Posts: 2,143
Pooh-Bah
Pooh-Bah
Joined: Jul 2006
Posts: 2,143
Originally Posted by Ruben
Originally Posted by jarmerson
Rick THANK YOU!! This worked like a charm smile I guess maybe there was a bird in your ear or something.

Ruben, sorry if I came off hot about the situation. I understand where you are coming from. I was given both FTP and phpMyAdmin.

No problem. We all get a little impatient when the software is not working as expected.
Even I fly off the handle at times.


I've never seen that. Ever. Hmmmmm.....



This thread for sale. Click here! [Linked Image from navaho.infopop.cc]

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
3 members (rootman, Gizmo, Nightcrawler), 562 guests, and 186 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)