<html 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="Title" content="">
<meta name="Keywords" content="">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Arial;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"Courier New";
panose-1:2 7 3 9 2 2 5 2 4 4;}
@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:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:Calibri;}
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:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Courier New";}
span.EmailStyle19
{mso-style-type:personal;
font-family:Calibri;
color:windowtext;}
span.cp
{mso-style-name:cp;}
span.n
{mso-style-name:n;}
span.s
{mso-style-name:s;}
span.p
{mso-style-name:p;}
span.mi
{mso-style-name:mi;}
span.o
{mso-style-name:o;}
span.mo
{mso-style-name:mo;}
span.k
{mso-style-name:k;}
span.EmailStyle28
{mso-style-type:personal-reply;
font-family:Calibri;
color:windowtext;}
span.msoIns
{mso-style-type:export-only;
mso-style-name:"";
text-decoration:underline;
color:teal;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:595.0pt 842.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body bgcolor="white" lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial;color:#31569F">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial;color:#31569F"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial;color:#31569F">I have an issue when I am unable to get prefix_route to work together with db_cluster. If I set the db_url manually it works great, pointing it to a specific database. However
we need the redundancy for this module.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial;color:#31569F"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial;color:#31569F">Dispatcher uses the same cluster without any issues.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial;color:#31569F"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial;color:#31569F">The following are my configuration sets:</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Arial;color:#31569F"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6">
<span style="font-size:10.0pt;font-family:Courier;color:#CC3333"># DB CLUSTER (db_cluster.inc)</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6">
<span style="font-size:10.0pt;font-family:Courier;color:black">loadmodule </span>
<b><span style="font-size:10.0pt;font-family:Courier;color:#CC9933">"db_cluster.so"</span></b><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6">
<span style="font-size:10.0pt;font-family:Courier;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6">
<span style="font-size:10.0pt;font-family:Courier;color:black">modparam(</span><b><span style="font-size:10.0pt;font-family:Courier;color:#CC9933">"db_cluster"</span></b><span style="font-size:10.0pt;font-family:Courier;color:black">,
</span><b><span style="font-size:10.0pt;font-family:Courier;color:#CC9933">"connection"</span></b><span style="font-size:10.0pt;font-family:Courier;color:black">,
</span><b><span style="font-size:10.0pt;font-family:Courier;color:#CC9933">"KAMDB01=>mysql://kamailio:password123@192.168.55.10/kamailio"</span></b><span style="font-size:10.0pt;font-family:Courier;color:black">)</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6">
<span style="font-size:10.0pt;font-family:Courier;color:black">modparam(</span><b><span style="font-size:10.0pt;font-family:Courier;color:#CC9933">"db_cluster"</span></b><span style="font-size:10.0pt;font-family:Courier;color:black">,
</span><b><span style="font-size:10.0pt;font-family:Courier;color:#CC9933">"connection"</span></b><span style="font-size:10.0pt;font-family:Courier;color:black">,
</span><b><span style="font-size:10.0pt;font-family:Courier;color:#CC9933">"KAMDB02=>mysql://kamailio:password123@192.168.55.11/kamailio"</span></b><span style="font-size:10.0pt;font-family:Courier;color:black">)</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6">
<span style="font-size:10.0pt;font-family:Courier;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6">
<span style="font-size:10.0pt;font-family:Courier;color:black">modparam(</span><b><span style="font-size:10.0pt;font-family:Courier;color:#CC9933">"db_cluster"</span></b><span style="font-size:10.0pt;font-family:Courier;color:black">,
</span><b><span style="font-size:10.0pt;font-family:Courier;color:#CC9933">"cluster"</span></b><span style="font-size:10.0pt;font-family:Courier;color:black">,
</span><b><span style="font-size:10.0pt;font-family:Courier;color:#CC9933">"AccCluster=>KAMDB02=9s9s;KAMDB01=4s4s"</span></b><span style="font-size:10.0pt;font-family:Courier;color:black">)</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6">
<span style="font-size:10.0pt;font-family:Courier;color:black">modparam(</span><b><span style="font-size:10.0pt;font-family:Courier;color:#CC9933">"db_cluster"</span></b><span style="font-size:10.0pt;font-family:Courier;color:black">,
</span><b><span style="font-size:10.0pt;font-family:Courier;color:#CC9933">"cluster"</span></b><span style="font-size:10.0pt;font-family:Courier;color:black">,
</span><b><span style="font-size:10.0pt;font-family:Courier;color:#CC9933">"Settings=>KAMDB02=9s9s;KAMDB01=4s4s"</span></b><span style="font-size:10.0pt;font-family:Courier;color:black">)</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6">
<span style="font-size:10.0pt;font-family:Courier;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6">
<span style="font-size:10.0pt;font-family:Courier;color:#CC3333"># KAMAILIO.CFG (kamailio.cfg)</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6">
<span style="font-size:10.0pt;font-family:Courier;color:#CC3333"># PREFIX ROUTE MODPARAM</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6">
<span style="font-size:10.0pt;font-family:Courier;color:#CC3333"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6">
<span style="font-size:10.0pt;font-family:Courier;color:#CC3333">loadmodule "prefix_route.so"</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6">
<span style="font-size:10.0pt;font-family:Courier;color:#CC3333">include_file "db_cluster.inc"</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6">
<span style="font-size:10.0pt;font-family:Courier;color:black">modparam(</span><b><span style="font-size:10.0pt;font-family:Courier;color:#CC9933">"prefix_route"</span></b><span style="font-size:10.0pt;font-family:Courier;color:black">,
</span><b><span style="font-size:10.0pt;font-family:Courier;color:#CC9933">"db_url"</span></b><span style="font-size:10.0pt;font-family:Courier;color:black">,
</span><b><span style="font-size:10.0pt;font-family:Courier;color:#CC9933">"cluster://Settings"</span></b><span style="font-size:10.0pt;font-family:Courier;color:black">)</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6">
<span style="font-size:10.0pt;font-family:Courier;color:black">modparam(</span><b><span style="font-size:10.0pt;font-family:Courier;color:#CC9933">"prefix_route"</span></b><span style="font-size:10.0pt;font-family:Courier;color:black">,
</span><b><span style="font-size:10.0pt;font-family:Courier;color:#CC9933">"db_table"</span></b><span style="font-size:10.0pt;font-family:Courier;color:black">,
</span><b><span style="font-size:10.0pt;font-family:Courier;color:#CC9933">"prefix_route"</span></b><span style="font-size:10.0pt;font-family:Courier;color:black">)</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6">
<span style="font-size:10.0pt;font-family:Courier;color:black">modparam(</span><b><span style="font-size:10.0pt;font-family:Courier;color:#CC9933">"prefix_route"</span></b><span style="font-size:10.0pt;font-family:Courier;color:black">,
</span><b><span style="font-size:10.0pt;font-family:Courier;color:#CC9933">"exit"</span></b><span style="font-size:10.0pt;font-family:Courier;color:black">, 1)</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="SV"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="SV"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="SV">Syslog output:</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="SV"> </span><o:p></o:p></p>
<pre style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6"><span class="n"><span style="font-family:Courier;color:black">Oct</span></span><span style="font-family:Courier;color:black"> <span class="mi">10</span> <span class="mi">09</span><span class="o">:</span><span class="mi">53</span><span class="o">:</span><span class="mo">03</span> <span class="n">kamailio01</span> <span class="o">/</span><span class="n">usr</span><span class="o">/</span><span class="n">local</span><span class="o">/</span><span class="n">sbin</span><span class="o">/</span><span class="n">kamailio</span><span class="p">[</span><span class="mi">5225</span><span class="p">]</span><span class="o">:</span> <span class="n">ERROR</span><span class="o">:</span> <span class="o"><</span><span class="n">core</span><span class="o">></span> <span class="p">[</span><span class="n">db_cmd</span><span class="p">.</span><span class="n">c</span><span class="o">:</span><span class="mi">122</span><span class="p">]</span><span class="o">:</span> <span class="n">db_cmd</span><span class="p">()</span><span class="o">:</span> <span class="n">DB</span> <span class="n">driver</span> <span class="n">cluster</span> <span class="n">does</span> <span class="n">not</span> <span class="n">implement</span> <span class="n">mandatory</span> <span class="n">db_cmd</span> <span class="n">function</span></span><o:p></o:p></pre>
<pre style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6"><span class="n"><span style="font-family:Courier;color:black">Oct</span></span><span style="font-family:Courier;color:black"> <span class="mi">10</span> <span class="mi">09</span><span class="o">:</span><span class="mi">53</span><span class="o">:</span><span class="mo">03</span> <span class="n">kamailio01</span> <span class="o">/</span><span class="n">usr</span><span class="o">/</span><span class="n">local</span><span class="o">/</span><span class="n">sbin</span><span class="o">/</span><span class="n">kamailio</span><span class="p">[</span><span class="mi">5225</span><span class="p">]</span><span class="o">:</span> <span class="n">ERROR</span><span class="o">:</span> <span class="o"><</span><span class="n">core</span><span class="o">></span> <span class="p">[</span><span class="n">db_cmd</span><span class="p">.</span><span class="n">c</span><span class="o">:</span><span class="mi">168</span><span class="p">]</span><span class="o">:</span> <span class="n">db_cmd</span><span class="p">()</span><span class="o">:</span> <span class="n">db_cmd</span><span class="o">:</span> <span class="n">Cannot</span> <span class="n">create</span> <span class="n">db_cmd</span> <span class="n">structure</span></span><o:p></o:p></pre>
<pre style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6"><span class="n"><span style="font-family:Courier;color:black">Oct</span></span><span style="font-family:Courier;color:black"> <span class="mi">10</span> <span class="mi">09</span><span class="o">:</span><span class="mi">53</span><span class="o">:</span><span class="mo">03</span> <span class="n">kamailio01</span> <span class="o">/</span><span class="n">usr</span><span class="o">/</span><span class="n">local</span><span class="o">/</span><span class="n">sbin</span><span class="o">/</span><span class="n">kamailio</span><span class="p">[</span><span class="mi">5225</span><span class="p">]</span><span class="o">:</span> <span class="n">ERROR</span><span class="o">:</span> <span class="n">prefix_route</span> <span class="p">[</span><span class="n">prefix_route</span><span class="p">.</span><span class="n">c</span><span class="o">:</span><span class="mi">126</span><span class="p">]</span><span class="o">:</span> <span class="n">pr_db_load</span><span class="p">()</span><span class="o">:</span> <span class="n">prefix_route</span><span class="o">:</span> <span class="n">db_load</span><span class="p">()</span><span class="o">:</span> <span class="n">db_cmd</span><span class="p">()</span> <span class="n">failed</span></span><o:p></o:p></pre>
<pre style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6"><span class="n"><span style="font-family:Courier;color:black">Oct</span></span><span style="font-family:Courier;color:black"> <span class="mi">10</span> <span class="mi">09</span><span class="o">:</span><span class="mi">53</span><span class="o">:</span><span class="mo">03</span> <span class="n">kamailio01</span> <span class="o">/</span><span class="n">usr</span><span class="o">/</span><span class="n">local</span><span class="o">/</span><span class="n">sbin</span><span class="o">/</span><span class="n">kamailio</span><span class="p">[</span><span class="mi">5225</span><span class="p">]</span><span class="o">:</span> <span class="o">:</span> <span class="n">prefix_route</span> <span class="p">[</span><span class="n">prefix_route</span><span class="p">.</span><span class="n">c</span><span class="o">:</span><span class="mi">214</span><span class="p">]</span><span class="o">:</span> <span class="n">mod_init</span><span class="p">()</span><span class="o">:</span> <span class="n">prefix_route</span><span class="o">:</span> <span class="n">db_load</span><span class="p">()</span> <span class="n">failed</span></span><o:p></o:p></pre>
<pre style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6"><span class="n"><span style="font-family:Courier;color:black">Oct</span></span><span style="font-family:Courier;color:black"> <span class="mi">10</span> <span class="mi">09</span><span class="o">:</span><span class="mi">53</span><span class="o">:</span><span class="mo">03</span> <span class="n">kamailio01</span> <span class="o">/</span><span class="n">usr</span><span class="o">/</span><span class="n">local</span><span class="o">/</span><span class="n">sbin</span><span class="o">/</span><span class="n">kamailio</span><span class="p">[</span><span class="mi">5225</span><span class="p">]</span><span class="o">:</span> <span class="n">ERROR</span><span class="o">:</span> <span class="o"><</span><span class="n">core</span><span class="o">></span> <span class="p">[</span><span class="n">sr_module</span><span class="p">.</span><span class="n">c</span><span class="o">:</span><span class="mi">974</span><span class="p">]</span><span class="o">:</span> <span class="n">init_mod</span><span class="p">()</span><span class="o">:</span> <span class="n">Error</span> </span><span class="k"><b><span style="font-family:Courier;color:#0033CC">while</span></b></span><span style="font-family:Courier;color:black"> <span class="n">initializing</span> <span class="n">module</span> <span class="n">prefix_route</span> <span class="p">(</span><span class="n">usr</span><span class="o">/</span><span class="n">local</span><span class="o">/</span><span class="n">lib64</span><span class="o">/</span><span class="n">kamailio</span><span class="o">/</span><span class="n">modules</span><span class="o">/</span><span class="n">prefix_route</span><span class="p">.</span><span class="n">so</span><span class="p">)</span></span><o:p></o:p></pre>
<pre style="mso-margin-top-alt:6.0pt;margin-right:0cm;margin-bottom:6.0pt;margin-left:0cm;line-height:13.2pt;background:#F6F6F6"><span class="n"><span style="font-family:Courier;color:black">Oct</span></span><span style="font-family:Courier;color:black"> <span class="mi">10</span> <span class="mi">09</span><span class="o">:</span><span class="mi">53</span><span class="o">:</span><span class="mo">03</span> <span class="n">kamailio01</span> <span class="o">/</span><span class="n">usr</span><span class="o">/</span><span class="n">local</span><span class="o">/</span><span class="n">sbin</span><span class="o">/</span><span class="n">kamailio</span><span class="p">[</span><span class="mi">5225</span><span class="p">]</span><span class="o">:</span> <span class="n">INFO</span><span class="o">:</span> <span class="o"><</span><span class="n">core</span><span class="o">></span> <span class="p">[</span><span class="n">sctp_core</span><span class="p">.</span><span class="n">c</span><span class="o">:</span><span class="mi">53</span><span class="p">]</span><span class="o">:</span> <span class="n">sctp_core_destroy</span><span class="p">()</span><span class="o">:</span> <span class="n">SCTP</span> <span class="n">API</span> <span class="n">not</span> <span class="n">initialized</span></span><o:p></o:p></pre>
<p class="MsoNormal"><span lang="SV"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="SV"> <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="SV">Ubuntu 14.04LTS<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="SV">version: kamailio 4.3.6 (x86_64/linux) 105a17<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="SV">flags: STATS: Off, USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, USE_RAW_SOCKS, DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MEM, SHM_MMAP, PKG_MALLOC, DBG_QM_MALLOC, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE, USE_DNS_FAILOVER,
USE_NAPTR, USE_DST_BLACKLIST, HAVE_RESOLV_RES<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="SV">ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="SV">poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="SV">id: 105a17<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="SV">compiled on 10:06:12 Oct 4 2016 with gcc 4.8.4<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="SV"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="SV">Thank you.</span><o:p></o:p></p>
</div>
</body>
</html>