MySQL Launchd item for Mac OS X Tiger

jstetser (Jake Stetser) — Tue, 07 Jun 2005 16:14:06 GMT

(Originally posted at Unquiet)

I had to reinstall Mysql because it wasnâ€™t one of the things I backed up before erasing my hard drive. Since Iâ€™m now running Mac OS X 10.4 â€œTigerâ€?, I decided to set it up to start when the system boots, but the system for creating startup items has changed slightly. So I saved the following xml in /Library/LaunchDaemons/com.mysql.Mysql.plist:



             "-//Apple Computer//DTD PLIST 1.0//EN" "

        http://www.apple.com/DTDs/PropertyList-1.0.dtd">

    

    

        Label

        com.mysql.Mysql

        OnDemand

        

        ProgramArguments

        

                /usr/local/mysql/bin/mysqld_safe

        

        ServiceDescription

        Mysql 4.1 Database Server

        UserName

        mysql

        WorkingDirectory

        /usr/local/mysql

Note that I'm using the official OSX distribution of MySQL... but with a few changes to match your database location, you can get this to work with other installs (fink, darwinports, etc).

WordPress with clean urls on Lighttpd

jstetser (Jake Stetser) — Tue, 07 Jun 2005 16:12:59 GMT

This single line seems to work for my WP install. I needed to add a couple of redirects and rewrites to handle my RSS feed, since I use Feedburner, but this line does all the heavy lifting...

Place it after server.document-root, either in the main section or in your virtual host sub-sections...

server.error-handler-404 = "/index.php?error=404"

and use this as your clean urls template

/%year%/%monthnum%/%day%/%postname%/

DZone Snippets: Jstetser's Code Snippets

MySQL Launchd item for Mac OS X Tiger

WordPress with clean urls on Lighttpd