<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Vlad and Alain<div><br></div><div>Thank you for your prompt response! I'll look into the m4 documentation and see how to use that. I'll then try both methods separately and report back whether using m4 or adding all modules to the modparam seems to work better.</div><div><br></div><div>Regards</div><div><br></div><div>Gary<br><br><div><hr id="stopSpelling">Date: Thu, 26 Jun 2014 14:31:20 +0300<br>From: vladpaiu@opensips.org<br>To: users@lists.opensips.org<br>Subject: Re: [OpenSIPS-Users] Using external MySQL server<br><br>
<div class="ecxmoz-cite-prefix">Hello,<br>
<br>
To make things simpler, you can also do<br>
<br>
modparam("module1|module2|module3","db_url","YOUR_URL_HERE")<br>
<br>
Best Regards,<br>
<pre class="ecxmoz-signature">Vlad Paiu
OpenSIPS Developer
<a class="ecxmoz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a> </pre>
On 26.06.2014 11:13, Alain BIEUZENT wrote:<br>
</div>
<blockquote cite="mid:004501cf9116$8ab1cd50$a01567f0$@free.fr">
<style><!--
.ExternalClass p.ecxMsoNormal, .ExternalClass li.ecxMsoNormal, .ExternalClass div.ecxMsoNormal {
font-size:12.0pt;
font-family:"Times New Roman","serif";
}
.ExternalClass a:link, .ExternalClass span.ecxMsoHyperlink {
color:blue;
text-decoration:underline;
}
.ExternalClass span.ecxMsoHyperlinkFollowed {
color:purple;
text-decoration:underline;
}
.ExternalClass p {
font-size:12.0pt;
font-family:"Times New Roman","serif";
}
.ExternalClass span.ecxEmailStyle18 {
font-family:"Calibri","sans-serif";
color:#1F497D;
}
.ExternalClass .ecxMsoChpDefault {
font-size:10.0pt;
}
.ExternalClass div.ecxWordSection1 {
}
--></style>
<div class="ecxWordSection1">
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;">Hi
gary,</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;"> </span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;" lang="EN-US">You can use m4 « compilator » for this</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;" lang="EN-US"> </span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;" lang="EN-US">Have look to : <a href="http://www.opensips.org/Documentation/Tools" target="_blank">http://www.opensips.org/Documentation/Tools</a></span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;" lang="EN-US"> </span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;" lang="EN-US">Regards</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;" lang="EN-US"> </span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm;">
<p class="ecxMsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";">De :</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";">
<a class="ecxmoz-txt-link-abbreviated" href="mailto:users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a>
[<a class="ecxmoz-txt-link-freetext" href="mailto:users-bounces@lists.opensips.org">mailto:users-bounces@lists.opensips.org</a>] <b>De la part
de</b> Gary Patton<br>
<b>Envoyé :</b> jeudi 26 juin 2014 01:29<br>
<b>À :</b> <a class="ecxmoz-txt-link-abbreviated" href="mailto:users@lists.opensips.org">users@lists.opensips.org</a><br>
<b>Objet :</b> [OpenSIPS-Users] Using external MySQL
server</span></p>
</div>
</div>
<p class="ecxMsoNormal"> </p>
<div>
<p class="ecxMsoNormal"><span style="font-family:"Calibri","sans-serif";">Hi
again! Another newbie question.</span></p>
<div>
<p class="ecxMsoNormal"><span style="font-family:"Calibri","sans-serif";"> </span></p>
</div>
<div>
<p class="ecxMsoNormal"><span style="font-family:"Calibri","sans-serif";">If
I want a module to use an external MySQL db server, I
simply modify the modparam for each module in my
residential config file by adding the external server's
IP address to the DB_URL parameter for each module. </span></p>
</div>
<div>
<p class="ecxMsoNormal"><span style="font-family:"Calibri","sans-serif";"> </span></p>
</div>
<div>
<p class="ecxMsoNormal"><span style="font-family:"Calibri","sans-serif";">But
isn't there a simpler way? I guess what I'm asking is
whether I can enter the external db server's IP address
on a single line in a config file somewhere in OpenSIPS
and OpenSIPS will use the external MySQL server for all
the modules included in my residential config file?</span></p>
</div>
<div>
<p class="ecxMsoNormal"><span style="font-family:"Calibri","sans-serif";"> </span></p>
</div>
<div>
<p class="ecxMsoNormal"><span style="font-family:"Calibri","sans-serif";">Hope
this question isn't too silly.</span></p>
</div>
<div>
<p class="ecxMsoNormal"><span style="font-family:"Calibri","sans-serif";"> </span></p>
</div>
<div>
<p class="ecxMsoNormal"><span style="font-family:"Calibri","sans-serif";">Regards</span></p>
</div>
<div>
<p class="ecxMsoNormal"><span style="font-family:"Calibri","sans-serif";"> </span></p>
</div>
<div>
<p class="ecxMsoNormal"><span style="font-family:"Calibri","sans-serif";">Gary</span></p>
</div>
</div>
</div>
<br>
<fieldset class="ecxmimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
Users mailing list
<a class="ecxmoz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="ecxmoz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
<br>_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users</div></div> </div></body>
</html>