<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p><font size="-1">Hi,</font></p>
<p><font size="-1">I think could be very useful replicate acc and
acc_cdrs data via DMQ.</font></p>
<p><font size="-1">Regards<br>
</font></p>
<pre class="moz-signature" cols="72">---
I'm SoCIaL, MayBe</pre>
<div class="moz-cite-prefix">El 19/07/2021 a las 9:25 a. m., Henning
Westerholt escribió:<br>
</div>
<blockquote type="cite"
cite="mid:PAXPR05MB85580E504C531FC4A3E29621C5E19@PAXPR05MB8558.eurprd05.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style>@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}pre
{mso-style-priority:99;
mso-style-link:"HTML Vorformatiert Zchn";
margin:0cm;
font-size:10.0pt;
font-family:"Courier New";}span.HTMLVorformatiertZchn
{mso-style-name:"HTML Vorformatiert Zchn";
mso-style-priority:99;
mso-style-link:"HTML Vorformatiert";
font-family:Consolas;}span.E-MailFormatvorlage21
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}div.WordSection1
{page:WordSection1;}</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Hello,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"
lang="EN-GB">so, you are saying that in a DMQ replicated
case the acc CDR generation is not working in failover
cases.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"
lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"
lang="EN-GB">I just looked briefly to the code; others might
have more details.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"
lang="EN-GB">But I think this is because the acc module do
not register to a callback function for dialog loading on
startup for the DMQ replication. This is done for DB
loading, but seems to be not implemented yet for DMQ
synchronisation.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"
lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"
lang="EN-GB">You could open a feature request on our github
tracker for this.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"
lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"
lang="EN-GB">Cheers,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"
lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"
lang="EN-GB">Henning<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"
lang="EN-GB"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"
lang="EN-GB">-- <o:p>
</o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"
lang="EN-GB">Henning Westerholt –
</span><span style="mso-fareast-language:EN-US"><a
href="https://skalatan.de/blog/" moz-do-not-send="true"><span
style="color:#0563C1" lang="EN-GB">https://skalatan.de/blog/</span></a></span><span
style="mso-fareast-language:EN-US" lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"
lang="EN-GB">Kamailio services –
</span><span style="mso-fareast-language:EN-US"><a
href="https://gilawa.com/" moz-do-not-send="true"><span
style="color:#0563C1" lang="EN-GB">https://gilawa.com</span></a></span><span
style="mso-fareast-language:EN-US">
<span lang="EN-GB"><o:p></o:p></span></span></p>
</div>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"
lang="EN-GB"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="margin-left:35.4pt"><b>From:</b>
sr-users <a class="moz-txt-link-rfc2396E" href="mailto:sr-users-bounces@lists.kamailio.org"><sr-users-bounces@lists.kamailio.org></a>
<b>On Behalf Of </b>Social Boh<br>
<b>Sent:</b> Monday, July 19, 2021 1:58 PM<br>
<b>To:</b> Kamailio (SER) - Users Mailing List
<a class="moz-txt-link-rfc2396E" href="mailto:sr-users@lists.kamailio.org"><sr-users@lists.kamailio.org></a><br>
<b>Subject:</b> Re: [SR-Users] Kamailio KeepAlived HA
acc_cdrs table record<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
<p style="margin-left:35.4pt">Hi,<o:p></o:p></p>
<p style="margin-left:35.4pt">I'm using 5.4.6<o:p></o:p></p>
<p style="margin-left:35.4pt">I switch off Kamailio on the first
server and keepalived move the virtual IP on the second server
so First Kamailio is off. This during the call.<o:p></o:p></p>
<p style="margin-left:35.4pt">Before switch off Kamailio and
during the call I can see data dialog on both server but in
the LOG /var/log/messages in my case:<o:p></o:p></p>
<p style="margin-left:35.4pt">server 1 INVITE<o:p></o:p></p>
<p style="margin-left:35.4pt">server 2 BYE<o:p></o:p></p>
<p style="margin-left:35.4pt">acc_cdrs table empty on both
servers.<o:p></o:p></p>
<p style="margin-left:35.4pt">acc table first server INVITE; acc
table second server BYE<o:p></o:p></p>
<p style="margin-left:35.4pt">Regards<o:p></o:p></p>
<pre style="margin-left:35.4pt">---<o:p></o:p></pre>
<pre style="margin-left:35.4pt">I'm SoCIaL, MayBe<o:p></o:p></pre>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">El 18/07/2021
a las 2:33 p. m., M Arqum CH escribió:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Hi
SoCIal, <br>
<br>
which Kamailio version you are using. <o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">did you
able to get the dialog information using the dialog
command.
<a
href="https://www.kamailio.org/docs/modules/devel/modules/dialog.html#dlg.r.dlg_list"
target="_blank" moz-do-not-send="true">
https://www.kamailio.org/docs/modules/devel/modules/dialog.html#dlg.r.dlg_list</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">when you
received bye on secondary server, is that server
recognized the bye.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:35.4pt"> <o:p></o:p></p>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">On Sun,
Jul 18, 2021 at 3:38 AM Social Boh <<a
href="mailto:social@bohboh.info" target="_blank"
moz-do-not-send="true">social@bohboh.info</a>>
wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC
1.0pt;padding:0cm 0cm 0cm
6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<p style="margin-left:35.4pt">Hello,<o:p></o:p></p>
<p style="margin-left:35.4pt">if during a call I stop
Primary Kamailio the Secondary Kamailio take de
Virtual IP but don't save call data:<o:p></o:p></p>
<p style="margin-left:35.4pt">In the Primary database,
acc table, I have INVITE data but not BYE data; no
data in acc_cdrs for the call. In the Secondary
Kamailio, acc table, I have BYE data but not INVITE
data.<o:p></o:p></p>
<p style="margin-left:35.4pt">in the file LOG no data
about call cdr.<o:p></o:p></p>
<p style="margin-left:35.4pt">Maybe a solution is write
call data whene the call end?<o:p></o:p></p>
<p style="margin-left:35.4pt">Regards<o:p></o:p></p>
<pre style="margin-left:35.4pt">---<o:p></o:p></pre>
<pre style="margin-left:35.4pt">I'm SoCIaL, MayBe<o:p></o:p></pre>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">El
17/07/2021 a las 11:34 a. m., M Arqum CH escribió:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Make
sure that your table columns matched the field's
you are trying to insert, please check the
syslog for acc module log, acc module print the
cdr in log facility too, if acc module facing
any issue while writing cdr in db, it will throw
error in logs.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:35.4pt">Hope
this will help you.<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal"
style="margin-left:35.4pt">On Sat, Jul 17,
2021, 7:33 PM Social Boh <<a
href="mailto:social@bohboh.info"
target="_blank" moz-do-not-send="true">social@bohboh.info</a>>
wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid
#CCCCCC 1.0pt;padding:0cm 0cm 0cm
6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<p style="margin-left:35.4pt">Hello,<o:p></o:p></p>
<p style="margin-left:35.4pt">i tested with
DMQ module and happens the same.<o:p></o:p></p>
<p style="margin-left:35.4pt">DMQ module
loaded before dialog module and on dialog
module parameters:<o:p></o:p></p>
<p style="margin-left:35.4pt">modparam("dialog",
"enable_dmq", 1)<o:p></o:p></p>
<p style="margin-left:35.4pt">During a call
I can see on both Kamailio servers the
dialog data but when switch off the active
kamailio server and the second kamailio
server take the control and hangup the
call, no data acc_cdrs table.<o:p></o:p></p>
<p style="margin-left:35.4pt">Regards<o:p></o:p></p>
<pre style="margin-left:35.4pt">---<o:p></o:p></pre>
<pre style="margin-left:35.4pt">I'm SoCIaL, MayBe<o:p></o:p></pre>
<div>
<p class="MsoNormal"
style="margin-left:35.4pt">El 17/07/2021
a las 1:24 a. m., M Arqum CH escribió:<o:p></o:p></p>
</div>
<blockquote
style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal"
style="margin-left:35.4pt">Hi
Social,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"
style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"
style="margin-left:35.4pt">Replication
of dialog using dmq will solve
your problem, you need to load dmq
module before loading dialog module
and enable replication of dialogs in
dialog module, please check dialog
module conf option for more
details. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"
style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"
style="margin-left:35.4pt">Cheers<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:35.4pt"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal"
style="margin-left:35.4pt">On
Fri, Jul 16, 2021, 7:32 PM
Social Boh <<a
href="mailto:social@bohboh.info"
target="_blank"
moz-do-not-send="true">social@bohboh.info</a>>
wrote:<o:p></o:p></p>
</div>
<blockquote
style="border:none;border-left:solid
#CCCCCC 1.0pt;padding:0cm 0cm 0cm
6.0pt;margin-left:4.8pt;margin-right:0cm">
<p class="MsoNormal"
style="margin-left:35.4pt">Im'
testinf Kamailio HA with
Keepalived.<br>
<br>
I have a problem with acc_cdrs
table in this situation:<br>
<br>
A call B and when the two users
are in the call I switch off the
active <br>
Kamailio. Keepalived pass the
Virtual IP to the secondary
Kamailio and <br>
audio still work because I'm
using a remote RTPENGINE server
for both <br>
Kamailio.<br>
<br>
The problem is when the call
end. On the acc table i can see
INVITE and <br>
BYE entries but on the acc_cdrs
table nothing. Second problem
the dialog <br>
still present on the table
dialog in a Primary/Primary
replication.<br>
<br>
Is there a way to solve it?<br>
<br>
Thank you<br>
<br>
Regards<br>
<br>
-- <br>
---<br>
I'm SoCIaL, MayBe<br>
<br>
<br>
__________________________________________________________<br>
Kamailio - Users Mailing List -
Non Commercial Discussions<br>
* <a
href="mailto:sr-users@lists.kamailio.org"
target="_blank"
moz-do-not-send="true">sr-users@lists.kamailio.org</a><br>
Important: keep the mailing list
in the recipients, do not reply
only to the sender!<br>
Edit mailing list options or
unsubscribe:<br>
* <a
href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users"
target="_blank"
moz-do-not-send="true">
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><o:p></o:p></p>
</blockquote>
</div>
</div>
</div>
<p class="MsoNormal"
style="margin-left:35.4pt"><br>
<br>
<o:p></o:p></p>
<pre style="margin-left:35.4pt">__________________________________________________________<o:p></o:p></pre>
<pre style="margin-left:35.4pt">Kamailio - Users Mailing List - Non Commercial Discussions<o:p></o:p></pre>
<pre style="margin-left:35.4pt"> * <a href="mailto:sr-users@lists.kamailio.org" target="_blank" moz-do-not-send="true">sr-users@lists.kamailio.org</a><o:p></o:p></pre>
<pre style="margin-left:35.4pt">Important: keep the mailing list in the recipients, do not reply only to the sender!<o:p></o:p></pre>
<pre style="margin-left:35.4pt">Edit mailing list options or unsubscribe:<o:p></o:p></pre>
<pre style="margin-left:35.4pt"> * <a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" target="_blank" moz-do-not-send="true">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><o:p></o:p></pre>
</blockquote>
</div>
<p class="MsoNormal"
style="margin-left:35.4pt">__________________________________________________________<br>
Kamailio - Users Mailing List - Non
Commercial Discussions<br>
* <a
href="mailto:sr-users@lists.kamailio.org"
target="_blank" moz-do-not-send="true">sr-users@lists.kamailio.org</a><br>
Important: keep the mailing list in the
recipients, do not reply only to the sender!<br>
Edit mailing list options or unsubscribe:<br>
* <a
href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users"
target="_blank" moz-do-not-send="true">
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><o:p></o:p></p>
</blockquote>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-left:35.4pt"><br>
<br>
<o:p></o:p></p>
<pre style="margin-left:35.4pt">__________________________________________________________<o:p></o:p></pre>
<pre style="margin-left:35.4pt">Kamailio - Users Mailing List - Non Commercial Discussions<o:p></o:p></pre>
<pre style="margin-left:35.4pt"> * <a href="mailto:sr-users@lists.kamailio.org" target="_blank" moz-do-not-send="true">sr-users@lists.kamailio.org</a><o:p></o:p></pre>
<pre style="margin-left:35.4pt">Important: keep the mailing list in the recipients, do not reply only to the sender!<o:p></o:p></pre>
<pre style="margin-left:35.4pt">Edit mailing list options or unsubscribe:<o:p></o:p></pre>
<pre style="margin-left:35.4pt"> * <a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" target="_blank" moz-do-not-send="true">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><o:p></o:p></pre>
</blockquote>
</div>
<p class="MsoNormal" style="margin-left:35.4pt">__________________________________________________________<br>
Kamailio - Users Mailing List - Non Commercial
Discussions<br>
* <a href="mailto:sr-users@lists.kamailio.org"
target="_blank" moz-do-not-send="true">sr-users@lists.kamailio.org</a><br>
Important: keep the mailing list in the recipients, do
not reply only to the sender!<br>
Edit mailing list options or unsubscribe:<br>
* <a
href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users"
target="_blank" moz-do-not-send="true">
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><o:p></o:p></p>
</blockquote>
</div>
<p class="MsoNormal" style="margin-left:35.4pt"><br
clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
<p class="MsoNormal" style="margin-left:35.4pt"><br>
<br>
<o:p></o:p></p>
<pre style="margin-left:35.4pt">__________________________________________________________<o:p></o:p></pre>
<pre style="margin-left:35.4pt">Kamailio - Users Mailing List - Non Commercial Discussions<o:p></o:p></pre>
<pre style="margin-left:35.4pt"> * <a href="mailto:sr-users@lists.kamailio.org" moz-do-not-send="true">sr-users@lists.kamailio.org</a><o:p></o:p></pre>
<pre style="margin-left:35.4pt">Important: keep the mailing list in the recipients, do not reply only to the sender!<o:p></o:p></pre>
<pre style="margin-left:35.4pt">Edit mailing list options or unsubscribe:<o:p></o:p></pre>
<pre style="margin-left:35.4pt"> * <a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" moz-do-not-send="true">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><o:p></o:p></pre>
</blockquote>
</div>
</blockquote>
</body>
</html>