12 Apr
2017
12 Apr
'17
4:09 p.m.
Based on how your blacklist_prefix table is defined, you will need to
perform some casts to make sure that the view matches the layout of
the htable:
ID NOT NULL UNSIGNED INT
KEY_NAME VARCHAR2(64)
KEY_TYPE INT
VALUE_TYPE INT
KEY_VALUE VARCHAR2(16)
EXPIRES INT
Regards,
Ovidiu Sas
On Wed, Apr 12, 2017 at 9:02 AM, Jan Hazenberg <jenus(a)cyberchaos.nl> wrote:
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
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
--
VoIP Embedded, Inc.
http://www.voipembedded.com