Postfix logo

GNU/Linux

Last updated:

Delete all MAILER-DAEMON emails in Postfix queue

How to delete all MAILER-DAEMON emails from your Postfix queue, when it matches a sender or recipient email address condition. In Postfix, there are various similar commands to delete messages from the Postfix mail queue, based on the Message-ID and/or email address for example...

Microsoft Internet Information Services (IIS) logo

Windows Server

Last updated:

Hide the .php file extension with IIS URL Rewrite Module

Sometimes it's important to remove (or hide) the file extension of scripts you use. Security by obscurity might be that reason, if you don't want others to know what script language you are using for your website, or for static site hosts.

Web applications

Last updated:

Minify JavaScript, CSS and compress images

Minify JavaScript and CSS the easy and fast way, with YUI Compressor and UglifyJS on the Linux, macOS and Windows command line.

a rusted iron gate with a chain hanging from it

Codebase

Last updated:

Test SMTP authentication and StartTLS

Investigate SMTP authentication issues like a boss! When using TLS encrypted SMTP connections, it's always handy if you are able to create a SMTP logon credentials and test SMTP authentication over a TLS/StartTLS connection. Preferably from your command-prompt.

Microsoft Internet Information Services (IIS) logo

Windows Server

Last updated:

IIS Outbound Rules with gzip compression

Gzip compression conflicts with IIS Outbound Rules resulting in HTTP 500.52 URL Rewrite Module Error. Here is how to resolve this.

Security

Last updated:

prettyPhoto DOM based XSS

Uh-oh, a prettyPhoto DOM based XSS on Saotn.org... What it is, why it can be dangerous, and how to fix it in jquery.prettyPhoto.js.

High Performance MySQL

WordPress

Last updated:

Wp_options table autoload micro-optimization

The autoload feature loads and caches all autoloaded options, if available, or all options. The default option is to autoload, and over time when the wp_options table grows, this degrades performance. Today I noticed a slow MySQL query coming from a WordPress database (WordPress wp_options table). This made me investigate and to optimize the WordPress wp_options table “autoload” feature.

High Performance MySQL

Useful

Last updated:

Check, repair and optimize MySQL tables with mysqlcheck

MySQL's mysqlcheck is a command line table maintenance program: it checks, repairs, optimizes, or analyzes tables. Very handy for automated performance optimizations of MySQL databases and tables.

Codebase

Last updated:

Validate MIME types with PHP Fileinfo

How to check the file type in PHP and secure file uploads: validate MIME types with the PHP Fileinfo extension, not by file extension.

Codebase

Last updated:

Add (custom) headers to MailMessage class

The System.Net.Mail Namespace leaves out the required Message-ID header in email. Here is how you can add this important header to your email, to make sure email arrives.

WordPress logo

WordPress

Last updated:

Clean-up spam comments and meta data

Delete WordPress spam comments and meta data in your database, easily with phpMyAdmin or mysql cli. Keep your WordPress database lean & mean!

Umbraco

Last updated:

Configure SQLServer sessionState for Umbraco

Configure Umbraco for SQLServer sessionState storage and prepare Umbraco for high performance web garden or web farm, and load balancing environments. This post explains it all.