<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<br>
<br>
<div class="moz-cite-prefix">On 08/04/16 08:43, Alberto Sagredo
wrote:<br>
</div>
<blockquote
cite="mid:CADqf3zC6B2KAq8Xiqk8iUrQyqqUz3QH=E0pAvUf-r=GwLrSbZA@mail.gmail.com"
type="cite">
<div dir="ltr">Thanks Daniel<br>
<div><br>
</div>
<div>That was exactly my issue. Solved!</div>
</div>
</blockquote>
Welcome, good it was sorted out quickly!<br>
<br>
Daniel<br>
<blockquote
cite="mid:CADqf3zC6B2KAq8Xiqk8iUrQyqqUz3QH=E0pAvUf-r=GwLrSbZA@mail.gmail.com"
type="cite">
<div class="gmail_extra"><br>
<div class="gmail_quote">2016-04-08 8:27 GMT+02:00
Daniel-Constantin Mierla <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:miconda@gmail.com"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:miconda@gmail.com">miconda@gmail.com</a></a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Hello,<br>
<br>
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:<br>
<br>
utils/kamctl/mysql/usrloc-create.sql<br>
<br>
Cheers,<br>
Daniel
<div>
<div class="h5"><br>
<br>
<div>On 07/04/16 22:20, Alberto Sagredo wrote:<br>
</div>
</div>
</div>
<blockquote type="cite">
<div>
<div class="h5">
<div dir="ltr">Im getting this error using USERLOCDB
<div><br>
</div>
<div>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><span>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)</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><span>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</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><span>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)</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><span>Apr
7 22:11:56 kamailio-int
/usr/local/sbin/kamailio[29717]: ERROR:
usrloc [urecord.c:591]: insert_ucontact():
failed to insert in database</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><span>Apr
7 22:11:56 kamailio-int
/usr/local/sbin/kamailio[29717]: ERROR:
registrar [save.c:522]: insert_contacts():
failed to insert contact</span></p>
<div><br>
</div>
<div>My config </div>
<div><br>
</div>
<div>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><span>#
----- usrloc params -----</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><span>/*
enable DB persistency for location entries
*/</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><span>#!ifdef
WITH_USRLOCDB </span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><span>modparam("usrloc",
"db_url", DBURL)</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><span>modparam("usrloc",
"timer_interval", 60)</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><span>modparam("usrloc",
"db_mode", 1)</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><span>modparam("usrloc",
"db_timer_clean", 1)</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><span>modparam("usrloc",
"use_domain", MULTIDOMAIN)</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><span>modparam("usrloc",
"db_ops_ruid", 1)</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><span>modparam("usrloc",
"db_check_update", 1)</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><span>#!endif</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;min-height:13px"><span> </span></p>
<div>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. </div>
</div>
</div>
<div><br>
</div>
<div>Thanks</div>
</div>
<br>
<fieldset></fieldset>
<br>
</div>
</div>
<pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a moz-do-not-send="true" href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a moz-do-not-send="true" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><span class="HOEnZb"><font color="#888888">
</font></span></pre>
<span class="HOEnZb"><font color="#888888"> </font></span></blockquote>
<span class="HOEnZb"><font color="#888888"> <br>
<pre cols="72">--
Daniel-Constantin Mierla
<a moz-do-not-send="true" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a moz-do-not-send="true" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference, Berlin, May 18-20, 2016 - <a moz-do-not-send="true" href="http://www.kamailioworld.com" target="_blank">http://www.kamailioworld.com</a></pre>
</font></span></div>
<br>
_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users
mailing list<br>
<a moz-do-not-send="true"
href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a moz-do-not-send="true"
href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users"
rel="noreferrer" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference, Berlin, May 18-20, 2016 - <a class="moz-txt-link-freetext" href="http://www.kamailioworld.com">http://www.kamailioworld.com</a></pre>
</body>
</html>