[wiki:howto <- Back to the HOWTO section] = Getting Apache, MySQL, and PHP Running under MacPorts = * Audience: Users who don't like the default OS X installation * Requires: MacPorts == Introduction == These instructions are written for the following versions: * Apache 2.2.* * MySQL 5.0.* * PHP 5.2.* == Installation == === Step 1: '''Turn off Apple's "Personal Web Sharing"''' === If you haven't already done so, make sure you turn off Apple's "Personal Web Sharing" in the System Preferences so that the default Apache server is not running. While you can set things up so that both servers run on different ports (e.g., port 80 and port 8080), it's not worth the hassle of maintaining two web server daemons. Just use the latest Apache from MacPorts and be done with it. === Step 2: Install Apache === {{{ sudo port install apache2 }}} Create an initial httpd.conf configuration file: {{{ cd /opt/local/apache2/conf sudo cp httpd.conf.sample httpd.conf }}} Activate your Apache installation so that it starts now and every time you boot your machine: {{{ sudo launchctl load -w /Library/LaunchDaemons/org.macports.apache2.plist }}} Point your browser to http://localhost/ (page refresh may be needed) and verify that Apache is running. (For Apache 2.2.9, you should see a giant "It works!" displayed.) Reboot your machine, point your browser again to http://localhost/, and verify that Apache has started and is running. You may want to enable local access to the "Apache HTTP Server Manual" and to User web pages. In `/opt/local/apache2/conf/httpd.conf`, search for the line {{{ #Include conf/extra/httpd-userdir.conf }}} and uncomment it this way: {{{ # Include conf/extra/httpd-userdir.conf }}} now uncomment the line {{{ #Include conf/extra/httpd-manual.conf }}} the same way: {{{ # Include conf/extra/httpd-manual.conf }}} In `/opt/local/apache2/conf/extra/httpd-userdir.conf`, add the following lines to the end of the file: {{{ # # Include user configurations # Include /private/etc/httpd/users/*.conf }}} Restart Apache (`sudo /opt/local/apache2/bin/apachectl -k restart`) and verify that everything's running. You should now be able to go to http://localhost/manual/ to access the manual, and you should be able to access your personal user web site at http://localhost/~username/, where "username" is your login id. '''''Note:''''' When you upgrade your Apache installation (e.g., `sudo port upgrade apache2`), be aware that the upgrade will not affect your `httpd.conf` file, but '''it will overwrite the other configuration files''', such as the `httpd-userdir.conf` file (see #8605). Therefore, if you've made any changes to those files (e.g., activating User web pages), you will need to save your `httpd-userdir.conf` file before upgrading and then reapply your changes after the upgrade. However, it would probably be a good idea to save your `httpd.conf` file too, just to be safe. === Step 3: Install MySQL === {{{ sudo port install mysql5 +server }}} Activate your MySQL server installation so that it autostarts when you boot your machine: {{{ sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist }}} Set up the main database {{{ sudo -u mysql mysql_install_db5 sudo chown -R mysql:mysql /opt/local/var/db/mysql5/ sudo chown -R mysql:mysql /opt/local/var/run/mysql5/ sudo chown -R mysql:mysql /opt/local/var/log/mysql5/ }}} ''If that doesn't work try this:'' {{{ sudo mysql_install_db5 sudo chown -R mysql:mysql /opt/local/var/db/mysql5/ sudo chown -R mysql:mysql /opt/local/var/run/mysql5/ }}} Start the MySQL daemon {{{ sudo /opt/local/bin/mysqld_safe5 & }}} and then verify that it's running {{{ ps -ax | grep mysql }}} Set the MySQL `root` password (it's currently empty): {{{ mysqladmin5 -u root -p password }}} where `` is your new desired root password. You will be prompted for your existing password ("`Enter password:`"); since it's empty, just press Return. Test everything by logging in to the server. {{{ mysql5 -u root -p }}} Once you're logged in, simply exit the session {{{ mysql> exit ; }}} As a last test, reboot your machine and then run {{{ ps -ax | grep mysql }}} again to verify that the daemon is still active. === Step 4: Install PHP === {{{ sudo port install php5 +apache2 +mysql5 }}} Register PHP with Apache {{{ cd /opt/local/apache2/modules sudo /opt/local/apache2/bin/apxs -a -e -n "php5" libphp5.so }}} Update Apache's `httpd.conf` file to enhance the "DirectoryIndex" directive to include additional "index" files. Search for: {{{ DirectoryIndex index.html }}} and change it this way: {{{ DirectoryIndex index.php index.html }}} Also, at the end of the `httpd.conf` file, add the following lines so that Apache includes the mod_php "AddType" configurations {{{ # # Include PHP configurations # Include conf/extras-conf/mod_php.conf }}} You may also need to load the PHP module '''before''' including `mod_php.conf` as described above: {{{ # Load the PHP module LoadModule php5_module modules/libphp5.so }}} Set up your PHP configuration files {{{ cd /opt/local/etc sudo cp php.ini-dist php.ini }}} If you installed php5 with the +pear variant you should also: {{{ sudo cp pear.conf.sample pear.conf }}} Restart Apache so that your changes take effect {{{ cd /opt/local/apache2/bin/ sudo ./apachectl -k restart }}} Create a file named `phpinfo.php` that contains the following three lines {{{ }}} and place it in your Apache "`DocumentRoot`" directory (should be "`/opt/local/apache2/htdocs`") or your own user "`Sites`" directory if you activated user directories as specified above. Point your browser to http://localhost/phpinfo.php (or http://localhost/~username/phpinfo.php if applicable) and verify that the correct version of PHP is active (v5.2.6 as of this writing) and that MySQL support is active (you may want to search the page for "`mysql`"). As a last check, reboot and verify that everything has autostarted and is running (i.e., repeat the above tests). === Step 5: Install phpMyAdmin (optional) === Use MacPorts to install the latest version of `phpMyAdmin`. {{{ sudo port install phpmyadmin }}} Update Apache's `httpd.conf` file to find `phpmyadmin`. First add the following lines to the end of the file: {{{ # Local access to phpmyadmin installation Include conf/extra/httpd-phpmyadmin.conf }}} and then create a file `/opt/local/apache2/conf/extra/httpd-phpmyadmin.conf` containing this text: {{{ AliasMatch ^/phpmyadmin(?:/)?(/.*)?$ "/opt/local/www/phpmyadmin$1" Options -Indexes AllowOverride None Order allow,deny Allow from all LanguagePriority en de es fr ja ko pt-br ru ForceLanguagePriority Prefer Fallback }}} Finally, you need to set up the `phpMyAdmin` configuration to access mySQL. First, set up the config file: {{{ cd /opt/local/www/phpmyadmin/ cp config.sample.inc.php config.inc.php }}} This will create a file `config.inc.php` in the `phpMyAdmin` folder. Edit that file, and locate the lines: {{{ $cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)? $cfg['Servers'][$i]['user'] = 'root'; // MySQL user $cfg['Servers'][$i]['password'] = ; // MySQL password (only needed // with 'config' auth_type) }}} You can either change the `auth_type` from 'config' to 'cookie' or 'httpd', or alternatively provide the password you selected for the root user in the 'password' option. To check your phpMyAdmin installation, point your browser to http://localhost/phpmyadmin (or http://localhost/~username/phpmyadmin if applicable) and verify that phpMyAdmin loads and can access your database (by providing a username and password, depending on the authentication method you selected). [wiki:howto <- Back to the HOWTO section]