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:
- In Call and chat history, proceed to CDR MySQL tab and enter the necessary data:
- Settings for standalone mode:
- Hostname: 127.0.0.1 enter hostname
- Database name: cdr enter name of the database
- CDR table name: cdr enter name of the table
- User: root
- Password: wil01dix enter password
- Port: 3306
Settings for WMS Network mode (Client PBX):
- Hostname: <master of wms-network ip address>
- Database name: cdr enter name of the database
- CDR table name: cdr enter name of the table
- User: root
- Password: wil01dix enter password
- Port: 3306
- Settings for standalone mode:
- In Call and chat history, go to the Settings tab and change CDR-backend to MySQL:
...