Login failure - does not recognize password

zoltandragon · 2021-12-22 09:59:06

Hi, I hope someone could guide me in this issue (help appreciated, really-really-truly). I have an old TXP site, running 4.2.0, php5.2 (I know…). I want to update to the latest release, but need to do some housekeeping first. However, I cannot enter the admin panel, as I get the following error (sensitive data reducted, of course, but I hope the error message is clear without it):

Warning: execute command denied to user 'db_user'@'localhost' for routine 'db_name.old_password' select name from txp_users where name = 'admin' and (pass = password(lower('thisisapassword')) or pass = password('thisisapassword') or pass = old_password(lower('thisisapassword')) or pass = old_password('thisisapassword')) and privs > 0 in /home/sitedirectory/public_html/textpattern/lib/txplib_db.php on line 85

Any help much appreciated, it would be crucial for me to enter the admin panel before proceeding with any new plan.
Thank you in advance :)

etc · 2021-12-22 10:31:54

Hi, what is your MySQL version? OLD_PASSWORD support has been removed since MySQL 5.7.5.

zoltandragon · 2021-12-22 10:51:10

etc wrote #332278:

Hi, what is your MySQL version? OLD_PASSWORD support has been removed since MySQL 5.7.5.

Hi, if I’m not mistaken, it is 5.7.36 (the web client is 5.6.43) (as you can see, I have no idea… :D sorry about that, I am far from being a developer).

Is there any workaround that solves this problem?

Thank you.

etc · 2021-12-22 11:05:56

zoltandragon wrote #332280:

Is there any workaround that solves this problem?

There is always a workaround :-) But I’m not a pro dev, so take these with caution:

either tmp switch to pre 5.7.5 MySQL
or check/grant php user EXECUTE privileges
or edit txp_auth.php code

zoltandragon · 2021-12-22 11:13:48

etc wrote #332281:

There is always a workaround :-) But I’m not a pro dev, so take these with caution:

either tmp switch to pre 5.7.5 MySQL

or check/grant php user EXECUTE privileges

or edit txp_auth.php code

oh, yeah, I did hope so :D The last option seems to be the most accessible – but what exactly would you suggest I edit in the code of the file?

etc · 2021-12-22 11:53:58

zoltandragon wrote #332282:

what exactly would you suggest I edit in the code of the file?

You can try to replace

if (version_compare(mysql_get_server_info(), '4.1.0', '>='))

on line 44 of textpattern/include/txp_auth.php with if (false). At worst, you will not be able to login :-)

zoltandragon · 2021-12-22 13:01:34

etc wrote #332283:

You can try to replace

if (version_compare(mysql_get_server_info(), '4.1.0', '>='))...

on line 44 of textpattern/include/txp_auth.php with if (false). At worst, you will not be able to login :-)

OMG, you’re a national treasure, it works like a charm! Thank you very much for your help :)

Destry · 2021-12-22 17:05:57

etc wrote #332281:

But I’m not a pro dev

You have ‘em fooled.

jakob · 2021-12-22 18:25:44

Destry wrote #332287:

You have ‘em fooled.

:-) Absolutely

Textpattern CMS

Textpattern CMS support forum

#1 2021-12-22 09:59:06