Api hotfix sqlalchemy

Webservice logs showed errors when trying to log in:

authlib.integrations.base_client.errors.MismatchingStateError: mismatching_state: CSRF Warning! State not equal in request and response.

Database sessions were unable to load, so the session state was not available for authentication. This appears to be related to an interaction between encode/databases and sqlalchemy 1.4.42 seems to cause issues with databases (https://stackoverflow.com/a/74102692). Pinning sqlalchemy to 1.4.41 resolves the issue for now.

• pinned sqlalchemy to 1.4.41
• added logging for exceptions that occur while loading sessions
• added INFO level logging by default, configured with LOG_LEVEL=INFO environment variable

/cc @erigler

geomagio/api/app.py

@@ -15,10 +15,10 @@ from starlette.responses import RedirectResponse
 from . import secure, ws
 from .db import database
 
-# configure logging
-DEBUG = os.getenv('DEBUG', 'false')
-LOG_LEVEL = logging.DEBUG if DEBUG == "true" else logging.INFO
-logging.basicConfig(level=LOG_LEVEL)
+LOG_BASIC_CONFIG = os.getenv("LOG_BASIC_CONFIG", "false")
+LOG_LEVEL = os.getenv("LOG_LEVEL", "INFO")
+if LOG_BASIC_CONFIG == "true":
+    logging.basicConfig(level=LOG_LEVEL)
 
 app = FastAPI()
 app.mount("/ws/secure", secure.app)