<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Got it working with ODBC and mysql in the end (not sure what the issue was with sqlite, or the dsn-less odbc string, but hey).<div class=""><br class=""></div><div class="">Although I’ve got the additional fields showing up in ‘show channels’, altering one of these with ‘uuid_setvar’ doesn’t show the current value in the channels table (confirmed with uuid_getvar), only the value initially set.</div><div class=""><br class=""></div><div class="">Is there a way of getting ‘show channels’ to update dynamically? I could run a separate database and store everything in there, but I’m hoping to avoid doubling down on everything if possible…?<br class="">


<div><br class=""><blockquote type="cite" class=""><div class="">On 5 Oct 2017, at 11:15, Rick Jarvis <<a href="mailto:rick@magicmail.mooo.com" class="">rick@magicmail.mooo.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html; charset=utf-8" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Ok so for some reason I have to specify the db file without the extension, then it works. Although there are no tables in it anyway, and adding a channels table doesn’t help. I’m guessing I need to be using mysql or similar if I want to be able to change the fields in channels?<br class="">
<div class=""><br class=""><blockquote type="cite" class=""><div class="">On 5 Oct 2017, at 09:53, Rick Jarvis <<a href="mailto:rick@magicmail.mooo.com" class="">rick@magicmail.mooo.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html; charset=utf-8" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Have to admit, I’ve not played around with the tables before, and the ‘presence’ element of that page confused me as I thought it was relating to SIP presence!<div class=""><br class=""></div><div class="">I’ve installed sqlite CLI (on Debian) but if I change into /var/lib/freeswitch/db and do a ’sqlite core.db’ I get:</div><div class=""><br class=""></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Monaco; color: rgb(244, 244, 244); background-color: rgba(0, 0, 0, 0.933333);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Unable to open database "core.db": file is encrypted or is not a database</span></div><div class=""><br class=""></div><div class=""> <br class="">

<div class=""><br class=""><blockquote type="cite" class=""><div class="">On 5 Oct 2017, at 05:46, Samir Doshi <<a href="mailto:samir.doshi@inextrix.com" class="">samir.doshi@inextrix.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class=""><img width="0" height="0" class="mailtrack-img" alt="" style="display:flex" src="https://mailtrack.io/trace/mail/1d6a4a303f05694b82e08468abd6b7f454ef6f8a.png?u=1840855">Refer below url if that can be helpful : <div class=""><a href="https://freeswitch.org/confluence/display/FREESWITCH/Variable+presence+data+cols" class="">https://freeswitch.org/confluence/display/FREESWITCH/Variable+presence+data+cols</a><br class=""><br class=""><br class=""><br class=""><div style="display:inline" class="">
            <div class="mt-signature" style="padding-right: 5px;">
                <a href="https://mailtrack.io/" class="mt-signature-logo" style="text-decoration:none">
                    <img src="https://s3-eu-west-1.amazonaws.com/mailtrack-crx/icon-signature.png" height="14" class="">
                </a>
                <span style="color:rgb(153,153,153)" class="">Sent with </span>
                <a href="https://mailtrack.io/install?source=signature&lang=en&referral=samir.doshi@inextrix.com&idSignature=22" class="mt-install">Mailtrack</a>
                
            <div class="mt-tool-tracking"></div><div class="mt-tool-tracking"><a href="x-msg://12/#" title="Remove the Mailtrack signature" class="mt-remove"><span class=""></span></a></div></div></div></div></div><div class="gmail_extra"><br clear="all" class=""><div class=""><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr" class=""><div class=""><div dir="ltr" class=""><div class=""><div dir="ltr" class=""><div class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><span style="color:rgb(51,51,153)" class=""><span class=""></span><span class=""></span><a href="http:///" target="_blank" class=""></a>Best Regards</span><br style="color:rgb(51,51,153)" class=""><span style="color:rgb(51,51,153)" class="">--</span><br style="color:rgb(51,51,153)" class=""><span style="color:rgb(51,51,153)" class="">Samir Doshi</span><br style="color:rgb(51,51,153)" class=""><b class=""><span style="color:rgb(51,51,153)" class="">iNextrix Technologie</span></b><b class=""><span style="color:rgb(51,51,153)" class=""><b class=""><span style="color:rgb(51,51,153)" class="">s</span></b> Pvt. Ltd</span></b>.<br style="color:rgb(51,51,153)" class=""><font size="2" class=""><span style="color:rgb(51,51,153)" class=""><a href="http://www.inextrix.com/" target="_blank" class="">http://www.inextrix.com</a></span></font><div class=""><font color="#333399" class=""></font><br class=""><br class=""><b style="color:rgb(51,51,153)" class="">Disclaimer:</b><br class=""><font color="#333399" class="">The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it.</font><br class=""></div></div></div></div></div></div></div></div></div></div></div></div></div>
<br class=""><div class="gmail_quote">On Wed, Oct 4, 2017 at 11:12 PM, Rick Jarvis <span dir="ltr" class=""><<a href="mailto:rick@magicmail.mooo.com" target="_blank" class="">rick@magicmail.mooo.com</a>></span> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I’m hoping to set a variable on a channel, which I can read back in JSON (ideally) via ‘show channels’.<br class="">
<br class="">
Using ‘uuid_setvar’ should I be able to affect any of the variables that are show in ‘show channels’?<br class="">
<br class="">
And if so, is there a way to get them out as JSON?<br class="">
<br class="">
<br class="">
______________________________<wbr class="">______________________________<wbr class="">_____________<br class="">
Professional FreeSWITCH Consulting Services:<br class="">
<a href="mailto:consulting@freeswitch.org" class="">consulting@freeswitch.org</a><br class="">
<a href="http://www.freeswitchsolutions.com/" rel="noreferrer" target="_blank" class="">http://www.<wbr class="">freeswitchsolutions.com</a><br class="">
<br class="">
Official FreeSWITCH Sites<br class="">
<a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://www.freeswitch.org</a><br class="">
<a href="http://confluence.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://confluence.freeswitch.<wbr class="">org</a><br class="">
<a href="http://www.cluecon.com/" rel="noreferrer" target="_blank" class="">http://www.cluecon.com</a><br class="">
<br class="">
FreeSWITCH-users mailing list<br class="">
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" class="">FreeSWITCH-users@lists.<wbr class="">freeswitch.org</a><br class="">
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank" class="">http://lists.freeswitch.org/<wbr class="">mailman/listinfo/freeswitch-<wbr class="">users</a><br class="">
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank" class="">http://lists.<wbr class="">freeswitch.org/mailman/<wbr class="">options/freeswitch-users</a><br class="">
<a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://www.freeswitch.org</a></blockquote></div><br class=""></div>
_________________________________________________________________________<br class="">Professional FreeSWITCH Consulting Services:<br class=""><a href="mailto:consulting@freeswitch.org" class="">consulting@freeswitch.org</a><br class=""><a href="http://www.freeswitchsolutions.com/" class="">http://www.freeswitchsolutions.com</a><br class=""><br class="">Official FreeSWITCH Sites<br class=""><a href="http://www.freeswitch.org" class="">http://www.freeswitch.org</a><br class="">http://confluence.freeswitch.org<br class="">http://www.cluecon.com<br class=""><br class="">FreeSWITCH-users mailing list<br class="">FreeSWITCH-users@lists.freeswitch.org<br class="">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<br class="">UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br class="">http://www.freeswitch.org</div></blockquote></div><br class=""></div></div>_________________________________________________________________________<br class="">Professional FreeSWITCH Consulting Services:<br class=""><a href="mailto:consulting@freeswitch.org" class="">consulting@freeswitch.org</a><br class=""><a href="http://www.freeswitchsolutions.com" class="">http://www.freeswitchsolutions.com</a><br class=""><br class="">Official FreeSWITCH Sites<br class="">http://www.freeswitch.org<br class="">http://confluence.freeswitch.org<br class="">http://www.cluecon.com<br class=""><br class="">FreeSWITCH-users mailing list<br class="">FreeSWITCH-users@lists.freeswitch.org<br class="">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<br class="">UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br class="">http://www.freeswitch.org</div></blockquote></div><br class=""></div>_________________________________________________________________________<br class="">Professional FreeSWITCH Consulting Services:<br class=""><a href="mailto:consulting@freeswitch.org" class="">consulting@freeswitch.org</a><br class="">http://www.freeswitchsolutions.com<br class=""><br class="">Official FreeSWITCH Sites<br class="">http://www.freeswitch.org<br class="">http://confluence.freeswitch.org<br class="">http://www.cluecon.com<br class=""><br class="">FreeSWITCH-users mailing list<br class="">FreeSWITCH-users@lists.freeswitch.org<br class="">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<br class="">UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br class="">http://www.freeswitch.org</div></blockquote></div><br class=""></div></body></html>