Author Archives: Phil

Configuring Exim to use Gmail as a Smarthost

Posted on March 15, 2008 by Phil

Add a router before or instead of the dnslookup router: gmail_route:   driver = manualroute   transport = gmail_relay   route_list = * smtp.gmail.com Add a transport: gmail_relay:   driver = smtp   port = 587   hosts_require_auth = $host_address   hosts_require_tls = $host_address Add an authenticator … Continue reading →

Posted in Sysadmin | Tagged , , | 4 Comments

Truncating SQL Server Log Files

Posted on September 10, 2007 by Phil

SQL Server logs in a circular fashion to its transaction log files. To shrink a transaction log file it is first necessary to backup the log. The following script backs the log up, throwing away the backup in the process … Continue reading →

Posted in Sysadmin | Tagged | Leave a comment

Converting Active Directory Date Time Attributes

Posted on August 28, 2007 by Phil

To convert a date time attribute in Active Directory (e.g. as used by lastLogon) to a human readable date time, you can use the w32tm command. For example with the following LDAP record: dn: CN=John Smith,CN=Users,DC=DC=example,DC=com lastLogon: 128326919184182832 Running w32tm … Continue reading →

Posted in Sysadmin | Tagged , | 1 Comment