<html><head></head><body><div class="ydp556efad0yahoo-style-wrap" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif; font-size: 13px;"><div></div>
<div dir="ltr" data-setdir="false">Dear Daniel,</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">Thanks for reply.</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">Obviously, there is a problem in my collection, is there any how-to for it?</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"><div><div>kamailio[1206]: 0(1208) DEBUG: db_mongodb [mongodb_dbase.c:973]: db_mongodb_query(): query to collection [version]</div><div>kamailio[1206]: 0(1208) DEBUG: db_mongodb [mongodb_dbase.c:1007]: db_mongodb_query(): query filter: { "table_name" : "address" }</div><div>kamailio[1206]: 0(1208) DEBUG: db_mongodb [mongodb_dbase.c:1043]: db_mongodb_query(): columns filter: { "projection" : { "table_version" : 1 } }</div><div>kamailio[1206]: 0(1208) DEBUG: <core> [db_res.c:119]: db_new_result(): allocate 56 bytes for result set at 0x7ff37023bce0</div><div>kamailio[1206]: 0(1208) DEBUG: db_mongodb [mongodb_dbase.c:851]: db_mongodb_store_result(): no result from mongodb</div><div>kamailio[1206]: 0(1208) DEBUG: <core> [db.c:407]: db_table_version(): no row for table address found</div><div>kamailio[1206]: 0(1208) ERROR: <core> [db.c:466]: db_check_table_version(): invalid version 0 for table address found, expected 6 (check table structure and table "version")</div></div><div><br></div><div dir="ltr" data-setdir="false">What I miss?</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">Regards,</div><div dir="ltr" data-setdir="false">Hossein</div><br></div><div><br></div>
</div><div id="ydp31b02c7yahoo_quoted_3060818213" class="ydp31b02c7yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Monday, February 8, 2021, 10:12:51 AM PST, Daniel-Constantin Mierla <miconda@gmail.com> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="ydp31b02c7yiv4228948567"><div>
<p>Hello,</p>
<p>jumping in to add another hint: run kamailio with debug=3 in
kamailio.cfg and look at the syslog file, iirc, the db_mongodb
should print many details when doing queries and then you may get
a clue of what happens. If not, send over here all the log
messages printed by kamailio in such case and we can take a look.</p>
<p>Cheers,<br clear="none">
Daniel<br clear="none">
</p>
<div class="ydp31b02c7yiv4228948567yqt6062309397" id="ydp31b02c7yiv4228948567yqt51168"><div class="ydp31b02c7yiv4228948567moz-cite-prefix">On 08.02.21 11:56, Henning Westerholt
wrote:<br clear="none">
</div>
<blockquote type="cite">
</blockquote></div></div><div class="ydp31b02c7yiv4228948567yqt6062309397" id="ydp31b02c7yiv4228948567yqt60342"><div><div class="ydp31b02c7yiv4228948567WordSection1">
<p class="ydp31b02c7yiv4228948567MsoNormal"><span>Hello,</span></p>
<p class="ydp31b02c7yiv4228948567MsoNormal"><span> </span></p>
<p class="ydp31b02c7yiv4228948567MsoNormal"><span lang="EN-GB">can you see on the mongoDB level (e.g. with
query debugging) what query is actually done on the server?
This might help to debug the problem.</span></p>
<p class="ydp31b02c7yiv4228948567MsoNormal"><span lang="EN-GB"> </span></p>
<p class="ydp31b02c7yiv4228948567MsoNormal"><span lang="EN-GB">Cheers,</span></p>
<p class="ydp31b02c7yiv4228948567MsoNormal"><span lang="EN-GB"> </span></p>
<p class="ydp31b02c7yiv4228948567MsoNormal"><span lang="EN-GB">Henning</span></p>
<p class="ydp31b02c7yiv4228948567MsoNormal"><span lang="EN-GB"> </span></p>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal"><span lang="EN-GB">--
</span></p>
<p class="ydp31b02c7yiv4228948567MsoNormal"><span lang="EN-GB">Henning Westerholt –
</span><span><a shape="rect" href="https://skalatan.de/blog/" rel="nofollow" target="_blank"><span lang="EN-GB" style="color:#0563C1;">https://skalatan.de/blog/</span></a></span><span lang="EN-GB"></span></p>
<p class="ydp31b02c7yiv4228948567MsoNormal"><span lang="EN-GB">Kamailio services –
</span><span><a shape="rect" href="https://gilawa.com/" rel="nofollow" target="_blank"><span lang="EN-GB" style="color:#0563C1;">https://gilawa.com</span></a></span><span>
<span lang="EN-GB"></span></span></p>
</div>
<p class="ydp31b02c7yiv4228948567MsoNormal"><span lang="EN-GB"> </span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm;">
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><b>From:</b>
sr-users <a shape="rect" class="ydp31b02c7yiv4228948567moz-txt-link-rfc2396E" href="mailto:sr-users-bounces@lists.kamailio.org" rel="nofollow" target="_blank"><sr-users-bounces@lists.kamailio.org></a>
<b>On Behalf Of </b>H Yavari<br clear="none">
<b>Sent:</b> Sunday, February 7, 2021 10:10 PM<br clear="none">
<b>To:</b> Kamailio (SER) - Users Mailing List
<a shape="rect" class="ydp31b02c7yiv4228948567moz-txt-link-rfc2396E" href="mailto:sr-users@lists.kamailio.org" rel="nofollow" target="_blank"><sr-users@lists.kamailio.org></a><br clear="none">
<b>Subject:</b> Re: [SR-Users] Permissions module with
Mongodb</p>
</div>
</div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"> </p>
<div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;">Thanks
for the reply.</span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;">But
I have the version now like this, and get the error!</span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;"><img class="ydp31b02c7yiv4228948567" id="ydp31b02c7yiv4228948567Bild_x0020_1" style="width: 404px; max-width: 404px;" src="cid:KrIEYlgKoJHcySchsQfG" alt="Inline image" border="0" data-inlineimagemanipulating="true"></span><span style="font-size:10.0pt;font-family:sans-serif;"></span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;">Any
idea?</span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;">Regards,</span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;">Hossein</span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;">----</span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
</div>
<div id="ydp31b02c7yiv4228948567ydp5b6c8257yahoo_quoted_2871214323">
<div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">On
Sunday, February 7, 2021, 09:25:12 AM PST, Jeremy
McNamara <<a shape="rect" href="mailto:mcnamara.jeremy@gmail.com" rel="nofollow" target="_blank">mcnamara.jeremy@gmail.com</a>>
wrote: </span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<div id="ydp31b02c7yiv4228948567ydp5b6c8257yiv9832865734">
<div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">Hmm...
I know I used that trick for usrloc about a
decade ago :)</span></p>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">Have
you discovered the mongo schema files located
here: <a shape="rect" href="https://github.com/kamailio/kamailio/tree/master/utils/kamctl/mongodb/kamailio" rel="nofollow" target="_blank">https://github.com/kamailio/kamailio/tree/master/utils/kamctl/mongodb/kamailio</a></span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">I
did a quick scan through and it seems
everything should be there. (Do you see a
version table in your mongodb?) </span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">-J</span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
</div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
<div>
<div id="ydp31b02c7yiv4228948567ydp5b6c8257yiv9832865734yqt74208">
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">On
Sat, Feb 6, 2021 at 6:14 PM H Yavari <<a shape="rect" href="mailto:hyavari@rocketmail.com" rel="nofollow" target="_blank">hyavari@rocketmail.com</a>>
wrote:</span></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm;">
<div>
<div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">Thanks
Jeremy,</span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">But
as I see in logs, it can't set this
parameter!</span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">Anybody
did it before? using Mongo for these
modules.</span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">BR,</span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">Hossein</span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
</div>
<div id="ydp31b02c7yiv4228948567ydp5b6c8257yiv9832865734gmail-m_-5273319281737000918ydpf769dffayahoo_quoted_3541247535">
<div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">On
Saturday, February 6, 2021, 01:39:09
PM PST, Jeremy McNamara <<a shape="rect" href="mailto:mcnamara.jeremy@gmail.com" rel="nofollow" target="_blank">mcnamara.jeremy@gmail.com</a>>
wrote: </span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<div id="ydp31b02c7yiv4228948567ydp5b6c8257yiv9832865734gmail-m_-5273319281737000918ydpf769dffayiv2200111905">
<div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">Hi
- This may not be a correct
solution, but it might help
you move forward.</span></p>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;color:#26282A;">modparam("permissions",
"version_table", 0)</span><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"></span></p>
<div id="ydp31b02c7yiv4228948567ydp5b6c8257yiv9832865734gmail-m_-5273319281737000918ydpf769dffayiv2200111905yqtfd91373">
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
</div>
</div>
</div>
</div>
<div id="ydp31b02c7yiv4228948567ydp5b6c8257yiv9832865734gmail-m_-5273319281737000918ydpf769dffayqtfd39318">
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">_______________________________________________<br clear="none">
Kamailio (SER) - Users Mailing
List<br clear="none">
<a shape="rect" href="mailto:sr-users@lists.kamailio.org" rel="nofollow" target="_blank">sr-users@lists.kamailio.org</a></span></p>
</div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"><br clear="none">
<a shape="rect" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="nofollow" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a></span></p>
<div id="ydp31b02c7yiv4228948567ydp5b6c8257yiv9832865734gmail-m_-5273319281737000918ydpf769dffayqtfd63874">
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
</div>
</div>
</div>
</div>
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">_______________________________________________<br clear="none">
Kamailio (SER) - Users Mailing List<br clear="none">
<a shape="rect" href="mailto:sr-users@lists.kamailio.org" rel="nofollow" target="_blank">sr-users@lists.kamailio.org</a><br clear="none">
<a shape="rect" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="nofollow" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a></span></p>
</blockquote>
</div>
</div>
</div>
</div>
<div id="ydp31b02c7yiv4228948567ydp5b6c8257yqt86556">
<p class="ydp31b02c7yiv4228948567MsoNormal" style="margin-left:35.4pt;"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">_______________________________________________<br clear="none">
Kamailio (SER) - Users Mailing List<br clear="none">
<a shape="rect" href="mailto:sr-users@lists.kamailio.org" rel="nofollow" target="_blank">sr-users@lists.kamailio.org</a><br clear="none">
<a shape="rect" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="nofollow" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a></span></p>
</div>
</div>
</div>
</div>
</div>
<br clear="none">
<fieldset class="ydp31b02c7yiv4228948567mimeAttachmentHeader"></fieldset>
<pre class="ydp31b02c7yiv4228948567moz-quote-pre">_______________________________________________
Kamailio (SER) - Users Mailing List
<a shape="rect" class="ydp31b02c7yiv4228948567moz-txt-link-abbreviated" href="mailto:sr-users@lists.kamailio.org" rel="nofollow" target="_blank">sr-users@lists.kamailio.org</a>
<a shape="rect" class="ydp31b02c7yiv4228948567moz-txt-link-freetext" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="nofollow" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
<pre class="ydp31b02c7yiv4228948567moz-signature">--
Daniel-Constantin Mierla -- <a shape="rect" class="ydp31b02c7yiv4228948567moz-txt-link-abbreviated" href="http://www.asipto.com" rel="nofollow" target="_blank">www.asipto.com</a>
<a shape="rect" class="ydp31b02c7yiv4228948567moz-txt-link-abbreviated" href="http://www.twitter.com/miconda" rel="nofollow" target="_blank">www.twitter.com/miconda</a> -- <a shape="rect" class="ydp31b02c7yiv4228948567moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda" rel="nofollow" target="_blank">www.linkedin.com/in/miconda</a>
Funding: <a shape="rect" class="ydp31b02c7yiv4228948567moz-txt-link-freetext" href="https://www.paypal.me/dcmierla" rel="nofollow" target="_blank">https://www.paypal.me/dcmierla</a></pre>
</div></div></div><div class="ydp31b02c7yqt6062309397" id="ydp31b02c7yqt70660">_______________________________________________<br clear="none">Kamailio (SER) - Users Mailing List<br clear="none"><a shape="rect" href="mailto:sr-users@lists.kamailio.org" rel="nofollow" target="_blank">sr-users@lists.kamailio.org</a><br clear="none"><a shape="rect" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="nofollow" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br clear="none"></div></div>
</div>
</div></body></html>