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

[Vik Killa]

Hi,
We have tried using these flags:

save("location")
save("location", "0x00")
save("location", "0x04")

And still memory does not get flushed to DB.
I will test the RPC command.
Thanks,
/V


On Fri, Jan 13, 2017 at 9:12 AM, Daniel-Constantin Mierla <miconda at gmail.com
> wrote:

> Hello,
>
> that flag is used to mark a contact for storage only in memory. The save()
> function has a parameter with flags where this kind of storage can be set.
> Can you check the RPC command is setting this flag?
> Cheers,
> Daniel
>
>
> On 13/01/2017 15:06, Vik Killa wrote:
>
> 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
>>
>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing listsr-users at lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
> --
> Daniel-Constantin Mierlawww.twitter.com/miconda -- www.linkedin.com/in/miconda
> Kamailio World Conference - May 8-10, 2017 - www.kamailioworld.com
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20170113/90bee87a/attachment.html>