dbmode = 4 on the host acting as registrar.

dbmode = 3 on the host receiving replicated usr_loc.

-dan

From: sr-users <sr-users-bounces@lists.kamailio.org> On Behalf Of Charles Chance
Sent: Thursday, September 6, 2018 3:12 PM
To: Kamailio (SER) - Users Mailing List <sr-users@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@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.