Textpattern CMS demo site

gaekwad · 2019-10-07 08:01:21

colak wrote #319558:

I cleared all cookies in FF, my default browser but the error maintained.

How strange. Are you using an exotic flavour of Firefox?

colak · 2019-10-07 09:28:38

The latest stable release on mac. 69.0.2 (64-bit)

colak · 2019-10-07 10:43:47

Hi Pete, I don’t know if you have done anything but everything started working just fine from here.

gaekwad · 2019-10-07 11:50:06

colak wrote #319563:

I don’t know if you have done anything but everything started working just fine from here.

I haven’t touched it, but I’m glad it’s working for you!

gaekwad · 2019-10-07 11:51:00

Please expect a bit of turbulence on the demo sites over the next 4 hours as I switch servers.

gaekwad · 2019-10-07 12:44:25

Alright, Percona 8.0 is installed and running. That was…enlightening. Some syntax changes in the SQL queries, so expect a few updates on the docs site when I’ve figured it out. There might be a brief write up here if anyone’s interested, but that’s a way off timescale-wise.

For info — and any developer person who can correct inaccuracies is very welcome to jump in and say something — I think Textpattern uses mysqli, and MySQL 8 has a different method of authentication by default which mysqli doesn’t like, so I’ve switched it to the legacy auth method called mysql_native_password. That works, with caveats.

Previously, to create a database and user for MySQL 5.*, I used this syntax:

CREATE DATABASE databasename CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
CREATE USER 'databaseuser'@'127.0.0.1' IDENTIFIED BY 'plaintextpassword';
GRANT ALL PRIVILEGES ON databasename . * TO 'databaseuser'@'127.0.0.1';
FLUSH PRIVILEGES;

…and now, this seems to work:

CREATE DATABASE databasename CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
CREATE USER 'databaseuser'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY 'plaintextpassword';
GRANT ALL ON databasename . * TO 'databaseuser'@'127.0.0.1';
FLUSH PRIVILEGES;

Note the changes in lines #2 and #3.

gaekwad · 2019-10-07 12:45:15

I’m pleased to report dev-demo is now running PHP 7.4 RC3 and Percona (MySQL) 8.0.

KAPOW!

gaekwad · 2019-10-07 13:39:31

I’ve spent some time today building out a new demo server, with a plan to achieve these things:

update dev-demo to have Percona (MySQL) 8.0 and PHP 7.4 (latest release candidate);
update release-demo to have Percona (MySQL) 8.0 and PHP 7.3 (latest point release);
update beta-demo to have Percona (MySQL) 8.0 and PHP 7.3 (latest point release);

I have had mixed success. As mentioned, dev-demo is on Percona 8.0 and PHP 7.4 – so that’s done. The plan to have release-demo and beta-demo bumped to Percona 8.0 didn’t work out exactly as planned:

Textpattern was/is auto-installed, no problem;
users, files and images are installed, no problem;
…and logging in throws a HTTP 401 status, with a generic ‘Internal error’ dialog, and I can’t log in;

So, as of now, dev-demo works fine, and lives in Amsterdam in a new server condo. release-demo and beta-demo still live in Frankfurt for now.

I’ve reverted the DNS so they should all work fine within the hour, assuming your DNS isn’t cached in a horrible way.

Thanks for your patience, and continued interest.

etc · 2019-10-07 15:43:41

Great work Pete, not so great work MySQL 8 – figures (checked in page source) are not any faster than 5.7. Edit: they are not on the same server though.

gaekwad · 2019-10-07 20:01:09

Yes – different server, different loading, and so on. And the VPS it’s on is first rung of the ladder price-wise, so it won’t be especially speedy hardware.

phiw13 · 2019-10-07 22:20:32

Right now (7:19:52 local time, UTC-9) dev-demo is missing all SVG images. Because CSP.

[Error] Refused to apply a stylesheet because its hash, its nonce, or 'unsafe-inline' does not appear in the style-src directive of the Content Security Policy. (index.php, line 13)
[Error] Refused to apply a stylesheet because its hash, its nonce, or 'unsafe-inline' does not appear in the style-src directive of the Content Security Policy. (index.php, line 273)
[Error] Refused to load data:image/svg+xml;charset=utf-8,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 16 16'%3E%3Cpath fill='%23333' d='M2 8l5 5v-3h7V6H7V3z'/%3E%3C/svg%3E because it does not appear in the img-src directive of the Content Security Policy.

(19 in total)

Otherwise – nice work Pete.

Last edited by phiw13 (2019-10-07 22:20:55)

gaekwad · 2019-10-08 07:01:19

phiw13 wrote #319583:

Because CSP.

Hello darkness, my old friend.

I will fix this now – thanks for the report.

Edit: strangely, the unsafe-inline directive is present already. More investigation needed.

Last edited by gaekwad (2019-10-08 07:03:02)

Textpattern CMS

Textpattern CMS support forum

#109 2019-10-07 08:01:21

Re: Textpattern CMS demo site

colak wrote #319558:

#110 2019-10-07 09:28:38

Re: Textpattern CMS demo site

#111 2019-10-07 10:43:47

Re: Textpattern CMS demo site

#112 2019-10-07 11:50:06

Re: Textpattern CMS demo site

colak wrote #319563:

#113 2019-10-07 11:51:00

Re: Textpattern CMS demo site

#114 2019-10-07 12:44:25

Re: Textpattern CMS demo site

#115 2019-10-07 12:45:15

Re: Textpattern CMS demo site

#116 2019-10-07 13:39:31

Re: Textpattern CMS demo site

#117 2019-10-07 15:43:41

Re: Textpattern CMS demo site

#118 2019-10-07 20:01:09

Re: Textpattern CMS demo site

#119 2019-10-07 22:20:32

Re: Textpattern CMS demo site

#120 2019-10-08 07:01:19

Re: Textpattern CMS demo site

phiw13 wrote #319583:

Board footer