[SR-Users] Error in USERLOCDB

[Daniel-Constantin Mierla]

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

-- 
Daniel-Constantin Mierla
http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, Berlin, May 18-20, 2016 - http://www.kamailioworld.com

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