<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 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>
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<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", "postgres://postgres:postgres@127.0.0.1:5432/postgres")<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>
</body>
</html>