1. Starting MySQL server
Go in Applications/Server/MySQL Manager'''
- Install the files needed by sql by clicking on the button
- setup a root mysql password
- start the service
2. Configure php4 to connect to the mysql socket
To change the location where PHP looks for the socket file, follow these steps:
- In Terminal: sudo cp /etc/php.ini.default /etc/php.ini
- Open /etc/php.ini in your preferred text editor.
- Find the [MySQL] section, and change the mysql.default_socket directive:
; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
mysql.default_socket = /var/mysql/mysql.sock
- Change the permissions on /var/mysql so that www can read the socket, by executing this in Terminal:
sudo chmod 775 /var/mysql
Once you have it setup, you can process the rest of the install
3. Enable php4 directives in httpd.conf
Add the following directives to your config:
LoadModule php4_module libexec/httpd/mod_php4.so
LoadModule log_sql_module libexec/httpd/mod_log_sql.so
LoadModule log_sql_mysql_module libexec/httpd/mod_log_sql_mysql.so
And check that those are set AFTER the ClearModuleList directive:
AddModule mod_php4.c
AddModule mod_log_sql.c
AddModule mod_log_sql_mysql.c
Note that DTC has mod_log_sql.so and mod_log_sql_mysql.so compiled for PPC. If it doesn't find mod_log_sql.so it will copy it from the archive. But if you use an Intel based Mac, You need to recompile those 2 .so modules from our cvs using those commands:
cvs -d :pserver:anonymous@gplhost.com:/var/lib/cvs checkout libapache-mod-log-sql
cd libapache-mod-log-sql
patch -p1 <debian/patch/001-mod_log_sql.c.dpatch
patch -p1 <debian/patch/002-mod_log_sql.h.dpatch
./configure --prefix=/usr --mandir=/usr/share/man --with-apxs=/usr/bin/apxs
make install
4. Install the panel itself
Download our latest release from here:
ftp://ftp.gplhost.com/pub/dtc/macosx
Untar the archive, then run the installer using ./install.
