[Freeswitch-users] Custom Columns into MySQL Channels table

Luis Daniel Lucio Quiroz luis.daniel.lucio at gmail.com
Sun Jan 18 16:24:05 MSK 2015

You may want to install FusionPBX, cdr code does exactly what you need
Luis Daniel Lucio Quiroz
Linux, VoIP and much more fun

Need LCR? Check out LCR for FusionPBX with FreeSWITCH
Need Billing? Check out Billing for FusionPBX with FreeSWITCH

2015-01-18 5:59 GMT-05:00 Jack Cortez <mvar78 at gmail.com>:
> Hi,
> I would like to add a column to channel table (created by FS automatically using ODBC) and populate this new columns with my own custom value.
> Is this possible?
> In particular, as I'm creating a simple PHP page to show active calls, what I would like to add is a column with the gateway_name to identify the Outbound Provider Name. So, in my PHP page I can show where the call is going out.
> And also, I found that the application_data columns is showing the sofia dialstring (for ie. sofia/gateway/my_gateway/44798797978) but this columns is overwritten by last action I can't rely on this field.
> I'm looking for days into the wiki but I didn't found anything interesting.
> Thank you so much!
> _________________________________________________________________________
> 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

Join us at ClueCon 2016 Aug 8-12, 2016
More information about the FreeSWITCH-users mailing list