Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#61 2018-08-04 11:19:08

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 3,632
GitHub

Re: Textpattern CMS demo site

Expect some demo site bumpiness this afternoon, I have a rebuild to do.

Should be back online properly by 1800UTC or before.

Offline

#62 2018-08-04 16:09:38

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 3,632
GitHub

Re: Textpattern CMS demo site

Sites are back online. Changes:

  • added specimen Files
  • added some descriptions to Images and Files
  • server updated (info below if you’re interested)
Textpattern version: 4.7.1 (8556b02a5a91658745d1d493ff8ab322)
PHP version: 7.2.7-0ubuntu0.18.04.2
GD Graphics Library: 2.2.5; Supported formats: GIF, JPEG, PNG.
Server timezone: Europe/Berlin
Time zone (GMT offset in seconds):  (+0)
MySQL: 5.7.22-22 (Percona Server (GPL), Release '22', Revision 'f62d93c') 
Web server: nginx/1.15.2
PHP server API: fpm-fcgi
Server OS: Linux 4.15.0-29-generic

Offline

#63 2018-08-06 09:01:39

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 3,632
GitHub

Re: Textpattern CMS demo site

Seeing some strangeness on the scheduled rebuild for release-demo.textpattern.co – investigating.

Offline

#64 2019-02-15 19:44:36

etc
Developer
Registered: 2010-11-11
Posts: 4,517
Website GitHub

Re: Textpattern CMS demo site

The dev-demo seems to serve the — very clean — Zero theme. :-)

Offline

#65 2019-02-15 19:53:38

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 3,632
GitHub

Re: Textpattern CMS demo site

etc wrote #316615:

The dev-demo seems to serve the — very clean — Zero theme. :-)

…but it loads really fast!

I’ll take a look -thanks for the report, etc.

Edit: fixed. The auto-installer was looking for a theme called four-point-seven, which doesn’t exist. Changed to four-point-eight, all working now.

Last edited by gaekwad (2019-02-15 19:57:57)

Offline

#66 2019-02-23 20:05:44

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 3,632
GitHub

Re: Textpattern CMS demo site

Demo site server overhaul this evening, should be online again by 2300UTC 0200UTC Feb 24 2019.

Last edited by gaekwad (2019-02-23 22:45:17)

Offline

#67 2019-02-24 00:57:11

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 3,632
GitHub

Re: Textpattern CMS demo site

Demo site server is back. Now running PHP 7.3.2 and Percona-flavoured MySQL 5.7:

Textpattern version: 4.8.0-dev (a5f74823bb9b889c8081b5701f55c239)
Last update: 2019-02-24 00:51:55/2019-02-24 00:50:58
Site URL: dev-demo.textpattern.co
Admin URL: dev-demo.textpattern.co/textpattern
Document root: /var/www/vhosts/textpattern.co/dev-demo/live
$path_to_site: /var/www/vhosts/textpattern.co/dev-demo/live
Textpattern path: /var/www/vhosts/textpattern.co/dev-demo/live/textpattern
Article URL pattern: section_title
Production status: testing
Temporary directory path: /var/www/vhosts/textpattern.co/dev-demo/live/textpattern/tmp
PHP version: 7.3.2
GD Graphics Library: bundled (2.1.0 compatible); Supported formats: GIF, JPEG, PNG, WebP.
Server timezone: Europe/Berlin
Server local time: 2019-02-24 01:51:59
Daylight Saving Time enabled?: 0
Automatically adjust Daylight Saving Time setting?: 0
Time zone (GMT offset in seconds):  (+3600)
MySQL: 5.7.25-28 (Percona Server (GPL), Release '28', Revision 'c335905')

For full disclosure, I intended to rebuild the server with Percona-flavoured MySQL 8, which is a drop-in replacement for Oracle-flavoured MySQL 8 but I found some issues with GRANT OPTION privileges that manifested as broken imports and I haven’t managed to fix it (i.e tired eyes).

So, for now, we’re on current PHP and a well-established database version. I have some plans for the next iteration of the demo site, and I’ll share these in time. Please know that it’s ready to receive the next patch release of Textpattern CMS which will, all being well, be coming very soon.

Thanks for your patience.

Offline

#68 2019-03-02 10:04:19

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 3,632
GitHub

Re: Textpattern CMS demo site

Investigating a PHP failure. Sites down. Please stand by.

Edit: fixed. Sites up.

Last edited by gaekwad (2019-03-02 10:05:54)

Offline

#69 2019-03-05 16:39:21

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 3,632
GitHub

Re: Textpattern CMS demo site

Investigating a different PHP failure. Sites down. Please stand by.

Edit: sites back but a bit wobbly, further investigation underway.

Last edited by gaekwad (2019-03-05 17:12:35)

Offline

#70 2019-04-02 17:57:52

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 3,632
GitHub

Re: Textpattern CMS demo site

PHP updating to 7.3.4 (source compiling as I type this), and the associated infrastructure beefed up to withstand global thermonuclear war systemctl and its behaviours.

Offline

#71 2019-04-07 18:09:27

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 3,632
GitHub

Re: Textpattern CMS demo site

Demo sites offline for a few hours of bumps while I move to a new datacenter.

Should be back online by 2200UTC.

Offline

#72 2019-04-07 20:33:21

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 3,632
GitHub

Re: Textpattern CMS demo site

My intentions for this evening were to set up a new server with Percona-flavoured MySQL 8.0, latest PHP, plus extra turbo trimmings for performance and security in an Amsterdam datacenter.

I have achieved 99% of this, but one thing is incomplete so I have reverted to the pre-existing server: how to best handle users in MySQL 8.0.

At a high level, the demo sites run on a collection of Bash scripts that fire over the day. Every three hours, the sites are rebuilt. Behind the scenes, this involves:

  • gathering some files from GitHub
  • teardown of the existing site scaffold
  • rebuild of the scaffold from scratch
  • automatic installation of Textpattern
  • add some files
  • add some images
  • add some users

…and this is largely how things have been for nearly 5 years. Very few snags, mostly runs like clockwork.

The last item on that list — add some users — is where I’m falling down. On MySQL 5.7, it’s straightforward to add a heap of users with corresponding passwords in a .sql file:

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,''),
(6,'managing-editor6',PASSWORD('managing-editor6'),'Managing Editor #6','managing-editor6@example.com',2,NULL,''),
(7,'managing-editor7',PASSWORD('managing-editor7'),'Managing Editor #7','managing-editor7@example.com',2,NULL,''),
(8,'managing-editor8',PASSWORD('managing-editor8'),'Managing Editor #8','managing-editor8@example.com',2,NULL,''),
(9,'managing-editor9',PASSWORD('managing-editor9'),'Managing Editor #9','managing-editor9@example.com',2,NULL,''),
(10,'managing-editor10',PASSWORD('managing-editor10'),'Managing Editor #10','managing-editor10@example.com',2,NULL,'');

(repeat for about six thousand lines, it’s about 630KB on a drive)

In MySQL 8.0, the PASSWORD() function has been removed…which means I can’t set the password automatically. It’s not currently clear to me how I can get around this, since substituting instances of PASSWORD with MD5 doesn’t help, and when I log in as one of the auto-added users, Textpattern throws an Internal Error modal and will go no further.

I will continue to look into this and flip the switch to the new server when I’ve solved it. For now, the demo server continues to live in Frankfurt.

In the meantime, you’re much smarter than I am — which is why I’m here — what can I change in the above user syntax that might yield better results?

Offline

Board footer

Powered by FluxBB