Yeastar MyPBX Enterprise. SMDR/CDR data format and connection settings


This data is being extracted with help of the "Advanced PBX Data Logger" software only. It may not applicable for other software titles.

Customized configuration

Introduction

The system configuration files included asterisk configurations are stored into database first and then logistically generated by the background applications. If you would like to manually modify the configurations in /etc/asterisk/, the configuration file will be updated when customers apply the changes on WEB GUI next time. Reboot the device will result in the update of configuration file as well. Namely, the customized modifications by clients can't be saved successfully.

Solution

If you want to save the user-defined data, you must save it to the database. In the directory of "/persistent/var/lib/asterisk/db/", you may find a directory "custom-cfg" to store user-defined data. You should place an appropriate configuration file under this directory. Modified data must saved in "/persistent/var/lib/asterisk/db/custom-cfg/manager_custom.conf".

Step 1

1. Go to WEB GUI → Network Preferences → LAN Settings.
2. Enable SSH temporarily.
3. Remember the SSH port number.
4. Save and apply the changes.

LAN Settings

Step 2

1. Go to WEB GUI → Security Settings → AMI Settings.
2. Specify the user name: ami (you may change the user name, but remember it. It will be used below).
3. Specify any strong password.
4. Specify the permitted IP address and subnet mask. This is the IP address of the computer with Advanced PBX Data Logger. Therefore this computer must have the static IP address. Only the specified computer can use the AMI interface.
5. Save the changes, but do not apply the changes yet.

AMI Settings

Step 3

1. Open any telnet utility with SSH support. We recommend to use PuTTY.
2. Connect to your PBX. Use your PBX IP address and the SSH port from "Step 1".

PuTTY SSH Login

3. Login as root. The default password for root is ys123456.
4. Type in the command prompt cd /persistent/var/lib/asterisk/db/custom-cfg/ to change the current directory.
5. Type in the command prompt vi manager_custom.conf to open a simple editor.
6. In the editor you must add 2 new rows (see below). Note: you must specify the user name from "Step 2" in the square brackets.

[ami]
read = all

7. Press the <ESC> button and type :wq to save the changes. The corresponding file must be on the PBX.

SSH console

Step 4

1. Go to WEB GUI → Network Preferences → LAN Settings.
2. Disable SSH.
3. Save and apply the changes.

PBX Data Logger Settings

1. The logger should work in TCP client mode. The PBX being in permanent listening on port 5038, therefore you need to specify x.x.x.x:5038, where x.x.x.x should be the IP address of your PCX (e.g. 10.0.0.150).

TCP Client Mode

2. Select the corresponding data query and parser plugin.

Parser and Query plugins

3. Click the "Setup" button near the "Data query" box.
4. Specify your login and password.

Password Settings

5. Clock "OK" and save all changes.

Data items

DescriptionData typeColumn name
Account codestringACC
Destination numberstringDIALED_PHONE
Caller ID NamestringFLAG1
Caller numberstringCALLER_PHONE
Call typestringCALL_TYPE
DirectionstringDIRECTION
TrunkstringTRUNK
ExtstringEXT
Call timedatetimeCALL_TIME
Call duration (sec)integerCALL_DURATION_S
Call durationdatetimeCALL_DURATION
Total duration (sec)integerTOTAL_DURATION_S
Ring duration (s)integerRING_S
Ring durationdatetimeRING
Call IDstringFLAG2

Interested in reports for PBX usage?

We offer the PBX Reports utility with various manual, scheduled and email reports, built-in web-server, and other features. Look here

Want PBX call logs in a database?

This is the standard feature. The logger captures exports SMDR or CDR data in real-time to your database. Follow this link

Note: Products and companies mentioned here are used only for definition and identification purposes and can be trademarks and/or registered trademarks of the respective companies.