Home  |  software  |  Musings  |  Pictorial  |  Academics  |  Links


Weblogs and Photo Albums on Mac OS X

I just gave a talk to our local Mac-Geek group about web logging and photo album web applications on Mac OS X. If you feel like installing PHP, mySQL, WordPress, or Gallery, you can check out my notes.

Software Used In This Talk

SubEthaEdit is a pretty rockin’ text editor that also allows people to collaboratively edit/view documents.
mySQL is a super-popular and super-powerful relational database backend. Detailed installation instructions are here.
CocoaMySQL is an alternative to phpMyAdmin. It's a Cocoa program that you can use to modify databases on local or remote machines.
phpMyAdmin is a php-based front-end to mySQL. In other words, it lets you configure and modify your databases from within a webpage rather than from the command-line.
WordPress is the weblog software I'm going to install. It's powerful, free and hackable.
Gallery is a super-powerful online photo album solution. You also need to download the support binaries netpbm and jhead.
We'll be making heavy use of Terminal. It's in your Utilities folder, which is in your Applications folder. Or just click the link.

General Weblog Information

Weblog Comparison Chart
PHP-Based Weblogging Software
Perl-Based Weblogging Software
Generalized Content Management Systems (CMS)

Getting PHP Working

  1. Create test PHP file
  2. Edit /etc/httpd/httpd.conf (enable PHP, set to default to PHP index files, allow .htaccess overrides)
  3. Turn on or restart webserver

Installing mySQL

  1. Run installer
  2. Install startup item
  3. Fix permissions in the data folder
  4. Start mySQL
  5. Change the root password
  6. Verify using CocoaMySQL

Installing phpMyAdmin

  1. Place into /Library/Webserver/Documents
  2. Create a symlink for convenience
  3. Add path and password to config.inc
  4. Test it!

Installing WordPress

  1. Place into /Library/Webserver/Documents
  2. Create wp-config.inc
  3. Set database name, username and password in wp-config.inc
  4. Create WordPress database user
  5. Create WordPress database
  6. Reload mySQL
  7. Browse http://localhost/wordpress/ and follow the prompts
  8. Change the admin password
  9. Browse your wordpress installation by surfing to http://localhost/wordpress/. Make changes by surfing to http://localhost/wordpress/wp-admin.php.

Installing Gallery

  1. Place into /Library/Webserver/Documents
  2. Create necessary files and directories
    cd /Library/Webserver/Documents/gallery
    cd ..
    mkdir albums
    sudo chown -R www albums
  3. Install support binaries
    cd /usr/local
    if [ ! -e bin ] ; then sudo mkdir bin; fi
    cd bin
    sudo cp ~/Desktop/jhead ./
    sudo chmod a+x jhead
    rm ~/Desktop/netpbm/README
    sudo cp ~/Desktop/netpbm/* ./
  4. Surf to http://localhost/gallery/ and begin the Configuration Wizard. Set the password and set the temporary directory to /tmp.
  5. Secure your Gallery installation
    cd /Library/Webserver/Documents/gallery

Integrating iPhoto with Gallery

  1. Run the iPhotoToGallery installer
  2. Launch iPhoto
  3. Select photos to export
  4. Choose Export… from the File menu. Navigate to the Gallery tab.
  5. Choose Add Gallery from the menu of galleries
  6. Select or create an album to export to and export 'em!


© 2005 — All Rights Reserved Site credits >