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

[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