[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.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
>
>