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/secure/SessionMiddleware.py

 import json
-from typing import Callable, Dict, Mapping
+import logging
 import uuid
+from typing import Callable, Dict, Mapping
 
 from cryptography.fernet import Fernet
 from starlette.datastructures import MutableHeaders
@@ -73,6 +74,7 @@ class SessionMiddleware:
                 scope["session"] = await self.get_session(session_id)
                 initial_session_was_empty = False
             except Exception:
+                logging.exception(f"Error loading session {session_id}")
                 scope["session"] = {}
         else:
             scope["session"] = {}