mysql: set primary key and autoincrement
ALTER TABLE XXXXXX ADD PRIMARY KEY (ID); ALTER TABLE XXXXXX MODIFY id int NOT NULL AUTO_INCREMENT; ALTER TABLE proxy_ips ADD UNIQUE […]
Category: uncategorized
apache: mod_rewrite not affecting my directory
The .htaccess on my local directory is not being considered. if this is the case go to: go to /etc/apache2/apache2.conf […]
python: imaplib - no way to sort feched uids by date - office365's fault
One could instinctively think that when you search your emails using imaplib as per below, and you get a list of all […]
bash: execute .sql file from bash script
mysql -u user -p < db.sql
powershell: office365 create global rule not to send read receipts
New-TransportRule -RemoveHeader 'Disposition-Notification-To' -Name 'Disable Read Receipt' -StopRuleProcessing:$false -Mode 'Enforce' -Comments ' ' -RuleErrorAction 'Ignore' -SenderAddressLocation 'Header'
office365: disable read receipts on admin console
https://support.archiver.gfi.com/hc/en-us/articles/360015215999-Configuring-Rule-to-Delete-Read-Receipts-for-Emails-Sent-by-Journaling-Mailbox-in-Office-365
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 ' […]
get server ip
curl http://icanhazip.com
unifi: configure dtim and beacon interval
The DTIM can be changed through the controller, but the Beacon is not that easy. It can kind of be […]
imaplib: get amazonses dsn
import email msg = email.message_from_string(emailstr) if (msg.is_multipart() and len(msg.get_payload()) > 1 and msg.get_payload(1).get_content_type() == 'message/delivery-status'): # email is DSN print(msg.get_payload(0).get_payload()) […]