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