Chapter 4. Installing and configuring phpMyAdmin

Table of Contents

1. Prerequisites
2. Installing PHP
3. Configuring phpMyAdmin
4. Installing OpenSSL
5. Installing and Configuring Apache with SSL

PhpMyAdmin is a MySQL database administration tool written in php. PhpMyAdmin is useful because Marmoset is an active research project that is sometimes unstable, so it is often necessary to view or update the raw data in the database directly with another tool.

This chapter is not necessary for the correct functioning of Submit Server.

1. Prerequisites

2. Installing PHP

To Do

3. Configuring phpMyAdmin

To Do

4. Installing OpenSSL

Use the openssl_install script to compile and install openssl (openSSL might already be installed on your system; I always compile it myself anyway).

change all occurrences of port 443 (default SSL port) to something else (I always 3006)

Create $HOME/www/conf/ssl.key and $HOME/www/conf/ssl.crt and copy in a key and a certificate. TODO link the key and cert

In ssl.conf, change "Listen 443" to "Listen 3006" (or some other port)

  • I always put everything into $HOME/software and create symlinks, for example:

    ln -s software/openssl-0.9.7e openssl

  • Edit $HOME/www/conf/ssl.conf
  • Edit $HOME/www/conf/httpd.conf:

    Add: AddType application/x-httpd-php .php AddType application/x-httpd-php-source .phps To the "AddType" section of httpd.conf

    Comment out the "Listen 80" line, we're using a VirtualHost created by the ssl.conf file instead so there's no need for http to listen (since https will be listening).

5. Installing and Configuring Apache with SSL

  • unpack httpd-2.0.55 into $HOME/software
  • Make sure that there's nothing installed in $HOME/www
  • run the apache_install script inside the $HOME/software/httpd-2.0.55 directory. This will install apache httpd into $HOME/www.