[web2py] Re: How to access the auth tables in appadmin?
This is because in the file models/db.py variable 'db' is defined first time in row 20: if not request.env.web2py_runtime_gae: ## if NOT running on Google App Engine use SQLite or other DB db = DAL(myconf.take('db.uri'), pool_size=myconf.take('db.pool_size', cast=int), check_reserved=['all']) and then we add to the end of this file code from the Manual: db = DAL("sqlite://storage.sqlite") db.define_table('image', Field('title', unique=True), Field('file', 'upload'), format = '%(title)s') ... And by the way column name 'file' from the Manual code raises error because 'file' is reserved word if 'check_reserved=['all']' is activated. On Friday, October 19, 2012 at 2:24:09 AM UTC+3, Massimo Di Pierro wrote: > > I think you simply had some additional model files that override the db > variable. > > On Thursday, 18 October 2012 14:36:15 UTC-5, mikech wrote: >> >> I uninstalled the images app and reinstalled it using the wizard rather >> than the new simple app option. The auth tables show up now. >> So, it depends on how the app is setup >> Mike >> >> On Thursday, October 18, 2012 10:59:02 AM UTC-7, Massimo Di Pierro wrote: >>> >>> Is it possible you have two db = DAL(...) in your code (perhaps in >>> different model files)? >>> >>> On Thursday, 18 October 2012 12:36:00 UTC-5, mikech wrote: Hi Bill don't want to take up much of your time. I've verified that the auth_* tables are defined using a sqllite2009 pro. I've included a screen shot attached. And I've also included a screenshot of the appadmin page which shows just 2 files image and comment. This is consistent with the image in the book by the way. On Thursday, October 18, 2012 9:21:39 AM UTC-7, mikech wrote: > > Thanks Bill. > What I'm trying to find out is how do I access the tables involved > with security. Do I need to create views, or is there already some > associated with the appadmin? > > On Wednesday, October 17, 2012 7:55:02 PM UTC-7, Bill Thayer wrote: >> >> Try this: >> In db.py: >> from gluon.tools import Auth, Crud, Service, PluginManager, >> prettydate >> auth = Auth(db) >> crud, service, plugins = Crud(db), Service(), PluginManager() >> >> auth.define_tables(username=True) # arg makes it so you can use a >> username instead of email to login >> >> >> >> On Wednesday, October 17, 2012 6:20:48 PM UTC-5, mikech wrote: >>> >>> I'm working thru the book again, and when I get to the image >>> tutorial it mentions adding a manager group to the auth tables in >>> appadmin: >>> >>> "Using appadmin create a group "manager" and make some users >>> members of the group. They will not be able to access" >>> >>> I cannot find where this is, when I bring up the appadmin it just >>> shows the two tables of the application - image and comment. >>> >> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[web2py] Re: How to access the auth tables in appadmin?
Thanks Bill. What I'm trying to find out is how do I access the tables involved with security. Do I need to create views, or is there already some associated with the appadmin? On Wednesday, October 17, 2012 7:55:02 PM UTC-7, Bill Thayer wrote: Try this: In db.py: from gluon.tools import Auth, Crud, Service, PluginManager, prettydate auth = Auth(db) crud, service, plugins = Crud(db), Service(), PluginManager() auth.define_tables(username=True) # arg makes it so you can use a username instead of email to login On Wednesday, October 17, 2012 6:20:48 PM UTC-5, mikech wrote: I'm working thru the book again, and when I get to the image tutorial it mentions adding a manager group to the auth tables in appadmin: Using appadmin create a group manager and make some users members of the group. They will not be able to access I cannot find where this is, when I bring up the appadmin it just shows the two tables of the application - image and comment. --
[web2py] Re: How to access the auth tables in appadmin?
Sounds like those auth_ tables are not defined. If you already have those lines in your db.py then the tables should be listed in your apadmin. If so then you just follow the instructions in my other post. https://groups.google.com/d/msg/web2py/AEBFWeS8YSA/2LWC4NqdaiAJ to get the permissions set correctly. On Thursday, October 18, 2012 11:21:39 AM UTC-5, mikech wrote: Thanks Bill. What I'm trying to find out is how do I access the tables involved with security. Do I need to create views, or is there already some associated with the appadmin? On Wednesday, October 17, 2012 7:55:02 PM UTC-7, Bill Thayer wrote: Try this: In db.py: from gluon.tools import Auth, Crud, Service, PluginManager, prettydate auth = Auth(db) crud, service, plugins = Crud(db), Service(), PluginManager() auth.define_tables(username=True) # arg makes it so you can use a username instead of email to login On Wednesday, October 17, 2012 6:20:48 PM UTC-5, mikech wrote: I'm working thru the book again, and when I get to the image tutorial it mentions adding a manager group to the auth tables in appadmin: Using appadmin create a group manager and make some users members of the group. They will not be able to access I cannot find where this is, when I bring up the appadmin it just shows the two tables of the application - image and comment. --
[web2py] Re: How to access the auth tables in appadmin?
Hi Bill don't want to take up much of your time. I've verified that the auth_* tables are defined using a sqllite2009 pro. I've included a screen shot attached. And I've also included a screenshot of the appadmin page which shows just 2 files image and comment. This is consistent with the image in the book by the way. On Thursday, October 18, 2012 9:21:39 AM UTC-7, mikech wrote: Thanks Bill. What I'm trying to find out is how do I access the tables involved with security. Do I need to create views, or is there already some associated with the appadmin? On Wednesday, October 17, 2012 7:55:02 PM UTC-7, Bill Thayer wrote: Try this: In db.py: from gluon.tools import Auth, Crud, Service, PluginManager, prettydate auth = Auth(db) crud, service, plugins = Crud(db), Service(), PluginManager() auth.define_tables(username=True) # arg makes it so you can use a username instead of email to login On Wednesday, October 17, 2012 6:20:48 PM UTC-5, mikech wrote: I'm working thru the book again, and when I get to the image tutorial it mentions adding a manager group to the auth tables in appadmin: Using appadmin create a group manager and make some users members of the group. They will not be able to access I cannot find where this is, when I bring up the appadmin it just shows the two tables of the application - image and comment. -- attachment: images.pngattachment: images-appadmin.png
[web2py] Re: How to access the auth tables in appadmin?
Is it possible you have two db = DAL(...) in your code (perhaps in different model files)? On Thursday, 18 October 2012 12:36:00 UTC-5, mikech wrote: Hi Bill don't want to take up much of your time. I've verified that the auth_* tables are defined using a sqllite2009 pro. I've included a screen shot attached. And I've also included a screenshot of the appadmin page which shows just 2 files image and comment. This is consistent with the image in the book by the way. On Thursday, October 18, 2012 9:21:39 AM UTC-7, mikech wrote: Thanks Bill. What I'm trying to find out is how do I access the tables involved with security. Do I need to create views, or is there already some associated with the appadmin? On Wednesday, October 17, 2012 7:55:02 PM UTC-7, Bill Thayer wrote: Try this: In db.py: from gluon.tools import Auth, Crud, Service, PluginManager, prettydate auth = Auth(db) crud, service, plugins = Crud(db), Service(), PluginManager() auth.define_tables(username=True) # arg makes it so you can use a username instead of email to login On Wednesday, October 17, 2012 6:20:48 PM UTC-5, mikech wrote: I'm working thru the book again, and when I get to the image tutorial it mentions adding a manager group to the auth tables in appadmin: Using appadmin create a group manager and make some users members of the group. They will not be able to access I cannot find where this is, when I bring up the appadmin it just shows the two tables of the application - image and comment. --
[web2py] Re: How to access the auth tables in appadmin?
I uninstalled the images app and reinstalled it using the wizard rather than the new simple app option. The auth tables show up now. So, it depends on how the app is setup Mike On Thursday, October 18, 2012 10:59:02 AM UTC-7, Massimo Di Pierro wrote: Is it possible you have two db = DAL(...) in your code (perhaps in different model files)? On Thursday, 18 October 2012 12:36:00 UTC-5, mikech wrote: Hi Bill don't want to take up much of your time. I've verified that the auth_* tables are defined using a sqllite2009 pro. I've included a screen shot attached. And I've also included a screenshot of the appadmin page which shows just 2 files image and comment. This is consistent with the image in the book by the way. On Thursday, October 18, 2012 9:21:39 AM UTC-7, mikech wrote: Thanks Bill. What I'm trying to find out is how do I access the tables involved with security. Do I need to create views, or is there already some associated with the appadmin? On Wednesday, October 17, 2012 7:55:02 PM UTC-7, Bill Thayer wrote: Try this: In db.py: from gluon.tools import Auth, Crud, Service, PluginManager, prettydate auth = Auth(db) crud, service, plugins = Crud(db), Service(), PluginManager() auth.define_tables(username=True) # arg makes it so you can use a username instead of email to login On Wednesday, October 17, 2012 6:20:48 PM UTC-5, mikech wrote: I'm working thru the book again, and when I get to the image tutorial it mentions adding a manager group to the auth tables in appadmin: Using appadmin create a group manager and make some users members of the group. They will not be able to access I cannot find where this is, when I bring up the appadmin it just shows the two tables of the application - image and comment. --
[web2py] Re: How to access the auth tables in appadmin?
I think you simply had some additional model files that override the db variable. On Thursday, 18 October 2012 14:36:15 UTC-5, mikech wrote: I uninstalled the images app and reinstalled it using the wizard rather than the new simple app option. The auth tables show up now. So, it depends on how the app is setup Mike On Thursday, October 18, 2012 10:59:02 AM UTC-7, Massimo Di Pierro wrote: Is it possible you have two db = DAL(...) in your code (perhaps in different model files)? On Thursday, 18 October 2012 12:36:00 UTC-5, mikech wrote: Hi Bill don't want to take up much of your time. I've verified that the auth_* tables are defined using a sqllite2009 pro. I've included a screen shot attached. And I've also included a screenshot of the appadmin page which shows just 2 files image and comment. This is consistent with the image in the book by the way. On Thursday, October 18, 2012 9:21:39 AM UTC-7, mikech wrote: Thanks Bill. What I'm trying to find out is how do I access the tables involved with security. Do I need to create views, or is there already some associated with the appadmin? On Wednesday, October 17, 2012 7:55:02 PM UTC-7, Bill Thayer wrote: Try this: In db.py: from gluon.tools import Auth, Crud, Service, PluginManager, prettydate auth = Auth(db) crud, service, plugins = Crud(db), Service(), PluginManager() auth.define_tables(username=True) # arg makes it so you can use a username instead of email to login On Wednesday, October 17, 2012 6:20:48 PM UTC-5, mikech wrote: I'm working thru the book again, and when I get to the image tutorial it mentions adding a manager group to the auth tables in appadmin: Using appadmin create a group manager and make some users members of the group. They will not be able to access I cannot find where this is, when I bring up the appadmin it just shows the two tables of the application - image and comment. --
[web2py] Re: How to access the auth tables in appadmin?
Try this: In db.py: from gluon.tools import Auth, Crud, Service, PluginManager, prettydate auth = Auth(db) crud, service, plugins = Crud(db), Service(), PluginManager() auth.define_tables(username=True) # arg makes it so you can use a username instead of email to login On Wednesday, October 17, 2012 6:20:48 PM UTC-5, mikech wrote: I'm working thru the book again, and when I get to the image tutorial it mentions adding a manager group to the auth tables in appadmin: Using appadmin create a group manager and make some users members of the group. They will not be able to access I cannot find where this is, when I bring up the appadmin it just shows the two tables of the application - image and comment. --