<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"\0027Helvetica Neue\0027";
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.apple-style-span
{mso-style-name:apple-style-span;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
span.longtext
{mso-style-name:long_text;}
span.E-MailFormatvorlage20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=DE-CH link=blue vlink=purple style='word-wrap: break-word;
-webkit-nbsp-mode: space;-webkit-line-break: after-white-space'>
<div class=WordSection1>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hi,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>There is also the possibility to use the xml-handler (e.g. lua),
write a c/c++ module which does fetch the dialplan/directory. Also it is
possible to call lua as a application and then do some sort of mysql queries. <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Another possible way is, that you specify to use LUA for the
context of a sip profile. Then, if the context would be used, it will just call
the lua script<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>BR,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Bernhard<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=DE style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>Von:</span></b><span
lang=DE style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
freeswitch-users-bounces@lists.freeswitch.org
[mailto:freeswitch-users-bounces@lists.freeswitch.org] <b>Im Auftrag von </b>David
Ponzone<br>
<b>Gesendet:</b> Dienstag, 28. September 2010 08:57<br>
<b>An:</b> FreeSWITCH Users Help<br>
<b>Betreff:</b> Re: [Freeswitch-users] Freeswitch and mysql<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Antonio,<o:p></o:p></p>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>there are 2 main solutions:<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>-use mod_xml_curl, which allows to get the whole dialplan
from HTTP (so from SQL, using the language of your choice)<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>-have a "call routing engine" written in the
language of your choice (LUA, JS, Python, Perl, C, C#, Ruby) running standalone
besides FS. It will be connected to FS through sockets, and then you can
include any level of "smartness" in that engine<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<div>
<div>
<div>
<div>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:"'Helvetica Neue'","serif";
color:#1C00FF'>David Ponzone </span><span class=apple-style-span><span
style='font-size:9.0pt;font-family:"'Helvetica Neue'","serif";color:black'>Direction
Technique</span></span><span style='font-size:10.5pt;font-family:"Helvetica","sans-serif";
color:black'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:10.0pt;
font-family:"'Helvetica Neue'","serif";color:black'>email: <a
href="mailto:david.ponzone@ipeva.fr">david.ponzone@ipeva.fr</a></span></span><span
style='font-size:10.5pt;font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:10.0pt;
font-family:"'Helvetica Neue'","serif";color:black'>tel: 01
74 03 18 97</span></span><span style='font-size:10.5pt;font-family:"Helvetica","sans-serif";
color:black'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:10.0pt;
font-family:"'Helvetica Neue'","serif";color:black'>gsm: 06 66 98 76 34</span></span><span
style='font-size:10.5pt;font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:"Helvetica","sans-serif";
color:black'><o:p> </o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:"'Helvetica Neue'","serif";
color:#1C00FF'>Service Client<span class=apple-converted-space> </span></span><span
style='font-size:10.5pt;font-family:"'Helvetica Neue'","serif";color:red'>IP</span><span
style='font-size:10.5pt;font-family:"'Helvetica Neue'","serif";color:#1C00FF'>eva</span><span
style='font-size:10.5pt;font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p>
</div>
<div>
<div>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:10.0pt;
font-family:"'Helvetica Neue'","serif";color:black'>tel:
0811 46 26 26</span></span><span style='font-size:10.5pt;font-family:
"Helvetica","sans-serif";color:black'><o:p></o:p></span></p>
</div>
<div>
<div>
<p class=MsoNormal><u><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:#0022F3'><a href="BLOCKED::http://www.ipeva.fr/">www.ipeva.fr</a></span></u><span
style='font-size:7.5pt;font-family:"Arial","sans-serif";color:#656895'>
- </span><u><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:#0022F3'><a href="BLOCKED::http://www.ipeva-studio.com/">www.ipeva-studio.com</a></span></u><span
style='font-size:7.5pt;font-family:"Arial","sans-serif";color:#0022F3'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:#0022F3'><o:p> </o:p></span></p>
</div>
<div>
<p class=MsoNormal style='text-align:justify'><i><span style='font-size:7.5pt;
font-family:"Arial","sans-serif";color:silver'>Ce message et toutes les pièces
jointes sont confidentiels et établis à l'intention exclusive de ses
destinataires. Toute utilisation ou diffusion non autorisée est interdite. Tout
message électronique est susceptible d'altération. <b>IPeva</b> décline
toute responsabilité au titre de ce message s'il a été altéré, déformé ou
falsifié. Si vous n'êtes pas destinataire de ce message, merci de le détruire
immédiatement et d'avertir l'expéditeur.</span></i><span style='font-size:7.5pt;
font-family:"Arial","sans-serif";color:silver'><o:p></o:p></span></p>
<p class=MsoNormal style='text-align:justify'><u><span style='font-size:7.5pt;
font-family:"Arial","sans-serif";color:#0022F3'><o:p><span style='text-decoration:
none'> </span></o:p></span></u></p>
</div>
</div>
</div>
</div>
<p class=MsoNormal><span style='font-size:10.5pt;font-family:"Helvetica","sans-serif";
color:black'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<div>
<p class=MsoNormal>Le 28/09/2010 à 00:36, Antonio a écrit :<o:p></o:p></p>
</div>
<p class=MsoNormal><br>
<br>
<o:p></o:p></p>
<div>
<p class=MsoNormal><span class=longtext><span style='background:white'>Hello,</span></span><span
style='background:white'><br>
<br>
<span class=longtext>I asked and more I searched, I found nothing, how to
integrate FreeSwitch with mysql. Some time ago I found Asterisk-realtime and
wanted to know if there is something similar in FreeSwitch. Is to avoid double
configurations, for example if there is a conference room that can be accessed
from multiple servers, etc. </span></span><span class=longtext>I'm new in
FreeSwitch and I have much knowledge ;-)</span><br>
<br>
<span class=longtext><span style='background:white'>Does anyone have any url or
book on how to do? </span>Lua?. Thanks.</span><br>
<br>
<span class=longtext><span style='background:white'>Greetings</span></span> <o:p></o:p></p>
</div>
<p class=MsoNormal>_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<br>
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br>
http://www.freeswitch.org<o:p></o:p></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</div>
</body>
</html>