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

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@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 ,&#39;dfjrewr12386fd6-343(a)kamailio.rpc&#39;,1,0,0,&#39;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 >>> ,&#39;dfjrewr12386fd6-343(a)kamailio.rpc&#39;,1,0,0,&#39;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": >>> &quot;dfjrewr12386fd6-343(a)kamailio.rpc&quot;.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(a)lists.kamailio.org >>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users