digital ocean api controller
doctl auth init --access-token $DO_TOKEN
Read more >gitea: create admin user
gitea admin user create --admin --username [username]--password [password] --email [emailaddress] touch README.md git init git checkout -b main git add . git commit -m "first commit 2" git remote add origin ssh://git@[remote_ip]:22022/[user]/[repo_name].git […]
Read more >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 that using dmarc policy reject or quarentine can cause some problems. some say its better to use p=none […]
Read more >https://www.dangtrinh.com/
https://www.dangtrinh.com/
Read more >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 NOT REGEXP '^(https?://|www\\.)[\.A-Za-z0-9\-]+\\.[a-zA-Z]{2,4}' OR Email NOT REGEXP '^[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$';
Read more >ubuntu: only route traffic through vpn tunnel
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
Read more >mysql: extract domain from email
SUBSTR(email_addresses.email_address, INSTR(email_addresses.email_address, '@') + 1)
Read more >mysql: extract domain from url
SUBSTRING_INDEX(SUBSTRING_INDEX(REPLACE(a0_custom_import_contacts.website, '//', '.'), '/', 1), '.', -2)
Read more >mysql: capitalize first word of all words
credits to: http://joezack.com/2008/10/20/mysql-capitalize-function/ create a function: CREATE FUNCTION CAP_FIRST (input VARCHAR(255)) RETURNS VARCHAR(255) DETERMINISTIC BEGIN DECLARE len INT; DECLARE i INT; SET len = CHAR_LENGTH(input); SET input = LOWER(input); SET i = 0; WHILE (i < len) DO […]
Read more >