PHP mysqli session error in SocialEngine on Mavericks Server 3 (OS X 10.9)

After installing SocialEngine 4 (4.8.6) on my Mac mini running Mavericks Server 3 and PHP 5.4.27, SocialEngine pukes with a error:

Read on for a solution:
Continue reading

Store Sequel Pro favorites and preferences in Dropbox

I’m experimenting with storing Sequel Pro’s favorites and preferences in Dropbox on Mavericks. I say experimenting, because Mavericks (unlike earlier OS X incarnations) actually caches all app preferences at login. So it’s unclear how often the OS re-reads preference files, and what impact having them stored in Dropbox (where they can be changed on another computer) will have on this system. Continue reading

Move Cornerstone SVN client settings and data to new computer

I use Cornerstone as my app of choice to manage those repositories. Combined with Unfuddle, it’s a wonderful combination for remote programming teams. I recently had the need to rebuild my Mac OS X desktop computer at work. I have a fair number of SVN repositories and working copies on my machine.

Anyway, I backed up all my Mac (including working directories), then formatted my hard drive. After reinstalling everything, I copied the working directories back to their original location, then copied these file, using terminal, from the backup to the new installation:

Preferences:

Registration Databases and Transcripts:

And everything is working perfectly again!

Adding SSL certificate to Mavericks Server 3 on Mac OS X 10.9

I wanted to add a cheap SSL certificate to my Mac OS X Mavericks 10.9.1 server. I purchased a Comodo PositiveSSL certificate for $9 from Namecheap.com. After generate the signed certificate request using the Server.app tool, I followed their directions and finally got the certificate. But after installing it, Server.app and Keychain both reported that “this certificate was signed by an unknown authority.” What gives?

Well, simply put, Mac OS X doesn’t recognize PositiveSSL as a certificate authority. So I needed to import their root certificate. Here’s how. In Keychain.app, search for your certificate based on the hostname that it’s assigned. Double click that cert, and scroll down to find the PositiveSSLCA2.crt. Click the link, which will download the cert. Then double click the downloaded .crt file and add it to your system keychain. Voila. All is well.

Test whether outbound port is open on Mac OS X 10.9, 10.8, 10.7

Wondering if a certain outbound port on your Mac is open or closed? Here’s a way to test if that port is open using netcat via the command line in terminal, using a free service from portquiz.net:

From terminal, enter:

where 443 is the port number you want to test.

Control-c will kill net cat after you get the info you want.

Create a Dropbox clone on Mac OS X Mavericks using OwnCloud

My company uses Dropbox extensively for sharing project files. It truly is an enhancement to our workflow. But, we don’t like the privacy concerns of hosting our contracts and other confidential information in their cloud, nor do we like the cost. We like everything else.

OwnCloud is an open source alternative to Dropbox, and provides the same features.

I decided to install it on our Mac mini server to give it a trial run. Here’s how I did it:

Continue reading