/**
* libnl callback function. Does the real parsing of a record returned by NETLINK. This function
* parses LINK related packets
*
* @param obj Pointer to a struct nl_object response
* @param arg Pointer to a struct etherinfo element where the parse result will be saved
*/
static void callback_nl_link(struct nl_object *obj, void *arg)
{
struct etherinfo *ethi = (struct etherinfo *) arg;
struct rtnl_link *link = (struct rtnl_link *) obj;
struct nl_addr *addr = rtnl_link_get_addr(link);
unsigned int i, len;
unsigned char *binaddr;
char hwaddr[130], *ptr;
if( (ethi == NULL) || (ethi->hwaddress != NULL) || (addr == NULL) ) {
return;
}
binaddr = nl_addr_get_binary_addr(addr);
memset(&hwaddr, 0, 130);
len = 20;
ptr = (char *)&hwaddr;
for( i = 0; i < 6; i++ ) {
if( i == 0 ) {
snprintf(ptr, len, "%02X", *(binaddr+i));
len -= 2;
ptr += 2;
} else {
snprintf(ptr, len, ":%02X", *(binaddr+i));
len -= 3;
ptr += 3;
}
}
SET_STR_VALUE(ethi->hwaddress, hwaddr);
}
/**
* libnl callback function. Does the real parsing of a record returned by NETLINK. This function
* parses ADDRESS related packets
*
* @param obj Pointer to a struct nl_object response
* @param arg Pointer to a struct etherinfo element where the parse result will be saved
*/
static void callback_nl_address(struct nl_object *obj, void *arg)
{
struct etherinfo *ethi = (struct etherinfo *) arg;
struct nl_addr *addr;
char ip_str[66];
int family;
if( ethi == NULL ) {
return;
}
addr = rtnl_addr_get_local((struct rtnl_addr *)obj);
family = nl_addr_get_family(addr);
switch( family ) {
case AF_INET:
case AF_INET6:
memset(&ip_str, 0, 66);
inet_ntop(family, nl_addr_get_binary_addr(addr), (char *)&ip_str, 64);
if( family == AF_INET ) {
struct nl_addr *brdcst = rtnl_addr_get_broadcast((struct rtnl_addr *)obj);
char brdcst_str[66];
SET_STR_VALUE(ethi->ipv4_address, ip_str);
ethi->ipv4_netmask = rtnl_addr_get_prefixlen((struct rtnl_addr*) obj);
if( brdcst ) {
memset(&brdcst_str, 0, 66);
inet_ntop(family, nl_addr_get_binary_addr(brdcst), (char *)&brdcst_str, 64);
SET_STR_VALUE(ethi->ipv4_broadcast, brdcst_str);
}
} else {
ethi->ipv6_addresses = etherinfo_add_ipv6(ethi->ipv6_addresses,
ip_str,
rtnl_addr_get_prefixlen((struct rtnl_addr*) obj),
rtnl_addr_get_scope((struct rtnl_addr*) obj));
}
return;
default:
return;
}
}
static inline void set_final_update_cols(db_val_t *vals, struct dlg_cell *cell,
int on_shutdown)
{
str *s;
LM_DBG("DLG vals and profiles should %s[%x:%d]\n",
(db_flush_vp && (cell->flags & DLG_FLAG_VP_CHANGED)) ?
"be saved" : "not be saved", cell->flags, db_flush_vp);
if (on_shutdown || (db_flush_vp && (cell->flags & DLG_FLAG_VP_CHANGED))) {
if (cell->vals==NULL) {
VAL_NULL(vals) = 1;
} else {
s = write_dialog_vars( cell->vals );
if (s==NULL) {
VAL_NULL(vals) = 1;
} else {
SET_STR_VALUE(vals, *s);
}
}
if (cell->profile_links==NULL) {
VAL_NULL(vals+1) = 1;
} else {
s = write_dialog_profiles( cell->profile_links );
if (s==NULL) {
VAL_NULL(vals+1) = 1;
} else {
SET_STR_VALUE(vals+1, *s);
}
}
SET_INT_VALUE(vals+2, cell->user_flags);
} else {
VAL_NULL(vals) = 1;
VAL_NULL(vals+1) = 1;
SET_INT_VALUE(vals+2, 0);
}
}
/**
* Add a new IPv6 address record to a struct ipv6address chain
*
* @param addrptr Pointer to the current IPv6 address chain.
* @param addr IPv6 address, represented as char * string
* @param netmask IPv6 netmask, as returned by libnl rtnl_addr_get_prefixlen()
* @param scope IPV6 address scope, as returned by libnl rtnl_addr_get_scope()
*
* @return Returns a new pointer to the chain containing the new element
*/
struct ipv6address * etherinfo_add_ipv6(struct ipv6address *addrptr, const char *addr, int netmask, int scope) {
struct ipv6address *newaddr = NULL;
newaddr = calloc(1, sizeof(struct ipv6address)+2);
if( !newaddr ) {
fprintf(stderr, "** ERROR ** Could not allocate memory for a new IPv6 address record (%s/%i [%i])",
addr, netmask, scope);
return addrptr;
}
SET_STR_VALUE(newaddr->address, addr);
newaddr->netmask = netmask;
newaddr->scope = scope;
newaddr->next = addrptr;
return newaddr;
}
int db_delete_pcontact(pcontact_t* _c)
{
LM_DBG("Trying to delete contact: %.*s\n", _c->aor.len, _c->aor.s);
db_val_t values[1];
db_key_t match_keys[1] = { &aor_col};
VAL_TYPE(values) = DB1_STR;
VAL_NULL(values) = 0;
SET_STR_VALUE(values, _c->aor);
if (use_location_pcscf_table(_c->domain) < 0) {
LM_ERR("Error trying to use table %.*s\n", _c->domain->len, _c->domain->s);
return -1;
}
if(ul_dbf.delete(ul_dbh, match_keys, 0, values, 1) < 0) {
LM_ERR("Failed to delete database information: aor[%.*s], rx_session_id=[%.*s]\n",
_c->aor.len, _c->aor.s,
_c->rx_session_id.len, _c->rx_session_id.s);
return -1;
}
return 0;
}
int update_dialog_dbinfo(struct dlg_cell * cell)
{
static db_ps_t my_ps_insert = NULL;
static db_ps_t my_ps_update = NULL;
static db_ps_t my_ps_update_vp = NULL;
struct dlg_entry entry;
db_val_t values[DIALOG_TABLE_TOTAL_COL_NO];
int callee_leg;
db_key_t insert_keys[DIALOG_TABLE_TOTAL_COL_NO] = { &h_entry_column,
&h_id_column, &call_id_column, &from_uri_column,
&from_tag_column, &to_uri_column, &to_tag_column,
&from_sock_column, &to_sock_column,
&start_time_column, &mangled_fu_column, &mangled_tu_column,
&state_column, &timeout_column,
&from_cseq_column, &to_cseq_column, &from_ping_cseq_column,
&to_ping_cseq_column,&flags_column,
&vars_column, &profiles_column, &sflags_column,
&from_route_column,
&to_route_column, &from_contact_column,&to_contact_column};
if(use_dialog_table()!=0)
return -1;
callee_leg= callee_idx(cell);
if((cell->flags & DLG_FLAG_NEW) != 0){
/* save all the current dialogs information*/
VAL_TYPE(values) = VAL_TYPE(values+1) = VAL_TYPE(values+9) =
VAL_TYPE(values+12) = VAL_TYPE(values+13) = VAL_TYPE(values+16) =
VAL_TYPE(values+17) = VAL_TYPE(values+18) =
VAL_TYPE(values+21) = DB_INT;
VAL_TYPE(values+2) = VAL_TYPE(values+3) = VAL_TYPE(values+4) =
VAL_TYPE(values+5) = VAL_TYPE(values+6) = VAL_TYPE(values+7) =
VAL_TYPE(values+8) = VAL_TYPE(values+10) = VAL_TYPE(values+11) =
VAL_TYPE(values+14) = VAL_TYPE(values+15) =
VAL_TYPE(values+19) = VAL_TYPE(values+20) = VAL_TYPE(values+22) =
VAL_TYPE(values+23) = VAL_TYPE(values+24) =
VAL_TYPE(values+25) = DB_STR;
/* lock the entry */
entry = (d_table->entries)[cell->h_entry];
dlg_lock( d_table, &entry);
SET_INT_VALUE(values, cell->h_entry);
SET_INT_VALUE(values+1, cell->h_id);
SET_STR_VALUE(values+2, cell->callid);
SET_STR_VALUE(values+3, cell->from_uri);
SET_STR_VALUE(values+4, cell->legs[DLG_CALLER_LEG].tag);
SET_STR_VALUE(values+5, cell->to_uri);
SET_STR_VALUE(values+6, cell->legs[callee_leg].tag);
SET_STR_VALUE(values+7, cell->legs[DLG_CALLER_LEG].bind_addr->sock_str);
if (cell->legs[callee_leg].bind_addr) {
SET_STR_VALUE(values+8,
cell->legs[callee_leg].bind_addr->sock_str);
} else {
VAL_NULL(values+8) = 1;
}
SET_INT_VALUE(values+9, cell->start_ts);
SET_STR_VALUE(values+10,cell->legs[callee_leg].from_uri);
SET_STR_VALUE(values+11,cell->legs[callee_leg].to_uri);
SET_INT_VALUE(values+12, cell->state);
SET_INT_VALUE(values+13, (unsigned int)( (unsigned int)time(0) +
cell->tl.timeout - get_ticks()) );
SET_STR_VALUE(values+14, cell->legs[DLG_CALLER_LEG].r_cseq);
SET_STR_VALUE(values+15, cell->legs[callee_leg].r_cseq);
SET_INT_VALUE(values+16,cell->legs[DLG_CALLER_LEG].last_gen_cseq);
SET_INT_VALUE(values+17,cell->legs[callee_leg].last_gen_cseq);
SET_INT_VALUE(values+18, cell->flags & ~(DLG_FLAG_NEW|DLG_FLAG_CHANGED|DLG_FLAG_VP_CHANGED));
set_final_update_cols(values+19, cell, 0);
SET_STR_VALUE(values+22, cell->legs[DLG_CALLER_LEG].route_set);
SET_STR_VALUE(values+23, cell->legs[callee_leg].route_set);
SET_STR_VALUE(values+24, cell->legs[DLG_CALLER_LEG].contact);
SET_STR_VALUE(values+25, cell->legs[callee_leg].contact);
CON_PS_REFERENCE(dialog_db_handle) = &my_ps_insert;
if((dialog_dbf.insert(dialog_db_handle, insert_keys, values,
DIALOG_TABLE_TOTAL_COL_NO)) !=0){
LM_ERR("could not add another dialog to db\n");
goto error;
}
/* dialog saved */
run_dlg_callbacks( DLGCB_SAVED, cell, 0, DLG_DIR_NONE, 0);
cell->flags &= ~(DLG_FLAG_NEW|DLG_FLAG_CHANGED|DLG_FLAG_VP_CHANGED);
} else if((cell->flags & DLG_FLAG_CHANGED) != 0) {
/* save only dialog's state and timeout */
VAL_TYPE(values) = VAL_TYPE(values+1) =
VAL_TYPE(values+12) = VAL_TYPE(values+13) = VAL_TYPE(values+16) =
VAL_TYPE(values+17) = VAL_TYPE(values+18) =
VAL_TYPE(values+21) =DB_INT;
VAL_TYPE(values+14) = VAL_TYPE(values+15) =
VAL_TYPE(values+19) = VAL_TYPE(values+20) = DB_STR;
/* lock the entry */
entry = (d_table->entries)[cell->h_entry];
dlg_lock( d_table, &entry);
SET_INT_VALUE(values, cell->h_entry);
SET_INT_VALUE(values+1, cell->h_id);
SET_INT_VALUE(values+12, cell->state);
SET_INT_VALUE(values+13, (unsigned int)( (unsigned int)time(0) +
cell->tl.timeout - get_ticks()) );
SET_STR_VALUE(values+14, cell->legs[DLG_CALLER_LEG].r_cseq);
SET_STR_VALUE(values+15, cell->legs[callee_leg].r_cseq);
SET_INT_VALUE(values+16,cell->legs[DLG_CALLER_LEG].last_gen_cseq);
SET_INT_VALUE(values+17,cell->legs[callee_leg].last_gen_cseq);
SET_INT_VALUE(values+18, cell->flags);
set_final_update_cols(values+19, cell, 1);
CON_PS_REFERENCE(dialog_db_handle) = &my_ps_update;
if((dialog_dbf.update(dialog_db_handle, (insert_keys), 0,
(values), (insert_keys+12), (values+12), 2, 10)) !=0){
LM_ERR("could not update database info\n");
goto error;
}
/* dialog saved */
run_dlg_callbacks( DLGCB_SAVED, cell, 0, DLG_DIR_NONE, 0);
cell->flags &= ~(DLG_FLAG_CHANGED|DLG_FLAG_VP_CHANGED);
} else if (cell->flags & DLG_FLAG_VP_CHANGED) {
cell->flags |= DLG_FLAG_VP_CHANGED;
VAL_TYPE(values) = VAL_TYPE(values+1) = VAL_TYPE(values+21) = DB_INT;
VAL_TYPE(values+19) = VAL_TYPE(values+20) = DB_STR;
/* lock the entry */
entry = (d_table->entries)[cell->h_entry];
dlg_lock( d_table, &entry);
SET_INT_VALUE(values, cell->h_entry);
SET_INT_VALUE(values+1, cell->h_id);
set_final_update_cols(values+19, cell, 0);
CON_PS_REFERENCE(dialog_db_handle) = &my_ps_update_vp;
if((dialog_dbf.update(dialog_db_handle, (insert_keys), 0,
(values), (insert_keys+19), (values+19), 2, 3)) !=0){
LM_ERR("could not update database info\n");
goto error;
}
run_dlg_callbacks( DLGCB_SAVED, cell, 0, DLG_DIR_NONE, 0);
cell->flags &= ~DLG_FLAG_VP_CHANGED;
} else {
return 0;
}
dlg_unlock( d_table, &entry);
return 0;
error:
dlg_unlock( d_table, &entry);
return -1;
}
void dialog_update_db(unsigned int ticks, void * param)
{
static db_ps_t my_ps_update = NULL;
static db_ps_t my_ps_insert = NULL;
static db_ps_t my_ps_update_vp = NULL;
int index;
db_val_t values[DIALOG_TABLE_TOTAL_COL_NO];
struct dlg_entry entry;
struct dlg_cell * cell;
unsigned char on_shutdown;
int callee_leg,ins_done=0;
static query_list_t *ins_list = NULL;
db_key_t insert_keys[DIALOG_TABLE_TOTAL_COL_NO] = { &h_entry_column,
&h_id_column, &call_id_column, &from_uri_column,
&from_tag_column, &to_uri_column, &to_tag_column,
&from_sock_column, &to_sock_column, &start_time_column,
&from_route_column, &to_route_column, &from_contact_column,
&to_contact_column, &mangled_fu_column, &mangled_tu_column,
/*update chunk */
&state_column, &timeout_column, &from_cseq_column,
&to_cseq_column, &from_ping_cseq_column, &to_ping_cseq_column,
&vars_column, &profiles_column, &sflags_column, &flags_column};
if (dialog_db_handle==0 || use_dialog_table()!=0)
return;
on_shutdown = (ticks==0);
/*save the current dialogs information*/
VAL_TYPE(values) = VAL_TYPE(values+1) = VAL_TYPE(values+9) =
VAL_TYPE(values+16) = VAL_TYPE(values+17) = VAL_TYPE(values+20) =
VAL_TYPE(values+21) = VAL_TYPE(values+24) = VAL_TYPE(values+25)= DB_INT;
VAL_TYPE(values+2) = VAL_TYPE(values+3) = VAL_TYPE(values+4) =
VAL_TYPE(values+5) = VAL_TYPE(values+6) = VAL_TYPE(values+7) =
VAL_TYPE(values+8) = VAL_TYPE(values+10) = VAL_TYPE(values+11) =
VAL_TYPE(values+12) = VAL_TYPE(values+13) = VAL_TYPE(values+14) =
VAL_TYPE(values+15) = VAL_TYPE(values+18) = VAL_TYPE(values+19) =
VAL_TYPE(values+22) = VAL_TYPE(values+23) = DB_STR;
for(index = 0; index< d_table->size; index++){
/* lock the whole entry */
entry = (d_table->entries)[index];
dlg_lock( d_table, &entry);
for(cell = entry.first; cell != NULL; cell = cell->next){
callee_leg = callee_idx(cell);
if( (cell->flags & DLG_FLAG_NEW) != 0 ) {
if ( cell->state == DLG_STATE_DELETED ) {
/* don't need to insert dialogs already terminated */
continue;
}
LM_DBG("inserting new dialog %p\n",cell);
SET_INT_VALUE(values, cell->h_entry);
SET_INT_VALUE(values+1, cell->h_id);
SET_STR_VALUE(values+2, cell->callid);
SET_STR_VALUE(values+3, cell->from_uri);
SET_STR_VALUE(values+4, cell->legs[DLG_CALLER_LEG].tag);
SET_STR_VALUE(values+5, cell->to_uri);
SET_STR_VALUE(values+6, cell->legs[callee_leg].tag);
SET_STR_VALUE(values+7,
cell->legs[DLG_CALLER_LEG].bind_addr->sock_str);
if (cell->legs[callee_leg].bind_addr) {
SET_STR_VALUE(values+8,
cell->legs[callee_leg].bind_addr->sock_str);
} else {
VAL_NULL(values+8) = 1;
}
SET_INT_VALUE(values+9, cell->start_ts);
SET_STR_VALUE(values+10, cell->legs[DLG_CALLER_LEG].route_set);
SET_STR_VALUE(values+11,
cell->legs[callee_leg].route_set);
SET_STR_VALUE(values+12, cell->legs[DLG_CALLER_LEG].contact);
SET_STR_VALUE(values+13,
cell->legs[callee_leg].contact);
SET_STR_VALUE(values+14,cell->legs[callee_leg].from_uri);
SET_STR_VALUE(values+15,cell->legs[callee_leg].to_uri);
SET_INT_VALUE(values+16, cell->state);
SET_INT_VALUE(values+17, (unsigned int)((unsigned int)time(0)
+ cell->tl.timeout - get_ticks()) );
SET_STR_VALUE(values+18, cell->legs[DLG_CALLER_LEG].r_cseq);
SET_STR_VALUE(values+19, cell->legs[callee_leg].r_cseq);
SET_INT_VALUE(values+20, cell->legs[DLG_CALLER_LEG].last_gen_cseq);
SET_INT_VALUE(values+21, cell->legs[callee_leg].last_gen_cseq);
set_final_update_cols(values+22, cell, on_shutdown);
SET_INT_VALUE(values+25, cell->flags & ~(DLG_FLAG_NEW|DLG_FLAG_CHANGED|DLG_FLAG_VP_CHANGED));
CON_PS_REFERENCE(dialog_db_handle) = &my_ps_insert;
if (con_set_inslist(&dialog_dbf,dialog_db_handle,
&ins_list,insert_keys,DIALOG_TABLE_TOTAL_COL_NO) < 0 )
CON_RESET_INSLIST(dialog_db_handle);
if((dialog_dbf.insert(dialog_db_handle, insert_keys,
values, DIALOG_TABLE_TOTAL_COL_NO)) !=0){
LM_ERR("could not add another dialog to db\n");
goto error;
}
if (ins_done==0)
ins_done=1;
/* dialog saved */
run_dlg_callbacks( DLGCB_SAVED, cell, 0, DLG_DIR_NONE, 0);
cell->flags &= ~(DLG_FLAG_NEW |DLG_FLAG_CHANGED|DLG_FLAG_VP_CHANGED);
} else if ( (cell->flags & DLG_FLAG_CHANGED)!=0 || on_shutdown ){
LM_DBG("updating existing dialog %p\n",cell);
SET_INT_VALUE(values, cell->h_entry);
SET_INT_VALUE(values+1, cell->h_id);
SET_INT_VALUE(values+16, cell->state);
SET_INT_VALUE(values+17, (unsigned int)((unsigned int)time(0)
+ cell->tl.timeout - get_ticks()) );
SET_STR_VALUE(values+18, cell->legs[DLG_CALLER_LEG].r_cseq);
SET_STR_VALUE(values+19, cell->legs[callee_leg].r_cseq);
SET_INT_VALUE(values+20, cell->legs[DLG_CALLER_LEG].last_gen_cseq);
SET_INT_VALUE(values+21, cell->legs[callee_leg].last_gen_cseq);
set_final_update_cols(values+22, cell, 1);
SET_INT_VALUE(values+25, cell->flags);
CON_PS_REFERENCE(dialog_db_handle) = &my_ps_update;
if((dialog_dbf.update(dialog_db_handle, (insert_keys), 0,
(values), (insert_keys+16), (values+16), 2, 10)) !=0) {
LM_ERR("could not update database info\n");
goto error;
}
/* dialog saved */
run_dlg_callbacks( DLGCB_SAVED, cell, 0, DLG_DIR_NONE, 0);
cell->flags &= ~(DLG_FLAG_CHANGED|DLG_FLAG_VP_CHANGED);
} else if (cell->flags & DLG_FLAG_VP_CHANGED) {
SET_INT_VALUE(values, cell->h_entry);
SET_INT_VALUE(values+1, cell->h_id);
set_final_update_cols(values+22, cell, 0);
CON_PS_REFERENCE(dialog_db_handle) = &my_ps_update_vp;
if((dialog_dbf.update(dialog_db_handle, (insert_keys), 0,
(values), (insert_keys+22), (values+22), 2, 3)) !=0) {
LM_ERR("could not update database info\n");
goto error;
}
run_dlg_callbacks( DLGCB_SAVED, cell, 0, DLG_DIR_NONE, 0);
cell->flags &= ~DLG_FLAG_VP_CHANGED;
}
}
dlg_unlock( d_table, &entry);
}
if (ins_done) {
LM_DBG("dlg timer attempting to flush rows to DB\n");
/* flush everything to DB
* so that next-time timer fires
* we are sure that DB updates will be succesful */
if (ql_flush_rows(&dialog_dbf,dialog_db_handle,ins_list) < 0)
LM_ERR("failed to flush rows to DB\n");
}
return;
error:
dlg_unlock( d_table, &entry);
}
int db_insert_pcontact(struct pcontact* _c)
{
str empty_str = str_init("");
str impus, service_routes;
db_key_t keys[13] = {
&domain_col,
&aor_col, &contact_col,
&received_col,
&received_port_col, &received_proto_col,
&path_col, &rx_session_id_col,
®_state_col,
&expires_col, &service_routes_col,
&socket_col, &public_ids_col
};
db_val_t values[13];
VAL_TYPE(GET_FIELD_IDX(values, LP_DOMAIN_IDX)) = DB1_STR;
VAL_TYPE(GET_FIELD_IDX(values, LP_AOR_IDX)) = DB1_STR;
VAL_TYPE(GET_FIELD_IDX(values, LP_CONTACT_IDX)) = DB1_STR;
VAL_TYPE(GET_FIELD_IDX(values, LP_RECEIVED_IDX)) = DB1_STR;
VAL_TYPE(GET_FIELD_IDX(values, LP_RECEIVED_PORT_IDX)) = DB1_INT;
VAL_TYPE(GET_FIELD_IDX(values, LP_RECEIVED_PROTO_IDX)) = DB1_INT;
VAL_TYPE(GET_FIELD_IDX(values, LP_PATH_IDX)) = DB1_STR;
VAL_TYPE(GET_FIELD_IDX(values, LP_RX_SESSION_ID_IDX)) = DB1_STR;
VAL_TYPE(GET_FIELD_IDX(values, LP_REG_STATE_IDX)) = DB1_INT;
VAL_TYPE(GET_FIELD_IDX(values, LP_EXPIRES_IDX)) = DB1_DATETIME;
VAL_TYPE(GET_FIELD_IDX(values, LP_SERVICE_ROUTES_IDX)) = DB1_STR;
VAL_TYPE(GET_FIELD_IDX(values, LP_SOCKET_IDX)) = DB1_STR;
VAL_TYPE(GET_FIELD_IDX(values, LP_PUBLIC_IPS_IDX)) = DB1_STR;
SET_STR_VALUE(GET_FIELD_IDX(values, LP_DOMAIN_IDX), (*_c->domain));
SET_STR_VALUE(GET_FIELD_IDX(values, LP_AOR_IDX), _c->aor); //TODO: need to clean AOR
SET_STR_VALUE(GET_FIELD_IDX(values, LP_CONTACT_IDX), _c->aor);
SET_STR_VALUE(GET_FIELD_IDX(values, LP_RECEIVED_IDX), _c->received_host);
SET_PROPER_NULL_FLAG((*_c->domain), values, LP_DOMAIN_IDX);
SET_PROPER_NULL_FLAG(_c->aor, values, LP_AOR_IDX);
SET_PROPER_NULL_FLAG(_c->aor, values, LP_CONTACT_IDX);
SET_PROPER_NULL_FLAG(_c->received_host, values, LP_RECEIVED_IDX);
VAL_INT(GET_FIELD_IDX(values, LP_RECEIVED_PORT_IDX)) = _c->received_port;
VAL_INT(GET_FIELD_IDX(values, LP_RECEIVED_PROTO_IDX)) = _c->received_proto;
VAL_NULL(GET_FIELD_IDX(values, LP_RECEIVED_PORT_IDX)) = 0;
VAL_NULL(GET_FIELD_IDX(values, LP_RECEIVED_PROTO_IDX)) = 0;
SET_STR_VALUE(GET_FIELD_IDX(values, LP_PATH_IDX), _c->path);
SET_STR_VALUE(GET_FIELD_IDX(values, LP_RX_SESSION_ID_IDX), _c->rx_session_id);
SET_PROPER_NULL_FLAG(_c->path, values, LP_PATH_IDX);
SET_PROPER_NULL_FLAG(_c->rx_session_id, values, LP_RX_SESSION_ID_IDX);
VAL_DOUBLE(GET_FIELD_IDX(values, LP_REG_STATE_IDX)) = _c->reg_state;
VAL_TIME(GET_FIELD_IDX(values, LP_EXPIRES_IDX)) = _c->expires;
VAL_NULL(GET_FIELD_IDX(values, LP_REG_STATE_IDX)) = 0;
VAL_NULL(GET_FIELD_IDX(values, LP_EXPIRES_IDX)) = 0;
SET_STR_VALUE(GET_FIELD_IDX(values, LP_SERVICE_ROUTES_IDX), _c->service_routes?(*_c->service_routes):empty_str);
VAL_NULL(GET_FIELD_IDX(values, LP_SERVICE_ROUTES_IDX)) = 1;
SET_STR_VALUE(GET_FIELD_IDX(values, LP_SOCKET_IDX), _c->sock?_c->sock->sock_str:empty_str);
VAL_NULL(GET_FIELD_IDX(values, LP_SOCKET_IDX)) = 1;
if (_c->service_routes) {
SET_PROPER_NULL_FLAG((*_c->service_routes), values, LP_SERVICE_ROUTES_IDX);
}
else {
VAL_NULL(GET_FIELD_IDX(values, LP_SERVICE_ROUTES_IDX)) = 1;
}
if (_c->sock) {
SET_PROPER_NULL_FLAG(_c->sock->sock_str, values, LP_SOCKET_IDX);
} else {
VAL_NULL(GET_FIELD_IDX(values, LP_SOCKET_IDX)) = 1;
}
/* add the public identities */
impus.len = impus_as_string(_c, &impu_buffer);
impus.s = impu_buffer.buf;
SET_PROPER_NULL_FLAG(impus, values, LP_PUBLIC_IPS_IDX);
SET_STR_VALUE(GET_FIELD_IDX(values, LP_PUBLIC_IPS_IDX), impus);
/* add service routes */
service_routes.len = service_routes_as_string(_c, &service_route_buffer);
service_routes.s = service_route_buffer.buf;
SET_PROPER_NULL_FLAG(service_routes, values, LP_SERVICE_ROUTES_IDX);
SET_STR_VALUE(GET_FIELD_IDX(values, LP_SERVICE_ROUTES_IDX), service_routes);
if (use_location_pcscf_table(_c->domain) < 0) {
LM_ERR("Error trying to use table %.*s\n", _c->domain->len, _c->domain->s);
return -1;
}
if (ul_dbf.insert(ul_dbh, keys, values, 13) < 0) {
LM_ERR("inserting contact in db failed\n");
return -1;
}
return 0;
}
int db_update_pcontact(pcontact_t* _c)
{
str impus, service_routes;
db_val_t match_values[1];
db_key_t match_keys[1] = { &aor_col };
db_op_t op[1];
db_key_t update_keys[8] = { &expires_col, ®_state_col,
&service_routes_col, &received_col,
&received_port_col, &received_proto_col,
&rx_session_id_col, &public_ids_col };
db_val_t values[8];
LM_DBG("updating pcontact: %.*s\n", _c->aor.len, _c->aor.s);
VAL_TYPE(match_values) = DB1_STR;
VAL_NULL(match_values) = 0;
VAL_STR(match_values) = _c->aor;
op[0]=OP_EQ;
if (use_location_pcscf_table(_c->domain) < 0) {
LM_ERR("Error trying to use table %.*s\n", _c->domain->len, _c->domain->s);
return -1;
}
VAL_TYPE(values) = DB1_DATETIME;
VAL_TIME(values) = _c->expires;
VAL_NULL(values) = 0;
VAL_TYPE(values + 1)= DB1_INT;
VAL_NULL(values + 1)= 0;
VAL_INT(values + 1) = _c->reg_state;
str empty_str = str_init("");
if (_c->service_routes) {
service_routes.len = service_routes_as_string(_c, &service_route_buffer);
service_routes.s = service_route_buffer.buf;
}
SET_STR_VALUE(values + 2, (_c->service_routes)?service_routes:empty_str);
VAL_TYPE(values + 2) = DB1_STR;
VAL_NULL(values + 2) = 0;
SET_STR_VALUE(values + 3, _c->received_host);
VAL_TYPE(values + 3) = DB1_STR;
VAL_NULL(values + 3) = 0;
VAL_TYPE(values + 4)= DB1_INT;
VAL_NULL(values + 4)= 0;
VAL_INT(values + 4) = _c->received_port;
VAL_TYPE(values + 5)= DB1_INT;
VAL_NULL(values + 5)= 0;
VAL_INT(values + 5) = _c->received_proto;
VAL_TYPE(values + 6) = DB1_STR;
SET_PROPER_NULL_FLAG(_c->rx_session_id, values, 6);
LM_DBG("Trying to set rx session id: %.*s\n", _c->rx_session_id.len, _c->rx_session_id.s);
SET_STR_VALUE(values + 6, _c->rx_session_id);
/* add the public identities */
impus.len = impus_as_string(_c, &impu_buffer);
impus.s = impu_buffer.buf;
VAL_TYPE(values + 7) = DB1_STR;
SET_PROPER_NULL_FLAG(impus, values, 7);
SET_STR_VALUE(values + 7, impus);
if((ul_dbf.update(ul_dbh, match_keys, op, match_values, update_keys,values, 1, 8)) !=0){
LM_ERR("could not update database info\n");
return -1;
}
if (ul_dbf.affected_rows && ul_dbf.affected_rows(ul_dbh) == 0) {
LM_DBG("no existing rows for an update... doing insert\n");
if (db_insert_pcontact(_c) != 0) {
LM_ERR("Failed to insert a pcontact on update\n");
}
}
return 0;
}
