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
Posts By: jonny
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 »
MySQL Converting ISAM to MyISAM
Some old database tables needed to be converted. This can be done at the mysql command prompt with: ALTER TABLE tbl_name TYPE = MYISAM; Or using the script ‘mysql_convert_table_format’ which is located in the MySQL bin folder. Usage: ./mysql_convert_table_format test –user=root –password=secret be careful as InnoDB tables will also be converted to MyISAM.
Problem Adding Exchange Profile
Setting up the email account for Outlook results in the message: “The action cannot be completed. The connection to Microsoft Exchange is unavailable. Outlook must be online or connected to complete this action.” The server address I had used had an outdated certificate. I was able to add the account by providing the actual mailbox… Read more »
Converting Squid Timestamps
I found the following perl snippet here to convert a squid log file into one with readable times: #! /usr/bin/perl -ps/^\d+\.\d+/localtime $&/e; It can be used like this:./timeconvert.pl inputfile.txt > outputfile-withhumantime.txt
Reset Lost Joomla Password
To reset a lost Joomla admin user password log in to the MySQL database and set the password field in the jos_users table to: d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199 This will allow you to login as admin with a password of secret. Reset the password from within Joomla afterwards.
Spamassassin Upgrade to 3.2.4 Problem
We probably don’t have a straight-forward spamd configuration so there wasn’t much noise out there from other people suffering this same issue so i think it may be peculiar to us.I upgraded from spamassassin 3.2.3 to 3.2.4 but received the following error when starting the service: cannot use –sql-config without -u As we are using… Read more »
phpBB3 Lost Administrator Password
If the password for the admin user has been forgotten/lost/whatever.Register on the site as a new user but BEFORE logging in edit the MySQL database table phpbb_users and set the field user_type to 3 (i.e. founder).Then log in and visit the ACP.From the ACP normal user management can take place again.
