-----Original Message-----
From: [email protected] [mailto:users-
[email protected]] On Behalf Of Vlad Paiu
Sent: Tuesday, March 29, 2011 3:53 PM
To: [email protected]
Subject: Re: [OpenSIPS-Users] Dialog module - updating db
Hello,
The '?' sign is just a placeholder in the case of prepared statements.
When the query will be issued to the DB, all '?' signs will be replaced with the
appropriate values for the query.
The to_tag column in the dialog database is marked as NOT NULL because
dialogs are pushed to DB only after the 200 OK is received, so the To-Tag
value MUST have been learned by the dialog module. In your case though, it
seems that the To-Tag is empty, which is not valid from SIP point of view.
We saw a similar problem with someone who used b2b and dialog together.
Are you by any change using b2b too ?
Please try to capture the SIP traffic that triggers this OpenSIPS error in
saving
dialog info to the DB back-end and check if the To-Tag is present in 200 OK
replies for the initial INVITE.
Regards,
--
Vlad Paiu
OpenSIPS Developer
On 03/29/2011 02:17 PM, Антон Загорский wrote:
Hello.
Sometimes I see in a log following lines:
[89566]: DBG:dialog:dialog_update_db: inserting new dialog 0x80417c568
[89566]: DBG:db_mysql:db_mysql_do_prepared_query: conn=0x731538
(tail=7530824) MC=0x72e9a8
[89566]: DBG:db_mysql:db_mysql_do_prepared_query: new
query=|insert into
dialog
(hash_entry,hash_id,callid,from_uri,from_tag,to_uri,to_tag,caller_sock,calle
e_sock,start_time,caller_route_set,callee_route_set,caller_contact,callee_c
o
ntact,state,timeout,caller_cseq,callee_cseq,vars,profiles,script_flags )
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)|
[89566]: INFO:db_mysql:re_init_statement: query is<insert into dialog
(hash_entry,hash_id,callid,from_uri,from_tag,to_uri,to_tag,caller_sock,calle
e_sock,start_time,caller_route_set,callee_route_set,caller_contact,callee_c
o
ntact,state,timeout,caller_cseq,callee_cseq,vars,profiles,script_flags )
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)>, ptr=0x0
[89566]: DBG:db_mysql:db_mysql_do_prepared_query: new
statement(0x7317c8) on
connection: (0x731538) 0x72e948
And that causes
[89566]: CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver
error
(1048): Column 'to_tag' cannot be null
[89566]: ERROR:dialog:dialog_update_db: could not add another dialog to
db
How can all values be '?' ?
WBR, Anton Zagorskiy
VoIP Developer, Oyster Telecom
Phone.: +7 812 601-0666
Fax: +7 812 601-0593
[email protected]
www.oyster-telecom.ru
