Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
MySQL / Percona OLD_PASSWORD
Having an issue logging in on a Txp system that uses the (alleged) drop-in replacement MySQL database Percona. I was just getting ‘Internal error’ and it dumped me back at the login page.
After doing some digging and outputting debug info, the issue is that:
ERROR 1305 (42000): FUNCTION dbname.OLD_PASSWORD does not exist
Presumably it’s been removed from Percona, though appears to still be supported in MySQL 5.7. Unsure about its status in MariaDB.
Although we don’t officially support non-MySQL databases in our system requirements, some hosts (and local LAMP stacks such as XAMPP) are switching over to MariaDB and Percona as their default database solution.
So, should we handle this and, if so, how?
- Find some way to sniff the database environment or do feature detection so we can omit the test for OLD_PASSWORD logins on systems that don’t support it?
- Remove OLD_PASSWORD entirely from the
txp_auth.php
, which would mean people upgrading from, like, gamma would be inconvenienced. Cross-ref this issue. - Stick with only supporting official MySQL and be damned with these newfangled forks.
- Something else…
Thoughts?
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Offline
Re: MySQL / Percona OLD_PASSWORD
Bloke wrote #298438:
- Remove OLD_PASSWORD entirely from the
txp_auth.php
This. OLD_PASSWORD was introduced with MySQL 4.1, released in October 2004.
Offline
Pages: 1