UCP Call History Is Not Able To Play Outbound Call Recordings or Download Them

Hello Everyone,

I just upgraded to FreePBX 6.12.65-20 (Asterisk Ver. 13.0.0), all modules have been updated but I have chosen not to install some of the commercial modules, which I believe is irrelevant to this issue. After upgrading, I logged into the UCP (12.0.0beta35) successfully and was able to access everything but for some reason I am unable to play or download outbound call recordings in my Call History. Whenever I click “Play” on a outbound call recording only the embedded player opens up but nothing happens; when I click “Download”, “File Not Found” pops up in my web browser. When I click “Download” the web browser address for the call recording shows this:

http://"Server IP"/ucp/?quietmode=1&module=cdr&command=listen&msgid=1415295700_2418&type=download&format=wav&ext=1003

When in fact the message is saved on my system in this format:

force-"Some 10 Digit Phone Number"-1003-20141106-124140-1415295700.2418.wav

Now here is an example of a intercom call recording from another associate which I am able to download and play within the UCP just fine:

http://"Server IP"/ucp/?quietmode=1&module=cdr&command=listen&msgid=1415291552_1830&type=download&format=wav&ext=1003

File format on system: exten-1003-1010-20141106-113232-1415291552.1830.wav

Inbound call recordings play and download just fine as well.

Also, the UCP does not display the CallerID on the outbound call recording (see screen-shot) The UCP only displays two quotation marks. Would anyone be able to assist me with this matter as I’m stuck. Any help is always appreciated!

Can you please go to CDR reports in the administration interface and see if you can play the file from there?

Also note that 13 seconds is really short and is usually indicative or nothing being recorded.

Thanks for the reply! I went into my CDR and that same 13 second call recording played just fine. I was also able to download it as well. Also, in the CDR it lists the outbound CallerID number unlike the UCP.

Please connect to the asteriskcdrdb and run:

select * from cdr where uniqueid = "1415295700.2418";

Bring that data back over here. Please replace sensitive numbers with “99999”

If this post is not adequate then let me know, I would be happy to post it on Pastebin.com if that helps.

mysql> select * from cdr where uniqueid = “1415295700.2418”;
±--------------------±----------------±-----------±-----------±--------------±------------------±-----------------------------±--------±--------------------------------------±---------±--------±------------±---------±------------±----------------±----------±----±----------------------------------------------------------±-----±----------------±--------------±--------------±---------+
| 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 |
±--------------------±----------------±-----------±-----------±--------------±------------------±-----------------------------±--------±--------------------------------------±---------±--------±------------±---------±------------±----------------±----------±----±----------------------------------------------------------±-----±----------------±--------------±--------------±---------+
| 2014-11-06 12:41:40 | “” <“99999”> | “99999” | “99999” | from-internal | SIP/1003-00000183 | SIP/fpbx-1-“99999”-00000184 | Dial | SIP/fpbx-1-“99999”/“99999”,300,Tt | 13 | 3 | ANSWERED | 3 | | 1415295700.2418 | | | force-“99999”-1003-20141106-124140-1415295700.2418.wav | 1003 | John Doe | “99999” | | |
±--------------------±----------------±-----------±-----------±--------------±------------------±-----------------------------±--------±--------------------------------------±---------±--------±------------±---------±------------±----------------±----------±----±----------------------------------------------------------±-----±----------------±--------------±--------------±---------+
1 row in set (0.16 sec)

mysql>

ahh. Im thinking it may be the quotation marks. Do you see a correlation between quotations and not being able to play the files?

Yes, I do see a correlation between the quotations. Here is the web browser address of an incoming call recording that plays and downloads just fine in the UCP Call History:

http://"99999"/ucp/?quietmode=1&module=cdr&command=listen&msgid=1415296440_2542&type=download&format=wav&ext=1003

and here is how my system names the call recording audio file:

force-"99999"-unknown-20141106-125401-1415296440.2542.wav

I apologize for the length of this output, but the inbound call goes through our Ring Group. Here is the asteriskcdrdb of call recording id: 1415296440.2542:

'mysql> use asteriskcdrdb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from cdr where uniqueid = “1415296440.2542”;
±--------------------±-----------------------------±-----------±-----±-------------------±-----------------------------±------------------±----------±--------------------------------------------------------------------------------±---------±--------±------------±---------±------------±----------------±----------±----±-------------------------------------------------------------±-----------±--------------±--------------±--------------±---------+
| 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 |
±--------------------±-----------------------------±-----------±-----±-------------------±-----------------------------±------------------±----------±--------------------------------------------------------------------------------±---------±--------±------------±---------±------------±----------------±----------±----±-------------------------------------------------------------±-----------±--------------±--------------±--------------±---------+
| 2014-11-06 12:54:30 | “DOE JANE” <“99999”> | “99999” | 1006 | from-did-direct | SIP/fpbx-1-“99999”-00000199 | SIP/1006-0000019a | Dial | SIP/1006,5,Ttr | 44 | 44 | NO ANSWER | 3 | | 1415296440.2542 | | | | | | | | |
| 2014-11-06 12:54:30 | “DOE JANE” <“99999”> | “99999” | 1000 | ext-group | SIP/fpbx-1-“99999”-00000199 | SIP/1002-0000019b | Dial | SIP/1002&SIP/1102&SIP/1003&SIP/1103&SIP/1004&SIP/1005&SIP/1007&SIP/1008&SIP/101 | 44 | 44 | NO ANSWER | 3 | | 1415296440.2542 | | | | | | | | |
| 2014-11-06 12:54:30 | “DOE JANE” <“99999”> | “99999” | | | SIP/fpbx-1-“99999”-00000199 | SIP/1003-0000019c | Dial | SIP/1002&SIP/1102&SIP/1003&SIP/1103&SIP/1004&SIP/1005&SIP/1007&SIP/1008&SIP/101 | 44 | 44 | NO ANSWER | 3 | | 1415296440.2542 | | | | | | | | |
| 2014-11-06 12:54:30 | “DOE JANE” <“99999”> | “99999” | | | SIP/fpbx-1-“99999”-00000199 | SIP/1004-0000019d | Dial | SIP/1002&SIP/1102&SIP/1003&SIP/1103&SIP/1004&SIP/1005&SIP/1007&SIP/1008&SIP/101 | 44 | 44 | NO ANSWER | 3 | | 1415296440.2542 | | | | | | | | |
| 2014-11-06 12:54:30 | “DOE JANE” <“99999”> | “99999” | | | SIP/fpbx-1-“99999”-00000199 | SIP/1005-0000019e | Dial | SIP/1002&SIP/1102&SIP/1003&SIP/1103&SIP/1004&SIP/1005&SIP/1007&SIP/1008&SIP/101 | 44 | 44 | NO ANSWER | 3 | | 1415296440.2542 | | | | | | | | |
| 2014-11-06 12:54:30 | “DOE JANE” <“99999”> | “99999” | | | SIP/fpbx-1-“99999”-00000199 | SIP/1007-0000019f | Dial | SIP/1002&SIP/1102&SIP/1003&SIP/1103&SIP/1004&SIP/1005&SIP/1007&SIP/1008&SIP/101 | 44 | 44 | NO ANSWER | 3 | | 1415296440.2542 | | | | | | | | |
| 2014-11-06 12:54:30 | “DOE JANE” <“99999”> | “99999” | | | SIP/fpbx-1-“99999”-00000199 | SIP/1008-000001a0 | Dial | SIP/1002&SIP/1102&SIP/1003&SIP/1103&SIP/1004&SIP/1005&SIP/1007&SIP/1008&SIP/101 | 44 | 44 | NO ANSWER | 3 | | 1415296440.2542 | | | | | | | | |
| 2014-11-06 12:54:30 | “DOE JANE” <“99999”> | “99999” | | | SIP/fpbx-1-“99999”-00000199 | SIP/1010-000001a1 | Dial | SIP/1002&SIP/1102&SIP/1003&SIP/1103&SIP/1004&SIP/1005&SIP/1007&SIP/1008&SIP/101 | 44 | 44 | ANSWERED | 3 | | 1415296440.2542 | | | | | | | | |
| 2014-11-06 12:54:30 | “DOE JANE” <“99999”> | “99999” | | | SIP/fpbx-1-“99999”-00000199 | SIP/1010-000001a1 | Dial | SIP/1002&SIP/1102&SIP/1003&SIP/1103&SIP/1004&SIP/1005&SIP/1007&SIP/1008&SIP/101 | 44 | 44 | ANSWERED | 3 | | 1415296440.2542 | | | | | | | | |
| 2014-11-06 12:54:30 | “DOE JANE” <“99999”> | “99999” | 1003 | from-internal-xfer | SIP/fpbx-1-“99999”-00000199 | SIP/1003-000001a2 | Dial | SIP/1003&SIP/1103,15,TtrM(auto-blkvm) | 15 | 15 | NO ANSWER | 3 | | 1415296440.2542 | | | force-“99999”-unknown-20141106-125401-1415296440.2542.wav | | | | | |
| 2014-11-06 12:54:45 | “DOE JANE” <“99999”> | “99999” | | | SIP/fpbx-1-“99999”-00000199 | | VoiceMail | [email protected],u | 29 | 29 | ANSWERED | 3 | | 1415296440.2542 | | | force-“99999”-unknown-20141106-125401-1415296440.2542.wav | “99999” | DOE JANE | | | |
±--------------------±-----------------------------±-----------±-----±-------------------±-----------------------------±------------------±----------±--------------------------------------------------------------------------------±---------±--------±------------±---------±------------±----------------±----------±----±-------------------------------------------------------------±-----------±--------------±--------------±--------------±---------+
11 rows in set (0.16 sec)’

As you can see, the quotations actually contain the CallerID name for the incoming call. On the outbound call recording where the quotations are null (" "), the phone number that follows is actually our main office number. However, shouldn’t that be the outbound CallerID and outbound number (or at least the outbound number)??? That’s how the old ARI would always display outbound call recordings. UCP displays it as our main office number calling out.

I wanted to add, this same incoming call will play fine in my Voicemail INBOX…however, when I try to download it I receive: “File Not Found” in my web browser. Also the “msgid” when I click download in my Voicemail INBOX is different versus when I click download in Call History:

Voicemail INBOX: http://"99999"/ucp/?quietmode=1&module=voicemail&command=listen&msgid=1415296499-0000000d&format=wav&ext=1003

Call History: http://"99999"/ucp/?quietmode=1&module=cdr&command=listen&msgid=1415296440_2542&type=download&format=wav&ext=1003

After thinking about it, I believe the UCP is pulling it’s information from the wrong SQL field of the outbound call since it is displaying our main office number when it should be displaying the outbound number being called. What do you think?

That would be a problem with Asterisk 12 + 13, not UCP. If you want reliable CDRs then you need to use Asterisk 11

As for downloads thats a bug in the parser dealing with quotations, however I need to clarify something. Are the quotations IN the filename or is that something you have been adding all along?

I have been adding the quotations, here is the actual file name (I only replaced the sensitive phone number with a 555 number):

force-5555551234-1003-20141106-124140-1415295700.2418.wav Should I file a bug report?

As for the CDR problem, would you recommend running asterisk-version-switch and going back to Asterisk 11 or is it too late and the damage has already been done to my CDR?

Your CDRs are already messed up. Is there any way you can open a ticket on this and attach your Asterisk CDRdb to said ticket. We can lock the ticket down to hide your confidential information so only you and I could see it.

Sure, however, it appears I must pay to open a support ticket or am I looking in the wrong area? I went to: https://support.schmoozecom.com/index.php?/Tickets/Submit.

Also, what are you seeing that is messed up in my CDR? Just looking over the asteriskcdrdb output it appears all the data is matching up with the corresponding fields.

http://issues.freepbx.org

Issue ticket created: FREEPBX-8233. I will upload my asteriskcdrdb once the ticket is locked down to you and I (or your team), so would you please do that? Thank you!

Http://issues.freepbx.org