[OpenSIPS-Users] Central database

[Alberto]

Hi,

Thanks, I was playing around with the clusterer module, but I can't quite
figure something out.

In the database I have this entry in the clusterer table:
id: 1
cluster_id: 1
node_id: 1
url: bin:10.0.0.184:5555
state: 1
no_ping_retries: 3
priority: 50
sip_addr: 10.0.0.184
flags: seed

And here's my configuration:

loadmodule "clusterer.so"
modparam("clusterer", "db_url", "unixodbc://opensips:opensipsrw@localhost
/opensips")
modparam("clusterer", "my_node_id", 1)

loadmodule "dialog.so"
modparam("dialog", "default_timeout", 14400) # 4 hours
modparam("dialog", "dlg_match_mode", 1)
modparam("dialog", "enable_stats", 0)
modparam("dialog", "profiles_with_value", "caller")
modparam("dialog", "cachedb_url", "mongodb://db.dialog")
modparam("dialog", "dialog_replication_cluster", 1)

loadmodule "usrloc.so"
modparam("usrloc", "nat_bflag", "NAT")
modparam("usrloc", "use_domain", 1)
modparam("usrloc", "cachedb_url", "mongodb://db.usrloc")
modparam("usrloc", "working_mode_preset", "federation-cachedb-cluster")
modparam("usrloc", "location_cluster", 1)


Now when a user registers, the usrloc collection in mongodb gets populated
with some details.
But when I start a call instead, the dialog collection stays empty. What do
I need to do to write the dialogs?
I'm testing with only one opensips server for now, so that's the only entry
in the clusterer table.
Thanks.

On Tue, 18 Jan 2022 at 12:50, Bogdan-Andrei Iancu <bogdan at opensips.org>
wrote:

> Hi Aberto,
>
> It is not a good strategy to blindly share the tables for usrloc or dialog
> between multiple opensips instances, as this will lead to data conflicts.
> Of course, you can have all pointing to the same DB, but one table per
> opensips server.
>
> If you want to aggregate the data (between all opensips instances), there
> is no other way than using the clustering .
>
> Regards,
>
> Bogdan-Andrei Iancu
>
> OpenSIPS Founder and Developer
>   https://www.opensips-solutions.com
> OpenSIPS eBootcamp 2021
>   https://opensips.org/training/OpenSIPS_eBootcamp_2021/
>
> On 1/16/22 1:47 PM, Alberto wrote:
>
> Hi,
> I need several opensips servers to save usrloc and dialog to the same
> central database, not for clustering/ha, but for reporting and billing.
> Is it safe to point multiple usrloc and dialog modules to a central
> database using the db_url? Or would they cause conflicts?
> Since it's not a cluster where they use the shared information, I would
> prefer to avoid the complexity of the clusterer module. But I need to know
> one server won't cancel another server location or dialog.
> Thanks
>
> _______________________________________________
> Users mailing listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20220118/2a0dea1b/attachment.html>