Voder-Vocoder

The Log of Hal Canary

Navigation: Home | THE LOG | Log Archives | Resume | Contact Info | Public Key | SSL | Math Applets | Site Map | WP Backend | RSS2 | Atom

Archive for 2004-08

« Previous Entries

Best Headline Ever!

Hal Canary | Mindless Link Propagation | 2004-08-27 08:54:51 EDT
Permanent Link | Comments Off

Installing Wordpress with MySQL

Definitions:

Wordpress
WordPress is a state-of-the-art semantic personal publishing
platform with a focus on aesthetics, web standards, and
usability. Uses PHP and MySQL. Licenced under the GPL.
MySQL
The MySQL database server is the world’s most popular open
source database. It is released under the GPL.

In a properly configured Fedora/Redhat system you can install MySQL with yum. You’ll need atleast the following packages: mysql-server, mysql, and php-mysql, as well as php and httpd. Assuming that your web server is already set up and working with php.

$ sudo yum install mysql-server mysql php-mysql

(Restart httpd after installing php-mysql.) With a fresh install of mysql, you’ll need to start the server daemon and set things up.

$ sudo /sbin/service httpd restart
$ sudo /sbin/service mysqld start
$ sudo /sbin/chkconfig --level 35 mysqld on

The mysql “root” password is initially blank, so don’t worry and hit return if it prompts you:

$ mysqladmin -u root -p password 'pick_a_good_password'
$ mysql -u root -p
mysql> CREATE DATABASE wordpress;
mysql> GRANT ALL ON wordpress.*
       TO wordpress_user@localhost
       IDENTIFIED BY 'pick_another_good_password';

Now you are set. Write down that info:

    WORDPRESS INFO:
Database Name : wordpress
User Name     : wordpress_user
Password      : pick_another_good_password
Database Host : localhost
Table Prefix  : wp1_

Now, download the latest version from: http://wordpress.org/latest.tar.gz . Then as a user with write access to /var/www/html, do:

$ cd /var/www/html
$ wget -nv http://wordpress.org/latest.tar.gz
$ tar xzf latest.tar.gz

Then it should be as simple as pointing your browser to http://localhost/wordpress/wp-admin/install.php snd going from there.

UPDATE: 2004-08-27 How I installed Wordpress on halcanary.org.

Since I already had a MySQL database set up, I just had to choose a uniqe prefix. Movable Type tables use the prefix mt_. So I set my Wordpress prefix to wp1_. Here are the tables used by both programs, according to phpMyAdmin:

mt_author	wp1_categories
mt_blog		wp1_comments
mt_category	wp1_linkcategories
mt_comment	wp1_links
mt_entry	wp1_optiongroup_options
mt_ipbanlist	wp1_optiongroups
mt_log		wp1_options
mt_notification	wp1_optiontypes
mt_permission	wp1_optionvalues
mt_placement	wp1_post2cat
mt_plugindata	wp1_postmeta
mt_tbping	wp1_posts
mt_template	wp1_users
mt_templatemap
mt_trackback

I’m getting ahead of myself. Before I got that far, I unpacked the wordpress tarball locally, used a gui ftp program to recursivly copy over the directory. I renamed ~/public_html/wordpress/ to ~/public_html/wp/ for brevity’s sake. I then had to change the permission mode on that directory to 777 so that the install program could make the wp-config.php file. Then I made a ~/public_html/b/ directory and copied index.php from the wp/ directory there. This way my permlinks will be to http://halcanary.org/b/, and not to http://halcanary.org/wp/.

Then I browsed to http://halcanary/wp/ and did the setup.

Hal Canary | Computers & Code | 2004-08-24 21:42:49 EDT
Permanent Link | Comments Off

iptables traversal

Tuesday I went to Martin Brown’s talk on netfilter/iptables.
He provided this

very useful diagram of how it all works.

Hal Canary | Computers & Code | 2004-08-22 09:47:07 EDT
Permanent Link | Comments Off

Spam Armoring

See this for background. I am declaring a little victory here. The simplest spam-armoring possible has proved to be the most effective:

echo $EMAIL | sed 's/@/ at /g;s/\./ dot /g'

As long as that method is not over-used–or used in a predictable manner–it should be safe for a while.

Hal Canary | Computers & Code | 2004-08-20 14:56:58 EDT
Permanent Link | Comments Off

Fun with Gnome 2

These two commands set keybindings for horizonatally and vertically maximizing a window. Most of the time when you maximize, you only need one of the two dimentions to be bigger.

$ gconftool-2 --type string -s \
  /apps/metacity/window_keybindings/maximize_vertically \
  '<Ctrl><Alt>v'
$ gconftool-2 --type string -s \
  /apps/metacity/window_keybindings/maximize_horizontally \
  '<Ctrl><Alt>h'

Hal Canary | Computers & Code | 2004-08-20 12:20:44 EDT
Permanent Link | Comments Off

I hear that in this version

Hal Canary | Mindless Link Propagation | 2004-08-18 00:59:34 EDT
Permanent Link | Comments Off

Books for Sale

[book cover]
Goldstein

Herbert Goldstein. Classical Mechanics (2nd Edition) (1980).

almost new

$35.00

[book cover]
Reif

F. Reif. Fundamentals of Statistical and Thermal Physics (1965).

good condition

$45.00

contact me, Hal Canary, at hal at ups dot physics dot wisc dot edu, or at 608-347-5844.

Hal Canary | Books | 2004-08-17 18:19:17 EDT
Permanent Link | Comments Off

Charlie

My parents live in Southwest Florida. They had a hurricane last week. Here are exerpts from my mother’s account:

From: "Kathy Canary" <XXXXXXXX@XXXXXXXXX.XXX>
Date: Mon, 16 Aug 2004 06:51:58 -0400
To: "Win Canary" <XXX@XXX.XXXXXXX.XXXX.XXX>
Subject: Charlie

On Fri, Aug 13, 2004 at 03:03:52PM -0500, Hal Canary wrote:
> Are you going to be hit by the hurricane?  Keep me
> updated.

When you wrote this Dad and I were in his closet with
all our quilts and pillows, a twin mattress wedged
over us, Quicken backup disks, my jewelry, our
billfolds, glasses, and cell phones. etc.

...

Obviously our well built concrete houses hold up very
well under severe conditions.

...

90% of Lee County is without power.

...

The most wonderful thing happened yesterday about 5
pm. We got our power and phones back.

...

Photos from my father:

[Thumb]

[Thumb]
I think this is the house across the street.

[Thumb]
Dad’s office is across the street from this gas station.

Hal Canary | Life | 2004-08-16 08:48:57 EDT
Permanent Link | Comments Off

VHS?

In the last three years, I have rented maybe one movie on VHS. The only reason I keep my VHS player is to play my original-edition Star Wars trilogy (which will never be availible on DVD).

I’ve been striving to simplify my system. I’m getting close to the ideal:

[]

Gone are:

  • Tape deck
  • VHS (It can be plugged into the TV if I need it.)
  • DVD player
  • CD player

I would someday like to replace my big computer case with a tiny Shuttle computer, my CRT TV with either a LCD screen or a projector, and my amplifier with something smaller.

Hal Canary | Movies | 2004-08-15 20:24:07 EDT
Permanent Link | Comments Off

RAM these days.

Just did a reboot of my FC2 workstation, started a terminal emulator and a browser.

$ head -2 /proc/meminfo
MemTotal:      1035692 kB
MemFree:        686080 kB
$ echo $(( (1035692-686080)/1024 ))
341

Including buffers, the system takes 341 MB of RAM just to get going. And you can still buy desktops with 256 MB!

I must admit that Linux 2.6.x tends to be optimized more for lots of RAM, as compaired to 2.2.x or 2.4.x.

Actually, if I was going to recomend a desktop for those who take no pleasure in building thier own system, I’d say go with something like the HPQ SR1000Z. Take the slowest Athlon XP offered and 1GB of RAM. I think this is what I reccomended to my father a year ago, and I think he’s happy with that computer.

Hal Canary | Computers & Code | 2004-08-15 16:51:49 EDT
Permanent Link | Comments Off

Apple Pro Keyboard with Linux

I have a 109-key Apple Pro Keyboard. This is my current .Xmodmap file:

! xmodmap $HOME/.Xmodmap

!! Funny Apple Keys:
keycode 174 = F16
keycode 176 = F17
keycode 160 = F18
keycode 204 = F19

!! Why are these different on Apple Keyboard?
keycode 157 = KP_Equal
keycode 182 = Print
keycode 183 = Scroll_Lock
keycode 184 = Pause

!! Remove Caps_Lock
remove Lock = Caps_Lock
keycode 66 = F20

Hal Canary | Computers & Code | 2004-08-14 16:05:05 EDT
Permanent Link | Comments Off

Family Reunion

The family reunion: (link)


[Thumb]



[Thumb]



[Thumb]



[Thumb]



[Thumb]

Hal Canary | Photos | 2004-08-14 12:24:08 EDT
Permanent Link | Comments Off

« Previous Entries

Copyright 1997-2007 by Hal Canary.
mailto: h3 at halcanary dot org
xmpp:halcanary@jabber.org
aim:halwcanary
http://halcanary.org