<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hello,</p>
<p>pushed the patch to master and 5.2 branches. Can you test and see
if all ok?</p>
<p>Cheers,<br>
Daniel<br>
</p>
<div class="moz-cite-prefix">On 16.05.19 17:03, José Seabra wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAEVZRWuMEvLa4xbKvx_7E5+3Z95Wdzyd1up6SVxF8qCciQUhng@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Hello Daniel,
<div>Thank you for the feedback.</div>
<div><br>
</div>
<div>Would be possible include this patch in the new kamailio
release 5.2.3?</div>
<div><br>
</div>
<div>Best Regards</div>
<div>José Seabra</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">Daniel-Constantin Mierla <<a
href="mailto:miconda@gmail.com" moz-do-not-send="true">miconda@gmail.com</a>>
escreveu no dia quinta, 16/05/2019 à(s) 11:44:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF">
<p>Hello,</p>
<p>you can ignore them for the moment, at least in this case
it is about a null value and the type doesn't matter much.</p>
<p>I have in plan to add a schema check for db_mongodb, but
I haven't gotten the time yet.</p>
<p>As a solution for now, I will push soon a small patch to
catch the null value and print dbg instead of info.</p>
<p>Cheers,<br>
Daniel<br>
</p>
<div class="gmail-m_4435417742339126984moz-cite-prefix">On
16.05.19 12:15, José Seabra wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">Hello there,
<div>I'm testing usrloc module with mongodb and
i have a couple of questions to do.</div>
<div><br>
</div>
<div>What i would like to know/have confirmation
is if the fields that are specified in the
following link <a
href="https://kamailio.org/docs/db-tables/kamailio-db-5.2.x.html#gen-db-location-index"
target="_blank" moz-do-not-send="true">https://kamailio.org/docs/db-tables/kamailio-db-5.2.x.html#gen-db-location-index</a>
can be used to create indexes in mongodb?</div>
<div><br>
</div>
<div>I'm noticing that when a register is
updated/deleted or expires kamailio prints the
following INFO logs:</div>
</div>
</div>
</div>
<blockquote style="margin:0px 0px 0px
40px;border:none;padding:0px">
<div>
<div>
<div>
<div><i>db_mongodb [mongodb_dbase.c:526]:
db_mongodb_get_columns(): unhandled data
type column (methods) type id (10), use
DB1_STRING as default</i></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div><i>db_mongodb [mongodb_dbase.c:526]:
db_mongodb_get_columns(): unhandled data
type column (instance) type id (10), use
DB1_STRING as default</i></div>
</div>
</div>
</div>
</blockquote>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div><br>
</div>
<div>These fields (<i>methods and </i><i>instance</i>)
are stored in mongodb document with a null
string, e.g:</div>
</div>
</div>
</div>
</div>
<blockquote style="margin:0px 0px 0px
40px;border:none;padding:0px">
<div>
<div>
<div>
<div>
<div>
<div><i>{</i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span>"_id"
: ObjectId("5cdc775a6472740055289a11"),</i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span>"username"
: "x1000",</i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span>"contact"
: <a
class="gmail-m_4435417742339126984moz-txt-link-rfc2396E"
moz-do-not-send="true">"sip:x1000@192.168.1.1:5674;transport=UDP"</a>,</i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span>"expires"
: ISODate("2019-05-15T20:33:26Z"),</i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span>"q"
: -1,</i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span>"callid"
: "<a
href="mailto:sipp-ci2-edge-sip-proxy1-20190515203220-1-21@172.31.2.61"
target="_blank" moz-do-not-send="true">sipp-ci2-edge-sip-proxy1-20190515203220-1-21@172.31.2.61</a>",</i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span>"cseq"
: 2,</i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span>"flags"
: 0,</i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span>"cflags"
: 0,</i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span>"user_agent"
: "sipp",</i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span>"received"
: "sip:<a
href="http://191.30.10.23:8888"
target="_blank" moz-do-not-send="true">191.30.10.23:8888</a>",</i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span>"path"
: "<a
class="gmail-m_4435417742339126984moz-txt-link-rfc2396E"
moz-do-not-send="true"><sip:172.31.2.61:5060;received=sip:191.30.10.23:8888;lr></a>",</i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span>"socket"
: "udp:<a href="http://172.31.2.11:5060"
target="_blank" moz-do-not-send="true">172.31.2.11:5060</a>",</i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span><b>"methods"
: null,</b></i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span>"last_modified"
: ISODate("2019-05-15T20:32:26Z"),</i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span>"ruid"
: "uloc-15-5cdc7756-55-1",</i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span><b>"instance"
: null,</b></i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span>"reg_id"
: 0,</i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span>"server_id"
: 21,</i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span>"connection_id"
: -1,</i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span>"keepalive"
: 0,</i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i><span style="white-space:pre-wrap"> </span>"partition"
: 0</i></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div><i>}</i></div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div>Should i be concerned about that log msg?
how can i avoid it?</div>
<div><br>
</div>
<div><br>
</div>
<div>Thanks </div>
<div>Regards<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr"
class="gmail-m_4435417742339126984gmail_signature">Cumprimentos
<div>José Seabra</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset
class="gmail-m_4435417742339126984mimeAttachmentHeader"></fieldset>
<pre class="gmail-m_4435417742339126984moz-quote-pre">_______________________________________________
Kamailio (SER) - Users Mailing List
<a class="gmail-m_4435417742339126984moz-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="gmail-m_4435417742339126984moz-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>
<pre class="gmail-m_4435417742339126984moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="gmail-m_4435417742339126984moz-txt-link-abbreviated" href="http://www.asipto.com" target="_blank" moz-do-not-send="true">www.asipto.com</a>
<a class="gmail-m_4435417742339126984moz-txt-link-abbreviated" href="http://www.twitter.com/miconda" target="_blank" moz-do-not-send="true">www.twitter.com/miconda</a> -- <a class="gmail-m_4435417742339126984moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda" target="_blank" moz-do-not-send="true">www.linkedin.com/in/miconda</a></pre>
</div>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail_signature">Cumprimentos
<div>José Seabra</div>
</div>
</blockquote>
<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></pre>
</body>
</html>