After self-signing an SSL certificate for development purposes the Web server needs to be configured appropriately. I found the posting by Dave Kiss to be the best one. Following are the required steps if you used the default MAMP settings:
Backup your configuration files:
Open a terminal window.
Go to the Apache configuration folder:
Backup the Apache configuration file:
cp httpd.conf httpd.conf.bak
Backup the SSL configuration file:
cp extra/httpd-ssl.conf extra/httpd-ssl.conf.bak
Update the Apache configuration file:
Open the configuration file using an editor of your choice:
Search for the line containing httpd-ssl.conf:
Press Ctrl-W then type httpd-ssl.conf
Uncomment the line by removing the # from the beginning such that it reads:
Save and exit:
Press Ctrl-X the Y
Copy the server.key and server.crt file to your Apache configuration folder.
N.B. If the apache server fails to start then you have an error in your configuration, make sure you replace the DocumentRoot in your SSL configuration file to match your actual root folder.
N.B. Dave’s post also contains steps to configure Virtual Hosts which I left out for a different posting to be less confusing.
N.B. Dave’s post using git to backup the files, in this post I simply make a copy of the configuration file, if you want to restore the backup simply type: cp httpd.conf.bak httpd.conf or any other file you want to restore.
At some point any Web Developer would need to secure part of a site and therefore require an SSL certificate. There are different options available depending on the use and here is a short post documenting the various options:
Free for Open Source Projects: Some providers are willing to offer free SSL certificates for open-source projects such as GoDaddy.com, obviously some terms and conditions apply which one must read. More details can be found here.
Free with Hosting Plan: Some Web Hosting providers would include a free SSL certificate if you buy a hosting plan. Generally the offer is for the first year with competitive renewal pricing. Just to name a few: HostColor.com, DomainAvenue.com and HostGator.com
Free SSL Community: A growing community called StartSSL are offering an entry level service for free for basic used and limited warranty which might well satisfy your needs and therefore worth a check.
Comparison Charts: If none of the above suits you then you might have to actually buy an SSL certificate, not before doing the appropriate research. WhichSSL is a dedicated site to aid in the selection of the appropriate certificate authority or SSL vendor to choose with the help of a comparison chart. More comparisons can be found in Wikipedia.org and SSLShopper.com. Your research might also payoff by finding some promotional offers and/or discounts.
Self-Signed Certificates for Development: Well if you need a certificate just for development purposes then you can sign one yourself as shown in my previous post.
If you are planning on developing or customizing some web systems such as WordPress or Magento, then at one point you will need some security. You might want to sign the SSL certificate yourself. A number of guides exists for this, for Windows Systems I found the one by Shivprasad Koirala to be very intuitive and for Unix systems the one by Heroku and Scott Baker are best. Here are the steps required:
Check that openssl is installed by running the following command in a terminal:
If no such file is found then you need to install. Here are the possible installation methods
Recently I participated in a discussion of a common problem in data modelling. The question is whether to represent parties (groups) as roles or as subtypes (generalisation hierarchy).
When designing the Conceptual Data Model, parties can be represented as subtypes provided there is a common context amongst sub-types. In the Logical Model, subtypes should be represented only if each subtype has a unique concept that the others don’t.
Another task that I needed to do after buying my Mac was to get my Web toolkit working. Apache, MySQL and PHP are very conveniently managed by MAMP, WordPress is as straight forward as always. MySQL Workbench required some fine tuning but managed to fix it properly.
Decided to document everything as I went along and prepared a well documented guide with some of my personal recommendations. Hope you will find it useful and as always all feedback is welcome.
One of my first tasks I wanted to be able to do after getting my Mac was to be able to remotely connect to my servers and a number of other trusted systems for support. I wanted to try a number of options and my first serious attempt was with TeamViewer.
My Laptop is a Mac, my Home-PC is Ubuntu Linux and my wife uses Windows XP. I installed version 7.0 of TeamViewer on each OS and got remote access in no time. Thought of creating a short guide on the subject even though the application is very self intuitive.
So here is the guide to getting remote access across different Operating Systems using TeamViewer: TeamViewer Guide