Just in time for the new plants and trees

Don’t care what they say, I’d still put this in my house

This doge ❤️ the new place

More pieces of the puzzle coming together

Ordered some bar stools 🤷‍♂️

First toasties on the new center griddle

The new Turman *original*

Doge the Destroyer Happy Place

December has really been something

Must get boring living here with the same weather every single day

…or would that be an MDF?

Chill, doge, chill

Bring on the rock trim

One month away – can’t believe it

Coming next month…

It’s coming along nicely

My one real upgrade this time

Turned out really nice – hopefully the move-in date is still a long ways out

Pre-drywall meeting was a success

A little more progress

Happy with the progress this week

Progress seems to be slowing :-/

Hopefully many more to come

Can’t wait to move in

Second floor framing ✅

Can’t wait to see how far they get this week

Exciting visual progress this week

Hope to see some vertical progress next time

…is not like the others

Bring on the slab!

Summer and fall will go quickly, right?

The countdown is on…

…and the foundation frames are gone

Way more progress than I was prepared for…

Can’t believe the neighbor lot went from nothing to framed up in about 30 days

That one was rather fun – ordered all the cat 6

Happy 15th birthday, 7 Minute Miles! Current stats:

• 12,192 Posts
• 216 Pages

Skipping unique visitors or page counts this year, as my web server logs are all mixed up after the big move to AWS Lightsail. I do hope to get that cleaned up soon – want to learn how the new nginx logs differ from Apache (which I used for years). WordPress.com stats report 8,066 visitors in 2020, along with 20,522 views, but I don’t really know how they calculate that. They also report that the “Reflections on Spring Hill Golf Club” post continues to be one of my most visited stories of all time. Rather hoping this will be the year I actually play there…

Won’t get too much into the technical weeds this time, as I have a lot of things cooking right now that I’m sure I’ll cover in more detail soon. Aside from the move to virtual AWS servers, I’m still on WordPress (v5.7) with the same old custom theme and the same set of plugins I had last year. Hoping for a new look in 2021, but I don’t know the timing of that launch yet. No new functionality recently – just lots of under the hood things (including a fix for the weird SSL/emoji issue).

Thanks for visiting!

It was really, really nice to have an entire week off work (and someone else to cover on-call). It’s also great to see some movement in the fight against COVID-19, both on the vaccine front and in the sports and entertainment world. I really felt recharged and ready to move forward this morning, as there are a lot of things that need my attention right now:

• Find a vaccine – my tier is up now, so I’ve got tabs open in my browser for all the big providers. Also discovered vaccinespotter.org (above), which is a big help. Briefly thought I snagged one for this afternoon, only to be kicked out of the process at the end (just like a hot concert ticket). And as the new South ParQ Vaccination Special said, “There’s a place in town, very hard to get into, very exclusive. Walgreens.“
• Reconnect at work – continuation of the file server saga, spring cleaning on software licensing and backups, starting a new firewall upgrade project and generally preparing for the return of ticketed guests to the building. Sounds like I might even get to hire some help this summer, which would be super awesome.
• AWS servers – the $100 credit I received from the re:Invent survey is almost used up, so I need to get back to moving this site off of virtual server one and over to the new virtual server I started experimenting with. That way I can shut the first one down and start figuring out a bunch of things on Ubuntu Server 20.04, including virtual host management, transfer of Let’s Encrypt certs, log analysis and WordPress theme development. It’s already been (nerdy) fun switching from Apache to nginx and from MySQL to MariaDB and kicking the tires on PHP8. WordPress 5.7 is the first release in a long time that did something to my (admittedly) ancient theme: the spacing below quote and status posts on the front page is off. Since I use Masonry and jQuery for layout, I thought it had to do with the upgrade of core WP jQuery from 1.12.4 to the 3.5.x tree mentioned here. After testing with the Enable jQuery Migrate Helper plugin, however, I don’t think this is the root cause (my version of Masonry is also pretty old). Stayed tuned…
• Construction – the design center meeting for the new house last week lasted just under four hours and everything has now been finalized and signed. Next, we move on to the electrical meeting, which has been scheduled for early April. So excited!
• Baseball – the announcements last week about fans at CHS Field (2,700) and Target Field (10,000) mean both of our ticket groups are about to fire up again. The Saints begin their new Triple A life at home on May 11th, while the Twins welcome fans back to Minneapolis on April 8th. I don’t know yet how many games we will end up with, but I’m very excited to watch more outdoor baseball in 2021.
• Exercise – my Apple Watch move streak hit 333 days last night, so I’m getting very close to my goal of one full year. Also found out last week that there will be a limited, in-person field for the 2021 Get in Gear 10K, which will include multiple waves and a sidewalk-only course. I was able to snag one of the spots and look forward to running outside more in the coming weeks to prepare.
• Taxes – ugh, just don’t want to start this yet. Also need to do my dad’s taxes one last time too, so that’s a double bummer. Not too scared of the potential financial hit for 2020, just thinking it will be more complex than normal. Hopefully TaxAct is up to the task (as they usually are).

Now back to refreshing those vaccine screens…

Coming soon to Newport

Today I needed to get from I-94 to Brake Bread on West 7th, so I exited at Snelling and headed over to the infamous Short Line. When I got to St. Clair, I thought, “why not swing by Lombard?” Lots of changes starting to appear at the two former family residences (more pics after the jump).

This year will fly by, right?

Haven’t really written much lately – both here or on Twitter (my last remaining social media account). The Banff trip from January 2020 seems like an eternity ago and while I’m very grateful for our health and stability, it’s been a mentally tough twelve months. There are so many things I miss right now: attending live concerts and sporting events, eating out, happy hours with co-workers, walking around the Great Minnesota Get-Together, traveling to Disneyland and Vegas. Luxuries, to be sure, but I still miss them.

So what else is going on? The kids are both doing well. Work for Colleen has been intense (as it is for everyone in healthcare these days). With football season complete, my job is all about planning, budgets and maintenance until the future of events becomes a little clearer. It’s stressful being a department of one (and the 24/7 on call), but I’m trying to balance things as best as I can. The days and nights really all blend together now, as do weekdays and weekends. I’ve noticed a shift lately of time seeming to pass by faster, which is definitely a different vibe from a few months ago. Looking forward to the new Boludo to open near the office.

We’re in house search mode and it’s been absolutely bonkers (that’s my nemesis website above). Everything you read about the real estate market right now is true – almost every new listing is receiving multiple offers on the first day. If it doesn’t, you wonder what’s wrong with the place. We’ve only made one offer so far and were outbid (by a lot). Many showings get canceled before we even get there because they sell so quickly. Hoping more inventory comes online as the weather gets better. We are being patient and prudent for now – it will happen when it happens.

Health-wise, I’ve been feeling pretty good. My move streak is closing in on 300 days, so I’m doing something every day. With the cold weather, that’s mainly been hill walking on the treadmill while I watch Netflix. MK and I did ski a few weekends ago at Spirit Mountain and SK wants to hit up Afton next weekend. Still need to read up on the new Nordic walking sticks and get them configured for my height – it hasn’t been *that* cold out so far (and it would be good to get outside on the sunny days that occasionally roll around). Mixed messages on my eyesight these days: still prefer no glasses with most computer work, but finding I need them more and more for reading and watching TV. Stress eating definitely still an issue.

Lastly, I’ve been spending a lot of my free time at night learning new cloud technology stuff on Amazon Web Services (AWS). Inspired by the free sessions and keynotes posted during the online re:Invent conference, I wanted to build on my experience with moving this site to a Lightsail instance a few months ago. After re:Invent, Amazon sent me a feedback survey and gave me a $100 account credit. About a week ago, I decided to use some of that credit to spin up a second virtual server and learn the LEMP stack on Ubuntu Server 20.04, building it from scratch (instead of using a Bitnami bundle). I’ll write more about that experience soon…

…but a more organized mess

It’s already been eight months since the last one, so let’s do this:

• For my Christmas and birthday gift this year, I got new skis and bindings (returning to my classic Rossi/Marker combo). Had a mixed experience at The House – will probably go back to Joe’s next time.
• With the skis finally here, trying to figure out when I can break them in. Lutsen has some really appealing midweek flex pricing, so that is a leading contender. Might do an Afton or Welch day and still really want to hit Beaver Creek someday (as well as return to Schweitzer).
• I got all excited about responsive, mobile-friendly WordPress themes this week, but have hit a testing roadblock. MAMP worked out of the box with a plain vanilla WordPress install, but I haven’t been able to get this site transferred over successfully.
• Thought about tossing my current theme completely (instead of retro-fitting for mobile) and customizing a theme like this one, but now I’m not sure which direction I want to go.
• Also not entirely 100% behind WordPress these days: don’t like Gutenberg and complexity seems to be increasing overall. Don’t see any great alternatives on the horizon, though.
• I’ve been happier with my transition to AWS, but maintenance and upgrade issues with the Bitnami WordPress Stack are making me reconsider moving to a straight LAMP virtual server instead.
• Yes, I do keep my iPhone boxes (but I’m trying to get better about recycling them).
• We’re house shopping, but this market is crazy aggressive right now. If you know someone in the Twin Cities thinking about selling a good “old people” house, please hit me up.
• Adult ear infections are not for the faint of heart.
• My Apple Watch move streak is closing in on 270 days – shooting for a year, then it can restart whenever.
• I bought a pair of Exerstrider Nordic walking poles after reading the story in the Strib, but I haven’t read the setup and training instructions yet. Seems like it will be fun.
• OWC has agreed to refund the SSD purchase, thereby ending my iMac kernel panic trauma.
• I have temporary computer options in place, but do want to move to an M1 machine. At first I thought I would do a Mac mini with a large, third-party monitor, but the retina screens on the iMacs just look so much better to me. I’ll probably wait for the M1 iMac later this year (with lots of RAM and SSD storage).
• I’m craving a Fuddruckers burger so badly I would consider an eight hour round-trip drive to South Dakota to get one.
• Sad the Vikings season turned out the way it did, but at least we get the Dallas circus back in town later this year. It will be nice to have Wild hockey again soon (helps to be a night owl) and I’m cautiously optimistic about the Twins and the Saints (but don’t get the whole “we’ve invited” thing – is there a deal or not?).
• The first Sunday of the Charlie Parr online residency at First Avenue was so emotional – make sure and catch the rest of them (every Sunday in January at 8 p.m. on his YouTube page) and drop him some money via GoFundMe.
• Speaking of music, we really enjoyed the Bee Gees documentary on HBO – nice job by Frank Marshall (with lots of fun cameos).
• Long live Grogu!

Welcome 2021, nice to have you around…

It’s been two and a half months since I last posted to Instagram (and about two months since I officially deleted both my Facebook and Instagram accounts). It wasn’t that hard to give up Facebook – I really only used it to sync status with a couple of games, promote posts from this site and to communicate with more distant family members. Add to that all of the other reasons people don’t like Facebook and it became a pretty easy decision. Now I just need Two Dots to continue to improve the Facebook-free experience and I’ll be fine (LEADERBOARDS).

Instagram, on the other hand, was a much tougher decision for me. From what I can tell, it launched on iOS in October of 2010 and I posted my first image on Christmas Day 2010. The original pictures were 640×640 and I used Iain Poulson’s excellent Intagrate WordPress plugin for many years to automatically pull my pics from Instagram and create image posts on this site. Facebook purchased the service in April 2012, but largely left it independent (image sizes did increase to 1080×1080 in 2015).

Instagram is the de facto social media standard for restaurants and foodies, so that’s really what I used it for in the beginning. I don’t like accounts that post the same thing across all platforms, so I’d use Facebook, Instagram and Twitter in specialized ways to help prevent overlap. Now that I’m only on Twitter, I initially tried to recreate some of that there, but I’m finding that I need to continue to prune my Twitter follow list and just move on from some things that I know I’m missing. Some examples: Instagram stories from Armon and Meredith, donut pictures from Erin and everything posted by my wife and daughters.

I finally finished merging all of the Instagram metadata they sent me in JSON format with the image files that I uploaded here. Also starting to get back to equilibrium on my main @kingsbury Twitter account (and will continue to use @7minutemiles to link to stories like this one). Really trying to get most of the politics out of my feed too – no real appetite for doomscrolling these days…

After nine plus years of running this site on a Mac mini in a Las Vegas data center, I decided it was time to transition to the big leagues of cloud infrastructure. This world is dominated by Amazon, Microsoft and Google, all of which have a dizzying array of available services at various price points. I messed around with Amazon Web Services (AWS EC2) last year, when they were promoting a limited free tier for nerds to experiment and evaluate. This year I decided to give Lightsail a try, which is basically an easier-to-use, fixed-priced version of AWS that gives you a virtual cloud-based server.

As you can see in the screenshot of the Lightsail console above, I created an instance with 4GB of RAM, two virtual CPUs and 80GB of storage running in Virginia Zone A. I was tempted to just pick a version of Linux and manually compile and install the various components I wanted. In the end, though, I decided to go with the Bitnami WordPress stack (version 5.3.2-3), which gave me Ubuntu Linux 16.04.6, Apache 2.4.31, MySQL 8.0.18 and PHP 7.3.14 (i.e., the LAMP stack). Throw in phpMyAdmin and certbot and you have a good preinstalled foundation on which to built and troubleshoot. I also decided to switch my DNS management from DNS Made Easy to Amazon’s Route 53, but kept domain registration and management at Hover.

I’ve owned a Tenacious D themed domain name for some time now that I use for testing and initially used that when I signed up for Lightsail (“All of a sudden, there shined a shiny demon in the middle of the road.”). Amazon and Bitnami both have great tutorial and support pages and I also need to give a shoutout to Sanjeev at MetaBlogue, who wrote two very useful posts. Also found this post from Amazon to be very helpful for setting up new certs from Let’s Encrypt (who I love). Speaking of certs, I spent some time adjusting the Apache TLS settings to get an “A” rating from Qualys on their cool SSL test site.

It took a while to transfer 15 years worth of site files from the old server to my iMac, then on to the new instance. The database files were also quite large, requiring an increase in the file upload settings in PHP. Switching from the test domain to 7minutemiles.com seemed to go smoothly at first, but I had a problem with my theme files that took longer than I wanted to troubleshoot (it was a case-sensitive URL thing). All seems well now, though, and even my stupid emoji issue from December 2018 seems to have been resolved on the new server. Lightsail offers the ability to create snapshots of the instance (yay!) and it appears that Vaultpress is successfully backing up from the new server too.

Now on to those elusive mobile theme enhancements and new data entry screens…

A few random Sunday night notes:

• The introvert in me is doing just fine, thank you very much.
• Started Yale’s free Science of Well-Being online class and I’m really glad I did (h/t Charles).
• Inspired by Ms. Rosner, I’m going to switch to unleaded for the immediate future.
• The scale is not my friend these days, but I’m still trying to close those three damn circles every day.
• Need to pick a day this week to run the virtual Get in Gear 10K and submit my (likely very slow) time.
• News and social media can be soul-crushing these days, but I just can’t turn it completely off. As the great Sandra Boynton said, don’t let the turkeys get you down.
• When this is all over, I want to buy drinks (in person) for all the cool people I follow on Twitter and Instagram.
• This weekend’s focus was deciding which physical CDs and DVDs we could do without. Once it reopens, Electric Fetus will be gifted the whole pile.
• The plan this week is to get the food page updated with those spots now offering great take-out. I don’t have an unlimited budget, but we should all try and support as many of our local favorites as we can.
• Finished all the taxes (ours and my dad’s) before the original April 15th deadline, but will hold on to those checks until July.
• Still can’t believe we are all done with Lombard – such a huge relief (thanks again Kary).
• Photos + iPhone + Catalina = fubar. All I want is to sync albums from Photos to my phone, but all I get is “Photos cannot be synced to the iPhone because your Photos Library is not yet available. Please try again later.” Never thought I’d yearn for iTunes.
• Starting week three with the CPAP and so far I’m not a big fan. Can’t sleep on my stomach or side, I don’t like breathing only through my nose and it hasn’t improved my sleep quality much. Definitey quieter for everyone else, though.
• Looking forward to my first socially-distanced round of golf this week at the always excellent Willingers in Northfield.
• Scheduled to see my long lost friend Eric at James Irving on May 4th. Fingers crossed…

Wishing you all peace, love and happiness ❤️

It’s blog birthday time again – the first 7 Minute Miles post appeared on this domain fourteen years ago today.

Current stats:

• 11,119 Posts
• 208 Pages
• 41,174 unique visitors in 2019
• 2,169,487 pages displayed in 2019

Currently running WordPress 5.3.2 with my custom theme and 19 plugins on the old Mac mini server colocated in Las Vegas. Favorite plugins: Wordfence Security, VaultPress, Intagrate and Really Simple SSL (with a Let’s Encrypt cert managed via Certbot). Still want to write some custom data entry forms for the golf, run and bike pages, but those (along with making the theme more mobile friendly) have still not made it off the to-do list. Also never figured out the solution to the weird SSL/emoji issue.

Haven’t changed the overall site structure much this year, adding only a new Concerts page that I’m experimenting with using the Vimeo hosting platform. I made some major updates to the Résumé page and just realized that the Biography page now needs a refresh too. After prepping photo boards for funerals in back-to-back months, I should also spend some time on updating the Photos section. I finally moved our Christmas samplers to online-only last year and might do a Hummel section soon too (hit me up if you need any).

As always, thanks for visiting and stay safe out there!

As promised, a quick health update from the halls of Hennepin Healthcare. I’m still wearing my prism glasses to treat double vision, but ophthalmologist Dr. Amy Chang is happy with the progress so far. She has reduced the strength of the lens twice now and said I can stop bi-weekly occupational therapy after my next appointment later this week. The hope is still to get to no glasses by October, but surgical options remain available if it takes longer than that. I can read my phone without them now and my left eye is really good at seeing far away, while my right is better close up. This has been mildly annoying, but my first attempt at golf while wearing glasses went much better than expected.

Last week’s big news was a successful third cerebral angioplasty to assess the stent and arteries in my head. The procedure had more risk than I realized before getting there (about a 1% chance of the catheter breaking something loose that would cause a stroke), but vascular neurosurgeon Dr. Adam Khan calmly explained everything before I signed the release form. It really amazes me that they can run a tube up the 8mm-wide artery in my leg, past my heart, up to my brain, inject contrast and take an x-ray of the blood vessels in my head. Science, for the win!

With the stent looking good and no signs of other aneurysms, they took me off the blood thinner. Neurologist Dr. Ann Hoang-Tienor has been managing my seizure care, which consists of anti-seizure medication and a review of activities that may be dangerous. At our last appointment, the doctor reduced my dosage a second time (with a goal of eliminating it altogether). She also gave the green light to all outside activities (with the exception of swimming alone), so I purchased a new bike helmet and ordered a new bike that will hopefully arrive in time for the bike challenge at work. Still haven’t returned to any alcohol yet, but she said it would be OK to take it slow and see how my head reacts. I’ve never been a big drinker, but these six months have really revealed what a huge part alcohol plays in fine dining and in many social situations.

Continued thanks to the staff at Hennepin Healthcare and everyone out there who has supported my recovery (and our family).

It’s that time of year again – the first 7minutemiles.com post appeared on this domain thirteen years ago today.

Current stats:

• 10,066 Posts
• 204 Pages
• 383 Comments (which are now turned off)
• 54,914 unique visitors in 2018
• 1,687,856 pages displayed in 2018

Still running WordPress (currently 5.1.1) with my custom theme and 17 plugins on the old Mac mini server colocated in Las Vegas. Favorite plugins: Wordfence Security, VaultPress, Intagrate and Really Simple SSL. Yes, I finally made the move this year to SSL using Let’s Encrypt, Certbot and that SSL plugin. I experimented with some form plugins for data entry on the golf, run and bike pages, but I didn’t like any of them. Planning to just write some custom code when I find the time. I’ve also given up on using a plugin to make the site more mobile-friendly, so at some point I’ll just have to learn the design and coding techniques to deal with that using my existing theme.

The old Tapemark Charity Pro-Am online leaderboards have a historical home now here. We had a new foodie join our team at the stadium, so I created a food page to summarize some of my favorite places in Minnesota. My upcoming races, concerts and sporting events are now displayed in the home page footer (and stored in a new database). The Biography and Résumé pages have some small updates. Video and photos still need a lot of love in the coming months and the mysterious SSL/emoji issue still needs resolution…

As always, thanks for visiting!

This site has always been a tool for me to stay sharp on new web technologies and lately it’s been a great way to test my cognitive skills since the little incident in October. I’ve had three things on my web development to-do list for a long time: 1) use Let’s Encrypt to add TLS/SSL security, 2) make my WordPress theme mobile-friendly and 3) create some dedicated data entry screens for golf scores, runs and bike rides. During my recovery at home, I decided to tackle item #1…

Since I still had Homebrew installed on this server, I was able to get Certbot installed early on in the process and had a valid certificate ready and waiting. I haven’t tried automating the renewal process yet, but can manually renew the certificate with no problem (had to do this once already, in fact). For whatever reason, I had trouble finding examples online of people with similar setups and had several false starts in getting Apache configured correctly to use the certificate for this domain. This post got me most of the way there, but had more of a focus on Mac OS X Server and not plain old Mac OS X client. A few other helpful links here, here and here. And this thread on the Let’s Encrypt site helped me figure out what can/should go in the httpd-vhosts.conf file versus what should go in the httpd-ssl.conf file.

Combined with the Really Simple SSL WordPress plugin, I was able to get a green “B” rating on the Qualys SSL test site. After adding a SSLCertificateChainFile line to my VirtualHost config, I got the top A+ rating and just needed to figure out why my main page was still showing a “not fully secure” message in Chrome. After upgrading the Really Simple SSL plugin to the pro version, I was able to run a full scan, correct a few issues it found, enable HSTS and make cookies more secure. Now all pages in Chrome have the coveted padlock (with no warnings) and I still had the A+ rating. All was right and good in the world.

Then I looked at some old posts…

Almost everything looked fine, but posts and pages that had emoji in them were now messed up (hearts seem to display OK, but everything else was either a question mark or some other image). Emoji support in WordPress started back in version 4.2 and I remember having issues back then too. For this site, it was due to the MySQL tables on the backend not being configured correctly. I verified that the database was using utf8mb4_unicode_ci collation on the posts field and also discovered that phpMyAdmin wasn’t having any issue displaying the emojis (it runs under the same domain and those pages were getting a padlock from the Let’s Encrypt certificate, so this has to be a WordPress issue). I thought maybe this had something to do with the newest emoji release, which WordPress contributor Brandon Kraft writes about here. After I tried matching his page source code for things like charset=”UTF-8″, I still couldn’t get these emojis to display (which they did when the site was not secure).

After Google failed to turn up much for WordPress, SSL and broken emoji, I contacted Really Simple SSL pro support. Their first question was if this happened to new posts in addition to the old ones (yes), then asked if I had looked at all the character encoding angles (like this post). My wp-config.php file didn’t have DB_CHARSET or DB_COLLATE lines, so I tried various combinations of adding that back in and commenting it out, with no success. Made sure to check caches and different browsers too. They hadn’t seen this before, so I’m guessing it’s something with my custom theme and combination of various plugins that is causing the issue. If I paste the same emojis into a test post on a different domain on the same server that hasn’t had SSL added (and with the same version of MySQL and WordPress), the emojis display fine. Huh.

Standard WordPress troubleshooting would have you disable all your plugins and I have tried to go back and disable Really Simple SSL (I don’t want to turn them all off). I also started researching how WordPress implemented emoji display and found some core javascript code that gets inserted automatically (it’s a section that starts with window._wpemojiSettings and references a baseUrl of “https:\/\/s.w.org\/images\/core\/emoji\/11\/72×72\/”). I thought maybe this was the issue, as I can’t seem to access that s.w.org domain using https, but when I compared the page source from my site to the javascript on Brandon Kraft’s page, it was exactly the same (and emojis appear fine on his site).

So in the grand scheme of things, I’d much rather have the A+ security rating and not worry about displaying emoji in posts. It does bug me, though, that I can’t find anyone else online with a similar problem and that I haven’t been able to successfully troubleshoot this issue. If you have any ideas, please contact me via email here.

Nights like tonight are when I remember just how stressful it can be to have servers remotely hosted 1,300 miles away. As I’ve written many times, this site runs on a Mac mini located in Las Vegas in a data center run by the fine folks at Mac Stadium. While trying to fix my SSL/WordPress/emoji issue (which I’ll write about later), I managed to almost completely lock up the server. I could ping it, but the Screen Sharing session dropped and SSH was unresponsive at first. Eventually I was able to login via SSH and issue a quick “sudo shutdown -r now” command before getting kicked out again. About ten minutes later, I was able to get in via Screen Sharing. Since I had a couple of security updates to install that required a restart, I decided to just continue the unexpected web server downtime and run those installers too. This ended up taking nearly an extra hour, so I apologize if you were trying to load the site and got nothing.

Now back to researching just how WordPress core supports and displays the latest emoji characters…

…since we moved in, anyways

Doggie dingles

The first week away from social has been a good learning experience

Decided to try something this week that I’ve been thinking about for a few months. I stopped visiting Facebook regularly a while ago, as I become tired of all the BS there (even after I massively limited who and what I was viewing). Twitter had been my favorite of the social networks, but lately my more political friends (both to the right and left of me) have made that platform as bad as Facebook (if not worse – thanks for nothing, @jack). No major beefs with Instagram, aside from the fact that Facebook owns them.

So what’s the plan? Well, I don’t want to close those accounts, as I’ve “owned” the kingsbury handle on all three for years. The main reason I’ve kept the Facebook account open is all of the other services that use it for authentication and tracking of progress/levels in various games. You can close your Facebook account and still prevent others from taking it over, but anytime you use one of those other services, it reactivates your profile automatically. Not sure what the rules are for Twitter and Instagram, but I imagine they would eventually allow someone else to take over those handles at some point if I closed them.

For now, I’m keeping the accounts open, but removing the apps from my phone. I closed Tweetbot on all of my computers and will try to go a few weeks without checking the timeline. I spent a few hours going through the layout of my phone apps, deleting a bunch I never use, eliminating folders and grouping apps by pages (primary, secondary, content and media, work and games). I have a great fear of missing out, but I feel like I need to compartmentalize these groupings and look for “cleaner” sources of information. I really just want to know about sports, food, concerts and unbiased business, technology and (I guess) political news. I’ll have to make a concerted effort to reach out to family and friends in others ways to stay up to date with their lives…just like the old days.

I will post more original content here, including short tweet-like status updates. I know the “audience” won’t be as big as the other networks, but I own the content, the platform and the server. You won’t be served ads or tracked (at least not beyond the generic web server log stuff) and I’ve done what I wish more sites would do – turn off comments. My email and phone number are on every single page of this site, so please feel free to reach out directly if you feel the need. And watch for TLS, video and mobile-friendly enhancements coming soon.

Thanks for reading!

Lookin’ good

Just a short post to document an issue I needed to troubleshoot the past few weeks on my web server in Vegas (Go Knights Go!). I’ve been running Homebrew versions of MySQL for some time now with no issues, but recently was receiving quite a few “Can’t connect to MySQL server” errors on all of my virtually hosted WordPress sites. It was particularly difficult to troubleshoot at first because it wasn’t an all or nothing situation – some database calls would go through, while others would not. All I knew was that the old “brew services restart mysql” command would clear things up for a few hours before the flakiness would return.

When I first started looking at the web server logs, I found a lot of error messages like this:

WordPress database error Table 'wp_termmeta' doesn't exist

There were a ton of these – guessing this was relating to the earlier database corruption issues I had related to InnoDB. Turns out that table really didn’t exist and I found this post that had the required SQL to properly recreate it. I wasn’t really sure if any of the themes or plugins that were looking for this table would actually re-populate the table with data (it doesn’t appear so), but the error messages in the logs have gone away (and everything seems a little faster now). Unfortunately, this did not have any impact on the MySQL connection issue.

Going back to the web server log, I found a number of mysqli errors:

PHP Warning: mysqli_connect(): MySQL server has gone away
PHP Warning: mysqli_connect(): Error while reading greeting packet.

These made me think it was on the database side and not an issue with Apache or PHP. I had tried messing a little with the my.cnf file, but it didn’t seem like any of the changes were having any impact. When I started looking for Homebrew MySQL tips, I first decided to reinstall MySQL while keeping the data directory in place (brew reinstall mysql). That seemed to work fine, keeping users and permissions in place while just recompiling the latest MySQL. All of the virtual sites came back up, but the can’t connect errors reappeared later in the day.

Next up, I was fully prepared to follow these instructions to blow away every sign of MySQL and reinstall from scratch (dumping all of the tables first using the awesome Sequel Pro). While looking at the /usr/local/var/mysql directory, I realized that Homebrew MySQL stores a local.err log in that same directory, which I hadn’t looked at (since Console doesn’t include it by default). This log was chock full of lines like this:

[Warning] File Descriptor 1024 exceeded FD_SETSIZE=1024

That lead me to this excellent post by Derek Jones that had me change a number of lines in the my.cnf file (specifically interactive_timeout = 300 and wait_timeout = 300). Some of the comments in this thread were also useful. I restarted the database server yet again and so far it’s been up and running for 24 hours straight (fingers crossed).

So to summarize troubleshooting 101: read all your logs, Google the errors and be thankful for those that blazed a path before you (and took the time to document it online).

So much work left to do

From what I can tell, I didn’t do an anniversary post last year (lots of moving and Final Four posts, but no birthday cake pics that I can find). The first 7minutemiles.com post appeared on this domain twelve years ago last Friday.

Current stats:

• 8,934 Posts
• 201 Pages
• 386 Comments
• 50,616 unique visitors in 2017
• 691,339 pages displayed in 2017

Still running WordPress (currently 4.9.5) with my custom theme and roughly a dozen plugins on the old Mac mini server colocated in Las Vegas. Probably too much of my content gets auto-generated these days from social media (Twitter and Instagram), but that’s OK. I feel lucky that I get to publish most of what I want without interference from trolls or stalkers, which unfortunately isn’t the case for some people I love to read (RIP Daily Angst).

After the technical difficulties last year, things have seemed to stabilize. The highest priorities for enhancements right now are moving to https via Let’s Encrypt, making the theme more mobile-friendly and finally adding a video post type to the mix. I’d also like to experiment with some form plugins for easier data entry of golf scores and adding to the run log. If I ever get my iMac photo library organized, I’d like to add more to the photo gallery section as well…

As always, thanks for visiting!

Took a bit to install, but I already like it a thousand times better than the old model

It’s been a long time since I wrote a longer post here, which actually wasn’t caused by being busy. I’ve been battling technical issues with my web server for months, which is a co-located Mac mini in Las Vegas (now at MacStadium since their merger with Brian Stucki’s excellent Macminicolo). I created my own perfect storm by trying to remotely upgrade the OS (which was two versions behind) *and* moving it from the old Macminicolo data center to the new MacStadium data center across town. Somewhere along the way, I also ended up corrupting my database backups and discovered my old backup processes weren’t working the way I thought. Thankfully I didn’t lose any data, but it wasn’t the best example of being a good sysadmin.

With work being work, I haven’t had time to focus on fixing these issues, so it’s been little bits and pieces here and there to finally get back to a semi-functioning site. I messed with moving to AWS for a little while, but decided to just rebuild my mini server from scratch. I use Homebrew versions of Apache, MySQL and PHP for the core stack, which I’m now familiar with enough to mostly breeze through those configs. I learned that over the years, my MySQL data got split into MyISAM and InnoDB islands, which caused some major problems with restoring the InnoDB side. Then I found out that I had MySQL collation setting issues, which created a bunch of weird characters (and a loss of emoji support).

This site uses a number of WordPress plugins to help automate things and several of those plugins stopped working due to the issues mentioned above. I needed to blow away both WordFence (security) and Intagrate (Instagram integration), reconfiguring both from square one. I’ve also had some general response issues with the server, which was mostly fixed with an ARP patch from MacStadium. I still need to go through the web server error logs to clean up a few other performance issues, but those are a little harder to research and isolate (wordpress termmeta doesn’t exist, anyone?).

So now that I can reliably post from the mobile app and have Twitter and Instagram integration working again, it’s almost time to get back to my enhancement wish list:

• Recreate my Coda web development environment on the new iMac
• Add Backblaze support to the server
• Rewrite and test my database backup scripts
• Move to https with Let’s Encrypt (this should help)
• Create data entry screens for golf scores and runs
• Make my default theme more mobile-friendly
• Add a video post type
• Make my header photos retina-ready
• Update the about and biography sections
• Bring back more of the old photo gallery pictures

As always – thanks for visiting!

SK has built an awesome spot

Haven’t been here much the past two weeks

Revival chicken and Easy/Easy & Oskey gimlets @ Rayette Lofts

Thanks again, Mystic Lake

Change is good, right? Well, we’ve been charging ahead full force the past month. Kid one moved out and into her own apartment mid-February, while the rest of us decided to pack it up and move back to the city. Today marks three weeks in our new loft in St. Paul’s Lowertown neighborhood, which the local boosters describe as:

A vibrant artists’ quarter filled with beautiful workspaces, hip cafes, fine dining and the stunning CHS Field.

We are kitty-corner from the wonderful St. Paul Farmer’s Market in the Rayette building, which we share with the home of my all-time favorite cheeseburger, Saint Dinette. The building has had an interesting history, opening as a millinery in 1911, with stints as the home of Aqua Net hairspray and as a parking ramp before being converted to lofts in 2014. We downsized from three bedrooms to two, but added 13 foot ceilings, huge windows and a layout that seems much larger than before (ours is the Monroe, with 1,459 square feet). I love the exposed brick, industrial columns and lack of carpeting throughout (finally got to toss our crappy vacuum cleaner).

In addition to the suburb-to-city change, transportation has also been turned on its head. We still have two cars, but one is parked here and the other is in storage. Colleen gets a discounted transit pass from her employer and now rides the bus to work (express plus a short transfer). I bought a monthly Go-To card from Metro Transit and ride the Green Line trains to and from the stadium. The Union Depot station is a block over and takes just under 40 minutes to drop me off right across Chicago Avenue from the Legacy Gate (and/or the skyway entrance). I can’t express how much of a quality of life improvement it is to not drive in metro rush hour traffic any longer. Now I plug in my headphones, check social media, read stories, play games and just relax. Hoping to eventually sell one car and just stick with one (which kid two uses to drive herself to school).

We lived in downtown St. Paul the first year out of college at Galtier Plaza, but this area is now completely different. I read somewhere that Lowertown now has 3500 residents and I’m pretty sure about half of them have dogs, which makes me very happy (even though allergies still prevent us from adding to the total). Mears Park is a block west and has a mini restaurant row, with Bulldog, Barrio, Public Kitchen + Bar and Handsome Hog. Big River Pizza is across the street, with the eclectic Golden’s Deli a few doors south of that. There are a ton of additional restaurants nearby and we are super excited for Saints games to start. Our Twins ticket group also has Saints tickets, so we are buying one share this season to see how it goes. The stadium is literally on the other side of the building you see above.

In addition to having the option of that cheeseburger downstairs six days a week, the building has a bunch of other great amenities. The workout room is just perfect – it’s exactly what I would design if I had the opportunity: all Life Fitness gear, two treadmills, a room full of spin cycles, free weights, an elliptical, squat rack, benches and more. There are two large TVs with DirectTV and a speaker system that you can supposedly plug stuff into (can’t seem to get that part working so far). It’s conveniently located one floor below our unit and now I don’t have to go outside in the winter any more to exercise. The downtown YMCA teaches a free spin class one night a week and may bring back a yoga class later in the year too. Once it gets warmer, I will have some great new running and biking routes along the Mississippi that I can’t wait to try.

Directly across from the exercise room is the “Sinatra Lounge,” which is a shared community space that has a fireplace, bar, multiple TVs and a pool table. We’ve already spent a lot of time shooting pool – I really like having access to that again (and free is even better). Up on the roof, there is a community patio that includes a gas fire pit, grill, all-season TV and speaker system. The views of the river and surrounding areas are stellar, day or night. The office manager and maintenance guy are great, the mail and package delivery systems seem to work well and I love having chutes for trash and recycling. My only (small) issues so far are the overly complicated thermostat and the noise from one of the garage door openers.

We are mostly unpacked now, with just a few areas that need to be cleaned up (and a few more things to hang on the walls). Once that’s done, we’d love to have visitors – drop me a line at dk@7minutemiles.com and we will see you soon in Lowertown!

Staircase A is emergency exit only

Top 3 worst for sure – maybe #1

Really hope this works out