[SR-Users] Kamailio KeepAlived HA acc_cdrs table record

Social Boh social at bohboh.info
Tue Jul 20 14:08:27 CEST 2021


hello,

sorry to send the new message directly to Henning

----

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 
> <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/ <https://skalatan.de/blog/>
>
> Kamailio services – https://gilawa.com <https://gilawa.com/>
>
> *From:* sr-users <sr-users-bounces at lists.kamailio.org> *On Behalf Of 
> *Social Boh
> *Sent:* Tuesday, July 20, 2021 12:55 AM
> *To:* Kamailio (SER) - Users Mailing List <sr-users at 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/
>     <https://skalatan.de/blog/>
>
>     Kamailio services – https://gilawa.com <https://gilawa.com/>
>
>     *From:* sr-users <sr-users-bounces at lists.kamailio.org>
>     <mailto:sr-users-bounces at lists.kamailio.org> *On Behalf Of *Social Boh
>     *Sent:* Monday, July 19, 2021 1:58 PM
>     *To:* Kamailio (SER) - Users Mailing List
>     <sr-users at lists.kamailio.org> <mailto:sr-users at 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
>         <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 at bohboh.info
>         <mailto:social at 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 at bohboh.info <mailto:social at 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 at bohboh.info
>                         <mailto:social at 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 at lists.kamailio.org
>                             <mailto:sr-users at 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
>                             <https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users>
>
>
>
>
>                         __________________________________________________________
>
>                         Kamailio - Users Mailing List - Non Commercial Discussions
>
>                            *sr-users at lists.kamailio.org  <mailto:sr-users at 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  <https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users>
>
>                     __________________________________________________________
>                     Kamailio - Users Mailing List - Non Commercial
>                     Discussions
>                       * sr-users at lists.kamailio.org
>                     <mailto:sr-users at 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
>                     <https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users>
>
>
>
>
>                 __________________________________________________________
>
>                 Kamailio - Users Mailing List - Non Commercial Discussions
>
>                    *sr-users at lists.kamailio.org  <mailto:sr-users at 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  <https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users>
>
>             __________________________________________________________
>             Kamailio - Users Mailing List - Non Commercial Discussions
>               * sr-users at lists.kamailio.org
>             <mailto:sr-users at 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
>             <https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users>
>
>
>
>
>
>         __________________________________________________________
>
>         Kamailio - Users Mailing List - Non Commercial Discussions
>
>            *sr-users at lists.kamailio.org  <mailto:sr-users at 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  <https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20210720/e1a01e25/attachment.htm>


More information about the sr-users mailing list