Welcome to Sysadmins of the North

A technical blog where topics include: computer, servers, web, sysadmin, databases, virtualization, optimization and security.

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 how to use .htaccess files for your website. Further this post describes some common uses of .htaccess files by PHP applications like WordPress, Joomla, Drupal or your own coded CMS, for example how to manage subdomains or redirect HTTP to HTTPS.

Umbraco logo blue

Umbraco CMS admin password reset

If you forgot your Umbraco admin password, use the following SQL query to reset your Umbraco admin password in SQL Server Management Studio (SSMS) or MySQL

MySQL query caching using PHP/Zend_Cache

By using the Cache.php PHP class of the Zend Framework, you can relatively easy cache MySQL query results to disk. This ensures faster consecutive results and speeds up execution. In this context, caching means: execute a MySQL query once and save the result in a temporary file. For every time that same query is executed, you can simply use the result stored in your disk cache file, as long as the database hasn’t changed. Often it is faster to save this on the web server than having it to redo the query every time.

Check IP address blacklist status in Bash

Bash script to check an IP address reputation status in several blacklists. I’ve added HttpBl as backlist and an API key is required for this list. Using this script in Bash you can quickly test if an IP address is blacklisted.

IIS 10 Module Mappings for *.php handler

PHP on IIS: No input file specified.

Here is how to resolve the no input file specified error with PHP and IIS. When you host your PHP website on Windows Server IIS, you may receive an “No input file specified” error message, when a HTTP request is made to non-existing .php files. When this happens you probably have no Request Restrictions configured in IIS’ PHP handler set