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 -- VoIP Embedded, Inc. http://www.voipembedded.com _______________________________________________ Kamailio (SER) - Users Mailing List [email protected] https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
