Re: [OpenSIPS-Users] Problem with SQL database in Federated User Location Cluster OpenSIPS 3.0

2019-09-20 Thread Liviu Chircu
Hi Sasmita, Any time we receive an INVITE, we have to look up the MongoDB metadata, to learn all POPs where we should fork it to.  There is no caching for this, as the idea is to be able to scale this whole thing horizontally and geographically. Regards, Liviu Chircu OpenSIPS Developer http:

Re: [OpenSIPS-Users] Problem with SQL database in Federated User Location Cluster OpenSIPS 3.0

2019-09-19 Thread Sasmita Panda
Hi Liviu, I have a query in this model . As the contact metadata is present in the mongoDB cache . When an Invite came to a node which is not local to that node at that time , the node query the mongoDB cache for the meta data or the node has the meta data in the memory . I mean each and every ti

Re: [OpenSIPS-Users] Problem with SQL database in Federated User Location Cluster OpenSIPS 3.0

2019-09-17 Thread Shanawaj Khan
Thanks Liviu, working fine with "load-from-sql" (with dashes). Regards, Shahnawaz On Tue, Sep 17, 2019 at 3:27 PM Liviu Chircu wrote: > Hi Shanawaj, > > By any chance, do you get an ERROR log on startup resembling: > > ERROR: unknown 'restart_persistency' value: load_from_sql, using 'none'? > >

Re: [OpenSIPS-Users] Problem with SQL database in Federated User Location Cluster OpenSIPS 3.0

2019-09-17 Thread Liviu Chircu
Hi Shanawaj, By any chance, do you get an ERROR log on startup resembling: ERROR: unknown 'restart_persistency' value: load_from_sql, using 'none'? It looks like you should be using "load-from-sql" (with dashes) Regards, Liviu Chircu OpenSIPS Developer http://www.opensips-solutions.com On 17

Re: [OpenSIPS-Users] Problem with SQL database in Federated User Location Cluster OpenSIPS 3.0

2019-09-17 Thread Johan De Clercq
Your connection string is probably wrong. On Tue, 17 Sep 2019, 11:22 Shanawaj Khan, wrote: > Hi All, > > I am trying to save user location data in SQL database for restart > persistency. I am setting parameters as > > modparam("usrloc", "db_url", "mysql://root:myuser@localhost/opensips") > modpa

[OpenSIPS-Users] Problem with SQL database in Federated User Location Cluster OpenSIPS 3.0

2019-09-17 Thread Shanawaj Khan
Hi All, I am trying to save user location data in SQL database for restart persistency. I am setting parameters as modparam("usrloc", "db_url", "mysql://root:myuser@localhost/opensips") modparam("usrloc", "use_domain", 1) modparam("usrloc", "location_cluster", 1) modparam("usrloc", "cluster_mode"