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