Brian Nelson Ramblings - User contributions [en]

Bash Script to Enable Under-Attack in Cloudflare

2026-03-20T01:36:21Z

Brian: Created page with "==Bash Script to Monitor PHP Process and Enable Under Attack Mode in Cloudflare== Does your domain hit max_children often due to high attacks from bots/scrapers? Did you kno..."

==Bash Script to Monitor PHP Process and Enable Under Attack Mode in Cloudflare==

Does your domain hit max_children often due to high attacks from bots/scrapers?

Did you know you can enable under-attack via the api?

===API Enable Under-Attack Mode via Cloudflare===

#!/usr/bin/env bash
#
# cf-phpfpm-attack-toggle.sh
# Toggle Cloudflare Under Attack mode based on PHP-FPM max_children usage.

### CONFIG #########################################################

# Cloudflare
CF_API_TOKEN="[Input your API Token]"
CF_DOMAIN="[Input your Domain]" # your domain
CF_NORMAL_LEVEL="medium" # normal security level
CF_ATTACK_LEVEL="under_attack" # attack mode level

# PHP-FPM
PHP_FPM_POOL_CONF="[Input Pool Config Location]" # adjust for your distro
PHP_FPM_PROCESS_NAME="php-fpm" # e.g. php-fpm, php-fpm82, php-fpm8.2
PHP_USER="[Input your user]"

# Thresholds
HIGH_USAGE_PCT=90 # enable Under Attack if >= this % of max_children in use
LOW_USAGE_PCT=50 # disable Under Attack if <= this % of max_children in use

# State file to avoid flapping
STATE_FILE="/var/run/cf_under_attack.state"

####################################################################

set -euo pipefail

log() {
echo "[$(date -Is)] $*"
}

get_zone_id() {
curl -s -X GET "https://api.cloudflare.com/client/v4/zones?name=${CF_DOMAIN}" \
-H "Authorization: Bearer ${CF_API_TOKEN}" \
-H "Content-Type: application/json" \
| jq -r '.result[0].id'
}

get_cf_security_level() {
local zone_id="$1"
curl -s -X GET "https://api.cloudflare.com/client/v4/zones/${zone_id}/settings/security_level" \
-H "Authorization: Bearer ${CF_API_TOKEN}" \
-H "Content-Type: application/json" \
| jq -r '.result.value'
}

set_cf_security_level() {
local zone_id="$1"
local level="$2"
curl -s -X PATCH "https://api.cloudflare.com/client/v4/zones/${zone_id}/settings/security_level" \
-H "Authorization: Bearer ${CF_API_TOKEN}" \
-H "Content-Type: application/json" \
--data "{\"value\":\"${level}\"}" \
| jq -r '.success'
}

get_max_children() {
# reads first pm.max_children in pool conf
awk -F'=' '/^[[:space:]]*pm\.max_children[[:space:]]*=/ {gsub(/[[:space:]]/, "", $2); print $2; exit}' \
"${PHP_FPM_POOL_CONF}"
}

get_current_children_count() {
# count running php-fpm workers (exclude master)
# ps -o cmd= -C "${PHP_FPM_PROCESS_NAME}" 2>/dev/null | grep "sitesent" | wc -l
local count
count=$(ps -o cmd= -C "${PHP_FPM_PROCESS_NAME}" 2>/dev/null | grep "${PHP_USER}" | wc -l)
#Fix for math bug of if no process 0 are active
echo $(( count + 1 ))
}

get_state() {
if [[ -f "${STATE_FILE}" ]]; then
cat "${STATE_FILE}"
else
echo "normal"
fi
}

set_state() {
echo "$1" > "${STATE_FILE}"
}

main() {
# Get PHP-FPM usage
local max_children
max_children=$(get_max_children || echo 0)
if [[ "${max_children}" -le 0 ]]; then
log "ERROR: Could not determine pm.max_children from ${PHP_FPM_POOL_CONF}"
exit 1
fi

local current_children
current_children=$(get_current_children_count)

local usage_pct
usage_pct=$(( current_children * 100 / max_children ))

log "PHP-FPM: ${current_children}/${max_children} children (${usage_pct}%)"

# Get Cloudflare zone and current level
local zone_id
zone_id=$(get_zone_id)
if [[ -z "${zone_id}" || "${zone_id}" == "null" ]]; then
log "ERROR: Unable to determine Cloudflare zone ID for ${CF_DOMAIN}"
exit 1
fi

local current_level
current_level=$(get_cf_security_level "${zone_id}")
log "Cloudflare security level: ${current_level}"

local state
state=$(get_state)
log "Current state flag: ${state}"

# Logic:
# - If usage >= HIGH_USAGE_PCT and not already under attack -> enable
# - If usage <= LOW_USAGE_PCT and currently under attack -> disable

if (( usage_pct >= HIGH_USAGE_PCT )) && [[ "${state}" != "attack" ]]; then
log "High PHP-FPM usage (>= ${HIGH_USAGE_PCT}%). Enabling Under Attack mode..."
if [[ "${current_level}" != "${CF_ATTACK_LEVEL}" ]]; then
local ok
ok=$(set_cf_security_level "${zone_id}" "${CF_ATTACK_LEVEL}")
if [[ "${ok}" == "true" ]]; then
log "Cloudflare set to ${CF_ATTACK_LEVEL}"
set_state "attack"
else
log "ERROR: Failed to enable Under Attack mode"
fi
else
log "Cloudflare already in ${CF_ATTACK_LEVEL} level."
set_state "attack"
fi

elif (( usage_pct <= LOW_USAGE_PCT )) && [[ "${state}" == "attack" ]]; then
log "PHP-FPM usage low (<= ${LOW_USAGE_PCT}%). Disabling Under Attack mode..."
if [[ "${current_level}" != "${CF_NORMAL_LEVEL}" ]]; then
local ok
ok=$(set_cf_security_level "${zone_id}" "${CF_NORMAL_LEVEL}")
if [[ "${ok}" == "true" ]]; then
log "Cloudflare set to ${CF_NORMAL_LEVEL}"
set_state "normal"
else
log "ERROR: Failed to disable Under Attack mode"
fi
else
log "Cloudflare already at normal level (${CF_NORMAL_LEVEL})."
set_state "normal"
fi

else
log "No change to Cloudflare mode (usage: ${usage_pct}%, state: ${state})."
fi
}

main "$@"

===Setup Cron to Auto Enable/Disable Under-Attack Mode in Cloudflare===

Now set it up to run every minute

* * * * * bash /path/to/script/cf-phpfpm-attack-toggle.sh >> /var/log/cf-under-attack.log

Now when your site gets heavy traffic it will auto enable under-attack mode.

===How to setup the API Key in Cloudflare===

To generate the API key in cloudflare, you will need to go to

'''Manage Account -> Account API Tokens -> Create Token
'''

Make sure to select '''Zone -> Zone Settings both (Edit/Read)
'''

Those are the only settings this API token needs

Main Page

2026-03-20T01:20:03Z

Brian: /* Other */

==Welcome to Ramblings of a Centos Ninja==

[[File:Centos-logo.png|100px|frameless|right|alt=Centos How-Tos]]
===Centos 7===
--> [[Install Remi and EPEL yum repo Centos 7]]
--> [[Install Mysql Database Centos 7]]
--> [[Install Apache Web Server Centos 7]]
--> [[Install PHP/PHP-FPM 5.4 Centos 7]]
--> [[Install (LAMP) Linux Apache MySQL and PHP Centos 7]]
--> [[Install Redis on Centos 7 How To]]
--> [[How To Configure SWAP on Centos 7]]
--> [[How to find user memory usage in linux]]
--> [[How to Configure letsencrypt with Apache on Centos 7 Server]]
--> [[How to configure Gmail as a Mail Relay with Postfix]]
--> [[How use GeoIP on the command line Centos7]]
--> [[Protecting Folders with .htpasswd/.htaccess]]
--> [[Linux setfacl command]]
--> [[How to disable SSH timeout]] [[File:New.jpg|35px|frameless]]
--> [[How to Install Squid Proxy Server on Cento7]] [[File:New.jpg|35px|frameless]]
--> [[How To Use Systemctl to Manage Systemd Services]]

===Centos 6===
--> [[Change Runlevel]]
--> [[Check Current Runlevel]]
--> [[Change Run Level at Bootup]]
--> [[How to change the Hostname on Centos]]
--> [[chkconfig settings]]
--> [[How to extract a tar.gz file]]
--> [[Install SIM - System Integrity Monitor]]
--> [[Use Bash on a Non Bash User]]
--> [[Quit Bash Shell without Saving Bash History]]
--> [[Change the Timezone Centos]]
--> [[Check the Version of Package]]
--> [[How to install Sphinx on Centos Server]]
--> [[How to install Redis on a Centos 6.4 Server]]
--> [[Basic Redis commands - Cheat Sheet]]
--> [[Adding a New Disk Drive with Centos]]
--> [[Creating Backups using rsync with Examples]]
--> [[Expand your bash_history to 2500]]
--> [[Setup logrotate to rotate your logs]]
--> [[GPG: Encrypt And Decrypt Files With A Password]]
--> [[Install Remi and EPEL yum repo]]
--> [[Install NewRelic on Centos6]]
--> [[Setting Up An NFS Server And Client On CentOS 6]]
--> [[Sar is not working how to restart]]
--> [[Batch jpeg Image Optimization]]
--> [[Howto Block or Open HTTP/HTTPs Ports IPTables]]
--> [[Reset Root Password in CentOS]]
--> [[Setup vsftp with SELinux]]
--> [[Howto Setup NTP on CentOS]]
--> [[Fix corrupted RPM database]]
--> [[Crontab Usage]]
--> [[Make an ISO from a Folder with mkisofs]]
--> [[How to setup a VPN server with CentOS PPTPD]]
--> [[APF Firewall -Advanced Policy Firewall - Basics]]
--> [[How to Block Bittorrent Traffic with IPtables]]
--> [[How to find user memory usage in linux]]
--> [[How to install ccsrch on Centos 6]]
--> [[How to install jpegoptim for CentOS]]
--> [[How to install optipng for CentOS]]
--> [[How to install gifsicle for CentOS]]
--> [[How to install jpegtran for CentOS]]
--> [[IPTABLES quick command list]]
--> [[Linux setfacl command]]
--> [[Postfix Mail Queue Commands for Reviewing Emails]]

[[File:Magentos.jpg|100px|frameless|right|alt=Magento How To's]]

===Magento Community Edition/Magento Enterprise Edition===
--> [[What is Magento?]]
--> [[Clear Magento Cache]]
--> [[Disable Magento Modules]]
--> [[Turn on Manual Indexing]]
--> [[How to Reset Magento Password]]
--> [[How to Create Users in Mageento]]
--> [[Enable Mysql Slow Query Logging]]
--> [[Magento Connect is not Working]]
--> [[Magento will NOT save my Product Updates]]
--> [[Magento Internal Cron not Running]]
--> [[Setting up the System Cron Job]]
--> [[Magento Connect is not Working]]
--> [[Changing the Minimum Search Query - MySQL Full Text Only]]
--> [[Install Redis Caching for Magento]]
--> [[Install Redis Full Page Caching for Magento Enterprise]]
--> [[Setting up a Second Instance of Redis]]
--> [[Magento Setup Return-Path Email]]
--> [[Magento Server Compatibility Check]]
--> [[Magento Database Optimization - Log Cleaning Script]]
--> [[Magento Site Performance Optimization]]
--> [[Magento Log Rotate with logrotate]]
--> [[How to use CDN with Webfonts with Magento]]
--> [[How to Disable Magento Newsletter Module]]
--> [[Magento : Execute Custom Module Cron Manually]]

[[File:Magentos.jpg|100px|frameless|right|alt=Magento2 How To's]]

===Magento 2 Community Edition===
--> [[Upgrade Magento2 via CLI]]
--> [[Enable/Disable Magento2 Maintenance Page]]
--> [[How to set Magento 2 permissions and avoid installation errors]]
--> [[How to speed up Magento 2 out of the box]]
--> [[How to Change Magento 2 mode]]
--> [[How to Enable Disable Magento 2 caches]]
--> [[Magento 2 How to Add Alternative HTTP headers]]
--> [[Magento 2 Purge Varnish Cache]]
--> [[Magento 2 Redis Page Cache and Default Cache Example]]
--> [[Magento 2 How to check Magento Version]]
--> [[Magento 2 Reindex Error: Index is locked by another reindex process. Skipping]]
--> [[Magento 2 Reindex via the CLI]]
--> [[Magento 2 Custom 503 Maintenance page]]

[[File:Memcahed.jpg|100px|frameless|right|alt=Memcache Caching]]

===Memcached Server===
--> [[Memcached Monitor Tool]]
--> [[Setup Multi Instance Memcache]]
--> [[Check if Memcached is Running]]
--> [[Flush Your Memcached Instance]]
--> [[Check Memory Usage of Memcached]]
--> [[Memcache running out of Memory?]]
--> [[Memcached List all Keys]]

[[File:Apachelogo.gif|100px|right|alt=Apache How Tos]]

===Apache/PHP===

--> [[Deny access to my site with an .htaccess file]]
--> [[Redirect site to www or non www]]
--> [[Restrict POST request to Website]]
--> [[Install Tomcat6 Server on Centos 6]]
--> [[How to setup an SSL Certificate for Free]]
--> [[Enable Apache to Create Core Dumps]]
--> [[Enable php-fpm to create core dumps]]
--> [[Debug PHP Enabling slow_log]]
--> [[Block Bots by User Agent String]]
--> [[Install mod_extact_forward - Show Real IP behind Proxy]]
--> [[Install ionCube Loaders for Centos]]
--> [[Install Zend Guard with PHP 5.3 on Centos]]
--> [[Install Zend Guard 6.0 with PHP 5.4 on Centos]]
--> [[Disable Mod_Security for a single vhost]]
--> [[Hide PHP Version(X-Powered-By) in Headers]]
--> [[Sessions are ending before MaxLifetime]]
--> [[Apache mod_speling case insensitive urls issue]]
--> [[Restrict access via htaccess via ipaddress]]
--> [[Howto install mod_evasive with fail2ban]]
--> [[Install the Latest version PHP on CentOS]]
--> [[How to bypass .htpasswd for certain IPs Apache]]
--> [[Clear mod_pagespeed cache ]]
--> [[Install GeoIP for Apache and PHP]]
--> [[How to block or allow countries using GeoIP and .htaccess]]
--> [[How to disable mod_security per vhost]]
--> [[Force HTTPS for entire website via htaccess]]
--> [[Restrict Access to wp-login.php and xmlrpc.php]]
--> [[The X-Frame-Options response header]]
--> [[Install Xdebug with php-fpm per pool]]
--> [[How to Enable Gzip Compression]]
--> [[Enable Apache rewrite logging]]
--> [[Protecting Folders with .htpasswd/.htaccess]]
--> [[How to Disable PHP Execution in Certain Directories]]
--> [[Directory listing in htaccess. Allow, Deny, Disable, Enable Directory Listing in .htaccess]]
--> [[What is the Cache-Control Header]]
--> [[How do I block a host by ASN for apache - Example]]
--> [[Whitelist IP in mod_security]]

[[File:Haproxy.png|100px|frameless|right|alt=Mysql Percona]]

===HAProxy===
--> [[What is HAProxy]]
--> [[HAProxy vs Nginx]]
--> [[HAProxy Load Balancing]]
--> [[HAProxy Cluster Setup Example]]
--> [[HAProxy Docker]]
--> [[HAProxy with Varnish SSL Termination Example]]
--> [[HAProxy http2]]
--> [[HAProxy GUI]]
--> [[HAProxy Install on Centos7]]
--> [[HAProxy Cloud Load Balancer]]
--> [[HAProxy Block by User-Agent]]
--> [[HAProxy Restrict by IP Address]]
--> [[HAProxy Redirect domain to another domain]]
--> [[HAProxy Rate-Limiting Example]]

[[File:Logo percona server new.png|100px|frameless|right|alt=Mysql Percona]]

===Mysql/Percona===
--> [[How to Optimize/Repair a Table]]
--> [[MySQL - Check Which Query is Consuming Resources]]
--> [[How to Set your MySQL Password]]
--> [[Rest your MySQL Admin Password]]
--> [[How to Convert Table to InnoDB]]
--> [[How to install Percona Database Server]]
--> [[How to Access the MySQL via Shell]]
--> [[How to Add a User in MySQL]]
--> [[How to Drop a User in MySQL]]
--> [[How to Create and Delete a MySQL Database]]
--> [[How to Create a Table in MySQL Database]]
--> [[How to Create a MySQL Database Backup]]
--> [[How to Import a MySQL Database]]
--> [[How to update the max_connections setting in MySQL]]
--> [[How to view a list of MySQL users and their privileges]]
--> [[Save MySQL query results into a text or CSV file]]
--> [[How to optimize a MySQL database using phpMyAdmin]]
--> [[How to solve MySQL max_user_connections error]]
--> [[How to enable Show Engine Innodb Status]]
--> [[Access mysql/mysqldump without password entry each time - Using .my.cnf]]

[[File:Varnish-cache-log.jpeg|100px|frameless|right|alt=Varnish How tos]]

===Varnish Cache===
--> [[Setup Varnish Cache]]
--> [[Setup Varnish for Magento]]
--> [[Setup Varnish for Wordpress]]
--> [[Setup Varnish for MediaWiki]]
--> [[Setup Varnish - Multiple Domains]]
--> [[Setup Varnish - Multiple Ipaddress]]
--> [[Script to Clear a Page from Varnish Cache]]
--> [[Varnish will not restart WHY?]]
--> [[Warm up Varnish Script using Sitemap.xml]]
--> [[Varnish How to redirect non-www URLs to www]]
--> [[Install libvmod-header with Varnish]]

[[File:Nginx-logo.png|100px|frameless|right|Install Nginx|alt=Nginx How tos]]

===Nginx Web Server===
--> [[Setup Nginx PHP FPM Percona Mysql]]
--> [[Wordpress Ngnix Rewrite Rules]]
--> [[Setup up Nginx Caching]]
--> [[Nginx Magento vhost Configuration]]
--> [[Basic HTTP Authentication with Nginx]]
--> [[Protecting Folders with Nginx]]
--> [[403 Forbidden Error Nginx - How to Solve]]

[[File:Sword-of-Omens-Sword1.png|100px|frameless|right|alt=Brian Nelson]]

===Other===
--> [[How to add trusted root certificates]]
--> [[Find:_10_Useful_Examples_of_Find]]
--> [[Send email from PHP to a log file instead of sendmail]]
--> [[Debugging Wordpress]]
--> [[How to install Linux via USB]]
--> [[Network Subnet Mask Cheat Sheet]]
--> [[Linux Keyboard Shortcuts]]
--> [[Setup a SSH Tunnel for Secure Browsing]]
--> [[Install OpenSSH on Windows]]
--> [[Install Qmail on a Fresh Centos Server]]
--> [[Setup Qmail to Listen on port 587 for SMTP]]
--> [[Qmail catch-all account with vpopmail]]
--> [[Setup Incoming Email Pipe to Script for Qmail]]
--> [[Qmail Control Files]]
--> [[Install qmqtool for Qmail on Centos Server]]
--> [[Rest Email Password for vpopmail]]
--> [[How to check Used IP on your Home Network]]
--> [[How to find GMAIL IPs to allow at Firewall]]
--> [[Useful TCPDUMP commands]]
--> [[Remove Email Block Lists]]
--> [[How to disable qmail vpopmail email user]]
--> [[Git Cheat Sheet - Git made easy]]
--> [[Top Chmod Command Examples for Beginners]]
--> [[Benchmarking and Load Testing with Siege]]
--> [[Benchmarking and Load Testing with Apache Bench(AB)]]
--> [[How do I find out more about socket files in /proc/fd]]
--> [[How to Disable the wp-cron.php in WordPress]]
--> [[How to delete mail queue in Postfix]]

--> [[Top Command Line Games - Linux CLI Games]] Cause Linux can be fun

--> [[Centos Oneliners]]

--> [[Bash Script to Check Memory with Email Alert when Low]]
--> [[Bash Script to Check Site Code Status with Email Alert]]
--> [[Bash Script to Enable Under-Attack in Cloudflare]]

Magento Log Rotate with logrotate

2025-02-13T00:02:49Z

Brian:

==Magento Log Rotate with logrotate==

Have you ever had your Magento logs get so large you run out of disk quota. Maybe you would like to setup a log rotation for your Magento logs, it only makes sense all other major logs get rotated...right.

Let setup a cron that will rotate your magento logs (exception.log && system.log).

===Lets create the logrotate configuration file===

note, you will need to set your path to log files

vim magento-logrotate.conf

now add the following to the magento-logrotate.conf file

/path/to/magento/var/log/*log {
compress
delaycompress
dateext
missingok
nosharedscripts
notifempty
daily
rotate 14
prerotate
/usr/local/bin/ok2rotate $1
endscript
}

===Add a Daily cron to rotate your logs===

@daily /usr/sbin/logrotate -f /path/to/magento-logrotate.conf

or
0 0 * * * /usr/sbin/logrotate -f /path/to/magento-logrotate.conf

This will compress the old logs and keep 7 days worth of logs

Whitelist IP in mod security

2024-11-22T05:04:32Z

Brian: Created page with "==How to Whitelist IP in Mod_security== ModSecurity, often called ModSec or mod_security, is a web application firewall (WAF) designed for real-time monitoring, logging, and..."

==How to Whitelist IP in Mod_security==

ModSecurity, often called ModSec or mod_security, is a web application firewall (WAF) designed for real-time monitoring, logging, and controlling access to web applications (source: modsecurity.org). In simple terms, it actively detects and prevents malicious activities targeting the system. However, legitimate actions can sometimes unintentionally trigger these security rules, causing an IP to be blocked. This can disrupt access for you or your developer until the block is lifted. A common solution to prevent such interruptions is whitelisting, which allows specific IP addresses to bypass ModSecurity's restrictions and access the server without interference.

===Whitelist by IP in ModSecurity===

Basic rule for whitelisting an ip address in mod_security is:
SecRule REMOTE_ADDR "@ipMatch <IP>" "<actions>"
====Components:====
# SecRule: Defines a rule for ModSecurity to evaluate.
# REMOTE_ADDR: Matches the client's IP address.
# @ipMatch: Operator used to check if the request's IP matches the specified value(s).
# <IP>: Specific IP address to match.

====Actions:====
* phase:1: The rule is applied during the request's first processing phase.
* id:<number>: A unique identifier for the rule.
* nolog: Prevents logging of requests matching the rule.
* allow: Allows the request to bypass the usual security rules.
* ctl:ruleEngine=Off: Disables the ModSecurity rule engine for requests matching this rule.

Full example of whitelisting an ip address for mod_security:
SecRule REMOTE_ADDR "@ipMatch 111.111.111.110" "phase:1,id:200000001,nolog,allow,ctl:ruleEngine=Off"
SecRule REMOTE_ADDR "@ipMatch 111.111.111.109" "phase:1,id:200000002,nolog,allow,ctl:ruleEngine=Off"

====Practical Use Case:====
* Whitelisting: These rules are often used to whitelist trusted IPs, such as internal systems, monitoring tools, or API clients that require unrestricted access to the server.
* Performance Optimization: Turning off ModSecurity for trusted IPs reduces overhead for requests from these sources.

Main Page

2024-11-22T04:56:10Z

Brian: /* Apache/PHP */

HAProxy Rate-Limiting Example

2024-08-14T04:17:51Z

Brian: Created page with "===HAProxy Rate-Limiting Example=== One of the benefits of haproxy is how easy it is to rate-limit aggressive ips. Recently I had to start rate-limiting aggressive ips that a..."

===HAProxy Rate-Limiting Example===
One of the benefits of haproxy is how easy it is to rate-limit aggressive ips.

Recently I had to start rate-limiting aggressive ips that are attempting to hack your site or just cause a small ddos attack.

I added the following to my configuration right before the backends.

##Whitelist
acl whitelist_ip hdr_ip(x-forwarded-for,1) -f /etc/haproxy/whitelist_ip.txt
acl whitelist_ip src -m ip -f /etc/haproxy/whitelist_ip.txt

## IP Rate Limiting ##
stick-table type ipv6 size 100k expire 30s store http_req_rate(10s)
http-request track-sc0 src
http-request deny deny_status 429 if { sc_http_req_rate(0) gt 20 } !whitelist_ip

## Route to chosen backend
use_backend %[var(req.backend)] if { var(req.backend) -m found }
default_backend apache-backend

===Rules Explained===
The rule says if they create 20 sessions in 10s from a specific ip address (aggressive ips), you block them for 30 seconds if the ip address is NOT whitelisted.

I use the whitelist for my ip and most good bots.

===Explainations and Customizations===

The stick-table directive creates a key-value store for storing counters like the HTTP request rate per client. The key is the client’s IP address, as configured by the type parameter, which is used to store and aggregate that client’s number of requests. The http-request track-sc0 src line adds the client as a record in the stick table. The counters begin to be recorded as soon as the IP is added.

A stick table record expires and is removed after a period of inactivity by the client, as set by the expire parameter. That’s just a way of freeing up space. Without an expire parameter, the oldest records are evicted when the storage becomes full. Here, we’re allowing 100,000 records.

The http-request deny line sets the rate limit threshold and the action to take when someone exceeds it. Here, we’re allowing up to 20 concurrent requests and denying additional ones with a 429 Too Many Requests response until the count during the last 10 seconds is below the threshold again. Other actions include forwarding the client to a dedicated backend or silently dropping the connection. The sc_http_req_rate fetch method returns the client’s current request rate.

You can play with the time period or the threshold. Instead of counting requests over 10 seconds, you might extend it to something like 1000 requests during the last 24 hours. Simply change the counter specified on the stick-table line from http_req_rate(10s) to http_req_rate(24h). Then update the http-request deny line to allow no more than 1000 requests.

Main Page

2024-08-14T04:04:35Z

Brian: /* HAProxy */

==Welcome to Ramblings of a Centos Ninja==

[[File:Centos-logo.png|100px|frameless|right|alt=Centos How-Tos]]
===Centos 7===
--> [[Install Remi and EPEL yum repo Centos 7]]
--> [[Install Mysql Database Centos 7]]
--> [[Install Apache Web Server Centos 7]]
--> [[Install PHP/PHP-FPM 5.4 Centos 7]]
--> [[Install (LAMP) Linux Apache MySQL and PHP Centos 7]]
--> [[Install Redis on Centos 7 How To]]
--> [[How To Configure SWAP on Centos 7]]
--> [[How to find user memory usage in linux]]
--> [[How to Configure letsencrypt with Apache on Centos 7 Server]]
--> [[How to configure Gmail as a Mail Relay with Postfix]]
--> [[How use GeoIP on the command line Centos7]]
--> [[Protecting Folders with .htpasswd/.htaccess]]
--> [[Linux setfacl command]]
--> [[How to disable SSH timeout]] [[File:New.jpg|35px|frameless]]
--> [[How to Install Squid Proxy Server on Cento7]] [[File:New.jpg|35px|frameless]]
--> [[How To Use Systemctl to Manage Systemd Services]]

===Centos 6===
--> [[Change Runlevel]]
--> [[Check Current Runlevel]]
--> [[Change Run Level at Bootup]]
--> [[How to change the Hostname on Centos]]
--> [[chkconfig settings]]
--> [[How to extract a tar.gz file]]
--> [[Install SIM - System Integrity Monitor]]
--> [[Use Bash on a Non Bash User]]
--> [[Quit Bash Shell without Saving Bash History]]
--> [[Change the Timezone Centos]]
--> [[Check the Version of Package]]
--> [[How to install Sphinx on Centos Server]]
--> [[How to install Redis on a Centos 6.4 Server]]
--> [[Basic Redis commands - Cheat Sheet]]
--> [[Adding a New Disk Drive with Centos]]
--> [[Creating Backups using rsync with Examples]]
--> [[Expand your bash_history to 2500]]
--> [[Setup logrotate to rotate your logs]]
--> [[GPG: Encrypt And Decrypt Files With A Password]]
--> [[Install Remi and EPEL yum repo]]
--> [[Install NewRelic on Centos6]]
--> [[Setting Up An NFS Server And Client On CentOS 6]]
--> [[Sar is not working how to restart]]
--> [[Batch jpeg Image Optimization]]
--> [[Howto Block or Open HTTP/HTTPs Ports IPTables]]
--> [[Reset Root Password in CentOS]]
--> [[Setup vsftp with SELinux]]
--> [[Howto Setup NTP on CentOS]]
--> [[Fix corrupted RPM database]]
--> [[Crontab Usage]]
--> [[Make an ISO from a Folder with mkisofs]]
--> [[How to setup a VPN server with CentOS PPTPD]]
--> [[APF Firewall -Advanced Policy Firewall - Basics]]
--> [[How to Block Bittorrent Traffic with IPtables]]
--> [[How to find user memory usage in linux]]
--> [[How to install ccsrch on Centos 6]]
--> [[How to install jpegoptim for CentOS]]
--> [[How to install optipng for CentOS]]
--> [[How to install gifsicle for CentOS]]
--> [[How to install jpegtran for CentOS]]
--> [[IPTABLES quick command list]]
--> [[Linux setfacl command]]
--> [[Postfix Mail Queue Commands for Reviewing Emails]]

[[File:Magentos.jpg|100px|frameless|right|alt=Magento How To's]]

===Magento Community Edition/Magento Enterprise Edition===
--> [[What is Magento?]]
--> [[Clear Magento Cache]]
--> [[Disable Magento Modules]]
--> [[Turn on Manual Indexing]]
--> [[How to Reset Magento Password]]
--> [[How to Create Users in Mageento]]
--> [[Enable Mysql Slow Query Logging]]
--> [[Magento Connect is not Working]]
--> [[Magento will NOT save my Product Updates]]
--> [[Magento Internal Cron not Running]]
--> [[Setting up the System Cron Job]]
--> [[Magento Connect is not Working]]
--> [[Changing the Minimum Search Query - MySQL Full Text Only]]
--> [[Install Redis Caching for Magento]]
--> [[Install Redis Full Page Caching for Magento Enterprise]]
--> [[Setting up a Second Instance of Redis]]
--> [[Magento Setup Return-Path Email]]
--> [[Magento Server Compatibility Check]]
--> [[Magento Database Optimization - Log Cleaning Script]]
--> [[Magento Site Performance Optimization]]
--> [[Magento Log Rotate with logrotate]]
--> [[How to use CDN with Webfonts with Magento]]
--> [[How to Disable Magento Newsletter Module]]
--> [[Magento : Execute Custom Module Cron Manually]]

[[File:Magentos.jpg|100px|frameless|right|alt=Magento2 How To's]]

===Magento 2 Community Edition===
--> [[Upgrade Magento2 via CLI]]
--> [[Enable/Disable Magento2 Maintenance Page]]
--> [[How to set Magento 2 permissions and avoid installation errors]]
--> [[How to speed up Magento 2 out of the box]]
--> [[How to Change Magento 2 mode]]
--> [[How to Enable Disable Magento 2 caches]]
--> [[Magento 2 How to Add Alternative HTTP headers]]
--> [[Magento 2 Purge Varnish Cache]]
--> [[Magento 2 Redis Page Cache and Default Cache Example]]
--> [[Magento 2 How to check Magento Version]]
--> [[Magento 2 Reindex Error: Index is locked by another reindex process. Skipping]]
--> [[Magento 2 Reindex via the CLI]]
--> [[Magento 2 Custom 503 Maintenance page]]

[[File:Memcahed.jpg|100px|frameless|right|alt=Memcache Caching]]

===Memcached Server===
--> [[Memcached Monitor Tool]]
--> [[Setup Multi Instance Memcache]]
--> [[Check if Memcached is Running]]
--> [[Flush Your Memcached Instance]]
--> [[Check Memory Usage of Memcached]]
--> [[Memcache running out of Memory?]]
--> [[Memcached List all Keys]]

[[File:Apachelogo.gif|100px|right|alt=Apache How Tos]]

===Apache/PHP===

--> [[Deny access to my site with an .htaccess file]]
--> [[Redirect site to www or non www]]
--> [[Restrict POST request to Website]]
--> [[Install Tomcat6 Server on Centos 6]]
--> [[How to setup an SSL Certificate for Free]]
--> [[Enable Apache to Create Core Dumps]]
--> [[Enable php-fpm to create core dumps]]
--> [[Debug PHP Enabling slow_log]]
--> [[Block Bots by User Agent String]]
--> [[Install mod_extact_forward - Show Real IP behind Proxy]]
--> [[Install ionCube Loaders for Centos]]
--> [[Install Zend Guard with PHP 5.3 on Centos]]
--> [[Install Zend Guard 6.0 with PHP 5.4 on Centos]]
--> [[Disable Mod_Security for a single vhost]]
--> [[Hide PHP Version(X-Powered-By) in Headers]]
--> [[Sessions are ending before MaxLifetime]]
--> [[Apache mod_speling case insensitive urls issue]]
--> [[Restrict access via htaccess via ipaddress]]
--> [[Howto install mod_evasive with fail2ban]]
--> [[Install the Latest version PHP on CentOS]]
--> [[How to bypass .htpasswd for certain IPs Apache]]
--> [[Clear mod_pagespeed cache ]]
--> [[Install GeoIP for Apache and PHP]]
--> [[How to block or allow countries using GeoIP and .htaccess]]
--> [[How to disable mod_security per vhost]]
--> [[Force HTTPS for entire website via htaccess]]
--> [[Restrict Access to wp-login.php and xmlrpc.php]]
--> [[The X-Frame-Options response header]]
--> [[Install Xdebug with php-fpm per pool]]
--> [[How to Enable Gzip Compression]]
--> [[Enable Apache rewrite logging]]
--> [[Protecting Folders with .htpasswd/.htaccess]]
--> [[How to Disable PHP Execution in Certain Directories]]
--> [[Directory listing in htaccess. Allow, Deny, Disable, Enable Directory Listing in .htaccess]]
--> [[What is the Cache-Control Header]]
--> [[How do I block a host by ASN for apache - Example]]
[[File:Haproxy.png|100px|frameless|right|alt=Mysql Percona]]

===HAProxy===
--> [[What is HAProxy]]
--> [[HAProxy vs Nginx]]
--> [[HAProxy Load Balancing]]
--> [[HAProxy Cluster Setup Example]]
--> [[HAProxy Docker]]
--> [[HAProxy with Varnish SSL Termination Example]]
--> [[HAProxy http2]]
--> [[HAProxy GUI]]
--> [[HAProxy Install on Centos7]]
--> [[HAProxy Cloud Load Balancer]]
--> [[HAProxy Block by User-Agent]]
--> [[HAProxy Restrict by IP Address]]
--> [[HAProxy Redirect domain to another domain]]
--> [[HAProxy Rate-Limiting Example]]

[[File:Logo percona server new.png|100px|frameless|right|alt=Mysql Percona]]

===Mysql/Percona===
--> [[How to Optimize/Repair a Table]]
--> [[MySQL - Check Which Query is Consuming Resources]]
--> [[How to Set your MySQL Password]]
--> [[Rest your MySQL Admin Password]]
--> [[How to Convert Table to InnoDB]]
--> [[How to install Percona Database Server]]
--> [[How to Access the MySQL via Shell]]
--> [[How to Add a User in MySQL]]
--> [[How to Drop a User in MySQL]]
--> [[How to Create and Delete a MySQL Database]]
--> [[How to Create a Table in MySQL Database]]
--> [[How to Create a MySQL Database Backup]]
--> [[How to Import a MySQL Database]]
--> [[How to update the max_connections setting in MySQL]]
--> [[How to view a list of MySQL users and their privileges]]
--> [[Save MySQL query results into a text or CSV file]]
--> [[How to optimize a MySQL database using phpMyAdmin]]
--> [[How to solve MySQL max_user_connections error]]
--> [[How to enable Show Engine Innodb Status]]
--> [[Access mysql/mysqldump without password entry each time - Using .my.cnf]]

[[File:Varnish-cache-log.jpeg|100px|frameless|right|alt=Varnish How tos]]

===Varnish Cache===
--> [[Setup Varnish Cache]]
--> [[Setup Varnish for Magento]]
--> [[Setup Varnish for Wordpress]]
--> [[Setup Varnish for MediaWiki]]
--> [[Setup Varnish - Multiple Domains]]
--> [[Setup Varnish - Multiple Ipaddress]]
--> [[Script to Clear a Page from Varnish Cache]]
--> [[Varnish will not restart WHY?]]
--> [[Warm up Varnish Script using Sitemap.xml]]
--> [[Varnish How to redirect non-www URLs to www]]
--> [[Install libvmod-header with Varnish]]

[[File:Nginx-logo.png|100px|frameless|right|Install Nginx|alt=Nginx How tos]]

===Nginx Web Server===
--> [[Setup Nginx PHP FPM Percona Mysql]]
--> [[Wordpress Ngnix Rewrite Rules]]
--> [[Setup up Nginx Caching]]
--> [[Nginx Magento vhost Configuration]]
--> [[Basic HTTP Authentication with Nginx]]
--> [[Protecting Folders with Nginx]]
--> [[403 Forbidden Error Nginx - How to Solve]]

[[File:Sword-of-Omens-Sword1.png|100px|frameless|right|alt=Brian Nelson]]

===Other===
--> [[How to add trusted root certificates]]
--> [[Find:_10_Useful_Examples_of_Find]]
--> [[Send email from PHP to a log file instead of sendmail]]
--> [[Debugging Wordpress]]
--> [[How to install Linux via USB]]
--> [[Network Subnet Mask Cheat Sheet]]
--> [[Linux Keyboard Shortcuts]]
--> [[Setup a SSH Tunnel for Secure Browsing]]
--> [[Install OpenSSH on Windows]]
--> [[Install Qmail on a Fresh Centos Server]]
--> [[Setup Qmail to Listen on port 587 for SMTP]]
--> [[Qmail catch-all account with vpopmail]]
--> [[Setup Incoming Email Pipe to Script for Qmail]]
--> [[Qmail Control Files]]
--> [[Install qmqtool for Qmail on Centos Server]]
--> [[Rest Email Password for vpopmail]]
--> [[How to check Used IP on your Home Network]]
--> [[How to find GMAIL IPs to allow at Firewall]]
--> [[Useful TCPDUMP commands]]
--> [[Remove Email Block Lists]]
--> [[How to disable qmail vpopmail email user]]
--> [[Git Cheat Sheet - Git made easy]]
--> [[Top Chmod Command Examples for Beginners]]
--> [[Benchmarking and Load Testing with Siege]]
--> [[Benchmarking and Load Testing with Apache Bench(AB)]]
--> [[How do I find out more about socket files in /proc/fd]]
--> [[How to Disable the wp-cron.php in WordPress]]
--> [[How to delete mail queue in Postfix]]

--> [[Top Command Line Games - Linux CLI Games]] Cause Linux can be fun

--> [[Centos Oneliners]]

--> [[Bash Script to Check Memory with Email Alert when Low]]
--> [[Bash Script to Check Site Code Status with Email Alert]]

Access mysql/mysqldump without password entry each time - Using .my.cnf

2023-08-26T02:59:31Z

Brian: Created page with "==Access mysql/mysqldump without password entry each time - Using .my.cnf== In this guide we will show you have to save your mysql credentials so you do not have to enter the..."

==Access mysql/mysqldump without password entry each time - Using .my.cnf==

In this guide we will show you have to save your mysql credentials so you do not have to enter them each time run mysql or mysqldump.

This is done by creating a ~/.my.cnf file in your users home directory.

vim /home/bnelson/.my.cnf or vim ~/.my.cnf

After you have created this file you can enter your credentials.

[client]
user=mysqluser
password=mysqlpass

* It is best to use a superuser for this, so that you can have access to all databases.

If you are attempting to create a script to do a mysql dump or optimization, this will allow you run that script without having it stop and wait for credentials.

===Overview and Thoughts===

'''For safety, make this file readable to you only by running chmod 0600 ~/.my.cnf
'''

Of course, if you specify username and password explicitly as part of commands arguments, they will be used.

Next time you run mysql commands mysql, mysqlcheck, mysqdump, etc; they will pick username & password from this file if you do not provide them as argument (-u and -p).

Main Page

2023-08-26T02:50:23Z

Brian: /* Mysql/Percona */

==Welcome to Ramblings of a Centos Ninja==

[[File:Centos-logo.png|100px|frameless|right|alt=Centos How-Tos]]
===Centos 7===
--> [[Install Remi and EPEL yum repo Centos 7]]
--> [[Install Mysql Database Centos 7]]
--> [[Install Apache Web Server Centos 7]]
--> [[Install PHP/PHP-FPM 5.4 Centos 7]]
--> [[Install (LAMP) Linux Apache MySQL and PHP Centos 7]]
--> [[Install Redis on Centos 7 How To]]
--> [[How To Configure SWAP on Centos 7]]
--> [[How to find user memory usage in linux]]
--> [[How to Configure letsencrypt with Apache on Centos 7 Server]]
--> [[How to configure Gmail as a Mail Relay with Postfix]]
--> [[How use GeoIP on the command line Centos7]]
--> [[Protecting Folders with .htpasswd/.htaccess]]
--> [[Linux setfacl command]]
--> [[How to disable SSH timeout]] [[File:New.jpg|35px|frameless]]
--> [[How to Install Squid Proxy Server on Cento7]] [[File:New.jpg|35px|frameless]]
--> [[How To Use Systemctl to Manage Systemd Services]]

===Centos 6===
--> [[Change Runlevel]]
--> [[Check Current Runlevel]]
--> [[Change Run Level at Bootup]]
--> [[How to change the Hostname on Centos]]
--> [[chkconfig settings]]
--> [[How to extract a tar.gz file]]
--> [[Install SIM - System Integrity Monitor]]
--> [[Use Bash on a Non Bash User]]
--> [[Quit Bash Shell without Saving Bash History]]
--> [[Change the Timezone Centos]]
--> [[Check the Version of Package]]
--> [[How to install Sphinx on Centos Server]]
--> [[How to install Redis on a Centos 6.4 Server]]
--> [[Basic Redis commands - Cheat Sheet]]
--> [[Adding a New Disk Drive with Centos]]
--> [[Creating Backups using rsync with Examples]]
--> [[Expand your bash_history to 2500]]
--> [[Setup logrotate to rotate your logs]]
--> [[GPG: Encrypt And Decrypt Files With A Password]]
--> [[Install Remi and EPEL yum repo]]
--> [[Install NewRelic on Centos6]]
--> [[Setting Up An NFS Server And Client On CentOS 6]]
--> [[Sar is not working how to restart]]
--> [[Batch jpeg Image Optimization]]
--> [[Howto Block or Open HTTP/HTTPs Ports IPTables]]
--> [[Reset Root Password in CentOS]]
--> [[Setup vsftp with SELinux]]
--> [[Howto Setup NTP on CentOS]]
--> [[Fix corrupted RPM database]]
--> [[Crontab Usage]]
--> [[Make an ISO from a Folder with mkisofs]]
--> [[How to setup a VPN server with CentOS PPTPD]]
--> [[APF Firewall -Advanced Policy Firewall - Basics]]
--> [[How to Block Bittorrent Traffic with IPtables]]
--> [[How to find user memory usage in linux]]
--> [[How to install ccsrch on Centos 6]]
--> [[How to install jpegoptim for CentOS]]
--> [[How to install optipng for CentOS]]
--> [[How to install gifsicle for CentOS]]
--> [[How to install jpegtran for CentOS]]
--> [[IPTABLES quick command list]]
--> [[Linux setfacl command]]
--> [[Postfix Mail Queue Commands for Reviewing Emails]]

[[File:Magentos.jpg|100px|frameless|right|alt=Magento How To's]]

===Magento Community Edition/Magento Enterprise Edition===
--> [[What is Magento?]]
--> [[Clear Magento Cache]]
--> [[Disable Magento Modules]]
--> [[Turn on Manual Indexing]]
--> [[How to Reset Magento Password]]
--> [[How to Create Users in Mageento]]
--> [[Enable Mysql Slow Query Logging]]
--> [[Magento Connect is not Working]]
--> [[Magento will NOT save my Product Updates]]
--> [[Magento Internal Cron not Running]]
--> [[Setting up the System Cron Job]]
--> [[Magento Connect is not Working]]
--> [[Changing the Minimum Search Query - MySQL Full Text Only]]
--> [[Install Redis Caching for Magento]]
--> [[Install Redis Full Page Caching for Magento Enterprise]]
--> [[Setting up a Second Instance of Redis]]
--> [[Magento Setup Return-Path Email]]
--> [[Magento Server Compatibility Check]]
--> [[Magento Database Optimization - Log Cleaning Script]]
--> [[Magento Site Performance Optimization]]
--> [[Magento Log Rotate with logrotate]]
--> [[How to use CDN with Webfonts with Magento]]
--> [[How to Disable Magento Newsletter Module]]
--> [[Magento : Execute Custom Module Cron Manually]]

[[File:Magentos.jpg|100px|frameless|right|alt=Magento2 How To's]]

===Magento 2 Community Edition===
--> [[Upgrade Magento2 via CLI]]
--> [[Enable/Disable Magento2 Maintenance Page]]
--> [[How to set Magento 2 permissions and avoid installation errors]]
--> [[How to speed up Magento 2 out of the box]]
--> [[How to Change Magento 2 mode]]
--> [[How to Enable Disable Magento 2 caches]]
--> [[Magento 2 How to Add Alternative HTTP headers]]
--> [[Magento 2 Purge Varnish Cache]]
--> [[Magento 2 Redis Page Cache and Default Cache Example]]
--> [[Magento 2 How to check Magento Version]]
--> [[Magento 2 Reindex Error: Index is locked by another reindex process. Skipping]]
--> [[Magento 2 Reindex via the CLI]]
--> [[Magento 2 Custom 503 Maintenance page]]

[[File:Memcahed.jpg|100px|frameless|right|alt=Memcache Caching]]

===Memcached Server===
--> [[Memcached Monitor Tool]]
--> [[Setup Multi Instance Memcache]]
--> [[Check if Memcached is Running]]
--> [[Flush Your Memcached Instance]]
--> [[Check Memory Usage of Memcached]]
--> [[Memcache running out of Memory?]]
--> [[Memcached List all Keys]]

[[File:Apachelogo.gif|100px|right|alt=Apache How Tos]]

===Apache/PHP===

--> [[Deny access to my site with an .htaccess file]]
--> [[Redirect site to www or non www]]
--> [[Restrict POST request to Website]]
--> [[Install Tomcat6 Server on Centos 6]]
--> [[How to setup an SSL Certificate for Free]]
--> [[Enable Apache to Create Core Dumps]]
--> [[Enable php-fpm to create core dumps]]
--> [[Debug PHP Enabling slow_log]]
--> [[Block Bots by User Agent String]]
--> [[Install mod_extact_forward - Show Real IP behind Proxy]]
--> [[Install ionCube Loaders for Centos]]
--> [[Install Zend Guard with PHP 5.3 on Centos]]
--> [[Install Zend Guard 6.0 with PHP 5.4 on Centos]]
--> [[Disable Mod_Security for a single vhost]]
--> [[Hide PHP Version(X-Powered-By) in Headers]]
--> [[Sessions are ending before MaxLifetime]]
--> [[Apache mod_speling case insensitive urls issue]]
--> [[Restrict access via htaccess via ipaddress]]
--> [[Howto install mod_evasive with fail2ban]]
--> [[Install the Latest version PHP on CentOS]]
--> [[How to bypass .htpasswd for certain IPs Apache]]
--> [[Clear mod_pagespeed cache ]]
--> [[Install GeoIP for Apache and PHP]]
--> [[How to block or allow countries using GeoIP and .htaccess]]
--> [[How to disable mod_security per vhost]]
--> [[Force HTTPS for entire website via htaccess]]
--> [[Restrict Access to wp-login.php and xmlrpc.php]]
--> [[The X-Frame-Options response header]]
--> [[Install Xdebug with php-fpm per pool]]
--> [[How to Enable Gzip Compression]]
--> [[Enable Apache rewrite logging]]
--> [[Protecting Folders with .htpasswd/.htaccess]]
--> [[How to Disable PHP Execution in Certain Directories]]
--> [[Directory listing in htaccess. Allow, Deny, Disable, Enable Directory Listing in .htaccess]]
--> [[What is the Cache-Control Header]]
--> [[How do I block a host by ASN for apache - Example]]
[[File:Haproxy.png|100px|frameless|right|alt=Mysql Percona]]

===HAProxy===
--> [[What is HAProxy]]
--> [[HAProxy vs Nginx]]
--> [[HAProxy Load Balancing]]
--> [[HAProxy Cluster Setup Example]]
--> [[HAProxy Docker]]
--> [[HAProxy with Varnish SSL Termination Example]]
--> [[HAProxy http2]]
--> [[HAProxy GUI]]
--> [[HAProxy Install on Centos7]]
--> [[HAProxy Cloud Load Balancer]]
--> [[HAProxy Block by User-Agent]]
--> [[HAProxy Restrict by IP Address]]
--> [[HAProxy Redirect domain to another domain]]

[[File:Logo percona server new.png|100px|frameless|right|alt=Mysql Percona]]

===Mysql/Percona===
--> [[How to Optimize/Repair a Table]]
--> [[MySQL - Check Which Query is Consuming Resources]]
--> [[How to Set your MySQL Password]]
--> [[Rest your MySQL Admin Password]]
--> [[How to Convert Table to InnoDB]]
--> [[How to install Percona Database Server]]
--> [[How to Access the MySQL via Shell]]
--> [[How to Add a User in MySQL]]
--> [[How to Drop a User in MySQL]]
--> [[How to Create and Delete a MySQL Database]]
--> [[How to Create a Table in MySQL Database]]
--> [[How to Create a MySQL Database Backup]]
--> [[How to Import a MySQL Database]]
--> [[How to update the max_connections setting in MySQL]]
--> [[How to view a list of MySQL users and their privileges]]
--> [[Save MySQL query results into a text or CSV file]]
--> [[How to optimize a MySQL database using phpMyAdmin]]
--> [[How to solve MySQL max_user_connections error]]
--> [[How to enable Show Engine Innodb Status]]
--> [[Access mysql/mysqldump without password entry each time - Using .my.cnf]]

[[File:Varnish-cache-log.jpeg|100px|frameless|right|alt=Varnish How tos]]

===Varnish Cache===
--> [[Setup Varnish Cache]]
--> [[Setup Varnish for Magento]]
--> [[Setup Varnish for Wordpress]]
--> [[Setup Varnish for MediaWiki]]
--> [[Setup Varnish - Multiple Domains]]
--> [[Setup Varnish - Multiple Ipaddress]]
--> [[Script to Clear a Page from Varnish Cache]]
--> [[Varnish will not restart WHY?]]
--> [[Warm up Varnish Script using Sitemap.xml]]
--> [[Varnish How to redirect non-www URLs to www]]
--> [[Install libvmod-header with Varnish]]

[[File:Nginx-logo.png|100px|frameless|right|Install Nginx|alt=Nginx How tos]]

===Nginx Web Server===
--> [[Setup Nginx PHP FPM Percona Mysql]]
--> [[Wordpress Ngnix Rewrite Rules]]
--> [[Setup up Nginx Caching]]
--> [[Nginx Magento vhost Configuration]]
--> [[Basic HTTP Authentication with Nginx]]
--> [[Protecting Folders with Nginx]]
--> [[403 Forbidden Error Nginx - How to Solve]]

[[File:Sword-of-Omens-Sword1.png|100px|frameless|right|alt=Brian Nelson]]

===Other===
--> [[How to add trusted root certificates]]
--> [[Find:_10_Useful_Examples_of_Find]]
--> [[Send email from PHP to a log file instead of sendmail]]
--> [[Debugging Wordpress]]
--> [[How to install Linux via USB]]
--> [[Network Subnet Mask Cheat Sheet]]
--> [[Linux Keyboard Shortcuts]]
--> [[Setup a SSH Tunnel for Secure Browsing]]
--> [[Install OpenSSH on Windows]]
--> [[Install Qmail on a Fresh Centos Server]]
--> [[Setup Qmail to Listen on port 587 for SMTP]]
--> [[Qmail catch-all account with vpopmail]]
--> [[Setup Incoming Email Pipe to Script for Qmail]]
--> [[Qmail Control Files]]
--> [[Install qmqtool for Qmail on Centos Server]]
--> [[Rest Email Password for vpopmail]]
--> [[How to check Used IP on your Home Network]]
--> [[How to find GMAIL IPs to allow at Firewall]]
--> [[Useful TCPDUMP commands]]
--> [[Remove Email Block Lists]]
--> [[How to disable qmail vpopmail email user]]
--> [[Git Cheat Sheet - Git made easy]]
--> [[Top Chmod Command Examples for Beginners]]
--> [[Benchmarking and Load Testing with Siege]]
--> [[Benchmarking and Load Testing with Apache Bench(AB)]]
--> [[How do I find out more about socket files in /proc/fd]]
--> [[How to Disable the wp-cron.php in WordPress]]
--> [[How to delete mail queue in Postfix]]

--> [[Top Command Line Games - Linux CLI Games]] Cause Linux can be fun

--> [[Centos Oneliners]]

--> [[Bash Script to Check Memory with Email Alert when Low]]
--> [[Bash Script to Check Site Code Status with Email Alert]]

Resume

2023-06-10T03:15:08Z

Brian: /* Resume */

==Resume==
----
Brian S. Nelson 
Email: briansnelson@gmail.com
Telephone: Ask via Email

===EXPERIENCE===
----
<big>Nexcess .NET LLC/Liquid Web LLC</big> 
'''Support System Administrator II''' 
Oct 2012- Present 
* Provided advanced troubleshooting for server issues
*Optimizing server environments for web applications in a high availability cluster environment utilizing haproxy/apache/mysql
*Diagnosing and resolving IP email blacklisting issues
*Audited hacked accounts to prevent the hack from recurring
*Identified issues with varnish/haproxy/apache/php
*Advanced troubleshooting on CMS platforms (Magento,Wordpress,Joomla and Expression Engine)
*Stress test web sites for high availability(siege/ab testing/k6.io)
*Working with clients to resolve issues via phone and ticket system
*Write and maintain internal documentation for training purposes
*Assisting with training of new technicians.
*Diagnosing mysql errors and performance issues (locks,deadlocks)
*Addressing PCI compliance Issues
*Configured and managed firewalls to protect the network from malicious threats and ensure compliance with security policies
*Reviewed and resolved complex technical issues to restore service to customers quickly
*Performed Website Backups and Restores from Backup Server to Live Server
*Installed and upgraded system services to keep up to date (mysql/haproxy/varnish/elasticsearch/php-fpm)
*Identified and escalated major technical issues to system operations for resolution
*Collaborated with cross-functional teams to identify and resolve customer issues
*Developed scripts to capture data to help identify the cause of system issues

<big>Triple Crown Ventures LLC</big> 
'''System Administrator / PHP Web Developer / Database Administrator''' 
Feb 2006 - Oct 2012 
* Provided daily server maintenance on various applications Qmail Server, MySQL Server, LAMP Server / Varnish Caching Server, LNMP Servers, TinyDNS Server
*Configured Barracuda Load Balancer / Application Firewall application
*Established Wordpress Blogs / Developed Plugins
*Developed Email Templates that resulted in a 10-15% increase in click through rate
*Integrated critical nightly backup system for website,email, and databases
*Optimized MySQL/Apache/Nginx services to provide peak performance that handled spikes in traffic
*Created an automated system for system patching and updates that improved system reliability and security
*Monitored database performance and identified and addressed any performance bottlenecks

<big>Peak Positions LLC</big> 
'''SEO Project Engineer''' 
May 2005 - Nov 2005 
* Provided Customers with monthly keyword rankings reports
*Developed content pages for various keywords to improve the overall rank on that keyword
*Designed Templates in FrontPage to be used for Content Pages
*Identified and resolved project issues quickly and efficiently, minimizing their impact on project progress
*Initiated project plans and guidelines that provided a roadmap for successful completion of the project
*Implemented an effective SEO strategy that increased organic search engine rankings and doubled website visits
*Conducted keyword research, to compose SEO-friendly content titles and meta descriptions to maximize content visibility
*Evaluated keyword research to identify topics with high search volume and low competition for SEO optimization
*Cultivated a search engine optimization (SEO) strategy that increased organic search engine rankings and increased visibility on search engines.

===SKILLS===
----
*Website/ Database Design
*Linux Server Administrator
*System Administration
*Search Engine Optimization
*Customer Service
*Leadership and Teamwork
*Critical Thinking and problem solving
*Effective Time Management
*Ability to Multitask
*Ability to work Under Pressure

===EDUCATION===
----
Northwood University – Midland, MI 
Bachelor of Business Administration 
Dual Major: Management Information Systems and Management 
Graduated May 2003

Resume

2023-06-09T21:46:12Z

Brian: /* Resume */

==Resume==
----
Brian S. Nelson 
Email: brian@briansnelson.com 
Telephone: 586-921-3056 

===EXPERIENCE===
----
<big>Nexcess .NET LLC/Liquid Web LLC</big> 
'''Support System Administrator II''' 
Oct 2012- Present 
* Provided advanced troubleshooting for server issues
*Optimizing server environments for web applications in a high availability cluster environment utilizing haproxy/apache/mysql
*Diagnosing and resolving IP email blacklisting issues
*Audited hacked accounts to prevent the hack from recurring
*Identified issues with varnish/haproxy/apache/php
*Advanced troubleshooting on CMS platforms (Magento,Wordpress,Joomla and Expression Engine)
*Stress test web sites for high availability(siege/ab testing/k6.io)
*Working with clients to resolve issues via phone and ticket system
*Write and maintain internal documentation for training purposes
*Assisting with training of new technicians.
*Diagnosing mysql errors and performance issues (locks,deadlocks)
*Addressing PCI compliance Issues
*Configured and managed firewalls to protect the network from malicious threats and ensure compliance with security policies
*Reviewed and resolved complex technical issues to restore service to customers quickly
*Performed Website Backups and Restores from Backup Server to Live Server
*Installed and upgraded system services to keep up to date (mysql/haproxy/varnish/elasticsearch/php-fpm)
*Identified and escalated major technical issues to system operations for resolution
*Collaborated with cross-functional teams to identify and resolve customer issues
*Developed scripts to capture data to help identify the cause of system issues

<big>Triple Crown Ventures LLC</big> 
'''System Administrator / PHP Web Developer / Database Administrator''' 
Feb 2006 - Oct 2012 
* Provided daily server maintenance on various applications Qmail Server, MySQL Server, LAMP Server / Varnish Caching Server, LNMP Servers, TinyDNS Server
*Configured Barracuda Load Balancer / Application Firewall application
*Established Wordpress Blogs / Developed Plugins
*Developed Email Templates that resulted in a 10-15% increase in click through rate
*Integrated critical nightly backup system for website,email, and databases
*Optimized MySQL/Apache/Nginx services to provide peak performance that handled spikes in traffic
*Created an automated system for system patching and updates that improved system reliability and security
*Monitored database performance and identified and addressed any performance bottlenecks

<big>Peak Positions LLC</big> 
'''SEO Project Engineer''' 
May 2005 - Nov 2005 
* Provided Customers with monthly keyword rankings reports
*Developed content pages for various keywords to improve the overall rank on that keyword
*Designed Templates in FrontPage to be used for Content Pages
*Identified and resolved project issues quickly and efficiently, minimizing their impact on project progress
*Initiated project plans and guidelines that provided a roadmap for successful completion of the project
*Implemented an effective SEO strategy that increased organic search engine rankings and doubled website visits
*Conducted keyword research, to compose SEO-friendly content titles and meta descriptions to maximize content visibility
*Evaluated keyword research to identify topics with high search volume and low competition for SEO optimization
*Cultivated a search engine optimization (SEO) strategy that increased organic search engine rankings and increased visibility on search engines.

===SKILLS===
----
*Website/ Database Design
*Linux Server Administrator
*System Administration
*Search Engine Optimization
*Customer Service
*Leadership and Teamwork
*Critical Thinking and problem solving
*Effective Time Management
*Ability to Multitask
*Ability to work Under Pressure

===EDUCATION===
----
Northwood University – Midland, MI 
Bachelor of Business Administration 
Dual Major: Management Information Systems and Management 
Graduated May 2003

Resume

2023-06-09T21:37:23Z

Brian: /* Resume */

==Resume==
----
Brian S. Nelson 
Email: brian@briansnelson.com 
Telephone: 586-921-3056 

===EXPERIENCE===
----
<big>Nexcess .NET LLC</big> 
'''Level 2 Linux Support/Tier 2 Support Analyst''' 
July 2013 - Present 
* Provided advanced troubleshooting for server issues
* Optimizing server environments for web applications.
* Diagnosing and resolving IP email blacklisting issues
* Audited hacked accounts to prevent the hack from recurring
* Resolved issues/installed redis, memcached, sphinx and varnish
* Advanced troubleshooting on CMS platforms (Magento,Wordpress,Joomla and Expression Engine)
* Stress test web sites for high availability(siege/ab testing)
* Working with clients to resolve issues via phone and ticket system
* Write and maintain internal documentation for training purposes
* Assisting with training for new technicians.
* Diagnosing mysql errors and performance issues (locks,deadlocks)
* Diagnosing/Addressing PCI compliance Issues

'''Level 1 Linux Support''' 
Oct 2012 - July 2013 
* Provided daily support to over 10,000+ clients via phone and ticket system
* Performed Website Backups and Restores from Backup Server to Live Server
* Monitored thousands of Centos web servers utilizing Apache/MySQL/PHP/PHP-FPM
* Familiarity with Linux Web hosting software (Apache httpd, FTP, SSH, MySQL, DNS)
* Experience with qmail and other parts of the djb suite (vpopmail,daemontools, djbdns, tcpserver, etc).
* Installing/upgrading web software with yum/pecl

<big>Triple Crown Ventures LLC</big> 
'''System Administrator / PHP Web Developer / Database Administrator''' 
Feb 2006 - Oct 2012 
* Provided daily server maintenance on various applications
* Qmail Server, MySQL Server, LAMP Server / Varnish Caching Server, LNMP Servers, TinyDNS Server ,Centos / Debian
* Configured Barracuda Load Balancer / Application Firewall
* Designed and Setup Wordpress Blogs / Plugins
* Designed and Developed Email Templates that resulted in a 10-15% increase in click through rate
* Designed critical nightly backup system for website,email, and databases
* Optimized MySQL/Apache/Nginx services to provide peak performance

<big>Peak Positions LLC</big> 
'''SEO Project Engineer''' 
May 2005 - Nov 2005 
* Provided Customers with monthly keyword rankings reports
* Gained expert knowledge of Organic SEO
* Developed content pages for various keywords to improve the overall rank on that keyword
* Designed Templates in FrontPage to be used for Content Pages
* Used HTML, DHTML, CSS, FrontPage, Photoshop daily

===SKILLS===
----
HTML, DHTML, Database Design, Knowledge of PHP, Cascading Style Sheets (CSS), Photoshop, Problem Solving, DNS/rDNS,SPF Records, FTP, SSH, Centos/Debian Administrator, Microsoft Office, Web Design/Development, Apache 2/MySQL, Search Engine Optimization, HTML Validation, Web Server Administration, Nginx, Varnish, Memcached, Postfix, Dovecot, Qmail

===EDUCATION===
----
Northwood University – Midland, MI 
Bachelor of Business Administration 
Dual Major: Management Information Systems and Management 
Graduated May 2003

Resume

2023-06-09T21:35:46Z

Brian: /* Resume */

How do I block a host by ASN for apache - Example

2022-03-27T17:51:08Z

Brian: /* Save the script to /blockasn/cron.script then add it to a cron */

==How do I block a host by ASN for apache - Example==

Do you have issues with bots attempting to cause issues with your site? This is can disrupt your business and cause all types of performance issue.

Working to solve this we found it best to block entire ASN's for known bad ranges.

During my investigation I found a list of known bad ASN

https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv

I took this list by downloading, and then parsing out the ASN numbers.

===Get the contents of the bad ASN list===

First create a directory to download this list to.

mkdir /blockasn

Down the above csv file:

curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list

===Parsing the ASN number===

cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2

You can use this with the following to download the ips for that ASN NUMBER, just replace ASN NUMBER

wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS[[ASN NUMBER]]&type=htaccess&api=1"

This will save the contents to file:

Example:
AS9925_htaccess.txt

Then you can copy this over to apache configuration directory:

cp AS9925_htaccess.txt /etc/httpd/conf.d/AS9925.conf

Then just restart apache and it will be blocked
sudo systemctl restart httpd.service

At this point you have blocked all the ips in that ASN

==Making a Script that you can apply to a cron to auto update the list==

#!/bin/bash
#Block bad ASN
#https://briansnelson.com/How_do_I_block_a_host_by_ASN_for_apache_-_Example
###########################
#Download List to use
curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list

#Get all the ASN lists download to your blockasn directory
for x in $(cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2| grep -v ASN); do
wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS$x&type=htaccess&api=1"
done;
#Lets add them to apache
echo '<Directory />' > /etc/httpd/conf.d/blockASN.conf;
echo 'Order Deny,Allow' >> /etc/httpd/conf.d/blockASN.conf;
cat /blockasn/AS*.txt | grep -v Order >> /etc/httpd/conf.d/blockASN.conf;
echo '</Directory>' >> /etc/httpd/conf.d/blockASN.conf;
sudo systemctl restart httpd.service

===Save the script to /blockasn/cron.script then add it to a cron===

echo '0 0 * * 6 /blockasn/cron.script >/dev/null 2>&1' >> /var/spool/cron/root
chmod +x cron.script

Now with everything setup you can easily block bad ASN from causing issues on your network, you can also add ASN that are not part of that list that you find over time, by adding an echo statement to update the badasnlist.list file before it goes into the add to apache

#!/bin/bash
#Block bad ASN
#https://briansnelson.com/How_do_I_block_a_host_by_ASN_for_apache_-_Example
###########################
#Download List to use
curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list
#Add non listed ASN numbers to auto block list
echo '32934' >> /blockasn/badasnlist.list
#Get all the ASN lists download to your blockasn directory
for x in $(cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2| grep -v ASN); do
wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS$x&type=htaccess&api=1"
done;
#Lets add them to apache
echo '<Directory />' > /etc/httpd/conf.d/blockASN.conf;
echo 'Order Deny,Allow' >> /etc/httpd/conf.d/blockASN.conf;
cat /blockasn/AS*.txt | grep -v Order >> /etc/httpd/conf.d/blockASN.conf;
echo '</Directory>' >> /etc/httpd/conf.d/blockASN.conf;
sudo systemctl restart httpd.service

Use with caution, as come copy and paste will mixup the quotes in the above script

How do I block a host by ASN for apache - Example

2022-03-27T17:50:56Z

Brian: /* Making a Script that you can apply to a cron to auto update the list */

==How do I block a host by ASN for apache - Example==

Do you have issues with bots attempting to cause issues with your site? This is can disrupt your business and cause all types of performance issue.

Working to solve this we found it best to block entire ASN's for known bad ranges.

During my investigation I found a list of known bad ASN

https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv

I took this list by downloading, and then parsing out the ASN numbers.

===Get the contents of the bad ASN list===

First create a directory to download this list to.

mkdir /blockasn

Down the above csv file:

curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list

===Parsing the ASN number===

cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2

You can use this with the following to download the ips for that ASN NUMBER, just replace ASN NUMBER

wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS[[ASN NUMBER]]&type=htaccess&api=1"

This will save the contents to file:

Example:
AS9925_htaccess.txt

Then you can copy this over to apache configuration directory:

cp AS9925_htaccess.txt /etc/httpd/conf.d/AS9925.conf

Then just restart apache and it will be blocked
sudo systemctl restart httpd.service

At this point you have blocked all the ips in that ASN

==Making a Script that you can apply to a cron to auto update the list==

#!/bin/bash
#Block bad ASN
#https://briansnelson.com/How_do_I_block_a_host_by_ASN_for_apache_-_Example
###########################
#Download List to use
curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list

#Get all the ASN lists download to your blockasn directory
for x in $(cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2| grep -v ASN); do
wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS$x&type=htaccess&api=1"
done;
#Lets add them to apache
echo '<Directory />' > /etc/httpd/conf.d/blockASN.conf;
echo 'Order Deny,Allow' >> /etc/httpd/conf.d/blockASN.conf;
cat /blockasn/AS*.txt | grep -v Order >> /etc/httpd/conf.d/blockASN.conf;
echo '</Directory>' >> /etc/httpd/conf.d/blockASN.conf;
sudo systemctl restart httpd.service

===Save the script to /blockasn/cron.script then add it to a cron===

echo '0 0 * * 6 /blockasn/cron.script >/dev/null 2>&1' >> /var/spool/cron/root
chmod +x cron.script

Now with everything setup you can easily block bad ASN from causing issues on your network, you can also add ASN that are not part of that list that you find over time, by adding an echo statement to update the badasnlist.list file before it goes into the add to apache

#!/bin/bash
#Block bad ASN
#https://briansnelson.com/
###########################
#Download List to use
curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list
#Add non listed ASN numbers to auto block list
echo '32934' >> /blockasn/badasnlist.list
#Get all the ASN lists download to your blockasn directory
for x in $(cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2| grep -v ASN); do
wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS$x&type=htaccess&api=1"
done;
#Lets add them to apache
echo '<Directory />' > /etc/httpd/conf.d/blockASN.conf;
echo 'Order Deny,Allow' >> /etc/httpd/conf.d/blockASN.conf;
cat /blockasn/AS*.txt | grep -v Order >> /etc/httpd/conf.d/blockASN.conf;
echo '</Directory>' >> /etc/httpd/conf.d/blockASN.conf;
sudo systemctl restart httpd.service

Use with caution, as come copy and paste will mixup the quotes in the above script

How do I block a host by ASN for apache - Example

2022-03-27T17:41:32Z

Brian: /* Save the script to /blockasn/cron.script then add it to a cron */

==How do I block a host by ASN for apache - Example==

Do you have issues with bots attempting to cause issues with your site? This is can disrupt your business and cause all types of performance issue.

Working to solve this we found it best to block entire ASN's for known bad ranges.

During my investigation I found a list of known bad ASN

https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv

I took this list by downloading, and then parsing out the ASN numbers.

===Get the contents of the bad ASN list===

First create a directory to download this list to.

mkdir /blockasn

Down the above csv file:

curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list

===Parsing the ASN number===

cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2

You can use this with the following to download the ips for that ASN NUMBER, just replace ASN NUMBER

wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS[[ASN NUMBER]]&type=htaccess&api=1"

This will save the contents to file:

Example:
AS9925_htaccess.txt

Then you can copy this over to apache configuration directory:

cp AS9925_htaccess.txt /etc/httpd/conf.d/AS9925.conf

Then just restart apache and it will be blocked
sudo systemctl restart httpd.service

At this point you have blocked all the ips in that ASN

==Making a Script that you can apply to a cron to auto update the list==

#!/bin/bash
#Block bad ASN
#https://briansnelson.com/
###########################
#Download List to use
curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list

#Get all the ASN lists download to your blockasn directory
for x in $(cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2| grep -v ASN); do
wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS$x&type=htaccess&api=1"
done;
#Lets add them to apache
echo '<Directory />' > /etc/httpd/conf.d/blockASN.conf;
echo 'Order Deny,Allow' >> /etc/httpd/conf.d/blockASN.conf;
cat /blockasn/AS*.txt | grep -v Order >> /etc/httpd/conf.d/blockASN.conf;
echo '</Directory>' >> /etc/httpd/conf.d/blockASN.conf;
sudo systemctl restart httpd.service

===Save the script to /blockasn/cron.script then add it to a cron===

echo '0 0 * * 6 /blockasn/cron.script >/dev/null 2>&1' >> /var/spool/cron/root
chmod +x cron.script

Now with everything setup you can easily block bad ASN from causing issues on your network, you can also add ASN that are not part of that list that you find over time, by adding an echo statement to update the badasnlist.list file before it goes into the add to apache

#!/bin/bash
#Block bad ASN
#https://briansnelson.com/
###########################
#Download List to use
curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list
#Add non listed ASN numbers to auto block list
echo '32934' >> /blockasn/badasnlist.list
#Get all the ASN lists download to your blockasn directory
for x in $(cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2| grep -v ASN); do
wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS$x&type=htaccess&api=1"
done;
#Lets add them to apache
echo '<Directory />' > /etc/httpd/conf.d/blockASN.conf;
echo 'Order Deny,Allow' >> /etc/httpd/conf.d/blockASN.conf;
cat /blockasn/AS*.txt | grep -v Order >> /etc/httpd/conf.d/blockASN.conf;
echo '</Directory>' >> /etc/httpd/conf.d/blockASN.conf;
sudo systemctl restart httpd.service

Use with caution, as come copy and paste will mixup the quotes in the above script

How do I block a host by ASN for apache - Example

2022-03-27T17:41:24Z

Brian: /* Making a Script that you can apply to a cron to auto update the list */

==How do I block a host by ASN for apache - Example==

Do you have issues with bots attempting to cause issues with your site? This is can disrupt your business and cause all types of performance issue.

Working to solve this we found it best to block entire ASN's for known bad ranges.

During my investigation I found a list of known bad ASN

https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv

I took this list by downloading, and then parsing out the ASN numbers.

===Get the contents of the bad ASN list===

First create a directory to download this list to.

mkdir /blockasn

Down the above csv file:

curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list

===Parsing the ASN number===

cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2

You can use this with the following to download the ips for that ASN NUMBER, just replace ASN NUMBER

wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS[[ASN NUMBER]]&type=htaccess&api=1"

This will save the contents to file:

Example:
AS9925_htaccess.txt

Then you can copy this over to apache configuration directory:

cp AS9925_htaccess.txt /etc/httpd/conf.d/AS9925.conf

Then just restart apache and it will be blocked
sudo systemctl restart httpd.service

At this point you have blocked all the ips in that ASN

==Making a Script that you can apply to a cron to auto update the list==

#!/bin/bash
#Block bad ASN
#https://briansnelson.com/
###########################
#Download List to use
curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list

#Get all the ASN lists download to your blockasn directory
for x in $(cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2| grep -v ASN); do
wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS$x&type=htaccess&api=1"
done;
#Lets add them to apache
echo '<Directory />' > /etc/httpd/conf.d/blockASN.conf;
echo 'Order Deny,Allow' >> /etc/httpd/conf.d/blockASN.conf;
cat /blockasn/AS*.txt | grep -v Order >> /etc/httpd/conf.d/blockASN.conf;
echo '</Directory>' >> /etc/httpd/conf.d/blockASN.conf;
sudo systemctl restart httpd.service

===Save the script to /blockasn/cron.script then add it to a cron===

echo '0 0 * * 6 /blockasn/cron.script >/dev/null 2>&1' >> /var/spool/cron/root
chmod +x cron.script

Now with everything setup you can easily block bad ASN from causing issues on your network, you can also add ASN that are not part of that list that you find over time, by adding an echo statement to update the badasnlist.list file before it goes into the add to apache

#!/bin/bash
#Block bad ASN
#https://briansnelson.com/
###########################
#Download List to use
curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list
#Add non listed ASN numbers to auto block list
echo '32934' >> /blockasn/badasnlist.list
#Get all the ASN lists download to your blockasn directory
for x in $(cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2| grep -v ASN); do
wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS$x&type=htaccess&api=1"
done;
#Lets add them to apache
echo '<Directory />' > /etc/httpd/conf.d/blockASN.conf;
echo 'Order Deny,Allow' >> /etc/httpd/conf.d/blockASN.conf;
cat //blockasn/AS*.txt | grep -v Order >> /etc/httpd/conf.d/blockASN.conf;
echo '</Directory>' >> /etc/httpd/conf.d/blockASN.conf;
sudo systemctl restart httpd.service

Use with caution, as come copy and paste will mixup the quotes in the above script

How do I block a host by ASN for apache - Example

2022-03-27T17:38:05Z

Brian: /* Save the script to /blockasn/cron.script then add it to a cron */

==How do I block a host by ASN for apache - Example==

Do you have issues with bots attempting to cause issues with your site? This is can disrupt your business and cause all types of performance issue.

Working to solve this we found it best to block entire ASN's for known bad ranges.

During my investigation I found a list of known bad ASN

https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv

I took this list by downloading, and then parsing out the ASN numbers.

===Get the contents of the bad ASN list===

First create a directory to download this list to.

mkdir /blockasn

Down the above csv file:

curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list

===Parsing the ASN number===

cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2

You can use this with the following to download the ips for that ASN NUMBER, just replace ASN NUMBER

wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS[[ASN NUMBER]]&type=htaccess&api=1"

This will save the contents to file:

Example:
AS9925_htaccess.txt

Then you can copy this over to apache configuration directory:

cp AS9925_htaccess.txt /etc/httpd/conf.d/AS9925.conf

Then just restart apache and it will be blocked
sudo systemctl restart httpd.service

At this point you have blocked all the ips in that ASN

==Making a Script that you can apply to a cron to auto update the list==

#!/bin/bash
#Block bad ASN
#https://briansnelson.com/
###########################
#Download List to use
curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list

#Get all the ASN lists download to your blockasn directory
for x in $(cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2| grep -v ASN); do
wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS$x&type=htaccess&api=1"
done;
#Lets add them to apache
echo '<Directory />' > /etc/httpd/conf.d/blockASN.conf;
echo 'Order Deny,Allow' >> /etc/httpd/conf.d/blockASN.conf;
cat //blockasn/AS*.txt | grep -v Order >> /etc/httpd/conf.d/blockASN.conf;
echo '</Directory>' >> /etc/httpd/conf.d/blockASN.conf;
sudo systemctl restart httpd.service

===Save the script to /blockasn/cron.script then add it to a cron===

echo '0 0 * * 6 /blockasn/cron.script >/dev/null 2>&1' >> /var/spool/cron/root
chmod +x cron.script

Now with everything setup you can easily block bad ASN from causing issues on your network, you can also add ASN that are not part of that list that you find over time, by adding an echo statement to update the badasnlist.list file before it goes into the add to apache

#!/bin/bash
#Block bad ASN
#https://briansnelson.com/
###########################
#Download List to use
curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list
#Add non listed ASN numbers to auto block list
echo '32934' >> /blockasn/badasnlist.list
#Get all the ASN lists download to your blockasn directory
for x in $(cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2| grep -v ASN); do
wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS$x&type=htaccess&api=1"
done;
#Lets add them to apache
echo '<Directory />' > /etc/httpd/conf.d/blockASN.conf;
echo 'Order Deny,Allow' >> /etc/httpd/conf.d/blockASN.conf;
cat //blockasn/AS*.txt | grep -v Order >> /etc/httpd/conf.d/blockASN.conf;
echo '</Directory>' >> /etc/httpd/conf.d/blockASN.conf;
sudo systemctl restart httpd.service

Use with caution, as come copy and paste will mixup the quotes in the above script

How do I block a host by ASN for apache - Example

2022-03-27T17:37:13Z

Brian: /* Making a Script that you can apply to a cron to auto update the list */

==How do I block a host by ASN for apache - Example==

Do you have issues with bots attempting to cause issues with your site? This is can disrupt your business and cause all types of performance issue.

Working to solve this we found it best to block entire ASN's for known bad ranges.

During my investigation I found a list of known bad ASN

https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv

I took this list by downloading, and then parsing out the ASN numbers.

===Get the contents of the bad ASN list===

First create a directory to download this list to.

mkdir /blockasn

Down the above csv file:

curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list

===Parsing the ASN number===

cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2

You can use this with the following to download the ips for that ASN NUMBER, just replace ASN NUMBER

wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS[[ASN NUMBER]]&type=htaccess&api=1"

This will save the contents to file:

Example:
AS9925_htaccess.txt

Then you can copy this over to apache configuration directory:

cp AS9925_htaccess.txt /etc/httpd/conf.d/AS9925.conf

Then just restart apache and it will be blocked
sudo systemctl restart httpd.service

At this point you have blocked all the ips in that ASN

==Making a Script that you can apply to a cron to auto update the list==

#!/bin/bash
#Block bad ASN
#https://briansnelson.com/
###########################
#Download List to use
curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list

#Get all the ASN lists download to your blockasn directory
for x in $(cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2| grep -v ASN); do
wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS$x&type=htaccess&api=1"
done;
#Lets add them to apache
echo '<Directory />' > /etc/httpd/conf.d/blockASN.conf;
echo 'Order Deny,Allow' >> /etc/httpd/conf.d/blockASN.conf;
cat //blockasn/AS*.txt | grep -v Order >> /etc/httpd/conf.d/blockASN.conf;
echo '</Directory>' >> /etc/httpd/conf.d/blockASN.conf;
sudo systemctl restart httpd.service

===Save the script to /blockasn/cron.script then add it to a cron===

echo '0 0 * * 6 /blockasn/cron.script >/dev/null 2>&1' > /var/spool/cron/root
chmod +x cron.script

Now with everything setup you can easily block bad ASN from causing issues on your network, you can also add ASN that are not part of that list that you find over time, by adding an echo statement to update the badasnlist.list file before it goes into the add to apache

#!/bin/bash
#Block bad ASN
#https://briansnelson.com/
###########################
#Download List to use
curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list
#Add non listed ASN numbers to auto block list
echo '32934' >> /blockasn/badasnlist.list
#Get all the ASN lists download to your blockasn directory
for x in $(cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2| grep -v ASN); do
wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS$x&type=htaccess&api=1"
done;
#Lets add them to apache
echo '<Directory />' > /etc/httpd/conf.d/blockASN.conf;
echo 'Order Deny,Allow' >> /etc/httpd/conf.d/blockASN.conf;
cat //blockasn/AS*.txt | grep -v Order >> /etc/httpd/conf.d/blockASN.conf;
echo '</Directory>' >> /etc/httpd/conf.d/blockASN.conf;
sudo systemctl restart httpd.service

Use with caution, as come copy and paste will mixup the quotes in the above script

How do I block a host by ASN for apache - Example

2022-03-27T17:37:02Z

Brian: /* Save the script to /blockasn/cron.script then add it to a cron */

==How do I block a host by ASN for apache - Example==

Do you have issues with bots attempting to cause issues with your site? This is can disrupt your business and cause all types of performance issue.

Working to solve this we found it best to block entire ASN's for known bad ranges.

During my investigation I found a list of known bad ASN

https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv

I took this list by downloading, and then parsing out the ASN numbers.

===Get the contents of the bad ASN list===

First create a directory to download this list to.

mkdir /blockasn

Down the above csv file:

curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list

===Parsing the ASN number===

cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2

You can use this with the following to download the ips for that ASN NUMBER, just replace ASN NUMBER

wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS[[ASN NUMBER]]&type=htaccess&api=1"

This will save the contents to file:

Example:
AS9925_htaccess.txt

Then you can copy this over to apache configuration directory:

cp AS9925_htaccess.txt /etc/httpd/conf.d/AS9925.conf

Then just restart apache and it will be blocked
sudo systemctl restart httpd.service

At this point you have blocked all the ips in that ASN

==Making a Script that you can apply to a cron to auto update the list==

#!/bin/bash
#Block bad ASN
#https://briansnelson.com/
###########################
#Make the working directory
mkdir /blockasn
#Download List to use
curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list

#Get all the ASN lists download to your blockasn directory
for x in $(cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2| grep -v ASN); do
wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS$x&type=htaccess&api=1"
done;
#Lets add them to apache
echo '<Directory />' > /etc/httpd/conf.d/blockASN.conf;
echo 'Order Deny,Allow' >> /etc/httpd/conf.d/blockASN.conf;
cat //blockasn/AS*.txt | grep -v Order >> /etc/httpd/conf.d/blockASN.conf;
echo '</Directory>' >> /etc/httpd/conf.d/blockASN.conf;
sudo systemctl restart httpd.service

===Save the script to /blockasn/cron.script then add it to a cron===

echo '0 0 * * 6 /blockasn/cron.script >/dev/null 2>&1' > /var/spool/cron/root
chmod +x cron.script

Now with everything setup you can easily block bad ASN from causing issues on your network, you can also add ASN that are not part of that list that you find over time, by adding an echo statement to update the badasnlist.list file before it goes into the add to apache

#!/bin/bash
#Block bad ASN
#https://briansnelson.com/
###########################
#Download List to use
curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list
#Add non listed ASN numbers to auto block list
echo '32934' >> /blockasn/badasnlist.list
#Get all the ASN lists download to your blockasn directory
for x in $(cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2| grep -v ASN); do
wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS$x&type=htaccess&api=1"
done;
#Lets add them to apache
echo '<Directory />' > /etc/httpd/conf.d/blockASN.conf;
echo 'Order Deny,Allow' >> /etc/httpd/conf.d/blockASN.conf;
cat //blockasn/AS*.txt | grep -v Order >> /etc/httpd/conf.d/blockASN.conf;
echo '</Directory>' >> /etc/httpd/conf.d/blockASN.conf;
sudo systemctl restart httpd.service

Use with caution, as come copy and paste will mixup the quotes in the above script

How do I block a host by ASN for apache - Example

2022-03-27T17:35:06Z

Brian: /* Making a Script that you can apply to a cron to auto update the list */

==How do I block a host by ASN for apache - Example==

Do you have issues with bots attempting to cause issues with your site? This is can disrupt your business and cause all types of performance issue.

Working to solve this we found it best to block entire ASN's for known bad ranges.

During my investigation I found a list of known bad ASN

https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv

I took this list by downloading, and then parsing out the ASN numbers.

===Get the contents of the bad ASN list===

First create a directory to download this list to.

mkdir /blockasn

Down the above csv file:

curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list

===Parsing the ASN number===

cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2

You can use this with the following to download the ips for that ASN NUMBER, just replace ASN NUMBER

wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS[[ASN NUMBER]]&type=htaccess&api=1"

This will save the contents to file:

Example:
AS9925_htaccess.txt

Then you can copy this over to apache configuration directory:

cp AS9925_htaccess.txt /etc/httpd/conf.d/AS9925.conf

Then just restart apache and it will be blocked
sudo systemctl restart httpd.service

At this point you have blocked all the ips in that ASN

==Making a Script that you can apply to a cron to auto update the list==

#!/bin/bash
#Block bad ASN
#https://briansnelson.com/
###########################
#Make the working directory
mkdir /blockasn
#Download List to use
curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list

#Get all the ASN lists download to your blockasn directory
for x in $(cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2| grep -v ASN); do
wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS$x&type=htaccess&api=1"
done;
#Lets add them to apache
echo '<Directory />' > /etc/httpd/conf.d/blockASN.conf;
echo 'Order Deny,Allow' >> /etc/httpd/conf.d/blockASN.conf;
cat //blockasn/AS*.txt | grep -v Order >> /etc/httpd/conf.d/blockASN.conf;
echo '</Directory>' >> /etc/httpd/conf.d/blockASN.conf;
sudo systemctl restart httpd.service

===Save the script to /blockasn/cron.script then add it to a cron===

echo '0 0 * * 6 /blockasn/cron.script >/dev/null 2>&1' > /var/spool/cron/root

Now with everything setup you can easily block bad ASN from causing issues on your network, you can also add ASN that are not part of that list that you find over time, by adding an echo statement to update the badasnlist.list file before it goes into the add to apache

#!/bin/bash
#Block bad ASN
#https://briansnelson.com/
###########################
#Make the working directory
mkdir /blockasn
#Download List to use
curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list
#Add non listed ASN numbers to auto block list
echo '32934' >> /blockasn/badasnlist.list
#Get all the ASN lists download to your blockasn directory
for x in $(cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2| grep -v ASN); do
wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS$x&type=htaccess&api=1"
done;
#Lets add them to apache
echo '<Directory />' > /etc/httpd/conf.d/blockASN.conf;
echo 'Order Deny,Allow' >> /etc/httpd/conf.d/blockASN.conf;
cat //blockasn/AS*.txt | grep -v Order >> /etc/httpd/conf.d/blockASN.conf;
echo '</Directory>' >> /etc/httpd/conf.d/blockASN.conf;
sudo systemctl restart httpd.service

Use with caution, as come copy and paste will mixup the quotes in the above script

How do I block a host by ASN for apache - Example

2022-03-27T17:33:41Z

Brian: Created page with "==How do I block a host by ASN for apache - Example== Do you have issues with bots attempting to cause issues with your site? This is can disrupt your business and cause all..."

==How do I block a host by ASN for apache - Example==

Do you have issues with bots attempting to cause issues with your site? This is can disrupt your business and cause all types of performance issue.

Working to solve this we found it best to block entire ASN's for known bad ranges.

During my investigation I found a list of known bad ASN

https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv

I took this list by downloading, and then parsing out the ASN numbers.

===Get the contents of the bad ASN list===

First create a directory to download this list to.

mkdir /blockasn

Down the above csv file:

curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list

===Parsing the ASN number===

cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2

You can use this with the following to download the ips for that ASN NUMBER, just replace ASN NUMBER

wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS[[ASN NUMBER]]&type=htaccess&api=1"

This will save the contents to file:

Example:
AS9925_htaccess.txt

Then you can copy this over to apache configuration directory:

cp AS9925_htaccess.txt /etc/httpd/conf.d/AS9925.conf

Then just restart apache and it will be blocked
sudo systemctl restart httpd.service

At this point you have blocked all the ips in that ASN

==Making a Script that you can apply to a cron to auto update the list==

#!/bin/bash
#Block bad ASN
#https://briansnelson.com/
#Download List to use
curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list

#Get all the ASN lists download to your blockasn directory
for x in $(cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2| grep -v ASN); do
wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS$x&type=htaccess&api=1"
done;
#Lets add them to apache
echo '<Directory />' > /etc/httpd/conf.d/blockASN.conf;
echo 'Order Deny,Allow' >> /etc/httpd/conf.d/blockASN.conf;
cat //blockasn/AS*.txt | grep -v Order >> /etc/httpd/conf.d/blockASN.conf;
echo '</Directory>' >> /etc/httpd/conf.d/blockASN.conf;
sudo systemctl restart httpd.service

===Save the script to /blockasn/cron.script then add it to a cron===

echo '0 0 * * 6 /blockasn/cron.script >/dev/null 2>&1' > /var/spool/cron/root

Now with everything setup you can easily block bad ASN from causing issues on your network, you can also add ASN that are not part of that list that you find over time, by adding an echo statement to update the badasnlist.list file before it goes into the add to apache

#!/bin/bash
#Block bad ASN
#https://briansnelson.com/
#Download List to use
curl https://raw.githubusercontent.com/brianhama/bad-asn-list/master/bad-asn-list.csv > /blockasn/badasnlist.list
#Add non listed ASN numbers to auto block list
echo '32934' >> /blockasn/badasnlist.list
#Get all the ASN lists download to your blockasn directory
for x in $(cat /blockasn/badasnlist.list | awk -F',' '{print $1}' | cut -d'"' -f2| grep -v ASN); do
wget --content-disposition "https://www.enjen.net/asn-blocklist/index.php?asn=AS$x&type=htaccess&api=1"
done;
#Lets add them to apache
echo '<Directory />' > /etc/httpd/conf.d/blockASN.conf;
echo 'Order Deny,Allow' >> /etc/httpd/conf.d/blockASN.conf;
cat //blockasn/AS*.txt | grep -v Order >> /etc/httpd/conf.d/blockASN.conf;
echo '</Directory>' >> /etc/httpd/conf.d/blockASN.conf;
sudo systemctl restart httpd.service

Use with caution, as come copy and paste will mixup the quotes in the above script

Main Page

2022-03-27T17:06:06Z

Brian: /* Apache/PHP */

==Welcome to Ramblings of a Centos Ninja==

[[File:Centos-logo.png|100px|frameless|right|alt=Centos How-Tos]]
===Centos 7===
--> [[Install Remi and EPEL yum repo Centos 7]]
--> [[Install Mysql Database Centos 7]]
--> [[Install Apache Web Server Centos 7]]
--> [[Install PHP/PHP-FPM 5.4 Centos 7]]
--> [[Install (LAMP) Linux Apache MySQL and PHP Centos 7]]
--> [[Install Redis on Centos 7 How To]]
--> [[How To Configure SWAP on Centos 7]]
--> [[How to find user memory usage in linux]]
--> [[How to Configure letsencrypt with Apache on Centos 7 Server]]
--> [[How to configure Gmail as a Mail Relay with Postfix]]
--> [[How use GeoIP on the command line Centos7]]
--> [[Protecting Folders with .htpasswd/.htaccess]]
--> [[Linux setfacl command]]
--> [[How to disable SSH timeout]] [[File:New.jpg|35px|frameless]]
--> [[How to Install Squid Proxy Server on Cento7]] [[File:New.jpg|35px|frameless]]
--> [[How To Use Systemctl to Manage Systemd Services]]

===Centos 6===
--> [[Change Runlevel]]
--> [[Check Current Runlevel]]
--> [[Change Run Level at Bootup]]
--> [[How to change the Hostname on Centos]]
--> [[chkconfig settings]]
--> [[How to extract a tar.gz file]]
--> [[Install SIM - System Integrity Monitor]]
--> [[Use Bash on a Non Bash User]]
--> [[Quit Bash Shell without Saving Bash History]]
--> [[Change the Timezone Centos]]
--> [[Check the Version of Package]]
--> [[How to install Sphinx on Centos Server]]
--> [[How to install Redis on a Centos 6.4 Server]]
--> [[Basic Redis commands - Cheat Sheet]]
--> [[Adding a New Disk Drive with Centos]]
--> [[Creating Backups using rsync with Examples]]
--> [[Expand your bash_history to 2500]]
--> [[Setup logrotate to rotate your logs]]
--> [[GPG: Encrypt And Decrypt Files With A Password]]
--> [[Install Remi and EPEL yum repo]]
--> [[Install NewRelic on Centos6]]
--> [[Setting Up An NFS Server And Client On CentOS 6]]
--> [[Sar is not working how to restart]]
--> [[Batch jpeg Image Optimization]]
--> [[Howto Block or Open HTTP/HTTPs Ports IPTables]]
--> [[Reset Root Password in CentOS]]
--> [[Setup vsftp with SELinux]]
--> [[Howto Setup NTP on CentOS]]
--> [[Fix corrupted RPM database]]
--> [[Crontab Usage]]
--> [[Make an ISO from a Folder with mkisofs]]
--> [[How to setup a VPN server with CentOS PPTPD]]
--> [[APF Firewall -Advanced Policy Firewall - Basics]]
--> [[How to Block Bittorrent Traffic with IPtables]]
--> [[How to find user memory usage in linux]]
--> [[How to install ccsrch on Centos 6]]
--> [[How to install jpegoptim for CentOS]]
--> [[How to install optipng for CentOS]]
--> [[How to install gifsicle for CentOS]]
--> [[How to install jpegtran for CentOS]]
--> [[IPTABLES quick command list]]
--> [[Linux setfacl command]]
--> [[Postfix Mail Queue Commands for Reviewing Emails]]

[[File:Magentos.jpg|100px|frameless|right|alt=Magento How To's]]

===Magento Community Edition/Magento Enterprise Edition===
--> [[What is Magento?]]
--> [[Clear Magento Cache]]
--> [[Disable Magento Modules]]
--> [[Turn on Manual Indexing]]
--> [[How to Reset Magento Password]]
--> [[How to Create Users in Mageento]]
--> [[Enable Mysql Slow Query Logging]]
--> [[Magento Connect is not Working]]
--> [[Magento will NOT save my Product Updates]]
--> [[Magento Internal Cron not Running]]
--> [[Setting up the System Cron Job]]
--> [[Magento Connect is not Working]]
--> [[Changing the Minimum Search Query - MySQL Full Text Only]]
--> [[Install Redis Caching for Magento]]
--> [[Install Redis Full Page Caching for Magento Enterprise]]
--> [[Setting up a Second Instance of Redis]]
--> [[Magento Setup Return-Path Email]]
--> [[Magento Server Compatibility Check]]
--> [[Magento Database Optimization - Log Cleaning Script]]
--> [[Magento Site Performance Optimization]]
--> [[Magento Log Rotate with logrotate]]
--> [[How to use CDN with Webfonts with Magento]]
--> [[How to Disable Magento Newsletter Module]]
--> [[Magento : Execute Custom Module Cron Manually]]

[[File:Magentos.jpg|100px|frameless|right|alt=Magento2 How To's]]

===Magento 2 Community Edition===
--> [[Upgrade Magento2 via CLI]]
--> [[Enable/Disable Magento2 Maintenance Page]]
--> [[How to set Magento 2 permissions and avoid installation errors]]
--> [[How to speed up Magento 2 out of the box]]
--> [[How to Change Magento 2 mode]]
--> [[How to Enable Disable Magento 2 caches]]
--> [[Magento 2 How to Add Alternative HTTP headers]]
--> [[Magento 2 Purge Varnish Cache]]
--> [[Magento 2 Redis Page Cache and Default Cache Example]]
--> [[Magento 2 How to check Magento Version]]
--> [[Magento 2 Reindex Error: Index is locked by another reindex process. Skipping]]
--> [[Magento 2 Reindex via the CLI]]
--> [[Magento 2 Custom 503 Maintenance page]]

[[File:Memcahed.jpg|100px|frameless|right|alt=Memcache Caching]]

===Memcached Server===
--> [[Memcached Monitor Tool]]
--> [[Setup Multi Instance Memcache]]
--> [[Check if Memcached is Running]]
--> [[Flush Your Memcached Instance]]
--> [[Check Memory Usage of Memcached]]
--> [[Memcache running out of Memory?]]
--> [[Memcached List all Keys]]

[[File:Apachelogo.gif|100px|right|alt=Apache How Tos]]

===Apache/PHP===

--> [[Deny access to my site with an .htaccess file]]
--> [[Redirect site to www or non www]]
--> [[Restrict POST request to Website]]
--> [[Install Tomcat6 Server on Centos 6]]
--> [[How to setup an SSL Certificate for Free]]
--> [[Enable Apache to Create Core Dumps]]
--> [[Enable php-fpm to create core dumps]]
--> [[Debug PHP Enabling slow_log]]
--> [[Block Bots by User Agent String]]
--> [[Install mod_extact_forward - Show Real IP behind Proxy]]
--> [[Install ionCube Loaders for Centos]]
--> [[Install Zend Guard with PHP 5.3 on Centos]]
--> [[Install Zend Guard 6.0 with PHP 5.4 on Centos]]
--> [[Disable Mod_Security for a single vhost]]
--> [[Hide PHP Version(X-Powered-By) in Headers]]
--> [[Sessions are ending before MaxLifetime]]
--> [[Apache mod_speling case insensitive urls issue]]
--> [[Restrict access via htaccess via ipaddress]]
--> [[Howto install mod_evasive with fail2ban]]
--> [[Install the Latest version PHP on CentOS]]
--> [[How to bypass .htpasswd for certain IPs Apache]]
--> [[Clear mod_pagespeed cache ]]
--> [[Install GeoIP for Apache and PHP]]
--> [[How to block or allow countries using GeoIP and .htaccess]]
--> [[How to disable mod_security per vhost]]
--> [[Force HTTPS for entire website via htaccess]]
--> [[Restrict Access to wp-login.php and xmlrpc.php]]
--> [[The X-Frame-Options response header]]
--> [[Install Xdebug with php-fpm per pool]]
--> [[How to Enable Gzip Compression]]
--> [[Enable Apache rewrite logging]]
--> [[Protecting Folders with .htpasswd/.htaccess]]
--> [[How to Disable PHP Execution in Certain Directories]]
--> [[Directory listing in htaccess. Allow, Deny, Disable, Enable Directory Listing in .htaccess]]
--> [[What is the Cache-Control Header]]
--> [[How do I block a host by ASN for apache - Example]]
[[File:Haproxy.png|100px|frameless|right|alt=Mysql Percona]]

===HAProxy===
--> [[What is HAProxy]]
--> [[HAProxy vs Nginx]]
--> [[HAProxy Load Balancing]]
--> [[HAProxy Cluster Setup Example]]
--> [[HAProxy Docker]]
--> [[HAProxy with Varnish SSL Termination Example]]
--> [[HAProxy http2]]
--> [[HAProxy GUI]]
--> [[HAProxy Install on Centos7]]
--> [[HAProxy Cloud Load Balancer]]
--> [[HAProxy Block by User-Agent]]
--> [[HAProxy Restrict by IP Address]]
--> [[HAProxy Redirect domain to another domain]]

[[File:Logo percona server new.png|100px|frameless|right|alt=Mysql Percona]]

===Mysql/Percona===
--> [[How to Optimize/Repair a Table]]
--> [[MySQL - Check Which Query is Consuming Resources]]
--> [[How to Set your MySQL Password]]
--> [[Rest your MySQL Admin Password]]
--> [[How to Convert Table to InnoDB]]
--> [[How to install Percona Database Server]]
--> [[How to Access the MySQL via Shell]]
--> [[How to Add a User in MySQL]]
--> [[How to Drop a User in MySQL]]
--> [[How to Create and Delete a MySQL Database]]
--> [[How to Create a Table in MySQL Database]]
--> [[How to Create a MySQL Database Backup]]
--> [[How to Import a MySQL Database]]
--> [[How to update the max_connections setting in MySQL]]
--> [[How to view a list of MySQL users and their privileges]]
--> [[Save MySQL query results into a text or CSV file]]
--> [[How to optimize a MySQL database using phpMyAdmin]]
--> [[How to solve MySQL max_user_connections error]]
--> [[How to enable Show Engine Innodb Status]]

[[File:Varnish-cache-log.jpeg|100px|frameless|right|alt=Varnish How tos]]

===Varnish Cache===
--> [[Setup Varnish Cache]]
--> [[Setup Varnish for Magento]]
--> [[Setup Varnish for Wordpress]]
--> [[Setup Varnish for MediaWiki]]
--> [[Setup Varnish - Multiple Domains]]
--> [[Setup Varnish - Multiple Ipaddress]]
--> [[Script to Clear a Page from Varnish Cache]]
--> [[Varnish will not restart WHY?]]
--> [[Warm up Varnish Script using Sitemap.xml]]
--> [[Varnish How to redirect non-www URLs to www]]
--> [[Install libvmod-header with Varnish]]

[[File:Nginx-logo.png|100px|frameless|right|Install Nginx|alt=Nginx How tos]]

===Nginx Web Server===
--> [[Setup Nginx PHP FPM Percona Mysql]]
--> [[Wordpress Ngnix Rewrite Rules]]
--> [[Setup up Nginx Caching]]
--> [[Nginx Magento vhost Configuration]]
--> [[Basic HTTP Authentication with Nginx]]
--> [[Protecting Folders with Nginx]]
--> [[403 Forbidden Error Nginx - How to Solve]]

[[File:Sword-of-Omens-Sword1.png|100px|frameless|right|alt=Brian Nelson]]

===Other===
--> [[How to add trusted root certificates]]
--> [[Find:_10_Useful_Examples_of_Find]]
--> [[Send email from PHP to a log file instead of sendmail]]
--> [[Debugging Wordpress]]
--> [[How to install Linux via USB]]
--> [[Network Subnet Mask Cheat Sheet]]
--> [[Linux Keyboard Shortcuts]]
--> [[Setup a SSH Tunnel for Secure Browsing]]
--> [[Install OpenSSH on Windows]]
--> [[Install Qmail on a Fresh Centos Server]]
--> [[Setup Qmail to Listen on port 587 for SMTP]]
--> [[Qmail catch-all account with vpopmail]]
--> [[Setup Incoming Email Pipe to Script for Qmail]]
--> [[Qmail Control Files]]
--> [[Install qmqtool for Qmail on Centos Server]]
--> [[Rest Email Password for vpopmail]]
--> [[How to check Used IP on your Home Network]]
--> [[How to find GMAIL IPs to allow at Firewall]]
--> [[Useful TCPDUMP commands]]
--> [[Remove Email Block Lists]]
--> [[How to disable qmail vpopmail email user]]
--> [[Git Cheat Sheet - Git made easy]]
--> [[Top Chmod Command Examples for Beginners]]
--> [[Benchmarking and Load Testing with Siege]]
--> [[Benchmarking and Load Testing with Apache Bench(AB)]]
--> [[How do I find out more about socket files in /proc/fd]]
--> [[How to Disable the wp-cron.php in WordPress]]
--> [[How to delete mail queue in Postfix]]

--> [[Top Command Line Games - Linux CLI Games]] Cause Linux can be fun

--> [[Centos Oneliners]]

--> [[Bash Script to Check Memory with Email Alert when Low]]
--> [[Bash Script to Check Site Code Status with Email Alert]]

How to enable Show Engine Innodb Status

2022-02-25T03:55:08Z

Brian: /* How to enable Show Engine Innodb Status */

==How to enable Show Engine Innodb Status==

Are you trying to see the latest deadlocks or foreign key errors but run in to the following error:

[Error Code: 1227, SQL State: 42000] Access denied; you need (at least one of) the PROCESS privilege(s) for this operation

When this happens you will need to grant your user the PROCESS privilege.

GRANT SELECT, PROCESS ON *.* TO '<youruser>'@'localhost';

===Creating a new user to view Show Engine Innodb Status===

Sometimes you find that a client or yourself wants to view Show Engine Innodb Status and they want a new user to do this with.

Here are the standard commands to create and grant them the privileges:

CREATE USER '<newuser>'@'%' IDENTIFIED BY '<password>';
GRANT SELECT, PROCESS ON *.* TO '<newuser>'@'%';
FLUSH PRIVILEGES;

This is the bare minimum to enable them to run (Show Engine Innodb Status)

How to enable Show Engine Innodb Status

2022-02-25T03:54:40Z

Brian: Created page with "==How to enable Show Engine Innodb Status== Are you trying to see the latest deadlocks or foreign key errors but run in to the following error: [Error Code: 1227, SQL State:..."

==How to enable Show Engine Innodb Status==

Are you trying to see the latest deadlocks or foreign key errors but run in to the following error:

[Error Code: 1227, SQL State: 42000] Access denied; you need (at least one of) the PROCESS privilege(s) for this operation

When this happens you will need to grant your user the PROCESS privilege.

GRANT SELECT, PROCESS ON *.* TO 'youruser'@'localhost';

===Creating a new user to view Show Engine Innodb Status===

Sometimes you find that a client or yourself wants to view Show Engine Innodb Status and they want a new user to do this with.

Here are the standard commands to create and grant them the privileges:

CREATE USER '<youruser>'@'%' IDENTIFIED BY '<password>';
GRANT SELECT, PROCESS ON *.* TO '<youruser>'@'%';
FLUSH PRIVILEGES;

This is the bare minimum to enable them to run (Show Engine Innodb Status)

Main Page

2022-02-25T03:47:12Z

Brian: /* Mysql/Percona */

==Welcome to Ramblings of a Centos Ninja==

[[File:Centos-logo.png|100px|frameless|right|alt=Centos How-Tos]]
===Centos 7===
--> [[Install Remi and EPEL yum repo Centos 7]]
--> [[Install Mysql Database Centos 7]]
--> [[Install Apache Web Server Centos 7]]
--> [[Install PHP/PHP-FPM 5.4 Centos 7]]
--> [[Install (LAMP) Linux Apache MySQL and PHP Centos 7]]
--> [[Install Redis on Centos 7 How To]]
--> [[How To Configure SWAP on Centos 7]]
--> [[How to find user memory usage in linux]]
--> [[How to Configure letsencrypt with Apache on Centos 7 Server]]
--> [[How to configure Gmail as a Mail Relay with Postfix]]
--> [[How use GeoIP on the command line Centos7]]
--> [[Protecting Folders with .htpasswd/.htaccess]]
--> [[Linux setfacl command]]
--> [[How to disable SSH timeout]] [[File:New.jpg|35px|frameless]]
--> [[How to Install Squid Proxy Server on Cento7]] [[File:New.jpg|35px|frameless]]
--> [[How To Use Systemctl to Manage Systemd Services]]

===Centos 6===
--> [[Change Runlevel]]
--> [[Check Current Runlevel]]
--> [[Change Run Level at Bootup]]
--> [[How to change the Hostname on Centos]]
--> [[chkconfig settings]]
--> [[How to extract a tar.gz file]]
--> [[Install SIM - System Integrity Monitor]]
--> [[Use Bash on a Non Bash User]]
--> [[Quit Bash Shell without Saving Bash History]]
--> [[Change the Timezone Centos]]
--> [[Check the Version of Package]]
--> [[How to install Sphinx on Centos Server]]
--> [[How to install Redis on a Centos 6.4 Server]]
--> [[Basic Redis commands - Cheat Sheet]]
--> [[Adding a New Disk Drive with Centos]]
--> [[Creating Backups using rsync with Examples]]
--> [[Expand your bash_history to 2500]]
--> [[Setup logrotate to rotate your logs]]
--> [[GPG: Encrypt And Decrypt Files With A Password]]
--> [[Install Remi and EPEL yum repo]]
--> [[Install NewRelic on Centos6]]
--> [[Setting Up An NFS Server And Client On CentOS 6]]
--> [[Sar is not working how to restart]]
--> [[Batch jpeg Image Optimization]]
--> [[Howto Block or Open HTTP/HTTPs Ports IPTables]]
--> [[Reset Root Password in CentOS]]
--> [[Setup vsftp with SELinux]]
--> [[Howto Setup NTP on CentOS]]
--> [[Fix corrupted RPM database]]
--> [[Crontab Usage]]
--> [[Make an ISO from a Folder with mkisofs]]
--> [[How to setup a VPN server with CentOS PPTPD]]
--> [[APF Firewall -Advanced Policy Firewall - Basics]]
--> [[How to Block Bittorrent Traffic with IPtables]]
--> [[How to find user memory usage in linux]]
--> [[How to install ccsrch on Centos 6]]
--> [[How to install jpegoptim for CentOS]]
--> [[How to install optipng for CentOS]]
--> [[How to install gifsicle for CentOS]]
--> [[How to install jpegtran for CentOS]]
--> [[IPTABLES quick command list]]
--> [[Linux setfacl command]]
--> [[Postfix Mail Queue Commands for Reviewing Emails]]

[[File:Magentos.jpg|100px|frameless|right|alt=Magento How To's]]

===Magento Community Edition/Magento Enterprise Edition===
--> [[What is Magento?]]
--> [[Clear Magento Cache]]
--> [[Disable Magento Modules]]
--> [[Turn on Manual Indexing]]
--> [[How to Reset Magento Password]]
--> [[How to Create Users in Mageento]]
--> [[Enable Mysql Slow Query Logging]]
--> [[Magento Connect is not Working]]
--> [[Magento will NOT save my Product Updates]]
--> [[Magento Internal Cron not Running]]
--> [[Setting up the System Cron Job]]
--> [[Magento Connect is not Working]]
--> [[Changing the Minimum Search Query - MySQL Full Text Only]]
--> [[Install Redis Caching for Magento]]
--> [[Install Redis Full Page Caching for Magento Enterprise]]
--> [[Setting up a Second Instance of Redis]]
--> [[Magento Setup Return-Path Email]]
--> [[Magento Server Compatibility Check]]
--> [[Magento Database Optimization - Log Cleaning Script]]
--> [[Magento Site Performance Optimization]]
--> [[Magento Log Rotate with logrotate]]
--> [[How to use CDN with Webfonts with Magento]]
--> [[How to Disable Magento Newsletter Module]]
--> [[Magento : Execute Custom Module Cron Manually]]

[[File:Magentos.jpg|100px|frameless|right|alt=Magento2 How To's]]

===Magento 2 Community Edition===
--> [[Upgrade Magento2 via CLI]]
--> [[Enable/Disable Magento2 Maintenance Page]]
--> [[How to set Magento 2 permissions and avoid installation errors]]
--> [[How to speed up Magento 2 out of the box]]
--> [[How to Change Magento 2 mode]]
--> [[How to Enable Disable Magento 2 caches]]
--> [[Magento 2 How to Add Alternative HTTP headers]]
--> [[Magento 2 Purge Varnish Cache]]
--> [[Magento 2 Redis Page Cache and Default Cache Example]]
--> [[Magento 2 How to check Magento Version]]
--> [[Magento 2 Reindex Error: Index is locked by another reindex process. Skipping]]
--> [[Magento 2 Reindex via the CLI]]
--> [[Magento 2 Custom 503 Maintenance page]]

[[File:Memcahed.jpg|100px|frameless|right|alt=Memcache Caching]]

===Memcached Server===
--> [[Memcached Monitor Tool]]
--> [[Setup Multi Instance Memcache]]
--> [[Check if Memcached is Running]]
--> [[Flush Your Memcached Instance]]
--> [[Check Memory Usage of Memcached]]
--> [[Memcache running out of Memory?]]
--> [[Memcached List all Keys]]

[[File:Apachelogo.gif|100px|right|alt=Apache How Tos]]

===Apache/PHP===

--> [[Deny access to my site with an .htaccess file]]
--> [[Redirect site to www or non www]]
--> [[Restrict POST request to Website]]
--> [[Install Tomcat6 Server on Centos 6]]
--> [[How to setup an SSL Certificate for Free]]
--> [[Enable Apache to Create Core Dumps]]
--> [[Enable php-fpm to create core dumps]]
--> [[Debug PHP Enabling slow_log]]
--> [[Block Bots by User Agent String]]
--> [[Install mod_extact_forward - Show Real IP behind Proxy]]
--> [[Install ionCube Loaders for Centos]]
--> [[Install Zend Guard with PHP 5.3 on Centos]]
--> [[Install Zend Guard 6.0 with PHP 5.4 on Centos]]
--> [[Disable Mod_Security for a single vhost]]
--> [[Hide PHP Version(X-Powered-By) in Headers]]
--> [[Sessions are ending before MaxLifetime]]
--> [[Apache mod_speling case insensitive urls issue]]
--> [[Restrict access via htaccess via ipaddress]]
--> [[Howto install mod_evasive with fail2ban]]
--> [[Install the Latest version PHP on CentOS]]
--> [[How to bypass .htpasswd for certain IPs Apache]]
--> [[Clear mod_pagespeed cache ]]
--> [[Install GeoIP for Apache and PHP]]
--> [[How to block or allow countries using GeoIP and .htaccess]]
--> [[How to disable mod_security per vhost]]
--> [[Force HTTPS for entire website via htaccess]]
--> [[Restrict Access to wp-login.php and xmlrpc.php]]
--> [[The X-Frame-Options response header]]
--> [[Install Xdebug with php-fpm per pool]]
--> [[How to Enable Gzip Compression]]
--> [[Enable Apache rewrite logging]]
--> [[Protecting Folders with .htpasswd/.htaccess]]
--> [[How to Disable PHP Execution in Certain Directories]]
--> [[Directory listing in htaccess. Allow, Deny, Disable, Enable Directory Listing in .htaccess]]
--> [[What is the Cache-Control Header]]
[[File:Haproxy.png|100px|frameless|right|alt=Mysql Percona]]

===HAProxy===
--> [[What is HAProxy]]
--> [[HAProxy vs Nginx]]
--> [[HAProxy Load Balancing]]
--> [[HAProxy Cluster Setup Example]]
--> [[HAProxy Docker]]
--> [[HAProxy with Varnish SSL Termination Example]]
--> [[HAProxy http2]]
--> [[HAProxy GUI]]
--> [[HAProxy Install on Centos7]]
--> [[HAProxy Cloud Load Balancer]]
--> [[HAProxy Block by User-Agent]]
--> [[HAProxy Restrict by IP Address]]
--> [[HAProxy Redirect domain to another domain]]

[[File:Logo percona server new.png|100px|frameless|right|alt=Mysql Percona]]

===Mysql/Percona===
--> [[How to Optimize/Repair a Table]]
--> [[MySQL - Check Which Query is Consuming Resources]]
--> [[How to Set your MySQL Password]]
--> [[Rest your MySQL Admin Password]]
--> [[How to Convert Table to InnoDB]]
--> [[How to install Percona Database Server]]
--> [[How to Access the MySQL via Shell]]
--> [[How to Add a User in MySQL]]
--> [[How to Drop a User in MySQL]]
--> [[How to Create and Delete a MySQL Database]]
--> [[How to Create a Table in MySQL Database]]
--> [[How to Create a MySQL Database Backup]]
--> [[How to Import a MySQL Database]]
--> [[How to update the max_connections setting in MySQL]]
--> [[How to view a list of MySQL users and their privileges]]
--> [[Save MySQL query results into a text or CSV file]]
--> [[How to optimize a MySQL database using phpMyAdmin]]
--> [[How to solve MySQL max_user_connections error]]
--> [[How to enable Show Engine Innodb Status]]

[[File:Varnish-cache-log.jpeg|100px|frameless|right|alt=Varnish How tos]]

===Varnish Cache===
--> [[Setup Varnish Cache]]
--> [[Setup Varnish for Magento]]
--> [[Setup Varnish for Wordpress]]
--> [[Setup Varnish for MediaWiki]]
--> [[Setup Varnish - Multiple Domains]]
--> [[Setup Varnish - Multiple Ipaddress]]
--> [[Script to Clear a Page from Varnish Cache]]
--> [[Varnish will not restart WHY?]]
--> [[Warm up Varnish Script using Sitemap.xml]]
--> [[Varnish How to redirect non-www URLs to www]]
--> [[Install libvmod-header with Varnish]]

[[File:Nginx-logo.png|100px|frameless|right|Install Nginx|alt=Nginx How tos]]

===Nginx Web Server===
--> [[Setup Nginx PHP FPM Percona Mysql]]
--> [[Wordpress Ngnix Rewrite Rules]]
--> [[Setup up Nginx Caching]]
--> [[Nginx Magento vhost Configuration]]
--> [[Basic HTTP Authentication with Nginx]]
--> [[Protecting Folders with Nginx]]
--> [[403 Forbidden Error Nginx - How to Solve]]

[[File:Sword-of-Omens-Sword1.png|100px|frameless|right|alt=Brian Nelson]]

===Other===
--> [[How to add trusted root certificates]]
--> [[Find:_10_Useful_Examples_of_Find]]
--> [[Send email from PHP to a log file instead of sendmail]]
--> [[Debugging Wordpress]]
--> [[How to install Linux via USB]]
--> [[Network Subnet Mask Cheat Sheet]]
--> [[Linux Keyboard Shortcuts]]
--> [[Setup a SSH Tunnel for Secure Browsing]]
--> [[Install OpenSSH on Windows]]
--> [[Install Qmail on a Fresh Centos Server]]
--> [[Setup Qmail to Listen on port 587 for SMTP]]
--> [[Qmail catch-all account with vpopmail]]
--> [[Setup Incoming Email Pipe to Script for Qmail]]
--> [[Qmail Control Files]]
--> [[Install qmqtool for Qmail on Centos Server]]
--> [[Rest Email Password for vpopmail]]
--> [[How to check Used IP on your Home Network]]
--> [[How to find GMAIL IPs to allow at Firewall]]
--> [[Useful TCPDUMP commands]]
--> [[Remove Email Block Lists]]
--> [[How to disable qmail vpopmail email user]]
--> [[Git Cheat Sheet - Git made easy]]
--> [[Top Chmod Command Examples for Beginners]]
--> [[Benchmarking and Load Testing with Siege]]
--> [[Benchmarking and Load Testing with Apache Bench(AB)]]
--> [[How do I find out more about socket files in /proc/fd]]
--> [[How to Disable the wp-cron.php in WordPress]]
--> [[How to delete mail queue in Postfix]]

--> [[Top Command Line Games - Linux CLI Games]] Cause Linux can be fun

--> [[Centos Oneliners]]

--> [[Bash Script to Check Memory with Email Alert when Low]]
--> [[Bash Script to Check Site Code Status with Email Alert]]

Magento 2 Custom 503 Maintenance page

2021-12-10T17:51:39Z

Brian:

==Magento2 Custom 503 Maintenance Page ==

I would start off by talking about the 503 Maintenance Page and how you can customize it and let your customer know they can still contact you.

===(HTTP) 503 response code definition:===

The HyperText Transfer Protocol (HTTP) 503 Service Unavailable server error response code indicates that the server is not ready to handle the request.
Common causes are a server that is down for maintenance or that is overloaded.

Below is the basic magento2 maintenance page

[[File:503-magneto2-maintenace-page.png|800px|frameless|alt=create custom magento2 maintenance page]]

===How to Create a Custom Maintenance Page ===

You will want to navigate to your html/pub/errors directory, this is where all the changes will happen.

You will be tempted to change the 503 in html/pub/errors/default directory, however this is the wrong way to go about creating a custom 503 page, unless at some random update you want to lose your page.

First we will want to copy the html/pub/errors/default to a new directory

example:
cd html/pub/errors/
cp -rf default custom

Next go into the new custom directory and start editing your 503.phtml

Once you are all finished, you will want go back out to the html/pub/errors directory

First, you have set the xml file
cp local.xml.sample local.xml

Next you will need to edit the local.xml file to use your new custom directory files

vim local.xml

Near the top of the file you will find:

<config>
<skin>default</skin>
<report>

You will need to change this to use the custom directory:

<config>
<skin>custom</skin>
<report>

Overall you can change any of the files in this directory to have custom 503, 404 and more..

Now lets enable maintenance mode and show off your new custom 503 page

bin/magento maintenance:enable

Magento 2 Custom 503 Maintenance page

2021-12-10T17:49:39Z

Brian: Created page with "==Magento2 Custom 503 Maintenance Page == I would start off by talking about the 503 Maintenance Page and how you can customize it and let your customer know they can still c..."

File:Screen Shot 2021-12-10 at 12.44.40 PM.png

2021-12-10T17:45:08Z

Brian:

File:503-magneto2-maintenace-page.png

2021-12-10T17:14:30Z

Brian: Brian uploaded a new version of File:503-magneto2-maintenace-page.png

Magneto2 Maintenance page 503

File:503-magneto2-maintenace-page.png

2021-12-10T17:12:17Z

Brian: Magneto2 Maintenance page 503

Magneto2 Maintenance page 503

Main Page

2021-12-10T17:03:14Z

Brian: /* Magento 2 Community Edition */

==Welcome to Ramblings of a Centos Ninja==

[[File:Centos-logo.png|100px|frameless|right|alt=Centos How-Tos]]
===Centos 7===
--> [[Install Remi and EPEL yum repo Centos 7]]
--> [[Install Mysql Database Centos 7]]
--> [[Install Apache Web Server Centos 7]]
--> [[Install PHP/PHP-FPM 5.4 Centos 7]]
--> [[Install (LAMP) Linux Apache MySQL and PHP Centos 7]]
--> [[Install Redis on Centos 7 How To]]
--> [[How To Configure SWAP on Centos 7]]
--> [[How to find user memory usage in linux]]
--> [[How to Configure letsencrypt with Apache on Centos 7 Server]]
--> [[How to configure Gmail as a Mail Relay with Postfix]]
--> [[How use GeoIP on the command line Centos7]]
--> [[Protecting Folders with .htpasswd/.htaccess]]
--> [[Linux setfacl command]]
--> [[How to disable SSH timeout]] [[File:New.jpg|35px|frameless]]
--> [[How to Install Squid Proxy Server on Cento7]] [[File:New.jpg|35px|frameless]]
--> [[How To Use Systemctl to Manage Systemd Services]]

===Centos 6===
--> [[Change Runlevel]]
--> [[Check Current Runlevel]]
--> [[Change Run Level at Bootup]]
--> [[How to change the Hostname on Centos]]
--> [[chkconfig settings]]
--> [[How to extract a tar.gz file]]
--> [[Install SIM - System Integrity Monitor]]
--> [[Use Bash on a Non Bash User]]
--> [[Quit Bash Shell without Saving Bash History]]
--> [[Change the Timezone Centos]]
--> [[Check the Version of Package]]
--> [[How to install Sphinx on Centos Server]]
--> [[How to install Redis on a Centos 6.4 Server]]
--> [[Basic Redis commands - Cheat Sheet]]
--> [[Adding a New Disk Drive with Centos]]
--> [[Creating Backups using rsync with Examples]]
--> [[Expand your bash_history to 2500]]
--> [[Setup logrotate to rotate your logs]]
--> [[GPG: Encrypt And Decrypt Files With A Password]]
--> [[Install Remi and EPEL yum repo]]
--> [[Install NewRelic on Centos6]]
--> [[Setting Up An NFS Server And Client On CentOS 6]]
--> [[Sar is not working how to restart]]
--> [[Batch jpeg Image Optimization]]
--> [[Howto Block or Open HTTP/HTTPs Ports IPTables]]
--> [[Reset Root Password in CentOS]]
--> [[Setup vsftp with SELinux]]
--> [[Howto Setup NTP on CentOS]]
--> [[Fix corrupted RPM database]]
--> [[Crontab Usage]]
--> [[Make an ISO from a Folder with mkisofs]]
--> [[How to setup a VPN server with CentOS PPTPD]]
--> [[APF Firewall -Advanced Policy Firewall - Basics]]
--> [[How to Block Bittorrent Traffic with IPtables]]
--> [[How to find user memory usage in linux]]
--> [[How to install ccsrch on Centos 6]]
--> [[How to install jpegoptim for CentOS]]
--> [[How to install optipng for CentOS]]
--> [[How to install gifsicle for CentOS]]
--> [[How to install jpegtran for CentOS]]
--> [[IPTABLES quick command list]]
--> [[Linux setfacl command]]
--> [[Postfix Mail Queue Commands for Reviewing Emails]]

[[File:Magentos.jpg|100px|frameless|right|alt=Magento How To's]]

===Magento Community Edition/Magento Enterprise Edition===
--> [[What is Magento?]]
--> [[Clear Magento Cache]]
--> [[Disable Magento Modules]]
--> [[Turn on Manual Indexing]]
--> [[How to Reset Magento Password]]
--> [[How to Create Users in Mageento]]
--> [[Enable Mysql Slow Query Logging]]
--> [[Magento Connect is not Working]]
--> [[Magento will NOT save my Product Updates]]
--> [[Magento Internal Cron not Running]]
--> [[Setting up the System Cron Job]]
--> [[Magento Connect is not Working]]
--> [[Changing the Minimum Search Query - MySQL Full Text Only]]
--> [[Install Redis Caching for Magento]]
--> [[Install Redis Full Page Caching for Magento Enterprise]]
--> [[Setting up a Second Instance of Redis]]
--> [[Magento Setup Return-Path Email]]
--> [[Magento Server Compatibility Check]]
--> [[Magento Database Optimization - Log Cleaning Script]]
--> [[Magento Site Performance Optimization]]
--> [[Magento Log Rotate with logrotate]]
--> [[How to use CDN with Webfonts with Magento]]
--> [[How to Disable Magento Newsletter Module]]
--> [[Magento : Execute Custom Module Cron Manually]]

[[File:Magentos.jpg|100px|frameless|right|alt=Magento2 How To's]]

===Magento 2 Community Edition===
--> [[Upgrade Magento2 via CLI]]
--> [[Enable/Disable Magento2 Maintenance Page]]
--> [[How to set Magento 2 permissions and avoid installation errors]]
--> [[How to speed up Magento 2 out of the box]]
--> [[How to Change Magento 2 mode]]
--> [[How to Enable Disable Magento 2 caches]]
--> [[Magento 2 How to Add Alternative HTTP headers]]
--> [[Magento 2 Purge Varnish Cache]]
--> [[Magento 2 Redis Page Cache and Default Cache Example]]
--> [[Magento 2 How to check Magento Version]]
--> [[Magento 2 Reindex Error: Index is locked by another reindex process. Skipping]]
--> [[Magento 2 Reindex via the CLI]]
--> [[Magento 2 Custom 503 Maintenance page]]

[[File:Memcahed.jpg|100px|frameless|right|alt=Memcache Caching]]

===Memcached Server===
--> [[Memcached Monitor Tool]]
--> [[Setup Multi Instance Memcache]]
--> [[Check if Memcached is Running]]
--> [[Flush Your Memcached Instance]]
--> [[Check Memory Usage of Memcached]]
--> [[Memcache running out of Memory?]]
--> [[Memcached List all Keys]]

[[File:Apachelogo.gif|100px|right|alt=Apache How Tos]]

===Apache/PHP===

--> [[Deny access to my site with an .htaccess file]]
--> [[Redirect site to www or non www]]
--> [[Restrict POST request to Website]]
--> [[Install Tomcat6 Server on Centos 6]]
--> [[How to setup an SSL Certificate for Free]]
--> [[Enable Apache to Create Core Dumps]]
--> [[Enable php-fpm to create core dumps]]
--> [[Debug PHP Enabling slow_log]]
--> [[Block Bots by User Agent String]]
--> [[Install mod_extact_forward - Show Real IP behind Proxy]]
--> [[Install ionCube Loaders for Centos]]
--> [[Install Zend Guard with PHP 5.3 on Centos]]
--> [[Install Zend Guard 6.0 with PHP 5.4 on Centos]]
--> [[Disable Mod_Security for a single vhost]]
--> [[Hide PHP Version(X-Powered-By) in Headers]]
--> [[Sessions are ending before MaxLifetime]]
--> [[Apache mod_speling case insensitive urls issue]]
--> [[Restrict access via htaccess via ipaddress]]
--> [[Howto install mod_evasive with fail2ban]]
--> [[Install the Latest version PHP on CentOS]]
--> [[How to bypass .htpasswd for certain IPs Apache]]
--> [[Clear mod_pagespeed cache ]]
--> [[Install GeoIP for Apache and PHP]]
--> [[How to block or allow countries using GeoIP and .htaccess]]
--> [[How to disable mod_security per vhost]]
--> [[Force HTTPS for entire website via htaccess]]
--> [[Restrict Access to wp-login.php and xmlrpc.php]]
--> [[The X-Frame-Options response header]]
--> [[Install Xdebug with php-fpm per pool]]
--> [[How to Enable Gzip Compression]]
--> [[Enable Apache rewrite logging]]
--> [[Protecting Folders with .htpasswd/.htaccess]]
--> [[How to Disable PHP Execution in Certain Directories]]
--> [[Directory listing in htaccess. Allow, Deny, Disable, Enable Directory Listing in .htaccess]]
--> [[What is the Cache-Control Header]]
[[File:Haproxy.png|100px|frameless|right|alt=Mysql Percona]]

===HAProxy===
--> [[What is HAProxy]]
--> [[HAProxy vs Nginx]]
--> [[HAProxy Load Balancing]]
--> [[HAProxy Cluster Setup Example]]
--> [[HAProxy Docker]]
--> [[HAProxy with Varnish SSL Termination Example]]
--> [[HAProxy http2]]
--> [[HAProxy GUI]]
--> [[HAProxy Install on Centos7]]
--> [[HAProxy Cloud Load Balancer]]
--> [[HAProxy Block by User-Agent]]
--> [[HAProxy Restrict by IP Address]]
--> [[HAProxy Redirect domain to another domain]]

[[File:Logo percona server new.png|100px|frameless|right|alt=Mysql Percona]]

===Mysql/Percona===
--> [[How to Optimize/Repair a Table]]
--> [[MySQL - Check Which Query is Consuming Resources]]
--> [[How to Set your MySQL Password]]
--> [[Rest your MySQL Admin Password]]
--> [[How to Convert Table to InnoDB]]
--> [[How to install Percona Database Server]]
--> [[How to Access the MySQL via Shell]]
--> [[How to Add a User in MySQL]]
--> [[How to Drop a User in MySQL]]
--> [[How to Create and Delete a MySQL Database]]
--> [[How to Create a Table in MySQL Database]]
--> [[How to Create a MySQL Database Backup]]
--> [[How to Import a MySQL Database]]
--> [[How to update the max_connections setting in MySQL]]
--> [[How to view a list of MySQL users and their privileges]]
--> [[Save MySQL query results into a text or CSV file]]
--> [[How to optimize a MySQL database using phpMyAdmin]]
--> [[How to solve MySQL max_user_connections error]]

[[File:Varnish-cache-log.jpeg|100px|frameless|right|alt=Varnish How tos]]

===Varnish Cache===
--> [[Setup Varnish Cache]]
--> [[Setup Varnish for Magento]]
--> [[Setup Varnish for Wordpress]]
--> [[Setup Varnish for MediaWiki]]
--> [[Setup Varnish - Multiple Domains]]
--> [[Setup Varnish - Multiple Ipaddress]]
--> [[Script to Clear a Page from Varnish Cache]]
--> [[Varnish will not restart WHY?]]
--> [[Warm up Varnish Script using Sitemap.xml]]
--> [[Varnish How to redirect non-www URLs to www]]
--> [[Install libvmod-header with Varnish]]

[[File:Nginx-logo.png|100px|frameless|right|Install Nginx|alt=Nginx How tos]]

===Nginx Web Server===
--> [[Setup Nginx PHP FPM Percona Mysql]]
--> [[Wordpress Ngnix Rewrite Rules]]
--> [[Setup up Nginx Caching]]
--> [[Nginx Magento vhost Configuration]]
--> [[Basic HTTP Authentication with Nginx]]
--> [[Protecting Folders with Nginx]]
--> [[403 Forbidden Error Nginx - How to Solve]]

[[File:Sword-of-Omens-Sword1.png|100px|frameless|right|alt=Brian Nelson]]

===Other===
--> [[How to add trusted root certificates]]
--> [[Find:_10_Useful_Examples_of_Find]]
--> [[Send email from PHP to a log file instead of sendmail]]
--> [[Debugging Wordpress]]
--> [[How to install Linux via USB]]
--> [[Network Subnet Mask Cheat Sheet]]
--> [[Linux Keyboard Shortcuts]]
--> [[Setup a SSH Tunnel for Secure Browsing]]
--> [[Install OpenSSH on Windows]]
--> [[Install Qmail on a Fresh Centos Server]]
--> [[Setup Qmail to Listen on port 587 for SMTP]]
--> [[Qmail catch-all account with vpopmail]]
--> [[Setup Incoming Email Pipe to Script for Qmail]]
--> [[Qmail Control Files]]
--> [[Install qmqtool for Qmail on Centos Server]]
--> [[Rest Email Password for vpopmail]]
--> [[How to check Used IP on your Home Network]]
--> [[How to find GMAIL IPs to allow at Firewall]]
--> [[Useful TCPDUMP commands]]
--> [[Remove Email Block Lists]]
--> [[How to disable qmail vpopmail email user]]
--> [[Git Cheat Sheet - Git made easy]]
--> [[Top Chmod Command Examples for Beginners]]
--> [[Benchmarking and Load Testing with Siege]]
--> [[Benchmarking and Load Testing with Apache Bench(AB)]]
--> [[How do I find out more about socket files in /proc/fd]]
--> [[How to Disable the wp-cron.php in WordPress]]
--> [[How to delete mail queue in Postfix]]

--> [[Top Command Line Games - Linux CLI Games]] Cause Linux can be fun

--> [[Centos Oneliners]]

--> [[Bash Script to Check Memory with Email Alert when Low]]
--> [[Bash Script to Check Site Code Status with Email Alert]]

How to solve MySQL max user connections error

2021-01-16T05:14:01Z

Brian: Created page with "==How to solve MySQL max connections/user connections error== If clients encounter Too many connections errors when attempting to connect to the mysqld server, all available..."

==How to solve MySQL max connections/user connections error==

If clients encounter Too many connections errors when attempting to connect to the mysqld server, all available connections are in use by other clients.

The permitted number of connections is controlled by the max_connections system variable. The default value is 151 to improve performance when MySQL is used with the Apache Web server. To support more connections, set max_connections to a larger value

===Checking the max_connections===

You can run the following command to check the current value of max_connections

MariaDB [(none)]> show variables like 'max_connections';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 151 |
+-----------------+-------+
1 row in set (0.00 sec)

This shows the current value, you can check the current number of connections by running:

MariaDB [(none)]> show status where variable_name = 'threads_connected';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Threads_connected | 146 |
+-------------------+-------+
1 row in set (0.02 sec)

===You can increase this value in two ways:===

====Without restarting mysql (temp change) ====

MariaDB [(none)]> SET GLOBAL max_connections = 300;
Query OK, 0 rows affected (0.00 sec)

'''Checking the new value:
'''
MariaDB [(none)]> show variables like 'max_connections';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 300 |
+-----------------+-------+
1 row in set (0.00 sec)

====Restarting Mysql via my.cnf (permanent change)====

Or set this parameter in my.cnf that located at /etc/my.cnf

vi /etc/my.cnf
max_connections = 300

Then restart mysql, this is a permanent change to the max_connections at this point

Main Page

2021-01-16T04:49:44Z

Brian: /* Mysql/Percona */

==Welcome to Ramblings of a Centos Ninja==

[[File:Centos-logo.png|100px|frameless|right|alt=Centos How-Tos]]
===Centos 7===
--> [[Install Remi and EPEL yum repo Centos 7]]
--> [[Install Mysql Database Centos 7]]
--> [[Install Apache Web Server Centos 7]]
--> [[Install PHP/PHP-FPM 5.4 Centos 7]]
--> [[Install (LAMP) Linux Apache MySQL and PHP Centos 7]]
--> [[Install Redis on Centos 7 How To]]
--> [[How To Configure SWAP on Centos 7]]
--> [[How to find user memory usage in linux]]
--> [[How to Configure letsencrypt with Apache on Centos 7 Server]]
--> [[How to configure Gmail as a Mail Relay with Postfix]]
--> [[How use GeoIP on the command line Centos7]]
--> [[Protecting Folders with .htpasswd/.htaccess]]
--> [[Linux setfacl command]]
--> [[How to disable SSH timeout]] [[File:New.jpg|35px|frameless]]
--> [[How to Install Squid Proxy Server on Cento7]] [[File:New.jpg|35px|frameless]]
--> [[How To Use Systemctl to Manage Systemd Services]]

===Centos 6===
--> [[Change Runlevel]]
--> [[Check Current Runlevel]]
--> [[Change Run Level at Bootup]]
--> [[How to change the Hostname on Centos]]
--> [[chkconfig settings]]
--> [[How to extract a tar.gz file]]
--> [[Install SIM - System Integrity Monitor]]
--> [[Use Bash on a Non Bash User]]
--> [[Quit Bash Shell without Saving Bash History]]
--> [[Change the Timezone Centos]]
--> [[Check the Version of Package]]
--> [[How to install Sphinx on Centos Server]]
--> [[How to install Redis on a Centos 6.4 Server]]
--> [[Basic Redis commands - Cheat Sheet]]
--> [[Adding a New Disk Drive with Centos]]
--> [[Creating Backups using rsync with Examples]]
--> [[Expand your bash_history to 2500]]
--> [[Setup logrotate to rotate your logs]]
--> [[GPG: Encrypt And Decrypt Files With A Password]]
--> [[Install Remi and EPEL yum repo]]
--> [[Install NewRelic on Centos6]]
--> [[Setting Up An NFS Server And Client On CentOS 6]]
--> [[Sar is not working how to restart]]
--> [[Batch jpeg Image Optimization]]
--> [[Howto Block or Open HTTP/HTTPs Ports IPTables]]
--> [[Reset Root Password in CentOS]]
--> [[Setup vsftp with SELinux]]
--> [[Howto Setup NTP on CentOS]]
--> [[Fix corrupted RPM database]]
--> [[Crontab Usage]]
--> [[Make an ISO from a Folder with mkisofs]]
--> [[How to setup a VPN server with CentOS PPTPD]]
--> [[APF Firewall -Advanced Policy Firewall - Basics]]
--> [[How to Block Bittorrent Traffic with IPtables]]
--> [[How to find user memory usage in linux]]
--> [[How to install ccsrch on Centos 6]]
--> [[How to install jpegoptim for CentOS]]
--> [[How to install optipng for CentOS]]
--> [[How to install gifsicle for CentOS]]
--> [[How to install jpegtran for CentOS]]
--> [[IPTABLES quick command list]]
--> [[Linux setfacl command]]
--> [[Postfix Mail Queue Commands for Reviewing Emails]]

[[File:Magentos.jpg|100px|frameless|right|alt=Magento How To's]]

===Magento Community Edition/Magento Enterprise Edition===
--> [[What is Magento?]]
--> [[Clear Magento Cache]]
--> [[Disable Magento Modules]]
--> [[Turn on Manual Indexing]]
--> [[How to Reset Magento Password]]
--> [[How to Create Users in Mageento]]
--> [[Enable Mysql Slow Query Logging]]
--> [[Magento Connect is not Working]]
--> [[Magento will NOT save my Product Updates]]
--> [[Magento Internal Cron not Running]]
--> [[Setting up the System Cron Job]]
--> [[Magento Connect is not Working]]
--> [[Changing the Minimum Search Query - MySQL Full Text Only]]
--> [[Install Redis Caching for Magento]]
--> [[Install Redis Full Page Caching for Magento Enterprise]]
--> [[Setting up a Second Instance of Redis]]
--> [[Magento Setup Return-Path Email]]
--> [[Magento Server Compatibility Check]]
--> [[Magento Database Optimization - Log Cleaning Script]]
--> [[Magento Site Performance Optimization]]
--> [[Magento Log Rotate with logrotate]]
--> [[How to use CDN with Webfonts with Magento]]
--> [[How to Disable Magento Newsletter Module]]
--> [[Magento : Execute Custom Module Cron Manually]]

[[File:Magentos.jpg|100px|frameless|right|alt=Magento2 How To's]]

===Magento 2 Community Edition===
--> [[Upgrade Magento2 via CLI]]
--> [[Enable/Disable Magento2 Maintenance Page]]
--> [[How to set Magento 2 permissions and avoid installation errors]]
--> [[How to speed up Magento 2 out of the box]]
--> [[How to Change Magento 2 mode]]
--> [[How to Enable Disable Magento 2 caches]]
--> [[Magento 2 How to Add Alternative HTTP headers]]
--> [[Magento 2 Purge Varnish Cache]]
--> [[Magento 2 Redis Page Cache and Default Cache Example]]
--> [[Magento 2 How to check Magento Version]]
--> [[Magento 2 Reindex Error: Index is locked by another reindex process. Skipping]]
--> [[Magento 2 Reindex via the CLI]]

[[File:Memcahed.jpg|100px|frameless|right|alt=Mecache Caching]]

===Memcached Server===
--> [[Memcached Monitor Tool]]
--> [[Setup Multi Instance Memcache]]
--> [[Check if Memcached is Running]]
--> [[Flush Your Memcached Instance]]
--> [[Check Memory Usage of Memcached]]
--> [[Memcache running out of Memory?]]
--> [[Memcached List all Keys]]

[[File:Apachelogo.gif|100px|right|alt=Apache How Tos]]

===Apache/PHP===

--> [[Deny access to my site with an .htaccess file]]
--> [[Redirect site to www or non www]]
--> [[Restrict POST request to Website]]
--> [[Install Tomcat6 Server on Centos 6]]
--> [[How to setup an SSL Certificate for Free]]
--> [[Enable Apache to Create Core Dumps]]
--> [[Enable php-fpm to create core dumps]]
--> [[Debug PHP Enabling slow_log]]
--> [[Block Bots by User Agent String]]
--> [[Install mod_extact_forward - Show Real IP behind Proxy]]
--> [[Install ionCube Loaders for Centos]]
--> [[Install Zend Guard with PHP 5.3 on Centos]]
--> [[Install Zend Guard 6.0 with PHP 5.4 on Centos]]
--> [[Disable Mod_Security for a single vhost]]
--> [[Hide PHP Version(X-Powered-By) in Headers]]
--> [[Sessions are ending before MaxLifetime]]
--> [[Apache mod_speling case insensitive urls issue]]
--> [[Restrict access via htaccess via ipaddress]]
--> [[Howto install mod_evasive with fail2ban]]
--> [[Install the Latest version PHP on CentOS]]
--> [[How to bypass .htpasswd for certain IPs Apache]]
--> [[Clear mod_pagespeed cache ]]
--> [[Install GeoIP for Apache and PHP]]
--> [[How to block or allow countries using GeoIP and .htaccess]]
--> [[How to disable mod_security per vhost]]
--> [[Force HTTPS for entire website via htaccess]]
--> [[Restrict Access to wp-login.php and xmlrpc.php]]
--> [[The X-Frame-Options response header]]
--> [[Install Xdebug with php-fpm per pool]]
--> [[How to Enable Gzip Compression]]
--> [[Enable Apache rewrite logging]]
--> [[Protecting Folders with .htpasswd/.htaccess]]
--> [[How to Disable PHP Execution in Certain Directories]]
--> [[Directory listing in htaccess. Allow, Deny, Disable, Enable Directory Listing in .htaccess]]
--> [[What is the Cache-Control Header]]
[[File:Haproxy.png|100px|frameless|right|alt=Mysql Percona]]

===HAProxy===
--> [[What is HAProxy]]
--> [[HAProxy vs Nginx]]
--> [[HAProxy Load Balancing]]
--> [[HAProxy Cluster Setup Example]]
--> [[HAProxy Docker]]
--> [[HAProxy with Varnish SSL Termination Example]]
--> [[HAProxy http2]]
--> [[HAProxy GUI]]
--> [[HAProxy Install on Centos7]]
--> [[HAProxy Cloud Load Balancer]]
--> [[HAProxy Block by User-Agent]]
--> [[HAProxy Restrict by IP Address]]
--> [[HAProxy Redirect domain to another domain]]

[[File:Logo percona server new.png|100px|frameless|right|alt=Mysql Percona]]

===Mysql/Percona===
--> [[How to Optimize/Repair a Table]]
--> [[MySQL - Check Which Query is Consuming Resources]]
--> [[How to Set your MySQL Password]]
--> [[Rest your MySQL Admin Password]]
--> [[How to Convert Table to InnoDB]]
--> [[How to install Percona Database Server]]
--> [[How to Access the MySQL via Shell]]
--> [[How to Add a User in MySQL]]
--> [[How to Drop a User in MySQL]]
--> [[How to Create and Delete a MySQL Database]]
--> [[How to Create a Table in MySQL Database]]
--> [[How to Create a MySQL Database Backup]]
--> [[How to Import a MySQL Database]]
--> [[How to update the max_connections setting in MySQL]]
--> [[How to view a list of MySQL users and their privileges]]
--> [[Save MySQL query results into a text or CSV file]]
--> [[How to optimize a MySQL database using phpMyAdmin]]
--> [[How to solve MySQL max_user_connections error]]

[[File:Varnish-cache-log.jpeg|100px|frameless|right|alt=Varnish How tos]]

===Varnish Cache===
--> [[Setup Varnish Cache]]
--> [[Setup Varnish for Magento]]
--> [[Setup Varnish for Wordpress]]
--> [[Setup Varnish for MediaWiki]]
--> [[Setup Varnish - Multiple Domains]]
--> [[Setup Varnish - Multiple Ipaddress]]
--> [[Script to Clear a Page from Varnish Cache]]
--> [[Varnish will not restart WHY?]]
--> [[Warm up Varnish Script using Sitemap.xml]]
--> [[Varnish How to redirect non-www URLs to www]]
--> [[Install libvmod-header with Varnish]]

[[File:Nginx-logo.png|100px|frameless|right|Install Nginx|alt=Nginx How tos]]

===Nginx Web Server===
--> [[Setup Nginx PHP FPM Percona Mysql]]
--> [[Wordpress Ngnix Rewrite Rules]]
--> [[Setup up Nginx Caching]]
--> [[Nginx Magento vhost Configuration]]
--> [[Basic HTTP Authentication with Nginx]]
--> [[Protecting Folders with Nginx]]
--> [[403 Forbidden Error Nginx - How to Solve]]

[[File:Sword-of-Omens-Sword1.png|100px|frameless|right|alt=Brian Nelson]]

===Other===
--> [[How to add trusted root certificates]]
--> [[Find:_10_Useful_Examples_of_Find]]
--> [[Send email from PHP to a log file instead of sendmail]]
--> [[Debugging Wordpress]]
--> [[How to install Linux via USB]]
--> [[Network Subnet Mask Cheat Sheet]]
--> [[Linux Keyboard Shortcuts]]
--> [[Setup a SSH Tunnel for Secure Browsing]]
--> [[Install OpenSSH on Windows]]
--> [[Install Qmail on a Fresh Centos Server]]
--> [[Setup Qmail to Listen on port 587 for SMTP]]
--> [[Qmail catch-all account with vpopmail]]
--> [[Setup Incoming Email Pipe to Script for Qmail]]
--> [[Qmail Control Files]]
--> [[Install qmqtool for Qmail on Centos Server]]
--> [[Rest Email Password for vpopmail]]
--> [[How to check Used IP on your Home Network]]
--> [[How to find GMAIL IPs to allow at Firewall]]
--> [[Useful TCPDUMP commands]]
--> [[Remove Email Block Lists]]
--> [[How to disable qmail vpopmail email user]]
--> [[Git Cheat Sheet - Git made easy]]
--> [[Top Chmod Command Examples for Beginners]]
--> [[Benchmarking and Load Testing with Siege]]
--> [[Benchmarking and Load Testing with Apache Bench(AB)]]
--> [[How do I find out more about socket files in /proc/fd]]
--> [[How to Disable the wp-cron.php in WordPress]]
--> [[How to delete mail queue in Postfix]]

--> [[Top Command Line Games - Linux CLI Games]] Cause Linux can be fun

--> [[Centos Oneliners]]

--> [[Bash Script to Check Memory with Email Alert when Low]]
--> [[Bash Script to Check Site Code Status with Email Alert]]

Restrict Access to wp-login.php and xmlrpc.php

2020-12-09T01:49:29Z

Brian: /* Multiple IP address access: */

==Restrict Access to wp-login.php and xmlrpc.php==

Wordpress Security alert!! Stop getting hacked by restricting access to wp-login.php and xmlrpc.php.

Access your .htaccess file in your html directory

vim /var/www/html/.htaccess

===Now we have options:===

You can get your ip address by visiting: https://briansnelson.com/ip/

====Single IP address access:====

Add the following, don't forget to replace the ip address with your own

<IfModule mod_rewrite.c>
RewriteEngine on
RewriteCond %{REQUEST_URI} ^(.*)?wp-login\.php(.*)$ [OR]
RewriteCond %{REQUEST_URI} ^(.*)?xmlrpc\.php(.*)$ [OR]
RewriteCond %{REQUEST_URI} ^(.*)?wp-admin(.*)$
RewriteCond %{REMOTE_ADDR} !^123\.123\.123\.123$
RewriteRule ^(.*)$ - [R=403,L]
</IfModule>

====Multiple IP address access:====

Add the following, don't forget to replace the ip address with your own

<IfModule mod_rewrite.c>
RewriteEngine on
RewriteCond %{REQUEST_URI} ^(.*)?wp-login\.php(.*)$ [OR]
RewriteCond %{REQUEST_URI} ^(.*)?xmlrpc\.php(.*)$ [OR]
RewriteCond %{REQUEST_URI} ^(.*)?wp-admin(.*)$
RewriteCond %{REMOTE_ADDR} !^123\.123\.123\.123$
RewriteCond %{REMOTE_ADDR} !^123\.123\.123\.124$
RewriteCond %{REMOTE_ADDR} !^123\.123\.123\.125$
RewriteRule ^(.*)$ - [R=403,L]
</IfModule>

Side note, I would also allow your server's ip address, as some wp-cron.php scripts require access to xmlrpc.php

Restrict Access to wp-login.php and xmlrpc.php

2020-12-09T01:49:19Z

Brian: /* Single IP address access: */

==Restrict Access to wp-login.php and xmlrpc.php==

Wordpress Security alert!! Stop getting hacked by restricting access to wp-login.php and xmlrpc.php.

Access your .htaccess file in your html directory

vim /var/www/html/.htaccess

===Now we have options:===

You can get your ip address by visiting: https://briansnelson.com/ip/

====Single IP address access:====

Add the following, don't forget to replace the ip address with your own

<IfModule mod_rewrite.c>
RewriteEngine on
RewriteCond %{REQUEST_URI} ^(.*)?wp-login\.php(.*)$ [OR]
RewriteCond %{REQUEST_URI} ^(.*)?xmlrpc\.php(.*)$ [OR]
RewriteCond %{REQUEST_URI} ^(.*)?wp-admin(.*)$
RewriteCond %{REMOTE_ADDR} !^123\.123\.123\.123$
RewriteRule ^(.*)$ - [R=403,L]
</IfModule>

====Multiple IP address access:====

Add the following, don't forget to replace the ip address with your own

<IfModule mod_rewrite.c>
RewriteEngine on
RewriteCond %{REQUEST_URI} ^(.*)?wp-login\.php(.*)$ [OR]
RewriteCond %{REQUEST_URI} ^(.*)?xmlrpc\.php(.*)$ [OR]
RewriteCond %{REQUEST_URI} ^(.*)?wp-admin$
RewriteCond %{REMOTE_ADDR} !^123\.123\.123\.123$
RewriteCond %{REMOTE_ADDR} !^123\.123\.123\.124$
RewriteCond %{REMOTE_ADDR} !^123\.123\.123\.125$
RewriteRule ^(.*)$ - [R=403,L]
</IfModule>

Side note, I would also allow your server's ip address, as some wp-cron.php scripts require access to xmlrpc.php

HAProxy Redirect domain to another domain

2020-11-25T03:57:21Z

Brian: /* Next restart or start the server to start blocking by ip address */

==HAProxy Redirect domain to another domain==

From time to time, you may find yourself wanting to redirect a domain to a folder on another domain

===You will want to edit the haproxy.cfg file===

vim /etc/haproxy/haproxy.cfg

===Then add something like the following to the frontend in haproxy.===

acl demoredirect hdr_dom(host) -i demofolder.com
acl demoredirect hdr_dom(host) -i www.demofolder.com
http-request redirect location https://briansnelson.com/demofolder/ code 301 if demoredirect

===Save and check your configuration===

service haproxy check

You are looking for

Configuration file is valid

===Next restart or start the server to start redirecting from one domain to another===

service haproxy restart/start

Block Bots by User Agent String

2020-10-27T01:26:19Z

Brian: /* Via BrowserMatch */

==How to block a bot by User Agent Sting==

Do you have those bandwidth hogging bots as much as Phil and I do? Did you know you can block them in your .htaccess file?

===Block the BOT===
Let block the most annoying bot on the internet - Baidu spider

vim .htaccess

Now Add the following to block bad bots

===Via mod_rewrite===

<Directory />
RewriteEngine On
RewriteCond %{HTTP_USER_AGENT} Baiduspider [NC,OR]
RewriteCond %{HTTP_USER_AGENT} Baidu [NC]
RewriteRule ^.*$ - [F,L]
</Directory>

===Via BrowserMatch===

<Directory />
BrowserMatchNoCase "Baiduspider" bots
BrowserMatchNoCase "HTTrack" bots
BrowserMatchNoCase "Yandex" bots
BrowserMatchNoCase "AhrefsBot" bots
BrowserMatchNoCase "Pinterestbot" bots
BrowserMatchNoCase "YandexImages" bots
BrowserMatchNoCase "YandexBot" bots
BrowserMatchNoCase "Facebot" bots
BrowserMatchNoCase "DotBot" bots
BrowserMatchNoCase "PetalBot" bots

Order Allow,Deny
Allow from ALL
Deny from env=bots
</Directory>

That's it save the file, and you are now blocking the Baidu spider

===Testing to see if its blocked===

One way to do this is to use curl

curl -I http://www.briansnelson.com -A "Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)"

Now you will get a 403 Forbidden

HTTP/1.1 403 Forbidden
Date: Mon, 06 Jan 2014 19:18:11 GMT

Block Bots by User Agent String

2020-10-27T01:24:10Z

Brian: /* Via BrowserMatch */

==How to block a bot by User Agent Sting==

Do you have those bandwidth hogging bots as much as Phil and I do? Did you know you can block them in your .htaccess file?

===Block the BOT===
Let block the most annoying bot on the internet - Baidu spider

vim .htaccess

Now Add the following to block bad bots

===Via mod_rewrite===

<Directory />
RewriteEngine On
RewriteCond %{HTTP_USER_AGENT} Baiduspider [NC,OR]
RewriteCond %{HTTP_USER_AGENT} Baidu [NC]
RewriteRule ^.*$ - [F,L]
</Directory>

===Via BrowserMatch===

<Directory />
BrowserMatchNoCase "Baiduspider" bots
BrowserMatchNoCase "HTTrack" bots
BrowserMatchNoCase "Yandex" bots
BrowserMatchNoCase "AhrefsBot" bots
BrowserMatchNoCase "Pinterestbot" bots
BrowserMatchNoCase "YandexImages" bots
BrowserMatchNoCase "YandexBot" bots
BrowserMatchNoCase "Facebot" bots
BrowserMatchNoCase "DotBot" bots

Order Allow,Deny
Allow from ALL
Deny from env=bots
</Directory>

That's it save the file, and you are now blocking the Baidu spider

===Testing to see if its blocked===

One way to do this is to use curl

curl -I http://www.briansnelson.com -A "Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)"

Now you will get a 403 Forbidden

HTTP/1.1 403 Forbidden
Date: Mon, 06 Jan 2014 19:18:11 GMT

Block Bots by User Agent String

2020-10-27T01:23:40Z

Brian: /* Via mod_rewrite */

==How to block a bot by User Agent Sting==

Do you have those bandwidth hogging bots as much as Phil and I do? Did you know you can block them in your .htaccess file?

===Block the BOT===
Let block the most annoying bot on the internet - Baidu spider

vim .htaccess

Now Add the following to block bad bots

===Via mod_rewrite===

<Directory />
RewriteEngine On
RewriteCond %{HTTP_USER_AGENT} Baiduspider [NC,OR]
RewriteCond %{HTTP_USER_AGENT} Baidu [NC]
RewriteRule ^.*$ - [F,L]
</Directory>

===Via BrowserMatch===

BrowserMatchNoCase "Baiduspider" bots
BrowserMatchNoCase "HTTrack" bots
BrowserMatchNoCase "Yandex" bots
BrowserMatchNoCase "AhrefsBot" bots
BrowserMatchNoCase "Pinterestbot" bots
BrowserMatchNoCase "YandexImages" bots
BrowserMatchNoCase "YandexBot" bots
BrowserMatchNoCase "Facebot" bots
BrowserMatchNoCase "DotBot" bots

Order Allow,Deny
Allow from ALL
Deny from env=bots

That's it save the file, and you are now blocking the Baidu spider

===Testing to see if its blocked===

One way to do this is to use curl

curl -I http://www.briansnelson.com -A "Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)"

Now you will get a 403 Forbidden

HTTP/1.1 403 Forbidden
Date: Mon, 06 Jan 2014 19:18:11 GMT

HAProxy Redirect domain to another domain

2020-10-21T06:56:07Z

Brian: Created page with "==HAProxy Redirect domain to another domain== From time to time, you may find yourself wanting to redirect a domain to a folder on another domain ===You will want to edit th..."

==HAProxy Redirect domain to another domain==

From time to time, you may find yourself wanting to redirect a domain to a folder on another domain

===You will want to edit the haproxy.cfg file===

vim /etc/haproxy/haproxy.cfg

===Then add something like the following to the frontend in haproxy.===

acl demoredirect hdr_dom(host) -i demofolder.com
acl demoredirect hdr_dom(host) -i www.demofolder.com
http-request redirect location https://briansnelson.com/demofolder/ code 301 if demoredirect

===Save and check your configuration===

service haproxy check

You are looking for

Configuration file is valid

===Next restart or start the server to start blocking by ip address===

service haproxy restart/start

Main Page

2020-10-21T06:48:53Z

Brian: /* HAProxy */

==Welcome to Ramblings of a Centos Ninja==

[[File:Centos-logo.png|100px|frameless|right|alt=Centos How-Tos]]
===Centos 7===
--> [[Install Remi and EPEL yum repo Centos 7]]
--> [[Install Mysql Database Centos 7]]
--> [[Install Apache Web Server Centos 7]]
--> [[Install PHP/PHP-FPM 5.4 Centos 7]]
--> [[Install (LAMP) Linux Apache MySQL and PHP Centos 7]]
--> [[Install Redis on Centos 7 How To]]
--> [[How To Configure SWAP on Centos 7]]
--> [[How to find user memory usage in linux]]
--> [[How to Configure letsencrypt with Apache on Centos 7 Server]]
--> [[How to configure Gmail as a Mail Relay with Postfix]]
--> [[How use GeoIP on the command line Centos7]]
--> [[Protecting Folders with .htpasswd/.htaccess]]
--> [[Linux setfacl command]]
--> [[How to disable SSH timeout]] [[File:New.jpg|35px|frameless]]
--> [[How to Install Squid Proxy Server on Cento7]] [[File:New.jpg|35px|frameless]]
--> [[How To Use Systemctl to Manage Systemd Services]]

===Centos 6===
--> [[Change Runlevel]]
--> [[Check Current Runlevel]]
--> [[Change Run Level at Bootup]]
--> [[How to change the Hostname on Centos]]
--> [[chkconfig settings]]
--> [[How to extract a tar.gz file]]
--> [[Install SIM - System Integrity Monitor]]
--> [[Use Bash on a Non Bash User]]
--> [[Quit Bash Shell without Saving Bash History]]
--> [[Change the Timezone Centos]]
--> [[Check the Version of Package]]
--> [[How to install Sphinx on Centos Server]]
--> [[How to install Redis on a Centos 6.4 Server]]
--> [[Basic Redis commands - Cheat Sheet]]
--> [[Adding a New Disk Drive with Centos]]
--> [[Creating Backups using rsync with Examples]]
--> [[Expand your bash_history to 2500]]
--> [[Setup logrotate to rotate your logs]]
--> [[GPG: Encrypt And Decrypt Files With A Password]]
--> [[Install Remi and EPEL yum repo]]
--> [[Install NewRelic on Centos6]]
--> [[Setting Up An NFS Server And Client On CentOS 6]]
--> [[Sar is not working how to restart]]
--> [[Batch jpeg Image Optimization]]
--> [[Howto Block or Open HTTP/HTTPs Ports IPTables]]
--> [[Reset Root Password in CentOS]]
--> [[Setup vsftp with SELinux]]
--> [[Howto Setup NTP on CentOS]]
--> [[Fix corrupted RPM database]]
--> [[Crontab Usage]]
--> [[Make an ISO from a Folder with mkisofs]]
--> [[How to setup a VPN server with CentOS PPTPD]]
--> [[APF Firewall -Advanced Policy Firewall - Basics]]
--> [[How to Block Bittorrent Traffic with IPtables]]
--> [[How to find user memory usage in linux]]
--> [[How to install ccsrch on Centos 6]]
--> [[How to install jpegoptim for CentOS]]
--> [[How to install optipng for CentOS]]
--> [[How to install gifsicle for CentOS]]
--> [[How to install jpegtran for CentOS]]
--> [[IPTABLES quick command list]]
--> [[Linux setfacl command]]
--> [[Postfix Mail Queue Commands for Reviewing Emails]]

[[File:Magentos.jpg|100px|frameless|right|alt=Magento How To's]]

===Magento Community Edition/Magento Enterprise Edition===
--> [[What is Magento?]]
--> [[Clear Magento Cache]]
--> [[Disable Magento Modules]]
--> [[Turn on Manual Indexing]]
--> [[How to Reset Magento Password]]
--> [[How to Create Users in Mageento]]
--> [[Enable Mysql Slow Query Logging]]
--> [[Magento Connect is not Working]]
--> [[Magento will NOT save my Product Updates]]
--> [[Magento Internal Cron not Running]]
--> [[Setting up the System Cron Job]]
--> [[Magento Connect is not Working]]
--> [[Changing the Minimum Search Query - MySQL Full Text Only]]
--> [[Install Redis Caching for Magento]]
--> [[Install Redis Full Page Caching for Magento Enterprise]]
--> [[Setting up a Second Instance of Redis]]
--> [[Magento Setup Return-Path Email]]
--> [[Magento Server Compatibility Check]]
--> [[Magento Database Optimization - Log Cleaning Script]]
--> [[Magento Site Performance Optimization]]
--> [[Magento Log Rotate with logrotate]]
--> [[How to use CDN with Webfonts with Magento]]
--> [[How to Disable Magento Newsletter Module]]
--> [[Magento : Execute Custom Module Cron Manually]]

[[File:Magentos.jpg|100px|frameless|right|alt=Magento2 How To's]]

===Magento 2 Community Edition===
--> [[Upgrade Magento2 via CLI]]
--> [[Enable/Disable Magento2 Maintenance Page]]
--> [[How to set Magento 2 permissions and avoid installation errors]]
--> [[How to speed up Magento 2 out of the box]]
--> [[How to Change Magento 2 mode]]
--> [[How to Enable Disable Magento 2 caches]]
--> [[Magento 2 How to Add Alternative HTTP headers]]
--> [[Magento 2 Purge Varnish Cache]]
--> [[Magento 2 Redis Page Cache and Default Cache Example]]
--> [[Magento 2 How to check Magento Version]]
--> [[Magento 2 Reindex Error: Index is locked by another reindex process. Skipping]]
--> [[Magento 2 Reindex via the CLI]]

[[File:Memcahed.jpg|100px|frameless|right|alt=Mecache Caching]]

===Memcached Server===
--> [[Memcached Monitor Tool]]
--> [[Setup Multi Instance Memcache]]
--> [[Check if Memcached is Running]]
--> [[Flush Your Memcached Instance]]
--> [[Check Memory Usage of Memcached]]
--> [[Memcache running out of Memory?]]
--> [[Memcached List all Keys]]

[[File:Apachelogo.gif|100px|right|alt=Apache How Tos]]

===Apache/PHP===

--> [[Deny access to my site with an .htaccess file]]
--> [[Redirect site to www or non www]]
--> [[Restrict POST request to Website]]
--> [[Install Tomcat6 Server on Centos 6]]
--> [[How to setup an SSL Certificate for Free]]
--> [[Enable Apache to Create Core Dumps]]
--> [[Enable php-fpm to create core dumps]]
--> [[Debug PHP Enabling slow_log]]
--> [[Block Bots by User Agent String]]
--> [[Install mod_extact_forward - Show Real IP behind Proxy]]
--> [[Install ionCube Loaders for Centos]]
--> [[Install Zend Guard with PHP 5.3 on Centos]]
--> [[Install Zend Guard 6.0 with PHP 5.4 on Centos]]
--> [[Disable Mod_Security for a single vhost]]
--> [[Hide PHP Version(X-Powered-By) in Headers]]
--> [[Sessions are ending before MaxLifetime]]
--> [[Apache mod_speling case insensitive urls issue]]
--> [[Restrict access via htaccess via ipaddress]]
--> [[Howto install mod_evasive with fail2ban]]
--> [[Install the Latest version PHP on CentOS]]
--> [[How to bypass .htpasswd for certain IPs Apache]]
--> [[Clear mod_pagespeed cache ]]
--> [[Install GeoIP for Apache and PHP]]
--> [[How to block or allow countries using GeoIP and .htaccess]]
--> [[How to disable mod_security per vhost]]
--> [[Force HTTPS for entire website via htaccess]]
--> [[Restrict Access to wp-login.php and xmlrpc.php]]
--> [[The X-Frame-Options response header]]
--> [[Install Xdebug with php-fpm per pool]]
--> [[How to Enable Gzip Compression]]
--> [[Enable Apache rewrite logging]]
--> [[Protecting Folders with .htpasswd/.htaccess]]
--> [[How to Disable PHP Execution in Certain Directories]]
--> [[Directory listing in htaccess. Allow, Deny, Disable, Enable Directory Listing in .htaccess]]
--> [[What is the Cache-Control Header]]
[[File:Haproxy.png|100px|frameless|right|alt=Mysql Percona]]

===HAProxy===
--> [[What is HAProxy]]
--> [[HAProxy vs Nginx]]
--> [[HAProxy Load Balancing]]
--> [[HAProxy Cluster Setup Example]]
--> [[HAProxy Docker]]
--> [[HAProxy with Varnish SSL Termination Example]]
--> [[HAProxy http2]]
--> [[HAProxy GUI]]
--> [[HAProxy Install on Centos7]]
--> [[HAProxy Cloud Load Balancer]]
--> [[HAProxy Block by User-Agent]]
--> [[HAProxy Restrict by IP Address]]
--> [[HAProxy Redirect domain to another domain]]

[[File:Logo percona server new.png|100px|frameless|right|alt=Mysql Percona]]

===Mysql/Percona===
--> [[How to Optimize/Repair a Table]]
--> [[MySQL - Check Which Query is Consuming Resources]]
--> [[How to Set your MySQL Password]]
--> [[Rest your MySQL Admin Password]]
--> [[How to Convert Table to InnoDB]]
--> [[How to install Percona Database Server]]
--> [[How to Access the MySQL via Shell]]
--> [[How to Add a User in MySQL]]
--> [[How to Drop a User in MySQL]]
--> [[How to Create and Delete a MySQL Database]]
--> [[How to Create a Table in MySQL Database]]
--> [[How to Create a MySQL Database Backup]]
--> [[How to Import a MySQL Database]]
--> [[How to update the max_connections setting in MySQL]]
--> [[How to view a list of MySQL users and their privileges]]
--> [[Save MySQL query results into a text or CSV file]]
--> [[How to optimize a MySQL database using phpMyAdmin]]

[[File:Varnish-cache-log.jpeg|100px|frameless|right|alt=Varnish How tos]]

===Varnish Cache===
--> [[Setup Varnish Cache]]
--> [[Setup Varnish for Magento]]
--> [[Setup Varnish for Wordpress]]
--> [[Setup Varnish for MediaWiki]]
--> [[Setup Varnish - Multiple Domains]]
--> [[Setup Varnish - Multiple Ipaddress]]
--> [[Script to Clear a Page from Varnish Cache]]
--> [[Varnish will not restart WHY?]]
--> [[Warm up Varnish Script using Sitemap.xml]]
--> [[Varnish How to redirect non-www URLs to www]]
--> [[Install libvmod-header with Varnish]]

[[File:Nginx-logo.png|100px|frameless|right|Install Nginx|alt=Nginx How tos]]

===Nginx Web Server===
--> [[Setup Nginx PHP FPM Percona Mysql]]
--> [[Wordpress Ngnix Rewrite Rules]]
--> [[Setup up Nginx Caching]]
--> [[Nginx Magento vhost Configuration]]
--> [[Basic HTTP Authentication with Nginx]]
--> [[Protecting Folders with Nginx]]
--> [[403 Forbidden Error Nginx - How to Solve]]

[[File:Sword-of-Omens-Sword1.png|100px|frameless|right|alt=Brian Nelson]]

===Other===
--> [[How to add trusted root certificates]]
--> [[Find:_10_Useful_Examples_of_Find]]
--> [[Send email from PHP to a log file instead of sendmail]]
--> [[Debugging Wordpress]]
--> [[How to install Linux via USB]]
--> [[Network Subnet Mask Cheat Sheet]]
--> [[Linux Keyboard Shortcuts]]
--> [[Setup a SSH Tunnel for Secure Browsing]]
--> [[Install OpenSSH on Windows]]
--> [[Install Qmail on a Fresh Centos Server]]
--> [[Setup Qmail to Listen on port 587 for SMTP]]
--> [[Qmail catch-all account with vpopmail]]
--> [[Setup Incoming Email Pipe to Script for Qmail]]
--> [[Qmail Control Files]]
--> [[Install qmqtool for Qmail on Centos Server]]
--> [[Rest Email Password for vpopmail]]
--> [[How to check Used IP on your Home Network]]
--> [[How to find GMAIL IPs to allow at Firewall]]
--> [[Useful TCPDUMP commands]]
--> [[Remove Email Block Lists]]
--> [[How to disable qmail vpopmail email user]]
--> [[Git Cheat Sheet - Git made easy]]
--> [[Top Chmod Command Examples for Beginners]]
--> [[Benchmarking and Load Testing with Siege]]
--> [[Benchmarking and Load Testing with Apache Bench(AB)]]
--> [[How do I find out more about socket files in /proc/fd]]
--> [[How to Disable the wp-cron.php in WordPress]]
--> [[How to delete mail queue in Postfix]]

--> [[Top Command Line Games - Linux CLI Games]] Cause Linux can be fun

--> [[Centos Oneliners]]

--> [[Bash Script to Check Memory with Email Alert when Low]]
--> [[Bash Script to Check Site Code Status with Email Alert]]

How to bypass .htpasswd for certain IPs Apache

2020-04-01T03:14:23Z

Brian: /* Wordpress wp-admin directory */

==How to bypass .htpasswd for certain IPs with Apache==

If you would like to setup Apache authentication on your website to block out unwanted users, example a development site with public access and allow your ipaddress to bypass the authentication.

Setting up your .htaccess or vhost configuration file.

===Basic Usage===

Add the following, with your variables

Order deny,allow
Deny from all
AuthType Basic
AuthUserFile /path/to/.htpasswd
AuthName "Protected Area"
require valid-user
Allow from xxx.xxx.xxx.xxx
SetEnvIf X-FORWARDED-FOR xxx.xxx.xxx.xxx allowed
Allow from env=allowed
Satisfy Any

You will want to replace the xxx.xxx.xxx.xxx with your ipaddress.

This can be put in your vhost file or .htaccess file.

===Wordpress wp-admin directory===

Another example would be for wordpress wp-admin folder

<Directory "/var/www/wordpressdomain/wp-admin/">
Order deny,allow
Deny from all
AuthType Basic
AuthUserFile /path/to/.htpasswd
AuthName "Protected Area"
require valid-user
Allow from xxx.xxx.xxx.xxx
SetEnvIf X-FORWARDED-FOR xxx.xxx.xxx.xxx allowed
Allow from env=allowed
Satisfy Any
</Directory>

This will protect your admin files from everyone but your ipaddress.

How to bypass .htpasswd for certain IPs Apache

2020-04-01T03:14:10Z

Brian: /* Wordpress wp-admin directory */

How to bypass .htpasswd for certain IPs Apache

2020-04-01T03:11:51Z

Brian: /* Basic Usage */

==How to bypass .htpasswd for certain IPs with Apache==

If you would like to setup Apache authentication on your website to block out unwanted users, example a development site with public access and allow your ipaddress to bypass the authentication.

Setting up your .htaccess or vhost configuration file.

===Basic Usage===

Add the following, with your variables

Order deny,allow
Deny from all
AuthType Basic
AuthUserFile /path/to/.htpasswd
AuthName "Protected Area"
require valid-user
Allow from xxx.xxx.xxx.xxx
SetEnvIf X-FORWARDED-FOR xxx.xxx.xxx.xxx allowed
Allow from env=allowed
Satisfy Any

You will want to replace the xxx.xxx.xxx.xxx with your ipaddress.

This can be put in your vhost file or .htaccess file.

===Wordpress wp-admin directory===

Another example would be for wordpress wp-admin folder

<Directory "/var/www/wordpressdomain/wp-admin/">
AuthUserFile /path/to/your/.htpasswd
AuthName "Please Log In"
AuthType Basic
require valid-user
Order allow,deny
Allow from xxx.xxx.xxx.xxx
Satisfy any
</Directory>

This will protect your admin files from everyone but your ipaddress.

How to bypass .htpasswd for certain IPs Apache

2020-04-01T03:11:23Z

Brian: /* Basic Usage */

==How to bypass .htpasswd for certain IPs with Apache==

If you would like to setup Apache authentication on your website to block out unwanted users, example a development site with public access and allow your ipaddress to bypass the authentication.

Setting up your .htaccess or vhost configuration file.

===Basic Usage===

Add the following, with your variables

Order deny,allow
Deny from all
AuthType Basic
AuthUserFile /path/to/.htpasswd
AuthName "Protected Area"
require valid-user
Allow from xxx.xxx.xxx.xxx
SetEnvIf X-FORWARDED-FOR xxx.xxx.xxx.xxx allowed
Allow from env=allowed
Satisfy Any

You will want to replace the xxx.xxx.xxx.xxx with your ipaddress.

This can be put in your vhost file or .htaccess file.

===Wordpress wp-admin directory===

Another example would be for wordpress wp-admin folder

<Directory "/var/www/wordpressdomain/wp-admin/">
AuthUserFile /path/to/your/.htpasswd
AuthName "Please Log In"
AuthType Basic
require valid-user
Order allow,deny
Allow from xxx.xxx.xxx.xxx
Satisfy any
</Directory>

This will protect your admin files from everyone but your ipaddress.

HAProxy Restrict by IP Address

2019-12-12T21:24:53Z

Brian: Created page with "==HAProxy Restrict by IP Address== As with any proxy service, you want to block bad ips before they get to the backend servers. With haproxy you can block ips really easy...."

==HAProxy Restrict by IP Address==

As with any proxy service, you want to block bad ips before they get to the backend servers. With haproxy you can block ips really easy.

Add the following to your haproxy configuration file

vim /etc/haproxy/haproxy.cfg

Add the following to your frontend, are blocking via x-forwarded-for and direct ip access, we do this now so you don't have to later if you decided to use cloudflare or another proxy later

# Blacklist IP list
acl is-blacklisted-ip hdr_ip(x-forwarded-for,1) -f /etc/haproxy/blacklist.txt
acl is-blacklisted-ip src -m ip -f /etc/haproxy/blacklist.txt
http-request deny if is-blacklisted-ip

Save then add the blacklist-agent.txt file.

vim /etc/haproxy/blacklist.txt

Add some ips to the block list file, you can add lot, you can even block entire countries with this method

192.168.0.1

Save and check your configuration

service haproxy check

You are looking for

'''Configuration file is valid'''

Next restart or start the server to start blocking by ip address

service haproxy restart/start

HAProxy Block by User-Agent

2019-12-12T08:33:13Z

Brian:

==HAProxy block by User-Agent==

As with any proxy service, you will want to block bad bots. Blocking by the a keyword in the user-agent before it hits the backend servers will save on server resources.

Add the following to your haproxy configuration file

vim /etc/haproxy/haproxy.cfg

Add the following to your frontend

# Block badbots
acl is-blockedagent hdr_sub(user-agent) -i -f /etc/haproxy/blacklist-agent.txt
http-request deny if is-blockedagent

Save then add the blacklist-agent.txt file.

vim /etc/haproxy/blacklist-agent.txt

Block the basics

SemrushBot
AhrefsBot
MJ12bot
ZoominfoBot
DotBot
MauiBot

Save and check your configuration

service haproxy check

You are looking for

'''Configuration file is valid'''

Next restart or start the server to start blocking by user-agent

service haproxy restart/start

HAProxy Block by User-Agent

2019-12-12T08:32:56Z

Brian: Created page with "==HAProxy block by User-Agent== As with any proxy service, you will want to block bad bots. Blocking by the a keyword in the user-agent before it hits the backend servers wi..."

==HAProxy block by User-Agent==

As with any proxy service, you will want to block bad bots. Blocking by the a keyword in the user-agent before it hits the backend servers will save on server resources.

Add the following to your haproxy configuration file

vim /etc/haproxy/haproxy.cfg

Add the following to your frontend

# Block badbots
acl is-blockedagent hdr_sub(user-agent) -i -f /etc/haproxy/blacklist-agent.txt
http-request deny if is-blockedagent

Save then add the blacklist-agent.txt file.

vim /etc/haproxy/blacklist-agent.txt

Block the basics

SemrushBot
AhrefsBot
MJ12bot
ZoominfoBot
DotBot
MauiBot

Save and check your configuration

service haproxy check

You are looking for

Configuration file is valid

Next restart or start the server to start blocking by user-agent

service haproxy restart/start

Main Page

2019-12-12T08:25:15Z

Brian: /* HAProxy */

==Welcome to Ramblings of a Centos Ninja==

[[File:Centos-logo.png|100px|frameless|right|alt=Centos How-Tos]]
===Centos 7===
--> [[Install Remi and EPEL yum repo Centos 7]]
--> [[Install Mysql Database Centos 7]]
--> [[Install Apache Web Server Centos 7]]
--> [[Install PHP/PHP-FPM 5.4 Centos 7]]
--> [[Install (LAMP) Linux Apache MySQL and PHP Centos 7]]
--> [[Install Redis on Centos 7 How To]]
--> [[How To Configure SWAP on Centos 7]]
--> [[How to find user memory usage in linux]]
--> [[How to Configure letsencrypt with Apache on Centos 7 Server]]
--> [[How to configure Gmail as a Mail Relay with Postfix]]
--> [[How use GeoIP on the command line Centos7]]
--> [[Protecting Folders with .htpasswd/.htaccess]]
--> [[Linux setfacl command]]
--> [[How to disable SSH timeout]] [[File:New.jpg|35px|frameless]]
--> [[How to Install Squid Proxy Server on Cento7]] [[File:New.jpg|35px|frameless]]
--> [[How To Use Systemctl to Manage Systemd Services]]

===Centos 6===
--> [[Change Runlevel]]
--> [[Check Current Runlevel]]
--> [[Change Run Level at Bootup]]
--> [[How to change the Hostname on Centos]]
--> [[chkconfig settings]]
--> [[How to extract a tar.gz file]]
--> [[Install SIM - System Integrity Monitor]]
--> [[Use Bash on a Non Bash User]]
--> [[Quit Bash Shell without Saving Bash History]]
--> [[Change the Timezone Centos]]
--> [[Check the Version of Package]]
--> [[How to install Sphinx on Centos Server]]
--> [[How to install Redis on a Centos 6.4 Server]]
--> [[Basic Redis commands - Cheat Sheet]]
--> [[Adding a New Disk Drive with Centos]]
--> [[Creating Backups using rsync with Examples]]
--> [[Expand your bash_history to 2500]]
--> [[Setup logrotate to rotate your logs]]
--> [[GPG: Encrypt And Decrypt Files With A Password]]
--> [[Install Remi and EPEL yum repo]]
--> [[Install NewRelic on Centos6]]
--> [[Setting Up An NFS Server And Client On CentOS 6]]
--> [[Sar is not working how to restart]]
--> [[Batch jpeg Image Optimization]]
--> [[Howto Block or Open HTTP/HTTPs Ports IPTables]]
--> [[Reset Root Password in CentOS]]
--> [[Setup vsftp with SELinux]]
--> [[Howto Setup NTP on CentOS]]
--> [[Fix corrupted RPM database]]
--> [[Crontab Usage]]
--> [[Make an ISO from a Folder with mkisofs]]
--> [[How to setup a VPN server with CentOS PPTPD]]
--> [[APF Firewall -Advanced Policy Firewall - Basics]]
--> [[How to Block Bittorrent Traffic with IPtables]]
--> [[How to find user memory usage in linux]]
--> [[How to install ccsrch on Centos 6]]
--> [[How to install jpegoptim for CentOS]]
--> [[How to install optipng for CentOS]]
--> [[How to install gifsicle for CentOS]]
--> [[How to install jpegtran for CentOS]]
--> [[IPTABLES quick command list]]
--> [[Linux setfacl command]]
--> [[Postfix Mail Queue Commands for Reviewing Emails]]

[[File:Magentos.jpg|100px|frameless|right|alt=Magento How To's]]

===Magento Community Edition/Magento Enterprise Edition===
--> [[What is Magento?]]
--> [[Clear Magento Cache]]
--> [[Disable Magento Modules]]
--> [[Turn on Manual Indexing]]
--> [[How to Reset Magento Password]]
--> [[How to Create Users in Mageento]]
--> [[Enable Mysql Slow Query Logging]]
--> [[Magento Connect is not Working]]
--> [[Magento will NOT save my Product Updates]]
--> [[Magento Internal Cron not Running]]
--> [[Setting up the System Cron Job]]
--> [[Magento Connect is not Working]]
--> [[Changing the Minimum Search Query - MySQL Full Text Only]]
--> [[Install Redis Caching for Magento]]
--> [[Install Redis Full Page Caching for Magento Enterprise]]
--> [[Setting up a Second Instance of Redis]]
--> [[Magento Setup Return-Path Email]]
--> [[Magento Server Compatibility Check]]
--> [[Magento Database Optimization - Log Cleaning Script]]
--> [[Magento Site Performance Optimization]]
--> [[Magento Log Rotate with logrotate]]
--> [[How to use CDN with Webfonts with Magento]]
--> [[How to Disable Magento Newsletter Module]]
--> [[Magento : Execute Custom Module Cron Manually]]

[[File:Magentos.jpg|100px|frameless|right|alt=Magento2 How To's]]

===Magento 2 Community Edition===
--> [[Upgrade Magento2 via CLI]]
--> [[Enable/Disable Magento2 Maintenance Page]]
--> [[How to set Magento 2 permissions and avoid installation errors]]
--> [[How to speed up Magento 2 out of the box]]
--> [[How to Change Magento 2 mode]]
--> [[How to Enable Disable Magento 2 caches]]
--> [[Magento 2 How to Add Alternative HTTP headers]]
--> [[Magento 2 Purge Varnish Cache]]
--> [[Magento 2 Redis Page Cache and Default Cache Example]]
--> [[Magento 2 How to check Magento Version]]
--> [[Magento 2 Reindex Error: Index is locked by another reindex process. Skipping]]
--> [[Magento 2 Reindex via the CLI]]

[[File:Memcahed.jpg|100px|frameless|right|alt=Mecache Caching]]

===Memcached Server===
--> [[Memcached Monitor Tool]]
--> [[Setup Multi Instance Memcache]]
--> [[Check if Memcached is Running]]
--> [[Flush Your Memcached Instance]]
--> [[Check Memory Usage of Memcached]]
--> [[Memcache running out of Memory?]]
--> [[Memcached List all Keys]]

[[File:Apachelogo.gif|100px|right|alt=Apache How Tos]]

===Apache/PHP===

--> [[Deny access to my site with an .htaccess file]]
--> [[Redirect site to www or non www]]
--> [[Restrict POST request to Website]]
--> [[Install Tomcat6 Server on Centos 6]]
--> [[How to setup an SSL Certificate for Free]]
--> [[Enable Apache to Create Core Dumps]]
--> [[Enable php-fpm to create core dumps]]
--> [[Debug PHP Enabling slow_log]]
--> [[Block Bots by User Agent String]]
--> [[Install mod_extact_forward - Show Real IP behind Proxy]]
--> [[Install ionCube Loaders for Centos]]
--> [[Install Zend Guard with PHP 5.3 on Centos]]
--> [[Install Zend Guard 6.0 with PHP 5.4 on Centos]]
--> [[Disable Mod_Security for a single vhost]]
--> [[Hide PHP Version(X-Powered-By) in Headers]]
--> [[Sessions are ending before MaxLifetime]]
--> [[Apache mod_speling case insensitive urls issue]]
--> [[Restrict access via htaccess via ipaddress]]
--> [[Howto install mod_evasive with fail2ban]]
--> [[Install the Latest version PHP on CentOS]]
--> [[How to bypass .htpasswd for certain IPs Apache]]
--> [[Clear mod_pagespeed cache ]]
--> [[Install GeoIP for Apache and PHP]]
--> [[How to block or allow countries using GeoIP and .htaccess]]
--> [[How to disable mod_security per vhost]]
--> [[Force HTTPS for entire website via htaccess]]
--> [[Restrict Access to wp-login.php and xmlrpc.php]]
--> [[The X-Frame-Options response header]]
--> [[Install Xdebug with php-fpm per pool]]
--> [[How to Enable Gzip Compression]]
--> [[Enable Apache rewrite logging]]
--> [[Protecting Folders with .htpasswd/.htaccess]]
--> [[How to Disable PHP Execution in Certain Directories]]
--> [[Directory listing in htaccess. Allow, Deny, Disable, Enable Directory Listing in .htaccess]]
--> [[What is the Cache-Control Header]]
[[File:Haproxy.png|100px|frameless|right|alt=Mysql Percona]]

===HAProxy===
--> [[What is HAProxy]]
--> [[HAProxy vs Nginx]]
--> [[HAProxy Load Balancing]]
--> [[HAProxy Cluster Setup Example]]
--> [[HAProxy Docker]]
--> [[HAProxy with Varnish SSL Termination Example]]
--> [[HAProxy http2]]
--> [[HAProxy GUI]]
--> [[HAProxy Install on Centos7]]
--> [[HAProxy Cloud Load Balancer]]
--> [[HAProxy Block by User-Agent]]
--> [[HAProxy Restrict by IP Address]]

[[File:Logo percona server new.png|100px|frameless|right|alt=Mysql Percona]]

===Mysql/Percona===
--> [[How to Optimize/Repair a Table]]
--> [[MySQL - Check Which Query is Consuming Resources]]
--> [[How to Set your MySQL Password]]
--> [[Rest your MySQL Admin Password]]
--> [[How to Convert Table to InnoDB]]
--> [[How to install Percona Database Server]]
--> [[How to Access the MySQL via Shell]]
--> [[How to Add a User in MySQL]]
--> [[How to Drop a User in MySQL]]
--> [[How to Create and Delete a MySQL Database]]
--> [[How to Create a Table in MySQL Database]]
--> [[How to Create a MySQL Database Backup]]
--> [[How to Import a MySQL Database]]
--> [[How to update the max_connections setting in MySQL]]
--> [[How to view a list of MySQL users and their privileges]]
--> [[Save MySQL query results into a text or CSV file]]
--> [[How to optimize a MySQL database using phpMyAdmin]]

[[File:Varnish-cache-log.jpeg|100px|frameless|right|alt=Varnish How tos]]

===Varnish Cache===
--> [[Setup Varnish Cache]]
--> [[Setup Varnish for Magento]]
--> [[Setup Varnish for Wordpress]]
--> [[Setup Varnish for MediaWiki]]
--> [[Setup Varnish - Multiple Domains]]
--> [[Setup Varnish - Multiple Ipaddress]]
--> [[Script to Clear a Page from Varnish Cache]]
--> [[Varnish will not restart WHY?]]
--> [[Warm up Varnish Script using Sitemap.xml]]
--> [[Varnish How to redirect non-www URLs to www]]
--> [[Install libvmod-header with Varnish]]

[[File:Nginx-logo.png|100px|frameless|right|Install Nginx|alt=Nginx How tos]]

===Nginx Web Server===
--> [[Setup Nginx PHP FPM Percona Mysql]]
--> [[Wordpress Ngnix Rewrite Rules]]
--> [[Setup up Nginx Caching]]
--> [[Nginx Magento vhost Configuration]]
--> [[Basic HTTP Authentication with Nginx]]
--> [[Protecting Folders with Nginx]]
--> [[403 Forbidden Error Nginx - How to Solve]]

[[File:Sword-of-Omens-Sword1.png|100px|frameless|right|alt=Brian Nelson]]

===Other===
--> [[How to add trusted root certificates]]
--> [[Find:_10_Useful_Examples_of_Find]]
--> [[Send email from PHP to a log file instead of sendmail]]
--> [[Debugging Wordpress]]
--> [[How to install Linux via USB]]
--> [[Network Subnet Mask Cheat Sheet]]
--> [[Linux Keyboard Shortcuts]]
--> [[Setup a SSH Tunnel for Secure Browsing]]
--> [[Install OpenSSH on Windows]]
--> [[Install Qmail on a Fresh Centos Server]]
--> [[Setup Qmail to Listen on port 587 for SMTP]]
--> [[Qmail catch-all account with vpopmail]]
--> [[Setup Incoming Email Pipe to Script for Qmail]]
--> [[Qmail Control Files]]
--> [[Install qmqtool for Qmail on Centos Server]]
--> [[Rest Email Password for vpopmail]]
--> [[How to check Used IP on your Home Network]]
--> [[How to find GMAIL IPs to allow at Firewall]]
--> [[Useful TCPDUMP commands]]
--> [[Remove Email Block Lists]]
--> [[How to disable qmail vpopmail email user]]
--> [[Git Cheat Sheet - Git made easy]]
--> [[Top Chmod Command Examples for Beginners]]
--> [[Benchmarking and Load Testing with Siege]]
--> [[Benchmarking and Load Testing with Apache Bench(AB)]]
--> [[How do I find out more about socket files in /proc/fd]]
--> [[How to Disable the wp-cron.php in WordPress]]
--> [[How to delete mail queue in Postfix]]

--> [[Top Command Line Games - Linux CLI Games]] Cause Linux can be fun

--> [[Centos Oneliners]]

--> [[Bash Script to Check Memory with Email Alert when Low]]
--> [[Bash Script to Check Site Code Status with Email Alert]]