[Freeswitch-users] Custom Columns into MySQL Channels table

[Lloyd Aloysius]

Jack

There is a channel variable for this purpose *sip_gateway_name.*

LLoyd

On Sun, Jan 18, 2015 at 9:08 AM, Jack Cortez <mvar78 at gmail.com> wrote:

> Hi Luis!
> If this was a newest installation I will choose FusionPBX but as this is a
> running box I do prefer to not install Fusion, but just find a solution for
> adding a columns to channels table based on a custom variables (maybe
> declared into the dialplan or with a lua script).
> Can  you give me a clue on this?
>
> Thanks
>
>
> Il giorno 18/gen/2015, alle ore 14:24, Luis Daniel Lucio Quiroz ha scritto:
>
> > 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
>
>
> _________________________________________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20150118/a531a250/attachment.html