Installing WordPress 2.9.2 on Windows Server 2003 using Microsoft's Web Platform Installer

  • March 12, 2010
  • James Skemp
I recently had need to install and test WordPress for some possible work. While I was tempted to go the Linux route, shortly after the OS was setup I decided to skip that and stick with Windows. Since Microsoft has released a platform that supposedly makes it easy to install Web-related applications, I decided to give it a try to determine just how simple it was. What follows is an overview of the setup process to install WordPress 2.

Read More

Ubuntu Quickie: MySQL and PostgreSQL passwords

  • June 23, 2007
  • James Skemp
Another Ubuntu Quickie, this time on the default passwords for MySQL and PostgreSQL. MySQL mysql -u root UPDATE mysql.user SET Password = OLD_PASSWORD(’password’) WHERE User = ‘root’; FLUSH PRIVILEGES; \q PostgreSQL sudo -u postgres psql template1 ALTER USER postgres WITH PASSWORD ‘password’; \q

Read More

Ubuntu Quickie: Installing MySQL and PostgreSQL

  • June 21, 2007
  • James Skemp
There was a couple of reasons for this. First, MySQL docs recommend it. Second, there's not that much that I really want to configure in SQL. So ... MySQL sudo apt-get install mysql-server At the time of this writing, this will install; libdbd-mysql-perl libdbi-perl libnet-daemon-perl libplrpc-perl mysql-client-5.0 mysql-server mysql-server-5.0 Suggested packages: dbishell libcompress-zlib-perl tinyca Recommended packages: mailx There's some official GUIs that you can also install: sudo apt-get install mysql-admin mysql-query-browser At the time of this writing, this will install;

Read More

The major failing of Akismet ...

  • February 25, 2007
  • James Skemp

The major failing of the Akismet plug-in is that you can't determine which IPs, if any, are spamming your site the most.

Read More

PHP Forum Software Showdown Part 6: phpBB

  • November 25, 2006
  • James Skemp
It's that time again. This time, we'll be looking at phpBB. “phpBB is a high powered, fully scalable, and highly customizable Open Source bulletin board package. phpBB has a user-friendly interface, simple and straightforward administration panel, and helpful FAQ. Based on the powerful PHP server language and your choice of MySQL, MS-SQL, PostgreSQL or Access/ODBC database servers, phpBB is the ideal free community solution for all web sites.” Lot's of features, so let's get to it.

Read More

PHP Forum Software Showdown Part 5: PunBB

  • November 24, 2006
  • James Skemp

Almost there. This time, we'll be looking at PunBB. First, I did donate to PunBB development some time ago. At the time, I liked PunBB, and received some great support. It's been sometime since that time, so I don't know how things stand.

Anywho, “PunBB is a fast and lightweight PHP-powered discussion board. It is released under the GNU General Public License. Its primary goals are to be faster, smaller and less graphically intensive as compared to other discussion boards. PunBB has fewer features than many other discussion boards, but is generally faster and outputs smaller, semantically correct XHTML-compliant pages.”

In this article, we'll be installing PunBB version 1.2.14, which is the latest version, as of October 15, 2006.

Read More

PHP Forum Software Showdown Part 4: MyBB

  • November 22, 2006
  • James Skemp

This time, we'll be looking at MyBB. “MyBB is a powerful, efficient and free forum package developed in PHP and MySQL. MyBB has been designed with the end users in mind, you and your subscribers. Full control over your discussion system is presented right at the tip of your fingers, from multiple styles and themes to the ultimate customisation of your forums using the template system.”

In this article, we'll be installing MyBB version 1.2.1, which is the latest version, as of September 27, 2006.

Read More

PHP Forum Software Showdown Part 3: Simple Machines

  • November 21, 2006
  • James Skemp

Curiously, in late-September 2006, Simple Machines Forum turned three (it had been three years since 1.0 beta 1). That's curious because the current stable version of Simple Machines is 1.0.9, and there's a 1.1 RC3 out as well (as of late-October 2006).

In this article, we'll be installing Simple Machines version 1.0.9, so we can compare it to the other PHP forums that we've installed, or will be installing.

Read More

PHP Forum Software Showdown Part 2: Vanilla

  • November 20, 2006
  • James Skemp

While the Vanilla forum's are fairly unknown, it's been around for a little over a year. “Vanilla is an open-source, standards-compliant, multi-lingual, fully extensible discussion forum for the web.” The version we'll be installing, 1.0.1, was released in late-August 2006.

Read More

PHP Forum Software Showdown Part 1: bbPress

  • November 19, 2006
  • James Skemp

A relative new-comer, bbPress “is forum software with a twist from the creators of WordPress”. The first public version, 0.72, was released in mid-October 2006, and the version we'll be installing, 0.73, was released a couple of weeks later. Downloading bbPress is fairly easy, since there's only two options – one for the installer in .zip, and one in .tar.gz.

Read More

Installing Apache 2.0.59 to a Windows-based computer, locally: Part 3

  • August 26, 2006
  • James Skemp
In Part 1 of this Apache 2.0.59 guide, we setup Apache 2.0.59 on a Windows XP SP2 machine. We also setup Perl and mod_perl, attempting to mimic our Apache 1.3.34 install. In Part 2 of this Apache 2.0.59 guide, we setup ColdFusion MX 6.1 and 7.0. This time, we'll be continuing in our quest by adding support for both PHP 4 and PHP 5. In previous guides, we installed PHP 4 and PHP 5, so if you need to install either one, do so with the above directions.

Read More

Installing MySQL Query Browser 1.1.20 on a local Windows-based, Apache, server

  • July 8, 2006
  • James Skemp

In a previous guide, we installed MySQL and the MySQL Administrator. In this guide, we'll be installing the MySQL Query Browser, version 1.1.20.

Read More

Upgrading phpMyAdmin (2.7.0-pl2 to 2.8.1) on a local, Windows-based, Apache server

  • June 20, 2006
  • James Skemp

In a previous post, we installed phpMyAdmin 2.7.0-pl2 to our local Web server. We did this so that we would have an easy way to administer our MySQL databases, from a PHP-based interface. This time, we'll be upgrading phpMyAdmin to version 2.8.1.

Read More

WP-ShortStat SQL queries

  • April 4, 2006
  • James Skemp
The wp-shortstat plugin, modified for WordPress 2.x use by Markus Kaemmerer, is a great little plugin. I've been using it since March 17, and since Markus has been doing a deal of updating (additional functionality, as well as bug fixes), I've been checking it on a regular basis (and have looked through the code more than once). However, since I started out by using 1.3, I've got a problem with old records skewing my stats.

Read More

Adding MySQL connectivity to ColdFusion MX on a local Windows-based, Apache, server

  • March 18, 2006
  • James Skemp
Until now, we've yet to setup a connection to MySQL from ColdFusion MX. This has meant that while we can do cool database things in PHP (like WordPress), we can't in ColdFusion. Until now. This time, we'll be setting up MySQL 4.1.18 and ColdFusion MX 6.1 on our local server. Because of some of the choices that we've made before, this installation is going to be fairly quick. Setting up MySQL database and user First, we'll need to setup a MySQL database and user for ColdFusion.

Read More

Upgrading (our local install of) WordPress

  • March 11, 2006
  • James Skemp

In a previous guide, we walked through installing WordPress on a local machine. This time, we'll be upgrading WordPress. For this guide, we'll be upgrading from WordPress 2.0.1 to 2.0.2. Note that this guide will work equally well for upgrading to 2.0.3, 2.0.4 or 2.0.5.

Read More

Setting up WordPress on a local Web server

  • February 28, 2006
  • James Skemp

Note: This guide should work equally well for WordPress 2.0.2 and above. For a guide on upgrading this 2.0.1 install, see Upgrading (our local install of) WordPress.

In our previous tutorials, we setup an Apache-based Web server, on a Windows XP home computer. The Web server is also running PHP and MySQL, as well as ColdFusion MX. This time, we'll be installing WordPress onto our local Web server. This installation will require us to work with both PHP and MySQL, and we'll be able to setup any number of WordPresses after we have completed this one.

Read More

A local, Apache Web server, on a Windows XP computer

  • February 27, 2006
  • James Skemp
My intention is to write a number of guides that will help someone build a functional Web server for testing purposes. Since Windows is fairly popular, I've decided to outline how to install Web server programs on it. Since Apache is both powerful and free, I've opted to use it as the core, instead of IIS, or the like. I also plan on keeping the various technologies up-to-date, yet continuing to provide the instructions for past versions used, just in case.

Read More

Installing MySQL Administrator on a local Windows-based, Apache, server

  • February 25, 2006
  • James Skemp
Last time, we successfully installed both MySQL and phpMyAdmin on our local server. However, we only had one user. This time, we'll be installing MySQL Administrator, to give us the ability to add administer MySQL in a way that we can't do with phpMyAdmin. Before we go, please note that the MySQL Administrator does not take away the value of phpMyAdmin. In fact, phpMyAdmin is usually how you'll be able to administer your MySQL databases in the real world.

Read More

Installing MySQL and phpMyAdmin on a local Windows-based, Apache, server

  • February 24, 2006
  • James Skemp
Note: This guide should work equally well for phpMyAdmin 2.8.1 and above. For a guide on upgrading this 2.7.0-pl2 install, see Upgrading phpMyAdmin (2.7.0-pl2 to 2.8.1) on a local, Windows-based, Apache server. MySQL will allow us to create databases on our local server. With PHP, this will allow us to install applications like the free WordPress, as well as number of open source content management systems, not to mention bulletin boards and the like.

Read More

PHP and MySQL work

  • December 23, 2005
  • James Skemp
I'm looking for ideas on what I can write in PHP and MySQL.  Thus far, I've written: 1) A comments system, that still gets hit by spam (but don't they all?). 2) An admin interface to upload documents, then create a record in a database for display elsewhere (along with categories and related articles/documents). I just don't know - what do I *need* for functionality?  Maybe I'll look further into creating a RSS reader - I just don't know .

Read More

Great PHP and MySQL tutorial

  • November 5, 2005
  • James Skemp

Read More