<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hello,</p>
<p>that file you get with wget is sort of schema definition, but
doesn't have to be imported in mongo. Delete it, only Kamailio
should insert into location table.</p>
<p>Cheers,<br>
Daniel<br>
</p>
<br>
<div class="moz-cite-prefix">On 05.11.18 16:23, Denys Pozniak wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CA+x3AxpqQNr=cW4T3OCGn_yf0WsqjWsnBC6ppDBEw08y17zbNQ@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">My steps:
<div>1) wget <a
href="https://raw.githubusercontent.com/kamailio/kamailio/master/utils/kamctl/mongodb/kamailio/location.json"
moz-do-not-send="true">https://raw.githubusercontent.com/kamailio/kamailio/master/utils/kamctl/mongodb/kamailio/location.json</a><br>
</div>
<div>
<div><br>
</div>
<div>2) [root@mongodb-1 root]#
mongoimport --db test --collection location
--file location.json -vvvv</div>
</div>
</div>
</div>
</div>
<blockquote style="margin:0px 0px 0px
40px;border:none;padding:0px">
<div>
<div>
<div>
<div>
<div>2018-11-05T16:17:30.422+0100 using 1
decoding workers</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:17:30.422+0100 using 1
insert workers</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:17:30.423+0100 filesize:
2131 bytes</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:17:30.423+0100 using
fields:</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:17:30.424+0100 will
listen for SIGTERM, SIGINT, and SIGKILL</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:17:30.428+0100 connected
to: localhost</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:17:30.428+0100 ns:
test.location</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:17:30.428+0100 connected
to node type: replset</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:17:30.428+0100 using
write concern: w='majority', j=false,
fsync=false, wtimeout=0</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:17:30.428+0100 using
write concern: w='majority', j=false,
fsync=false, wtimeout=0</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:17:30.428+0100 Failed:
error processing document #1: invalid
character ':' after array element</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:17:30.428+0100 imported
0 documents</div>
</div>
</div>
</div>
</div>
</blockquote>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div><br>
</div>
<div>3) Tested with JSON validator and the same:</div>
<div><br>
</div>
<h3 style="margin:0px 0px
10px;padding:0px;box-sizing:border-box;vertical-align:top;font-size:1.3em;color:rgb(51,51,51);font-family:"Open
Sans","Helvetica
Neue",Helvetica,Arial,sans-serif;background-color:rgb(250,251,252)">Results</h3>
<pre id="gmail-result" class="error" style="margin-top:1.6em;margin-bottom:1.6em;padding:0.8em;box-sizing:border-box;vertical-align:top;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:0.95em;line-height:1.5;font-family:"andale mono",monotype,"lucida console",monospace;border:1px solid rgb(251,194,196);background:rgb(251,227,228);color:rgb(209,47,25)">Error: Parse error on line 5:
... "columns": [ "id": { "type": "int"
----------------------^ </pre>
<div><span
style="background-color:rgb(251,227,228);color:rgb(209,47,25);font-family:"andale
mono",monotype,"lucida
console",monospace;font-size:0.95em">Expecting
'EOF', '}', ',', ']', got ':'</span></div>
<div><br>
</div>
<div>4) Changed manually</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<blockquote style="margin:0 0 0 40px;border:none;padding:0px">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div>"columns": [ --> "columns": { </div>
<div> ] -- > }</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div><br>
</div>
<div>5) [root@mongodb-1 root]# mongoimport
--db test --collection location --file
location.json -vvvv</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<blockquote style="margin:0 0 0 40px;border:none;padding:0px">
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:21:11.454+0100 using 1
decoding workers</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:21:11.455+0100 using 1
insert workers</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:21:11.455+0100 filesize:
2132 bytes</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:21:11.456+0100 using
fields:</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:21:11.456+0100 will listen
for SIGTERM, SIGINT, and SIGKILL</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:21:11.460+0100 connected
to: localhost</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:21:11.460+0100 ns:
test.location</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:21:11.461+0100 connected
to node type: replset</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:21:11.461+0100 using write
concern: w='majority', j=false, fsync=false,
wtimeout=0</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:21:11.461+0100 using write
concern: w='majority', j=false, fsync=false,
wtimeout=0</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:21:11.463+0100 got line:
[{name location} {version 9} {columns [{id
[{type int} {default <nil>} {null
false}]} {ruid [{type string} {default } {null
false}]} {username [{type string} {default }
{null false}]} {domain [{type string} {default
<nil>} {null true}]} {contact [{type
string} {default } {null false}]} {received
[{type string} {default <nil>} {null
true}]} {path [{type string} {default
<nil>} {null true}]} {expires [{type
datetime} {default 2030-05-28 21:32:15} {null
false}]} {q [{type double} {default 1} {null
false}]} {callid [{type string} {default
Default-Call-ID} {null false}]} {cseq [{type
int} {default 1} {null false}]} {last_modified
[{type datetime} {default 2000-01-01 00:00:01}
{null false}]} {flags [{type int} {default 0}
{null false}]} {cflags [{type int} {default 0}
{null false}]} {user_agent [{type string}
{default } {null false}]} {socket [{type
string} {default <nil>} {null true}]}
{methods [{type int} {default <nil>}
{null true}]} {instance [{type string}
{default <nil>} {null true}]} {reg_id
[{type int} {default 0} {null false}]}
{server_id [{type int} {default 0} {null
false}]} {connection_id [{type int} {default
0} {null false}]} {keepalive [{type int}
{default 0} {null false}]} {partition [{type
int} {default 0} {null false}]}]}]</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:21:11.464+0100 got
extended line:
bson.D{bson.DocElem{Name:"name",
Value:"location"},
bson.DocElem{Name:"version", Value:9},
bson.DocElem{Name:"columns",
Value:bson.D{bson.DocElem{Name:"id",
Value:bson.D{bson.DocElem{Name:"type",
Value:"int"}, bson.DocElem{Name:"default",
Value:interface {}(nil)},
bson.DocElem{Name:"null", Value:false}}},
bson.DocElem{Name:"ruid",
Value:bson.D{bson.DocElem{Name:"type",
Value:"string"}, bson.DocElem{Name:"default",
Value:""}, bson.DocElem{Name:"null",
Value:false}}}, bson.DocElem{Name:"username",
Value:bson.D{bson.DocElem{Name:"type",
Value:"string"}, bson.DocElem{Name:"default",
Value:""}, bson.DocElem{Name:"null",
Value:false}}}, bson.DocElem{Name:"domain",
Value:bson.D{bson.DocElem{Name:"type",
Value:"string"}, bson.DocElem{Name:"default",
Value:interface {}(nil)},
bson.DocElem{Name:"null", Value:true}}},
bson.DocElem{Name:"contact",
Value:bson.D{bson.DocElem{Name:"type",
Value:"string"}, bson.DocElem{Name:"default",
Value:""}, bson.DocElem{Name:"null",
Value:false}}}, bson.DocElem{Name:"received",
Value:bson.D{bson.DocElem{Name:"type",
Value:"string"}, bson.DocElem{Name:"default",
Value:interface {}(nil)},
bson.DocElem{Name:"null", Value:true}}},
bson.DocElem{Name:"path",
Value:bson.D{bson.DocElem{Name:"type",
Value:"string"}, bson.DocElem{Name:"default",
Value:interface {}(nil)},
bson.DocElem{Name:"null", Value:true}}},
bson.DocElem{Name:"expires",
Value:bson.D{bson.DocElem{Name:"type",
Value:"datetime"},
bson.DocElem{Name:"default", Value:"2030-05-28
21:32:15"}, bson.DocElem{Name:"null",
Value:false}}}, bson.DocElem{Name:"q",
Value:bson.D{bson.DocElem{Name:"type",
Value:"double"}, bson.DocElem{Name:"default",
Value:1}, bson.DocElem{Name:"null",
Value:false}}}, bson.DocElem{Name:"callid",
Value:bson.D{bson.DocElem{Name:"type",
Value:"string"}, bson.DocElem{Name:"default",
Value:"Default-Call-ID"},
bson.DocElem{Name:"null", Value:false}}},
bson.DocElem{Name:"cseq",
Value:bson.D{bson.DocElem{Name:"type",
Value:"int"}, bson.DocElem{Name:"default",
Value:1}, bson.DocElem{Name:"null",
Value:false}}},
bson.DocElem{Name:"last_modified",
Value:bson.D{bson.DocElem{Name:"type",
Value:"datetime"},
bson.DocElem{Name:"default", Value:"2000-01-01
00:00:01"}, bson.DocElem{Name:"null",
Value:false}}}, bson.DocElem{Name:"flags",
Value:bson.D{bson.DocElem{Name:"type",
Value:"int"}, bson.DocElem{Name:"default",
Value:0}, bson.DocElem{Name:"null",
Value:false}}}, bson.DocElem{Name:"cflags",
Value:bson.D{bson.DocElem{Name:"type",
Value:"int"}, bson.DocElem{Name:"default",
Value:0}, bson.DocElem{Name:"null",
Value:false}}},
bson.DocElem{Name:"user_agent",
Value:bson.D{bson.DocElem{Name:"type",
Value:"string"}, bson.DocElem{Name:"default",
Value:""}, bson.DocElem{Name:"null",
Value:false}}}, bson.DocElem{Name:"socket",
Value:bson.D{bson.DocElem{Name:"type",
Value:"string"}, bson.DocElem{Name:"default",
Value:interface {}(nil)},
bson.DocElem{Name:"null", Value:true}}},
bson.DocElem{Name:"methods",
Value:bson.D{bson.DocElem{Name:"type",
Value:"int"}, bson.DocElem{Name:"default",
Value:interface {}(nil)},
bson.DocElem{Name:"null", Value:true}}},
bson.DocElem{Name:"instance",
Value:bson.D{bson.DocElem{Name:"type",
Value:"string"}, bson.DocElem{Name:"default",
Value:interface {}(nil)},
bson.DocElem{Name:"null", Value:true}}},
bson.DocElem{Name:"reg_id",
Value:bson.D{bson.DocElem{Name:"type",
Value:"int"}, bson.DocElem{Name:"default",
Value:0}, bson.DocElem{Name:"null",
Value:false}}}, bson.DocElem{Name:"server_id",
Value:bson.D{bson.DocElem{Name:"type",
Value:"int"}, bson.DocElem{Name:"default",
Value:0}, bson.DocElem{Name:"null",
Value:false}}},
bson.DocElem{Name:"connection_id",
Value:bson.D{bson.DocElem{Name:"type",
Value:"int"}, bson.DocElem{Name:"default",
Value:0}, bson.DocElem{Name:"null",
Value:false}}}, bson.DocElem{Name:"keepalive",
Value:bson.D{bson.DocElem{Name:"type",
Value:"int"}, bson.DocElem{Name:"default",
Value:0}, bson.DocElem{Name:"null",
Value:false}}}, bson.DocElem{Name:"partition",
Value:bson.D{bson.DocElem{Name:"type",
Value:"int"}, bson.DocElem{Name:"default",
Value:0}, bson.DocElem{Name:"null",
Value:false}}}}}}</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>2018-11-05T16:21:11.603+0100 imported 1
document</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div><br>
</div>
<div>
<div>[root@mongodb-1 root]# mongo --version</div>
<div>MongoDB shell version v3.4.10</div>
<div>git version:
078f28920cb24de0dd479b5ea6c66c644f6326e9</div>
<div>OpenSSL version: OpenSSL 1.0.1e-fips 11 Feb
2013</div>
<div>allocator: tcmalloc</div>
<div>modules: none</div>
<div>build environment:</div>
<div> distmod: rhel70</div>
<div> distarch: x86_64</div>
<div> target_arch: x86_64</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr">пн, 5 нояб. 2018 г. в 16:55, Daniel-Constantin
Mierla <<a href="mailto:miconda@gmail.com"
moz-do-not-send="true">miconda@gmail.com</a>>:<br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<p>Hello,</p>
<p>how was the record (json document) inserted in the
location table? It doesn't seem to have valid values...</p>
<p>Cheers,<br>
Daniel<br>
</p>
<br>
<div class="m_6422593769911831472moz-cite-prefix">On
05.11.18 13:13, Denys Pozniak wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div>Hello!</div>
<div><br>
</div>
<div>I want to keep user location in
mongodb, but Kamailio does not start
well.</div>
<div><br>
</div>
<div>Configuration:<br>
</div>
<div><br>
</div>
<div>loadmodule "usrloc.so"<br>
</div>
<div>
<div>loadmodule "db_mongodb.so"</div>
<div>modparam("usrloc",
"db_insert_null", 1)</div>
<div>modparam("usrloc", "db_url",
"mongodb://mongodb.test/kamailio")</div>
</div>
<div>
<div>modparam("usrloc", "db_mode", 2)<br>
</div>
<div>modparam("usrloc",
"timer_interval", 30)<br>
</div>
<div>modparam("usrloc",
"desc_time_order", 1)<br>
</div>
<div><br>
</div>
</div>
<div><br>
</div>
<div>
<div>Mongodb:</div>
<div><br>
</div>
<div>
<div>rs0:PRIMARY> use kamailio</div>
<div>switched to db kamailio</div>
</div>
<div>rs0:PRIMARY> db.location.find()<br>
</div>
<div>
<div>{ "_id" :
ObjectId("5be024d6b9d8febf4ae19681"),
"name" : "location", "version" : 9,
"columns" : { "id" : { "type" :
"int", "default" : null, "null" :
false }, "ruid" : { "type" :
"string", "default" : "", "null" :
false }, "username" : { "type" :
"string", "default" : "", "null" :
false }, "domain" : { "type" :
"string", "default" : null, "null" :
true }, "contact" : { "type" :
"string", "default" : "", "null" :
false }, "received" : { "type" :
"string", "default" : null, "null" :
true }, "path" : { "type" :
"string", "default" : null, "null" :
true }, "expires" : { "type" :
"datetime", "default" : "2030-05-28
21:32:15", "null" : false }, "q" : {
"type" : "double", "default" : 1,
"null" : false }, "callid" : {
"type" : "string", "default" :
"Default-Call-ID", "null" : false },
"cseq" : { "type" : "int", "default"
: 1, "null" : false },
"last_modified" : { "type" :
"datetime", "default" : "2000-01-01
00:00:01", "null" : false }, "flags"
: { "type" : "int", "default" : 0,
"null" : false }, "cflags" : {
"type" : "int", "default" : 0,
"null" : false }, "user_agent" : {
"type" : "string", "default" : "",
"null" : false }, "socket" : {
"type" : "string", "default" : null,
"null" : true }, "methods" : {
"type" : "int", "default" : null,
"null" : true }, "instance" : {
"type" : "string", "default" : null,
"null" : true }, "reg_id" : { "type"
: "int", "default" : 0, "null" :
false }, "server_id" : { "type" :
"int", "default" : 0, "null" : false
}, "connection_id" : { "type" :
"int", "default" : 0, "null" : false
}, "keepalive" : { "type" : "int",
"default" : 0, "null" : false },
"partition" : { "type" : "int",
"default" : 0, "null" : false } } }</div>
<div>{ "_id" :
ObjectId("5be02a77175610be86a1a589"),
"username" : "dummy_user" }</div>
</div>
<br
class="m_6422593769911831472gmail-Apple-interchange-newline">
</div>
<div><br>
</div>
<div>Syslog:</div>
<div><br>
</div>
<div>Nov 5 12:51:01 dev-rtpengine
/usr/sbin/kamailio[21543]: ERROR:
db_mongodb [mongodb_dbase.c:416]:
db_mongodb_get_columns(): field
[username] not found in result iterator</div>
<div>Nov 5 12:51:01 dev-rtpengine
/usr/sbin/kamailio[21543]: ERROR:
db_mongodb [mongodb_dbase.c:815]:
db_mongodb_store_result(): failed to set
the columns</div>
<div>Nov 5 12:51:01 dev-rtpengine
/usr/sbin/kamailio[21543]: ERROR:
db_mongodb [mongodb_dbase.c:1018]:
db_mongodb_query(): failed to store
result</div>
<div>Nov 5 12:51:01 dev-rtpengine
/usr/sbin/kamailio[21543]: ERROR:
db_mongodb [mongodb_dbase.c:1027]:
db_mongodb_query(): failed to do the
query</div>
<div>Nov 5 12:51:01 dev-rtpengine
/usr/sbin/kamailio[21543]: ERROR: usrloc
[udomain.c:457]: preload_udomain():
db_query failed</div>
<div>Nov 5 12:51:01 dev-rtpengine
/usr/sbin/kamailio[21543]: ERROR: usrloc
[usrloc_mod.c:430]: child_init():
child(1): failed to preload domain
'location'</div>
<div>Nov 5 12:51:01 dev-rtpengine
/usr/sbin/kamailio[21543]: ERROR:
<core> [core/sr_module.c:946]:
init_mod_child(): error while
initializing module usrloc
(/usr/lib64/kamailio/modules/usrloc.so)
(idx: 1 rank: 1 desc: [udp receiver
child=0 sock=<a
href="http://10.10.10.10:5060"
target="_blank" moz-do-not-send="true">10.10.10.10:5060</a>])</div>
<div>Nov 5 12:51:01 dev-rtpengine
/usr/sbin/kamailio[21543]: ERROR:
<core> [core/pt.c:340]:
fork_process(): init_child failed for
process 1, pid 21543, "udp receiver
child=0 sock=<a
href="http://10.10.10.10:5060"
target="_blank" moz-do-not-send="true">10.10.10.10:5060</a>"</div>
<div>Nov 5 12:51:01 dev-rtpengine
/usr/sbin/kamailio[21543]: CRITICAL:
<core> [main.c:1607]: main_loop():
Cannot fork</div>
<div><br>
</div>
<div>
<div><br>
</div>
</div>
<div>2018-11-05T13:07:19.117+0100 D
COMMAND [conn367] run command
kamailio.$cmd { find: "version", filter:
{ table_name: "location" }, projection:
{ table_version: 1 } }<br>
</div>
<div>
<div>2018-11-05T13:07:19.118+0100 I
COMMAND [conn367] command
kamailio.version command: find { find:
"version", filter: { table_name:
"location" }, projection: {
table_version: 1 } } planSummary:
COLLSCAN keysExamined:0 docsExamined:2
cursorExhausted:1 numYields:0
nreturned:1 reslen:148 locks:{ Global:
{ acquireCount: { r: 2 } }, Database:
{ acquireCount: { r: 1 } },
Collection: { acquireCount: { r: 1 } }
} protocol:op_query 0ms</div>
<div>2018-11-05T13:07:19.118+0100 D
COMMAND [conn367] run command
kamailio.$cmd { find: "location",
filter: { username: "dummy_user" },
projection: { username: 1 } }</div>
<div>2018-11-05T13:07:19.119+0100 I
COMMAND [conn367] command
kamailio.location command: find {
find: "location", filter: { username:
"dummy_user" }, projection: {
username: 1 } } planSummary: COLLSCAN
keysExamined:0 docsExamined:2
cursorExhausted:1 numYields:0
nreturned:1 reslen:155 locks:{ Global:
{ acquireCount: { r: 2 } }, Database:
{ acquireCount: { r: 1 } },
Collection: { acquireCount: { r: 1 } }
} protocol:op_query 0ms</div>
<div>2018-11-05T13:07:19.178+0100 D
COMMAND [conn368] run command
kamailio.$cmd { find: "location",
filter: {}, projection: { username: 1,
contact: 1, expires: 1, q: 1, callid:
1, cseq: 1, flags: 1, cflags: 1,
user_agent: 1, received: 1, path: 1,
socket: 1, methods: 1, last_modified:
1, ruid: 1, instance: 1, reg_id: 1,
server_id: 1, connection_id: 1,
keepalive: 1 } }</div>
<div>2018-11-05T13:07:19.179+0100 I
COMMAND [conn368] command
kamailio.location command: find {
find: "location", filter: {},
projection: { username: 1, contact: 1,
expires: 1, q: 1, callid: 1, cseq: 1,
flags: 1, cflags: 1, user_agent: 1,
received: 1, path: 1, socket: 1,
methods: 1, last_modified: 1, ruid: 1,
instance: 1, reg_id: 1, server_id: 1,
connection_id: 1, keepalive: 1 } }
planSummary: COLLSCAN keysExamined:0
docsExamined:2 cursorExhausted:1
numYields:0 nreturned:2 reslen:180
locks:{ Global: { acquireCount: { r: 2
} }, Database: { acquireCount: { r: 1
} }, Collection: { acquireCount: { r:
1 } } } protocol:op_query 0ms</div>
<div><br>
</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div>
<div>[root@dev-rtpengine kamailio]#
kamailio -v</div>
<div>version: kamailio 5.1.6
(x86_64/linux) 7d1964</div>
<div>flags: STATS: Off, USE_TCP,
USE_TLS, USE_SCTP, TLS_HOOKS,
USE_RAW_SOCKS, DISABLE_NAGLE,
USE_MCAST, DNS_IP_HACK, SHM_MEM,
SHM_MMAP, PKG_MALLOC, Q_MALLOC,
F_MALLOC, TLSF_MALLOC, DBG_SR_MEMORY,
USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT,
USE_DNS_CACHE, USE_DNS_FAILOVER,
USE_NAPTR, USE_DST_BLACKLIST,
HAVE_RESOLV_RES</div>
<div>ADAPTIVE_WAIT_LOOPS=1024,
MAX_RECV_BUFFER_SIZE 262144
MAX_URI_SIZE 1024, BUF_SIZE 65535,
DEFAULT PKG_SIZE 8MB</div>
<div>poll method support: poll,
epoll_lt, epoll_et, sigio_rt, select.</div>
<div>id: 7d1964</div>
<div>compiled on 11:10:15 Nov 4 2018
with gcc 4.8.5</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
-- <br>
<div dir="ltr"
class="m_6422593769911831472gmail_signature">
<div dir="ltr"><br>
<div>
<div>BR,</div>
<div>Denys Pozniak<br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset
class="m_6422593769911831472mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
Kamailio (SER) - Users Mailing List
<a class="m_6422593769911831472moz-txt-link-abbreviated" href="mailto:sr-users@lists.kamailio.org" target="_blank" moz-do-not-send="true">sr-users@lists.kamailio.org</a>
<a class="m_6422593769911831472moz-txt-link-freetext" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" target="_blank" moz-do-not-send="true">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="m_6422593769911831472moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="m_6422593769911831472moz-txt-link-abbreviated" href="http://www.asipto.com" target="_blank" moz-do-not-send="true">www.asipto.com</a>
<a class="m_6422593769911831472moz-txt-link-abbreviated" href="http://www.twitter.com/miconda" target="_blank" moz-do-not-send="true">www.twitter.com/miconda</a> -- <a class="m_6422593769911831472moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda" target="_blank" moz-do-not-send="true">www.linkedin.com/in/miconda</a>
Kamailio World Conference -- <a class="m_6422593769911831472moz-txt-link-abbreviated" href="http://www.kamailioworld.com" target="_blank" moz-do-not-send="true">www.kamailioworld.com</a>
Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- <a class="m_6422593769911831472moz-txt-link-abbreviated" href="http://www.asipto.com" target="_blank" moz-do-not-send="true">www.asipto.com</a></pre>
</div>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail_signature"
data-smartmail="gmail_signature">
<div dir="ltr"><br>
<div>
<div>BR,</div>
<div>Denys Pozniak<br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
</div>
</div>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="moz-txt-link-abbreviated" href="http://www.asipto.com">www.asipto.com</a>
<a class="moz-txt-link-abbreviated" href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a class="moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a>
Kamailio World Conference -- <a class="moz-txt-link-abbreviated" href="http://www.kamailioworld.com">www.kamailioworld.com</a>
Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- <a class="moz-txt-link-abbreviated" href="http://www.asipto.com">www.asipto.com</a></pre>
</body>
</html>