{"id":303,"date":"2018-12-19T21:06:15","date_gmt":"2018-12-19T21:06:15","guid":{"rendered":"https:\/\/www.douglaskirk.ca\/?page_id=303"},"modified":"2018-12-22T04:12:06","modified_gmt":"2018-12-22T04:12:06","slug":"server-setup","status":"publish","type":"page","link":"https:\/\/www.douglaskirk.ca\/index.php\/server-setup\/","title":{"rendered":"Server Setup"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

My Linux server is hosted on a powerful pink Toshiba Portege M800 that\u00a0<\/span>I had purchased it for my wife at Best Buy one Christmas. and it performed well till it’s battery and speed caught up with it.<\/span><\/p>

Now it’s a little Ubuntu 18.04 Server running my two websites and a Minecraft server for my boys.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t

\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

My Server Notes<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

My goal in this section is to list a few helpful things I came across.<\/p>

Please note this is a ongoing scrap page of misc notes. A work in progress.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

www.digitalocean.com is a very useful site that I referenced to setup this site with.<\/p>

The first being:<\/p>

How To Install WordPress with LAMP on Ubuntu 18.04<\/p>

https:\/\/www.digitalocean.com\/community\/tutorials\/how-to-install-wordpress-with-lamp-on-ubuntu-18-04<\/span><\/pre>
The second being:<\/p>
How To Install Linux, Apache, MySQL, PHP (LAMP) stack on Ubuntu 18.04<\/p>
https:\/\/www.digitalocean.com\/community\/tutorials\/how-to-install-linux-apache-mysql-php-lamp-stack-ubuntu-18-04<\/pre>
After creating my site, I soon realised that the last time I did this much work, I didn’t have my database backed up and it was not a good day. What make for an even worst day is when you realise that the backup you protected doesn’t seem to work the way you had thought, and something seems to be missing. With that, I like to do a dry run at rebuilding a mirrored site on another systems and verify everything.<\/p>
WordPress relies on mysql to deal with it’s database, so another site I came across explained how to create a backup easily.<\/p>
How To Copy a MySQL Database<\/p>
http:\/\/www.mysqltutorial.org\/mysql-copy-database\/<\/pre>
I noticed a bunch of errors viewing the wordpress database with phpmyadmin and found a solution at stackoverflow.<\/p>
https:\/\/stackoverflow.com\/questions\/48001569\/phpmyadmin-count-parameter-must-be-an-array-or-an-object-that-implements-co<\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
<\/p>
Note the changes in red.<\/span><\/p>
|| (<\/span>(count($analyzed_sql_results['select_expr'])<\/span> == 1) 
&& (<\/span>(count($analyzed_sql_results['select_tables']))<\/span> == 1);<\/pre>
\u00a0|| (count($analyzed_sql_results[‘select_expr’] == 1)<\/span><\/p>
\u00a0&& count($analyzed_sql_results[‘select_tables’]) == 1;<\/p>
rockstar@mini:~$\u00a0<\/p>
https:\/\/www.howtogeek.com\/323390\/how-to-fix-windows-and-linux-showing-different-times-when-dual-booting\/<\/p>
timedatectl set-local-rtc 1 –adjust-system-clock<\/p>
https:\/\/www.a2hosting.com\/kb\/installable-applications\/optimization-and-configuration\/wordpress2\/resetting-the-wordpress-administrator-password<\/p>
UPDATE `wp_users` SET `user_pass` = MD5( ‘PASSWORD’ ) WHERE `wp_users`.`user_login` = “USERNAME”;<\/p>
https:\/\/www.digitalocean.com\/community\/tutorials\/initial-server-setup-with-ubuntu-18-04<\/p>
Step 5 \u2014 Verifying Certbot Auto-Renewal<\/p>
Let’s Encrypt’s certificates are only valid for ninety days. This is to encourage users to automate their certificate renewal process. The certbot package we installed takes care of this for us by adding a renew script to \/etc\/cron.d. This script runs twice a day and will automatically renew any certificate that’s within thirty days of expiration.<\/p>
To test the renewal process, you can do a dry run with certbot:<\/p>
sudo certbot renew –dry-run<\/p>
If you see no errors, you’re all set. When necessary, Certbot will renew your certificates and reload Apache to pick up the changes. If the automated renewal process ever fails, Let\u2019s Encrypt will send a message to the email you specified, warning you when your certificate is about to expire.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"
My Linux server is hosted on a powerful pink Toshiba Portege M800 that\u00a0I had purchased it for my wife at Best Buy one Christmas. and it performed well till it’s battery and speed caught up with it. Now it’s a little Ubuntu 18.04 Server running my two websites and a […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-templates\/template-fullwidth.php","meta":{"footnotes":""},"class_list":["post-303","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.douglaskirk.ca\/index.php\/wp-json\/wp\/v2\/pages\/303","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.douglaskirk.ca\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.douglaskirk.ca\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.douglaskirk.ca\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.douglaskirk.ca\/index.php\/wp-json\/wp\/v2\/comments?post=303"}],"version-history":[{"count":10,"href":"https:\/\/www.douglaskirk.ca\/index.php\/wp-json\/wp\/v2\/pages\/303\/revisions"}],"predecessor-version":[{"id":322,"href":"https:\/\/www.douglaskirk.ca\/index.php\/wp-json\/wp\/v2\/pages\/303\/revisions\/322"}],"wp:attachment":[{"href":"https:\/\/www.douglaskirk.ca\/index.php\/wp-json\/wp\/v2\/media?parent=303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}