This document explains how to deploy MySQL server on Virtual PBXs
Created: November 2022
Permalink: https://wildix.atlassian.net/wiki/x/AQCkB
Introduction
Using this instruction, you can deploy MySQL server to be used on your Virtual PBX and set up CDRs to use the MySQL database.
Note: The support starts from: WMS Beta ____
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:
- In Call and chat history, proceed to CDR MySQL tab and enter the necessary data:
- Settings for standalone mode:
- Hostname: 127.0.0.1
- Database name: cdr
- CDR table name: cdr
- User: root
- Password: wil01dix
- Port: 3306
Settings for WMS Network mode (Client PBX):
- Hostname: <master of wms-network ip address>
- Database name: cdr
- CDR table name: cdr
- User: root
- Password: wil01dix
- Port: 3306
- Settings for standalone mode:
- In Call and chat history, go to the Settings tab and change CDR-backend to MySQL: