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

_______________________________________________
Kamailio (SER) - Users Mailing List
[email protected]
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

Reply via email to