[Freeswitch-users] Custom Columns into MySQL Channels table

[Ken Rice]

Ok luis while i understand that you are a fan of fusionpbx can we skip that as you suggested answer for everything on this list?





Sent from my iPhone

> On Jan 18, 2015, at 7:24 AM, Luis Daniel Lucio Quiroz <luis.daniel.lucio at gmail.com> wrote:
> 
> You may want to install FusionPBX, cdr code does exactly what you need
> Luis Daniel Lucio Quiroz
> CISSP, CISM, CISA
> Linux, VoIP and much more fun
> www.okay.com.mx
> 
> 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
> 
> _________________________________________________________________________
> 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