Urgent: Admin user password reset

Permalink 1 user found helpful
Hi guys I have an urgent problem with a site that is to go live for a client today...

This is going to sound completely idiotic but...

I had to reset my admin password!

This hasn't been a problem under my other sites I have created as they are hosted on my own hosts servers and sending an email to a differnet email address other than the one for the domain that is being hosted has never been a problem and they have a PHP admin interface where (I think) I could have retrieved it out of the database wherever it is stored.

Unfortunately my clients host (fasthost) do not have a phpAdmin interface where I can possibly search for this.

So:
1) where is the admin username and password stored?
2) can I access this through FTP?
3) how can I set it without going through the dashboard login?

Please please someone respond quickly.

cheers in advance
Paul

craftyCS
View Replies:
Maynar replied on at Permalink Reply
Maynar
Did you try the forgot password function in plain view when you get the login screen?

yourwebsite.com/concrete/index.php/login

On the bottom there you need to fill in your email address and you will get a replacement or something.
craftyCS replied on at Permalink Reply
craftyCS
The host doesn't seem to allow emails sent to email address' other than the one it is hosting. So:
My email address is:
[email protected]
but the client host will only send out emails to ones on which they host the domain:
www.www.woodlands-wellbeing.com... is the domain that is being hosted so I am not receiving the reset password as the email is not getting out!

mare!
Remo replied on at Permalink Reply
Remo
Check the mysql table "Logs" you'll find the password there once you've hit "Reset password"
Maynar replied on at Permalink Reply
Maynar
Can you access the dashboard? If not.. you got a real good one.. (a problem that is)

To respond to your earlier questions:
1) In the database
2) No
3) If logged in go to /profile/edit
Remo replied on at Permalink Reply
Remo
you can override the password yourself but please not that you have to include the salt from the config as well. After that it's just a simple md5 hash...

But for this you need to access the database and if you can do that you can also check the table "Logs" which is probably easier...
craftyCS replied on at Permalink Reply
craftyCS
Am going through the database now...
The host doesn't have a control panel interfaace for the database so I'm downloading one now... on that note which one do you use? I'm trying the free navicat8 lite

cheers
craftycs
craftyCS replied on at Permalink Reply
craftyCS
the stored password is a very long series of numbers and letters how do you get the most recent?
Remo replied on at Permalink Reply
Remo
not the user table. this is a hash which you can't read and won't be able to read unless you do some fancy rainbow table attack on a really really incredibley fast server

check the table called "Logs"
craftyCS replied on at Permalink Reply
craftyCS
Sorted!!
agbela replied on at Permalink Reply
Hi...same problem...checked Logs and all I got:

mysql> select logID from Logs;
Empty set (0.00 sec)

mysql> select logType from Logs;
Empty set (0.00 sec)

mysql> select timestamp from Logs;
Empty set (0.00 sec)

mysql> select logText from Logs;
Empty set (0.00 sec)

mysql> select logisInternal from Logs;
Empty set (0.00 sec)


Any other ideas?
SmushyPillows replied on at Permalink Reply
Thanks for that help, I did a stupid and typo'ed my password. this testing server did not have SMTP working. Got me out of a jam.
sparkdigital replied on at Permalink Reply
sparkdigital
Yep, great tip. When you go to logs (after resetting the password), you tick the box for emails sent and click on print view with full text. This opens the email that was sent with the link to set a new password. Click on that link and it will open a new browser window.

Works a treat for localhost installations too.

Konrad
karlconcrete replied on at Permalink Reply
ok this had me a little confused but after doing the following it work.

Localhost solution

1. request email with new password
2. login into phpadmin
3. select your database
4. go to the logs table
5. tick / select emails sent
6. Under "Query results operations"
7. Print view (with full texts)
8. In the SQL results print view scroll down find
9.http://localhost/concrete/index.php/login/change_password/lbfLxbskO... yours maybe different
10. copy paste to browser
11. reset password
AccountDisabled replied on at Permalink Reply
If you don't want any of the manual fuss and don't mind having a new account created then try outhttp://forestmist.org/2012/07/concrete5-instant-admin/...

Perfect for situations where you don't have email reset capability, don't want to wait or don't have a MySQL tool handy.

Cheers!
steveholtam replied on at Permalink Reply
THANKS!!!!

The above tool got me into the my companies site after the old guy quit. It was frustrating as heck to have FTP access, minus the DB files for some reason and not being able to enter the C5 dash.
HOBOcs replied on at Permalink Reply
HOBOcs
Thanks for posting - came in handy today when I tried to access an old version website via xampp localhost.