Unable to create database (Windows 10)

[Josh Itinus]

Hello All,

I'm trying to start trytond-admin to create a started database but keep getting a "Database does not exist" error.

My config file is basic with just this line:

[database]

path=D:/BitBucket/Python/Tryton/

PS C:\Windows\system32> python C:\ProgramData\Anaconda3\Scripts\trytond-admin -c D:\BitBucket\Python\sqlite.confi

 -d TrytonDB --all

Timezone must be set to UTC instead of Central Standard Time

Traceback (most recent call last):

  File "C:\ProgramData\Anaconda3\Scripts\trytond-admin", line 21, in <module>

    admin.run(options)

  File "C:\ProgramData\Anaconda3\lib\site-packages\trytond\admin.py", line 24, in run

    with Transaction().start(db_name, 0):

  File "C:\ProgramData\Anaconda3\lib\site-packages\trytond\transaction.py", line 87, in start

    database = Database(database_name).connect()

  File "C:\ProgramData\Anaconda3\lib\site-packages\trytond\backend\sqlite\database.py", line 220, in connect

    raise IOError('Database "%s" doesn\'t exist!' % db_filename)

OSError: Database "TrytonDB.sqlite" doesn't exist!

Any pointers are greatly appreciated.

rgds
JI

[Cédric Krier]

On 2017-02-25 07:46, Josh Itinus wrote:
> raise IOError('Database "%s" doesn\'t exist!' % db_filename)
> OSError: Database "TrytonDB.sqlite" doesn't exist!

You have to create the empty file.

--
Cédric Krier - B2CK SPRL
Email/Jabber: cedric...@b2ck.com
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/

[Josh Itinus]

It seems the configuration requires .sqlite to be the extension. So make sure to create a new file with that ext.

JI