Fixing MySQL Error 1064 with PHPList when selecting new criteria

Today we had to fix a clients PHPlist. There was an error in their mysql select statement for whatever reason – whether it was their setup (they had some really weird group names and country names) or something with PHPList. Took us a while to figure it out, but as it turns out someone else [...]

How to fix your hackable SSH on Debian and Ubuntu Servers

If you’re running debian or ubuntu, your ssh keys are vulnerable. Follow these steps to regenerate them and secure your box back up.
apt-get update
apt-get upgrade
cd /etc/ssh/
rm ssh_host_dsa_key
rm ssh_host_dsa_key.pub
rm ssh_host_rsa_key
rm ssh_host_rsa_key.pub
ssh-keygen -t dsa (filename as /etc/ssh/ssh_host_dsa_key)
ssh-keygen -t rsa (filename as /etc/ssh/ssh_host_rsa_key)
/etc/init.d/ssh restart

Fix SMS Time Issues on Rogers/FIDO Unlocked GSM/3G Windows Mobile 5/6 SmartPhones/PocketPC’s

FIX: You need to add this to the registry: Go to HKEY_LOCAL_MACHINE\SOFTWARE\OEM\PhoneSetting\
Add a dword key “TrustTimeZoneField” and give it a dword value of 0
then soft reset your phone.
enjoy!

SBS 2003 Disable Sync of Certain Offline Files like .PST or .MDB

Today I was noticing that some clients on the network were experiencing errors when users logged out and windows synced for them.
In order to fix this, I had to do the following:

TS to SBS Server
Navigate to \\SBS\netlogon
Edit the SBS_LOGIN_SCRIPT.bat file in this directory. It should look like:
\\SBS\Clients\Setup\setup.exe /s SBS
Change it to this:
@echo off
rem ==================================================
rem
rem Title: [...]