rendered paste body# Example CDR Entry
| 2007-06-13 14:32:40 | "KAYAK.COM " <2038993102> | 2038993102 | 5132 | default | SIP/5060-b69042c0 | SIP/5132-08238878 | Dial | SIP/5132|18 | 91 | 86 | ANSWERED | 3 | | |
# extensions.conf (pertinent section)
[DID]
exten => _5[1-2]XX,hint,SIP/${EXTEN}
exten => _5[1-2]XX,1,Dial(SIP/${EXTEN},18)
exten => _5[1-2]XX,2,NoOp(${CALLERID(num)}---${CALLERID(name)})
exten => _5[1-2]XX,3,GotoIfTime(09:00-22:00,mon-sun,*,*?5)
exten => _5[1-2]XX,4,Goto(6)
exten => _5[1-2]XX,5,FollowMe(follow${EXTEN}|san)
exten => _5[1-2]XX,6,Voicemail(${EXTEN}@allstaff,u)
exten => _5[1-2]XX,7,Hangup()
exten => _5[1-2]XX,102,Voicemail(${EXTEN}@allstaff,b)
exten => _5[1-2]XX,103,Hangup()
# CLI Output
grosvenor*CLI>
-- Executing [5201@default:1] Dial("SIP/5060-b6905ba0", "SIP/5201|18") in new stack
-- Called 5201
-- SIP/5201-08238878 is ringing
[Jun 13 16:13:45] DEBUG[27679]: cdr_addon_mysql.c:210 mysql_log: cdr_mysql: inserting a CDR record.
[Jun 13 16:13:45] DEBUG[27679]: cdr_addon_mysql.c:226 mysql_log: cdr_mysql: SQL command as follows: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode) VALUES ('2007-06-13 16:13:40','','','s','internal', 'SIP/5201-08238878','','','',5,0,'NO ANSWER',3,'')
== Spawn extension (default, 5201, 1) exited non-zero on 'SIP/5060-b6905ba0'
[Jun 13 16:13:45] DEBUG[27679]: cdr_addon_mysql.c:210 mysql_log: cdr_mysql: inserting a CDR record.
[Jun 13 16:13:45] DEBUG[27679]: cdr_addon_mysql.c:226 mysql_log: cdr_mysql: SQL command as follows: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode) VALUES ('2007-06-13 16:13:40','\"Unavailable\" <2012147154>','2012147154','5201','default', 'SIP/5060-b6905ba0','SIP/5201-08238878','Dial','SIP/5201|18',5,0,'NO ANSWER',3,'')