Into the Void

Flush with my recent success running Tiki Wiki under Windows XP SP2, I thought it might be fun to try Subdreamer, too. Subdreamer is a Content Management System and is different from a Wiki mainly in the way it organizes and presents data. Subdreamer has the advantage of allowing me to integrate my phpBB forum into it so that my current users have the same user id and password on the new CMS.
In case anyone else wants to smear Linux web apps all over their harddrive, it’s not very hard to do. In this article I’ll walk you through the four main tasks required to evaluate the Subdreamer CMS on a Windows XP box.
You will be using an application called PhpTriad. PhpTriad contains Windows versions of the ubiquitous Apache server with PHP support, MySQL database software, and phpMyadmin. You’ll have no trouble at all getting PhpTriad running.
Next you’ll get the free version of Subdreamer and unzip it onto your hard drive. If you want more functionality when you take your CMS on-line you can buy the full version later.
Then you’ll run the MySQL software and use phpmyadmin to set up the MySql database where the Subdreamer CMS will store the contents of your web site.
Finally, you’ll open the Subdreamer installation file in your browser, work a little magic, and there you’ll be. It’s a little tricky, but I’ve made the mistakes several times so I’ll try to point out the gotchas before you make them.

Ok, let’s do it.

Download and install PhpTriad.

1. Download and save phptriad r2.2 from the project pages at http://www.sourceforge.net/phptriad/ on SourceForge.
2. Run phptriad2-2-1.exe.
3. When the install is done, run PHPTriad -> Apache Console -> Start Apache from the start menu like any other Windows app. A command window named “Start
   Apache” opens. Minimize the Apache window, but don’t exit the program. Apache is now listening on port 80 for browser requests.
4. Open your browser to http://localhost/ and you’ll see the PhpTriad welcome screen. Great!

Download Subdreamer Light.

1. Register on the Subdreamer site at http://www.subdreamer.com/, then log in. Go to http://www.subdreamer.com/light/, download the Subdreamer Light .zip file
2. Extract it into C:\apache\htdocs\. This will create directory C:\apache\htdocs\Subdreamer_Light_2202. Go into this directory, find the directory named upload and move it up to C:\apache\htdocs.
3. In directory C:\apache\htdocs\subdreamer\includes\, make a copy of the file config.php.new. Rename this file config.php.
4. Important! Check the properties of folder subdreamer and uncheck Read-only if it’s checked.

Configure a database for Subdreamer.

1. From the start menu run PHPTriad -> MySQL -> MYSQL-D-NT.
2. When you point your browser to http://localhost/phpmyadmin you’ll see the phpMyAdmin welcome page. It’s pretty much self-explanatory.
3. Point your browser to http://localhost/phpmyadmin and create a new database named sdcms.
4. Point your browser to http://localhost/phpmyadmin and Reload MySQL. It is very important to reload the SQL by revisiting http://localhost/phpmyadmin after every command, so check that out if things don’t work.
5. Point your browser to http://localhost/phpmyadmin and go to Users.
6. Select database scms in the pulldown menu Check Database Privileges. Now add a new user sdadmin and with password sdpasswd. Give the user all privileges. Don’t forget to write down that password!

Install Subdreamer Light.

1. Run the Subdreamer installer by pointing your browser to http://localhost/subdreamer/install/install.php. Fill in the requested data:
      Database server hostname: localhost
   Database name: sdcms
   Database username: sduser
   Database password: sdpw
   Table Prefix: sd_
   Username: admin
   Password: changeme
   Confirm Password: changeme
   Email: you@your.com
   When you click “Install Subdreamer” it should take you to the “Installation Successfull!” page. Hooray!
2. Now delete the install directory and you’re ready to create your web site.
3. Go to the subdreamer admin panel at http://localhost/subdreamer/admin/ and log in as user admin with password changeme. You will be prompted (via a pink error message) to enter the full URL for your Subdreamer installation. It is http://localhost/subdreamer/

And that’s it! Experiment with settings, post entries, create and delete users. Subdreamer is suitable for a small to medium website, and that is why it is so easy to use. If you like Subdreamer, by all means buy the full version.
Just remember to periodically export the sdcms database via http://localhost/phpmyadmin. Not only does it protect your data from late-night errors, and there will be errors, but when you decide to go live with Subdreamer you can reuse your local data on-line. Your web host will likely also use phpMyAdmin and you can follow the same steps to create the database, and then import the file.