<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
El 19/01/11 22:16, Avi Marcus escribió:
<blockquote
cite="mid:AANLkTinYebKhBXQGdwV02bi_kBPB4Vp7Q3iGCv9YRDD7@mail.gmail.com"
type="cite">
<div dir="ltr">Integrate freeswitch with mysql is vague. That
itself could mean something like having freeswitch store it's
database in mysql, but that doesn't seem to be what you want.
<div>You are asking how to use a database (any, not just mysql)
to configure the dialplan - users, extensions, conferences,
whatever.</div>
<div>1) You can use lua to process the calls and have it query
your database</div>
<div>2) If you just need simple sql queries, check the
mod_odbc_query from the git contrib. If you already understand
the dialplan basics, then this can easily let you query the
database as part of that.</div>
<div>3) However, if you need more complicated things, then
mod_xml_curl is your friend - it lets you grab dynamicly
generated XML files for each call.</div>
<div>I myself use php to query a mysql database for how much to
charge for the call, a custom LCR implementation, etc.</div>
<div>I posted the basic classes to github a while ago:
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<a moz-do-not-send="true"
href="https://github.com/avimar/FreeSWITCH-mod_xml-with-PHP">https://github.com/avimar/FreeSWITCH-mod_xml-with-PHP</a></div>
<div>Also, intralanman wrote a very modular, all inclusive
xml_curl implementation in php - which if you understand it (I
didn't know it existed) should be really helpful. You can find
that in the git contrib also in:
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<span class="Apple-style-span" style="font-family: sans-serif;
font-size: 10.8333px; line-height: 19px;">intralanman/PHP/fs_curl</span><br>
<br>
</div>
<div>-Avi Marcus</div>
<br>
</div>
</blockquote>
Hi<span id="result_box" class="long_text" lang="en"><span title="Haz
clic para obtener traducciones alternativas" class="hps"></span><br>
<br>
<span title="Haz clic para obtener traducciones alternativas"
class="hps">Thanks</span> <span title="Haz clic para obtener
traducciones alternativas" class="hps">for</span> <span
title="Haz clic para obtener traducciones alternativas"
class="hps">everyone's responses</span><span class="" title="Haz
clic para obtener traducciones alternativas">,</span> <span
title="Haz clic para obtener traducciones alternativas"
class="hps">are</span> <span title="Haz clic para obtener
traducciones alternativas" class="hps">really helping</span> <span
title="Haz clic para obtener traducciones alternativas"
class="hps">me</span> <span title="Haz clic para obtener
traducciones alternativas" class="hps">to</span> <span
title="Haz clic para obtener traducciones alternativas"
class="hps">really know</span> <span title="Haz clic para
obtener traducciones alternativas" class="hps">to look for</span>
<span title="Haz clic para obtener traducciones alternativas"
class="hps">and</span> <span title="Haz clic para obtener
traducciones alternativas" class="hps">how to document ;-)</span><span
class="" title="Haz clic para obtener traducciones alternativas">.</span>
<span title="Haz clic para obtener traducciones alternativas"
class="hps">I had thought</span> <span title="Haz clic para
obtener traducciones alternativas" class="hps">one thing</span>
<span title="Haz clic para obtener traducciones alternativas"
class="hps">and</span> <span title="Haz clic para obtener
traducciones alternativas" class="hps">I have</span> <span
title="Haz clic para obtener traducciones alternativas"
class="hps">a question</span><span class="" title="Haz clic para
obtener traducciones alternativas">:</span> <span title="Haz
clic para obtener traducciones alternativas" class="hps">Could</span>
<span title="Haz clic para obtener traducciones alternativas"
class="hps">use</span> <span title="Haz clic para obtener
traducciones alternativas" class="hps">python</span> <span
title="Haz clic para obtener traducciones alternativas"
class="hps">for</span> <span title="Haz clic para obtener
traducciones alternativas" class="hps">this</span> <span
title="Haz clic para obtener traducciones alternativas"
class="hps">cause</span><span class="" title="Haz clic para
obtener traducciones alternativas">?</span><span class=""
title="Haz clic para obtener traducciones alternativas">.</span>
<span title="Haz clic para obtener traducciones alternativas"
class="hps">I'll</span> <span title="Haz clic para obtener
traducciones alternativas" class="hps">look at me</span> <span
title="Haz clic para obtener traducciones alternativas"
class="hps">while the</span> <span title="Haz clic para obtener
traducciones alternativas" class="hps">modules</span> <span
title="Haz clic para obtener traducciones alternativas"
class="hps">that</span> <span title="Haz clic para obtener
traducciones alternativas" class="hps">have told me</span><span
class="" title="Haz clic para obtener traducciones alternativas">;-)</span><span
class="" title="Haz clic para obtener traducciones alternativas">.</span>
<span title="Haz clic para obtener traducciones alternativas"
class="hps">Thank you very much</span><span class="" title="Haz
clic para obtener traducciones alternativas">.</span></span><br>
<br>
<br>
Regards<br>
<br>
<action application="python" data="extension_user"/><br>
<br>
--------- extension_user.xml ---------<br>
<include><br>
<user id="1000" mailbox="1000"><br>
<params><br>
<param name="password" value="1234"/><br>
<param name="vm-password" value="1000"/><br>
</params><br>
<variables><br>
<variable name="toll_allow"
value="domestic,international,local"/><br>
<variable name="accountcode" value="1000"/><br>
<variable name="user_context" value="default"/><br>
<variable name="effective_caller_id_name"
value="NAME"/><br>
<variable name="effective_caller_id_number"
value="1000"/><br>
<variable name="outbound_caller_id_name"
value="$${outbound_caller_name}"/><br>
<variable name="outbound_caller_id_number"
value="$${outbound_caller_id}"/><br>
<variable name="callgroup" value="techsupport"/><br>
</variables><br>
</user><br>
</include><br>
--------- extension_user.xml ---------<br>
</body>
</html>