Migrate WordPress Blog

I wanted to move my WordPress blog to my Openmediavault server to consolidate my hardware. It use to be that I have this blog on a standalone FreeBSD box.

So what did I do to make this happen? Here are the high level steps that I did.

  1. Prepare the VM.
  2. Move the data.
  3. Run the App.
  • Openmediavault is able to run Docker and also KVM.

I decided to use KVM because I wanted familiarity and I have not have a lot of experience with docker containers. However, I was also successful in migrating my other applications into docker containers ( more on this to follow.)

  • Migrate the data.

I did a database export and copied over my /usr/local/etc and /usr/local/www folders. I imported the data using the mariadb commandline since I have not setup PhpMyAdmin yet. I encountered a snag on the import. It seems that my database will not import unless I did an individual export of the databases. Something to do with the database user conflicts. Another thing with the import is that I have to redo the database users. I had to drop the users, create user, grant privileges, and finally flush privileges.

The configs I had to check the users and groups as well as the root folder (www) and the wp-content.

  • Run the app.

It would have been simpler if I just setup the server the same way. But, I decided to add an NGINX reverse proxy into the mix. I am able to make it work somewhat but ran into an issue when logging into the app.

this is the error I got:

fatal error: uncaught error: call to undefined function ctype_digit() in /usr/local/www/wordpress/wp-content/plugins/jetpack/vendor/automattic/jetpack-connection/legacy/class-jetpack-signature.php:244 stack trace: #0 /usr/local/www/wordpress/wp-content/plugins/jetpack/vendor/automattic/jetpack-connection/src/class-client.php(136): jetpack_signature->sign_request('i9a$fqo@pwxac&o…', 1578694208, 'ldozcjbmxi', 'vbvvpd3yni1/f2m…', 'post', 'https://jetpack…', 'query('jetpack.sso.req…') #3 /usr/local/www/wordpress/wp-content/plugins/jetpack/modules/sso.php(409): jetpack_sso::request_initial_nonce() #4 /usr/local/www/wordpress/wp-content/plugins/jetpack/modules/sso.php(392): jetpack_sso- in /usr/local/www/wordpress/wp-content/plugins/jetpack/vendor/automattic/jetpack-connection/legacy/class-jetpack-signature.php on line 244

I googled for days but I could never find any solution on the net. I finally decided to try to uninstall the Jetpack plugin. I had to go to wordpress.com and disconnect my blog. Once , I did that I was able to login. I then was able to update WordPress and re-enable the jetpack plugin. Booyah!!!

Gallery 3 no more..

gallery
Gallery

I recently found out that Gallery is going to hibernation, when I was trying to update my install. It’s sad but really understandable. Everybody has their own lives and I could attest to that. People move on and prioritize more important things such as family, school or work.

In light of all of this, I have decided to just move all my photos to my wordpress blog. This would consolidate all my photos since I am mostly using WP to post photos anyway. The only problem is how do I upload my photos to my WP. Physically, all my photos are on the same server albeit on a different hard drive . But, there isn’t a clear way to upload my stuff to WP. I found a plugin “Add from Server” which at first looked promising but It failed the first time I tried it. I am thinking I can just add the photos through PhpMyadmin. I need to investigate further.