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

[Stefan]

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