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="'courier new', monospace">modparam("htable", "htable", "local_routes=>size=4;autoexpire=0;dbtable=TABLE_A;")</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">modparam("htable", "key_name_column", "NAME_1")</font></div><div><font class="Apple-style-span" face="'courier new', monospace">modparam("htable", "key_value_column", "VALUE_1")</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">modparam("htable", "fetch_rows", 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'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="'courier new', monospace">modparam("htable", "htable", "inbound_acl=>size=4;autoexpire=0;dbtable=TABLE_B;")</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">modparam("htable", "key_name_column", "NAME_2")</font></div><div><font class="Apple-style-span" face="'courier new', monospace">modparam("htable", "key_value_column", "VALUE_2")</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">modparam("htable", "fetch_rows", 512)</font></div><div><font class="Apple-style-span" face="'courier new', 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="'courier new', monospace">INFO:core:init_mod: initializing module htable</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">ERROR:db_mysql:db_mysql_submit_query: driver error on query: Unknown column 'NAME_2' in 'field list'</font></div><div><font class="Apple-style-span" face="'courier new', monospace"><br>
</font></div><div>'NAME_2' does not exist in 'TABLE_1' 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="'courier new', 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="'courier new', 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've overlooked in the docs or elsewhere about about loading multiple htables from different database tables? I'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>