This document explains how to deploy MySQL server on Virtual PBXs Created: November 2022 Permalink: https://wildix.atlassian.net/wiki/x/AQCkB |
Using this instruction, you can deploy MySQL server to be used on your Virtual PBX and set up CDRs to use the MySQL database.
Important: If you plan to use MySQL in WMS Network, the below steps need to be completed only for the Server PBX. |
1.Go to terminal and authorise under sudo permissions using "su" command.
2. Install MySQL package:
apt-get install mysql-server |
3. Create database for CDR:
mysql -u root -Bse 'create database cdr' |
4. Change credentials for root user:
mysql -u root -Bse "ALTER USER 'root'@'localhost' IDENTIFIED BY 'wildix'" |
In case of a WMS Network: If you want to install MySQL server for your all WMS Network, run the following commands (optional, only for Server PBX):
sed 's/bind-address.*/bind-address = 0.0.0.0/g' /etc/mysql/mariadb.conf.d/50-server.cnf systemctl restart mariadb.service |
Settings for WMS Network mode (Client PBX):