Using MacOS X, Apache, PHP, MySQL, Dreamweaver UltraDev, and Phakt

•  Introduction
•  Choosing your Mac OS X Operating System
•  Installing Apache and PHP
•  Installing MySQL
•  Installing the required JDBC drivers
•  Installing the Phakt PHP Server Model
•  Setting up UltraDev and Phakt to talk to MySQL
•  Potential Problems







Page 4 -- Installing the JDBC Driver on the Web Server

The Phakt PHP server model, which we'll be talking about shortly, relies on a JDBC connection to the MySQL database for run-time connections. These connections are used for such things as creating the objects that appear in UltraDev's Data Bindings Inspector, Live Data Preview, and the like. We'll need to install these drivers to get it to work, and there are some pretty details steps involved in doing so. Follow along closely with me now; watch the wording:

  1. First, decompress the MM.MySQL Java archive (JAR) file that you just downloaded. The latest version of the JDBC driver as of the writing of this article is v2.0.8, and the JAR file should be called something like mm.mysql-2.0.8-you-must-unjar-me.jar. If you are using StuffIt Expander, it may have done this for you already. There will likely be a folder on your desktop called "mm.mysql-2.0.8-you-must-unjar-me Folder" or something along that line that contains the objects we need. If it hasn't been "un-JARred" for you yet, drag the JAR file onto your Stuffit Expander application icon or use your favorite decompression tool.
  2. From the Finder menu, select Go > Go To Folder... and enter "/usr/local/" (without the quotes).
  3. Open the folder called "mysql-3.23.47" in your /usr/local folder
  4. Open the folder called "mm.mysql-2.0.8-you-must-unjar-me Folder" from the location into which it was decompressed in Step 1, and find the folder named "mm.mysql-2.0.8."
  5. Copy the entire "mm.mysql-2.0.8" folder into the "mysql-3.23.47" folder.

Installing the JDBC Driver for UltraDev and OS 9 (Mac Ultradev Users Only)

The steps above install the JDBC driver for MySQL to use, but JDBC is a two-way street. You also need to install the same JDBC driver on the other end of the connection so that UltraDev (or other applications) can use it. Note: This is for the Classic layer (OS 9) to use.

  1. In the /usr/local/mysql-3.23.47/mm.mysql-2.0.8 folder that was just installed above, find the file called mm.mysql-2.0.8-bin.jar.
  2. Place a copy of this file (not an alias of it) in Macintosh HD : System Folder : Extensions : MRJ Libraries : MRJClasses. If your system hard drive is named differently than that which is shown above, or if OS 9 is installed on a different partition, follow the path to the MRJClasses folder on that drive.
  3. Reboot your Mac for changes to take effect.

Let's install Phakt!

 

 
Copyright ©2001 Christopher Owens. The logos above are copyrighted by their respective owners, organization, and corporations.