12 Apr
2017
12 Apr
'17
1:02 p.m.
Hello,
I'm trying to load data from a mysql table into a htable using a mysql view. But when i start kamailio i get the following error:
ERROR: htable [ht_db.c:345]: ht_db_load_table(): Wrong db type [3] for key_type column
Here a example of a view i'm trying to use:
CREATE OR REPLACE VIEW `view_blacklist_prefix` AS SELECT prefix AS key_name, '0' AS key_type, '0' AS value_type, '1' AS key_value, '0' AS expires FROM openser.blacklist_prefix GO
Should it be possible to use a mysql view as input for a htable?
Thanks,
Jan Hazenberg