Dolphin 7.0 Password retrieval

Hi,

 

I am putting this out there in the hope someone can help, i need to retrieve my Dolphin Admin Login & Password, i have created several support tickets but the answers i get are meaningless and mostly consist of sending me to a forgot.php page which does not exist and with no instructions even if it did.

I would have thought that password retrieval was a common requirement but it is over 2 weeks now and no-one at Boonex has been able to help.

 

If anyone has any experience with password retrieval any help would be greatly appreciated

 

Thanks

Quote · 17 Aug 2011

I think you have more serious issues if your forgot.php is missing.

BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin
Quote · 17 Aug 2011

if you are not seeing the forgot.php file, then you indeed have additional troubles. if you were able to see the forgot.php file, you would in most cases catch a clue, the instructions are enter your email, it would search the database for your email or nickname, once it found it, it would send you an email with an auto-generated password to use to login with.

 

being that you do not see the forgot.php file, then of course this method would not be available to you.

 

so alternatively, you would need to login to mysql, and run an update query on the database, not to retrieve the password, but to reset it. 

our comrade and superb module developer friend Deano has provided this method for resetting the admin password.

 

In phpMyAdmin run the following MySQL queries.

UPDATE `Profiles` SET `Salt` = CONV(FLOOR(RAND()*99999999999999), 10, 36) WHERE `ID`='1';

UPDATE `Profiles` SET `Password` = SHA1(CONCAT(md5('New Admin Password'), `Salt`)) WHERE `ID`='1';


Now Delete user1.php from the cache folder on the server. (This step is important.)


You can also use this to reset other users passwords as well as long as you know the ID. Just change the number 1 in the above instructions to the ID of the member your resetting the password of.

When a GIG is not enough --> Terabyte Dolphin Technical Support - Server Management and Support
Quote · 17 Aug 2011

Thanks,

 

I ran the MySQl queries but am unsure how to remover (where to find) the user1.php that needs to be deleted, can you help please

 

Thanks again 

 

Yokestar

Quote · 17 Aug 2011

You can empty the /cache/ (except for the .htacess file) and /cache_public/ directories. I also recommend you look into your missing forgot.php problem.

BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin
Quote · 17 Aug 2011

Is this cache in PhpMyAdmin or Cpanel i am unable to find cache anywhere? also once i have completed this how do i reset my password & is the login still "admin"

 

i will look into the forgot.php once i can get into Dolphin Admin

 

Thanks

 

Alan

Quote · 17 Aug 2011

cache/ is one of dolphins folders. You can get to it's contents via cpanal file manager or via FTP.

The logon is still admin.

You said you ran the queries so you already reset the password. That is of course assuming you actually replaced the words New Admin Password with the actual password you want to use.

Once you complete the last step of clearing the cache, then the logon should work. That is of course assuming nothing else is wrong with your site.


https://www.deanbassett.com
Quote · 17 Aug 2011

Oh, and one other thing.

Look of the front page of your site. There should be a logon block. And in the logon block is a link that says Forgot Password. Have you even tried to click on that yet?

Because i have a fealing because you do not know what the cache folder is or how to find it, then you most likley don't know how to find forgot.php either.

You can also try to go to this URL using your web browser. yoursite.com/forgot.php where yoursite.com is to be replaced with your actual domain name.


https://www.deanbassett.com
Quote · 17 Aug 2011

 as you can gather from the sql query, there is nothing to edit the nickname so the nickname admin would still be intact. 

 

In phpMyAdmin run the following MySQL queries.

UPDATE `Profiles` SET `Salt` = CONV(FLOOR(RAND()*99999999999999), 10, 36) WHERE `ID`='1';

UPDATE `Profiles` SET `Password` = SHA1(CONCAT(md5('New Admin Password'), `Salt`)) WHERE `ID`='1';


Now Delete user1.php from the cache folder on the server. (This step is important.)


You can also use this to reset other users passwords as well as long as you know the ID. Just change the number 1 in the above instructions to the ID of the member your resetting the password of.

 

ID 1, which by default is the administrators ID, doesnt mean the nickname is admin, though in most cases users opt for that name. from the query you can ascertain the following, the password is being provided in text form. the query takes the text form, and randomizes SALT as well as md5 hashes the textual characters.

there is nothing on there that edits the nickname.

 

second part of your question is related to cache, both cache and cache_public are part of the file structure. so you would need to access the area on the server where your files are located, via ftp or some other means. the two directories cache and cache_public are listed alphabetically. there is a file in the cache directory that needs to remain there. the name of the file is .htaccess, leave it there, and just delete everything else that is cached. 

in the cache_public, just remove everything that is in there.

 

 

Is this cache in PhpMyAdmin or Cpanel i am unable to find cache anywhere? also once i have completed this how do i reset my password & is the login still "admin"

 

i will look into the forgot.php once i can get into Dolphin Admin

 

Thanks

 

Alan

 Alan, the sql statement is what i used to reset the password in relation to the userID. 

When a GIG is not enough --> Terabyte Dolphin Technical Support - Server Management and Support
Quote · 17 Aug 2011

Got it!! Thanks everyone, the MySql worked after i figured out how to clear the cache.

As to the forgot.php i think this may be down to the fact that our site is still under construction and not a live url, will find out soon

Thanks again

Alan

Yokestar

Quote · 17 Aug 2011

 

Got it!! Thanks everyone, the MySql worked after i figured out how to clear the cache.

As to the forgot.php i think this may be down to the fact that our site is still under construction and not a live url, will find out soon

Thanks again

Alan

Yokestar

 

When a GIG is not enough --> Terabyte Dolphin Technical Support - Server Management and Support
Quote · 18 Aug 2011
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.