Last week I posted seeking help getting PHP/MySQL and WordPress working on a Windows 2003 server with IIS.

I just wanted to come back and update that I *was* able to get it working with IIS after a lot of blood, sweat, tears and aggravation, however it did not feel “stable” too me – I simply wasn’t comfortable putting it into production like that. It felt shoehorned for lack of a better word.

I ended up going with a separate server running WampServer. I did try out XAMPP as well, however (and this could have just been my impression) XAMPP felt a little more “workstation” oriented, and I think would be better for someone wanting an “AMP” stack on say a Windows XP workstation that they also use for development. I liked the config tools that came with WampServer a little better, and I also managed to learn some of the behind-the-scenes config file “stuff” for Apache as well.

Long story short, I was able to get what I needed created, and I’m happy to say that I am a LOT more comfortable with Apache now – it seems like a awesome web server once you dig in and learn how it works. Also, luckily I have several other projects that may be coming down the pipe that require Apache, so not only will I be better prepared, I already have the “dirty work” done

Moodle is usually easy to install once you’ve got Apache/PHP 5/MySQL running.

But the installation script for Moodle 1.8 fails- hitting ‘Next’ after entering the database information gave me a blank screen.

The install works fine under XP. But the problem isn’t limited to Vista: John McGrath and others on moodle.org report a similar problem under XAMPP/Win2000. John manually built his configuration file to get Moodle running (http://moodle.org/mod/forum/discuss.php?d=64692).

I was able to install Moodle 1.8 successfully under Vista following his approach.

1. Install the Apache webserver. I’m using Apache 2.2.4.
2. Install MySQL 5 (The most recent installer (5.0.41) works without a hitch under Vista. Don’t forget to unblock port 3306 in your firewall, and set sql-mode=”” in your my.ini file; Moodle doesn’t like strict mode).
3. Install PHP 5. I’m using version 5.2.3.
4. Download the latest stable build of 1.8+ from http://download.moodle.org/download.php/stable18/moodle-latest-18.zip.
5. Unzip the file into your Apache document root (c:\apache\htdocs, if you follow the instructions linked in step one). I renamed the directory c:\apache\htdocs\moodle18, so I could install multiple versions of moodle later for testing.
6. Create a directory for storing data that is outside the document root (I used c:\apache\htdata).
7. Create an empty database for Moodle 1.8. I used mysql:
   1. Get a command line (All Programs > Accessories > Command Line) and start up mysql:

      mysql -u root -p

   2. After giving mysql your root password, you should see a welcome message. At the mysql prompt, type:

       create database moodle18;
       grant select,insert,update,delete,create,drop,
          index,alter on moodle18.* to moodle@localhost
          identified by 'put-a-moodle-password-here';
       quit;
      

8. Double check your php.ini file. Moodle requires the following to be set somewhere in php.ini:

   session.auto_start = 0
   magic_quotes_gpc = On
   magic_quotes_runtime = Off
   register_globals = Off
   sql.safe_mode = Off
   file_uploads = On
   memory_limit = 128M
   upload_max_filesize = 64M
   post_max_size = 64M
   extension=php_gd2.dll
   

   Moodle won’t complain if you leave magic_quotes_gpc off, but Joomla will.

   64 megabytes is just a little larger than my largest course backups- if I set it any smaller, I won’t be able to upload them through Moodle.

9. Create a Notepad file in your Moodle directory and call it config.php (c:\Apache\htdocs\moodle18\config.php, for me):

   <?php /// Moodle Configuration File
   
   unset($CFG);
   
   $CFG->dbtype = 'mysql';
   $CFG->dbhost = 'localhost';
   $CFG->dbname = 'moodle18';
   $CFG->dbuser = 'moodle';
   $CFG->dbpass = 'put-a-moodle-password-here';
   $CFG->dbpersist = false;
   $CFG->prefix = 'mdl_';
   
   $CFG->wwwroot = 'http://localhost/moodle18';
   $CFG->dirroot = 'C:\Apache\htdocs\moodle18';
   $CFG->dataroot = 'C:\Apache\htdata';
   $CFG->admin = 'admin';
   
   $CFG->directorypermissions = 00777; // try 02777 on a server in Safe Mode
   
   $CFG->unicodedb = true; // Database is utf8
   
   require_once("$CFG->dirroot/lib/setup.php");
   // MAKE SURE WHEN YOU EDIT THIS FILE THAT THERE ARE NO SPACES, BLANK LINES,
   // RETURNS, OR ANYTHING ELSE AFTER THE TWO CHARACTERS ON THE NEXT LINE.
   ?>
   

   Put in your own paths and passwords.

10. Browse to your Moodle directory (http://localhost/moodle18, for me) and the install script should take it from there!

I initially tried the msi installer for PHP 5. Unfortunately, it installs only PHP under CGI, which although it has some performance and security issues, might be ok for a quick and dirty development environment.

But the installer is badly broken. You’ll get an error something like

PHP Fatal error:  require_once()[function.require]: Failed opening
required 'SAM/php_sam.php' (include_path='.;C:php5pear') in
sam_factory on line 1

After fighting this for a couple of hours, I ended up installing manually anyway. I used this procedure to get PHP 5 running under Vista:

1. Install the Apache webserver.
2. Get the current version of PHP 5 from http://www.php.net/downloads.php#v5. (It’s 5.2.3 at this time). Get both the zip file and the PECL zip file (which includes extensions).
3. Uninstall any previous installations of PHP 5 (Start > Control Panel > Programs and Features). You may have to reboot your machine.
4. Disconnect from the Internet. Turn off your firewall. Turn off your virus checker.
5. Turn off User Account Control (UAC).
6. Get an administrator prompt by going to All Programs > Accessories. Right-Click “Command Prompt” and choose “Run as Administrator”
7. Use the command prompt to manually remove directories containing previous PHP installations (like C:\Program Files\PHP…)
8. Go to the directory where you’ve downloaded the PHP5 and PECL zipfiles. Extract the PHP zipfile. Rename the extracted php directory (which has a name something like php-5.2.3-Win32) to c:\php. Extract the PECL zipfile into c:\php\ext.
9. In the command prompt, type:

   cd c:\php
   mkdir upload
   mkdir session
   copy php.ini-recommended php.ini

10. Open php.ini in Notepad:
    1. There are many variables… the following are important. Notice that starting a line with a semicolon in the ini file comments it out.

       upload_tmp_dir="C:\php\upload"
       session.save_path="C:\php\session"
       cgi.force_redirect=0
       extension_dir ="C:\php\ext"
       display_errors = Off
       log_errors = On
       error_log = "C:\php\error_log"

    2. You might want to look at upload_max_filesize. I’ve set mine to 16M. I also set post_max_size = 16M.
    3. Enable the extensions you need by deleting the semicolon at the beginning of the line. These will depend on your application… I’m going to be using MySQL (which I’ve already installed) and Moodle (which I’ll install later). My list looks like the following:

       extension=php_bz2.dll
       extension=php_curl.dll
       extension=php_dba.dll
       extension=php_dbase.dll
       ;extension=php_exif.dll
       extension=php_fdf.dll
       extension=php_gd2.dll
       extension=php_gettext.dll
       ;extension=php_gmp.dll
       ;extension=php_ifx.dll
       ;extension=php_imap.dll
       ;extension=php_interbase.dll
       extension=php_ldap.dll
       extension=php_mbstring.dll
       extension=php_mcrypt.dll
       extension=php_mhash.dll
       extension=php_mime_magic.dll
       ;extension=php_ming.dll
       ;extension=php_msql.dll
       ;extension=php_mssql.dll
       extension=php_mysql.dll
       extension=php_mysqli.dll
       ;extension=php_oci8.dll
       extension=php_openssl.dll
       ;extension=php_pdo.dll
       ;extension=php_pdo_firebird.dll
       ;extension=php_pdo_mssql.dll
       ;extension=php_pdo_mysql.dll
       ;extension=php_pdo_oci.dll
       ;extension=php_pdo_oci8.dll
       ;extension=php_pdo_odbc.dll
       ;extension=php_pdo_pgsql.dll
       ;extension=php_pdo_sqlite.dll
       ;extension=php_pgsql.dll
       ;extension=php_pspell.dll
       extension=php_shmop.dll
       ;extension=php_snmp.dll
       extension=php_soap.dll
       extension=php_sockets.dll
       ;extension=php_sqlite.dll
       ;extension=php_sybase_ct.dll
       extension=php_tidy.dll
       extension=php_xmlrpc.dll
       extension=php_xsl.dll
       extension=php_zip.dll

11. Right-Click on Start > Computer. Choose “Properties”, then “Advanced”. Click on “Environment Variables”. Click on PATH, then Edit… and add “;C:\php;c:\php\ext” (without quotes) to the end of the variable.
12. Open your Apache configuration file (All Programs > Apache HTTP Server 2.2.x > Configure Apache Server > Edit the Apache httpd.conf Configuration File). Add the following lines:

    LoadModule php5_module "C:\php\php5apache2_2.dll"
    AddType application/x-httpd-php .php
    AcceptPathInfo on
    PHPIniDir "C:\php"

    Look for the DirectoryIndex line. Add ” index.php” (no quotes) to the end of that line.

    Save the file.

13. Create a file named test.php in your Apache htdocs directory, containing this text: <?php phpinfo(); ?>
14. Reboot your machine.
15. Browse to http://localhost/test.php. You should see tabulated information about your working PHP installation.

Installing Apache under Windows XP was trivial. Not so, under Vista. Creation of the Apache service fails. The conf directory can’t be set up by the installer, probably due to permission problems.

I finally got it working with the following procedure. I used the latest version of Apache (2.2.4) and Windows Vista Home Premium.

1. Uninstall any previous installations of Apache Web server (Start > Control Panel > Programs and Features).
2. Turn off your firewall (Control Panel).
3. Stop User Account Control (UAC).
4. Get the most recent version of apache from http://httpd.apache.org/download.cgi and put it on your desktop. Rename it to apache.msi
5. Start > All Programs > Accessories
6. Right-Click “Command Prompt” and choose “Run as Administrator”
7. Manually remove directories containing previous apache installations (like C:\Program Files\Apache Software Foundation…)
8. Change to your desktop folder (At prompt type cd desktop)
9. Type “msiexec /i apache.msi” on the command prompt.
10. Run through the Apache installer. I’m running a development server, so I left the domain and computer name blank. Choose the default server on port 80 for all users option. Change the installation directory to c:\apache.
11. Reboot.
12. The little Apache feather won’t appear on the task bar under Vista with the present version of Apache (2.2.4). To remove the “error” box that says ‘the operation completed successfully” on startup, go to  All Programs > Startup,  and remove the Apache item there.
13. Browse to http://localhost. It should say “It works!” If it doesn’t, check your httpd.conf file by going to All Programs > Apache HTTP Server 2.2.x > Configure Apache Server > Test Configuration. Follow the directions for fixing the configuration file.
14. Turn your firewall back on. You can turn UAC back on too, if you like (mine is off, and it’s staying off!)