<div dir="ltr"><div dir="ltr">Hey thanks!!<div><br></div><div>not working, but i'm finally getting some useful erros:</div><div><br></div><div><div>Oct 31 13:22:52 sip2 /usr/sbin/kamailio[1326]: DEBUG: jsonrpcs [jsonrpcs_fifo.c:449]: jsonrpc_fifo_server(): preparing to execute fifo jsonrpc [{"jsonrpc": "2.0", "method": "ul.add", "params": ["location", "<a href="mailto:361119997@sip2.domain.com">361119997@sip2.domain.com</a>", "<a href="mailto:sip%3A361119997@4.3.2.1">sip:361119997@4.3.2.1</a>", 3600, 1, "sip:<a href="http://4.3.2.1:5060">4.3.2.1:5060</a>", 0, 0, 13279, ".", "."], "reply_name": "kamailio_receiver_2583", "id": 2583}]</div><div>Oct 31 13:22:52 sip2 /usr/sbin/kamailio[1326]: DEBUG: usrloc [ul_rpc.c:573]: ul_rpc_add(): ret: 9 table:location <a href="mailto:aor%3A361119997@sip2.hayo.sn">aor:361119997@sip2.hayo.sn</a> <a href="mailto:contact%3Asip%3A361119997@4.3.2.1">contact:sip:361119997@4.3.2.1</a> expires:3600 dtemp:1.000000 path:sip:<a href="http://4.3.2.1:5060">4.3.2.1:5060</a> flags:0 bflags:0 methods:13279</div><div>Oct 31 13:22:52 sip2 /usr/sbin/kamailio[1326]: DEBUG: usrloc [ul_rpc.c:580]: ul_rpc_add(): q:1</div><div>Oct 31 13:22:52 sip2 /usr/sbin/kamailio[1326]: DEBUG: <core> [sruid.c:183]: sruid_next(): new sruid is [ulcx-5bd9ddde-525-a] (10 / 19)</div><div>Oct 31 13:22:52 sip2 /usr/sbin/kamailio[1326]: ERROR: <core> [db.c:452]: db_use_table(): invalid parameter value</div><div>Oct 31 13:22:52 sip2 /usr/sbin/kamailio[1326]: ERROR: usrloc [udomain.c:631]: db_load_urecord(): failed to use table location</div><div>Oct 31 13:22:52 sip2 /usr/sbin/kamailio[1326]: ERROR: <core> [db.c:452]: db_use_table(): invalid parameter value</div><div>Oct 31 13:22:52 sip2 /usr/sbin/kamailio[1326]: ERROR: usrloc [ucontact.c:678]: db_insert_ucontact(): sql use_table failed</div><div>Oct 31 13:22:52 sip2 /usr/sbin/kamailio[1326]: ERROR: usrloc [urecord.c:582]: insert_ucontact(): failed to insert in database</div><div>Oct 31 13:22:52 sip2 /usr/sbin/kamailio[1326]: DEBUG: jsonrpcs [jsonrpcs_mod.c:395]: jsonrpc_send(): sending response with body: (nil) - 500 Can't insert contact</div><div>Oct 31 13:22:52 sip2 /usr/sbin/kamailio[1326]: DEBUG: jsonrpcs [jsonrpcs_fifo.c:461]: jsonrpc_fifo_server(): command executed - result: [kamailio_receiver_2583] [500] [0x143dd50] [{#012#011"jsonrpc":#011"2.0",#012#011"error":#0</div></div><div><br></div><div><br></div><div><br clear="all"><div><div dir="ltr" class="gmail_signature"><div dir="ltr"><div>Regards,</div><div><br></div>David Villasmil<div>email: <a href="mailto:david.villasmil.work@gmail.com" target="_blank">david.villasmil.work@gmail.com</a></div><div>phone: +34669448337</div></div></div></div><br></div></div></div><div hspace="streak-pt-mark" style="max-height:1px"><img alt="" style="width:0px;max-height:0px;overflow:hidden" src="https://mailfoogae.appspot.com/t?sender=aZGF2aWQudmlsbGFzbWlsLndvcmtAZ21haWwuY29t&type=zerocontent&guid=df6a6477-4e9a-419e-b88e-b63a3ddde3a5"><font color="#ffffff" size="1">ᐧ</font></div><br><div class="gmail_quote"><div dir="ltr">On Wed, Oct 31, 2018 at 6:14 PM Joel Serrano <<a href="mailto:joel@textplus.com">joel@textplus.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr">Hi David,<div><br></div><div>Sorry for the delay.. You are missing parameters:</div><div><br></div><div><div>root@sbc02:~# kamctl rpc ul.add location <a href="mailto:361119997@m.domain.com" target="_blank">361119997@m.domain.com</a> <a href="mailto:sip%3A361119997@4.3.2.1" target="_blank">sip:361119997@4.3.2.1</a> 3600 1 sip:<a href="http://4.3.2.1:5060" target="_blank">4.3.2.1:5060</a></div><div>{</div><div> "jsonrpc": "2.0",</div><div> "error": {</div><div> "code": 500,</div><div> "message": "Not enough parameters or wrong format"</div><div> },</div><div> "id": 31201</div><div>}</div><div>root@sbc02:~#</div></div><div><br></div><div><div>root@sbc02:~# kamctl rpc ul.add location <a href="mailto:361119997@m.domain.com" target="_blank">361119997@m.domain.com</a> <a href="mailto:sip%3A361119997@4.3.2.1" target="_blank">sip:361119997@4.3.2.1</a> 3600 1 sip:<a href="http://4.3.2.1:5060" target="_blank">4.3.2.1:5060</a> 0 0 13279 . .</div><div>{</div><div> "jsonrpc": "2.0",</div><div> "result": {</div><div> },</div><div> "id": 31249</div><div>}</div><div>root@sbc02:~#</div></div><div><br></div><div><div>root@sbc02:~# kamctl rpc ul.dump</div><div>{</div><div> "jsonrpc": "2.0",</div><div> "result": {</div><div> "Domains": [{</div><div> "Domain": {</div><div> "Domain": "location",</div><div> "Size": 1024,</div><div> "AoRs": [{</div><div> "Info": {</div><div> "AoR": "361119997",</div><div> "HashID": 1820329880,</div><div> "Contacts": [{</div><div> "Contact": {</div><div> "Address": "<a href="mailto:sip%3A361119997@4.3.2.1" target="_blank">sip:361119997@4.3.2.1</a>",</div><div> "Expires": 3592,</div><div> "Q": 1,</div><div> "Call-ID": "dfjrewr12386fd6-343@kamailio.rpc",</div><div> "CSeq": 1,</div><div> "User-Agent": "kamailio SIP Router - RPC Server",</div><div> "Received": "[not set]",</div><div> "Path": "sip:<a href="http://4.3.2.1:5060" target="_blank">4.3.2.1:5060</a>",</div><div> "State": "CS_SYNC",</div><div> "Flags": 0,</div><div> "CFlags": 0,</div><div> "Socket": "[not set]",</div><div> "Methods": 13279,</div><div> "Ruid": "ulcx-5bd875a3-712-1",</div><div> "Instance": "[not set]",</div><div> "Reg-Id": 0,</div><div> "Server-Id": 0,</div><div> "Tcpconn-Id": 0,</div><div> "Keepalive": 0,</div><div> "Last-Keepalive": 0,</div><div> "Last-Modified": 0</div><div> }</div><div> }]</div><div> }</div><div> }</div><div> ],</div><div> "Stats": {</div><div> "Records": 1,</div><div> "Max-Slots": 1</div><div> }</div><div> }</div><div> }]</div><div> },</div><div> "id": 31347</div><div>}</div><div>root@sbc02:~#</div></div><div><br></div><div><br></div><div>More info:</div><div><a href="https://kamailio.org/docs/modules/5.1.x/modules/usrloc.html#usrloc.r.add" target="_blank">https://kamailio.org/docs/modules/5.1.x/modules/usrloc.html#usrloc.r.add</a><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div></div></div></div></div></div><br><div class="gmail_quote"><div dir="ltr">On Wed, Oct 31, 2018 at 10:05 AM David Villasmil <<a href="mailto:david.villasmil.work@gmail.com" target="_blank">david.villasmil.work@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Ok, I checked my config and i had <div><br></div><div>save("location","0x01")</div><div><br></div><div>which disables saving the location in db, now when i register i see the location in the table...</div><div>But i still can't add a location:</div><div><br></div><div>Some help would be appreciated!</div><div><br></div><div>David</div><div><br></div><div><br clear="all"><div><div dir="ltr" class="m_-9214728586186840486m_6569929570703909467gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div>Regards,</div><div><br></div>David Villasmil<div>email: <a href="mailto:david.villasmil.work@gmail.com" target="_blank">david.villasmil.work@gmail.com</a></div><div>phone: +34669448337</div></div></div></div><br></div></div><div hspace="streak-pt-mark" style="max-height:1px"><img alt="" style="width:0px;max-height:0px;overflow:hidden" src="https://mailfoogae.appspot.com/t?sender=aZGF2aWQudmlsbGFzbWlsLndvcmtAZ21haWwuY29t&type=zerocontent&guid=32dc6bd4-3a7b-4ba4-a8c5-04c9fa5f5422"><font color="#ffffff" size="1">ᐧ</font></div><br><div class="gmail_quote"><div dir="ltr">On Wed, Oct 31, 2018 at 3:22 PM David Villasmil <<a href="mailto:david.villasmil.work@gmail.com" target="_blank">david.villasmil.work@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello all,<div><br></div><div>I'm trying to add a permanent location.</div><div><br></div><div>i’m using db_mode 1, use_domain = 1, i tried that command</div><div><br></div><div>kamctl rpc ul.add location <a href="mailto:361119997@m.domain.com" target="_blank">361119997@m.domain.com</a> <a href="mailto:sip%3A361119997@4.3.2.1" target="_blank">sip:361119997@4.3.2.1</a> 3600 0 sip:<a href="http://4.3.2.1:5060" target="_blank">4.3.2.1:5060</a></div><div><br></div><div><br></div><div>Response is:</div><div><br></div><div>{<br> "jsonrpc": "2.0",<br> "error": {<br> "code": -32000,<br> "message": "Execution Error"<br> },<br> "id": 25950<br>}<br></div><div><br></div><div><br></div><div>Anyone knows what this might be?</div><div><br></div><div>David</div>
</blockquote></div>
_______________________________________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a><br>
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br>
</blockquote></div>
_______________________________________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a><br>
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br>
</blockquote></div>