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@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@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
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@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@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@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
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@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@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@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@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
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 ,'dfjrewr12386fd6-343@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@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@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@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Hello Daniel
The kamailio.log shows me the following: Jul 1 14:38:31 kamailio-srv02 /sbin/kamailio[3895]: ERROR: usrloc [ul_rpc.c:625]: ul_rpc_add(): not enough parameters - read so far: -5
Regards Stefan
Am 01.07.20 um 15:03 schrieb Daniel-Constantin Mierla:
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 ,'dfjrewr12386fd6-343@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@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@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@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Hmm, error getting the command parameter, run:
VERBOSE=1 kamctl ul add 1234 sip:1234@10.10.10.10:5060
and you should see the jsonrpc command printed like:
FIFO command was: {"jsonrpc": "2.0", ...
Send it here to check it.
Cheers, Daniel
On 01.07.20 16:42, Stefan wrote:
Hello Daniel
The kamailio.log shows me the following: Jul 1 14:38:31 kamailio-srv02 /sbin/kamailio[3895]: ERROR: usrloc [ul_rpc.c:625]: ul_rpc_add(): not enough parameters - read so far: -5
Regards Stefan
Am 01.07.20 um 15:03 schrieb Daniel-Constantin Mierla:
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 ,'dfjrewr12386fd6-343@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@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@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@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Hi Daniel
Verbose reply is (I changed the domain):
-e FIFO command was: {"jsonrpc": "2.0", "method": "ul.add", "params": ["location", "1234@my.domain.com", "sip:1234@10.10.10.10:5060", 0, 1.0, 0, 0, 0, 4294967295], "reply_name": "kamailio_receiver_3949", "id": 3949}
Stefan
Am 01.07.20 um 16:53 schrieb Daniel-Constantin Mierla:
Hmm, error getting the command parameter, run:
VERBOSE=1 kamctl ul add 1234 sip:1234@10.10.10.10:5060
and you should see the jsonrpc command printed like:
FIFO command was: {"jsonrpc": "2.0", ...
Send it here to check it.
Cheers, Daniel
On 01.07.20 16:42, Stefan wrote:
Hello Daniel
The kamailio.log shows me the following: Jul 1 14:38:31 kamailio-srv02 /sbin/kamailio[3895]: ERROR: usrloc [ul_rpc.c:625]: ul_rpc_add(): not enough parameters - read so far: -5
Regards Stefan
Am 01.07.20 um 15:03 schrieb Daniel-Constantin Mierla:
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 ,'dfjrewr12386fd6-343@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@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@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@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Hello,
can you try with latest git branch 5.3 -- I pushed some commits there trying to address both issues. I don't have any postgres around to test, but ul add without dots should work now.
Cheers, Daniel
On 01.07.20 17:06, Stefan wrote:
Hi Daniel
Verbose reply is (I changed the domain):
-e FIFO command was: {"jsonrpc": "2.0", "method": "ul.add", "params": ["location", "1234@my.domain.com", "sip:1234@10.10.10.10:5060", 0, 1.0, 0, 0, 0, 4294967295], "reply_name": "kamailio_receiver_3949", "id": 3949}
Stefan
Am 01.07.20 um 16:53 schrieb Daniel-Constantin Mierla:
Hmm, error getting the command parameter, run:
VERBOSE=1 kamctl ul add 1234 sip:1234@10.10.10.10:5060
and you should see the jsonrpc command printed like:
FIFO command was: {"jsonrpc": "2.0", ...
Send it here to check it.
Cheers, Daniel
On 01.07.20 16:42, Stefan wrote:
Hello Daniel
The kamailio.log shows me the following: Jul 1 14:38:31 kamailio-srv02 /sbin/kamailio[3895]: ERROR: usrloc [ul_rpc.c:625]: ul_rpc_add(): not enough parameters - read so far: -5
Regards Stefan
Am 01.07.20 um 15:03 schrieb Daniel-Constantin Mierla:
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 ,'dfjrewr12386fd6-343@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@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@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@lists.kamailio.org > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Hi Daniel
Thanks for your fast replies! I'm sorry, I'm not able to test the latest branch today, because it's a productive system and I am away next two weeks. But I will do as soon as I'm back or I am going to upgrade directly to 5.4 when it is released.
Regards Stefan
Am 02.07.20 um 09:59 schrieb Daniel-Constantin Mierla:
Hello,
can you try with latest git branch 5.3 -- I pushed some commits there trying to address both issues. I don't have any postgres around to test, but ul add without dots should work now.
Cheers, Daniel
On 01.07.20 17:06, Stefan wrote:
Hi Daniel
Verbose reply is (I changed the domain):
-e FIFO command was: {"jsonrpc": "2.0", "method": "ul.add", "params": ["location", "1234@my.domain.com", "sip:1234@10.10.10.10:5060", 0, 1.0, 0, 0, 0, 4294967295], "reply_name": "kamailio_receiver_3949", "id": 3949}
Stefan
Am 01.07.20 um 16:53 schrieb Daniel-Constantin Mierla:
Hmm, error getting the command parameter, run:
VERBOSE=1 kamctl ul add 1234 sip:1234@10.10.10.10:5060
and you should see the jsonrpc command printed like:
FIFO command was: {"jsonrpc": "2.0", ...
Send it here to check it.
Cheers, Daniel
On 01.07.20 16:42, Stefan wrote:
Hello Daniel
The kamailio.log shows me the following: Jul 1 14:38:31 kamailio-srv02 /sbin/kamailio[3895]: ERROR: usrloc [ul_rpc.c:625]: ul_rpc_add(): not enough parameters - read so far: -5
Regards Stefan
Am 01.07.20 um 15:03 schrieb Daniel-Constantin Mierla:
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 ,'dfjrewr12386fd6-343@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@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@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@lists.kamailio.org >> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
-
Daniel-Constantin Mierla -
Stefan