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@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@inextrix.com <mailto:samir.doshi@inextrix.com>> wrote:
Refer below url if that can be helpful : https://freeswitch.org/confluence/display/FREESWITCH/Variable+presence+data+... <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@magicmail.mooo.com <mailto:rick@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@freeswitch.org <mailto:consulting@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@lists.freeswitch.org <mailto:FreeSWITCH-users@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@freeswitch.org <mailto:consulting@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@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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org