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> 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> 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> wrote:

Refer below url if that can be helpful : 

https://freeswitch.org/confluence/display/FREESWITCH/Variable+presence+data+cols

Sent with Mailtrack

Best Regards
--
Samir Doshi
iNextrix Technologies Pvt. Ltd.
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> 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
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

_________________________________________________________________________
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

_________________________________________________________________________
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

_________________________________________________________________________
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