Ovidiu,
Thanks for the pointer, with a correct CAST it works fine.
Jan
Ovidiu Sas schreef op 2017-04-12 15:09:
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 <[email protected]>
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
[email protected]
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
_______________________________________________
Kamailio (SER) - Users Mailing List
[email protected]
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
