It's been awhile but tonight I booted up my parent's new machine and installed much of the software I said I was going to install in my previous post.

I am a bit concerned that the interface to Windows 7 is so significantly different from XP that my parents will be lost (at least for a short while). Since I don't run Windows I was very surprised at what looks like a fairly radical shift in some of the design (although there are some familiar elements). Hopefully the software I have chosen to place on their computer will just work. My confidence level (based entirely on past experience) is currently very low. I was hedging on purchasing a gotomypc.com subscription but I now think it wil be very useful. Especially for the short term. Once the machine is up and running at my parent's home I assume Dell support will be able to take over from there.

I'm looking for a replacement for awstats for processing my web logs. I'd also like this replacement to analyze my postfix logs and possibly some system-wide logs.

Awstats is a very nice tool, but it requires some modification to get it to work properly with more than one domain. Awstats can work with mail logs but I'm not terribly happy with the reports it generates (for mail or web). I'd like something with better reports. Granted I have yet to define what I mean by 'better'.

So far there are two candidates: surftrackr (formerly known as squidalyser) and lire. There are problems with both. Lire seems much more complicated than what I need for such a simple site as mine. Surftrackr isn't packaged by Ubuntu.

I suppose this means I really have no candidates at all. There must be a very simple log analysis tool that is easily available.

So the final Apache 1.3 has been released. Perhaps this will finally prompt companies to move on. I have yet to work for a company that did not use Apache 1.3 for its primary web products. Granted I am using a small sample size, but it is astonishing to me that I have never been paid to work on a product that uses Apache 2.x. When I started my current job they were still using Apache 1.3. Instead of moving to Apache 2.x for the rewrite of the product we decided to write our own webserver. So far its turned out pretty well, but, once again, Apache 2.x was not an option.

I will be doing some initial work on a computer I bought for my parents. My goal is to install only the software that they need and that that software be as unintrusive as possible.

I bought them a Dell computer with some pretty decent specs. At work I have been soliciting recommendations for essential software that meets the criteria I mentioned above.

SUPPORT: I may be purchasing a subscription to gotomypc. My intention is to use this subscription to provide technical support should they need it. Beyond that I got them the three year warranty that comes with Dell technical support.

ANTI-VIRUS: I was told that Microsoft Security Essentials was a very good, free product. It updates itself automatically and doesn't cripple the performance of the computer (which I gather some other anti-virus software does).

DEFRAGMENTATION: Apparently Windows 7 still runs on a filesystem that can easily become fragmented. I will be placing DeFraggler on the computer. Once again this is software that runs in the background and will do what is needed without bothering the user.

BACKUP: For backup I am still deciding between Mozy and carbonite.

PHOTO ORGANIZATION: I was running a Gallery2 installation on my VPS and used it to host my pictures and pictures my parents took. Initially I had wanted my entire extended family to use it, but that never really worked out. I finally realized that running this server was ridiculous considering all of the high quality (and free!) image hosting sites. I decided on Google's Picasa Web which is an on-line service that integrates well with their Picasa image organization software. It also supports Linux along with Windows.

Do you only have a non-Windows/DOS operating system installed on your computer? Do you want or need to flash your motherboard's BIOS? Then you should really read this.

All information contained in this post comes from the SSL FAQ.

Create RSA private key

openssl genrsa -des3 -out server.key 512|1024|2048
(openssl rsa -noout -text -in server.key)

Create Certificate Signing Request (CSR)

openssl req -new -key server.key -out server.csr
(openssl req -noout -text -in server.csr)

Create own Certificate of Authority (CA) key

openssl genrsa -des3 -out ca.key 512|1024|2048
(openssl rsa -noout -text -in ca.key)

Create self-signed CA certificate

openssl req -new -x509 -days 3650 -key ca.key -out ca.crt
(openssl x509 -noout -text -in ca.crt)

Sign the server CSR and create a server certificate

openssl x509 -req -in server.csr -out server.crt -CA ca.cert -CAkey ca.key -CAcreateserial -days 3650

(Optional) Remove pass-phrase dialog (useful for Apache)

cp server.key server.key.org openssl rsa -in server.key.org -out server.key chmod 400 server.key

Buying a valid certificate

Follow the first two steps above Go to Instant SSL and order cert
(optional) Perform the last step once certificate received