NethVoice CTI: deleting a recording does not work

[andrea-marchionni]

The NethVoice CTI removes the audio file when a call recording is deleted.

However, the interface does not recognize that the file is no longer available and continues to display it as if the recording still exists.

This is the error when trying to interact with the file which is still shown after deleting it

Error: ENOENT: no such file or directory, unlink '/var/spool/asterisk/monitor/2025/01/10/exten-92252-253-20250110-103636-606.wav'

The issue may arise because the CDR database entry for the call still contains the value of the recording's audio file, even after the NethVoice CTI has deleted the file.

To determine whether a call has an associated recording, NethVoice CTI should rely on the recordingfile field of the call entry in the CDR database.

+---------------------+-------------------------+-----+-----+-----------+----------------------+--------------------+---------+---------------------------------------------------------------------------------+----------+---------+-------------+----------+-------------+------------------+-----------+-----+----------------------------------------+------+-----------------+---------------+---------------+----------------+------------------+-------------+----------+----------+--------------+
| calldate            | clid                    | src | dst | dcontext  | channel              | dstchannel         | lastapp | lastdata                                                                        | duration | billsec | disposition | amaflags | accountcode | uniqueid         | userfield | did | recordingfile                          | cnum | cnam            | outbound_cnum | outbound_cnam | dst_cnam       | linkedid         | peeraccount | sequence | ccompany | dst_ccompany |
+---------------------+-------------------------+-----+-----+-----------+----------------------+--------------------+---------+---------------------------------------------------------------------------------+----------+---------+-------------+----------+-------------+------------------+-----------+-----+----------------------------------------+------+-----------------+---------------+---------------+----------------+------------------+-------------+----------+----------+--------------+
| 2025-01-10 10:17:13 | "Mario Garramone" <252> | 252 | 253 | ext-local | PJSIP/92252-00000c1e | PJSIP/253-00000c21 | Dial    | PJSIP/92253/sip:[email protected]:1334;transport=tls&PJSIP/91253/sip:91253@167 |       38 |      31 | ANSWERED    |        3 | 252         | 1736500633.31160 |           |     | exten-253-92252-20250110-101729-19.wav | 252  | Mario Garramone |               |               | Vittorio Russo | 1736500633.31160 | 252         |     6833 |          |              |
+---------------------+-------------------------+-----+-----+-----------+----------------------+--------------------+---------+---------------------------------------------------------------------------------+----------+---------+-------------+----------+-------------+------------------+-----------+-----+----------------------------------------+------+-----------------+---------------+---------------+----------------+------------------+-------------+----------+----------+--------------+