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
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:
Thanks Daniel
That was exactly my issue. Solved!
2016-04-08 8:27 GMT+02:00 Daniel-Constantin Mierla miconda@gmail.com:
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
-
Alberto Sagredo -
Daniel-Constantin Mierla