Re: [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@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 ,'dfjrewr12386fd6-...@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@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 ,'dfjrewr12386fd6-...@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@10.10.10.10:5060",
                       "Expires":  "permanent",
                       "Q":  1,
                       "Call-ID": "dfjrewr12386fd6-...@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@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users


_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users