[Freeswitch-users] How to get call uuid from b-leg and insert to pgsql

[Brian West]

Your best bet is to use XML CDR and post process it.

On Tue, Jul 9, 2019 at 4:45 AM 王聡 <cong.wang.itsherpa at gmail.com> wrote:

> Hi all,
>
> I’m trying to manage cdr in pgsql by mod_cdr_pg_csv, and I hope to record
> a call uuid to manage multiple recorded channels in one call.
>
> A channel variable “variable_call_uuid” seems good to record, and I
> confirmed it is the correct call uuid in fs_cli by:
>
> freeswitch at TEST-FS> uuid_getvar 67534e60-fc91-4e6b-b64e-868d5f3d8b16
> call_uuid
> 67534e60-fc91-4e6b-b64e-868d5f3d8b16
>
> freeswitch at TEST-FS> uuid_getvar 2ab39a17-2f8d-4ac1-81de-b32a990e55c1
> call_uuid
> 67534e60-fc91-4e6b-b64e-868d5f3d8b16
>
> However, when I tried to record this variable into pgsql, it turned into
> channels uuid in pgsql.
> The followings had added into cdr_pg_csv.conf.xml:
>
>     <field var="call_uuid”/>
>
>
> But pgsql record showed:
>
> SELECT call_uuid FROM cdr where uuid =
> '67534e60-fc91-4e6b-b64e-868d5f3d8b16’;
> > 67534e60-fc91-4e6b-b64e-868d5f3d8b16
>
> SELECT call_uuid FROM cdr where uuid =
> '2ab39a17-2f8d-4ac1-81de-b32a990e55c1’;
> > 2ab39a17-2f8d-4ac1-81de-b32a990e55c1 # Which should be
> 67534e60-fc91-4e6b-b64e-868d5f3d8b16
>
> Any idea or advice on this issue?
>
> Regards.
> _________________________________________________________________________
>
> 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



-- 

Brian West | Co-founder and Developer

Need Commercial support? email sales at freeswitch.com

FreeSWITCH Solutions | 17345 Civic Drive #2531 Brookfield, WI 53045
<https://maps.google.com/?q=17345+Civic+Drive+%232531+Brookfield,+WI+53045&entry=gmail&source=g>

Email: brian at freeswitch.com

Mobile: 918-424-9378

Website: https://www.FreeSWITCH.com <https://www.freeswitch.com/>

[image: https://www.facebook.com/signalwireinc?src=email]
<https://www.facebook.com/freeswitch> [image:
https://twitter.com/freeswitch] <https://twitter.com/freeswitch>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20190709/25ee38cc/attachment.html>