[SR-Users] Error in USERLOCDB

[Daniel-Constantin Mierla]

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 at gmail.com
> <mailto:miconda at 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 at lists.sip-router.org <mailto:sr-users at 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 at lists.sip-router.org <mailto:sr-users at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20160411/050fd55a/attachment.html>