Re: [SR-Users] Permissions module with Mongodb

Hi Daniel, I investigated a little and find something:  db.version.find() doesn't run. It seems Mongo has a problem with the name of "version" and it says: 2021-02-09T00:16:57.333-0800 E QUERY    [js] TypeError: db.version.find is not a function : I am using: The server version: 4.2.12 Mongo-C version: 1.17.4 Do you have any idea? is there any hint about versions? BR, Hossein -- On Monday, February 8, 2021, 11:32:57 PM PST, Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; wrote: Hello, maybe the version collection was not created properly -- have you read the guidelines from next link?   * https://www.kamailio.org/wiki/tutorials/kamailio-and-mongodb <https://www.kamailio.org/wiki/tutorials/kamailio-and-mongodb> Cheers, Daniel On 09.02.21 08:00, H Yavari wrote: Dear Daniel, Thanks for reply. Obviously, there is a problem in my collection, is there any how-to for it? kamailio[1206]:  0(1208) DEBUG: db_mongodb [mongodb_dbase.c:973]: db_mongodb_query(): query to collection [version] kamailio[1206]:  0(1208) DEBUG: db_mongodb [mongodb_dbase.c:1007]: db_mongodb_query(): query filter: { "table_name" : "address" } kamailio[1206]:  0(1208) DEBUG: db_mongodb [mongodb_dbase.c:1043]: db_mongodb_query(): columns filter: { "projection" : { "table_version" : 1 } } kamailio[1206]:  0(1208) DEBUG: <core> [db_res.c:119]: db_new_result(): allocate 56 bytes for result set at 0x7ff37023bce0 kamailio[1206]:  0(1208) DEBUG: db_mongodb [mongodb_dbase.c:851]: db_mongodb_store_result(): no result from mongodb kamailio[1206]:  0(1208) DEBUG: <core> [db.c:407]: db_table_version(): no row for table address found 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") What I miss? Regards, Hossein On Monday, February 8, 2021, 10:12:51 AM PST, Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; <mailto:miconda@gmail.com> wrote: Hello, 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. Cheers, Daniel On 08.02.21 11:56, Henning Westerholt wrote: Hello,   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.   Cheers,   Henning   -- Henning Westerholt – https://skalatan.de/blog/ <https://skalatan.de/blog/> Kamailio services – https://gilawa.com <https://gilawa.com/>   *From:* sr-users &lt;sr-users-bounces(a)lists.kamailio.org&gt; <mailto:sr-users-bounces@lists.kamailio.org> *On Behalf Of *H Yavari *Sent:* Sunday, February 7, 2021 10:10 PM *To:* Kamailio (SER) - Users Mailing List &lt;sr-users(a)lists.kamailio.org&gt; <mailto:sr-users@lists.kamailio.org> *Subject:* Re: [SR-Users] Permissions module with Mongodb   Thanks for the reply. But I have the version now like this, and get the error!     Any idea?   Regards, Hossein   ----   On Sunday, February 7, 2021, 09:25:12 AM PST, Jeremy McNamara &lt;mcnamara.jeremy(a)gmail.com <mailto:mcnamara.jeremy@gmail.com>> wrote:     Hmm... I know I used that trick for usrloc about a decade ago :)   Have you discovered the mongo schema files located here:  https://github.com/kamailio/kamailio/tree/master/utils/kamctl/mongodb/kamai… <https://github.com/kamailio/kamailio/tree/master/utils/kamctl/mongodb/kamailio> I did a quick scan through and it seems everything should be there.   (Do you see a version table in your mongodb?)      -J         On Sat, Feb 6, 2021 at 6:14 PM H Yavari &lt;hyavari(a)rocketmail.com <mailto:hyavari@rocketmail.com>> wrote: Thanks Jeremy,   But as I see in logs, it can't set this parameter!   Anybody did it before? using Mongo for these modules.   BR, Hossein     On Saturday, February 6, 2021, 01:39:09 PM PST, Jeremy McNamara &lt;mcnamara.jeremy(a)gmail.com <mailto:mcnamara.jeremy@gmail.com>> wrote:     Hi - This may not be a correct solution, but it might help you move forward.   modparam("permissions", "version_table", 0)   _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org <mailto:sr-users@lists.kamailio.org> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users <https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users>   _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org <mailto:sr-users@lists.kamailio.org> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users <https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users> _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org <mailto:sr-users@lists.kamailio.org> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users <https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users> _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org <mailto:sr-users@lists.kamailio.org> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users <https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users> -- Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com> www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda> Funding: https://www.paypal.me/dcmierla <https://www.paypal.me/dcmierla> _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org <mailto:sr-users@lists.kamailio.org> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users <https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users> -- Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com> www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda> Funding: https://www.paypal.me/dcmierla <https://www.paypal.me/dcmierla>