I will assume that you want to install the CloudWatch agent on an EC2 instance (as opposed to an on-premise server). I took the example of sending Apache logs to CloudWatch Logs. First, make sure your EC2 instance has an… Read More
Blog
How to convert Maildir to mbox?
Make sure you have the procmail package installed, and then run the following: $ for i in MAILDIR/cur/*; do formail -I "Status: RO" < "$i" >> MBOX; done I work as a freelancer, so if you don’t want to do… Read More
How to show the disk space used by MySQL tables?
Connect to your MySQL server and run the following: mysql> select table_name, round(((data_length + index_length) / (1024 * 1024)), 2) as `Size in MB` from information_schema.tables where table_schema = ‘YOUR_DB_NAME’ order by `Size in MB`; I work as a freelancer,… Read More
How to properly use certbot with Nginx on Ubuntu?
Install and configure Nginx: $ sudo apt update $ sudo apt install nginx $ sudo rm /etc/nginx/sites-enabled/default $ sudo vi /etc/nginx/sites-available/MYSITE # See below $ sudo ln -s /etc/nginx/sites-available/MYSITE /etc/nginx/sites-enabled $ sudo systemctl restart nginx The /etc/nginx/sites-available/MYSITE config file should… Read More
How to install an old version of PHP using geerlingguy.php on Ubuntu target
Your playbook should look like so: — – hosts: XYZ become: yes pre_tasks: – name: Add repository for old PHP apt_repository: repo: ppa:ondrej/php update_cache: yes state: present roles: – role: geerlingguy.apache … – role: geerlingguy.php php_webserver_daemon: apache2 php_default_version_debian: "7.1" php_version:… Read More
How to install and kick off minikube on Ubuntu?
Install kubectl: $ sudo apt update $ sudo apt install apt-transport-https $ curl -sSL https://packages.cloud.google.com/apt/doc/apt-key.gpg | sudo apt-key add – $ echo "deb http://apt.kubernetes.io/ kubernetes-xenial main" | sudo tee -a /etc/apt/sources.list.d/kubernetes.list $ sudo apt update $ sudo apt install kubectl… Read More
How to do a basic install of Prometheus on Ubuntu?
Machine requirement I will assume your machine is Ubuntu >= 16.04. Please make sure only ports 80 and 443 are open. I assume there are two DNS entries to your machine, such as prometheus.blablabla.com and grafana.blablabla.com (replace as appropriate throughout… Read More
How to programmatically know your external IP address?
You are probably used to type “what is my ip” in google to know this, but how can you do that in a shell script? Here it is: $ curl ifconfig.co Simple! I work as a freelancer, so if you… Read More
How to install Docker on Ubuntu
Follow the steps to install Docker Community Edition: $ sudo apt install curl software-properties-common $ curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add – $ sudo add-apt-repository "deb [arch=amd64] https://download.docker.com/linux/ubuntu $(lsb_release -cs) stable" $ sudo apt update $ sudo apt install… Read More
How to enable and analyse the slow query log on MySQL?
Set the following variables in your MySQL config file: slow_query_log = 1 (means true) long_query_time = 0 (means 0 seconds) log_queries_not_using_indexes = 1 (means true) log_output = FILE (default is TABLE) Setting long_query_time to 0 will instruct MySQL to log… Read More