Getting access to iCal Server database

On Mac OS X Server 10.7 and 10.8, the data for the iCal and Address Book services is located inside a PostgreSQL database. If you wish to see the data in the database, you can connect to the database by logging with SSH on the server, and call:

sudo psql -U _postgres caldav

All iCalendar objects are in the calendar_object table, and all vCard objects are in the addressbook_object table.

 If you wish to delete the data because you are not using the services anymore, call:

sudo dropdb -U caldav caldav

SSL issues with git and CentOS

Someone told me of a problem with Jenkins and Git who can't do a clone because of a SSL issue with the certificate from GitHub. I remember having the same issue a couple of months ago. The main problem is that the root certificates in CentOS (and I assume Amazon Linux and RedHat) are too old and don't have the root certificate of the provider that GitHub use.

How to fix this? See this blog post.