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

Daniel-Constantin Mierla miconda at gmail.com
Thu Jul 2 09:59:01 CEST 2020


Hello,

can you try with latest git branch 5.3 -- I pushed some commits there
trying to address both issues. I don't have any postgres around to test,
but ul add without dots should work now.

Cheers,
Daniel

On 01.07.20 17:06, Stefan wrote:
> Hi Daniel
>
> Verbose reply is (I changed the domain):
>
> -e FIFO command was:
> {"jsonrpc": "2.0", "method": "ul.add", "params": ["location",
> "1234 at my.domain.com", "sip:1234 at 10.10.10.10:5060", 0, 1.0, 0, 0, 0,
> 4294967295], "reply_name": "kamailio_receiver_3949", "id": 3949}
>
> Stefan
>
> Am 01.07.20 um 16:53 schrieb Daniel-Constantin Mierla:
>> Hmm, error getting the command parameter, run:
>>
>> VERBOSE=1 kamctl ul add 1234 sip:1234 at 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 at 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 at 10.10.10.10:5060','1970-01-01
>>>>> 00:00:00',1.000000
>>>>> ,'dfjrewr12386fd6-343 at kamailio.rpc',1,0,0,'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 at 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 at 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 at 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 at 10.10.10.10:5060','1970-01-01
>>>>>>> 00:00:00',1.000000
>>>>>>> ,'dfjrewr12386fd6-343 at kamailio.rpc',1,0,0,'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 at 10.10.10.10:5060",
>>>>>>>                          "Expires":  "permanent",
>>>>>>>                          "Q":  1,
>>>>>>>                          "Call-ID":
>>>>>>> "dfjrewr12386fd6-343 at kamailio.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 at lists.kamailio.org
>>>>>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
-- 
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Funding: https://www.paypal.me/dcmierla




More information about the sr-users mailing list