add wordpress site for register.freezingsaddles.org

[obscurerichard]

It would be valuable to have the WordPress registration site hosted on the freezingsaddles.org domain - we can secure it with SSL via LetsEncrypt easily, and it would let us do more direct integration with the database of registrants eventually.

It's possible to run WordPress via Docker and Docker Compose. The current registration site. http://s94971567.onlinehome.us , administered by Carol C., uses Updraft Plus as a backup solution. I did a proof of concept migration of this in November, 2021.

To do this I installed Wordpress via Docker (see #19 ) and then attempted to do a restoration of backups. I first tried to use the https://wordpress.org/plugins/all-in-one-wp-migration/ plugin, but I could not get it to restore, so I did a second pass of restoration using the Updraft Plus backup plugin, where I restored the backups from Dropbox from the other site. I edited the database backup file to replace http://s94971567.onlinehome.us with https://register.freezingsaddles.org and then put the backup files in place in /opt/compose/wordpress/wp-content/updraft, and I was able to do a restoration. Without editing the database files the Updraft restore complained that this was a migration not a restore and I had to get a premium license. No thanks!

The resulting installation had Ninja Forms in place and looks like it is at least partially functioning. To prevent confusion, I disabled automatic backups on the register.freezingsaddles.org site since it looks like the restore put the configuration of Updraft Plus that includes the Dropbox token into place.

There were some issues though that we would need to resolve before making a switch:

• Resolve issue with MailPoet requiring a PDO MYSQL PHP Extension: “MailPoet Error: MailPoet requires a PDO_MYSQL PHP extension. Please read our instructions on how to resolve this issue.”
• Test whether mail is working - this may require fixes to MailPoet and possibly to the WP Mail SMTP plugin - this is configured with SendGrid currently
• Test whether backups are working and going to Dropbox - and re-enable automatic daily backups - I set them to manual.
• Fix up WordFence configuration for .htaccess - see below
• Get any changes to .htaccess and wp-config.php into version control, without compromising credentials
• Have Carol do some exploratory testing to make sure that essential site functions are working.

Carol investigated and expanded on the list:

In general, it seems to be working well—thanks for all your work on this! It will need a few tweaks before it is ready for use. Given that you’re dealing with a much more serious issue right now (getting the site to read the Strava data), and we won’t be using the new site this year anyway, we can defer action on these. However, just noting for later:

• Something is messed up in the theme. My site works off of the Twenty Thirteen Child theme, which is basically Twenty Thirteen with some tweaks that set the header image and some styling. It looks like maybe that theme did not make it over, so the site is just using Twenty Thirteen.
• We’ll need to do some stuff to get the mail working, because I have to set up a new API key and verify the domain with SendGrid.
• I’ll need to update the Recaptcha so it works with a different domain.

MailPoet requires PDO MYSQL PHP Extension

MailPoet Error: MailPoet requires a PDO_MYSQL PHP extension. Please read our instructions on how to resolve this issue. We should probably use a Dockerfile and docker-compose to do this.

WordFence .htaccess fixes

WordFence is complaining:

To make your site as secure as possible, take a moment to optimize the Wordfence Web Application Firewall: https://register.freezingsaddles.org/wp-admin/admin.php?page=WordfenceWAF&subpage=waf_options#configureAutoPrepend

Changes to .htaccess and wp-config.php

I used the advice in https://help.servmask.com/2018/10/27/how-to-increase-maximum-upload-file-size-in-wordpress/ to increase the maximum upload file size and processing times. Those changes are just in the .htaccess and wp-config.php files on the server currently though., If we need those we should save them in version control and put at least a note in the README for a runbook, or script the care and feeding of those files.

[obscurerichard]

This is not really fully resolved, we still need to do testing and integration.