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
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
The host doesn't seem to allow emails sent to email address' other than the one it is hosting. So:
My email address is:
paul@itsnotrocketscience.com
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!
My email address is:
paul@itsnotrocketscience.com
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!
Check the mysql table "Logs" you'll find the password there once you've hit "Reset password"
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
To respond to your earlier questions:
1) In the database
2) No
3) If logged in go to /profile/edit
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...
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...
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
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
the stored password is a very long series of numbers and letters how do you get the most recent?
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"
check the table called "Logs"
Sorted!!
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?
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?
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.
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
Works a treat for localhost installations too.
Konrad
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
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
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!
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!
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.
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.
Thanks for posting - came in handy today when I tried to access an old version website via xampp localhost.
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.