Hi all,<div><br></div><div>Currently running on 1.5.4-notls and using a single htable that gets loaded at startup ala<br clear="all"><br><div><font class="Apple-style-span" face="&#39;courier new&#39;, monospace">modparam(&quot;htable&quot;, &quot;htable&quot;, &quot;local_routes=&gt;size=4;autoexpire=0;dbtable=TABLE_A;&quot;)</font></div>
<div><font class="Apple-style-span" face="&#39;courier new&#39;, monospace">modparam(&quot;htable&quot;, &quot;key_name_column&quot;, &quot;NAME_1&quot;)</font></div><div><font class="Apple-style-span" face="&#39;courier new&#39;, monospace">modparam(&quot;htable&quot;, &quot;key_value_column&quot;, &quot;VALUE_1&quot;)</font></div>
<div><font class="Apple-style-span" face="&#39;courier new&#39;, monospace">modparam(&quot;htable&quot;, &quot;fetch_rows&quot;, 512)</font></div><div><br></div><div><span class="Apple-style-span" style="font-family: arial, helvetica, sans-serif; ">This works great, the problem I&#39;ve run into is attempting to load a second htable on startup whose data comes from a different table/scheme ala</span></div>
</div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><br></font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><div><font class="Apple-style-span" face="&#39;courier new&#39;, monospace">modparam(&quot;htable&quot;, &quot;htable&quot;, &quot;inbound_acl=&gt;size=4;autoexpire=0;dbtable=TABLE_B;&quot;)</font></div>
<div><font class="Apple-style-span" face="&#39;courier new&#39;, monospace">modparam(&quot;htable&quot;, &quot;key_name_column&quot;, &quot;NAME_2&quot;)</font></div><div><font class="Apple-style-span" face="&#39;courier new&#39;, monospace">modparam(&quot;htable&quot;, &quot;key_value_column&quot;, &quot;VALUE_2&quot;)</font></div>
<div><font class="Apple-style-span" face="&#39;courier new&#39;, monospace">modparam(&quot;htable&quot;, &quot;fetch_rows&quot;, 512)</font></div><div><font class="Apple-style-span" face="&#39;courier new&#39;, monospace"><br>
</font></div><div>With both of them in the config file Kamailio fails to start with the error</div><div><br></div><div><font class="Apple-style-span" face="&#39;courier new&#39;, monospace">INFO:core:init_mod: initializing module htable</font></div>
<div><font class="Apple-style-span" face="&#39;courier new&#39;, monospace">ERROR:db_mysql:db_mysql_submit_query: driver error on query: Unknown column &#39;NAME_2&#39; in &#39;field list&#39;</font></div><div><font class="Apple-style-span" face="&#39;courier new&#39;, monospace"><br>
</font></div><div>&#39;NAME_2&#39; does not exist in &#39;TABLE_1&#39; so that seems to suggest that only the first dbtable value is used, the SQL side supports this:</div><div><br></div><div><div><font class="Apple-style-span" face="&#39;courier new&#39;, monospace">select NAME_2,key_type,value_type,VALUE_2 from TABLE_A  order by key_type</font></div>
</div><div><font class="Apple-style-span" face="&#39;courier new&#39;, monospace"><br></font></div><div>So it uses the first defined database table, but then the last defined key_name and key_value.</div><div><br></div><div>
Is there any way that I&#39;ve overlooked in the docs or elsewhere about about loading multiple htables from different database tables? I&#39;d like to use this htable in an ACL and would like to avoid database hits though can make it work with avpops if I have to.</div>
<div><br></div><div>Any suggestions are greatly appreciated.</div><div><br></div><div>Thanks, Robin</div><div><br></div><div><br></div></font></div>