Posted inWindows Server
Hugo development environment in WSL 2
How to set up Hugo and an static website in an not-so-standard (but fun) development environment? In WSL 2 on Windows 11/10 of course.
About Me
— My story A passionate blogger and photographer from London. Add more information about yourself. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent pharetra sollicitudin sem eget vestibulum. Phasellus mollis id nibh vitae dignissim. Maecenas vitae eros tincidunt, laoreet tellus in, interdum eros. Interdum et malesuada fames ac ante…
Posted inWeb application security
Disallow direct access to PHP files in wp-content/uploads/
It's recommended to disallow access to and execution of PHP files in wp-content/uploads folder. Preferably without the use of a security plugin. Blocking access to PHP files in WordPress wp-content/uploads folder is easily achieved with a .htaccess file on Linux Apache, or web.config accesssPolicy in Windows Server IIS, and here is how. Secure your WordPress site with this simple, yet effective, tip!
Posted inWordPress
Delete spam comments after three (3) days
Here is how to change Akismet interval to three (3) days instead of 15 days for deleting spam comments, using the akismet_delete_comment_interval filter in your WordPress functions.php
Posted inWordPress
Reduce Wordfence CPU usage, disable Wordfence “Live Traffic View”
Reduce Wordfence and WordPress CPU usage by checking settings and disabling Live Traffic View. This'll improve the performance and speed of your WordPress website.
Posted inCode base
How to use SSL in PHP Data Objects (PDO) mysql
Connect securely to your MySQL database using PHP Data Objects (PDO) and SSL/TLS; Here is how to connect to MySQL with PHP PDO using an SSL encrypted connection.
Posted inCode base
Fatal error: Uncaught Error: [] operator not supported for strings – PHP 7.1
With PHP 7.1, some PHP web applications fail because of deprecated code usage. This may result in an error message like [] operator not supported for strings for various Joomla, WordPress and Drupal components. Here's how to fix this code for PHP 7.1+.
Posted inMySQL
Restore single MySQL table from a full mysqldump backup file
Here are the steps required to restore a single MySQL table from a full mysqldump database backup file on the command-line. If you need to restore a single table from a full MySQL backup, you may find yourself wondering "how do I do that?". There are a few steps required, I outline them here for you to restore the contents of just one table back into the database from the mysqldump using Bash.
Posted inWordPress
Remove Jetpack email sharing service
Recently the WordPress Jetpack email sharing service is often abused by spammers. They use the Send to Email Address for sending spam. All these kind of "Tell a Friend" scripts are abused a lot. Here is how to disable email share service in Jetpack.
Posted inWindows Server
Enable NTFS long paths GPO in Windows Server 2022, 2019 and Windows Server 2016
With Windows Server 2016 released, we can finally lift the idiotic 260 characters limitation for NTFS paths. In this post I'll show you how to configure the "Enable Win32 long paths" Group Policy, and how to make the "LongPathsEnabled" change in the Windows registry. The NTFS long paths GPO is also still required for Windows Server 2022 and 2019.
Posted inWordPress
The WinCache effect: Save with object caching
WinCache, or Windows Cache Extension for PHP, is a PHP accelerator that is used to significantly increase the speed of PHP applications running on Windows Server IIS. Besides increasing the speed of PHP applications, WinCache decreases CPU usage making it a win win situation extension.
Posted inMySQL
MySQL InnoDB performance improvement: InnoDB buffer pool instances – Updated!
Are you running into MySQL load problems? Learn how to optimize MySQL InnoDB Buffer Pool for a heavy InnoDB workload by configuring innodb_buffer_pool_instances and increasing read/write I/O threads. Dividing the InnoDB buffer pool into multiple instances can improve Disk I/O. By doing so, you run your database more efficiently and faster. Here is a little help for you.
Posted inMySQL
MySQL DoS in the Procedure Analyse Function – CVE-2015-4870
Sri Lankan Security researcher Osanda Malith discovered a DoS -or crash- vulnerability in MySQL's Procedure Analyse Function. The vulnerability crashes MySQL versions up to 5.5.45.
Posted inWindows Server
HackRepair.com’s Bad Bots .htaccess in web.config for IIS
Block bad bots in WIndows Server IIS using web.config. Learn to protect your WordPress website with this web.config file!
Posted inGNU Linux
Recursive scp and symlinks
Recursive scp without following symbolic links. When using recursive scp, symbolic links aren't preserved and are copied as if they are normal directories. So you have to look for another solution to recursively transfer symlinks over ssh. Here is one: Tar over ssh!