// Archives

How To’s

This category contains 11 posts

How to exclude your own traffic in Google Analytics

So you’ve got Google Analytics set up and you’re tracking your web site statistics. But every time you visit your web site (to do testing, training, etc.) your reports are skewed because they include traffic from your own computer. One way to fix this is to set a cookie on your computer with some predetermined […]

Some users and groups do not show up in the SBS Console

Problem If you do not create users and groups using the SBS Console, they will not show up in the SBS Console. If you create users and groups through another method, you can use this procedure to modify the users and groups so they show up in the SBS Console. Solution For Users: Open the […]

Mac printing to a non-Postscript printer

I have to admit I am not a Mac expert. I am a PC guy but I have learned a few things about Mac’s over the years. One of which is that Mac’s like to use Postscript as the default emulation method for printing. Unfortunately, not all printers support Postscript out of the box. In […]

How to override a single host on your Windows DNS Server

Situation 1. Your internal Active Directory domain name is different than your public Internet domain name. For example, your AD domain name might be contoso.local but your public Internet domain name might be contoso.com 2. You want to override a single host on contoso.com but your internal DNS server is not authoritative for that zone. […]

How to determine who is relaying mail through your Exchange server

Problem If you have relay access control properly configured, only authenticated users should be able to relay mail through your server. If you are still seeing messages being relayed, then it’s possible a user account has been compromised. This will allow you to see which users are relaying mail so you know which account has […]

How to use Classic ASP to connect to Access databases on SBS 2008

So here’s the scenario: I recently migrated from Small Business Server 2003 to SBS 2008. It was a fairly smooth transition except for one thing: There was a web application written in classic ASP that connected to an Access database. Problem #1: No 64-bit JET driver As you may know, SBS 2008 is required to […]

Dissecting and removing the SHV5 rootkit

Yesterday I noticed some odd behavior on one of the Linux servers that I maintain. For one thing, every time I would run ‘top’ or ‘ps’, I would see the following message Unknown Hz value! (75) Assume 100 I decided to run rkhunter to check for rootkits. Needless to say, I was disappointed to discover […]

How to backup your MySQL databases to separate files

I wanted to dump all my MySQL databases using the mysqldump utility, but I wanted each database to be in a separate file. I couldn’t find a solution online, so I wrote my own script. Here it is: #!/bin/sh USERNAME=admin PASSWORD=topsecret BACKUPDIR=/var/local/mysql-backups for i in $(mysql -u $USERNAME -p$PASSWORD -e “SHOW DATABASES;” –skip-column-names –batch) do […]

Remove Personal Antivirus in 3 easy steps

What is Personal Antivirus? Personal Antivirus sounds like a wonderful program that might be good to have, right? Actually, it’s just one of an increasingly common type of malware called a rogue anti-virus or rogue anti-spyware program. It appears to be harmless or even beneficial on the surface, but it’s actual goal is to scare […]

Blackberry purgatory

Blackberries. You gotta love em. They’re great when they work but sometimes it’s a challenge to get them setup properly. I must have taken at least three phone calls on Friday from clients who needed help getting their Blackberries setup with their corporate email accounts. Two of them were using BES (Blackberry Enterprise Server) and […]