Re: [OpenSIPS-Users] Central database

[Bogdan-Andrei Iancu]

Hi Alberto,

For the dialog replications, the noSQL is used only for counters on the 
dialog profiles, not for sharing the calls. The calls are shared 
directly via the clustering layer and you will see the same of dialogs 
on all OpenSIPs nodes (via MI dlg_list). Of course, you can combine a 
SQL DB in dialog module, for dumping the dialogs into DB. In this way, 
whatever is in memory (either calls started by the node, either calls 
received via replication) will also end up in the SQL DB.


Best 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/18/22 6:26 PM, Alberto wrote:

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: 
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 > 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 list
Users@lists.opensips.org  
http://lists.opensips.org/cgi-bin/mailman/listinfo/users  





___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [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:
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 
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@lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] Central database

[Bogdan-Andrei Iancu]

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 list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users