Tag: Lion

Complete Un-installation of PostgreSQL from Mac OS X Lion

Complete Un-installation of PostgreSQL from Mac OS X Lion

In response to a question on stackoverflow, here is a short guide on how to completely uninstall PostgreSQL 9.1 from Mac OS X Lion.

  1. Open a terminal window


  2. Run the uninstaller

    sudo /Library/PostgreSQL/9.1/uninstall-postgresql.app/Contents/MacOS/installbuilder.sh

    PostgreSQL Uninstall Wizard
    PostgreSQL Uninstall Wizard in Progress

    Data not removed after PostgreSQL Uninstallation
  3. Remove the PostgreSQL and data folders (Wizard will notify you that these were not removed)

    sudo rm -rf /Library/PostgreSQL

  4. Remove the ini file

    sudo rm /etc/postgres-reg.ini

  5. Remove the PostgreSQL user

    System Preferences -> Users & Groups

    Unlock the settings panel by clicking on the padlock and enter your password

    Select the PostgreSQL user and click on the minus button.

Remove PostgreSQL User


Configuring SSL for Apache on OS X Lion using MAMP

Configuring SSL for Apache on OS X Lion using MAMP

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:

  1. Backup your configuration files:
    1. Open a terminal window.
    2. Go to the Apache configuration folder:
      cd /Applications/MAMP/conf/apache
    3. Backup the Apache configuration file:
      cp httpd.conf httpd.conf.bak
    4. Backup the SSL configuration file:
      cp extra/httpd-ssl.conf extra/httpd-ssl.conf.bak
  2. Update the Apache configuration file:
    1. Open the configuration file using an editor of your choice:
      nano httpd.conf
    2. Search for the line containing httpd-ssl.conf:
      Press Ctrl-W then type httpd-ssl.conf
    3. Uncomment the line by removing the # from the beginning such that it reads:
      Include /Applications/MAMP/conf/apache/extra/httpd-ssl.conf
    4. Save and exit:
      Press Ctrl-X the Y
  3. Copy the server.key and server.crt file to your Apache configuration folder.
  4. Start the servers through the MAMP interface.
  5. Navigate to your site through a browser using https:
Accept self-signed certificate

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.

Configuring MySQL Workbench with MAMP on Mac OS X Lion

Configuring MySQL Workbench with MAMP on Mac OS X Lion

Installing MAMP on Mac OS X Lion is surely an easy way of getting Apache, PHP and MySQL working on your system. If you plan on using MySQL Workbench you will need to do some additional steps.

  1. Create the missing my.cnf file.
    1. Open a terminal window.
    2. Create the file by typing:
      sudo touch /etc/my.cnf
    3. Change the owner of the file to your username:
      sudo chown fraki /etc/my.cnf
  2. Create a new server instance and shown in my previous post: MAMP, MySQL Workbench and WordPress setup guide
  3. Edit the server instance settings as follows:
    1. Set the MySQL Server start command to:
    2. Set the MySQL Server stop command to:
    3. Set the MySQL Server status command to:
      ps xa | grep “/Applications/MAMP/Library/bin/[m]ysqld”
Configuring MySQL Workbench on OS X Lion with MAMP

Keep checking through the guide for additional configuration.

Theme: Overlay by Kaira