Related Articles
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 […]
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 […]
Fix Asterisk 1 way Audio Issues
NAT issues Perhaps the most common problem encountered is one-way audio, and 99% of the time, this is caused by a NAT firewall. So here are the steps you must take to configure the PBX to work behind a NAT firewall. Make sure you have a resolvable address on the Internet. If you don’t want […]