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:[email protected]: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:[email protected]:5060','1970-01-01 00:00:00',1.000000 ,'[email protected]',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:[email protected]: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:[email protected]: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:[email protected]: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:[email protected]:5060','1970-01-01 00:00:00',1.000000 ,'[email protected]',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:[email protected]:5060", "Expires": "permanent", "Q": 1, "Call-ID": "[email protected]", "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 [email protected] https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
_______________________________________________ Kamailio (SER) - Users Mailing List [email protected] https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
