Hello,
I know this has been posted before, I read all the questions and answers on the same topic. Unfortunately, none of the answers applied to me.
To summarize:
-
I'm using flask and sqlalchemy
-
I'm using sqlite because mysql kept denying connections, and half of the requests resulted in "Something went wrong :-(" and an error from sqlalchemy about how 'mysql has gone away'. Great success, yes?
-
The database url is specified as a full path:
os.environ['KATZ_DATABASE_URL'] = 'sqlite:///var/www/sites/katzstudio/db/katz.db'
-
The db file has access a+rwx
-
The db folder has access a+rwx. Hell, even the app folder has a+rwx rights.
-
Logging in with ssh and running commands against the database through the python shell (using the app db connection) works fine
-
Querying the database with the sqlite3 client works fine
-
Yes, the path I used with ssh and the path used by the app are the same. I used copy & paste. I also checked the logs.
-
Yes, I have restarted the app. A bazillion times. After every change.
What doesn't work, is the application. Am I missing something? And please, don't recommend using mysql unless there's a clear solution to solving the connection problems.