[SR-Users] Permissions module with Mongodb

H Yavari hyavari at rocketmail.com
Tue Feb 9 08:00:41 CET 2021


 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 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/
 
Kamailio services – https://gilawa.com 
  
  
   
From: sr-users <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>
 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> 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
   
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> 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> 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
  

 https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
  
  
      
_______________________________________________
 Kamailio (SER) - Users Mailing List
 sr-users at lists.kamailio.org
 https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
 
      
_______________________________________________
 Kamailio (SER) - Users Mailing List
 sr-users at lists.kamailio.org
 https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
      
  _______________________________________________
Kamailio (SER) - Users Mailing List
sr-users at 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 at lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20210209/e7e49945/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 22590 bytes
Desc: not available
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20210209/e7e49945/attachment.png>


More information about the sr-users mailing list