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

Stefan sr.maillists at gmail.com
Wed Jul 1 11:42:14 CEST 2020


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



More information about the sr-users mailing list