April 23, 2021uncategorized openvpn: ignore redirect gateway https://community.openvpn.net/openvpn/wiki/IgnoreRedirectGateway
April 23, 2021April 23, 2021uncategorized digital ocean api controller doctl auth init --access-token $DO_TOKEN
April 23, 2021April 23, 2021uncategorized gitea: create admin user gitea admin user create --admin --username [username]--password [password] --email [emailaddress] touch README.md git init […]
April 20, 2021April 20, 2021uncategorized test email server configuration best general option https://mxtoolbox.com/MXLookup.aspx for gmail and google apps https://toolbox.googleapps.com/apps/checkmx/ remember to setup dkim and dmarc, and consider […]
April 20, 2021April 20, 2021blogs to follow, uncategorized https://www.dangtrinh.com/ https://www.dangtrinh.com/
April 18, 2021April 18, 2021uncategorized mysql: delete records with special characters DELETE FROM [table] where First_Name REGEXP '[^a-zA-Z0-9- ]' OR Last_Name REGEXP '[^a-zA-Z0-9- ]' OR Company REGEXP '[^a-zA-Z0-9-& ]' OR website […]
April 18, 2021April 19, 2021uncategorized ubuntu: add user to another group source: https://www.howtogeek.com/50787/add-a-user-to-a-group-or-second-group-on-linux/ usermod -a -G examplegroup exampleusername
April 17, 2021April 17, 2021mysql, uncategorized mysql: extract domain from email SUBSTR(email_addresses.email_address, INSTR(email_addresses.email_address, '@') + 1)
April 17, 2021uncategorized mysql: extract domain from url SUBSTRING_INDEX(SUBSTRING_INDEX(REPLACE(a0_custom_import_contacts.website, '//', '.'), '/', 1), '.', -2)