Changes between Version 1 and Version 2 of howto/MAMP

Timestamp:

May 31, 2008, 10:09:19 PM (16 years ago)

Author:

jaguarcy+macports@…

Comment:

--

howto/MAMP

@@ -86 +86 @@
 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 `http.conf` file, but '''it will overwrite the other configuration files''', such as the `httpd-userdir.conf` file. 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 `http.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 mysql5 mysql_install_db5 
+sudo chown -R mysql:mysql /opt/local/var/db/mysql5/ 
+sudo chown -R mysql:mysql /opt/local/var/run/mysqld5/ 
+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/mysqld5/
+  }}}
+
+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 <new-password>
+}}}
+
+where `<new-password>` is your new desired root password.
+
+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 ===
+
+'''Note: Currently, the PHP5 installer uses wget to install the PEAR environment, but the installer does not list wget as a dependent component. So, the installation will fail during the staging operations if you do not manually install wget first.'''
+
+{{{
+sudo port install wget
+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:
+
+{{{
+DirectoryIndex index.html index.cgi index.php
+}}}
+
+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
+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
+
+{{{
+!#php
+<?php
+phpinfo();
+?>
+}}}
+
+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/data/phpmyadmin$1"
+
+<Directory "/opt/local/www/data/phpmyadmin">
+  Options -Indexes
+  AllowOverride None
+  Order allow,deny
+  Allow from all
+  
+  LanguagePriority en de es fr ja ko pt-br ru 
+  ForceLanguagePriority Prefer Fallback
+</Directory>
+}}}
+
+Finally, you need to set up the `phpMyAdmin` configuration to access mySQL. First, set up the config file:
+
+{{{
+cd /opt/local/www/data/phpmyadmin/
+cp libraries/config.default.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]