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-343(a)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-343(a)kamailio.rpc".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