{"id":2240,"date":"2014-05-21T15:29:59","date_gmt":"2014-05-21T15:29:59","guid":{"rendered":"http:\/\/www.sitekickr.com\/blog\/?p=2240"},"modified":"2014-05-21T15:29:59","modified_gmt":"2014-05-21T15:29:59","slug":"week-8","status":"publish","type":"post","link":"https:\/\/www.sitekickr.com\/blog\/week-8\/","title":{"rendered":"Linux, SQL and a scoop of yogurt in Week #8"},"content":{"rendered":"

Find of the Week<\/h2>\n

Project Parfait<\/h3>\n

I’m a big yogurt fan, so there’s a decent chance I came across this while Googling recipes. Either way, it’s an incredible tool.<\/p>\n

Supported only in Chrome at time of writing, this little app will allow you to upload a PSD, then slice and dice it for you, returning CSS, colors, fonts, etc. It’ll even pick apart individual layers or objects and export CSS rules to create them on the web.<\/p>\n

I’m not sure I’ll use it for every project, but it definitely takes me once step closer to a less platform dependent development machine.<\/p>\n

https:\/\/projectparfait.adobe.com<\/a><\/p>\n

 <\/p>\n

Linux<\/h2>\n

Time Zones<\/h3>\n

For a while, I had a server that for one reason or another, would restart every couple of months. No problem, it always happened at night, downtime was minimal and all services came back up.<\/p>\n

A couple days after each restart, I’d get an email from one of my clients to the effect of, “It’s weird, all of a sudden the time on our orders is one hour off.”<\/p>\n

“That is weird”, I’d reply, and immediately I knew that the server time zone was set improperly. So, I’d do the usual move my timezone file over to the \/etc\/localtime and voila, it was fixed.<\/p>\n

I manage a few servers, so I clearly couldn’t remember that this same server was having the time zone reset every couple months. It finally hit me that it was something in a server config file.<\/p>\n

A simple update to \/etc\/sysconfig\/clock<\/em> and I’m good to go!<\/p>\n

Oh, that update was to set the ZONE=<\/em><\/strong> parameter\u00a0in the clock config file to the proper time zone.<\/p>\n

<\/h3>\n

Secure Images not Working in some Email Clients<\/h3>\n

I had a really stupid and probably not-so-common issue with SSL certificates this week. I had installed a very basic Positive SSL certificate on one of my domains.<\/p>\n

Everything checked out, except, when I viewed an email in Mozilla Thunderbird, it would not load the secure images from the server. \u00a0Any image at https:\/\/ simply wouldn’t load.<\/p>\n

It ends up that Thunderbird didn’t like the order that I placed the SSL certificate chain files in!<\/p>\n

This post<\/a> brought the issue to light for me.<\/p>\n

 <\/p>\n

SQL<\/h2>\n

Getting the total row count when a limit is used<\/h3>\n

This is a really handy tip I learned this week. Typically when I want to return the number of matched rows when a LIMIT is used, I’ll do one of two things:<\/p>\n