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

Reference: PostgreSQL 8.2 commands on Ubuntu

• June 23, 2007
• James Skemp

Below are the PostgreSQL 8.2 commands on Ubuntu.

Read More

Ubuntu Quickie: Installing MySQL and PostgreSQL

• June 21, 2007
• James Skemp

For SQL on Ubuntu Linux, I decided it was easiest to just use the repositories to just install MySQL and PostgreSQL.

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

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

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

• March 19, 2006
• James Skemp

Having already added MySQL support for ColdFusion MX, it's time to look at adding PostgreSQL. For many of the same reasons we installed PostgreSQL with PHP, we'll be doing this to add to our potential resources. However, unlike our connection of MySQL with ColdFusion MX, we'll need to install some additional features to ColdFusion MX. (This guide assumes you've already installed PostgreSQL.) Downloading and installing the JDBC Driver The first thing we'll need to do is install a special driver for ColdFusion.

Read More

Installing PostgreSQL on a local Windows-based, Apache, server

• March 15, 2006
• James Skemp

While we've already setup MySQL, another popular SQL server is PostgreSQL. Like MySQL, PostgreSQL is absolutely free, and will allow us to create databases on our local server. Downloading PostgreSQL We'll be downloading the most current version of PostgreSQL, which is 8.1.3 at the time of this writing. You can download the installation file from http://www.postgresql.org/ftp/win32. We'll want to download the regular zip file, called postgresql-8.1.3-1.zip, and weighing in at 21 MB.

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