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