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@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

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users