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

[Stefan]

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