Author Archives: tighe

I’m back!

It’s been a while since I’ve been on the air. Actually, a bit over 3 years since my Elecraft K-Line (K3, P3, and KPA500) has been out of storage and powered up. It took a full day to get everything out and hooked up along with getting my old Hustler 6BTV setup. Everything worked as expected and I made a couple of contacts on 40m. I need to get the 160/80m wire antenna up.

This being the first time I’ve operated from our property in TN, it’s nice to be in a relatively RF quiet place compared to our previous QTH in SC.

Goodbye Joomla!

It took a little work, but I’m now migrated from Joomla to WordPress.  Here’s how I migrated:

  • Used Akeeba Backup to get a full backup of my Joomla site and download it locally.
  • Created a local linux virtual machine and installed Joomla, then restored the Akeeba backup.
  • Created another local linux virtual machine and installed Joomla.
  • Using the FG Joomla to WordPress tool, I migrated the site.
  • After migrating, I was able to do cleanup and customize the new site.
  • Created a backup of the new WordPress site using UpdraftPlus, then uploaded to my GCP instance.
  • Created a new Docker WordPress container and configured Nginx for the new container to support testing.
  • Restored the WordPress backup to the new container and did final testing and cleanup of the site.  One important step was fixing URL references in the database.  I connected to MariaDB and used these queries:
UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl', 'http://www.newurl') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl');
UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldurl', 'http://www.newurl');
UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl','http://www.newurl');
  • To go live with the new site, it was just a matter of changing the back-ed port forwarding in Nginx.  Both the live and testing sites are forwarding to the same back-end container so all works as it should.
  • Then a final clean-up Nginx port forwarding and the database using the above SQL queries so that I can keep the testing site separate.
  • And of course, remove the Joomla container and database.

Going SSL

With all of the issues around web security, there’s a pretty easy solution using EFF’s certbot and  I use an Nginx proxy in front of everything, so all of the encryption terminates there.  So using certbot with webroot was pretty easy and then it was just a matter of adjusting the Nginx config.

In each site that I migrated to SSL, here’s an example of what the final config looks like.  This works for both Joomla! and WordPress sites behind Nginx.  Nginx listens on http/80 and redirects to https/443.

server {
 listen       80;
 server_name  site_name.come;
 return 301 https://$host$request_uri;

server {
 listen       443 ssl;
 ssl_certificate    /etc/letsencrypt/live/;
 ssl_certificate_key  /etc/letsencrypt/live/;
 ssl on;

location / {
 proxy_set_header Host $host;
 proxy_set_header X-Forwarded-Host $host;
 proxy_set_header X-Forwarded-Proto $scheme;

 proxy_redirect http:// https://;