5

I have a database in sqlite and followed this tutorial on how to create it. I checked, the database exists and contains values.

I entered following SQLAlchemy URI in the web interface of the superset: sqlite:///Users/me/Documents/cancellation/item/eventlog.db

and got following error:

ERROR: {"error": "Connection failed!\n\nThe error message returned
was:\n'NoneType' object has no attribute
'get_password_masked_url_from_uri'"}

I do not understand why there should be a password, if in the documentation there are not passwords specified:

http://docs.sqlalchemy.org/en/rel_1_0/core/engines.html#sqlite

Code:

sqlite_file = 'eventlog.db' # the DB file
conn = sqlite3.connect(sqlite_file) 
eventlog.to_sql('eventlog', conn, if_exists='replace', index=False)
from sqlalchemy import create_engine
>engine = create_engine('sqlite:////Users/me/Documents/cancellation/item/eventlog.db)
Alina
  • 2,191
  • 3
  • 33
  • 68

1 Answers1

3

This issue drove me crazy for the last few days. I eventually found that you actually have to save the database config and then return to the page for the "Test Connection" to actually succeed. Attempts to use the "Test Connection" button prior to hitting Save produce the error message that you listed.

mjd
  • 46
  • 1
  • In the end I inserted it into URI of already provided example of the database. :) – Alina Nov 14 '17 at 19:24
  • 1
    This looks like a bug. It would make sense to post an issue on github (if there is none yet). – dmigo Nov 16 '17 at 10:06