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@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@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@lists.freeswitch.org [mailto:freeswitch-users-bounces@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@infomedia.si>
Ok Brian, you got me

thank you...




2012/5/23 Brian Foster <bdfoster@endigotech.com>
All over the wiki, my friend.

-BDF

On May 22, 2012 6:07 PM, "Gregor Nanger" <gregor@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@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.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@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@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.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@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@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.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@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@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.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@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org