<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Hi Husnain,<br>
<br>
The db_text driver is flushing to file only at shutdown or upon
dbt_dump MI command. Otherwise, the data is cached in memory.<br>
<br>
Best regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 22.09.2016 20:50, Husnain Taseer
wrote:<br>
</div>
<blockquote
cite="mid:CALkA4hJXvOJD12acuOOAAR66ha_y35RfOtnP5ijwh27rOgbiPg@mail.gmail.com"
type="cite">
<div dir="ltr">Dear Users,<br>
I am using opensips 2.2.1 on debian server. dialog table is
configured with dbtext to store information, but there is no
information populated by opensips in dialog file. I have tried
almost all the combination of db_mode for dialog and dbtext
module but no luck. My current configuration for dbtext and
dialog module is:<br>
<br>
<br>
<div>loadmodule "db_text.so"</div>
<div>modparam("db_text", "db_mode",1)</div>
<br>
<div>loadmodule "dialog.so"</div>
<div>modparam("dialog", "db_mode", 1)</div>
<div>modparam("dialog", "dlg_match_mode", 1)</div>
<div>modparam("dialog", "default_timeout", 3600)</div>
<div>modparam("dialog", "profiles_with_value", "caller ;
callee")</div>
<div>modparam("dialog", "profiles_no_value", "inbound ;
outbound")</div>
<div>modparam("dialog", "db_update_period", 10)</div>
<div>modparam("dialog", "db_url", "text:///usr/local/v2Term/etc/<wbr>opensips/dbtext")</div>
<div><br>
</div>
<div>When I make call I can see that dialog has been created
which can be shown using "dlg_list"</div>
<div><i><br>
</i>
<div><i>dialog:: hash=1396:<a moz-do-not-send="true"
title="Click-to-Call 1435064472">1435064472</a></i></div>
<div><i> state:: 4</i></div>
<div><i> user_flags:: 0</i></div>
<div><i> timestart:: <a moz-do-not-send="true"
title="Click-to-Call 1474564499">1474564499</a></i></div>
<div><i> datestart:: 2016-09-22 13:14:59</i></div>
<div><i> timeout:: <a moz-do-not-send="true"
title="Click-to-Call 1474571700">1474571700</a></i></div>
<div><i> dateout:: 2016-09-22 15:15:00</i></div>
<div><i> callid:: MDkxZTdlZjRiN2ZkNzQ0NzcxZjU4N2<wbr>U4NTZmNTZmYzc.</i></div>
<div><i> from_uri:: <a class="moz-txt-link-abbreviated" href="mailto:sip:1404xxxxx@xx.xx.xx.xx">sip:1404xxxxx@xx.xx.xx.xx</a></i></div>
<div><i> to_uri:: <a class="moz-txt-link-abbreviated" href="mailto:sip:8977xxxxx@xx.xx">sip:8977xxxxx@xx.xx</a>.<wbr>xx.xx</i></div>
<div><i> caller_tag:: 2d682d42</i></div>
<div><i> caller_contact:: <a class="moz-txt-link-abbreviated" href="mailto:sip:1404xxxxxx@xx.xx.xx:38756">sip:1404xxxxxx@xx.xx.xx:38756</a></i></div>
<div><i> callee_cseq:: 0</i></div>
<div><i> caller_route_set::</i></div>
<div><i> caller_bind_addr:: udp:xx.xx.xx.xx<a
moz-do-not-send="true" href="http://216.55.177.129:5060"
target="_blank">:5060</a></i></div>
<div><i> caller_sdp::</i></div>
<div><i> CALLEES::</i></div>
<div><i> callee::</i></div>
<div><i> callee_tag:: 15830SIPpTag0110</i></div>
<div><i> callee_contact::
<a class="moz-txt-link-abbreviated" href="mailto:sip:8977xxxxxx@xx.xx.xx.xx:5067;transport=UDP">sip:8977xxxxxx@xx.xx.xx.xx:5067;transport=UDP</a></i></div>
<div><i> caller_cseq:: 1</i></div>
<div><i> callee_route_set::</i></div>
<div><i> callee_bind_addr::
udp:xx.xx.xx.xx<a moz-do-not-send="true"
href="http://216.55.177.129:5060" target="_blank">:5060</a></i></div>
<div><i> callee_sdp::</i></div>
</div>
<div><br>
</div>
<div>But during this ongoing session there isn't any thing in
the dialog file except heading and also the last change time
of that file is of yesterday when it was created. Here are the
debug logs related to dialog when call comes on opensips.<br>
<br>
<br>
<div><i>Sep 22 13:14:59 localhost ./opensips[6258]:
DBG:dialog:w_create_dialog2: bye on timeout activated</i></div>
<div><i>Sep 22 13:14:59 localhost ./opensips[6258]:
DBG:dialog:build_new_dlg: new dialog 0x7ff790731ab0
(c=MDkxZTdlZjRiN2ZkNzQ0NzcxZjU4N2U4NTZmNTZmYzc.,<a class="moz-txt-link-abbreviated" href="mailto:f=sip:1404xxxxx@xx.xx.xx.xx,t=sip:8977xxxxx@xx.xx.xx.xx,ft=2d682d42">f=sip:1404xxxxx@xx.xx.xx.xx,t=sip:8977xxxxx@xx.xx.xx.xx,ft=2d682d42</a>)
on hash 1396</i></div>
<div><i>Sep 22 13:14:59 localhost ./opensips[6258]:
DBG:dialog:init_leg_info: route_set , contact
<a class="moz-txt-link-abbreviated" href="mailto:sip:1404xxxxx@xx.xx.xx.xx:38756">sip:1404xxxxx@xx.xx.xx.xx:38756</a>, cseq 1 and bind_addr
udp:xx.xx.xx.xx:5060</i></div>
<div><i>Sep 22 13:14:59 localhost ./opensips[6258]:
DBG:dialog:dlg_add_leg_info: set leg 0 for 0x7ff790731ab0:
tag=<2d682d42> rcseq=<0></i></div>
<div><i>Sep 22 13:14:59 localhost ./opensips[6258]:
DBG:dialog:link_dlg: ref dlg 0x7ff790731ab0 with 3 -> 3
in h_entry 0x7ff7906f1280 - 1396</i></div>
<div><i>Sep 22 13:14:59 localhost ./opensips[6258]:
DBG:dialog:link_dlg_profile: Entered here with hash = 10</i></div>
<div><i>Sep 22 13:14:59 localhost ./opensips[6258]:
DBG:dialog:dlg_onreq: t hash_index = 17835, t label =
1923053288</i></div>
<div><i>Sep 22 13:14:59 localhost ./opensips[6258]:
DBG:dialog:unref_dlg: unref dlg 0x7ff790731ab0 with 1
-> 2 in entry 0x7ff7906f1280</i></div>
<div><i>Sep 22 13:14:59 localhost ./opensips[6257]:
DBG:dialog:push_reply_in_dialog: 0x7ff790731ab0 totag in
rpl is <15830SIPpTag0110> (16)</i></div>
<div><i>Sep 22 13:14:59 localhost ./opensips[6257]:
DBG:dialog:push_reply_in_dialog: new branch with tag
<15830SIPpTag0110></i></div>
<div><i>Sep 22 13:14:59 localhost ./opensips[6257]:
DBG:dialog:init_leg_info: route_set , contact , cseq 1 and
bind_addr udp:xx.xx.xx.xx:5060</i></div>
<div><i>Sep 22 13:14:59 localhost ./opensips[6257]:
DBG:dialog:dlg_add_leg_info: set leg 1 for 0x7ff790731ab0:
tag=<15830SIPpTag0110> rcseq=<1></i></div>
<div><i>Sep 22 13:14:59 localhost ./opensips[6257]:
DBG:dialog:push_reply_in_dialog: Skipping 1 ,0, 0, 1</i></div>
<div><i>Sep 22 13:14:59 localhost ./opensips[6257]:
DBG:dialog:dlg_update_routing: dialog 0x7ff790731ab0[1]:
rr=<>
contact=<a class="moz-txt-link-rfc2396E" href="mailto:sip:8977xxxx@xx.xx.xx.xx:5067;transport=UDP"><sip:8977xxxx@xx.xx.xx.xx:5067;transport=UDP></a></i></div>
<div><i>Sep 22 13:14:59 localhost ./opensips[6257]:
DBG:dialog:next_state_dlg: dialog 0x7ff790731ab0 changed
from state 1 to state 3, due event 3</i></div>
<div><i>Sep 22 13:14:59 localhost ./opensips[6257]:
DBG:dialog:dlg_onreply: dialog 0x7ff790731ab0 confirmed</i></div>
<div><i>Sep 22 13:14:59 localhost ./opensips[6257]:
DBG:dialog:insert_dlg_timer_unsafe: inserting
0x7ff790731af8 for 7883</i></div>
<div><i>Sep 22 13:14:59 localhost ./opensips[6257]:
DBG:dialog:ref_dlg: ref dlg 0x7ff790731ab0 with 1 -> 3</i></div>
<div><i>Sep 22 13:14:59 localhost ./opensips[6257]:
DBG:dialog:set_final_update_cols: DLG vals and profiles
should not be saved[11b:0]</i></div>
<div><i>Sep 22 13:14:59 localhost ./opensips[6257]:
DBG:db_text:dbt_db_get_table: cache or mtime succeeded for
[dialog]</i></div>
<div><i>Sep 22 13:14:59 localhost ./opensips[6257]:
DBG:dialog:run_dlg_callbacks: dialog=0x7ff790731ab0,
type=8</i></div>
<div><i>Sep 22 13:15:00 localhost ./opensips[6257]:
DBG:dialog:push_reply_in_dialog: 0x7ff790731ab0 totag in
rpl is <15830SIPpTag0110> (16)</i></div>
<div><i>Sep 22 13:15:00 localhost ./opensips[6257]:
DBG:dialog:push_reply_in_dialog: branch with tag
<15830SIPpTag0110> already exists</i></div>
<div><i>Sep 22 13:15:00 localhost ./opensips[6263]:
DBG:dialog:dlg_onroute: route param is '475.89859855'
(len=12)</i></div>
<div><i>Sep 22 13:15:00 localhost ./opensips[6263]:
DBG:dialog:lookup_dlg: ref dlg 0x7ff790731ab0 with 1 ->
4</i></div>
<div><i>Sep 22 13:15:00 localhost ./opensips[6263]:
DBG:dialog:lookup_dlg: dialog id=1435064472 found on entry
1396</i></div>
<div><i>Sep 22 13:15:00 localhost ./opensips[6263]:
DBG:dialog:next_state_dlg: dialog 0x7ff790731ab0 changed
from state 3 to state 4, due event 6</i></div>
<div><i>Sep 22 13:15:00 localhost ./opensips[6263]:
DBG:dialog:dlg_onroute: sequential request successfully
processed (dst_leg=1)</i></div>
<div><i>Sep 22 13:15:00 localhost ./opensips[6263]:
DBG:dialog:dlg_onroute: dialog_timeout: 7200</i></div>
<div><i>Sep 22 13:15:00 localhost ./opensips[6263]:
DBG:dialog:set_final_update_cols: DLG vals and profiles
should not be saved[1a:0]</i></div>
<div><i>Sep 22 13:15:00 localhost ./opensips[6263]:
DBG:dialog:write_dialog_profiles: profile string is
<caller#xx.xx.xx.xx|>(20)</i></div>
<div><i>Sep 22 13:15:00 localhost ./opensips[6263]:
DBG:db_text:dbt_db_get_table: cache or mtime succeeded for
[dialog]</i></div>
<div><i>Sep 22 13:15:00 localhost ./opensips[6263]:
DBG:dialog:unref_dlg: unref dlg 0x7ff790731ab0 with 1
-> 3 in entry 0x7ff7906f1280</i></div>
<div><i>Sep 22 13:15:01 localhost ./opensips[6263]:
DBG:dialog:dlg_onroute: route param is '475.89859855'
(len=12)</i></div>
<div><i>Sep 22 13:15:01 localhost ./opensips[6263]:
DBG:dialog:lookup_dlg: ref dlg 0x7ff790731ab0 with 1 ->
4</i></div>
<div><i>Sep 22 13:15:01 localhost ./opensips[6263]:
DBG:dialog:lookup_dlg: dialog id=1435064472 found on entry
1396</i></div>
<div><i>Sep 22 13:15:01 localhost ./opensips[6263]:
DBG:dialog:next_state_dlg: dialog 0x7ff790731ab0 changed
from state 4 to state 4, due event 6</i></div>
<div><i>Sep 22 13:15:01 localhost ./opensips[6263]:
DBG:dialog:dlg_onroute: sequential request successfully
processed (dst_leg=1)</i></div>
<div><i>Sep 22 13:15:01 localhost ./opensips[6263]:
DBG:dialog:dlg_onroute: dialog_timeout: 7200</i></div>
<div><i>Sep 22 13:15:01 localhost ./opensips[6263]:
DBG:dialog:unref_dlg: unref dlg 0x7ff790731ab0 with 1
-> 3 in entry 0x7ff7906f1280</i></div>
<div><i>Sep 22 13:15:01 localhost ./opensips[6263]:
DBG:dialog:unref_dlg: unref dlg 0x7ff7907325b0 with 1
-> 0 in entry 0x7ff7906e7a00</i></div>
<div><i>Sep 22 13:15:01 localhost ./opensips[6263]:
DBG:dialog:unref_dlg: ref <=0 for dialog 0x7ff7907325b0</i></div>
<div><i>Sep 22 13:15:01 localhost ./opensips[6263]:
DBG:dialog:destroy_dlg: destroying dialog 0x7ff7907325b0</i></div>
<div><i>Sep 22 13:15:01 localhost ./opensips[6263]:
DBG:dialog:destroy_dlg: dlg expired or not in list - dlg
0x7ff7907325b0 [176:7110971] with clid
'NTY2YzcxMmQ0MGFiZmYwMzkxOWU2NjIyZWU3YzUyYWI.' and tags
'72028e07' '15830SIPpTag019'</i></div>
<div><i>Sep 22 13:15:01 localhost ./opensips[6263]:
DBG:dialog:run_dlg_callbacks: dialog=0x7ff7907325b0,
type=2048</i></div>
<div><i>Sep 22 13:15:05 localhost ./opensips[6263]:
DBG:dialog:next_state_dlg: unref dlg 0x7ff790731ab0 with 1
-> 2 in entry 0x7ff7906f1280</i></div>
<div><i>Sep 22 13:15:05 localhost ./opensips[6263]:
DBG:dialog:next_state_dlg: dialog 0x7ff790731ab0 changed
from state 4 to state 4, due event 1</i></div>
<div><br>
</div>
<br>
<br>
Also please note that I am using different database backends
in same cfg like for dispatcher module DBMYSQL, for dialog,
usrloc DBTEXT and for acc DBFLATSTORE.<br>
<br>
Regards,<br>
Husnain Taseer<br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>