Ok reading through other responses to similar questions in the mail list archive, it seems that’s not really an option. I guess I could get my app to manually update the channels table by hooking into it? The other option is to monitor ESL which I’m doing anyway, and run my own copy of the data, but I think I might go for the first option, as at least I know that the calls will be correct, and that I haven’t missed an event…
On 5 Oct 2017, at 14:00, Rick Jarvis <rick@magicmail.mooo.com> wrote:
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@magicmail.mooo.com <mailto:rick@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@magicmail.mooo.com <mailto: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 <http://www.freeswitchsolutions.com/>
Official FreeSWITCH Sites http://www.freeswitch.org <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 <mailto:consulting@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@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 <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