|
Joined: Jul 2010
Posts: 13
stranger
|
stranger
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,568 Likes: 78
|
Joined: Dec 2003
Posts: 6,568 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
stranger
|
stranger
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?
|
|
|
|
Joined: Dec 2003
Posts: 6,568 Likes: 78
|
Joined: Dec 2003
Posts: 6,568 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,303 Likes: 116
|
Joined: Jun 2006
Posts: 16,303 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.
|
|
|
|
Joined: Jul 2010
Posts: 13
stranger
|
stranger
Joined: Jul 2010
Posts: 13 |
Ruben, Thanks - I'm working on getting the license and pass from my client. I feel 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 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
Former Developer
|
Former Developer
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:
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,568 Likes: 78
|
Joined: Dec 2003
Posts: 6,568 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,568 Likes: 78
|
Joined: Dec 2003
Posts: 6,568 Likes: 78 |
Ruben, Thanks - I'm working on getting the license and pass from my client. I feel 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 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,303 Likes: 116
|
Joined: Jun 2006
Posts: 16,303 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
|
|
|
|
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,303 Likes: 116
|
Joined: Jun 2006
Posts: 16,303 Likes: 116 |
One reason that I'm surprised we don't salt our MD5 :/
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
|
|
|
|
Joined: Jun 2006
Posts: 1,344
veteran
|
veteran
Joined: Jun 2006
Posts: 1,344 |
Ruben, Thanks - I'm working on getting the license and pass from my client. I feel 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 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. One reason that I'm surprised we don't salt our MD5 :/ I agree Nice, thank you Rick
|
|
|
|
Joined: Dec 2003
Posts: 6,568 Likes: 78
|
Joined: Dec 2003
Posts: 6,568 Likes: 78 |
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 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,303 Likes: 116
|
Joined: Jun 2006
Posts: 16,303 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...
|
|
|
|
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
Former Developer
|
Former Developer
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 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
stranger
|
stranger
Joined: Jul 2010
Posts: 13 |
Rick THANK YOU!! This worked like a charm 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,568 Likes: 78
|
Joined: Dec 2003
Posts: 6,568 Likes: 78 |
Rick THANK YOU!! This worked like a charm 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
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
hehe.. your trigger is a screwed up featured member image
|
|
|
|
Joined: Dec 2003
Posts: 6,568 Likes: 78
|
Joined: Dec 2003
Posts: 6,568 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
veteran
|
veteran
Joined: Jun 2006
Posts: 1,344 |
hehe.. your trigger is a screwed up featured member image You had to go there, lol. That is Ruben's mission!!
|
|
|
|
Joined: Dec 2003
Posts: 6,568 Likes: 78
|
Joined: Dec 2003
Posts: 6,568 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
veteran
|
veteran
Joined: Jun 2006
Posts: 1,344 |
lol, you aint nagging
|
|
|
|
Joined: Dec 2003
Posts: 6,568 Likes: 78
|
Joined: Dec 2003
Posts: 6,568 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 |
|
|
|
|
Joined: Jul 2006
Posts: 2,143
Pooh-Bah
|
Pooh-Bah
Joined: Jul 2006
Posts: 2,143 |
Rick THANK YOU!! This worked like a charm 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.....
|
|
|
|
|
Test
by Phun - 05/28/2024 7:31 PM
|
|
0 members (),
435
guests, and
342
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|