Re: [SR-Users] Kamailio 5.3.5, usrloc: Error inserting location (integer out of range)

Hmm, error getting the command parameter, run: VERBOSE=1 kamctl ul add 1234 sip:1234@10.10.10.10:5060 and you should see the jsonrpc command printed like: FIFO command was: {"jsonrpc": "2.0", ... Send it here to check it. Cheers, Daniel On 01.07.20 16:42, Stefan wrote: > Hello Daniel > > The kamailio.log shows me the following: > Jul  1 14:38:31 kamailio-srv02 /sbin/kamailio[3895]: ERROR: usrloc > [ul_rpc.c:625]: ul_rpc_add(): not enough parameters - read so far: -5 > > Regards > Stefan > > Am 01.07.20 um 15:03 schrieb Daniel-Constantin Mierla: >> Hello, >> >> so for the first case the error is actually in the postgres, the >> methods >> in the query is without sign. But looking at kamctl, it should be >> 0xffffffff (or -1). Needs some check in the db_postgres code. >> >> For the second case, the command without ending dots that is not >> working: can you look in the syslog file for error messages that >> contain: >> >> ... not enough parameters - read so far ... >> >> And paste them here to see how many parameters were sent over via rpc. >> >> Cheers, >> Daniel >> >> On 01.07.20 13:21, Stefan wrote: >>> Hi Daniel >>> >>> I got still the same error: >>> >>> kamctl ul add 1234 sip:1234@10.10.10.10:5060 . . >>> { >>>     "jsonrpc":  "2.0", >>>     "result": { >>>     }, >>>     "id": 1679 >>> } >>> >>> >>> Jul  1 11:14:20 kamailio-srv02 /sbin/kamailio[3892]: ERROR: >>> db_postgres [km_dbase.c:266]: db_postgres_submit_query(): >>> 0x7fbe5398c148 PQsendQuery Error: ERROR:  integer out of range#012 >>> Query: insert into location >>> (username,contact,expires,q,callid,cseq,flags,cflags,user_agent,methods,last_modified,ruid,reg_id,server_id,connection_id,keepalive,partition >>> >>> >>> ) values ('1234','sip:1234@10.10.10.10:5060','1970-01-01 >>> 00:00:00',1.000000 >>> ,&#39;dfjrewr12386fd6-343(a)kamailio.rpc&#39;,1,0,0,&#39;kamailio >>> SIP Router - RPC Server',2147483648,'1970-01-01 >>> 00:00:00','ulcx-5ef99724-f37-2',0,0,0,0,24) >>> >>> Btw: Why is the following not working? >>> >>> kamctl ul add 1234 sip:1234@10.10.10.10:5060 >>> { >>>     "jsonrpc":  "2.0", >>>     "error":  { >>>       "code": 500, >>>       "message":  "Not enough parameters or wrong format" >>>     }, >>>     "id": 1788 >>> } >>> >>> Usage says: >>> ul add <username> <uri> ............... introduce a permanent usrloc >>> entry >>> >>> Cheers, >>> Stefan >>> >>> Am 01.07.20 um 12:01 schrieb Daniel-Constantin Mierla: >>>> Hello, >>>> >>>> try with . (dot) instead of NULL, otherwise you give the string >>>> "NULL" >>>> as value. Like: >>>> >>>> kamctl ul add 1234 sip:1234@10.10.10.10:5060 . . >>>> >>>> Cheers, >>>> Daniel >>>> >>>> On 01.07.20 11:42, Stefan wrote: >>>>> Hi Maillist >>>>> >>>>> Kamailio-Version: 5.3.5 built from source with postgres-db. >>>>> I get an Error if I try to add a static location with kamctl, >>>>> see my >>>>> example: >>>>> >>>>> kamctl ul add 1234 sip:1234@10.10.10.10:5060 NULL NULL >>>>> >>>>> Log output: >>>>> Jul  1 09:28:20 kamailio-srv02 /sbin/kamailio[3892]: ERROR: >>>>> db_postgres [km_dbase.c:266]: db_postgres_submit_query(): >>>>> 0x7fbe5398c148 PQsendQuery Error: ERROR:  integer out of range#012 >>>>> Query: insert into location >>>>> (username,contact,expires,q,callid,cseq,flags,cflags,user_agent,path,methods,last_modified,ruid,reg_id,server_id,connection_id,keepalive,partition >>>>> >>>>> >>>>> >>>>> ) values ('1234','sip:1234@10.10.10.10:5060','1970-01-01 >>>>> 00:00:00',1.000000 >>>>> ,&#39;dfjrewr12386fd6-343(a)kamailio.rpc&#39;,1,0,0,&#39;kamailio >>>>> SIP Router - RPC Server','NULL',2147483648,'1970-01-01 >>>>> 00:00:00','ulcx-5ef99724-f37-1',0,0,0,0,22) >>>>> >>>>> truncated output of kamctl ul show: >>>>> >>>>> "AoRs": [{ >>>>>                  "Info": { >>>>>                    "AoR":  "1234", >>>>>                    "HashID": 924651761, >>>>>                    "Contacts": [{ >>>>>                        "Contact":  { >>>>>                          "Address":  "sip:1234@10.10.10.10:5060", >>>>>                          "Expires":  "permanent", >>>>>                          "Q":  1, >>>>>                          "Call-ID": >>>>> &quot;dfjrewr12386fd6-343(a)kamailio.rpc&quot;.rpc", >>>>>                          "CSeq": 1, >>>>>                          "User-Agent": "kamailio SIP Router - RPC >>>>> Server", >>>>>                          "Received": "[not set]", >>>>>                          "Path": "NULL", >>>>>                          "State":  "CS_NEW", >>>>>                          "Flags":  0, >>>>>                          "CFlags": 0, >>>>>                          "Socket": "[not set]", >>>>>                          "Methods":  -2147483648, >>>>>                          "Ruid": "ulcx-5ef99724-f37-1", >>>>>                          "Instance": "[not set]", >>>>>                          "Reg-Id": 0, >>>>>                          "Server-Id":  0, >>>>>                          "Tcpconn-Id": 0, >>>>>                          "Keepalive":  0, >>>>>                          "Last-Keepalive": 0, >>>>>                          "Last-Modified":  0 >>>>>                        } >>>>>                      }] >>>>>                  } >>>>>                }, { >>>>> >>>>> >>>>> So the log tells me: integer out of range. I think it's this one: >>>>> "Methods":  -2147483648, >>>>> This let's me thinking that this is a bug. >>>>> >>>>> Someone else? >>>>> >>>>> Regards >>>>> Stefan >>>>> >>>>> _______________________________________________ >>>>> Kamailio (SER) - Users Mailing List >>>>> sr-users(a)lists.kamailio.org >>>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users