Sysadmins of the North (Page 17)

Technical SysOps blog, where topics include Sysadmin, DevOps, computers, servers, web, MySQL, database, virtualization, optimization and security

Cache MySQL query results with PHP WinCache

Learn how to cache and store the MySQL query result in your web server RAM memory, utilizing PHP WinCache or OPcache

Calculate MySQL database size with PHP (off the old shelf)

Use PHP to calculate the size of MySQL databases.

Convert .htaccess to web.config

This post describes some of the IIS URL Rewrite Module web.config equivalents of commonly used Apache .htaccess settings. You'll learn how to translate .htaccess content to IIS web.config, this is useful when you need to migrate your website from Apache to Windows Server IIS.

PHP with WinCache on IIS

In this article you'll learn how to install and set up PHP with the Windows Cache Extension (WinCache) on windows IIS web servers. WinCache enabled PHP gives a great PHP performance boost for your WordPress-, Drupal or Joomla website. This post will show you it's not hard to set up high performance PHP hosting on IIS.

Remove ETags HTTP response header in IIS

Removing ETag response headers is not an easy task in Windows Server IIS web servers. Here I show you how to properly remove ETag HTTP response headers with an IIS Rewrite Module Outbound rewrite rule.

"The length of the URL for this request exceeds the configured maxUrlLength value"

The length of the URL for this request exceeds the configured maxUrlLength value is an IIS error telling you the length of the given URL exceeds a limit. The Windows Server IIS maximum URL length is defined by the `HttpRuntimeSection.MaxUrlLength` property. Its value is 260 characters. This may cause problems with longer than configured `maxUrlLength` URL's, and here is how to resolve this max URL length issue.

"htaccess files should not be used for security restrictions"

Acunetix' Bogdan Calin wrote an article explaining why .htaccess files should not be used to secure sensitive data

WordPress HyperDB is an advanced database class that supports replication

HyperDB is an advanced database class for WordPress that supports replication and partition of data. HyperDB is a replacement for the standard wpdb class.

Multiple IIS 6.0/7.5 Vulnerabilities

Multiple vulnerabilities found in IIS 6.0 and 7.5 web servers and reported to the Full-Disclosure mailinglist by Kingcope. I took some time to test the various vulnerablities.

How to filter web traffic with blocklists

Create your own HTTP web blocklist filter to block and filter unwanted web HTTP traffic with blocklists.

Microsoft Deployment Workbench: silent installation of various applications

Silently deploy applications through Windows Deployment Services (WDS) / Microsoft Deployment Workbench

Clean up WordPress post revisions

Every time you write or edit a WordPress post, WordPress saves the change as a post revision. As you might expect, this fills up your database with a huge amount of unneeded post revisions and information. This uses space which should be free space, the MySQL database becomes bloated. You can clean up these WordPress post revisions quite easily, you only need one (1) simple SQL statement.

"System.Web.HttpException (0x80004005): The URL-encoded form data is not valid." error after MS11-100

After applying MS11-100, an out-of-band security update for ASP.NET to mitigate an ASP.NET Denial of Service vulnerability, you may experience the errors comming from .NET web applications

How to use .htaccess files on Windows Server IIS

In this post I'll show you how to install Helicon Ape in Windows Server IIS and use .htaccess files in your website. Yes, expect a lot of .htaccess examples for IIS

Start all stopped application pools in IIS 6.0

Learn how to stop and start all application pools using VBScript and ADSI in Windows Server 2003 and IIS 6.0. Query IIS' Metabase for all AppPool objects and their .State property.