Hi Vlad, Yes, I'm using dialog module with B2B top hiding scenario. In case of such problem, should I rewrite config to avoid using them together? This will not be easy...
Also, in a MySQL log I see exactly that requests with '?'... 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 > -----Original Message----- > From: users-boun...@lists.opensips.org [mailto:users- > boun...@lists.opensips.org] On Behalf Of Vlad Paiu > Sent: Tuesday, March 29, 2011 3:53 PM > To: users@lists.opensips.org > 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 > > 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 _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users