Related Articles
How to Update Third-Party SSL Certificates on GitLab
Updating third-party SSL certificates on GitLab involves replacing the existing certificate files with the new ones and reconfiguring GitLab. Here’s how to do it 1. Obtain New SSL Certificates You can use my CSR Generator to generate a CSR and acquire the SSL certificate. – Acquire the updated SSL certificate and private key from your […]
Connect Cisco SPA400 SIP Gateway (4 FXO Ports) with Asterisk
On Asterisk /etc/asterisk/sip.conf, you need to configure the account exactly similar to User ID of SPA400 The entries in sip.conf to enable Asterisk register to SPA400 are as follow: [general] register => [email protected]/9000 Replace 9000 with the value you entered in the User ID of SPA400, and replace 192.168.0.2 with the IP address of the […]
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 […]