This post is at: ForumGeneral Questions
6 posts / 0 new
Last post
matthewmalk248
matthewmalk248's picture
Joined: 2015/08/09
Points: 20

While diagnosing a Queue problem for an end-user, I realized the call in question didn't exist anywhere in the CDR table. I did find it in the asterisk full log, as well as the queue_log and "call_status" tables. The caller did leave a voicemail which is the only reason they knew he called.

This is the first instance that I know of but it is concerning. I can't seem to find any red flags in the full log for the specific call and even see a "CDR updated on SIP/MyTrunk-000a202a" message after the caller pressed "1" in the IVR.

Is there anywhere else I should be looking to see about why this call wasn't recorded? I plan on doing a table check on cdr but was going to wait until after hours.

Any guidance is appreciated!

thirdlane
thirdlane's picture
Joined: 2007/02/07
Points: 250

Matt,

Did you check the database CDR table or just the GUI?

Alex Epshteyn
Third Lane Technologies
Multi Tenant Asterisk PBX

matthewmalk248
matthewmalk248's picture
Joined: 2015/08/09
Points: 20

Hi Alex,
The CDR table had no record of the call, but the queue_status and queue_log tables did have references to the call.

volodya
volodya's picture
Joined: 2017/01/05
Points: 60

Hello,

Please post the bottom section of /etc/asterisk/cdr_adaptive_odbc.conf configuration file from your system. Just the lines that are not commented out.

matthewmalk248
matthewmalk248's picture
Joined: 2015/08/09
Points: 20

[cdr1]
connection=pbxlogs
table=cdr
alias start => calldate

callafterinsert => cdr_update_nested_calls

volodya
volodya's picture
Joined: 2017/01/05
Points: 60

Ok, that is correct. Please run "cdr show status" command in Asterisk CLI to check if configuration is loaded properly. If it is, you might need someone from support take a look at this.