[SR-Users] DMQ - Failed to get domain

[Charles Chance]

dmq_usrloc is designed for replication of in-memory contacts and typically
removes the need for using a database altogether. If you do still have a
need for the database then you probably want to be using db_mode 1 or 2
(and the same on both nodes).

I have never tried using db_mode 3 on a receiving (or any for that matter)
node - can you try with an alternative mode and let me know if you still
have the same issue? If the issue remains, please share your usrloc params
 for both servers.

Charles

On Thu, 6 Sep 2018 at 20:23, Daniel W. Graham <dan at cmsinter.net> wrote:

> dbmode = 4 on the host acting as registrar.
>
> dbmode = 3 on the host receiving replicated usr_loc.
>
>
>
> -dan
>
>
>
> *From:* sr-users <sr-users-bounces at lists.kamailio.org> * On Behalf Of *Charles
> Chance
> *Sent:* Thursday, September 6, 2018 3:12 PM
> *To:* Kamailio (SER) - Users Mailing List <sr-users at lists.kamailio.org>
> *Subject:* Re: [SR-Users] DMQ - Failed to get domain
>
>
>
> Hello,
>
>
>
> On Thu, 6 Sep 2018 at 19:00, Daniel W. Graham <dan at cmsinter.net> wrote:
>
> v 5.1.5
>
>
>
> modparam("dmq", "server_address", "sip:x.x.x.x:5060")
>
> modparam("dmq", "notification_address", "sip:y.y.y.y:5060")
>
> modparam("dmq", "multi_notify", 1)
>
> modparam("dmq", "num_workers", 2)
>
> modparam("dmq", "worker_usleep", 0)
>
> modparam("dmq", "ping_interval", 90)
>
>
>
> modparam("dmq_usrloc", "enable", 1)
>
> modparam("dmq_usrloc", "sync", 0)
>
> modparam("dmq_usrloc", "usrloc_domain", "location")
>
>
>
> My initial assumption was that dmq_handle_message() handled everything.
>
>
>
>
>
> It does.
>
>
>
> I have since added
>
> if (dmq_is_from_node()) {
>
>                 if (!save("location")) {
>
>                                 xlogl("L_ERR", "Error saving contact\n");
>
>                 }
>
> }
>
>
>
>
>
> This will not work.
>
>
>
> Now results in:
>
>
>
> ERROR: <core> [db.c:463]: db_use_table(): invalid parameter value
>
> ERROR: usrloc [udomain.c:631]: db_load_urecord(): failed to use table
> location
>
> ERROR: <core> [db.c:463]: db_use_table(): invalid parameter value
>
> ERROR: usrloc [ucontact.c:679]: db_insert_ucontact(): sql use_table failed
>
> ERROR: usrloc [urecord.c:582]: insert_ucontact(): failed to insert in
> database
>
>
>
>
>
> Which db_mode are you using for usrloc?
>
>
>
>
>
> Cheers,
>
>
>
> Charles
>
>
>
>
>
>
>
> --
>
> *Charles Chance*
> Managing Director
>
>
>
> t. 0330 120 1200    m. 07932 063 891
>
>
>
> Sipcentric Ltd. Company registered in England & Wales no. 7365592. Registered
> office: Faraday Wharf, Innovation Birmingham Campus, Holt Street,
> Birmingham Science Park, Birmingham B7 4BB.
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
-- 
*Charles Chance*
Managing Director

t. 0330 120 1200    m. 07932 063 891

-- 
Sipcentric Ltd.
                Company registered in England & Wales no. 
7365592. Registered
                office: Faraday Wharf, Innovation 
Birmingham Campus, Holt Street, Birmingham Science Park, Birmingham B7 4BB.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20180907/464a7984/attachment.html>