[prev in list] [next in list] [prev in thread] [next in thread] 

List:       serusers
Subject:    Re: [SR-Users] Kamailio KeepAlived HA acc_cdrs table record
From:       Henning Westerholt <hw () skalatan ! de>
Date:       2021-07-20 12:11:29
Message-ID: PAXPR05MB85585B935BF8BD7B5FE3665FC5E29 () PAXPR05MB8558 ! eurprd05 ! prod ! outlook ! com
[Download RAW message or body]

[Attachment #2 (text/plain)]

Hello,

I have not tested it, but the dialog database will probably only help in a restart \
scenario with regarding to dialogs, at least with a standard cfg. Regarding the \
example below, this would mean starting the primary Kamailio again, then the cdrs \
should be generated during the hangup from the primary. You can test also to restart \
the secondary Kamailio, it should then also read the dialogs from the replicated \
table and generate cdrs at hangup.

Cheers,

Henning

--
Henning Westerholt – https://skalatan.de/blog/
Kamailio services – https://gilawa.com<https://gilawa.com/>

From: Social Boh <social@bohboh.info>
Sent: Tuesday, July 20, 2021 2:02 PM
To: Henning Westerholt <hw@skalatan.de>
Subject: Re: [SR-Users] Kamailio KeepAlived HA acc_cdrs table record


Hello,

with dialog db_mode 1 and Primary/Primary MariaDB Replication If I switch Off primary \
Kamailio during a call and move the call to Replica and then hangup, no entry on \
acc_cdrs table. acc table is ok.

Regards

---

I'm SoCIaL, MayBe
El 20/07/2021 a las 4:09 a. m., Henning Westerholt escribió:
Hello,

Usage of DB to store dialogs. See \
https://kamailio.org/docs/modules/devel/modules/dialog.html#dialog.p.db_mode – in \
particular mode 1 and 3.

Cheers,

Henning

--
Henning Westerholt – https://skalatan.de/blog/
Kamailio services – https://gilawa.com<https://gilawa.com/>

From: sr-users <sr-users-bounces@lists.kamailio.org><mailto:sr-users-bounces@lists.kamailio.org> \
                On Behalf Of Social Boh
Sent: Tuesday, July 20, 2021 12:55 AM
To: Kamailio (SER) - Users Mailing List \
                <sr-users@lists.kamailio.org><mailto:sr-users@lists.kamailio.org>
Subject: Re: [SR-Users] Kamailio KeepAlived HA acc_cdrs table record


Hello

what means "DB loading" ?

Regards

---

I'm SoCIaL, MayBe
El 19/07/2021 a las 9:25 a. m., Henning Westerholt escribió:
Hello,

so, you are saying that in a DMQ replicated case the acc CDR generation is not \
working in failover cases.

I just looked briefly to the code; others might have more details.
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.

You could open a feature request on our github tracker for this.

Cheers,

Henning

--
Henning Westerholt – https://skalatan.de/blog/
Kamailio services – https://gilawa.com<https://gilawa.com/>

From: sr-users <sr-users-bounces@lists.kamailio.org><mailto:sr-users-bounces@lists.kamailio.org> \
                On Behalf Of Social Boh
Sent: Monday, July 19, 2021 1:58 PM
To: Kamailio (SER) - Users Mailing List \
                <sr-users@lists.kamailio.org><mailto:sr-users@lists.kamailio.org>
Subject: Re: [SR-Users] Kamailio KeepAlived HA acc_cdrs table record


Hi,

I'm using 5.4.6

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.

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:

server 1 INVITE

server 2 BYE

acc_cdrs table empty on both servers.

acc table first server INVITE; acc table second server BYE

Regards

---

I'm SoCIaL, MayBe
El 18/07/2021 a las 2:33 p. m., M Arqum CH escribió:
Hi SoCIal,

which Kamailio version you are using.

did you able to get the dialog information using the dialog command. \
https://www.kamailio.org/docs/modules/devel/modules/dialog.html#dlg.r.dlg_list

when you received bye on secondary server, is that server recognized the bye.



On Sun, Jul 18, 2021 at 3:38 AM Social Boh \
<social@bohboh.info<mailto:social@bohboh.info>> wrote:

Hello,

if during a call I stop Primary Kamailio the Secondary Kamailio take de Virtual IP \
but don't save call data:

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.

in the file LOG no data about call cdr.

Maybe a solution is write call data whene the call end?

Regards

---

I'm SoCIaL, MayBe
El 17/07/2021 a las 11:34 a. m., M Arqum CH escribió:
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.

Hope this will help you.
On Sat, Jul 17, 2021, 7:33 PM Social Boh \
<social@bohboh.info<mailto:social@bohboh.info>> wrote:

Hello,

i tested with DMQ module and happens the same.

DMQ module loaded before dialog module and on dialog module parameters:

modparam("dialog", "enable_dmq", 1)

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.

Regards

---

I'm SoCIaL, MayBe
El 17/07/2021 a las 1:24 a. m., M Arqum CH escribió:
Hi Social,

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.

Cheers

On Fri, Jul 16, 2021, 7:32 PM Social Boh \
<social@bohboh.info<mailto:social@bohboh.info>> wrote: Im' testinf Kamailio HA with \
Keepalived.

I have a problem with acc_cdrs table in this situation:

A call B and when the two users are in the call I switch off the active
Kamailio. Keepalived pass the Virtual IP to the secondary Kamailio and
audio still work because I'm using a remote RTPENGINE server for both
Kamailio.

The problem is when the call end. On the acc table i can see INVITE and
BYE entries but on the acc_cdrs table nothing. Second problem the dialog
still present on the table dialog in a Primary/Primary replication.

Is there a way to solve it?

Thank you

Regards

--
---
I'm SoCIaL, MayBe


__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions
  * sr-users@lists.kamailio.org<mailto:sr-users@lists.kamailio.org>
Important: keep the mailing list in the recipients, do not reply only to the sender!
Edit mailing list options or unsubscribe:
  * https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users





__________________________________________________________

Kamailio - Users Mailing List - Non Commercial Discussions

  * sr-users@lists.kamailio.org<mailto:sr-users@lists.kamailio.org>

Important: keep the mailing list in the recipients, do not reply only to the sender!

Edit mailing list options or unsubscribe:

  * https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions
  * sr-users@lists.kamailio.org<mailto:sr-users@lists.kamailio.org>
Important: keep the mailing list in the recipients, do not reply only to the sender!
Edit mailing list options or unsubscribe:
  * https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users





__________________________________________________________

Kamailio - Users Mailing List - Non Commercial Discussions

  * sr-users@lists.kamailio.org<mailto:sr-users@lists.kamailio.org>

Important: keep the mailing list in the recipients, do not reply only to the sender!

Edit mailing list options or unsubscribe:

  * https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions
  * sr-users@lists.kamailio.org<mailto:sr-users@lists.kamailio.org>
Important: keep the mailing list in the recipients, do not reply only to the sender!
Edit mailing list options or unsubscribe:
  * https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users







__________________________________________________________

Kamailio - Users Mailing List - Non Commercial Discussions

  * sr-users@lists.kamailio.org<mailto:sr-users@lists.kamailio.org>

Important: keep the mailing list in the recipients, do not reply only to the sender!

Edit mailing list options or unsubscribe:

  * https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users


[Attachment #3 (text/html)]

<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"> <head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@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;}
/* Style Definitions */
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-MailFormatvorlage22
	{mso-style-type:personal-reply;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:70.85pt 70.85pt 2.0cm 70.85pt;}
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]-->
</head>
<body lang="DE" link="blue" vlink="purple" style="word-wrap:break-word">
<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>&nbsp;</o:p></span></p> <p \
class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US">I have not \
tested it, but the dialog database will probably only help in a restart scenario with \
regarding to dialogs, at least with a standard cfg.<o:p></o:p></span></p> <p \
class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US">Regarding the \
example below, this would mean starting the primary Kamailio again, then the cdrs \
should be generated during the hangup from the primary. You can test also to restart \
the  secondary Kamailio, it should then also read the dialogs from the replicated \
table and generate cdrs at hangup.<o:p></o:p></span></p> <p class="MsoNormal"><span \
lang="EN-GB" style="mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p> <p \
class="MsoNormal"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">Cheers,<o:p></o:p></span></p> <p \
class="MsoNormal"><span lang="EN-GB" \
style="mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p> <p \
class="MsoNormal"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">Henning<o:p></o:p></span></p> <p \
class="MsoNormal"><span lang="EN-GB" \
style="mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p> <div>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US">-- <o:p>
</o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US">Henning \
Westerholt – </span><span style="mso-fareast-language:EN-US"><a \
href="https://skalatan.de/blog/"><span lang="EN-GB" \
style="color:#0563C1">https://skalatan.de/blog/</span></a></span><span lang="EN-GB" \
style="mso-fareast-language:EN-US"><o:p></o:p></span></p> <p class="MsoNormal"><span \
lang="EN-GB" style="mso-fareast-language:EN-US">Kamailio services – </span><span \
style="mso-fareast-language:EN-US"><a href="https://gilawa.com/"><span lang="EN-GB" \
style="color:#0563C1">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 lang="EN-GB" \
style="mso-fareast-language:EN-US"><o:p>&nbsp;</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> Social Boh \
&lt;social@bohboh.info&gt; <br>
<b>Sent:</b> Tuesday, July 20, 2021 2:02 PM<br>
<b>To:</b> Henning Westerholt &lt;hw@skalatan.de&gt;<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>&nbsp;</o:p></p>
<p style="margin-left:35.4pt"><span \
style="font-size:10.0pt">Hello,</span><o:p></o:p></p> <p \
style="margin-left:35.4pt"><span style="font-size:10.0pt">with dialog db_mode 1 and \
Primary/Primary MariaDB Replication If I switch Off primary Kamailio during a call \
and move the call to Replica and then hangup, no entry on acc_cdrs table. acc table \
is  ok.</span><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 20/07/2021 a las 4:09 a.&nbsp;m., \
Henning Westerholt escribió:<o:p></o:p></p> </div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal" style="margin-left:35.4pt"><span \
style="mso-fareast-language:EN-US">Hello,</span><o:p></o:p></p> <p class="MsoNormal" \
style="margin-left:35.4pt"><span \
style="mso-fareast-language:EN-US">&nbsp;</span><o:p></o:p></p> <p class="MsoNormal" \
style="margin-left:35.4pt"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">Usage of DB to store dialogs. See </span><span \
style="mso-fareast-language:EN-US"><a \
href="https://kamailio.org/docs/modules/devel/modules/dialog.html#dialog.p.db_mode"><span \
lang="EN-GB">https://kamailio.org/docs/modules/devel/modules/dialog.html#dialog.p.db_mode</span></a>
 </span><span lang="EN-GB" style="mso-fareast-language:EN-US">– in particular mode \
1 and 3.</span><o:p></o:p></p> <p class="MsoNormal" style="margin-left:35.4pt"><span \
lang="EN-GB" style="mso-fareast-language:EN-US">&nbsp;</span><o:p></o:p></p> <p \
class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">Cheers,</span><o:p></o:p></p> <p class="MsoNormal" \
style="margin-left:35.4pt"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">&nbsp;</span><o:p></o:p></p> <p class="MsoNormal" \
style="margin-left:35.4pt"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">Henning</span><o:p></o:p></p> <p class="MsoNormal" \
style="margin-left:35.4pt"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">&nbsp;</span><o:p></o:p></p> <div>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">-- </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">Henning Westerholt – </span><span \
style="mso-fareast-language:EN-US"><a href="https://skalatan.de/blog/"><span \
lang="EN-GB" style="color:#0563C1">https://skalatan.de/blog/</span></a></span><o:p></o:p></p>
 <p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">Kamailio services – </span><span \
style="mso-fareast-language:EN-US"><a href="https://gilawa.com/"><span lang="EN-GB" \
style="color:#0563C1">https://gilawa.com</span></a> </span><o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-left:35.4pt"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">&nbsp;</span><o:p></o:p></p> <div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="margin-left:70.8pt"><b>From:</b> sr-users <a \
href="mailto:sr-users-bounces@lists.kamailio.org"> \
&lt;sr-users-bounces@lists.kamailio.org&gt;</a> <b>On Behalf Of </b>Social Boh<br> \
<b>Sent:</b> Tuesday, July 20, 2021 12:55 AM<br> <b>To:</b> Kamailio (SER) - Users \
Mailing List <a href="mailto:sr-users@lists.kamailio.org"> \
&lt;sr-users@lists.kamailio.org&gt;</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:70.8pt">&nbsp;<o:p></o:p></p>
<p style="margin-left:70.8pt"><span \
style="font-size:10.0pt">Hello</span><o:p></o:p></p> <p \
style="margin-left:70.8pt"><span style="font-size:10.0pt">what means \
&quot;</span><span lang="EN-GB" style="mso-fareast-language:EN-US">DB loading&quot; \
?</span><o:p></o:p></p> <p style="margin-left:70.8pt"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">Regards</span><o:p></o:p></p> <pre \
style="margin-left:70.8pt">---<o:p></o:p></pre> <pre style="margin-left:70.8pt">I'm \
SoCIaL, MayBe<o:p></o:p></pre> <div>
<p class="MsoNormal" style="margin-left:70.8pt">El 19/07/2021 a las 9:25 a.&nbsp;m., \
Henning Westerholt escribió:<o:p></o:p></p> </div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal" style="margin-left:70.8pt"><span \
style="mso-fareast-language:EN-US">Hello,</span><o:p></o:p></p> <p class="MsoNormal" \
style="margin-left:70.8pt"><span \
style="mso-fareast-language:EN-US">&nbsp;</span><o:p></o:p></p> <p class="MsoNormal" \
style="margin-left:70.8pt"><span lang="EN-GB" style="mso-fareast-language:EN-US">so, \
you are saying that in a DMQ replicated case the acc CDR generation is not working in \
failover cases.</span><o:p></o:p></p> <p class="MsoNormal" \
style="margin-left:70.8pt"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">&nbsp;</span><o:p></o:p></p> <p class="MsoNormal" \
style="margin-left:70.8pt"><span lang="EN-GB" style="mso-fareast-language:EN-US">I \
just looked briefly to the code; others might have more \
details.</span><o:p></o:p></p> <p class="MsoNormal" style="margin-left:70.8pt"><span \
lang="EN-GB" style="mso-fareast-language:EN-US">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.</span><o:p></o:p></p> <p class="MsoNormal" \
style="margin-left:70.8pt"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">&nbsp;</span><o:p></o:p></p> <p class="MsoNormal" \
style="margin-left:70.8pt"><span lang="EN-GB" style="mso-fareast-language:EN-US">You \
could open a feature request on our github tracker for this.</span><o:p></o:p></p> <p \
class="MsoNormal" style="margin-left:70.8pt"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">&nbsp;</span><o:p></o:p></p> <p class="MsoNormal" \
style="margin-left:70.8pt"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">Cheers,</span><o:p></o:p></p> <p class="MsoNormal" \
style="margin-left:70.8pt"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">&nbsp;</span><o:p></o:p></p> <p class="MsoNormal" \
style="margin-left:70.8pt"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">Henning</span><o:p></o:p></p> <p class="MsoNormal" \
style="margin-left:70.8pt"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">&nbsp;</span><o:p></o:p></p> <div>
<p class="MsoNormal" style="margin-left:70.8pt"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">-- </span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:70.8pt"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">Henning Westerholt – </span><span \
style="mso-fareast-language:EN-US"><a href="https://skalatan.de/blog/"><span \
lang="EN-GB" style="color:#0563C1">https://skalatan.de/blog/</span></a></span><o:p></o:p></p>
 <p class="MsoNormal" style="margin-left:70.8pt"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">Kamailio services – </span><span \
style="mso-fareast-language:EN-US"><a href="https://gilawa.com/"><span lang="EN-GB" \
style="color:#0563C1">https://gilawa.com</span></a> </span><o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-left:70.8pt"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">&nbsp;</span><o:p></o:p></p> <div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="margin-left:106.2pt"><b>From:</b> sr-users <a \
href="mailto:sr-users-bounces@lists.kamailio.org"> \
&lt;sr-users-bounces@lists.kamailio.org&gt;</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 href="mailto:sr-users@lists.kamailio.org"> \
&lt;sr-users@lists.kamailio.org&gt;</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:106.2pt">&nbsp;<o:p></o:p></p>
<p style="margin-left:106.2pt">Hi,<o:p></o:p></p>
<p style="margin-left:106.2pt">I'm using 5.4.6<o:p></o:p></p>
<p style="margin-left:106.2pt">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:106.2pt">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:106.2pt">server 1 \
INVITE<o:p></o:p></p> <p style="margin-left:106.2pt">server 2 BYE<o:p></o:p></p>
<p style="margin-left:106.2pt">acc_cdrs table empty on both servers.<o:p></o:p></p>
<p style="margin-left:106.2pt">acc table first server INVITE; acc table second server \
BYE<o:p></o:p></p> <p style="margin-left:106.2pt">Regards<o:p></o:p></p>
<pre style="margin-left:106.2pt">---<o:p></o:p></pre>
<pre style="margin-left:106.2pt">I'm SoCIaL, MayBe<o:p></o:p></pre>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">El 18/07/2021 a las 2:33 p.&nbsp;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:106.2pt">Hi SoCIal,&nbsp;<br>
<br>
which Kamailio version you are using. <o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">&nbsp;<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">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"> 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:106.2pt">&nbsp;<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">when you received&nbsp;bye on \
secondary server, is that server recognized the bye.<o:p></o:p></p> </div>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">&nbsp;<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:106.2pt">
 &nbsp;<o:p></o:p></p>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-left:106.2pt">&nbsp;<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">On Sun, Jul 18, 2021 at 3:38 AM \
Social Boh &lt;<a href="mailto:social@bohboh.info" \
target="_blank">social@bohboh.info</a>&gt; 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-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt"> <div>
<p style="margin-left:106.2pt">Hello,<o:p></o:p></p>
<p style="margin-left:106.2pt">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:106.2pt">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:106.2pt">in the file LOG no data about call cdr.<o:p></o:p></p> <p \
style="margin-left:106.2pt">Maybe a solution is write call data whene the call \
end?<o:p></o:p></p> <p style="margin-left:106.2pt">Regards<o:p></o:p></p>
<pre style="margin-left:106.2pt">---<o:p></o:p></pre>
<pre style="margin-left:106.2pt">I'm SoCIaL, MayBe<o:p></o:p></pre>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">El 17/07/2021 a las 11:34 \
a.&nbsp;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:106.2pt">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:106.2pt">&nbsp;<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:106.2pt">
 Hope this will help&nbsp;you.<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">On Sat, Jul 17, 2021, 7:33 PM Social \
Boh &lt;<a href="mailto:social@bohboh.info" \
target="_blank">social@bohboh.info</a>&gt; 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-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt"> <div>
<p style="margin-left:106.2pt">Hello,<o:p></o:p></p>
<p style="margin-left:106.2pt">i tested with DMQ module and happens the \
same.<o:p></o:p></p> <p style="margin-left:106.2pt">DMQ module loaded before dialog \
module and on dialog module parameters:<o:p></o:p></p> <p \
style="margin-left:106.2pt">modparam(&quot;dialog&quot;, &quot;enable_dmq&quot;, \
1)<o:p></o:p></p> <p style="margin-left:106.2pt">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:106.2pt">Regards<o:p></o:p></p>
<pre style="margin-left:106.2pt">---<o:p></o:p></pre>
<pre style="margin-left:106.2pt">I'm SoCIaL, MayBe<o:p></o:p></pre>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">El 17/07/2021 a las 1:24 a.&nbsp;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:106.2pt">Hi Social,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">&nbsp;<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">Replication of dialog using dmq will \
solve your&nbsp;problem, you need to load dmq module before&nbsp; loading dialog \
module and enable replication of dialogs in dialog module, please check dialog module \
conf option for  more details.&nbsp;<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">&nbsp;<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">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:106.2pt">
 &nbsp;<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">On Fri, Jul 16, 2021, 7:32 PM Social \
Boh &lt;<a href="mailto:social@bohboh.info" \
target="_blank">social@bohboh.info</a>&gt; 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-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt"> <p \
class="MsoNormal" style="margin-left:106.2pt">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>
&nbsp; * <a href="mailto:sr-users@lists.kamailio.org" \
                target="_blank">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>
&nbsp; * <a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" \
target="_blank"> 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:106.2pt"><br>
<br>
<br>
<br>
<o:p></o:p></p>
<pre style="margin-left:106.2pt">__________________________________________________________<o:p></o:p></pre>
 <pre style="margin-left:106.2pt">Kamailio - Users Mailing List - Non Commercial \
Discussions<o:p></o:p></pre> <pre style="margin-left:106.2pt">&nbsp; * <a \
href="mailto:sr-users@lists.kamailio.org" \
target="_blank">sr-users@lists.kamailio.org</a><o:p></o:p></pre> <pre \
style="margin-left:106.2pt">Important: keep the mailing list in the recipients, do \
not reply only to the sender!<o:p></o:p></pre> <pre style="margin-left:106.2pt">Edit \
mailing list options or unsubscribe:<o:p></o:p></pre> <pre \
style="margin-left:106.2pt">&nbsp; * <a \
href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" \
target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><o:p></o:p></pre>
 </blockquote>
</div>
<p class="MsoNormal" \
style="margin-left:106.2pt">__________________________________________________________<br>
 Kamailio - Users Mailing List - Non Commercial Discussions<br>
&nbsp; * <a href="mailto:sr-users@lists.kamailio.org" \
                target="_blank">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>
&nbsp; * <a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" \
target="_blank"> 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:106.2pt"><br>
<br>
<br>
<br>
<o:p></o:p></p>
<pre style="margin-left:106.2pt">__________________________________________________________<o:p></o:p></pre>
 <pre style="margin-left:106.2pt">Kamailio - Users Mailing List - Non Commercial \
Discussions<o:p></o:p></pre> <pre style="margin-left:106.2pt">&nbsp; * <a \
href="mailto:sr-users@lists.kamailio.org" \
target="_blank">sr-users@lists.kamailio.org</a><o:p></o:p></pre> <pre \
style="margin-left:106.2pt">Important: keep the mailing list in the recipients, do \
not reply only to the sender!<o:p></o:p></pre> <pre style="margin-left:106.2pt">Edit \
mailing list options or unsubscribe:<o:p></o:p></pre> <pre \
style="margin-left:106.2pt">&nbsp; * <a \
href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" \
target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><o:p></o:p></pre>
 </blockquote>
</div>
<p class="MsoNormal" \
style="margin-left:106.2pt">__________________________________________________________<br>
 Kamailio - Users Mailing List - Non Commercial Discussions<br>
&nbsp; * <a href="mailto:sr-users@lists.kamailio.org" \
                target="_blank">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>
&nbsp; * <a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" \
target="_blank"> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><o:p></o:p></p>
 </blockquote>
</div>
<p class="MsoNormal" style="margin-left:106.2pt"><br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-left:106.2pt">&nbsp;<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-left:106.2pt"><br>
<br>
<br>
<br>
<o:p></o:p></p>
<pre style="margin-left:106.2pt">__________________________________________________________<o:p></o:p></pre>
 <pre style="margin-left:106.2pt">Kamailio - Users Mailing List - Non Commercial \
Discussions<o:p></o:p></pre> <pre style="margin-left:106.2pt">&nbsp; * <a \
href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a><o:p></o:p></pre>
 <pre style="margin-left:106.2pt">Important: keep the mailing list in the recipients, \
do not reply only to the sender!<o:p></o:p></pre> <pre \
style="margin-left:106.2pt">Edit mailing list options or \
unsubscribe:<o:p></o:p></pre> <pre style="margin-left:106.2pt">&nbsp; * <a \
href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><o:p></o:p></pre>
 </blockquote>
</blockquote>
</blockquote>
</div>
</body>
</html>



__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions
  * sr-users@lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the sender!
Edit mailing list options or unsubscribe:
  * https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

--===============1864406634==--


[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic