Showing posts from March, 2022

Digital Marketing

Separate partition for /var/log

It is advised that admins should mount /var/log on a separate partition to avoid out of control logs from filling the storage where the root of the filesystem resides.  This is critical when the server receives log files from many remote devices.

How to install mycli

$ pip3 install mycli

Export data in csv from mycli

\T csv ; \o ~/Downloads/export.csv ; SELECT * FROM my_table LIMIT 8

Graylog is a centralized logging solution that enables aggregating and searching through logs.

Graylog provides a powerful query language, a processing pipeline for data transformation, alerting abilities, and much more. It is fully extensible through a REST API. Add-ons can be downloaded from the Graylog Marketplace .

Install Docker Compose on AWS EC2

sudo pip3 install docker-compose docker-compose --version docker-compose version 1.29.2, build unknown

Install Docker on AWS EC2

// update sudo yum update -y // install most recent package sudo amazon-linux-extras install docker // start the service docker sudo service docker start // add the ec2-docker user to the group sudo usermod -a -G docker ec2-user

Adding or changing a passphrase for an existing private key

You can change the passphrase for an existing private key without regenerating the keypair by typing the following command: $ ssh-keygen -p -f ~/.ssh/id_rsa > Enter old passphrase: [Type old passphrase] > Key has comment '' > Enter new passphrase (empty for no passphrase): [Type new passphrase] > Enter same passphrase again: [Repeat the new passphrase] > Your identification has been saved with the new passphrase. If your key already has a passphrase, you will be prompted to enter it before you can change to a new passphrase.

Copy file content to clipboard by command line on Linux

Example: $ clip < ~/.ssh/


HEA HEA.U - Horizons Enhanced Income US Equity (USD) ETF HEE - Horizons Enhanced Income Energy ETF HEF - Horizons Enhanced Income Financials ETF HEJ - Horizons Enhanced Income International Equity ETF HEP - Horizons Enhanced Income Gold Producers ETF HEX - Horizons Enhanced Income Equity ETF HGY - Horizons Gold Yield ETF