Lei,<br><br>I am still learning myself, but I think I can help enough and others can chime in where I am wrong.<br><br>If you have FS up and running you will need to install xml_curl (<a href="http://wiki.freeswitch.org/wiki/Mod_xml_curl">http://wiki.freeswitch.org/wiki/Mod_xml_curl</a>).<br>
<br><br><br>Then you will need to edit the config for it in your conf/autoload_configs/xml_curl_conf.xml and add the following to the file.<br><br><binding name="externalDir"><br> <param name="gateway-url" value="<a href="http://my.webserver.com/index.php">http://my.webserver.com/index.php</a>" bindings="directory"/><br>
</binding><br><br><br>Then for every registered user call, a request will be posted to that script location.<br><br>The posts vary but look something like:<br><br>[hostname] => test.local <br>
[section] => directory <br>[tag_name] => domain <br>[key_name] => name <br>
[key_value] => company1.test.local <br>[action] => sip_auth <br>[sip_profile] => internal <br>
[sip_user_agent] => eyeBeam release 1100v stamp 47073 <br>[sip_auth_username] => 100 <br>[sip_auth_realm] => company1.test.local <br>
[sip_auth_nonce] => 37bd639a-d181-4df3-b53d-ab4172ca3be9 <br>[sip_auth_uri] => sip:company1.test.local;transport=udp <br>[sip_contact_user] => 100 <br>
[sip_contact_host] => 10.43.43.2 <br>[sip_to_user] => 100 <br>[sip_to_host] => company1.test.local <br>
[sip_from_user] => 100 <br>[sip_from_host] => company1.test.local <br>[sip_request_host] => company1.test.local <br>
[sip_auth_qop] => auth <br>[sip_auth_cnonce] => 207aae18a2af959346f87a2a3c2c7f8a <br>[sip_auth_nc] => 00000001 <br>
[sip_auth_response] => 770a1519789ba7606b3dcc6c4b7a99c5 <br>[sip_auth_method] => REGISTER <br>[key] => id <br>
[user] => 100 <br>[domain] => company1.test.local <br>[ip] => 10.43.43.2 <br>
<br><br>Then your script can handle the connection to the DB and the verification of the user information. My example uses PHP but any server side language that can be posted to can be used in the above scenario.<br><br>
<br><div class="gmail_quote">On Sun, Oct 25, 2009 at 8:58 AM, Lei Tang <span dir="ltr"><<a href="mailto:lei.tlfly@gmail.com">lei.tlfly@gmail.com</a>></span> wrote:<br><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>
<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>