Re: [SR-Users] Error in USERLOCDB

2016-04-11 Thread 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 >: > > Hello, > > it seems you created the location table a w

Re: [SR-Users] Error in USERLOCDB

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

Re: [SR-Users] Error in USERLOCDB

2016-04-07 Thread Daniel-Constantin Mierla
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

[SR-Users] Error in USERLOCDB

2016-04-07 Thread Alberto Sagredo
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]