1 Jul
2020
1 Jul
'20
2:21 p.m.
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-343(a)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-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