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

[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