Change Admin Password

I changed my admin password. When I did it gave me an error. So now I am not able to log in at all with the old or new. How may I reset it? I have looked at all the other form post and none of them worked for me. Can anyone tell me a simple way to change the password on on the back end? I do not have a phpmyadmin file so that one wont work.

Thanks to anyone who can help.

can you work with your current php, if so and you know what your doing and you have made a backup of your files,

you need to select

Password varchar(40) in the profiles and select MD5 from the drop down list

Yea, I don't feel comfortable enough to try that one. Any easier way? Like, is there not a simple file somewhere that I may edit?

well I have only used Dolphin for little over a year, there maybe another way and one of the seasoned members or a site moderator will chime in with an answer or better suggestion.

I'm backing up my files now to see if I can give it a try?

Thank you for your help :) have an awesome weekend!

You can do it with a php script.

create a new php file in the root of your dolphin site. name it something like resetpass.php

In that file place the following code.

<?php

require_once('inc/header.inc.php');
require_once(BX_DIRECTORY_PATH_INC . 'db.inc.php');
require_once(BX_DIRECTORY_PATH_INC . 'design.inc.php');
require_once(BX_DIRECTORY_PATH_INC . 'languages.inc.php');
require_once(BX_DIRECTORY_PATH_INC . 'utils.inc.php');


$res = db_res("UPDATE `Profiles` SET `Salt` = CONV(FLOOR(RAND()*99999999999999), 10, 36) WHERE `ID`='1'");
$res = db_res("UPDATE `Profiles` SET `Password` = SHA1(CONCAT(md5('New Admin Password'), `Salt`)) WHERE `ID`='1'");

unlink (BX_DIRECTORY_PATH_CACHE . 'user1.php');

echo "<br><br>Admin Password has been reset";

?>

Change the items in red to what they need to be.

New Admin Password should be the password you want.

1 should be the dolphin ID of your admin account. This is normally 1 so should be ok as is.

Then just go to http://yoursite.com/resetpass.php and your password should be reset.

Make sure you delete that script from the server when your done with it.

thanks Deano

going in my file cabinet!

So I did all that you instructed and I got an error a data base query error when I went to the browser you gave (with my site info)?

Any other ideas? Although when I looked at the profiles I never found a user 1.

there has to be a number one member, that would be the admin account..if not that is why your having a problem, which is a completely different story.

I just looked again and there was no user 1. I was able to get into the admin before I changed the password and I have not deleted any users. Is it easy to just create a user 1?

Need to know what the error was, as it was most likley the cause of why this happend in the first place.

How are you looking?

You said you have no phpMyadmin to look in the database.

In in files that are on my host site. I looked through the cache folder where all the profiles are.

Thats becuse part of that script deletes that cache file after the query is run. That is not a reliable way to determine if user 1 exists. It's just a cache file.

You need to check your bug report email address or server logs for the database error. As that will tell us why the script failed and most likley the reason this happend in the first place.

OK? can you dummy down what you just said? Like how do I do all that? I'm sure it's like something simple but I'm familiar with the process you mentioned.

Thank you so much for all your help by the way :)

When you first setup dolphin it asked for several email addresses. One of them is a bug report address. This is the address where dolphin sends all bug reports. Including database error reports. So check that address for errors sent to you.

As for the logs, well you will need to talk to your host. Because you don't even have phpMyAdmin you obviously do not have a normal server setup, so ask your host where the log files are stored.

Normally your php log files are in the site where dolphin is as files named error.log.

Because without the error we cannot tell you what happened.

So it is not as easy as just creating a user 1? Because I actually did not set up the site and the person that did has gone MIA for a while now. A few people used them and they have disappeared.

No, it's not that easy.

You could try it, but you would have to copy one of the existing ones then change all of the information in it to match the admin account. Then a hashed password would have to be created to put in that file.

Well it's worth a try perhaps? So what would be the admin info? Is it simply my info? Or is there special information that I need?

And about that whole hashed thing, how does that work?

Just look at one of the current user files. You will see what i mean.

As for the hash and salt that is in there i will have to generate one for you from a known password.

Now you will also need to make sure the new user1.php is set as writable. Mode 777 so dolphin can update it when needed with the admin account is updated.

OK, cool beans, will copy now.

Thanks

So I have copied and changed the info and made sure the permissions are 777. Now for that hashed thing. What do we do now?

Ok. So replace the following values.

For $aUser[1]['Password'] replace whats in between the single quotes with this. e07e5bfd275c91d7f64c6a26cac9d86889444258

For $aUser[1]['Salt'] replace whats in between the single quotes with this YjQyOTcx

These were generated from the password dolphin. So log in with admin and the password of dolphin


No garentee this will even work. The origional cause of the problem has still not been determined.

Oh, and do this as well.

edit the file inc/header.inc.php and find this.

$site['bugReportMail']

Make sure the email address shown there is a email address you check on a regular basis to recieve dolphins bug reports.

Is there another word for 'salt'? Because there is no salt in there?

No.

What version of dolphin is this?

Like 5? I think? I've had it for a long while.

It does not matter. I just checked a 7.0.0 file and it's there.

Add it. Directly below the password line.

$aUser[1]['Salt'] = 'YjQyOTcx';

If none of the user files contain a salt then this could be the reason something went wrong. It could indicate the salt field is missing from the profile table. And without phpMyAdmin, this will be task i will not be able to help you fix.

Hm? well I added it. And yes the other goes to the email I want. Now what do we do next?

You try and log in using the password dolphin

If it still does not work then i have gone as far as i can go.

No,

It did not work :(

Thank you for trying though. I have no idea why the whole password reset didn't work in the first place. I've changed it before and never had a problem. So frustrating.

not to complain, but why did you post this under Dolphin 7 if it is version 5?

I guess I should have asked b4 I gave any advice, I have no clue how to work with version 5 :)

That also explains why the password trick in the user file did not work. It's not compatible with that version. I can't work on a version that old either.