This document explains how to deploy MySQL server on Virtual PBXs
Created: November 2022
Permalink: https://wildix.atlassian.net/wiki/x/AQCkB
Note: The support starts from:
I. Install MySQL server
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:
su
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 'wil01dix'"
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
II. Change settings in WMS
- Go to WMS -> Settings -> PBX -> Call and chat history