[Freeswitch-users] Setting vars

Thu Oct 5 13:00:07 UTC 2017

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).

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.

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…?

> On 5 Oct 2017, at 11:15, Rick Jarvis <rick at magicmail.mooo.com> wrote:
> 
> 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?
> 
>> On 5 Oct 2017, at 09:53, Rick Jarvis <rick at magicmail.mooo.com <mailto:rick at magicmail.mooo.com>> wrote:
>> 
>> 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!
>> 
>> I’ve installed sqlite CLI (on Debian) but if I change into /var/lib/freeswitch/db and do a ’sqlite core.db’ I get:
>> 
>> Unable to open database "core.db": file is encrypted or is not a database
>> 
>>  
>> 
>>> On 5 Oct 2017, at 05:46, Samir Doshi <samir.doshi at inextrix.com <mailto:samir.doshi at inextrix.com>> wrote:
>>> 
>>> Refer below url if that can be helpful : 
>>> https://freeswitch.org/confluence/display/FREESWITCH/Variable+presence+data+cols <https://freeswitch.org/confluence/display/FREESWITCH/Variable+presence+data+cols>
>>> 
>>> 
>>> 
>>>    <https://mailtrack.io/>Sent with Mailtrack <https://mailtrack.io/install?source=signature&lang=en&referral=samir.doshi@inextrix.com&idSignature=22> <x-msg://12/#>
>>> 
>>>  <http:///>Best Regards
>>> --
>>> Samir Doshi
>>> iNextrix Technologies Pvt. Ltd.
>>> http://www.inextrix.com <http://www.inextrix.com/>
>>> 
>>> 
>>> Disclaimer:
>>> 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.
>>> 
>>> On Wed, Oct 4, 2017 at 11:12 PM, Rick Jarvis <rick at magicmail.mooo.com <mailto:rick at magicmail.mooo.com>> wrote:
>>> I’m hoping to set a variable on a channel, which I can read back in JSON (ideally) via ‘show channels’.
>>> 
>>> Using ‘uuid_setvar’ should I be able to affect any of the variables that are show in ‘show channels’?
>>> 
>>> And if so, is there a way to get them out as JSON?
>>> 
>>> 
>>> _________________________________________________________________________
>>> Professional FreeSWITCH Consulting Services:
>>> consulting at freeswitch.org <mailto:consulting at freeswitch.org>
>>> http://www.freeswitchsolutions.com <http://www.freeswitchsolutions.com/>
>>> 
>>> Official FreeSWITCH Sites
>>> http://www.freeswitch.org <http://www.freeswitch.org/>
>>> http://confluence.freeswitch.org <http://confluence.freeswitch.org/>
>>> http://www.cluecon.com <http://www.cluecon.com/>
>>> 
>>> FreeSWITCH-users mailing list
>>> FreeSWITCH-users at lists.freeswitch.org <mailto:FreeSWITCH-users at lists.freeswitch.org>
>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users <http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>> http://www.freeswitch.org <http://www.freeswitch.org/>
>>> _________________________________________________________________________
>>> Professional FreeSWITCH Consulting Services:
>>> consulting at freeswitch.org <mailto:consulting at freeswitch.org>
>>> http://www.freeswitchsolutions.com <http://www.freeswitchsolutions.com/>
>>> 
>>> Official FreeSWITCH Sites
>>> http://www.freeswitch.org
>>> http://confluence.freeswitch.org
>>> http://www.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
>>> http://www.freeswitch.org
>> 
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org <mailto:consulting at freeswitch.org>
>> http://www.freeswitchsolutions.com
>> 
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://confluence.freeswitch.org
>> http://www.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
>> http://www.freeswitch.org
> 
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
> 
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.freeswitch.org
> http://www.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
> http://www.freeswitch.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20171005/0c4068e6/attachment.html>