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 -- Daniel-Constantin Mierla -- www.asipto.com www.twitter.com/miconda -- www.linkedin.com/in/miconda Funding: https://www.paypal.me/dcmierla _______________________________________________ Kamailio (SER) - Users Mailing List [email protected] https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
