<div dir="ltr">Thanks Daniel<br><div><br></div><div>That was exactly my issue. Solved!</div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-04-08 8:27 GMT+02:00 Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</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 href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a 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 href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a 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 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 href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a 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>