``` 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

Closed #3922 as completed.