[web2py] Re: How to access the auth tables in appadmin?

2016-01-17 Thread Dmitry Chuvikovsky
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=['al

[web2py] Re: How to access the auth tables in appadmin?

2012-10-18 Thread Massimo Di Pierro
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 depend

[web2py] Re: How to access the auth tables in appadmin?

2012-10-18 Thread mikech
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(...)

[web2py] Re: How to access the auth tables in appadmin?

2012-10-18 Thread Massimo Di Pierro
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

[web2py] Re: How to access the auth tables in appadmin?

2012-10-18 Thread mikech
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

[web2py] Re: How to access the auth tables in appadmin?

2012-10-18 Thread Bill Thayer
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 se

[web2py] Re: How to access the auth tables in appadmin?

2012-10-18 Thread mikech
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 impor

[web2py] Re: How to access the auth tables in appadmin?

2012-10-17 Thread Bill Thayer
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