[OpenSIPS-Users] Dialog module - updating db

[Антон Загорский]

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.zagorskiy at oyster-telecom.ru
www.oyster-telecom.ru



> -----Original Message-----
> From: users-bounces at lists.opensips.org [mailto:users-
> bounces at lists.opensips.org] On Behalf Of Vlad Paiu
> Sent: Tuesday, March 29, 2011 3:53 PM
> To: users at 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.zagorskiy at oyster-telecom.ru
> > www.oyster-telecom.ru
> >
> >
> >
> >
> >
> > _______________________________________________
> > Users mailing list
> > Users at lists.opensips.org
> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
> >
> 
> 
> 
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users