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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]>
> 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:[EMAIL PROTECTED]
> 4(5244) DEBUG: get_hdr_field: <To> [25]; uri=[sip:[EMAIL PROTECTED]
> 4(5244) DEBUG: to body [<sip:[EMAIL PROTECTED]>
> ]
> 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:[EMAIL PROTECTED]
> 4(5244) New Message received: [4] from [sip:[EMAIL PROTECTED]
> 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:[EMAIL PROTECTED]>
> 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:[EMAIL PROTECTED]: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
> [EMAIL PROTECTED]
> http://openser.org/cgi-bin/mailman/listinfo/devel
>
_______________________________________________
Devel mailing list
[EMAIL PROTECTED]
http://openser.org/cgi-bin/mailman/listinfo/devel
