Hello world!

This is the first post in the new WordPress enabled view of Phydeaux’ Deauxmayne.

The old content is still here, although it’s formatted differently, and some of the “features” don’t work yet — gas prices, photos of the day, etc.

If you have the genealogy site bookmarked, it will still work. Otherwise, you can hit it here. I suspect that leaving comments will no longer work on that site though, as it has not been converted to WP yet.

What follows are the installation notes I made as I created this new WordPress site!

The first thing I did was download, gunzip, untar WordPress 1.2, and looked at the readme.html file. When I checked the System Recommendations:

  • PHP version 4.1 or higher:

    mail:/home/colin/wordpress # php --version
    PHP 4.3.3 (cgi) (built: Sep 24 2003 00:41:05)
    Copyright (c) 1997-2003 The PHP Group
    Zend Engine v1.3.0, Copyright (c) 1998-2003 Zend Technologies

  • MySQL version 3.23.23 or higher:

    mail:/home/colin/wordpress # mysql --version
    mysql  Ver 12.21 Distrib 4.0.15, for suse-linux (i686)

  • a link to http://wordpress.org on my site…. I’ll handle this one later! 🙂

Looks like prereqs are met.

I starting looking at wp-config-sample.php for the appropriate database connection detail changes…. and realized I’ve never used MySQL on my server. I’m not really a database guy, so it never ocurred to me to get it working.

I had already selected installation of PHP and MySQL when I installed SuSE 9 Pro, so I figured I was most of the way there. I got my O’Reilly MySQL & mSQL book off the shelf and started poking around.

However, MySQL wasn’t running:

colin@mail:~/wordpress> mysqladmin status
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

Did some Google searches, and found http://www.novell.com/coolsolutions/nnlsmag/features/a_amp_linux_nls.html which inspired me to look in YaST to get MySQL running, and get it in the boot sequence of the server. (More good info on this and other topics is at http://www.topology.org/linux/mysql.html)

Opened YaST. Clicked “System” (on left). Clicked “Runlevel Editor” (on right). Clicked “Expert Mode” (top). Scrolled, and selected “mysql”. Clicked “Set/Reset” dropdown (lower-right), chose “Enable the Service”. (This picked the right runlevels for me.) Clicked “Start/Stop/Refresh” dropdown (lower-left), chose “Start now”. Got a popup with the following info:

/etc/init.d/mysql start returned 0 (success):
Creating MySQL privilege database and starting MySQL...
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
040707  8:24:57  /usr/sbin/mysqld: Shutdown Complete

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h mail password 'new-password' See the manual for more instructions.
You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; perl run-all-tests
Please report any problems with the /usr/bin/mysqlbug script!
The latest information about MySQL is available on the web at http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

Clicked “Finish” (lower-right).

And it appears that it was running now:

colin@mail:~/wordpress> mysqladmin status
Uptime: 23  Threads: 1  Questions: 2  Slow queries: 0  Opens: 6  Flush tables: 1  Open tables: 0  Queries per second avg: 0.087

Per the popup (and a copy of MySQL & mSQL from O’Reilly), I changed the root password for MySQL with:

/usr/bin/mysqladmin -u root password 'new-password'

I was now ready to continue the 5-minute install from the readme.html file in the WordPress distro.

I made the changes (as best as I could guess them) for the MySQL settings, saved, and tried to launch the install.php page. It appears, however, that I don’t have Apache set up to serve php pages. Blecch.

Decided to upgrade to Apache 2.0.50 from 2.0.48 — I needed to do this anyway. So…

(Good info for apache+php at http://php.us.themoes.org/manual/en/installapache2.php)

Downloaded, gunzipped, untarred.

./configure --prefix=/www/apache/2.0.50 --with-port=81 --enable-mods-shared=all
make install

Decided to create custom configged php, so downloaded 4.3.7

./configure --with-apxs2=/www/apache/current/bin/apxs --with-mysql
make install
cp php.ini-dist /usr/local/lib/php.ini

Modified httpd.conf (per themoes.org) — LoadModule for php4_module was already there. Added AddType for php, phtml, phps.

Put simple test script in htdocs. Restarted apache. Hit test script — it worked!!!!

Moved all Apache custom configuration items from 2.0.48 to 2.0.50’s httpd.conf. Restarted…. success!

So, theoretically, I now have MySQL, Apache 2.0.50 and PHP 4.3.7 running alongside my existing MovableType installation and other server things I run.

I hit the install.php script, and it responded…. but I didn’t have the database stuff set up. I used MySQLCC to create the database and user, and aligned them with the info I put in wp-config.php.

I hit the install.php script again, and got a pretty WordPress welcome screen! I let the pages lead me through the configuration. I had to change the web address of the installation, as it was defaulting to the localhost name, rather than the public name.

Next, I changed where the public name was pointing (away from the MT install, and to the WP install). I also had to add index.php to my DirectoryIndex line in httpd.conf.

Phydeaux’ Deauxmayne was now live on WordPress!

All together, about three hours work (off and on) to get to this point. The biggest boggles were solved by getting clean Apache and PHP installations, and by actually creating the database before trying to hit it! 🙂