[Devel] openser1.2 with dbtext ... NULL value in subscription insert?

[Anca-Maria Vamanu]

Hello,

I found a possible source of the error in this case and commited the 
change. Hope it solves it.

regards,

Anca Vamanu

Cesc wrote:

> Hi,
>
> same setup ... 1.2 and dbtext ... xlite 3.0 ...
> dbtext reports a NULL value and refuses to subscribe ... it simply
> drops the message, it does not even send a reply back with an error
> ...
>
> Cesc
>
> 4(5244) SIP Request:
> 4(5244)  method:  <SUBSCRIBE>
> 4(5244)  uri:     <sip:Chelsea at cafes.org>
> 4(5244)  version: <SIP/2.0>
> 4(5244) parse_headers: flags=2
> 4(5244) Found param type 232, <branch> = <z9hG4bKe9df.e54f8592.0>; 
> state=16
> 4(5244) end of header reached, state=5
> 4(5244) parse_headers: Via found, flags=2
> 4(5244) parse_headers: this is the first via
> 4(5244) After parse_msg...
> 4(5244) preparing to run routing scripts...
> 4(5244) parse_headers: flags=100
> 4(5244) Found param type 232, <branch> =
> <z9hG4bK-d87543-4e78752d5371433f-1--d87543->; state=6
> 4(5244) Found param type 235, <rport> = <62414>; state=16
> 4(5244) end of header reached, state=5
> 4(5244) parse_headers: Via found, flags=100
> 4(5244) parse_headers: this is the second via
> 4(5244) DEBUG:maxfwd:is_maxfwd_present: value = 16
> 4(5244) 
> ============================================================================================== 
>
> 4(5244) parse_headers: flags=10
> 4(5244) DEBUG:parse_to:end of header reached, state=10
> 4(5244) DBUG:parse_to: display={}, ruri={sip:Chelsea at cafes.org}
> 4(5244) DEBUG: get_hdr_field: <To> [25]; uri=[sip:Chelsea at cafes.org]
> 4(5244) DEBUG: to body [<sip:Chelsea at cafes.org>
> ]
> 4(5244) DEBUG: add_param: tag=1318b802
> 4(5244) DEBUG:parse_to:end of header reached, state=29
> 4(5244) DBUG:parse_to: display={"X-Lite user 2"}, 
> ruri={sip:Chelsea at cafes.org}
> 4(5244) New Message received: [4] from [sip:Chelsea at cafes.org]
> 4(5244) Request method used:[SUBSCRIBE].
> 4(5244) 
> ============================================================================================= 
>
> 4(5244) DEBUG: t_newtran:  T on entrance=0xffffffff
> 4(5244) parse_headers: flags=ffffffffffffffff
> 4(5244) get_hdr_field: cseq <CSeq>: <1> <SUBSCRIBE>
> 4(5244) DEBUG: get_hdr_body : content_length=0
> 4(5244) found end of header
> 4(5244) parse_headers: flags=78
> 4(5244) t_lookup_request: start searching: hash=64926, isACK=0
> 4(5244) DEBUG: RFC3261 transaction matching failed
> 4(5244) DEBUG: t_lookup_request: no transaction found
> 4(5244) 
> ============================================================================================= 
>
> 4(5244) The request method used is to [SUBSCRIBE] information.
> (handle subscribe)
> 4(5244) 
> ============================================================================================= 
>
> 4(5244) parse_headers: flags=ffffffffffffffff
> 4(5244) PRESENCE: handle_subscribe: 'expires' found
> 4(5244) PRESENCE: handle_subscribe: lexpire= 3600
> 4(5244) PRESENCE: handle_subscribe: 'To' header ALREADY PARSED:
> <sip:Chelsea at cafes.org>
> 4(5244) PRESENCE:handle_subscribe: generating to_tag
> 4(5244) PRESENCE :proces_rr: out rr 
> [<sip:192.168.1.150;ftag=1318b802;lr=on>]
> 4(5244)
>        [p_user]= Chelsea  [p_domain]= cafes.org
>        [w_user]= Chelsea [w_domain]= cafes.org
> 4(5244) [event]= presence.winfo
>        [staus]= active
>        [expires]= 3600
> 4(5244) [to_tag]= 10.5244.1175412396.4
>        [from_tag]= 1318b802
> 4(5244) PRESENCE: update_subscription ...
> 4(5244)
>        [p_user]= Chelsea  [p_domain]= cafes.org
>        [w_user]= Chelsea [w_domain]= cafes.org
> 4(5244) [event]= presence.winfo
>        [staus]= active
>        [expires]= 3600
> 4(5244) [to_tag]= 10.5244.1175412396.4
>        [from_tag]= 1318b802
> 4(5244) expires: 3600
> 4(5244) PRESENCE:update_subscription:Inserting into database:
> n_query_cols:14
> 4(5244) [0] = to_user Chelsea
> 4(5244) [1] = to_domain cafes.org
> 4(5244) [2] = from_user Chelsea
> 4(5244) [3] = from_domain cafes.org
> 4(5244) [4] = event presence.winfo
> 4(5244) [5] = event_id
> 4(5244) [6] = callid OTgxN2RhYjY1ZTZjY2VhZWI3ZmIwODgyMjNhYmY2Mjc.
> 4(5244) [7] = to_tag 10.5244.1175412396.4
> 4(5244) [8] = from_tag 1318b802
> 4(5244) [9] = contact sip:Chelsea at 192.168.1.178:62414
> 4(5244) [10] = status active
> 4(5244) [11] = cseq 1
> 4(5244) DBT:dbt_table_check_row: NULL value not allowed - field 15
> 4(5244) DBT:db_insert: cannot insert the new row!!
> 4(5244) DBT:db_insert: make clean!
> 4(5244) PRESENCE:update_subscription: ERROR while storing new 
> subscription
> 4(5244) PRESENCE:update_presentity: ERROR occured
> 4(5244) PRESENCE:handle_subscribe: ERROR while updating database
> 4(5244) PRESENCE:handle_subscribe: ERROR occured
> 4(5244) DEBUG: cleanup_uac_timers: RETR/FR timers reset
> 4(5244) DEBUG: add_to_tail_of_timer[2]: 0xb5dc0900 (97)
> 4(5244) DEBUG:tm:UNREF_UNSAFE: after is 0
> 4(5244) DEBUG:destroy_avp_list: destroying list (nil)
> 4(5244) receive_msg: cleaning up
>
> _______________________________________________
> Devel mailing list
> Devel at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/devel
>