Re: Exception trying to install pgadmin4 version 8.4

Added to existing issue
https://github.com/pgadmin-org/pgadmin4/issues/7266#issuecomment-1987956752.
..

On Mon, 11 Mar 2024 at 03:17, Khushboo Vashi <
khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:

>
>
> On Sun, Mar 10, 2024 at 7:06 PM Shaheed Haque <shaheedhaque(at)gmail(dot)com>
> wrote:
>
>> OK, it looks as though this problem occurs newly in flask-migrate 4.0.6.
>> It looks as though the changes here:
>>
>>
>> https://github.com/miguelgrinberg/Flask-Migrate/commit/6f3f889c36030134f87dc1db327c2385d873a4d6
>>
>> introduce some new behaviour which I guess pgadmin4 does not yet support.
>> Can I gently request that the pgadmin4 team look into this further? I am of
>> course happy to test as needed.
>>
>> Please log a request @ https://github.com/pgadmin-org/pgadmin4/issues
>
>> Thanks, Shaheed
>>
>> On Sun, 10 Mar 2024 at 10:56, Shaheed Haque <shaheedhaque(at)gmail(dot)com>
>> wrote:
>>
>>> Hi,
>>>
>>> I have a scripted install for pgadmin4 which worked as expected for
>>> pgadmin7.7 when last used. I'm now trying to install 8.4 in a new VM, and
>>> it fails like this:
>>>
>>> $ sudo -i -u ubuntu PGADMIN_SETUP_EMAIL=xxx(at)123(dot)com
>>> PGADMIN_SETUP_PASSWORD=abcd python3
>>> /home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/setup.py setup-db
>>> 2024-03-10 03:13:21,163: ERROR pgadmin: Database migration failed
>>> 2024-03-10 03:13:21,164: ERROR pgadmin: Traceback (most recent
>>> call last):
>>> File
>>> "/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/pgadmin/__init__.py",
>>> line 386, in upgrade_db
>>> db_upgrade(app)
>>> File
>>> "/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/pgadmin/setup/db_upgrade.py",
>>> line 22, in db_upgrade
>>> flask_migrate.upgrade(migration_folder)
>>> File
>>> "/home/ubuntu/venv/lib/python3.10/site-packages/flask_migrate/__init__.py",
>>> line 111, in wrapped
>>> f(*args, **kwargs)
>>> File
>>> "/home/ubuntu/venv/lib/python3.10/site-packages/flask_migrate/__init__.py",
>>> line 198, in upgrade
>>> config =
>>> current_app.extensions['migrate'].migrate.get_config(directory,
>>> File
>>> "/home/ubuntu/venv/lib/python3.10/site-packages/flask_migrate/__init__.py",
>>> line 96, in get_config
>>> for x in g.x_arg:
>>> File "/home/ubuntu/venv/lib/python3.10/site-packages/flask/ctx.py",
>>> line 54, in __getattr__
>>> raise AttributeError(name) from None
>>> AttributeError: x_arg
>>> ...
>>> ascii art traceback
>>> ...
>>> AttributeError: x_arg
>>>
>>> During handling of the above exception, another exception occurred:
>>> ...
>>> ascii art traceback
>>> ...
>>> FileNotFoundError: [Errno 2] No such file or directory:
>>> '/var/lib/pgadmin/pgadmin4.db' ->
>>> '/var/lib/pgadmin/pgadmin4.db.20240310031321'
>>>
>>> Note: the argument "setup-db" was not previously used, but seems
>>> required now. I've enclosed the output of "pip freeze" below. I have
>>> verified that the directory "/var/lib/pgadmin" exists, and is writeable by
>>> the user "ubuntu". In the same directory as setup.py is the following file:
>>>
>>> $ cat
>>> /home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/config_local.py
>>> LOG_FILE = '/var/log/pgadmin/pgadmin4.log'
>>> SQLITE_PATH = '/var/lib/pgadmin/pgadmin4.db'
>>> SESSION_DB_PATH = '/var/lib/pgadmin/sessions'
>>> STORAGE_DIR = '/var/lib/pgadmin/storage'
>>> AZURE_CREDENTIAL_CACHE_DIR = '/var/lib/pgadmin/azurecredentialcache'
>>> <<< new entry
>>> KERBEROS_CCACHE_DIR = '/var/lib/pgadmin/kerberoscache'
>>> <<< new entry
>>> SERVER_MODE = True
>>>
>>> Note: I have highlighted a couple of entries which I added after reading
>>> the current installation documentation. I also tried launching the VM with
>>> the previously working pgadmin4 7.7
>>>
>>> $ sudo -i -u ubuntu PGADMIN_SETUP_EMAIL=123(at)123(dot)com
>>> PGADMIN_SETUP_PASSWORD=abcdedg python3
>>> /home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/setup.py setup-db
>>> 2024-03-10 10:04:24,371: ERROR pgadmin: Database migration failed
>>> 2024-03-10 10:04:24,372: ERROR pgadmin: Traceback (most recent
>>> call last):
>>> File
>>> "/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/pgadmin/__init__.py",
>>> line 390, in upgrade_db
>>> db_upgrade(app)
>>> File
>>> "/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/pgadmin/setup/db_upgrade.py",
>>> line 25, in db_upgrade
>>> flask_migrate.upgrade(migration_folder)
>>> File
>>> "/home/ubuntu/venv/lib/python3.10/site-packages/flask_migrate/__init__.py",
>>> line 111, in wrapped
>>> f(*args, **kwargs)
>>> File
>>> "/home/ubuntu/venv/lib/python3.10/site-packages/flask_migrate/__init__.py",
>>> line 198, in upgrade
>>> config =
>>> current_app.extensions['migrate'].migrate.get_config(directory,
>>> File
>>> "/home/ubuntu/venv/lib/python3.10/site-packages/flask_migrate/__init__.py",
>>> line 96, in get_config
>>> for x in g.x_arg:
>>> File "/home/ubuntu/venv/lib/python3.10/site-packages/flask/ctx.py",
>>> line 52, in __getattr__
>>> raise AttributeError(name) from None
>>> AttributeError: x_arg
>>> Traceback (most recent call last):
>>> File
>>> "/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/pgadmin/__init__.py",
>>> line 390, in upgrade_db
>>> db_upgrade(app)
>>> File
>>> "/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/pgadmin/setup/db_upgrade.py",
>>> line 25, in db_upgrade
>>> flask_migrate.upgrade(migration_folder)
>>> File
>>> "/home/ubuntu/venv/lib/python3.10/site-packages/flask_migrate/__init__.py",
>>> line 111, in wrapped
>>> f(*args, **kwargs)
>>> File
>>> "/home/ubuntu/venv/lib/python3.10/site-packages/flask_migrate/__init__.py",
>>> line 198, in upgrade
>>> config =
>>> current_app.extensions['migrate'].migrate.get_config(directory,
>>> File
>>> "/home/ubuntu/venv/lib/python3.10/site-packages/flask_migrate/__init__.py",
>>> line 96, in get_config
>>> for x in g.x_arg:
>>> File "/home/ubuntu/venv/lib/python3.10/site-packages/flask/ctx.py",
>>> line 52, in __getattr__
>>> raise AttributeError(name) from None
>>> AttributeError: x_arg
>>> During handling of the above exception, another exception occurred:
>>> Traceback (most recent call last):
>>> File
>>> "/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/setup.py", line
>>> 220, in <module>
>>> app = create_app()
>>> File
>>> "/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/pgadmin/__init__.py",
>>> line 477, in create_app
>>> run_migration_for_sqlite()
>>> File
>>> "/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/pgadmin/__init__.py",
>>> line 414, in run_migration_for_sqlite
>>> upgrade_db()
>>> File
>>> "/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/pgadmin/__init__.py",
>>> line 395, in upgrade_db
>>> backup_db_file()
>>> File
>>> "/home/ubuntu/venv/lib/python3.10/site-packages/pgadmin4/pgadmin/__init__.py",
>>> line 372, in backup_db_file
>>> os.rename(SQLITE_PATH, backup_file_name)
>>> FileNotFoundError: [Errno 2] No such file or directory:
>>> '/var/lib/pgadmin/pgadmin4.db' ->
>>> '/var/lib/pgadmin/pgadmin4.db.20240310100424'
>>>
>>> Note that 7.7 fails in the same way with or without the newly added
>>> "setup-db" argument. Given this pattern, my guess is that flask-migrate or
>>> flask is possibly the issue, rather than pgadmin4, but I have not been able
>>> to debug/confirm that.
>>>
>>> Any advice appreciated.
>>>
>>> Thanks, Shaheed
>>>
>>> Ecls: pip freeze output...
>>>
>>> (venv) srhaque-paiyroll-28edd545c2 pip freeze
>>> ...
>>> Flask==2.3.3
>>> flask-babel==4.0.0
>>> Flask-Compress==1.14
>>> Flask-Gravatar==0.5.0
>>> Flask-Login==0.6.3
>>> Flask-Mail==0.9.1
>>> Flask-Migrate==4.0.6
>>> Flask-Paranoid==0.3.0
>>> Flask-Principal==0.4.0
>>> Flask-Security-Too==5.3.3
>>> Flask-SocketIO==5.3.6
>>> Flask-SQLAlchemy==3.1.1
>>> Flask-WTF==1.2.1
>>> ...
>>> pgadmin4==8.4
>>>
>>