Textpattern CMS support forum

You are not logged in. Register | Login | Help

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

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 7,320
Website

Re: Textpattern CMS demo site

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


Yiannis
——————————
neme.org | hblack.net | LABS | State Machines | Respbublika! | NeMe @ github

Offline

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

gaekwad
Admin
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 2,574

Re: Textpattern CMS demo site

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!

Offline

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

gaekwad
Admin
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 2,574

Re: Textpattern CMS demo site

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

Offline

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

gaekwad
Admin
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 2,574

Re: Textpattern CMS demo site

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.

Offline

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

gaekwad
Admin
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 2,574

Re: Textpattern CMS demo site

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

KAPOW!

Offline

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

gaekwad
Admin
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 2,574

Re: Textpattern CMS demo site

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.

Offline

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

etc
Developer
Registered: 2010-11-11
Posts: 3,296
Website

Re: Textpattern CMS demo site

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.

Offline

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

gaekwad
Admin
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 2,574

Re: Textpattern CMS demo site

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.

Offline

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

phiw13
Plugin Author
From: Japan
Registered: 2004-02-27
Posts: 1,693
Website

Re: Textpattern CMS demo site

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)

Offline

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

gaekwad
Admin
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 2,574

Re: Textpattern CMS demo site

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)

Offline

Board footer

Powered by FluxBB