Problem with SQLalchemy

[IgorHolanda12]

There's a issue with the latest version of sqlalchemy where the the flask instance can't be iniciated. To fix this, change the version on the .txt requirement file to the version before

sqlalchemy==1.4.46

Error:

Usage: flask run [OPTIONS] Try 'flask run --help' for help.

Error: While importing 'app', an ImportError was raised:

Traceback (most recent call last): File "/usr/local/lib/python3.9/dist-packages/flask/cli.py", line 218, in locate_app import(module_name) File "/root/eNMS-4.2/app.py", line 1, in from eNMS.server import server as app # noqa: F401 File "/root/eNMS-4.2/eNMS/init.py", line 1, in from eNMS.controller import controller File "/root/eNMS-4.2/eNMS/controller.py", line 33, in from eNMS.database import db File "/root/eNMS-4.2/eNMS/database.py", line 28, in from sqlalchemy.ext.associationproxy import ASSOCIATION_PROXY ImportError: cannot import name 'ASSOCIATION_PROXY' from 'sqlalchemy.ext.associationproxy' (/usr/local/lib/python3.9/dist-packages/sqlalchemy/ext/associationproxy.py)

[IgorHolanda12]

~/eNMS/build/requirements/requirements.txt

apscheduler argon2-cffi dicttoxml dramatiq[redis, watch] flask flask_login flask-socketio flask_wtf gitpython gunicorn itsdangerous==2.0.1 napalm ncclient netmiko==3.4.0 passlib psutil redis ruamel.yaml sqlalchemy==1.4.46 watchdog wtforms==2.3.3 xlrd xlwt xmltodict

[Dellink86]

the File "/root/eNMS-4.2/eNMS/database.py" has two references to 'ASSOCIATION_PROXY' which is the wrong case. I had to change it to association_proxy to get it working.

[afourmy]

sqlalchemy now pinned to 1.4.46