[Freeswitch-users] xml_cdr problem using sip_from_user

[Gregor Nanger]

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 at 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 at 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 at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> https://freeswitch.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20220630/d69a2720/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 1004 bytes
Desc: not available
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20220630/d69a2720/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 1004 bytes
Desc: not available
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20220630/d69a2720/attachment-0001.jpg>