Howto: Fix MySQL Server dependency problems on Ubuntu LTS

Have you encountered this error?

An error occurred while setting the password for the MySQL administrative user.
This may have happened because the account already has a password, or because of a
communication problem with the MySQL server.

Or maybe seen this?

Errors were encountered while processing:

Or this?

dpkg: error processing package mysql-server (--configure):
dependency problems - leaving unconfigured

This is a total bastard of a problem. Here’s what worked for me:

sudo apt-get purge mysql-server mysql-client mysql-common mysql-server-5.5
sudo dpkg --purge mysql*
sudo rm -rf /etc/mysql
sudo apt-get install -f
sudo dpkg --configure -a
sudo apt-get update
sudo apt-get upgrade
sudo apt-get dist-upgrade
sudo apt-get autoremove
sudo apt-get autoclean
sudo apt-get install mysql-server
sudo reboot

Purge everything that even looks like mysql. Remove the /etc/mysql directory manually, because mysql-common is going to try to hide there. Fix any broken dependencies and reconfigure any broken packages. You may get the same error again when trying to reinstall mysql-server. I threw up my hands and went to bed at that point, woke up this morning deciding to finally learn PostgreSQL, got this error:

E: Could not get lock /var/lib/dpkg/lock - open (11: Resource temporarily unavailable)

and believe it or not, a reboot fixed the problem for me. mysqld started on reboot. I rubbed my eyes, and wrote this post in case it ever bloody well happens again.

Automator will not save service in General in Yosemite OSX for keyboard shortcuts

You might have had the same problem I just did: I tried to create a global hotkey shortcut command situation for popping up a new mail message. I’m trying hard to only look at my inbox Xx/day, but I often have emails I need to send. So, I tried to create a global shortcut using Automator on my OSX Mac. The tutorials all said to open Automator, create a new Service with no input from any application, drag the New Mail Message or whatever over to the workflow, save it, and then go find it under the “General” tab in System Preferences -> Keyboard -> Shortcuts -> Services -> General. Unfortunately, that General section on the right of Services didn’t appear.

Here’s why: you need to save your Automator Workflow Service in ~/Library/Services. I went and looked in that folder, and found that my workflow wasn’t being saved there. Turns out when I was saving the workflow automatically in iCloud instead.

Screenshot 2015-07-10 16.55.39

See the save location? Go to wherever you’re saving that workflow and drop it into your user/Library/Services folder.

How to set up a TP-LINK router on Apple/Mac

TP-LINK routers are best sellers on Amazon, and I like my new one a LOT. I had a 5-year old Vizio router that did yeoman’s service, but had started to drop connections and in general behave like an amnesiac hash addict.

I liked the reviews, which said that TP-LINK routers were dead easy to set up.

It was not.

I have a Mac Mini that operates as a home server, and I had some nonstandard configuration issues to deal with. Turns out that there were 3 issues. First, I couldn’t get to the router configuration page on a browser. I had to clone the previous MAC address, and finally, I had static internal IPs set on most of my devices in the house including the machine I was installing the router on. So, here are the easy steps to fix it if you have plugged in a TP-LINK router on a Mac home network and you can’t get it set up.

  1. Go into Network Preferences. Open your ethernet connection and go to TCP/IP. Clear the manual setting from your DHCP, and permit the machine to be assigned an internal IP from the DHCP server in the router.
  2. Hit in your browser. This should theoretically get you to the router config page. It worked for me. That’s the default IP for TP-LINK.
  3. admin/admin are the un/pw for TP-LINK.
  4. Keep a browser window open so you can see whether you’ve got a connection.
  5. If you do, good. You’re fine to set static IPs/MAC bindings.
  6. If not, try cloning the MAC. Go to the MAC settings in the router config, hit the “clone” button, save, and reboot the router.
  7. Does it work yet? If not, add a static IP for the box you’re working on while configuring the router.
  8. Hard cycle the router and modem.
  9. Set static IPs and MAC bindings.
  10. Profit!

I’ll keep updating these instructions. I’m assuming you know to set a different un/pw for your router if you’re actually able to follow these instructions. Per the usual, 18 months from now, I’ll reset the router and totally forget how I got it working, so this post is more for me than all y’all.