Blog

I was fixing MySQL replication on a slave this past week. Everything seemed to be ready to go after bringing data over from the master manually. I went to connect the slave to the master and nothing happened. Whaaaaaa? 1 2 Last_IO_Errno: 1045 Last_IO_Error: error connecting to master 'repl@blah.local:3306' - retry-time: 60 retries: 86400 Let me look up MySQL error code 1045: 1 2 Error: 1045 SQLSTATE: 28000 (ER_ACCESS_DENIED_ERROR) Message: Access denied for user '%s'@'%s' (using password: %s) That’s not helpful. After some additional testing I realized the password might be too long. Sure enough, the CHANGE MASTER TO syntax guide states MASTER_PASSWORD has a maximum length of 32 characters (despite the MySQL client having a longer limit). ...

I started having some Apple Keychain issues after upgrading to Mac OS X El Capitan. At random, I would be asked to sign back into accounts that I am logged into through Internet Accounts in System Preferences. I thought it a minor issue but it became unavoidable though once El Capitan told me it couldn’t find my login Apple Keychain after logging in: Something related to the ’login’ Apple Keychain happened during the Mac OS X El Capitan upgrade process I’m assuming and after a reboot this morning everything went to hell in a hand basket it would seem. ...

Here’s a handy one-liner to grep multiple Ansible Vault files (like group_vars). All you need is an Ansible Vault password file (outside of your configuration repo, please) and a little bash. 1 ls -1 | while read N ; do echo -n $N: ; ansible-vault --vault-password-file ~/.ansible_vault view $N | grep <STRING> ; done

Tim Tebow was observed working out on a USC baseball field recently. Tebow’s throwing motion looks a little bit better but his agents are likely pressuring him to become a public speaker according to Only Gators

I’ve been messing around with Tiny Tiny RSS today. Upon discovering it I posted in their Google+ Community asking how other users implemented it and what they thought of a specific use case I had. I got some good responses and was quite appreciative of them. I opted, at the advice of those in the community, to setup Tiny Tiny RSS on Red Hat’s OpenShift and was pleasantly surprised by how the product Red Hat created. I even tweeted to the OpenShift Architect about it. All around a nice experience with Red Hat’s OpenShift. Optimally, if I could get Tiny Tiny RSS to place nice on OpenShift I’d probably bring more hardware into the house for the sole purpose of running it on dedicated, non-AWS hardware. ...