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

Anca-Maria Vamanu anca at voice-system.ro
Fri Apr 13 14:33:42 CEST 2007


Just about to do this.
Cesc wrote:

> Hi Anca,
>
> This fixes the problem of not-inserted subs in dbtext.
> Are you going to port this to trunk?
>
> Cesc
>
> On 4/13/07, Anca-Maria Vamanu <anca at voice-system.ro> wrote:
>
>> 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
>> >
>>
>>
>




More information about the Devel mailing list