Getting "601:ERROR:flask_appbuilder.security.sqla.manager:DB Creation and initialization failed: (sqlite3.OperationalError) unable to open database file" about superset HOT 12 CLOSED

Found solution. Error happends because flask_manager could not find default db path for sqlite db. To fix this your need to change SQLALCHEMY_DATABASE_URI in caravel config.py

1. Go to your anaconda / python directory.
2. Open %python_path%\Lib\site-packages\caravel\config.py with text editor
3. Find row with SQLALCHEMY_DATABASE_URI connection string and change it according to your operation system / database setup. For windows you should type something like
   'sqlite:///C:\\tmp\\caravel.db'

More examples on connection strings at sql alchemy docs pages:
http://docs.sqlalchemy.org/en/rel_0_9/core/engines.html#database-urls

from superset.

Hi, a note on Windows 10. I did not have to edit / create config files. Creating the now missing C:\Temp worked for me though...

from superset.

HI,

I'm managing with Ubuntu and Windows.
To make it work on windows you'll need to tricks:

• I'm sure about having to change the data path for the sqllite database, but can not find where I did it, sorry. BTW be sure to have an existing "tmp" folder at C:\
• Delete "panoramix\panoramix\static\assets" file and create a symlink to *"..\assest" * instead
  mklink /D assests ..\assests

I'm using Anaconda as well instead normal python distribution. https://www.continuum.io/downloads

Hope this @helps

from superset.

Ubuntu should work great. I'm not planning on ever working on windows support. If someone was to take that on I can review the PRs and just make sure it doesn't break the rest.

from superset.

Looks like you are installing on windows. I have no way to test against or support windows...

from superset.

Thanks, will see if i can figure this out. What platform do you recommend installing for POC?

from superset.

Thanks

from superset.

Under windows you will need to create a panoramix_config.py in your PYTHONPATH.

from superset.

or you can create panoramix_config.py in the same location as config.py and when you run the server config should compile panoramix_config.py

P.S: its changed to caravel_config now ;)

from superset.

Hi, I am also getting the same error on my Windows machine.
Any updates on this?

from superset.

Thanks a ton! Works like charm :)

from superset.

Same for me ! Works perfectly now

from superset.