[Freeswitch-users] Freswitch ODBC tables

[Gregor Nanger]

Thank you guys!

Just wanted to figure it out. I wanted to get status of extension
(registered, oncall, ringing). And I can do this with registrations,
channels  and calls table. As I searched, I didn't find better way to do
this from external application. There are also no API command to show
exactly what I wanted.

Gregor



2012/5/23 Peter Olsson <peter.olsson at visionutveckling.se>

>  I don’t think there is much documentation about this – since it’s mostly
> data used internally by FS.****
>
> ** **
>
> What do you want to do more specifically? I guess most of the tables are
> quite self-explaining by their names..****
>
> ** **
>
> /Peter****
>
> ** **
>
> ** **
>
> *Från:* freeswitch-users-bounces at lists.freeswitch.org [mailto:
> freeswitch-users-bounces at lists.freeswitch.org] *För *Gregor Nanger
> *Skickat:* den 23 maj 2012 09:13
> *Till:* FreeSWITCH Users Help
> *Ämne:* Re: [Freeswitch-users] Freswitch ODBC tables****
>
> ** **
>
> Please give me hint what to search :-(
>
> I tried ODBC tables, sip_registration table, sofia tables, sofia ODBC and
> tables are mentioned, but no single description for what tables are  used.
> I figure it out that in registration table are stored active sip
> registrations with expire date etc..., sip_registration tables has same
> information, but with more fields.
>
> In channels table are stored all legs information when call is active...
>
> In Calls are stored active calls when bridge happened between legs...
>
> Can you give me a hand for other tables?
>
> ****
>
> 2012/5/23 Gregor Nanger <gregor at infomedia.si>****
>
> Ok Brian, you got me
>
> thank you...****
>
>
>
>
> ****
>
> 2012/5/23 Brian Foster <bdfoster at endigotech.com>****
>
> All over the wiki, my friend.****
>
> -BDF****
>
> On May 22, 2012 6:07 PM, "Gregor Nanger" <gregor at infomedia.si> wrote:****
>
>  Hi!
>
> I have FS in linux and  moved sofia db via ODBC to MS Sql server and it
> works ok.
>
> Are there any documentation about tables and how they are used by sofia?
>
> Thanx, Gregor****
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> Join Us At ClueCon - Aug 7-9, 2012
>
> 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://wiki.freeswitch.org
> http://www.cluecon.com
>
> Join Us At ClueCon - Aug 7-9, 2012
>
> 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****
>
> ** **
>
>
> !DSPAM:4fbc8cbd32761286258325! ****
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> Join Us At ClueCon - Aug 7-9, 2012
>
> 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/20120523/d5ad7274/attachment.html