Well whatever the case was it did give me some errors, cant remember which
now but I tried a few things to no avail.
I know its always this way starting out, been around the block a few times
already :)
On Fri, Jun 28, 2013 at 1:34 PM, LightDot <light...@gmail.com> wrote:
> On Friday, June 28, 2013 6:59:19 PM UTC+2, Tom Russell wrote:
>>
>> Yea thanks I tried that as well with no luck.
>>
>
> That's impossible. But never mind, hang in there, after you finish your
> first project, you'll be remembering this beginnings with a smile.
>
>
>> I ended up just creating a new db_wizard.py in my model and this set up
>> works great now. Its mentioned in the book but thats it, just mentioned.
>> For new users there should be a guide to setting all of this up correctly.
>> Maybe there is? I could write something up when I am done sorting it all
>> out.
>>
>> Thanks
>>
>
> Sure, no problem.
>
> Regards,
> Ales
>
>
>>
>> On Fri, Jun 28, 2013 at 12:51 PM, LightDot <ligh...@gmail.com> wrote:
>>
>>> Well, you have:
>>>
>>>
>>> db = DAL('sqlite://storage.sqlite',**pool_size=1,check_reserved=['**
>>> all'])
>>>
>>> defined, then you initiate auth with:
>>>
>>> auth.define_tables(username=**True, signature=True)
>>>
>>> which sets up auth tables etc. in the above database. But then you
>>> override the previously set db with:
>>>
>>>
>>> db = DAL('sqlite://webform.sqlite')
>>>
>>> in which you define your own tables. So basically you have set up auth
>>> in one database, then you stop using it and use another database, which has
>>> no auth set up. That can't work.
>>>
>>> Simply define db just once, not twice. Use the definition web2py has
>>> suggested for you and change the database name if you want to.
>>>
>>> Regards,
>>> Ales
>>>
>>>
>>>
>>> On Friday, June 28, 2013 5:05:50 PM UTC+2, Tom Russell wrote:
>>>>
>>>> I am confused about how I have my db.py set up for tables etc.
>>>>
>>>> At the top I have what is generated for me:
>>>>
>>>> if not request.env.web2py_runtime_**gae**:
>>>> ## if NOT running on Google App Engine use SQLite or other DB
>>>> db = DAL('sqlite://storage.sqlite',****
>>>> pool_size=1,check_reserved=['**a**ll'])
>>>> else:
>>>> ## connect to Google BigTable (optional
>>>> 'google:datastore://namespace'****)
>>>> db = DAL('google:datastore')
>>>> ## store sessions and tickets there
>>>> session.connect(request, response, db=db)
>>>> ## or store session in Memcache, Redis, etc.
>>>> ## from gluon.contrib.memdb import MEMDB
>>>> ## from google.appengine.api.memcache import Client
>>>> ## session.connect(request, response, db = MEMDB(Client()))
>>>>
>>>> from gluon.tools import Auth, Crud, Service, PluginManager,
>>>> prettydate, Mail
>>>> auth = Auth(db)
>>>> crud, service, plugins = Crud(db), Service(), PluginManager()
>>>> db._common_fields.append(auth.****signature) ## adds signature fields
>>>> to all tables
>>>> ## create all tables needed by auth if not custom tables
>>>> auth.define_tables(username=**Tr**ue, signature=True)
>>>>
>>>> And then from examples I have for my db down a ways is:
>>>>
>>>> db = DAL('sqlite://webform.sqlite')
>>>>
>>>> then I define my tables...
>>>>
>>>>
>>>> Problem with this is though I am trying to use http://www.web2pyslices.
>>>> **co**m/slice/show/1542/manage-**users**-and-memebership-in-the-**same-
>>>> **form<http://www.web2pyslices.com/slice/show/1542/manage-users-and-memebership-in-the-same-form>because
>>>> I need that feature but when trying to use it I get an error cause
>>>> auth_user doesnt exist. Well it doesnt because I set db =
>>>> DAL('sqlite://webform.sqlite') but in default.py I do have:
>>>>
>>>> def user():
>>>> """
>>>> exposes:
>>>> http://..../[app]/default/**user**/login
>>>> http://..../[app]/default/**user**/logout
>>>> http://..../[app]/default/**user**/register
>>>> http://..../[app]/default/**user**/profile
>>>> http://..../[app]/default/**user**/retrieve_password
>>>> http://..../[app]/default/**user**/change_password
>>>> http://..../[app]/default/**user**/manage_users (requires
>>>> membership in
>>>> use @auth.requires_login()
>>>> @auth.requires_membership('**gro**up name')
>>>> @auth.requires_permission('**rea**d','table name',record_id)
>>>> to decorate functions that need access control
>>>> """
>>>> return dict(form=auth())
>>>>
>>>> So bottom line, how do I get around or use auth_user in my app. If I
>>>> comment out my
>>>> db = DAL('sqlite://webform.sqlite') but in default.py, nothing works.
>>>>
>>>> Any help?
>>>>
>>>> Thanks
>>>>
>>>> --
>>>
>>> ---
>>> 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+un...@**googlegroups.com.
>>>
>>> For more options, visit
>>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out>
>>> .
>>>
>>>
>>>
>>
>> --
>
> ---
> 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/groups/opt_out.
>
>
>
--
---
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/groups/opt_out.
