https://www.dangtrinh.com/
https://www.dangtrinh.com/
Category: Uncategorized
pfsense: ping from specific ip
ping -S [gateway-ip] 8.8.8.8
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
ubuntu: remote desktop
Scope: Try to connect to an Ubuntu 18.04 Desktop Computer on my LAN using a Windows 10 Machine Steps to get this going: Ubuntu: Enable Screen Sharing (add password) Install dconf-editor on the Ubuntu Machine sudo apt install dconf-editor Go […]
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}$';
mysql: create super user with access to all tables
CREATE USER 'username' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'username'@'%'; caching_sha2_password problem CREATE USER ''@'your_server_ip ' IDENTIFIED WITH mysql_native_password BY 'your_password';
mysql: extract domain from email
SUBSTR(email_addresses.email_address, INSTR(email_addresses.email_address, '@') + 1)
mysql: extract domain from url
SUBSTRING_INDEX(SUBSTRING_INDEX(REPLACE(a0_custom_import_contacts.website, '//', '.'), '/', 1), '.', -2)
postgresql: incorrect table sizes
do a VACUUM FULL if you want to run this on python you need to set autocommit = True otherwise it will not work. conn.set_session(readonly=True, autocommit=True) sql = """ VACUUM FULL """ cur.execute(sql) conn.commit() conn.set_session(readonly=True, autocommit=False)
python imaplib: search emails with specific subject
result, numbers = mail.uid('search', None, '(SINCE "' + date_start + '" BEFORE "' + date_end + '") (SUBJECT "Failure")')