``` c int reload_address_db_table(address_tables_group_t *atg) { db_key_t cols[5]; db1_res_t* res = NULL; db_row_t* row; db_val_t* val; int i; unsigned int gid; unsigned int port; unsigned int mask; str ips; str tagv; cols[0] = &perm_grp_col; cols[1] = &perm_ip_addr_col; cols[2] = &perm_mask_col; cols[3] = &perm_port_col; cols[4] = &perm_tag_col; if (perm_dbf.use_table(perm_db_handle, &perm_address_table) < 0) { LM_ERR("failed to use table\n"); return -1; } if (perm_dbf.query(perm_db_handle, NULL, 0, NULL, cols, 0, 5, 0, &res) < 0) { LM_ERR("failed to query database\n"); return -1; } row = RES_ROWS(res); LM_DBG("Number of rows in address table: %d\n", RES_ROW_N(res)); for (i = 0; i < RES_ROW_N(res); i++) { val = ROW_VALUES(row + i); /* basic checks to db values */ if (ROW_N(row + i) != 5) { LM_DBG("failure during checks of db address table: Columns %d - expected 5\n", ROW_N(row + i)); goto dberror; } if ((VAL_TYPE(val) != DB1_INT) || VAL_NULL(val) || (VAL_INT(val) <= 0)) { LM_DBG("failure during checks of database value 1 (group) in address table\n"); goto dberror; } if ((VAL_TYPE(val + 1) != DB1_STRING) && (VAL_TYPE(val + 1) != DB1_STR)) { LM_DBG("failure during checks of database value 2 (IP address) in address table - not a string value\n"); goto dberror; } if (VAL_NULL(val + 1)) { LM_DBG("failure during checks of database value 2 (IP address) in address table - NULL value not permitted\n"); goto dberror; } if ((VAL_TYPE(val + 2) != DB1_INT) || VAL_NULL(val + 2)) { LM_DBG("failure during checks of database value 3 (subnet size/CIDR) in address table\n"); goto dberror; } if ((VAL_TYPE(val + 3) != DB1_INT) || VAL_NULL(val + 3)) { LM_DBG("failure during checks of database value 4 (port) in address table\n"); goto dberror; } gid = VAL_UINT(val); ips.s = (char *)VAL_STRING(val + 1); ips.len = strlen(ips.s); mask = VAL_UINT(val + 2); port = VAL_UINT(val + 3); tagv.s = VAL_NULL(val + 4)?NULL:(char *)VAL_STRING(val + 4); if(tagv.s!=NULL) { tagv.len = strlen(tagv.s); } if(reload_address_insert(atg, gid, &ips, mask, port, &tagv)<0) { goto dberror; } } perm_dbf.free_result(perm_db_handle, res); return 1; dberror: LM_ERR("database problem - invalid record\n"); perm_dbf.free_result(perm_db_handle, res); return -1; } ``` find this code check in kamailio -- Reply to this email directly or view it on GitHub: https://github.com/kamailio/kamailio/issues/3922#issuecomment-2232867802 You are receiving this because you are subscribed to this thread. Message ID: &lt;kamailio/kamailio/issues/3922/2232867802(a)github.com&gt;

Closed #3922 as completed. -- Reply to this email directly or view it on GitHub: https://github.com/kamailio/kamailio/issues/3922#event-13771914352 You are receiving this because you are subscribed to this thread. Message ID: &lt;kamailio/kamailio/issue/3922/issue_event/13771914352(a)github.com&gt;