Permissions module with Mongodb - sr-users - kamailio.org

List overview All Threads
Download

Permissions module with Mongodb

master daily build with disabled...

Kamailio as MS-Teams SBC

H Yavari

6 Feb 2021 6 Feb '21

7:25 a.m.

Hi to all, It's mentioned in the Permissions module doc, we can set DB driver:https://kamailio.org/docs/modules/3.1.x/modules_k/permissions.html#i… So we can use MongoDB as a DB backend? All the modules that use DB, support Mongo? Thanks. Regards,Hossein

Attachments:

attachment.html (text/html — 1.0 KB)

Reply

Show replies by date

Henning Westerholt

6 Feb 6 Feb

12:28 p.m.

Hello, This should work, yes. With a few exceptions you can use all existing modules that needs a database with the mongodb backend. (Some special module functions might need certain capabilities that not all database drivers are able to provide. Usually, you will get a message during Kamailio startup with an error message if something is not supported). Cheers, Henning -- Henning Westerholt – https://skalatan.de/blog/ Kamailio services – https://gilawa.com<https://gilawa.com/> From: sr-users <sr-users-bounces(a)lists.kamailio.org> On Behalf Of H Yavari Sent: Saturday, February 6, 2021 6:25 AM To: Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org> Subject: [SR-Users] Permissions module with Mongodb Hi to all, It's mentioned in the Permissions module doc, we can set DB driver: https://kamailio.org/docs/modules/3.1.x/modules_k/permissions.html#id2511783 So we can use MongoDB as a DB backend? All the modules that use DB, support Mongo? Thanks. Regards, Hossein

Reply

H Yavari

10:12 p.m.

Thanks Henning. The problem is "version" checking.I created a collection "version" in Mongo for address, trusted, and permissions with value=6 but Kamailio doesn't start:Feb 6 19:41:36 kamailio-sip kamailio[12400]: 0(12402) ERROR: <core> [db.c:466]: db_check_table_version(): invalid version 0 for table address found, expected 6 (check table structure and table "version")Feb 6 19:41:36 kamailio-sip kamailio[12400]: 0(12402) ERROR: permissions [address.c:484]: init_addresses(): Error during version check for db table: address, check database structure.Feb 6 19:41:36 kamailio-sip kamailio[12400]: 0(12402) ERROR: permissions [permissions.c:645]: mod_init(): failed to initialize the allow_address functionFeb 6 19:41:36 kamailio-sip kamailio[12400]: 0(12402) ERROR: <core> [core/sr_module.c:849]: init_mod(): Error while initializing module permissions (/opt/kamailio/lib64/kamailio/modules/permissions.so) and this is cfg file: ..modparam("permissions", "db_url", "mongodb://X.Y.W.Z/kamailio") .. Any idea what is wrong in configs? BR,Hossein ---- On Saturday, February 6, 2021, 02:28:27 AM PST, Henning Westerholt <hw(a)skalatan.de> wrote: Hello, This should work, yes. With a few exceptions you can use all existing modules that needs a database with the mongodb backend. (Some special module functions might need certain capabilities that not all database drivers are able to provide. Usually, you will get a message during Kamailio startup with an error message if something is not supported). Cheers, Henning -- Henning Westerholt –https://skalatan.de/blog/ Kamailio services –https://gilawa.com From: sr-users <sr-users-bounces(a)lists.kamailio.org>On Behalf Of H Yavari Sent: Saturday, February 6, 2021 6:25 AM To: Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org> Subject: [SR-Users] Permissions module with Mongodb Hi to all, It's mentioned in the Permissions module doc, we can set DB driver: https://kamailio.org/docs/modules/3.1.x/modules_k/permissions.html#id2511783 So we can use MongoDB as a DB backend? All the modules that use DB, support Mongo? Thanks. Regards, Hossein

Reply

Jeremy McNamara

11:35 p.m.

Hi - This may not be a correct solution, but it might help you move forward. modparam("permissions", "version_table", 0)

Reply

H Yavari

7 Feb 7 Feb

1:13 a.m.

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(a)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 https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

Reply

Jeremy McNamara

7:24 p.m.

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… 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(a)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(a)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 https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

Reply

H Yavari

11:09 p.m.

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(a)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… 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(a)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(a)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 https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

Reply

Henning Westerholt

8 Feb 8 Feb

12:56 p.m.

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/ Kamailio services – https://gilawa.com<https://gilawa.com/> From: sr-users <sr-users-bounces(a)lists.kamailio.org> On Behalf Of H Yavari Sent: Sunday, February 7, 2021 10:10 PM To: Kamailio (SER) - Users Mailing List <sr-users(a)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! [Inline image] Any idea? Regards, Hossein ---- On Sunday, February 7, 2021, 09:25:12 AM PST, Jeremy McNamara <mcnamara.jeremy@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… 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@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 <mcnamara.jeremy@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@lists.kamailio.org<mailto:sr-users@lists.kamailio.org> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users _______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org<mailto:sr-users@lists.kamailio.org> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users _______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org<mailto:sr-users@lists.kamailio.org> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

Reply

Daniel-Constantin Mierla

8:11 p.m.

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(a)lists.kamailio.org> *On Behalf Of *H Yavari *Sent:* Sunday, February 7, 2021 10:10 PM *To:* Kamailio (SER) - Users Mailing List <sr-users(a)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! Inline image Any idea? Regards, Hossein ---- On Sunday, February 7, 2021, 09:25:12 AM PST, Jeremy McNamara <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 <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 <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 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

Reply

H Yavari

9 Feb 9 Feb

9 a.m.

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 0x7ff37023bce0kamailio[1206]: 0(1208) DEBUG: db_mongodb [mongodb_dbase.c:851]: db_mongodb_store_result(): no result from mongodbkamailio[1206]: 0(1208) DEBUG: <core> [db.c:407]: db_table_version(): no row for table address foundkamailio[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(a)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/ Kamailio services – https://gilawa.com From: sr-users <sr-users-bounces(a)lists.kamailio.org> On Behalf Of H Yavari Sent: Sunday, February 7, 2021 10:10 PM To: Kamailio (SER) - Users Mailing List <sr-users(a)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(a)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… 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(a)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(a)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 https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org 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 _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

Reply

Daniel-Constantin Mierla

9:32 a.m.

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(a)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(a)lists.kamailio.org> <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 <sr-users(a)lists.kamailio.org> <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 <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 <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 <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 www.twitter.com/miconda -- www.linkedin.com/in/miconda Funding: https://www.paypal.me/dcmierla

Reply

H Yavari

10:17 a.m.

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.12Mongo-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 <miconda(a)gmail.com> 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 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(a)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/ Kamailio services – https://gilawa.com From: sr-users <sr-users-bounces(a)lists.kamailio.org> On Behalf Of H Yavari Sent: Sunday, February 7, 2021 10:10 PM To: Kamailio (SER) - Users Mailing List <sr-users(a)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(a)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… 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(a)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(a)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 https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org 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 _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org 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

Reply

Daniel-Constantin Mierla

10:34 a.m.

Hello, hmm, that's interesting, used to be no problem with name "version", afaik, might be something specific to newer versions of mongodb. I think there is a function to retrieve the collection by name, but that requires changes in the c code, not sure when I will get time for it, maybe others can also take a look. Meanwhile, the solution is to use a different name for the version table, you can set it via the core parameter: - https://www.kamailio.org/wiki/cookbooks/5.4.x/core#version_table Cheers, Daniel On 09.02.21 09:17, H Yavari wrote:

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 <miconda(a)gmail.com> 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 <miconda(a)gmail.com> <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 <sr-users-bounces(a)lists.kamailio.org> <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 <sr-users(a)lists.kamailio.org> <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 <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 <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 <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>

-- Daniel-Constantin Mierla -- www.asipto.com www.twitter.com/miconda -- www.linkedin.com/in/miconda Funding: https://www.paypal.me/dcmierla

Reply

H Yavari

10 Feb 10 Feb

1:14 a.m.

Hi Daniel, It worked with different names like "versions".Please put it in your issue list for future release. Thank you. Regards,Hossein -- On Tuesday, February 9, 2021, 12:34:06 AM PST, Daniel-Constantin Mierla <miconda(a)gmail.com> wrote: Hello, hmm, that's interesting, used to be no problem with name "version", afaik, might be something specific to newer versions of mongodb. I think there is a function to retrieve the collection by name, but that requires changes in the c code, not sure when I will get time for it, maybe others can also take a look. Meanwhile, the solution is to use a different name for the version table, you can set it via the core parameter: - https://www.kamailio.org/wiki/cookbooks/5.4.x/core#version_table Cheers, Daniel On 09.02.21 09:17, H Yavari wrote: 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 <miconda(a)gmail.com> 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 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(a)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/ Kamailio services – https://gilawa.com From: sr-users <sr-users-bounces(a)lists.kamailio.org> On Behalf Of H Yavari Sent: Sunday, February 7, 2021 10:10 PM To: Kamailio (SER) - Users Mailing List <sr-users(a)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(a)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… 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(a)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(a)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 https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org 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 _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org 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 -- Daniel-Constantin Mierla -- www.asipto.com www.twitter.com/miconda -- www.linkedin.com/in/miconda Funding: https://www.paypal.me/dcmierla

Reply

1412

days inactive

1415

days old

sr-users@lists.kamailio.org

Manage subscription

13 comments

4 participants

tags (0)

participants (4)

Daniel-Constantin Mierla
H Yavari
Henning Westerholt
Jeremy McNamara