[SR-Users] Error in USERLOCDB

[Alberto Sagredo]

Thanks Daniel

That was exactly my issue. Solved!

2016-04-08 8:27 GMT+02:00 Daniel-Constantin Mierla <miconda at gmail.com>:

> Hello,
>
> it seems you created the location table a while ago, before the official
> release of 4.4, when there was an invalid constraint in its definition. You
> have to drop database location and install it using the sql statement from
> the file:
>
> utils/kamctl/mysql/usrloc-create.sql
>
> Cheers,
> Daniel
>
>
> On 07/04/16 22:20, Alberto Sagredo wrote:
>
> Im getting this error using USERLOCDB
>
> Apr  7 22:11:56 kamailio-int /usr/local/sbin/kamailio[29717]: ERROR:
> db_mysql [km_dbase.c:128]: db_mysql_submit_query(): driver error on query:
> Duplicate entry '0--1' for key 'connection_idx' (1062)
>
> Apr  7 22:11:56 kamailio-int /usr/local/sbin/kamailio[29717]: ERROR:
> <core> [db_query.c:235]: db_do_insert_cmd(): error while submitting query
>
> Apr  7 22:11:56 kamailio-int /usr/local/sbin/kamailio[29717]: ERROR:
> usrloc [ucontact.c:684]: db_insert_ucontact(): inserting contact in db
> failed xxxx (uloc-5706bebd-7415-3)
>
> Apr  7 22:11:56 kamailio-int /usr/local/sbin/kamailio[29717]: ERROR:
> usrloc [urecord.c:591]: insert_ucontact(): failed to insert in database
>
> Apr  7 22:11:56 kamailio-int /usr/local/sbin/kamailio[29717]: ERROR:
> registrar [save.c:522]: insert_contacts(): failed to insert contact
>
> My config
>
> # ----- usrloc params -----
>
> /* enable DB persistency for location entries */
>
> #!ifdef WITH_USRLOCDB
>
> modparam("usrloc", "db_url", DBURL)
>
> modparam("usrloc", "timer_interval", 60)
>
> modparam("usrloc", "db_mode", 1)
>
> modparam("usrloc", "db_timer_clean", 1)
>
> modparam("usrloc", "use_domain", MULTIDOMAIN)
>
> modparam("usrloc", "db_ops_ruid", 1)
>
> modparam("usrloc", "db_check_update", 1)
>
> #!endif
>
>
> I have been using it without any problems in other installations but in a
>  new one with 4. KAMAILIO im getting this error. I can see registrations on
> kamctl ul show but seems that option 1 is not working . Option 2 does not
> update registrations from that device.
>
> Thanks
>
>
> _______________________________________________
> 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 Mierlahttp://www.asipto.comhttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
> Kamailio World Conference, Berlin, May 18-20, 2016 - http://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/20160408/f88e1f01/attachment.html>