Re: [SR-Users] Error in USERLOCDB

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 <miconda@gmail.com mailto:miconda@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