Force Git to overwrite local changes if there is a branch conflict
Use code you find here at your own risk! I am not responsible if you damage your data or system by following any instructions you find here. Navigate to your…
Subfolders
Latest "IT Grimoire" files
Force Git to overwrite local changes if there is a branch conflict
Getting Web Browsers Not To Blur Images on Retina Screens
Unfortunately this must be set by site, but on retina screens on MacOS, many browsers blur small images, such as 88x31 buttons. You can overcome this, at least for the…
How to fix if the “Save” button is grayed out in Photoshop CC 2017 save and export dialogs
I don't know if this affects other versions of Photoshop, but on MacOS Photoshop CC 2017 frequently starts unexpectedly graying out all save buttons when you have made changes to…
Filtering LinkedIn Posts, Notifications, and Comments by keyword
I use the uBlock Origin browser plugin to filter my LinkedIn Posts, Notifications, and Comments to hide anything containing objectionable topics. uBlock Origin allows you to add custom rules to…
Deactivating, deleting, and completely removing a plugin that WordPress won’t let you deactivate
I installed the WordPress plugin LWS Optimize, which turned out to be unusably broken (which is the reason I'm not linking to it) and made my site unusable. To make…
Website returns 503 server errors, but no errors in logs
Had a weird one today. Last one website of the several of on this server suddenly started returning 503 (service unavailable) errors. There was nothing in the PHP error log…
Get names of all input fields in a FileMaker Pro table
ExecuteSQL ( "SELECT FieldName FROM FileMaker_Fields WHERE TableName='[TABLE NAME]' AND FieldClass='Normal'",",","¶")
How to monitor RAM for tuning pm.max_children
How to monitor RAM usage: free -h: This command shows your system's total, used, and free memory in a human-readable format. Key metrics: total: Total RAM. used: RAM currently in…
Add sar logging for CPU, RAM, and disk I/O
Add or change /etc/cron.d/sysstat to this. This creates a cron jobe to write file /tmp/outage_resource_log.txt that keeps minute-by-minute stats, sometimes useful in troubleshooting slowdowns. However, it's not a great way…
Add /fpm-status page to Apache virtual host
Add this to virtual host file in /etc/apache2/sites-available/, right below DocumentRoot, in both :80 and :443 sections SetHandler "proxy:unix:/var/php-fpm/170027027353667.sock|fcgi://127.0.0.1" Require all granted May need in /etc/php/8.2/fpm/pool.d/www.conf, not sure: pm.status_path =…
View last 200 lines of all access logs on apache server
find [path/to/access/logs/folder] -name "*_access_log" -exec sh -c 'tail -200 "$1" | grep -v "HetrixTools\|ok\.txt\|canary" | sed "s/$/ [$(basename "$1" _access_log)]/"' _ {} \; | sort -k4,4 The grep -v "HetrixTools\|ok\.txt\|canary"…
How to check Fail2ban log
Command to check fail2ban's log is sudo tail -f /var/log/fail2ban.log
Linux PHP tuning utilities & commands
1. See memory consumed by php-fpm8.2 (change this to match different PHP version if necessary) ps --no-headers -o "rss,cmd" -C php-fpm8.2 | awk '{ sum+=$1 } END { printf ("%d%s\n",…
Linux SQL Tuning Utilities
1. tuning-primer.sh Run from Github: curl -L https://raw.githubusercontent.com/BMDan/tuning-primer.sh/main/tuning-primer.sh | bash 2. MySQLTuner.pl wget http://mysqltuner.pl/ -O mysqltuner.pl wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/basic_passwords.txt -O basic_passwords.txt wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/vulnerabilities.csv -O vulnerabilities.csv perl mysqltuner.pl --host 127.0.0.1 --user [user]…
