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

[Cesc]

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