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: 360

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: 100

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: 100

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.