We have used xml_odbc to get user data from database. <div><br></div><div>One question though, xml_odbc will load all the user info in database to memory just like it is loading from plain xml config files when FS starts. I was wondering if mod_xml_curl is doing this differently by only requesting user information on demand (real time)? and not loading all the user information from the beginning of FS start.</div>
<div><br></div><div><br><br><div class="gmail_quote">On Tue, Oct 27, 2009 at 5:39 AM, Costa Zikalala <span dir="ltr"><<a href="mailto:costa.zikalala@gmail.com">costa.zikalala@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Thanks for your response Michael,<br><br>Both the resources you've referred to don't explicitly say much about databases. Could you elaborate just a bit on how on information would retrieved from a database (MySQL) and presented to mod_xml_curl. <br>
<br>Thanks again.<br><br>
<br><br><div class="gmail_quote">2009/10/26 Michael Collins <span dir="ltr"><<a href="mailto:msc@freeswitch.org" target="_blank">msc@freeswitch.org</a>></span><br><blockquote class="gmail_quote" style="border-left:1px solid rgb(204, 204, 204);margin:0pt 0pt 0pt 0.8ex;padding-left:1ex">
<div><div></div><div class="h5">
<br><br><div class="gmail_quote"><div>On Sun, Oct 25, 2009 at 6:58 AM, Lei Tang <span dir="ltr"><<a href="mailto:lei.tlfly@gmail.com" target="_blank">lei.tlfly@gmail.com</a>></span> wrote:<br></div><div>
<div>
</div><div><blockquote class="gmail_quote" style="border-left:1px solid rgb(204, 204, 204);margin:0pt 0pt 0pt 0.8ex;padding-left:1ex">
Hi All:<br> I'm a newbie to FS. I'm using FS as a sbc and have about 20000 user account . Does somebody can tell me how to make FS load use account information from a database such as mssql or mysql? Could you give me a sample configuration file?<br>
Thanks a lots.<br> <br></blockquote></div></div><div>Lei,<br><br>The feature that you want is mod_xml_curl - it allows you to pull config information from a web server, and that web server will do the db lookup. For more information check out these resources:<br>
</div></div><br>Wiki docs: <a href="http://wiki.freeswitch.org/wiki/Mod_xml_curl" target="_blank">http://wiki.freeswitch.org/wiki/Mod_xml_curl</a><br>Example: <a href="http://fisheye.freeswitch.org/browse/FreeSWITCH/contrib/trixter/xml-curl" target="_blank">http://fisheye.freeswitch.org/browse/FreeSWITCH/contrib/trixter/xml-curl</a><br>
<br>We don't have a soup-to-nuts how-to on mod_xml_curl because it can be done in so many different ways. Someone could write a book on implementing xml_curl techniques. Your best bet is to figure out how you want to store your user information, then decide what's the best way to pull that information from the database, then setup a web server to handle the request/return process. Between the docs and the examples you should be able to get up and running.<br>
<font color="#888888">
<br>-MC<br>
</font><br></div></div><div class="im">_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></div></blockquote></div><br>
<br>_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Henry Huang<br>UniC Solution - Communication Unified<br>VoIP & Open Source software Consultant<br>
</div>