[SR-Users] usrloc module with dbmode=2 does not insert records to database

[Vik Killa]

following up here
i found if we comment out a single line of code, kamcmd ul.flush works

here is the git diff



diff --git a/src/modules/usrloc/ucontact.c b/src/modules/usrloc/ucontact.c
index 47f3c2f..633ca81 100644
--- a/src/modules/usrloc/ucontact.c
+++ b/src/modules/usrloc/ucontact.c
@@ -474,7 +474,7 @@ int db_insert_ucontact(ucontact_t* _c)
        int nr_cols;

        if (_c->flags & FL_MEM) {
-               return 0;
+               //return 0;
        }
        if(unlikely(_c->ruid.len<=0)) {
                LM_ERR("invalid ruid for aor: %.*s\n",





I don't quite understand the logic in that code.
Does anyone have an idea of why `        if (_c->flags & FL_MEM) {`
returns?

Thanks,
/V


On Thu, Jan 12, 2017 at 4:34 PM, Vik Killa <vipkilla at gmail.com> wrote:

> Hello,
> we've noticed that the usrloc module does not "sync" all the records from
> memory into the database.
> I use a bash script to generate in-memory AoRs (http://paste.debian.net/
> plain/908521)
> then i perform
> kamcmd ul.flush
> and no records are inserted.
> We have tried various usrloc parameters but none seem to work
> Here is our basic setup
>
> # ----- usrloc params -----
> modparam("usrloc", "db_url", DBURL)
> modparam("usrloc", "db_mode", 2)
> modparam("usrloc", "use_domain", 1)
> modparam("usrloc", "timer_interval", 120)
> modparam("usrloc", "timer_procs", 4)
>
> We are using postgresql.
> are we missing something?
>
> Thanks
> /V
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20170113/d9d7faff/attachment.html>