Re: [OpenSIPS-Users] Dialog module - updating db

[Vlad Paiu]

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_co
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_co
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
a.zagors...@oyster-telecom.ru
www.oyster-telecom.ru





_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

   



_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users