Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: Textpattern CMS demo site
colak wrote #318235:
Just a heads up. Visiting the demo urls I get this warning
Thanks, Yiannis – I’m investigating now.
Offline
Re: Textpattern CMS demo site
colak wrote #318235:
Just a heads up. Visiting the demo urls I get this warning
Resolved – it looks like a corrupted TLS certificate renewal config. Repaired and renewed, back on the air.
Offline
Re: Textpattern CMS demo site
gaekwad wrote #318237:
Resolved – it looks like a corrupted TLS certificate renewal config. Repaired and renewed, back on the air.
Yes! -at least from here.
Where is that emoji for a solar powered submarine when you need it ?
Sand space – admin theme for Textpattern
phiw13 on Codeberg
Offline
Re: Textpattern CMS demo site
? All looks fine again!
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: Textpattern CMS demo site
After some system library additions and tweaks, I am pleased to say the dev-demo site is now running on PHP 7.4.0-alpha1 — released yesterday. As the PHP 7.4 alpha releases turn into beta and GA releases, I will keep them updated.
No Textpattern testing done on my side, but it didn’t explode in a shower of errors, so that’s good.
Last edited by gaekwad (2019-06-25 10:35:43)
Offline
Re: Textpattern CMS demo site
… dev-demo now running PHP 7.4-alpha2, and according to the roadmap it’s set for GA release at the end of November 2019. Initial benchmarks show performance improvements over previous 7.* releases.
Offline
Re: Textpattern CMS demo site
Bumped Nginx to 1.17.3 to address 3x CVEs relating to HTTP/2.
Offline
Re: Textpattern CMS demo site
As of moments ago, dev-demo is running on PHP 7.4 RC1.
It is expected there will be six (6) release candidates before the general availability release toward the end of November 2019.
Offline
Re: Textpattern CMS demo site
I’m pleased to report dev-demo is now running PHP 7.4 RC2.
Both release-demo and beta-demo will stay on the latest stable PHP, currently the PHP 7.3 branch.
Offline
#100 2019-09-24 16:34:11
Re: Textpattern CMS demo site
release-demo bumped to PHP 7.3.10 (compiling now).
dev-demo and release-demo now running on Nginx 1.17.4 (pending reload).
Offline
#101 2019-10-01 09:50:33
Re: Textpattern CMS demo site
I’m pleased to report dev-demo is now running PHP 7.4 RC3.
Offline
#102 2019-10-01 10:41:44
Re: Textpattern CMS demo site
Love running dev on the latest bleeding edge code, thank you. Really helpful to catch issues early that are coming down the pipeline from the PHP team and would bite us.
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Hire Txp Builders – finely-crafted code, design and Txp
Online
#103 2019-10-05 12:10:21
Re: Textpattern CMS demo site
SQL nerds, I have some great news for you.
Each demo site rebuilds every three hours, and a .sql script creates ~6000 users for each site. Until today, this was the syntax used:
INSERT INTO `txp_users` (`user_id`, `name`, `pass`, `RealName`, `email`, `privs`, `last_access`, `nonce`)
VALUES
(1,'managing-editor1',PASSWORD('managing-editor1'),'Managing Editor #1','managing-editor1@example.com',2,NULL,''),
(2,'managing-editor2',PASSWORD('managing-editor2'),'Managing Editor #2','managing-editor2@example.com',2,NULL,''),
(3,'managing-editor3',PASSWORD('managing-editor3'),'Managing Editor #3','managing-editor3@example.com',2,NULL,''),
(4,'managing-editor4',PASSWORD('managing-editor4'),'Managing Editor #4','managing-editor4@example.com',2,NULL,''),
(5,'managing-editor5',PASSWORD('managing-editor5'),'Managing Editor #5','managing-editor5@example.com',2,NULL,''),
[…]This works fine in MySQL 5, which is what the demo sites run on, but it does not work in MySQL 8, which is the current version. Oleg (known around here as etc) provided an alternative syntax, so now the syntax looks like this:
INSERT INTO `txp_users` (`user_id`, `name`, `pass`, `RealName`, `email`, `privs`, `last_access`, `nonce`)
VALUES
(1,'managing-editor1',CONCAT('*', SHA1(UNHEX(SHA1('managing-editor1')))),'Managing Editor #1','managing-editor1@example.com',2,NULL,''),
(2,'managing-editor2',CONCAT('*', SHA1(UNHEX(SHA1('managing-editor2')))),'Managing Editor #2','managing-editor2@example.com',2,NULL,''),
(3,'managing-editor3',CONCAT('*', SHA1(UNHEX(SHA1('managing-editor3')))),'Managing Editor #3','managing-editor3@example.com',2,NULL,''),
(4,'managing-editor4',CONCAT('*', SHA1(UNHEX(SHA1('managing-editor4')))),'Managing Editor #4','managing-editor4@example.com',2,NULL,''),
(5,'managing-editor5',CONCAT('*', SHA1(UNHEX(SHA1('managing-editor5')))),'Managing Editor #5','managing-editor5@example.com',2,NULL,''),
[…]This also works fine in MySQL 5.7 (possibly earlier too, but I haven’t checked), and should also work in MySQL 8.0
As of now, the CONCAT() route is what we’re using. There should be no change in availability, but things are a bit faster and we’re getting ready for a jump to MySQL 8.0, perhaps running a dual-version’d MySQL on the demo server.
As always, please report any problems here and I will investigate.
Thanks for the tip, etc!
PS: for the speed heads…the legacy PASSWORD() route takes ~750ms to splat the table and insert ~6,000 users and the CONCAT() route takes ~720ms to do the same thing. As I understand it, it will be even faster with MySQL 8.0.
Offline
#104 2019-10-05 13:24:34
Offline
#105 2019-10-06 16:06:14
Re: Textpattern CMS demo site
etc wrote #319535:
Seems to work fine on 5.7, waiting for 8.0 switch.
I’m hoping to do some tests with a server build in the next week, if the tests are successful then we’ll have Persona (MySQL) 8.0 to play with.
Offline