12 Apr
2017
12 Apr
'17
4: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