Sysadmins of the North

Technical blog, where topics include: computer, server, web, sysadmin, MySQL, database, virtualization, optimization and security

Page 19 of 19

Clean up WordPress post revisions

Delete WordPress post revisions, turn them off and speed up your WordPress blog. Everytime 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 SQL statement: …

Continue reading

How to use .htaccess files on Windows Server IIS

Learn how to use .htaccess in Windows Server IIS. In this post I’ll provide you with some useful .htaccess URL rewrite examples. URL rewrite examples that you can use on Window Server IIS for your website.

Continue reading

Umbraco CMS admin password reset

Umbraco admin password reset: When you’ve forgotten your Umbraco admin password, use the following SQL query to reset your password for Umbraco:

Continue reading

MySQL query caching using PHP/Zend_Cache

When there is no MySQL query_cache available

Using the Cache.php PHP class of the Zend Framework, it is relatively easy to cache and save MySQL query results on disk. This 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 in your cache text file, as long as the database hasn’t changed. Often this is easier on the web server than having it to redo the query every time.

Continue reading

Failed Request Tracing error LOG FILE MAX SIZE TRUNCATE

As you’ve probably read in my post AppCmd introduction and examples, AppCmd is a very extensive tool to administer Windows Server IIS hosting environments. Therefore, now a bit more about a common error message you might get using Failed Request Tracing: LOG_FILE_MAX_SIZE_TRUNCATE.

Continue reading

Project Honey Pot

Project Honey Pot is the first and only distributed system for identifying spammers and the spambots they use to scrape addresses from your website.

Continue reading

Check IP address blacklist status in Bash

Here is a Linux Bash shell script to check whether an IP address is listed in a DNSBL blacklist, or RBL. This is a modified version of a by J65nko posted 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.

Continue reading

PHP on IIS 7.5/8.0: No input file specified.

If you receive an No input file specified, for an HTTP request made a non-existing .PHP file, then there are no Request Restrictions configured in IIS’ PHP handler settings. Here is how to resolve this no input file specified error in IIS for PHP…

Continue reading

“Forensic Log Parsing with Microsoft’s LogParser”

Just stumbled upon: Forensic Log Parsing with Microsoft’s LogParser.
Continue reading

7 Snippets to use .htaccess as a Web Application Firewall

.htaccess to secure your website

In this post I’ll show you a couple of snippets – e.g parts of .htaccess files – on how to use it as a kind of Web Application Firewall (WAF). You can use these snippets to block out exploit- and rogue HTTP requests, to secure your website.

Continue reading

[C&C] Devotion to duty

C&C: “Cats and coffee“, sysadmin devoted to his duty.

(source: xkcd.org)

Newer posts »
12 queries, 0.130 seconds running PHP version 7.2.9