xml_cdr problem using sip_from_user
All, Currently using fs 1.8.56 on a demo unit. I’ve noticed that on some CDRS the sip_from_user shows the dialed number that the extension placed when it should show the extension number. This is a speratic issue and I can’t narrow down why this may be happening. I am using a php script to post my CDRS. Does anyone have any suggestions? I do have set to record a / b legs of the call and to prefix the a leg. A snippit from the php script is below. $var = $cdr->variables; $sql = sprintf("INSERT INTO cdrClients (site_code,npa,call_direction,cac_call_type_id,call_uuid,direction,user,domain,from_user,from_host,to_user,to_host,req_user,req_host,bridge_channel,sip_term_status,sip_term_cause,sip_hangup_disposition,bridge_hangup_cause,hangup_cause,hangup_cause_q850,start_stamp,answer_stamp,end_stamp,duration,billsec) VALUES('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s');", $var->site,$var->NPA,$var->call_direction,$var->cac_call_type_id,$var->call_uuid,$var->direction,$var->user_name,$var->domain_name,$var->sip_from_user,$var->sip_from_host,$var->sip_to_user,$var->sip_to_host,$var->sip_req_user,$var->sip_req_host,rawurldecode($var->bridge_channel),$var->sip_term_status,$var->sip_term_cause,$var->sip_hangup_disposition,$var->bridge_hangup_cause,$var->hangup_cause,$var->hangup_cause_q850,rawurldecode($var->start_stamp),rawurldecode($var->answer_stamp),rawurldecode($var->end_stamp),$var->duration,$var->billsec); Jason Holden Phone: 1-866-836-9198 X405 Direct: 7868009949 www.thinksimplicity.com <http://www.thinksimplicity.com>
We had a same issue. It started with version 1.10.7. Also posted this question in mailing list. It was told that nothing changed in source code. We solved it to change logic how we are processing cdrs On Wed, 29 Jun 2022, 22:05 Jason Holden, <jasonh@thinksimplicity.com> wrote:
All,
Currently using fs 1.8.56 on a demo unit.
I’ve noticed that on some CDRS the sip_from_user shows the dialed number that the extension placed when it should show the extension number.
This is a speratic issue and I can’t narrow down why this may be happening.
I am using a php script to post my CDRS.
Does anyone have any suggestions?
I do have set to record a / b legs of the call and to prefix the a leg.
A snippit from the php script is below.
$var = $cdr->variables;
$sql = sprintf("INSERT INTO cdrClients (site_code,npa,call_direction,cac_call_type_id,call_uuid,direction,user,domain,from_user,from_host,to_user,to_host,req_user,req_host,bridge_channel,sip_term_status,sip_term_cause,sip_hangup_disposition,bridge_hangup_cause,hangup_cause,hangup_cause_q850,start_stamp,answer_stamp,end_stamp,duration,billsec)
VALUES('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s');",
$var->site,$var->NPA,$var->call_direction,$var->cac_call_type_id,$var->call_uuid,$var->direction,$var->user_name,$var->domain_name,$var->sip_from_user,$var->sip_from_host,$var->sip_to_user,$var->sip_to_host,$var->sip_req_user,$var->sip_req_host,rawurldecode($var->bridge_channel),$var->sip_term_status,$var->sip_term_cause,$var->sip_hangup_disposition,$var->bridge_hangup_cause,$var->hangup_cause,$var->hangup_cause_q850,rawurldecode($var->start_stamp),rawurldecode($var->answer_stamp),rawurldecode($var->end_stamp),$var->duration,$var->billsec);
Jason Holden
Phone: 1-866-836-9198 X405
Direct: 7868009949
www.thinksimplicity.com
[image: Logo 2019 Email Final 250]
_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
I have seen this also (about 18 months ago - so v1.10.5). I noticed that about a minute into the call FreeSWITCH reinvites the A-leg, so my speculation at the time was that the reinvite caused the changing of the sip variables as the from address of the reinvite is the destination address of the original call. I never followed it up though, as we don't use that variable for anything in the CDRs. Martin. Martin Paterson, Pattersong Music Reduced orchestrations of G&S On Thu, 30 Jun 2022 at 09:48, Gregor Nanger <gregor@infomedia.si> wrote:
We had a same issue. It started with version 1.10.7.
Also posted this question in mailing list. It was told that nothing changed in source code. We solved it to change logic how we are processing cdrs
On Wed, 29 Jun 2022, 22:05 Jason Holden, <jasonh@thinksimplicity.com> wrote:
All,
Currently using fs 1.8.56 on a demo unit.
I’ve noticed that on some CDRS the sip_from_user shows the dialed number that the extension placed when it should show the extension number.
This is a speratic issue and I can’t narrow down why this may be happening.
I am using a php script to post my CDRS.
Does anyone have any suggestions?
I do have set to record a / b legs of the call and to prefix the a leg.
A snippit from the php script is below.
$var = $cdr->variables;
$sql = sprintf("INSERT INTO cdrClients (site_code,npa,call_direction,cac_call_type_id,call_uuid,direction,user,domain,from_user,from_host,to_user,to_host,req_user,req_host,bridge_channel,sip_term_status,sip_term_cause,sip_hangup_disposition,bridge_hangup_cause,hangup_cause,hangup_cause_q850,start_stamp,answer_stamp,end_stamp,duration,billsec)
VALUES('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s');",
$var->site,$var->NPA,$var->call_direction,$var->cac_call_type_id,$var->call_uuid,$var->direction,$var->user_name,$var->domain_name,$var->sip_from_user,$var->sip_from_host,$var->sip_to_user,$var->sip_to_host,$var->sip_req_user,$var->sip_req_host,rawurldecode($var->bridge_channel),$var->sip_term_status,$var->sip_term_cause,$var->sip_hangup_disposition,$var->bridge_hangup_cause,$var->hangup_cause,$var->hangup_cause_q850,rawurldecode($var->start_stamp),rawurldecode($var->answer_stamp),rawurldecode($var->end_stamp),$var->duration,$var->billsec);
Jason Holden
Phone: 1-866-836-9198 X405
Direct: 7868009949
www.thinksimplicity.com
[image: Logo 2019 Email Final 250]
_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
participants (3)
-
Gregor Nanger
-
Jason Holden
-
Martin Paterson