Fix SpamAssassin Error on Mavericks Server 3

Every once in awhile Apple’s shitty Server 3 throws errors that prevent SpamAssassin from processing new spam. The error shows up when I run spam trainer. The error it throws looks like:

ERROR: Bayes dump returned an error, please re-run with -D for more information
bayes: cannot open bayes databases /Library/Server/Mail/Data/scanner/amavis/.spamassassin/bayes_* R/O: tie failed: Permission denied

Fix it by issuing these commands from Terminal:

sudo chown -R amavisd:amavisd /Library/Server/Mail/Data/scanner/amavis/.spamassassin/
sudo chmod u+rw /Library/Server/Mail/Data/scanner/amavis/.spamassassin/bayes_seen
sudo chmod u+rw /Library/Server/Mail/Data/scanner/amavis/.spamassassin/bayes_toks

Set up Mavericks Server 3 for email and train bayes spam filter

OS X Mavericks 10.9 Server 3 ships with SpamAssassin, but there are almost no controls available to admins (shame on you, Apple). Of course, a well-trained Bayes spam filter will cut down on annoying spam messages.

Thanks to the good folks at topicdesk.com, it’s super easy to set up the server for training the onboard SpamAssassin bayesian spam filter.

Here’s how:
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:
~/Library/Preferences/com.zennaware.Cornerstone.plist
Registration Databases and Transcripts:
~/Library/Application Support/Cornerstone
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:

nc -v portquiz.net 443

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