Hi
Thanks for getting back. I got sidetracked with holiday travels and some
other work.
Here is what finally worked. I made sure that my databases folder was
completed empty (not just the .table files). I switched everything to:
db = DAL(... migrate_enabled=False, migrate=False)
db.define_table(
auth.settings.table_user_name,... migrate=False)
auth.define_tables(username=True, signature=False, migrate=False)
And then I switched it to:
db = DAL(... migrate_enabled=True)
db.define_table(
auth.settings.table_user_name,... migrate=True)
auth.define_tables(username=True, signature=False, migrate=True)
Using the combination of these two settings in that order and making sure
the databases folder was completely empty seemed to be the fix...
On Fri, Dec 23, 2016 at 5:23 PM, Dave S <[email protected]> wrote:
>
>
> On Thursday, December 22, 2016 at 3:14:20 PM UTC-8, b.l. masters wrote:
>>
>> Ok. Actually that was something. I realized that I gave the directories
>> the wrong permissions when I created these. So I went ahead and reassigned
>> to www-data and now I am getting the following:
>>
>> Validation error, field:username <gluon.validators.IS_NOT_IN_DB object at
>> 0x7f1d49dcd2d0>
>>
>> It has now created databases. Or at least there are database files
>> showing in the databases directory. However, when I attempt to create a
>> user, this is the traceback message from the Database administration view:
>>
>> Traceback (most recent call last):
>>
>> [...]
>
>> File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py",
>> line 1382, in log_execute
>> ret = self.get_cursor().execute(command, *a[1:], **b)
>> OperationalError: no such table: auth_user
>>
>>
>> But this feels like progress. :-)
>>
>> These are my current settings migration settings:
>>
>> db = DAL(..., migrate=True, fake_migrate_all=True)
>>
>> db.define_table(..., migrate=True, fake_migrate=True
>>
>> auth.define_tables(username=True, signature=False, migrate=True)
>>
>> Thanks again for any help.
>>
>
> Do you instantiate Auth in your db.py?
>
> /dps
>
> --
> 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 a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/
> topic/web2py/e3SYa5D6HB0/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
