Email: inbox [at] sysadmin.lk
LinkedIn: https://www.linkedin.com/in/prabatht
Facebook: https://www.facebook.com/prabath.hinoize
Related Articles
How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?
This is the full step-by-step procedure to resync a master-slave replication from scratch: At the master: And copy the values of the result of the last command somewhere. Without closing the connection to the client (because it would release the read lock) issue the command to get a dump of the master: Now you can release the […]
Password Validation Plugin in MySQL
The validate_password plugin serves to test passwords and improve security. The plugin exposes a set of system variables that enable you to define password policy. First check the plugin directory of MySQL. mysql> show variables like “plugin%”; +—————+————————–+ | Variable_name | Value | +—————+————————–+ | plugin_dir | /usr/lib64/mysql/plugin/ | +—————+————————–+ 1 row in set (0.00 […]
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 => 9000@192.168.0.6/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 […]