<HTML>
<HEAD>
<TITLE>Re: [Freeswitch-users] Freswitch ODBC tables</TITLE>
</HEAD>
<BODY>
<FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'>You know Gregor,<BR>
<BR>
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).<BR>
<BR>
Tony is pretty good about using names that make sense for the various bits and pieces of freeswitch... <BR>
<BR>
<BR>
<BR>
<BR>
On 5/23/12 4:30 AM, "Gregor Nanger" <<a href="gregor@infomedia.si">gregor@infomedia.si</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'>And for the record if someone will search. FS on linux, sofia via odbc on MS SQL server 2008 and it works ok.<BR>
<BR>
Gregor<BR>
</SPAN></FONT><FONT SIZE="2"><FONT FACE="Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'><BR>
</SPAN></FONT></FONT><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'><BR>
<BR>
2012/5/23 Gregor Nanger <<a href="gregor@infomedia.si">gregor@infomedia.si</a>><BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'>Thank you guys!<BR>
<BR>
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.<BR>
<FONT COLOR="#888888"><BR>
Gregor<BR>
</FONT><BR>
<BR>
<BR>
<BR>
2012/5/23 Peter Olsson <<a href="peter.olsson@visionutveckling.se">peter.olsson@visionutveckling.se</a>><BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Monaco, Courier New"><FONT SIZE="2"><SPAN STYLE='font-size:10pt'>I don’t think there is much documentation about this – since it’s mostly data used internally by FS.<BR>
<BR>
What do you want to do more specifically? I guess most of the tables are quite self-explaining by their names..<BR>
<BR>
/Peter<BR>
<BR>
<BR>
<B>Från:</B> <a href="freeswitch-users-bounces@lists.freeswitch.org">freeswitch-users-bounces@lists.freeswitch.org</a> [<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org">mailto:freeswitch-users-bounces@lists.freeswitch.org</a>] <B>För </B>Gregor Nanger<BR>
<B>Skickat:</B> den 23 maj 2012 09:13<BR>
<B>Till:</B> FreeSWITCH Users Help<BR>
<B>Ämne:</B> Re: [Freeswitch-users] Freswitch ODBC tables<BR>
</SPAN></FONT><SPAN STYLE='font-size:11pt'><BR>
<BR>
Please give me hint what to search :-(<BR>
<BR>
I tried ODBC tables, sip_registration table, sofia tables, sofia ODBC and tables are mentioned, but no single description for what tables are used. <BR>
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.<BR>
<BR>
In channels table are stored all legs information when call is active...<BR>
<BR>
In Calls are stored active calls when bridge happened between legs...<BR>
<BR>
Can you give me a hand for other tables?<BR>
<BR>
2012/5/23 Gregor Nanger <<a href="gregor@infomedia.si">gregor@infomedia.si</a>><BR>
Ok Brian, you got me<BR>
<BR>
thank you...<BR>
<BR>
<BR>
<BR>
<BR>
2012/5/23 Brian Foster <<a href="bdfoster@endigotech.com">bdfoster@endigotech.com</a>><BR>
All over the wiki, my friend.<BR>
<BR>
-BDF<BR>
<BR>
On May 22, 2012 6:07 PM, "Gregor Nanger" <<a href="gregor@infomedia.si">gregor@infomedia.si</a>> wrote:<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'><BR>
Hi!<BR>
<BR>
I have FS in linux and moved sofia db via ODBC to MS Sql server and it works ok. <BR>
<BR>
Are there any documentation about tables and how they are used by sofia?<BR>
<BR>
Thanx, Gregor<BR>
_________________________________________________________________________<BR>
Professional FreeSWITCH Consulting Services:<BR>
<a href="consulting@freeswitch.org">consulting@freeswitch.org</a><BR>
<a href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a><BR>
<BR>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<BR>
<a href="http://www.cudatel.com">http://www.cudatel.com</a><BR>
<BR>
Official FreeSWITCH Sites<BR>
<a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
<a href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a><BR>
<a href="http://www.cluecon.com">http://www.cluecon.com</a><BR>
<BR>
Join Us At ClueCon - Aug 7-9, 2012<BR>
<BR>
FreeSWITCH-users mailing list<BR>
<a href="FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><BR>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><BR>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><BR>
<a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'><BR>
_________________________________________________________________________<BR>
Professional FreeSWITCH Consulting Services:<BR>
<a href="consulting@freeswitch.org">consulting@freeswitch.org</a><BR>
<a href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a><BR>
<BR>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<BR>
<a href="http://www.cudatel.com">http://www.cudatel.com</a><BR>
<BR>
Official FreeSWITCH Sites<BR>
<a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
<a href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a><BR>
<a href="http://www.cluecon.com">http://www.cluecon.com</a><BR>
<BR>
Join Us At ClueCon - Aug 7-9, 2012<BR>
<BR>
FreeSWITCH-users mailing list<BR>
<a href="FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><BR>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><BR>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><BR>
<a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
<BR>
<BR>
!DSPAM:4fbc8cbd32761286258325! <BR>
<BR>
_________________________________________________________________________<BR>
Professional FreeSWITCH Consulting Services:<BR>
<a href="consulting@freeswitch.org">consulting@freeswitch.org</a><BR>
<a href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a><BR>
<BR>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<BR>
<a href="http://www.cudatel.com">http://www.cudatel.com</a><BR>
<BR>
Official FreeSWITCH Sites<BR>
<a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
<a href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a><BR>
<a href="http://www.cluecon.com">http://www.cluecon.com</a><BR>
<BR>
Join Us At ClueCon - Aug 7-9, 2012<BR>
<BR>
FreeSWITCH-users mailing list<BR>
<a href="FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><BR>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><BR>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><BR>
<a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'><BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'><BR>
<BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"></SPAN></FONT><FONT SIZE="2"><FONT FACE="Consolas, Courier New, Courier"><SPAN STYLE='font-size:10pt'>_________________________________________________________________________<BR>
Professional FreeSWITCH Consulting Services:<BR>
<a href="consulting@freeswitch.org">consulting@freeswitch.org</a><BR>
<a href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a><BR>
<BR>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<BR>
<a href="http://www.cudatel.com">http://www.cudatel.com</a><BR>
<BR>
Official FreeSWITCH Sites<BR>
<a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
<a href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a><BR>
<a href="http://www.cluecon.com">http://www.cluecon.com</a><BR>
<BR>
Join Us At ClueCon - Aug 7-9, 2012<BR>
<BR>
FreeSWITCH-users mailing list<BR>
<a href="FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><BR>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><BR>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><BR>
<a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
</SPAN></FONT></FONT></BLOCKQUOTE>
</BODY>
</HTML>