Wednesday, May 31, 2006

Microsoft Outlook error 0x800CCC92

I get the following error when trying to retrieve e-mail from our POP3 Postfix mail server (on Solaris 5.8). We're also using Sendmail to interact with the PreciseMail spam filtering system:

Task 'mail.example.com - Sending and Receiving' reported error (0x800CCC92): 'Your e-mail server rejected your login. Verify your user name and password in your account properties. Under Tools, click E-mail accounts. The server responded: ??RR /usr/mail/.thomas.pop lock busy! Is another session active? (11)'

Basically, it indicates that the previous POP3 connection terminated in an unclean manner.

Links:
Telnet - POP Commands (retrieving mail using telnet)
POP lock busy

Looking at the contents of /usr/mail ("ls -la /usr/mail") you will see that there are at least one (and possibly multiple) .pop files in the directory (".username.pop").

Tuesday, May 30, 2006

Evaluation of new web hosting plans

Since my current web host is giving me the runaround about some firewall issues (I'm no longer able to use FTP PASV mode to publish to my site), I'm evaluating new hosting plans. My criteria are as follows:

$6-$12/mo
1GB of space
25GB of traffic
PostgreSQL support

The last item naturally leads me to look at PostgreSQL hosting providers for North America.

A 2 Web Hosting - Either the "Discount" or the "Small Biz" packages include oodles of disk space for a reasonable price. In addition, the Small Biz account would allow me to combine multiple domains into the same hosting account.

pgHoster - The plan that I would want is $15/mo, which is a pity because I'd love to pay a company that prominently promotes PostgreSQL.

VirtuosoNetSolutions - The basic package is ~$60/yr for 3GB/50GB or the eCommerce 5GB/100GB for ~$110/yr. Both packages allow additional domains to be hosted from the same account.

JTLnet - This looks like a good plan. The Linux '06 promo package is $10/mo for 2GB of space, 24GB of traffic, SFTP transfers.

Sunday, May 14, 2006

Microsoft Outlook Backup method

This is how I backup my PST files whenever I login to my laptop. Because I always have MSOutlook open, I find it difficult to get a good backup of the PST files.

1) You will want a copy of Info-Zip's ZIP and UNZIP executables.

2) Create a folder on your hard drive to hold these executables. I recommend creating a folder called "C:\bin" and adding that folder to your system's PATH statement.

Right-click on My Computer, Properties, Advanced, Environment Variables... Under System Variables, highlight "PATH" and click "Edit"... place C:\BIN at the start. It should look similar to "C:\bin;%SystemRoot%\system32;%SystemRoot%...". Make sure you leave the existing directories in the list and just add the "C:\bin;" at the start of the listing.

Place the zip.exe and unzip.exe files in the C:\BIN folder.

3) Locate your PST files. Create the following as a text file in the same directory. Name it as "backupemail.cmd".

@echo off
rem Backup my Outlook PST files

IF NOT EXIST "X:\EMailBackup\*" GOTO quit
IF NOT EXIST "C:\Data\EMail\*.pst" GOTO quit

C:
CD "\Data\EMail"
ZIP -u1 X:\EMailBackup\MyPSTs.zip *.pst

X:
CD \EMailBackup

IF EXIST MyPSTs-3.zip DEL MyPSTs-3.zip
IF EXIST MyPSTs-2.zip REN MyPSTs-2.zip MyPSTs-3.zip
IF EXIST MyPSTs-1.zip REN MyPSTs-1.zip MyPSTs-2.zip
IF EXIST MyPSTs.zip REN MyPSTs.zip MyPSTs-1.zip

:quit


Notes:

a) My PST files are stored in C:\Data\EMail. Anywhere that you see "C:\Data\EMail" you should replace with the folder name where your PST files are stored.

b) I backup my PST files to X:\EMailBackup. You will need to replace this path with the location where you keep your ZIP file backups.

c) This script keeps the past 3 backups by renaming them out of the way.

d) You must have at least one file in the X:\EMailBackup folder in order for the backup to run the first time. After that, the script will work properly.

e) If you find that ZIP is too slow, you may wish to change the "-u9" to "-u1" in order to get faster compression (but less compression).

f) I'm pretty sure the above script is foolproof and correct, but as always you should have a good backup before you attempt things like this.

4) Create a shortcut link to "backupemail.cmd" and place it in your Programs -> Startup folder. That way it will run as soon as you login.