Mother Nature Watering Service

Just in time for the new plants and trees
Originally published by DK on August 6, 2022 at 2:43 pmJust in time for the new plants and trees
Originally published by DK on August 6, 2022 at 2:43 pmDon’t care what they say, I’d still put this in my house
Originally published by DK on February 21, 2022 at 11:06 amThis doge ❤️ the new place
Originally published by DK on January 9, 2022 at 12:15 pmMore pieces of the puzzle coming together
Originally published by DK on January 7, 2022 at 10:03 pmOrdered some bar stools 🤷♂️
Originally published by DK on January 4, 2022 at 6:16 pmFirst toasties on the new center griddle
Originally published by DK on December 31, 2021 at 12:00 pmThe new Turman *original*
Originally published by DK on December 31, 2021 at 11:26 amDoge the Destroyer Happy Place
Originally published by DK on December 24, 2021 at 5:36 pmDecember has really been something
Originally published by DK on December 21, 2021 at 2:03 pmMust get boring living here with the same weather every single day
Originally published by DK on December 16, 2021 at 7:03 pm…or would that be an MDF?
Originally published by DK on December 11, 2021 at 10:36 pmChill, doge, chill
Originally published by DK on November 27, 2021 at 3:10 pmBring on the rock trim
Originally published by DK on November 26, 2021 at 3:52 pmOne month away – can’t believe it
Originally published by DK on November 20, 2021 at 4:20 pmComing next month…
Originally published by DK on November 8, 2021 at 9:34 amIt’s coming along nicely
Originally published by DK on November 1, 2021 at 8:43 pmMy one real upgrade this time
Originally published by DK on October 17, 2021 at 5:34 pmTurned out really nice – hopefully the move-in date is still a long ways out
Originally published by DK on October 9, 2021 at 12:06 pmPre-drywall meeting was a success
Originally published by DK on September 14, 2021 at 11:04 amA little more progress
Originally published by DK on September 9, 2021 at 8:13 pmHappy with the progress this week
Originally published by DK on September 2, 2021 at 6:12 pmProgress seems to be slowing :-/
Originally published by DK on August 17, 2021 at 6:51 pmHopefully many more to come
Originally published by DK on August 6, 2021 at 8:52 pmCan’t wait to move in
Originally published by DK on July 29, 2021 at 8:56 pmSecond floor framing ✅
Originally published by DK on July 24, 2021 at 7:01 pmCan’t wait to see how far they get this week
Originally published by DK on July 19, 2021 at 8:04 pmExciting visual progress this week
Originally published by DK on July 15, 2021 at 8:14 pmHope to see some vertical progress next time
Originally published by DK on July 9, 2021 at 9:15 pm…is not like the others
Originally published by DK on July 6, 2021 at 8:22 pmBring on the slab!
Originally published by DK on June 30, 2021 at 5:20 pmSummer and fall will go quickly, right?
Originally published by DK on June 22, 2021 at 9:38 pmThe countdown is on…
Originally published by DK on June 20, 2021 at 11:52 pm…and the foundation frames are gone
Originally published by DK on June 12, 2021 at 8:00 pmWay more progress than I was prepared for…
Originally published by DK on June 6, 2021 at 1:15 pmCan’t believe the neighbor lot went from nothing to framed up in about 30 days
Originally published by DK on May 17, 2021 at 8:41 pmThat one was rather fun – ordered all the cat 6
Originally published by DK on April 11, 2021 at 2:49 pmHappy 15th birthday, 7 Minute Miles! Current stats:
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!
Originally published by DK on March 30, 2021 at 10:20 pmIt 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:
Now back to refreshing those vaccine screens…
Originally published by DK on March 15, 2021 at 8:54 pmComing soon to Newport
Originally published by DK on March 6, 2021 at 6:53 pmToday 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?
Originally published by DK on February 4, 2021 at 1:16 pmHaven’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…
Originally published by DK on January 27, 2021 at 1:11 am…but a more organized mess
Originally published by DK on January 21, 2021 at 12:35 pmIt’s already been eight months since the last one, so let’s do this:
Welcome 2021, nice to have you around…
Originally published by DK on January 4, 2021 at 9:37 pmIt’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…
Originally published by DK on August 6, 2020 at 10:20 pmAfter 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…
Originally published by DK on July 26, 2020 at 12:00 amA few random Sunday night notes:
Wishing you all peace, love and happiness ❤️
Originally published by DK on April 19, 2020 at 9:17 pmIt’s blog birthday time again – the first 7 Minute Miles post appeared on this domain fourteen years ago today.
Current stats:
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!
Originally published by DK on March 30, 2020 at 8:00 amAs 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).
Originally published by DK on April 30, 2019 at 10:30 amIt’s that time of year again – the first 7minutemiles.com post appeared on this domain thirteen years ago today.
Current stats:
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!
Originally published by DK on March 30, 2019 at 1:15 pmThis 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.
Originally published by DK on December 5, 2018 at 10:49 pmNights 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…
Originally published by DK on December 2, 2018 at 10:44 pm…since we moved in, anyways
Originally published by DK on September 30, 2018 at 4:39 pmDoggie dingles
Originally published by DK on September 22, 2018 at 1:40 amThe first week away from social has been a good learning experience
Originally published by DK on August 25, 2018 at 9:07 pmDecided 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!
Originally published by DK on August 22, 2018 at 9:10 pmLookin’ good
Originally published by DK on July 1, 2018 at 12:50 pmJust 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).
Originally published by DK on May 28, 2018 at 11:16 pmSo much work left to do
Originally published by DK on April 29, 2018 at 11:54 pmFrom 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:
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!
Originally published by DK on April 5, 2018 at 12:48 amTook a bit to install, but I already like it a thousand times better than the old model
Originally published by DK on November 29, 2017 at 8:54 pmIt’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:
As always – thanks for visiting!
Originally published by DK on October 21, 2017 at 7:34 pmSK has built an awesome spot
Originally published by DK on September 9, 2017 at 4:11 pmHaven’t been here much the past two weeks
Originally published by DK on July 5, 2017 at 9:23 pmRevival chicken and Easy/Easy & Oskey gimlets @ Rayette Lofts
Originally published by DK on June 7, 2017 at 7:02 pmThanks again, Mystic Lake
Originally published by DK on June 7, 2017 at 12:43 amChange 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
Originally published by DK on March 4, 2017 at 7:39 pmTop 3 worst for sure – maybe #1
Originally published by DK on March 1, 2017 at 11:23 pmReally hope this works out
Originally published by DK on December 31, 2016 at 10:54 am