Thanks Daniel That was exactly my issue. Solved!
2016-04-08 8:27 GMT+02:00 Daniel-Constantin Mierla <mico...@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-us...@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@lists.sip-router.org > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users > >
_______________________________________________ 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