On 08/04/16 08:43, Alberto Sagredo wrote: > Thanks Daniel > > That was exactly my issue. Solved! Welcome, good it was sorted out quickly!
Daniel > > 2016-04-08 8:27 GMT+02:00 Daniel-Constantin Mierla <mico...@gmail.com > <mailto: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 list >> sr-users@lists.sip-router.org <mailto: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://twitter.com/#%21/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 <mailto: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
