New Job – Quick Thoughts

As many of you know, I started a new job with the new year. Yesterday was my first day as a Senior Attorney in the litigation group of the law firm Morgan, Lewis & Bockius LLP. It was a great day, and I’m very excited about the work ahead. I will be doing two types of work: both representing clients in their litigation matters and developing software platforms to augment and streamline the practice of law. It’s a truly unique opportunity to combine two of my skill sets and passions, and I can’t wait to get started in earnest.

I will, of course, miss the outstanding justices and wonderful former colleagues at the First Court of Appeals. But all good things in this life must come to an end, and this next chapter promises to be a great one!

What I’m Up to Now

If you read this blog regularly, you know I have a lot on my plate. Here’s a quick snapshot of what I’m up to.

It’s safe to say 2016 is off to a busy start.

Leaving My Job and Starting a Business

Entrepreneur Name Tag Business Owner New Startup Company

As you may know, I gave my notice at the First Court of Appeals this week. I am leaving the practice of law in order to start a software company, Cereblitz!

Cereblitz makes the first fully-customizable cart for customizable products

I will be developing and marketing an ecommerce platform for selling customizable products, such as products that can be imprinted with text or logos or have other user specifications. I have mentioned the software before, but now I am going to be working on it full-time.

This platform is one-of-a-kind: there is nothing else out there that is available to small and medium-sized businesses for selling customizable products!

I need your help getting the word out! Please help me by doing at least one of the following:

 

How to Stop Random iPhone Vibrations

I had problems recently with my iPhone 6 vibrating randomly. I didn’t get any alerts, banners, or app icon badges that I could see, so it was driving me a little crazy.

It turns out there are two kinds of mail notifications. The first kind is under Settings > Notifications > Mail. The second, which causes these phantom vibrations, is under Settings > Sounds > New Mail. Head there and change “Vibration” to “None.”

h/t http://www.scottyloveless.com/blog/2014/how-to-stop-your-iphone-from-vibrating-randomly

Using SSL with MySQL

If you ever make remote connections to a MySQL database, it’s extremely important to connect over SSL. Otherwise, you run the risk of someone seeing data in transit, modifying data in transit, or, worst of all, stealing your credentials. This could be an utter disaster.

Unfortunately, getting MySQL to use SSL is kind of complicated. Here’s how to do it.

Make Sure SSL is Enabled

First, make sure your installation of MySQL supports SSL. Using PHPMyAdmin, a MySQL command-line prompt, or whatever you prefer, run this command:

You should get a result looking something like this:

If you see “DISABLED” next to “have_openssl” and “have_ssl”, great – that means that your copy of MySQL supports SSL. If you see “NO”, you need to recompile or reinstall MySQL. If you see “YES”, you’re already done!

Create SSL Certificates

Now, you need to create some SSL certificates. Go to wherever you want to store them (I’d suggest something like /home/mysql/certs) and run the following commands:

Enter information as needed at the prompts. This will create self-signed client and server keys for you to use. The last two lines are very important! OpenSSL versions 1.0 and newer create keys in the PKCS #8 format, but MySQL expects them to be in the PKCS #1 format, so you have to run these commands to convert the keys we just created. You can read more about that problem in this Ask Ubuntu question: Enabling SSL in MySQL.

Tell MySQL to Use the Certificates

Edit your my.cnf file (probably at /etc/my.cnf) to include the following entries:

(If you used a directory other than /home/mysql/certs above, use it in the entries here.) If your my.cnf file already has mysqld and/or client sections, just add the appropriate entries to those sections.

Restart MySQL. The command varies by system, but will usually be something like service mysql restart.

Test It

Run this command again:

You should see something like this:

If so, congratulations! You’re done! If not, you might find the post Debugging MySQL SSL Problems on the Percona blog helpful.

Have you had problems with MySQL over SSL? Let me know in the comments! I’ll try to help you out!

%d bloggers like this: