Sqlalchemy.exc.operationalerror: (operationalerror) Unable To Open Database File None None

I am running a program from another person who are inconvenience ask for help from. The program is a website. Server end is written by python and flask (module, http://flask.pocoo.

Solution 1:

Replace:

app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:////dbdir/test.db'

With:

app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///dbdir/test.db'

Solution 2:

finally figured it out, had help tho

 import os

file_path = os.path.abspath(os.getcwd())+"\database.db"

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///'+file_path
 db = SQLAlchemy(app)

Solution 3:

I had this issue with sqlite. The process trying to open the database file needs to have write access to the directory as it creates temporary/lock files.

The following structure worked for me to allow www-data to use the database.

%> ls -l
drwxrwxr-x  2 fmlheureux www-data     4096 Feb 17 13:24 database-dir

%> ls -l database-dir/
-rw-rw-r-- 1 fmlheureux www-data 40960 Feb 17 13:28 database.sqlite

Solution 4:

My database URI started rocking after adding one dot in between ////. Working on windows 7. I had directory and db-file created prior to calling this.

app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///./dbdir/test.db'

Solution 5:

I think I've seen errors like this where file permissions were wrong for the .db file or its parent directory. You might make sure that the process trying to access the database can do so by appropriate use of chown or chmod.

This is specifically about Django, but maybe still relevant: https://serverfault.com/questions/57596/why-do-i-get-sqlite-error-unable-to-open-database-file