Tuesday
23/05/2007
11:06 pm
Posted in Diversions, Geekess, Software | 2 Comments »
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.
- Download and save phptriad r2.2 from the project pages at http://www.sourceforge.net/phptriad/ on SourceForge.
- Run phptriad2-2-1.exe.
- 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.
- Open your browser to
http://localhost/ and you’ll see the PhpTriad welcome screen. Great!
Download Subdreamer Light.
- 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
- 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.
- In directory
C:\apache\htdocs\subdreamer\includes\, make a copy of the file config.php.new. Rename this file config.php.
- Important! Check the properties of folder subdreamer and uncheck Read-only if it’s checked.
Configure a database for Subdreamer.
- From the start menu run
PHPTriad -> MySQL -> MYSQL-D-NT.
- When you point your browser to
http://localhost/phpmyadmin you’ll see the phpMyAdmin welcome page. It’s pretty much self-explanatory.
- Point your browser to
http://localhost/phpmyadmin and create a new database named sdcms.
- 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.
- Point your browser to
http://localhost/phpmyadmin and go to Users.
- 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.
- 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!
- Now delete the install directory and you’re ready to create your web site.
- 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.
Posted in Geekess, Koolaid Test Kitchen, Meta, Software | No Comments »
Thursday
20/13/2005
8:10 pm
I see from my access logs that someone found me by searching the web for “Missionaries and Cannibals”. So:
Missionaries & Cannibals. This is a bar game we used to play. The rules are simple, the solution isn’t, especially when you’re in Jay’s Elbow Room getting hammered.
The story is that there are three missionaries want to use a rowboat to cross a river with three newly-converted cannibal friends. There are six people but the boat only holds two, so they’ll have to row back and forth in singles and pairs.
However, there are two gotchas. First, although all three missionaries know how to row the boat, only one cannibal does. Second, if cannibals outnumber missionaries on either shore they will give in to temptation and eat the missionaries. Got that?
Great.
Start by drawing a couple of lines down the center of a placemat - this is the river. If there’s no placemat, draw on the table.
Now put three dimes on one side of the river. These are the three missionaries. And put two pennies and a nickel down with the quarters. These are the two cannibals who can’t row, and the one cannibal who can. [UK: use 5p, 2p and 10p. EU: you're on your own.]
Now move coins across the river and back in singles and pairs until all six are on the other side.

Click for solution.
Technorati:
Missionaries+and+Cannibals
Posted in Diversions, Software | No Comments »