Posts By: jonny

MySQL Old Passwords

We had a application using version 4 libraries of MySQL to talk to a MySQL 5 database which reported:<br /> Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client The temporary solution: SET PASSWORD FOR ‘some_user’@’some_host’ = OLD_PASSWORD(‘newpwd’);

Checking for Updates on Ubuntu

On Ubuntu/Debian servers install apticron with: apt-get install apticron This will run a daily job and send an email with available updates. The email address can be amended in /etc/apitcron/apticron.conf Quick, easy and useful!

Ubuntu Ibex (8.10), Opera and Flash

Opera is a great browser – magic wand, mouse gestures and less memory hungry than Firefox. It’s also pretty good on the Wii. Install the .deb from www.opera.com/download Then to get flash working: sudo ln -s /usr/lib/flashplugin-nonfree/libflashplayer.so /usr/lib/opera/plugins/libflashplayer.so

Plesk SSL Certificates from Comodo

Trying a free SSL cert from Comodo and had some difficulties with an error message: The CA certificate does not sign the certificate So downloaded the following CA bundle:https://support.comodo.com/index.php?_m=downloads&_a=viewdownload&downloaditemid=77and used that instead of the one supplied in the email and the certificate was accepted.The install instructions here explain the process for Plesk. If using a… Read more »

Sophie make problems

I had a few stumbles when setting up Sophie, so for future reference: v3.05 checking for DllGetClassObject in -lsavi… noHave you downloaded the correct version of Sophos? There are a few versions available (AMD64 etc) v3.0 checking for SAVIsweepFile in -lsavi… noHave you downloaded the latest version of Sophie Sophie will not make on AMD64I… Read more »

Sophie Sweep finds virus but Sophie does not

I found that the sweep command would show a file as a virus yet some of these files were still getting through our mail system past Sophie. There wasn’t much on the web describing this problem so I am posting here for future reference. In the sophie.savi configuration file change GrpSuper: 0 to GrpSuper: 1

Outlook messages stuck in Outbox

Slight problem today with emails stuck in users’ outboxes in Outlook and for OWA users their messages were moving to the Drafts folder without being sent. Problem was that a few services on the server hadn’t started automatically after an update. Starting the services again seems to have solved the problem.

Removing Old IIS Logs

Simple powershell script to remove old IIS logs (or any other file for that matter). $pathToLogs = “C:\WINDOWS\system32\LogFiles\W3SVC1”;$LogAgeTarget = 183; # Number of days of logs to keep$dteNow = Get-Date     if (Test-Path $pathToLogs){      $LastWrite = $Now.AddDays(-$LogAgeTarget)      $Files = Get-ChildItem $pathToLogs -include *.log -recurse |            Where {$_.LastWriteTime -le “$LastWrite”}      … Read more »

Swap Space Labels

A few issues today with a machine that had been left to boot with its swap space on the SAN. So I wanted to tell the machine to use the swap space on the local disk so I could refer to it in /etc/fstab by its label. So I tried: e2label /dev/sdf3 SWAP-local which didn’t… Read more »