Try run
python web2py.py -S welcome
then do things manually
>>> db = DAL('oracle://....',migrate=True)
>>> db.define_tables('person',Field('name'))
etc. See what goes wrong. If your want to access tables that are already
there you set migrate=False but still need to define_table them.
On Monday, 8 October 2012 21:08:58 UTC-5, Cliff Kachinske wrote:
>
> Can you connect to the database outside of Web2py?
>
> The long delay can mean connection problems, which I have induced by
> typing the db name incorrectly.
>
> On Monday, October 8, 2012 8:06:58 PM UTC-4, Bill Thayer wrote:
>>
>> Hi Massimo,
>>
>> Thank you.
>>
>> After installing the latest version I deleted the contents of the
>> databases folder and run with DAL(...,migrate=True) got one error, set the
>> table causing the error to migrate=false and re-ran. Now all the database
>> tables are created but now (after seting my settings.migrate to False in
>> 0.py the browser just shows the spinner when I try to access my app's index
>> page. The progress bar is shows only half progress.
>>
>> Regards,
>> Bill
>>
>> On Monday, October 8, 2012 5:53:04 PM UTC-5, Massimo Di Pierro wrote:
>>>
>>> LOL
>>>
>>> - Make sure you use stable "Version 2.0.9 (2012-09-13 23:51:30)" of the
>>> latest trunk. Not any intermediate version.
>>> - do not use the wizard if you do not want crap. The wizard is
>>> experimental and not the best piece of web2py.
>>> - If your tables already exist and you are happy with them run onces
>>> with db = DAL(....,fake_migrate=True) and then run with
>>> DAL(...,migrate=false)
>>> - If instead you want web2py to create tables and use migrations, delete
>>> you database, re-create it empty, delete everything under
>>> yourapp/databases/ and run with DAL(...,migrate=True).
>>>
>>> On Monday, 8 October 2012 17:33:06 UTC-5, Bill Thayer wrote:
>>>>
>>>> Ok,
>>>>
>>>> I have my Oracle database. From some attempted migrations I have the
>>>> auth tables defined and two other tables defined of about 17 tables.The
>>>> typical error is Object with that name already exists or some crap like
>>>> that. I figured clicking the clean button would help... DON"T DO THAT! Now
>>>> my browser just spins and spins.
>>>>
>>>> My SQL log has a bunch of crap that i do not want created in my
>>>> database like archive tables that the wizard created. Yet if I delete the
>>>> log file it will not re-create with a fresh log.
>>>>
>>>> After restoiring my backup my sql.log file has 2627 lines in it and the
>>>> time stamps go back 6 days when I started this all from scratch.
>>>>
>>>> Without having to re-create my application again. How can i just get a
>>>> nice clean SQL file and how, once connect to my DB can I get my new db.py
>>>> or db_wizard.py definitions to make the database tables that aren't
>>>> already
>>>> created without throwing errors for the ones that already are?
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
--
