Get CDR Data from Database of Yeastar P-Series Cloud Edition

Yeastar P-Series Cloud Edition allows you to access the system database and get CDR data. This topic describes how to get CDR data from the PBX database via Navicat software.

Procedure

  1. Grant access to the PBX database
  2. Access the PBX database via Navicat software

Grant access to the PBX database

  1. Log in to PBX web portal, go to Integration > Database Grant.
  2. Turn on Database Grant option and configure the authentication information for the third-party software to access the PBX database.

    • User Name: Use the randomly generated user name or change the name.
    • Password: Use the randomly generated password or change password.
  3. In the Permitted IP section, configure which IP addresses are allowed to access the database.

    1. Click Add.
    2. Enter the permitted IP address and subnet mask.

      In this example, enter the public IP address of the current network 110.80.36.162 and subnet mask 255.255.255.0 to allow all IP addresses in thecurrent network to access the database.

      Note: Restricted from MySQL database, only the two subnet masks are allowed to be filled in: 255.255.255.255 and 255.255.255.0.
  4. Click Save and Apply.

    The Database Address and Port of the PBX will be displayed on the web page and can not be modified.

Access the PBX database via Navicat software

  1. Launch Navicat for MySQL on the PC.
  2. On the Navicat for MySQL, click Connection and select MySQL.

  3. In the pop-up window, enter the following information:

    • Connection Name: Enter a connection name to help you identify it.
    • Host: Enter the database address of PBX
    • Port: Enter 15023.
    • User Name: Enter the user name that is configured on the PBX. In this example, enter mQRpgU7N.
    • Password: Enter the password that is configured on the PBX. In this example, enter Ydugei296kd.
  4. Click Save.
  5. To check CDR data, double click the new connection, and select cdr table.

    For more information about the cdr table, see cdr Table in the PBX Database.