hi,
We install Asterisk 1.4.6 and FreePBX 2.3 we have some problem in CDR tables that i mentioned below. In php myadmin SQL database Is there anyone can help us for this issue? Scenarios are explained below. and i copy-paste CDR table bottom of this page, if you copy CDR table into an excel sheet you can see CDR values better.
"Scenario for Call ID’s 1 & 2 : (problem scenario)
2003 calls 5553334455, after the call is connected 2003 pushes the conference button and calls 2125552255 after 2125552255 answers, 2003 joins the two calls and a 3-Way Calling is established. After a while 2003 closes on hooks, but the other two (5553334455 and 2125552255) continue the call for a few more seconds. The problem here is that the call to 5553334455 is not seen in the cdr, instead two seperate calls from 2003 to 2125552255 appear in the cdr. Also the display id of the extension 2003 can not be seen in the cdr. In the normal scenario it can be seen (as ““phone1"”).”
"Scenario for Call ID’s 3 & 4 : (normal scenario)
2003 calls 2125552255, after the call is connected 2003 pushes the conference button and calls 5553334455, after 5553334455 answers, 2003 joins the two calls and a 3-Way Calling is established. After a while 5553334455, 2125552255 and 2003 on hook simultaneously and all legs of the 3-way call is terminated at the same time. The call legs and teh display name of the extension can be seen correctly in the related cdrs. "
ID Call Date clid src dst dcontext channel dstchannel lastapp lastdata duration billsec disposition amaflags accountcode uniqueid
1 17.08.2007 16:47:47 2003 2003 2125552255 from-internal SIP/2003-09cb1738 SIP/Cisco 2811 OG-09c385d0 ResetCDR w 0 42 ANSWERED 3 1187358420
2 17.08.2007 16:47:09 2003 2003 2125552255 from-internal SIP/2003-09c88f78 SIP/Cisco 2811 OG-09c52100 ResetCDR w 38 36 ANSWERED 3 1187358430
3 17.08.2007 16:39:52 “phone1” <2003> 2003 5553334455 from-internal SIP/2003-09c4b7d8 SIP/Cisco 2811 OG-09c50d18 ResetCDR w 16 10 ANSWERED 3 1187357992
4 17.08.2007 16:39:42 “phone1” <2003> 2003 2125552255 from-internal SIP/2003-09cb1738 SIP/Cisco 2811 OG-09c385d0 ResetCDR w 26 24 ANSWERED 3 1187357982