Re: [SR-Users] Kamailio KeepAlived HA acc_cdrs table record

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 &lt;social(a)bohboh.info&gt; Sent: Tuesday, July 20, 2021 2:02 PM To: Henning Westerholt &lt;hw(a)skalatan.de&gt; 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_l… 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