Acoenoc.com

To enable https for your site using VirtualHost follow the following steps.

1. Download Apache 2.2.9 with openssl (MSI Installer) from http://httpd.apache.org/download.cgi
2. Execute the installer and follow the instructions.
3. Make sure Apache is installed properly by pointing your web browser to http://127.0.0.1/ or http//localhost/.
4. If you are using default Apache installation directory, navigate to c:\program files\apache software foundation\apache2.2\conf.
5. Execute:
   openssl req -config openssl.cnf -new -out domainname.csr -keyout domainname.pem
   to create a .pem key.
6. Execute:
   openssl rsa -in domainname.pem -out domainname.key
   to create a .key key.
7. Delete .rnd file.
8. Execute:
   openssl x509 -in domainname.csr -out domainname.cert -req -signkey domainname.key -days 365
   to create .cert key.
9. Create a directory called ssl in the conf directory. Move all keys (cert,csr,key,pem) to the newly created directory.
10. Edit httpd.conf.
11. Uncomment line that says:
    LoadModule ssl_module modules/mod_ssl.so.
12. Uncomment line that says:
    Include conf/extra/httpd-ssl.conf
13. Edit extra\httpd-ssl.conf.
14. Under directive <VirtualHost _default_:443>, edit DocumentRoot and ServerName to reflect your site name.
15. Point SSLCertificateFile to conf/ssl/domainname.cert
16. Point SSLCertificateKeyFile to conf/ssl/domainname.key
17. Modify options under <Directory> directives as required.

To know more about what each command does refer to http://www.neilstuff.com/apache/apache2-ssl-windows.htm.

1. Download the latest version of phpMyAdmin from http://www.phpmyadmin.net/home_page/downloads.php.
2. Extract the content to your desired installation location. (I will use D:\sites\phpmyadmin for this article).
3. Edit httpd.conf (Apache) to setup a virtual host by adding
   NameVirtualHost *:80

<VirtualHost *:80>
DocumentRoot “D:/sites/phpMyAdmin”
ServerName phpMyAdmin
<Directory “D:/sites/phpMyAdmin”>
        AllowOverride None
        Options None
        Order allow,deny
        Allow from all
    </Directory>
</VirtualHost>
lines to the bottom of the file.

4. Restart Apache.
5. Navigate to phpmyadmin installation directory and copy the file config.sample.inc.php to config.inc.php and edit it as you desired (or download mine here).
6. You need to enable a few extensions (edit php.ini) in order to use phpmyadmin. Here’s a few:
   extension=php_mysql.dll
   extension=php_mysqli.dll
   extension=php_mcrypt.dll
7. Since you are using virtual host, you need to edit your hosts file (%SystemRoot%\system32\drivers\etc\hosts).
   127.0.0.1 phpMyAdmin
8. Point your browser to http://phpMyAdmin/ .
9. You should now be able to login.
10. Navigate to Import tab.
11. Click Choose File.
12. On the popup box, navigate to D:\sites\phpmyadmin\scripts and select create_tables.sql. SQL commands should successfully execute.
13. Now, navigate to SQL tab.
14. Type: grant all on pmadb.* to ‘pma’@'localhost’ identified by ‘pmapass’.
15. Click Go.
16. You are all set to use phpMyAdmin now.

Apache installation on Vista is a breeze. Just use the installer downloaded from http://httpd.apache.org/download.cgi.

If you are looking steps to install PHP using MSI Installer, this isn’t for you. I have tried installing PHP using MSI installer on Vista, and it was a pain. So I decided to manually install and setup the PHP environments.

Below are the steps:

1. Download PHP Windows Binaries from http://www.php.net/downloads.php#v5 (zip package).
2. Unzip them to your desired location. I recommend not to install PHP on the partition where your Vista resides (e.g. D:\PHP) to avoid UAC annoyance.
3. Click on “Vista” icon (or “Start” button) on your desktop, right click on Computer and select Properties. Click on Advanced system settings.
4. A dialog box pops up. Click on Environment Variables.
5. Under System Variables scroll to find Path variable. Select and click Edit…
6. Append your PHP path (e.g. D:\PHP) to the beginning of Variable value. Don’t forget to insert ; after it. And save it.
7. Under System Variables click New…
8. Variable name: PHPRC, Variable Value: D:\PHP. And save it.
9. And just click OK buttons all the way to close all the dialog boxes.
10. Open a Command Prompt and execute “php -v” to see if PHP is correctly installed.
11. Edit php.ini file (under D:\PHP) and set your extension_dir to “./ext”.
12. Edit httpd.conf (Apache’s) and add
    LoadModule php5_module “D:/PHP/php5apache2_2.dll”
    AddType application/x-httpd-php .php
    line to the bottom of the file.