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.
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';
Arghh, I kept getting an empty sitemap.xml. I tried different plugins, changed settings — nothing. I removed an empty file sitemap.xml still nothing. Finally, I noticed a site map.xml.gz — presto, it works. Much better.
I was having problems with MarsEdit after updating to OpenSuse 11.1 because of a bug in php aggravated by a recent release of libxml2 (details here).
I was waiting for a real fix but lost my patience today. The advice was to “fall back to libxml2-2.6.32” so here’s what I did: