Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
#1 2020-05-15 06:05:30
- marios2
- Member
- From: Germany
- Registered: 2019-07-31
- Posts: 76
login localhost txp 4.7.3 fail
I am running a local installation of 4.7.3 on my Mac Book Air and are no longer able to login to the backend.
NOTE: The old password is lost and the mail new login feature does obviously not work.
Neither does a reset from within the database, since passwords are md5 hashed.
What to do?
Thanks in advance everyone and stay healthy.
Offline
Re: login localhost txp 4.7.3 fail
Hi Marios,
This post by Jakob should be of help.
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: login localhost txp 4.7.3 fail
Marios,
does this procedure (TXP docs) work for you ?
It did for me with Sequel Pro and a TXP 4.7x running on my MBA
Where is that emoji for a solar powered submarine when you need it ?
Sand space – admin theme for Textpattern
Offline
Re: login localhost txp 4.7.3 fail
What can also work is if you have another installation with a password you know, you can copy across that user to the db you cannot access.
(pre step: backup the DB first :-)
- Access the db with the working user/pw and copy that row as an SQL insert command. In Sequel Pro if you can do that very easily via the right-click menu.
- Now access your problem database and go to the query insert panel.
- Paste in the command but don’t run it just yet.
- Change the “id” number in the insert row to an unused ID and run the query.
- You should have yourself twice in the list. Delete the old user row.
- Log in with the working user/pw
TXP Builders – finely-crafted code, design and txp
Offline
#5 2020-05-15 11:53:27
- marios2
- Member
- From: Germany
- Registered: 2019-07-31
- Posts: 76
Re: login localhost txp 4.7.3 fail
Running the query directly didn’t work. There are some error messages like last access can not be null, and so on..
(The query from colaks post most likely does not work, because the values don’t match up the table column.)
But I did get it to work, inserting the values manually from within phpmyadmin.
phiwi13, interesting! So it is finally not the weak md5 algorithm, but the much stronger SHA1.
Well, I did not try this yet, but anyway, now I don’t have to.
Thanks again, dear folks. The support here is gold.
Marios
Last edited by marios2 (2020-05-15 12:03:00)
Offline
#6 2020-05-15 12:10:00
- marios2
- Member
- From: Germany
- Registered: 2019-07-31
- Posts: 76
Re: login localhost txp 4.7.3 fail
What can also work is if you have another installation with a password you know, you can copy across that user to the db you cannot access.
Jacob, nice workaround.
I finally got it to work entering the encrypted hash values manually from within phpmyadmin.
Running your query example from colaks post does not work, because the values do not match up the tablecolums and thus produces error messages.
phiw13, interesting, good catch! So it is finally not the weak md5 algorithm, but the much stronger SHA1.
Thanks again to everyone, the support here is Gold!
Marios
Last edited by marios2 (2020-05-15 12:17:40)
Offline
Pages: 1