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

[Daniel-Constantin Mierla]

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
> <mailto: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
>     <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 list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio World Conference - May 8-10, 2017 - www.kamailioworld.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20170113/fb5b795c/attachment.html>