Scroll export button | ||||||||
---|---|---|---|---|---|---|---|---|
|
Info |
---|
This document explains how to deploy MySQL server on Virtual PBXs Created: November 2022 Permalink: https://wildix.atlassian.net/wiki/x/AQCkB |
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.
I. Install MySQL server
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 |
---|
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):
...
II. Change settings in WMS
- Go to WMS -> Settings -> PBX -> Call and chat history Call and chat history:
- In Call and chat history, proceed to CDR MySQL tab and enter the necessary data:
- 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
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
- Settings for standalone mode:
- In Call and chat history, go to the Settings tab and change CDR-backend to MySQL:
Macrosuite divider macro | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...