[SR-Users] Loading multiple htables from db on startup? (Kamailio 1.5)

[Robin Rodriguez]

Hi all,

Currently running on 1.5.4-notls and using a single htable that gets loaded
at startup ala

modparam("htable", "htable",
"local_routes=>size=4;autoexpire=0;dbtable=TABLE_A;")
modparam("htable", "key_name_column", "NAME_1")
modparam("htable", "key_value_column", "VALUE_1")
modparam("htable", "fetch_rows", 512)

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

modparam("htable", "htable",
"inbound_acl=>size=4;autoexpire=0;dbtable=TABLE_B;")
modparam("htable", "key_name_column", "NAME_2")
modparam("htable", "key_value_column", "VALUE_2")
modparam("htable", "fetch_rows", 512)

With both of them in the config file Kamailio fails to start with the error

INFO:core:init_mod: initializing module htable
ERROR:db_mysql:db_mysql_submit_query: driver error on query: Unknown column
'NAME_2' in 'field list'

'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:

select NAME_2,key_type,value_type,VALUE_2 from TABLE_A  order by key_type

So it uses the first defined database table, but then the last defined
key_name and key_value.

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.

Any suggestions are greatly appreciated.

Thanks, Robin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110705/5b3f7600/attachment.htm>