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

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 jenus@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@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users