SIPtrix – procedure to fix duplication of recorded calls in ARI (Asterisk Recording Interface)

Background

SIPtrix server versions 1.2 through to 1.6 have an issue within the ARI screen  which shows links to recorded calls, but all the links actually play the same recording. This is due to a bug, introduced in one of the Asterisk modules, which fails to give the log of the recording a unique ID in the call recording database.

Solution

The configuration of the affected module must be modified, and the module re-compiled.

Other considerations

The SIPtrix server must be shut down for this to take place, and because the call recording database will still contain non-unique IDs, it must be cleared, which will loose all the call logs up to that point in time. However, files on the local hard disk of the SIPtrix server containing previously recorded calls will remain on the disk. Time taken to complete the procedure – about 10 minutes.

Prerequisites

As already mentioned, the Asterisk service must be shut down for this process to be run, so the server will not be available to answer calls during this time; root access through PuTTy will be required; access to the SIPtrix GUI will also be required. Any required reporting from the existing call recording database must have been completed.

Procedure

1. Take a backup of the system, using the Backup and Restore option from the Tools menu in the GUI. See the manual for more details if required.

1. Ensure no calls are being handled by the system, and that the system won’t be required for at least 10 minutes

1. Using PuTTy, connect to the console of the server, logging in as root

1. At the # prompt, type amportal stop; Asterisk will be shut down

1. Type cd/usr/src/asterisk-addons

1. Type mv Makefile Makefile.orig
2. Type cp -p ../asterisk-addons.old/Makefile .   ***Note there is a “.” at the end of this command

1. Type make clean

1. Type make install

1.  Using the GUI, go to the Tools Menu

If there is a menu option on the left hand side titled “phpMyAdmin”, proceed to step 12

1.  If phpMyAdmin does NOT appear on the left hand side of the Tools menu, it needs to be added. Click on the option “Module Admin”; locate module phpMyAdmin from the list and click the corresponding “Install” button. After the page refreshes, scroll back down to the phpMyAdmin module and click “Enable” – phpMyAdmin will now appear on the menu.

1. Locate the phpMyAdmin menu option under the tools menu and click it. A new browser window will open. You now have access to the underlying Asterisk databases so great care must be taken to not make any modifications other than as outlined in these instructions.

1.  In the left hand pane, click the drop-down menu under “Databases” select the database called “asteriskcdrdb (1)”

1.  In the right-hand pane, click on the “Dustbin” icon

Confirm that you want to Truncate (empty) the database table

1.  Return to the PuTTy window and type reboot

1.  Once the server has rebooted, verify the operation of the SIPtrix server and check through the Asterisk Recording Interface that recorded calls now appear correctly and can be played back.