<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Hi Ben,<br>
<br>
<tt>Could you <tt>check</tt> if a 2.3 version prior this commit:<br>
<tt>
<a class="moz-txt-link-freetext" href="https://github.com/OpenSIPS/opensips/commit/f25fbf631b6fb6eafea192f95f9a43566d68cc46#diff-91bbef43b346f11cbef768a1b01c74e0">https://github.com/OpenSIPS/opensips/commit/f25fbf631b6fb6eafea192f95f9a43566d68cc46#diff-91bbef43b346f11cbef768a1b01c74e0</a><br>
<tt>will still have the 1.11 <tt>behavior</tt><tt> ?<br>
<br>
<tt><tt>Regards,</tt></tt><br>
</tt></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 02/15/2018 03:22 PM, Ben Newlin
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:64CCB492-67CF-4D78-899B-630003E3FF51@genesys.com">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@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:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Calibri",sans-serif;}
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 Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
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:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Consolas",serif;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle22
{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:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt">Bogdan,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Yes, this
exact configuration was working in 1.11. None of these
module required any configuration changes that I could see
for the migration, so it is unchanged.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Thanks,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Ben Newlin<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #B5C4DF
1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="color:black">From: </span></b><span
style="color:black">Bogdan-Andrei Iancu
<a class="moz-txt-link-rfc2396E" href="mailto:bogdan@opensips.org"><bogdan@opensips.org></a><br>
<b>Date: </b>Thursday, February 15, 2018 at 2:21 AM<br>
<b>To: </b>OpenSIPS users mailling list
<a class="moz-txt-link-rfc2396E" href="mailto:users@lists.opensips.org"><users@lists.opensips.org></a>, Ben Newlin
<a class="moz-txt-link-rfc2396E" href="mailto:Ben.Newlin@genesys.com"><Ben.Newlin@genesys.com></a><br>
<b>Subject: </b>Re: [OpenSIPS-Users] Avpops and
db_virtual modules<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><a name="_MailOriginalBody"
moz-do-not-send="true"><tt><span style="font-size:10.0pt">Ben,
emails are welcome, as they provide valuable feedback
for us ;)</span></tt></a><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:10.0pt;font-family:"Courier
New""><br>
<br>
<tt>Do you say that avpops + db_virtual combination was
working in 1.11 ? I remember there were some fixes
couple of months ago in regards to how the capabilities
do propagate via the virtual module.
</tt><br>
<br>
<tt>Regards,</tt><br>
<br>
</span></span><span style="mso-bookmark:_MailOriginalBody"><o:p></o:p></span></p>
<pre><span style="mso-bookmark:_MailOriginalBody">Bogdan-Andrei Iancu<o:p></o:p></span></pre>
<pre><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></pre>
<pre><span style="mso-bookmark:_MailOriginalBody">OpenSIPS Founder and Developer<o:p></o:p></span></pre>
<pre><span style="mso-bookmark:_MailOriginalBody"> </span><a href="http://www.opensips-solutions.com" moz-do-not-send="true"><span style="mso-bookmark:_MailOriginalBody">http://www.opensips-solutions.com</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><o:p></o:p></span></pre>
<pre><span style="mso-bookmark:_MailOriginalBody">OpenSIPS Summit 2018<o:p></o:p></span></pre>
<pre><span style="mso-bookmark:_MailOriginalBody"> </span><a href="http://www.opensips.org/events/Summit-2018Amsterdam" moz-do-not-send="true"><span style="mso-bookmark:_MailOriginalBody">http://www.opensips.org/events/Summit-2018Amsterdam</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><o:p></o:p></span></pre>
<div>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody">On 02/15/2018 02:36
AM, Ben Newlin wrote:<o:p></o:p></span></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:11.0pt">Hi,</span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:11.0pt"> </span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:11.0pt">Sorry for all of the emails! I
have found one more issue while trying to upgrade from
OpenSIPS 1.11 to 2.x. We use the db_virtual module in
front of our redundant Postgres DB instances to
facilitate failover between the DBs. We also use the
avpops module to perform raw queries against the DB. In
both 2.2.6 and 2.3.3 I get the following error when
trying to load this configuration:</span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:11.0pt"> </span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:10.0pt">CRITICAL:avpops:avpops_db_bind:
database modules (virtual://set1) does not provide all
functions needed by avpops module</span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:10.0pt">ERROR:core:init_mod: failed to
initialize module avpops</span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:10.0pt"> </span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:11.0pt">My configuration is as follows:</span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:11.0pt"> </span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:10.0pt">#// PostgreSQL Database module</span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:10.0pt">loadmodule "db_postgres.so"</span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:10.0pt">modparam("db_postgres",
"exec_query_threshold", 500000)</span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:10.0pt"> </span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:10.0pt">#// Virtual DB module</span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:10.0pt">loadmodule "db_virtual.so"</span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:10.0pt">modparam("db_virtual",
"db_urls", "define set1 ROUND")</span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:10.0pt">modparam("db_virtual",
"db_urls",
</span></span><a
href="mailto:postgres://postgres:postgres@127.0.0.1:5432/postgres"
moz-do-not-send="true"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:10.0pt">"postgres://postgres:postgres@127.0.0.1:5432/postgres"</span></span><span
style="mso-bookmark:_MailOriginalBody"></span></a><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:10.0pt">)</span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:10.0pt"> </span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:10.0pt">#// AVP OPerationS module</span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:10.0pt">loadmodule "avpops.so"</span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:10.0pt">modparam("avpops", "db_url",
"virtual://set1")</span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:11.0pt"> </span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:11.0pt">Is db_virtual simply not
compatible with the new OpenSIPS versions or has
something changed in the configuration that I am
missing?</span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:11.0pt"> </span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:11.0pt">Thanks,</span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:11.0pt">Ben Newlin</span><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:11.0pt"><br>
<br>
<br>
<o:p></o:p></span></span></p>
<pre><span style="mso-bookmark:_MailOriginalBody">_______________________________________________<o:p></o:p></span></pre>
<pre><span style="mso-bookmark:_MailOriginalBody">Users mailing list<o:p></o:p></span></pre>
<pre><span style="mso-bookmark:_MailOriginalBody"></span><a href="mailto:Users@lists.opensips.org" moz-do-not-send="true"><span style="mso-bookmark:_MailOriginalBody">Users@lists.opensips.org</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><o:p></o:p></span></pre>
<pre><span style="mso-bookmark:_MailOriginalBody"></span><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" moz-do-not-send="true"><span style="mso-bookmark:_MailOriginalBody">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><o:p></o:p></span></pre>
</blockquote>
<p class="MsoNormal"><span
style="mso-bookmark:_MailOriginalBody"><span
style="font-size:11.0pt"><br>
<br>
</span></span><span style="font-size:11.0pt"><o:p></o:p></span></p>
</div>
</blockquote>
<br>
</body>
</html>