Tag Archives: virus

Coronavirus: why quarantine?

The article in OurWorldInData.org has this (symbolic) diagram that shows why it’s important to slow down the rate of infection. It’s not to decrease the number of people infected but rather to keep the healthcare system from being overwhelmed and so causing more deaths.

The horizontal line represents the theoretical capacity of the healthcare system.

Flattening the curve

Updating an AWS instance and wordpress multisite hostname

Just in case you haven’t heard about heartbleed or like comic strip explanation. Bruce Schneier has a good run down on how screwed we all are including this link to the logs of a possible exploit half a year ago.
So I figured I better update my server. First off, I’m using an AWS instance to host the web site. I’m both proud and embarrassed. The system has been up for 11 months.

$ uptime
 11:22:33 up 339 days,  9:34,  1 user,  load average: 0.14, 0.84, 0.84

Updating the software was fairly easy

sudo apt-get update {.sh}
sudo apt-get upgrade
sudo apt-get dist-upgrade

But it pretty much required a reboot to make sure everything was using the new libraries.
After that was done my wordpress installation was using the wrong hostname. Here are the tables I updated. The id, blog_id and table name wp_options are somewhat specific to my installation.

update wp_sitemeta set meta_value = 'https://peteware.com/' where meta_key = 'siteurl';
update wp_site set domain = 'peteware.com' where id = 1;
update wp_blogs set domain = 'peteware.com' where blog_id = 1;
update wp_options set option_value = 'http://peteware.com' where option_name = 'siteurl';
update wp_options set option_value = 'http://peteware.com' where option_name = 'home';