[OpenSIPS-Users] Dialog module - updating db

[Anca Vamanu]

Hi Anton,

Unfortunately, b2b does not work with dialog. The reason is that the 
dialog module was designed to work when OpenSIPS is used as a proxy, 
forwarding the requests, not as an endpoint, when it is used as a B2B. 
We do plan to work on integrating the two and make dialog module work 
also with b2b, but for the moment you have to rewrite the config.

Regards,

-- 
Anca Vamanu
OpenSIPS Developer



On 03/29/2011 03:07 PM, Антон Загорский wrote:
> 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