<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Just <tt>as an update, the fix was confirmed and backported on
2.2 and 2.3 also.<br>
<br>
<tt>Thanks Olle<tt> !<br>
<br>
<tt>Regards,</tt><br>
</tt></tt></tt></tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a>
OpenSIPS Summit 2018
<a class="moz-txt-link-freetext" href="http://www.opensips.org/events/Summit-2018Amsterdam">http://www.opensips.org/events/Summit-2018Amsterdam</a>
</pre>
<div class="moz-cite-prefix">On 03/02/2018 07:32 PM, Bogdan-Andrei
Iancu wrote:<br>
</div>
<blockquote type="cite"
cite="mid:9bc7d71b-857e-baef-ede9-4f03024f98e5@opensips.org">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<tt>Hi Olle,<br>
<br>
<tt>Could you give a try to this fix<tt>:<br>
<tt>
<a class="moz-txt-link-freetext"
href="https://github.com/OpenSIPS/opensips/commit/5b0bc1e30ebfc1e67f4967c3e66cfa7577ee5b58"
moz-do-not-send="true">https://github.com/OpenSIPS/opensips/commit/5b0bc1e30ebfc1e67f4967c3e66cfa7577ee5b58</a><br>
<br>
<tt>C<tt>urren<tt>tly this is available only on trunk
version (still you can use the nightly builds from
the official repo<tt>s). If your tests are posit<tt>ive<tt>,
I will do a backport ;)<br>
<br>
<tt>Best regards,</tt><br>
</tt></tt></tt></tt></tt></tt><br>
</tt></tt></tt></tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com" moz-do-not-send="true">http://www.opensips-solutions.com</a>
OpenSIPS Summit 2018
<a class="moz-txt-link-freetext" href="http://www.opensips.org/events/Summit-2018Amsterdam" moz-do-not-send="true">http://www.opensips.org/events/Summit-2018Amsterdam</a>
</pre>
<div class="moz-cite-prefix">On 02/13/2018 04:11 PM, Olle
Frimanson wrote:<br>
</div>
<blockquote type="cite"
cite="mid:015f01d3a4d4$7de02560$79a07020$@zaark.com">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML - förformaterad Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
tt
{mso-style-priority:99;
font-family:"Courier New";}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
span.HTML-frformateradChar
{mso-style-name:"HTML - förformaterad Char";
mso-style-priority:99;
mso-style-link:"HTML - förformaterad";
font-family:Consolas;
color:black;}
span.E-postmall21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.E-postmall22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 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]-->
<div class="WordSection1">
<p class="MsoNormal"><span style="color:windowtext"
lang="EN-US">Hi, thanks for the reply. We try to avoid
installing from source and rather use RPM’s. We are also
looking into using a SQL proxy and have that locally on
the opensips server. But the very best solution would be
to escape somehow.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"
lang="EN-US">I think there was a similar problem with the
TLS crypto suite that was fixed in a nice way.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"
lang="EN-US">And I don’t think we can get Microsoft to
change the usernames for MySQL </span><span
style="font-family:Wingdings;color:windowtext"
lang="EN-US">J</span><span style="color:windowtext"
lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"
lang="EN-US">BR / Olle<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"
lang="EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span
style="color:windowtext;mso-fareast-language:SV">Från:</span></b><span
style="color:windowtext;mso-fareast-language:SV">
Bogdan-Andrei Iancu [<a class="moz-txt-link-freetext"
href="mailto:bogdan@opensips.org"
moz-do-not-send="true">mailto:bogdan@opensips.org</a>]
<br>
<b>Skickat:</b> den 6 februari 2018 18:20<br>
<b>Till:</b> OpenSIPS users mailling list <a
class="moz-txt-link-rfc2396E"
href="mailto:users@lists.opensips.org"
moz-do-not-send="true"><users@lists.opensips.org></a>;
Olle Frimanson <a class="moz-txt-link-rfc2396E"
href="mailto:olle@zaark.com" moz-do-not-send="true"><olle@zaark.com></a><br>
<b>Ämne:</b> Re: [OpenSIPS-Users] Username in DB URL<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><tt><span style="font-size:10.0pt">Hi
Olle,</span></tt><span
style="font-size:10.0pt;font-family:"Courier
New""><br>
<br>
<tt>As Alex said there is no work around for this for now.
Still the problem can be addressed by coding and it is
not so hard to do. The question is what is the
best/proper type of escaping to be supported into the
URL - I guess the %xy is the proper one for an URL, as
per RFC 1738 ).</tt><br>
<br>
<tt>Have you installed opensips form sources ?</tt><br>
<br>
<tt>Regards,</tt><br>
<br>
</span><span style="mso-fareast-language:SV"><o:p></o:p></span></p>
<pre>Bogdan-Andrei Iancu<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>OpenSIPS Founder and Developer<o:p></o:p></pre>
<pre> <a href="http://www.opensips-solutions.com" moz-do-not-send="true">http://www.opensips-solutions.com</a><o:p></o:p></pre>
<pre>OpenSIPS Summit 2018<o:p></o:p></pre>
<pre> <a href="http://www.opensips.org/events/Summit-2018Amsterdam" moz-do-not-send="true">http://www.opensips.org/events/Summit-2018Amsterdam</a><o:p></o:p></pre>
<div>
<p class="MsoNormal">On 02/05/2018 08:08 PM, Olle Frimanson
wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span lang="EN-US">Hi, we are
experiencing an issue with a roleout in Microsoft Azure,
where the DB username contains a ”@” sign. This seems
to be the default in MySQL in Azure. Is there anyway to
escape this the URL for the clusterer module?</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US">If you use mysql
client it’s typical something like</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US">Mysql -h
host.mysql.azure.com -u opensips@host -popensips
opensips, which works fine</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US">In clustererar where
we use this this translates to:</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US">modparam("clusterer",
"db_url",<a
href="mailto:mysql://opensips@host:opensips@host.mysql.azure.com/opensips"
moz-do-not-send="true">"mysql://opensips@host:opensips@host.mysql.azure.com/opensips"</a>)</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US">which fails</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US">Any ideas on a
workaround on this?</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US">BR / Olle</span><o:p></o:p></p>
<p class="MsoNormal"><span style="mso-fareast-language:SV"><br>
<br>
<br>
<o:p></o:p></span></p>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>Users mailing list<o:p></o:p></pre>
<pre><a href="mailto:Users@lists.opensips.org" moz-do-not-send="true">Users@lists.opensips.org</a><o:p></o:p></pre>
<pre><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" moz-do-not-send="true">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"><span style="mso-fareast-language:SV"><o:p> </o:p></span></p>
</div>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>