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@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@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