[Freeswitch-users] Freswitch ODBC tables

[Ken Rice]

You know Gregor,

I don¹t know if those tables are actually documented on the wiki, but if you
look at the tables after FreeSWITCH creates them they should be fairly self
explanatory (to an english speaker anyway).

Tony is pretty good about using names that make sense for the various bits
and pieces of freeswitch...




On 5/23/12 4:30 AM, "Gregor Nanger" <gregor at infomedia.si> wrote:

> And for the record if someone will search. FS on linux, sofia via odbc on MS
> SQL server 2008 and it works ok.
> 
> Gregor
> 
> 
> 
> 2012/5/23 Gregor Nanger <gregor at infomedia.si>
>> 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
>>> 
>> 
> 
> 
> 
> _________________________________________________________________________
> 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/a02572d7/attachment-0001.html