Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

[Freeswitch-users] xml_cdr problem using sip_from_user


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> freeSWITCH Users
View previous topic :: View next topic  
Author Message
jasonh at thinksimplic...
Guest





PostPosted: Wed Jun 29, 2022 3:34 pm    Post subject: [Freeswitch-users] xml_cdr problem using sip_from_user Reply with quote

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
Back to top
gregor at infomedia.si
Guest





PostPosted: Thu Jun 30, 2022 3:58 am    Post subject: [Freeswitch-users] xml_cdr problem using sip_from_user Reply with quote

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 (jasonh@thinksimplicity.com)> wrote:

Quote:

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
 

 

_________________________________________________________________________

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 (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 (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
Back to top
martin at pattersong.c...
Guest





PostPosted: Mon Jul 04, 2022 6:07 am    Post subject: [Freeswitch-users] xml_cdr problem using sip_from_user Reply with quote

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 (gregor@infomedia.si)> wrote:

Quote:
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 (jasonh@thinksimplicity.com)> wrote:

Quote:

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
 

 

_________________________________________________________________________

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 (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 (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 (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 (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
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> freeSWITCH Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services