Wesley's Tool-Box

I was trying to create an MP4 video file that properly works with my PSP with a video encoding application for MacOS X called altShiiva. I think I found the right setting, so I'm writing them down before I forget.

A little hiccup this morning... I was updating some of the server components. To make sure I don't mess up anything next time I do this, I'll write down the procedures.

1. phpBB

Straightforward, actually. Go to phpBB downloads section, and get the latest 'Changed Files Only' version. Decompressing it will give you a bunch of 'version x to version y' zip files, with common files on their own.

[Related to: Use Mac as a Web Server]

Your Mac, which is also the webserver, is behind a router. You enter your website's domain name on your web browser. You cannot connect. You can still connect via your internal IP address, so the webserver is not down. What gives? Here's what might be happening.

[Related to: Use Mac as a Web Server]

Two issues may come up after installing s9y on the Mac.

1. Quicksearch Error

Attempt a search on the Quicksearch box and you may get this:

The search function did not work as expected. Notice for the administrator of this blog: This may happen because of missing index keys in your database. On MySQL systems your database user account needs to be privileged to execute this query:

CREATE FULLTEXT INDEX entry_idx on serendipity_entries (title,body,extended)

The specific error returned by the database was...

That's because the query was not run and the 'Fulltext Index' is not available. Time to pay Terminal a visit.

[Related to: Use Mac as a Web Server]

After setting up a domain name for your website, you might want to change the domain name setting for phpBB and s9y so you can administer them from anywhere.

phpBB

Login to phpBB and click Go to Administration Panel. Re-authenticate and you'll be at the admin page. Click Configuration under General Admin. The first setting should read Domain Name. Enter your domain name here instead of 127.0.0.1 or whatever IP address it had before. Scroll down and press Submit to complete.

s9y

Login via Blog Administration. On the admin page, click Configuration under Administration. Open up Path and find URL to blog. Enter http://domain_name/serendipity/ where domain_name is your domain name and serendipity is the folder where your s9y files are in.