[SR-Users] Permissions module with Mongodb
Daniel-Constantin Mierla
miconda at gmail.com
Tue Feb 9 08:32:53 CET 2021
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
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
> <miconda at 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 <sr-users-bounces at lists.kamailio.org>
> <mailto:sr-users-bounces at lists.kamailio.org> *On Behalf Of *H Yavari
> *Sent:* Sunday, February 7, 2021 10:10 PM
> *To:* Kamailio (SER) - Users Mailing List
> <sr-users at lists.kamailio.org> <mailto:sr-users at 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
> <mcnamara.jeremy at gmail.com <mailto:mcnamara.jeremy at 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/kamailio
> <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 <hyavari at rocketmail.com
> <mailto:hyavari at 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
> <mcnamara.jeremy at gmail.com <mailto:mcnamara.jeremy at 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 at lists.kamailio.org <mailto:sr-users at 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 at lists.kamailio.org <mailto:sr-users at 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 at lists.kamailio.org <mailto:sr-users at 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 at lists.kamailio.org <mailto:sr-users at 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 at lists.kamailio.org <mailto:sr-users at 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
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Funding: https://www.paypal.me/dcmierla
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20210209/dba64848/attachment.htm>
More information about the sr-users
mailing list