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