Page Comparison

Scroll export button

Info

This document explains how to deploy MySQL server on Virtual PBXs

Created: November 2022

Table of Contents

...

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.

Warning
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:

Code Block
apt-get install mysql-server

3. Create database for CDR:

Code Block
mysql -u root -Bse 'create database cdr'

4. Change credentials for root user:

Code Block
mysql -u root -Bse "ALTER USER 'root'@'localhost' IDENTIFIED BY 'wil01dixwildix'"

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):

Code Block
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 WMSGo to WMS -> Settings -> PBX -> 

...

Call and chat history:

Image Added
In Call and chat history, proceed to CDR MySQL tab and enter the necessary data:

Image Added
1. Settings for standalone mode:
  - Hostname: enter hostname
  - Database name: enter name of the database
  - CDR table name: enter name of the table
  - User: root
  - Password: enter password
  - Port: 3306
2. Settings for WMS Network mode (Client PBX):
  - Hostname: <master of wms-network ip address>
  - Database name: enter name of the database
  - CDR table name: enter name of the table
  - User: root
  - Password: enter password
  - Port: 3306
In Call and chat history, go to the Settings tab and change CDR-backend to MySQL:

Image Added

Macrosuite divider macro

dividerType	text
dividerWidth	70
emoji	{"id":"smile","name":"Smiling Face with Open Mouth and Smiling Eyes","short_names":["smile"],"colons":":smile:","emoticons":["C:","c:",":D",":-D"],"unified":"1f604","skin":null,"native":"😄"}
textColor	#000000
dividerWeight	1
labelPosition	middle
textAlignment	center
iconColor	#0052CC
fontSize	medium
text	Not finding the help you need? Join the Facebook group to ask a question!
emojiEnabled	false
dividerColor	#DFE1E6
dividerIcon	bootstrap/CloudsFill

...