Regex Between Two Strings
cat mobile_errors.txt.txt | grep -o -P '(?<=returned for booking ).*(?= with error code)' | sort | uniq > mobile_error_bookings.txtThe magic of this search is here:
grep -o -P '(?<=beginning string with space at end ).*(?= ending string with space at start of it)Website Traffic Analysis with goaccess better than Webalizer
Installation
sudo apt-get install goaccessTerminal Version
Use "NCSA Combined Log Format"
goaccess /home/mruckman/Desktop/apache-log-files-202X-mm-dd/var/log/httpd/access_log -o report.html --log-format=COMBINEDThere are keys you can use to navigate panels and browser forward and backwards. Type ? for help screen.
[Tab] and [Shift]+[Tab] key navigates between panels
Hit [Enter] to open a panel and then
[Ctrl] + [f] is forward
[Ctrl] + [b] is backward
Generate an HTML Report
goaccess /home/mruckman/Desktop/apache-log-files-202X-mm-dd/var/log/httpd/access_log -o report.html --log-format=COMBINEDConvert PEM to PPK
Refer: https://www.baeldung.com/linux/pem-ppk-keys
sudo apt-get install -y putty-tools
Private
puttygen id_rsa.pem -O private -o id_rsa_private.ppkPublic
puttygen id_rsa.pem -O public -o id_rsa_public.ppkTrello Replacement WeKan
Refer: https://wekan.github.io/
Docker Version: https://github.com/wekan/wekan/wiki/Docker
Ignore Markdown rules in Visual Studio Code
Create a .markdownlint.json file and place it in the root folder of your project.
{
"default": true,
"MD034": false
}Linking Domains to your GoDaddy Account
When GoDaddy upgraded and change my server package, we move my domains from one plan to another; however, the sites never went live on the new servers. This was because GoDaddy's automated process did not update my DNS settings properly. Do this manually.
Get the IP address of the new server, and you need to go through each domain that you own and update the A records for the DNS.
Import One SQLite Database into Another
From inside SQLite Browser
INSERT INTO temp
SELECT * from two.temp;Sample Code
ATTACH DATABASE 'other.db' AS other;
INSERT INTO other.tbl
SELECT * FROM main.tbl;WordPress Plug-ins
All-in-One WP Migration
WP Githuber MD – WordPress Markdown Editor
Limit Login Attempts Reloaded
Easy Hide Login
Disable Embeds
Custom Meta Widget bitacre
TurnOffSmartQuotesPlug-in to upload large files with All-in-One WP Migration
Using All-in-One WP Migration Plug-in
You MUST use these two settings for things to work.
- You can use this plug-in to export your site; however, test it first with Docker and YOU CANNOT export the plug-ins. It wil break the site!
- Also, YOU MUST go into your settings and make your permalinks
You should install the plug-in to upload large files too, on your target WordPress - all-in-one-wp-migration-file-extension.zip
You can also use "Traktor-1.1.exe" to extract the files, but it might be easier to just import using Docker and WordPress itself.