Email: inbox [at] sysadmin.lk
LinkedIn: https://www.linkedin.com/in/prabatht
Facebook: https://www.facebook.com/prabath.hinoize
Related Articles
Let’s Encrypt SSL for GitLab
To enable Let’s Encrypt SSL for GitLab, follow these steps. Ensure that GitLab is configured properly and you have root access to your GitLab instance. The steps apply to GitLab’s Omnibus installation. 1. Ensure Prerequisites A publicly accessible domain name pointing to your GitLab server. Port 80 (HTTP) and port 443 (HTTPS) open on your […]
Update oVirt hosted-engine host certificates VM if the are expired
Environment: Red Hat Virtualization 4.4 Issue: All the hosted-engine hosts vdsm certificates are expired. The hosted-engine VM is down and it’s unable to start it using hosted-engine –vm-start because of expired certificates. Resolution: Since CA of the RHV environment is the RHV manager which is down, we have to get the CA certificates and keys to the host […]
Useful MySQL Commands
Database with size SELECT table_schema “DB Name”, Round(Sum(data_length + index_length) / 1024 / 1024, 1) “DB Size in MB” FROM information_schema.tables GROUP BY table_schema; Create a database. mysql> create database [databasename]; List all databases on the server. mysql> show databases; Switch to a database. mysql> use [db name]; To see all the tables in the […]