[SR-Users] Use mysql view to load data into htable

Jan Hazenberg jenus at cyberchaos.nl
Wed Apr 12 15:02:19 CEST 2017


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



More information about the sr-users mailing list