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)
April 15, 2021uncategorized python imaplib: search emails with specific subject result, numbers = mail.uid('search', None, '(SINCE "' + date_start + '" BEFORE "' + date_end + '") (SUBJECT "Failure")')
April 15, 2021April 15, 2021uncategorized postgresql: incorrect table sizes do a VACUUM FULL if you want to run this on python you need to set autocommit = True otherwise it […]