<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Ben, emails are welcome, as they provide valuable feedback for
us ;)<br>
<br>
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. <br>
<br>
Regards,<br>
</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 02:36 AM, Ben Newlin
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:27EDAC44-90A5-44CA-BE19-125246B0D65B@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;}
/* 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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@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">Hi,<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">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:<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:10.0pt">CRITICAL:avpops:avpops_db_bind:
database modules (virtual://set1) does not provide all
functions needed by avpops module<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt">ERROR:core:init_mod:
failed to initialize module avpops<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">My
configuration is as follows:<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:10.0pt">#//
PostgreSQL Database module<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt">loadmodule
"db_postgres.so"<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt">modparam("db_postgres",
"exec_query_threshold", 500000)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt">#// Virtual
DB module<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt">loadmodule
"db_virtual.so"<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt">modparam("db_virtual",
"db_urls", "define set1 ROUND")<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt">modparam("db_virtual",
"db_urls",
<a class="moz-txt-link-rfc2396E" href="mailto:postgres://postgres:postgres@127.0.0.1:5432/postgres">"postgres://postgres:postgres@127.0.0.1:5432/postgres"</a>)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt">#// AVP
OPerationS module<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt">loadmodule
"avpops.so"<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt">modparam("avpops",
"db_url", "virtual://set1")<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">Is
db_virtual simply not compatible with the new OpenSIPS
versions or has something changed in the configuration that
I am missing?<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>
</div>
<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>