Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#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

#2 2020-05-15 06:32:26

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,093
Website GitHub Mastodon Twitter

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

#3 2020-05-15 07:18:46

phiw13
Plugin Author
From: Japan
Registered: 2004-02-27
Posts: 3,227
Website

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

#4 2020-05-15 09:16:57

jakob
Admin
From: Germany
Registered: 2005-01-20
Posts: 4,743
Website

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

Board footer

Powered by FluxBB