[pgadmin-org/pgadmin4] f3bb47: Fix an issue where drag and drop object names is n...

2023-02-06 Thread Aditya Toshniwal
  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: f3bb4776e458a6c21bc81b2a9b9e31ad243363ca
  
https://github.com/pgadmin-org/pgadmin4/commit/f3bb4776e458a6c21bc81b2a9b9e31ad243363ca
  Author: Aditya Toshniwal 
  Date:   2023-02-06 (Mon, 06 Feb 2023)

  Changed paths:
M web/pgadmin/static/js/components/PgTree/FileTreeItem/index.tsx

  Log Message:
  ---
  Fix an issue where drag and drop object names is not working. #5761






[pgadmin-org/pgadmin4] 4a3bcf: Use uplot for Dashboard graphs to reduce CPU usage...

2023-02-06 Thread Aditya Toshniwal
  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: 4a3bcfa202a326d95c672040584c258ca62b0ce7
  
https://github.com/pgadmin-org/pgadmin4/commit/4a3bcfa202a326d95c672040584c258ca62b0ce7
  Author: Aditya Toshniwal 
  Date:   2023-02-06 (Mon, 06 Feb 2023)

  Changed paths:
M web/package.json
M web/pgadmin/browser/static/js/node.js
M web/pgadmin/dashboard/__init__.py
M web/pgadmin/dashboard/static/js/Dashboard.jsx
M web/pgadmin/dashboard/static/js/Graphs.jsx
M web/pgadmin/static/css/style.css
M web/pgadmin/static/js/Theme/index.jsx
A web/pgadmin/static/js/Theme/overrides/uplot.override.js
A web/pgadmin/static/js/components/PgChart/StreamingChart.jsx
M web/regression/javascript/dashboard/graphs_spec.js
M web/regression/javascript/dashboard/graphs_wrapper_spec.js
M web/regression/javascript/erd/erd_core_spec.js
M web/regression/javascript/erd/ui_components/ERDTool.spec.js
M web/yarn.lock

  Log Message:
  ---
  Use uplot for Dashboard graphs to reduce CPU usage. #5794






[pgadmin-org/pgadmin4] 6833fd: Ensure that keyboard hotkey to open query tool and...

2023-02-06 Thread Akshay Joshi
  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: 6833fdd7319853dc0b903d1138b276b827995fd3
  
https://github.com/pgadmin-org/pgadmin4/commit/6833fdd7319853dc0b903d1138b276b827995fd3
  Author: Akshay Joshi 
  Date:   2023-02-06 (Mon, 06 Feb 2023)

  Changed paths:
M docs/en_US/release_notes_6_20.rst
M web/pgadmin/browser/static/js/keyboard.js

  Log Message:
  ---
  Ensure that keyboard hotkey to open query tool and search object should work 
properly. #5763


  Commit: 027f23bc47d70b18039265612aab49da46f41c82
  
https://github.com/pgadmin-org/pgadmin4/commit/027f23bc47d70b18039265612aab49da46f41c82
  Author: Akshay Joshi 
  Date:   2023-02-06 (Mon, 06 Feb 2023)

  Changed paths:
M DEPENDENCIES

  Log Message:
  ---
  Update Dependencies


  Commit: 426cc683eb852b3291151224886949f039ebfa69
  
https://github.com/pgadmin-org/pgadmin4/commit/426cc683eb852b3291151224886949f039ebfa69
  Author: Akshay Joshi 
  Date:   2023-02-06 (Mon, 06 Feb 2023)

  Changed paths:
M web/config.py

  Log Message:
  ---
  Update version for release v6.20


Compare: 
https://github.com/pgadmin-org/pgadmin4/compare/4a3bcfa202a3...426cc683eb85




pgAdmin4 v6.20 candidate builds

2023-02-06 Thread Akshay Joshi
Hi All,

pgAdmin4 v6.20 candidate builds and source code is available at
https://developer.pgadmin.org/builds/2023-02-06-1/

Fahar, could you please verify this for Thursday's release?

--
Akshay Joshi
Principal Software Architect
www.enterprisedb.com

*Blog*: https://www.enterprisedb.com/akshay-joshi
*GitHub*: https://github.com/akshay-joshi
*LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216


Re: PGadmi4 - Unable to set up dev environment

2023-02-06 Thread Vaij Bharamshetty
Thank you Aditya, appreciate your help. I still face issues detailed as
below,


*-- Python Version*(venv) [vaij@rocky4 runtime]$ python -V
Python 3.9.14


*-- Clean up existing Packages*pip freeze | xargs pip uninstall -y


*-- Install from Requirements*(venv) [vaij@rocky4 runtime]$ pip install -r
requirements.txt


*-- One Package did not install *ERROR: Could not find a version that
satisfies the requirement subscription-manager==1.29.30 (from versions:
none)
ERROR: No matching distribution found for subscription-manager==1.29.30


*-- Try running setup*(venv) [vaij@rocky4 runtime]$ python3
$PGADMIN4_SRC/web/setup.py
Traceback (most recent call last):
  File "/home/vaij/pgadmin4/web/setup.py", line 24, in 
import config
  File "/home/vaij/pgadmin4/web/config.py", line 25, in 
from pgadmin.utils import env, IS_WIN, fs_short_path
  File "/home/vaij/pgadmin4/web/pgadmin/__init__.py", line 25, in 
from flask_socketio import SocketIO
ModuleNotFoundError: No module named 'flask_socketio'

*-- (Trial and error) Try running with sudo*
(venv) [vaij@rocky4 runtime]$ sudo python3 $PGADMIN4_SRC/web/setup.py
[sudo] password for vaij:
Traceback (most recent call last):
  File "/home/vaij/pgadmin4/web/setup.py", line 24, in 
import config
  File "/home/vaij/pgadmin4/web/config.py", line 25, in 
from pgadmin.utils import env, IS_WIN, fs_short_path
  File "/home/vaij/pgadmin4/web/pgadmin/__init__.py", line 24, in 
from flask import Flask, abort, request, current_app, session, url_for
ModuleNotFoundError: No module named 'flask'


*-- Check existing packages and specifically Flask Version*(venv)
[vaij@rocky4 runtime]$ pip freeze > pgadmin4_packages.txt

Flask==2.1.2
flatbuffers==1.12
fonttools==4.33.3
frozenlist==1.3.0
fsspec==2022.5.0



*-- Try running python3 $PGADMIN4_SRC/web/setup.py-- Manually install
packages after above is failed for the following*(venv) [vaij@rocky4
runtime]$ pip install flask_socketio
flask_babel
flask_login
flask_mail
flask_paranoid
flask_security
email_validator
flask_sqlalchemy
simplejson
flask_migrate


*-- Try running python3 $PGADMIN4_SRC/web/setup.py*(venv) [vaij@rocky4
runtime]$ python3 $PGADMIN4_SRC/web/setup.py
2023-02-06 13:29:58,252: INFO   pgadmin:
 
2023-02-06 13:29:58,253: INFO   pgadmin:Starting pgAdmin 4 v6.19...
2023-02-06 13:29:58,253: INFO   pgadmin:
 
2023-02-06 13:29:58,253: DEBUG  pgadmin:Python syspath:
['/home/vaij/pgadmin4/web', '/usr/lib64/python39.zip',
'/usr/lib64/python3.9', '/usr/lib64/python3.9/lib-dynload',
'/home/vaij/pgadmin4/runtime/venv/lib64/python3.9/site-packages',
'/home/vaij/pgadmin4/runtime/venv/lib/python3.9/site-packages',
'/home/vaij/.local/lib/python3.9/site-packages',
'/usr/local/lib64/python3.9/site-packages',
'/usr/local/lib/python3.9/site-packages',
'/usr/lib64/python3.9/site-packages', '/usr/lib/python3.9/site-packages']
Traceback (most recent call last):
  File "/home/vaij/pgadmin4/web/setup.py", line 220, in 
app = create_app()
  File "/home/vaij/pgadmin4/web/pgadmin/__init__.py", line 302, in
create_app
app.logger.debug('Available translations: %s' %
babel.list_translations())
  File
"/home/vaij/pgadmin4/runtime/venv/lib64/python3.9/site-packages/flask_babel/__init__.py",
line 188, in list_translations
for dirname in get_babel().translation_directories:
  File
"/home/vaij/pgadmin4/runtime/venv/lib64/python3.9/site-packages/flask_babel/__init__.py",
line 44, in get_babel
if not hasattr(app, 'extensions'):
  File
"/home/vaij/pgadmin4/runtime/venv/lib64/python3.9/site-packages/werkzeug/local.py",
line 316, in __get__
obj = instance._get_current_object()  # type: ignore[misc]
  File
"/home/vaij/pgadmin4/runtime/venv/lib64/python3.9/site-packages/werkzeug/local.py",
line 513, in _get_current_object
raise RuntimeError(unbound_message) from None
RuntimeError: Working outside of application context.

This typically means that you attempted to use functionality that needed
the current application. To solve this, set up an application context
with app.app_context(). See the documentation for more information.

Attaching pip freeze for your reference.

On Mon, Feb 6, 2023 at 1:05 AM Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:

> Hi Vaij,
>
> You're using Flask 2.2.2. But the pgAdmin requirements say:
>
> Flask==2.0.3; python_version <= '3.6'
> Flask==2.1.*; python_version >= '3.7'
>
> Please use pgAdmin requirements.txt to create venv.
>
>
> On Mon, Feb 6, 2023 at 10:57 AM Vaij Bharamshetty 
> wrote:
>
>> Hi Aditya,
>>
>> Thank you for reaching out.  Please find the attached output.
>>
>> Vaij
>>
>> On Mon, Feb 6, 2023 at 12:01 AM Aditya Toshniwal <
>> aditya.toshni...@enterprisedb.com> wrote:
>>
>>> Hi Vaij,
>>>
>>> Please share pip freeze output. Looks like some issue with Flask version.
>>>
>>> On Sun, Feb 5, 2023 at 10:00 AM Vaij Bharamshetty 
>>> wrote:
>>>

Re: PGadmi4 - Unable to set up dev environment

2023-02-06 Thread Aditya Toshniwal
Hi Vaij,

You're using requirements.txt from the runtime directory. There is no such
file in the runtime directory.
The correct requirements.txt reside in the pgadmin home directory which has
below content. Please create the venv using the correct requirements.txt
file.

Flask==2.0.3; python_version <= '3.6'
Flask==2.1.*; python_version >= '3.7'
Flask-Gravatar==0.*
Flask-Login==0.*
Flask-Mail==0.*
Flask-Migrate==4.*
dnspython==2.2.1
greenlet==1.1.2; python_version <= '3.10'
Flask-SQLAlchemy==2.5.*
Flask-WTF==1.0.1
Flask-Compress==1.*
Flask-Paranoid==0.*
Flask-Babel==2.*
Flask-Security-Too==4.1.*
Flask-SocketIO<=5.2.0
WTForms==3.*
passlib==1.*
pytz==2021.*
simplejson==3.*
speaklater3==1.*
sqlparse==0.*
psutil==5.9.3
psycopg2==2.9.*
python-dateutil==2.*
SQLAlchemy==1.4.44; python_version <= '3.6'
SQLAlchemy==1.4.*; python_version >= '3.7'
bcrypt==3.*
cryptography==3.*
sshtunnel==0.*
ldap3==2.*
gssapi==1.7.*; python_version <= '3.6'
gssapi==1.8.*; python_version >= '3.7'
eventlet==0.33.0
httpagentparser==1.9.*
user-agents==2.2.0
pywinpty==1.1.*; sys_platform=="win32"
Authlib==0.15.*; python_version <= '3.6'
Authlib==1.1.*; python_version >= '3.7'
requests==2.25.*
pyotp==2.*
qrcode==7.*
Pillow==8.4.*; python_version <= '3.6'
Pillow==9.*; python_version >= '3.7'
boto3==1.23.*; python_version <= '3.6'
boto3==1.26.*; python_version >= '3.7'
botocore==1.26.*; python_version <= '3.6'
botocore==1.29.*; python_version >= '3.7'
urllib3==1.26.*
Werkzeug==2.0.3; python_version <= '3.6'
Werkzeug==2.1.2; python_version >= '3.7'
azure-mgmt-rdbms==10.1.0
azure-mgmt-resource==21.0.0
azure-mgmt-subscription==3.0.0
azure-identity==1.9.0


On Tue, Feb 7, 2023 at 12:07 AM Vaij Bharamshetty  wrote:

> Thank you Aditya, appreciate your help. I still face issues detailed as
> below,
>
>
> *-- Python Version*(venv) [vaij@rocky4 runtime]$ python -V
> Python 3.9.14
>
>
> *-- Clean up existing Packages*pip freeze | xargs pip uninstall -y
>
>
> *-- Install from Requirements*(venv) [vaij@rocky4 runtime]$ pip install
> -r requirements.txt
>
>
> *-- One Package did not install *ERROR: Could not find a version that
> satisfies the requirement subscription-manager==1.29.30 (from versions:
> none)
> ERROR: No matching distribution found for subscription-manager==1.29.30
>
>
> *-- Try running setup*(venv) [vaij@rocky4 runtime]$ python3
> $PGADMIN4_SRC/web/setup.py
> Traceback (most recent call last):
>   File "/home/vaij/pgadmin4/web/setup.py", line 24, in 
> import config
>   File "/home/vaij/pgadmin4/web/config.py", line 25, in 
> from pgadmin.utils import env, IS_WIN, fs_short_path
>   File "/home/vaij/pgadmin4/web/pgadmin/__init__.py", line 25, in 
> from flask_socketio import SocketIO
> ModuleNotFoundError: No module named 'flask_socketio'
>
> *-- (Trial and error) Try running with sudo*
> (venv) [vaij@rocky4 runtime]$ sudo python3 $PGADMIN4_SRC/web/setup.py
> [sudo] password for vaij:
> Traceback (most recent call last):
>   File "/home/vaij/pgadmin4/web/setup.py", line 24, in 
> import config
>   File "/home/vaij/pgadmin4/web/config.py", line 25, in 
> from pgadmin.utils import env, IS_WIN, fs_short_path
>   File "/home/vaij/pgadmin4/web/pgadmin/__init__.py", line 24, in 
> from flask import Flask, abort, request, current_app, session, url_for
> ModuleNotFoundError: No module named 'flask'
>
>
> *-- Check existing packages and specifically Flask Version*(venv)
> [vaij@rocky4 runtime]$ pip freeze > pgadmin4_packages.txt
>
> Flask==2.1.2
> flatbuffers==1.12
> fonttools==4.33.3
> frozenlist==1.3.0
> fsspec==2022.5.0
>
>
>
> *-- Try running python3 $PGADMIN4_SRC/web/setup.py-- Manually install
> packages after above is failed for the following*(venv) [vaij@rocky4
> runtime]$ pip install flask_socketio
> flask_babel
> flask_login
> flask_mail
> flask_paranoid
> flask_security
> email_validator
> flask_sqlalchemy
> simplejson
> flask_migrate
>
>
> *-- Try running python3 $PGADMIN4_SRC/web/setup.py*(venv) [vaij@rocky4
> runtime]$ python3 $PGADMIN4_SRC/web/setup.py
> 2023-02-06 13:29:58,252: INFO   pgadmin:
>  
> 2023-02-06 13:29:58,253: INFO   pgadmin:Starting pgAdmin 4 v6.19...
> 2023-02-06 13:29:58,253: INFO   pgadmin:
>  
> 2023-02-06 13:29:58,253: DEBUG  pgadmin:Python syspath:
> ['/home/vaij/pgadmin4/web', '/usr/lib64/python39.zip',
> '/usr/lib64/python3.9', '/usr/lib64/python3.9/lib-dynload',
> '/home/vaij/pgadmin4/runtime/venv/lib64/python3.9/site-packages',
> '/home/vaij/pgadmin4/runtime/venv/lib/python3.9/site-packages',
> '/home/vaij/.local/lib/python3.9/site-packages',
> '/usr/local/lib64/python3.9/site-packages',
> '/usr/local/lib/python3.9/site-packages',
> '/usr/lib64/python3.9/site-packages', '/usr/lib/python3.9/site-packages']
> Traceback (most recent call last):
>   File "/home/vaij/pgadmin4/web/setup.py", line 220, in 
> app = create_app()
>   File "/home/vaij/pgadmin4/web

Re: PGadmi4 - Unable to set up dev environment

2023-02-06 Thread Vaij Bharamshetty
Thank you Aditya.

I tried creating from the pgadmin4 directory, but now I get a different
error message.


*(venv) [vaij@rocky4 pgadmin4]$ python3 $PGADMIN4_SRC/web/setup.py*Traceback
(most recent call last):
  File "/home/vaij/pgadmin4/web/setup.py", line 24, in 
import config
  File "/home/vaij/pgadmin4/web/config.py", line 25, in 
from pgadmin.utils import env, IS_WIN, fs_short_path
  File "/home/vaij/pgadmin4/web/pgadmin/__init__.py", line 39, in 
from pgadmin.model import db, Role, Server, SharedServer, ServerGroup, \
  File "/home/vaij/pgadmin4/web/pgadmin/model/__init__.py", line 22, in

from flask_sqlalchemy import SQLAlchemy
  File
"/home/vaij/pgadmin4/venv/lib64/python3.9/site-packages/flask_sqlalchemy/__init__.py",
line 5, in 
from .extension import SQLAlchemy
  File
"/home/vaij/pgadmin4/venv/lib64/python3.9/site-packages/flask_sqlalchemy/extension.py",
line 22, in 
from .session import _app_ctx_id
  File
"/home/vaij/pgadmin4/venv/lib64/python3.9/site-packages/flask_sqlalchemy/session.py",
line 8, in 
from flask.globals import app_ctx
ImportError: cannot import name 'app_ctx' from 'flask.globals'
(/home/vaij/pgadmin4/venv/lib64/python3.9/site-packages/flask/globals.py)


*-- Working from $PGADMIN4_SRC directory*(venv) [vaij@rocky4 pgadmin4]$ pwd
/home/vaij/pgadmin4

Attaching pip freeze for reference.

Vaij



On Tue, Feb 7, 2023 at 12:35 AM Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:

> Hi Vaij,
>
> You're using requirements.txt from the runtime directory. There is no such
> file in the runtime directory.
> The correct requirements.txt reside in the pgadmin home directory which
> has below content. Please create the venv using the correct
> requirements.txt file.
>
> Flask==2.0.3; python_version <= '3.6'
> Flask==2.1.*; python_version >= '3.7'
> Flask-Gravatar==0.*
> Flask-Login==0.*
> Flask-Mail==0.*
> Flask-Migrate==4.*
> dnspython==2.2.1
> greenlet==1.1.2; python_version <= '3.10'
> Flask-SQLAlchemy==2.5.*
> Flask-WTF==1.0.1
> Flask-Compress==1.*
> Flask-Paranoid==0.*
> Flask-Babel==2.*
> Flask-Security-Too==4.1.*
> Flask-SocketIO<=5.2.0
> WTForms==3.*
> passlib==1.*
> pytz==2021.*
> simplejson==3.*
> speaklater3==1.*
> sqlparse==0.*
> psutil==5.9.3
> psycopg2==2.9.*
> python-dateutil==2.*
> SQLAlchemy==1.4.44; python_version <= '3.6'
> SQLAlchemy==1.4.*; python_version >= '3.7'
> bcrypt==3.*
> cryptography==3.*
> sshtunnel==0.*
> ldap3==2.*
> gssapi==1.7.*; python_version <= '3.6'
> gssapi==1.8.*; python_version >= '3.7'
> eventlet==0.33.0
> httpagentparser==1.9.*
> user-agents==2.2.0
> pywinpty==1.1.*; sys_platform=="win32"
> Authlib==0.15.*; python_version <= '3.6'
> Authlib==1.1.*; python_version >= '3.7'
> requests==2.25.*
> pyotp==2.*
> qrcode==7.*
> Pillow==8.4.*; python_version <= '3.6'
> Pillow==9.*; python_version >= '3.7'
> boto3==1.23.*; python_version <= '3.6'
> boto3==1.26.*; python_version >= '3.7'
> botocore==1.26.*; python_version <= '3.6'
> botocore==1.29.*; python_version >= '3.7'
> urllib3==1.26.*
> Werkzeug==2.0.3; python_version <= '3.6'
> Werkzeug==2.1.2; python_version >= '3.7'
> azure-mgmt-rdbms==10.1.0
> azure-mgmt-resource==21.0.0
> azure-mgmt-subscription==3.0.0
> azure-identity==1.9.0
>
>
> On Tue, Feb 7, 2023 at 12:07 AM Vaij Bharamshetty 
> wrote:
>
>> Thank you Aditya, appreciate your help. I still face issues detailed as
>> below,
>>
>>
>> *-- Python Version*(venv) [vaij@rocky4 runtime]$ python -V
>> Python 3.9.14
>>
>>
>> *-- Clean up existing Packages*pip freeze | xargs pip uninstall -y
>>
>>
>> *-- Install from Requirements*(venv) [vaij@rocky4 runtime]$ pip install
>> -r requirements.txt
>>
>>
>> *-- One Package did not install *ERROR: Could not find a version that
>> satisfies the requirement subscription-manager==1.29.30 (from versions:
>> none)
>> ERROR: No matching distribution found for subscription-manager==1.29.30
>>
>>
>> *-- Try running setup*(venv) [vaij@rocky4 runtime]$ python3
>> $PGADMIN4_SRC/web/setup.py
>> Traceback (most recent call last):
>>   File "/home/vaij/pgadmin4/web/setup.py", line 24, in 
>> import config
>>   File "/home/vaij/pgadmin4/web/config.py", line 25, in 
>> from pgadmin.utils import env, IS_WIN, fs_short_path
>>   File "/home/vaij/pgadmin4/web/pgadmin/__init__.py", line 25, in 
>> from flask_socketio import SocketIO
>> ModuleNotFoundError: No module named 'flask_socketio'
>>
>> *-- (Trial and error) Try running with sudo*
>> (venv) [vaij@rocky4 runtime]$ sudo python3 $PGADMIN4_SRC/web/setup.py
>> [sudo] password for vaij:
>> Traceback (most recent call last):
>>   File "/home/vaij/pgadmin4/web/setup.py", line 24, in 
>> import config
>>   File "/home/vaij/pgadmin4/web/config.py", line 25, in 
>> from pgadmin.utils import env, IS_WIN, fs_short_path
>>   File "/home/vaij/pgadmin4/web/pgadmin/__init__.py", line 24, in 
>> from flask import Flask, abort, request, current_app, session, url_for
>> ModuleNotFoundError: No module named 'flask'
>>
>>
>> *-- Chec

Re: PGadmi4 - Unable to set up dev environment

2023-02-06 Thread Aditya Toshniwal
Hi Vaij,

I am not sure from where are you getting the incorrect versions required
but you're using - Flask-SQLAlchemy==3.0.3 but pgAdmin requirements clearly
has - Flask-SQLAlchemy==2.5.*
I suggest, deleting the venv completely and reinstalling using pgAdmin
requirements.txt

On Tue, Feb 7, 2023 at 11:46 AM Vaij Bharamshetty  wrote:

> Thank you Aditya.
>
> I tried creating from the pgadmin4 directory, but now I get a different
> error message.
>
>
> *(venv) [vaij@rocky4 pgadmin4]$ python3 $PGADMIN4_SRC/web/setup.py*Traceback
> (most recent call last):
>   File "/home/vaij/pgadmin4/web/setup.py", line 24, in 
> import config
>   File "/home/vaij/pgadmin4/web/config.py", line 25, in 
> from pgadmin.utils import env, IS_WIN, fs_short_path
>   File "/home/vaij/pgadmin4/web/pgadmin/__init__.py", line 39, in 
> from pgadmin.model import db, Role, Server, SharedServer, ServerGroup,
> \
>   File "/home/vaij/pgadmin4/web/pgadmin/model/__init__.py", line 22, in
> 
> from flask_sqlalchemy import SQLAlchemy
>   File
> "/home/vaij/pgadmin4/venv/lib64/python3.9/site-packages/flask_sqlalchemy/__init__.py",
> line 5, in 
> from .extension import SQLAlchemy
>   File
> "/home/vaij/pgadmin4/venv/lib64/python3.9/site-packages/flask_sqlalchemy/extension.py",
> line 22, in 
> from .session import _app_ctx_id
>   File
> "/home/vaij/pgadmin4/venv/lib64/python3.9/site-packages/flask_sqlalchemy/session.py",
> line 8, in 
> from flask.globals import app_ctx
> ImportError: cannot import name 'app_ctx' from 'flask.globals'
> (/home/vaij/pgadmin4/venv/lib64/python3.9/site-packages/flask/globals.py)
>
>
> *-- Working from $PGADMIN4_SRC directory*(venv) [vaij@rocky4 pgadmin4]$
> pwd
> /home/vaij/pgadmin4
>
> Attaching pip freeze for reference.
>
> Vaij
>
>
>
> On Tue, Feb 7, 2023 at 12:35 AM Aditya Toshniwal <
> aditya.toshni...@enterprisedb.com> wrote:
>
>> Hi Vaij,
>>
>> You're using requirements.txt from the runtime directory. There is no
>> such file in the runtime directory.
>> The correct requirements.txt reside in the pgadmin home directory which
>> has below content. Please create the venv using the correct
>> requirements.txt file.
>>
>> Flask==2.0.3; python_version <= '3.6'
>> Flask==2.1.*; python_version >= '3.7'
>> Flask-Gravatar==0.*
>> Flask-Login==0.*
>> Flask-Mail==0.*
>> Flask-Migrate==4.*
>> dnspython==2.2.1
>> greenlet==1.1.2; python_version <= '3.10'
>> Flask-SQLAlchemy==2.5.*
>> Flask-WTF==1.0.1
>> Flask-Compress==1.*
>> Flask-Paranoid==0.*
>> Flask-Babel==2.*
>> Flask-Security-Too==4.1.*
>> Flask-SocketIO<=5.2.0
>> WTForms==3.*
>> passlib==1.*
>> pytz==2021.*
>> simplejson==3.*
>> speaklater3==1.*
>> sqlparse==0.*
>> psutil==5.9.3
>> psycopg2==2.9.*
>> python-dateutil==2.*
>> SQLAlchemy==1.4.44; python_version <= '3.6'
>> SQLAlchemy==1.4.*; python_version >= '3.7'
>> bcrypt==3.*
>> cryptography==3.*
>> sshtunnel==0.*
>> ldap3==2.*
>> gssapi==1.7.*; python_version <= '3.6'
>> gssapi==1.8.*; python_version >= '3.7'
>> eventlet==0.33.0
>> httpagentparser==1.9.*
>> user-agents==2.2.0
>> pywinpty==1.1.*; sys_platform=="win32"
>> Authlib==0.15.*; python_version <= '3.6'
>> Authlib==1.1.*; python_version >= '3.7'
>> requests==2.25.*
>> pyotp==2.*
>> qrcode==7.*
>> Pillow==8.4.*; python_version <= '3.6'
>> Pillow==9.*; python_version >= '3.7'
>> boto3==1.23.*; python_version <= '3.6'
>> boto3==1.26.*; python_version >= '3.7'
>> botocore==1.26.*; python_version <= '3.6'
>> botocore==1.29.*; python_version >= '3.7'
>> urllib3==1.26.*
>> Werkzeug==2.0.3; python_version <= '3.6'
>> Werkzeug==2.1.2; python_version >= '3.7'
>> azure-mgmt-rdbms==10.1.0
>> azure-mgmt-resource==21.0.0
>> azure-mgmt-subscription==3.0.0
>> azure-identity==1.9.0
>>
>>
>> On Tue, Feb 7, 2023 at 12:07 AM Vaij Bharamshetty 
>> wrote:
>>
>>> Thank you Aditya, appreciate your help. I still face issues detailed as
>>> below,
>>>
>>>
>>> *-- Python Version*(venv) [vaij@rocky4 runtime]$ python -V
>>> Python 3.9.14
>>>
>>>
>>> *-- Clean up existing Packages*pip freeze | xargs pip uninstall -y
>>>
>>>
>>> *-- Install from Requirements*(venv) [vaij@rocky4 runtime]$ pip install
>>> -r requirements.txt
>>>
>>>
>>> *-- One Package did not install *ERROR: Could not find a version that
>>> satisfies the requirement subscription-manager==1.29.30 (from versions:
>>> none)
>>> ERROR: No matching distribution found for subscription-manager==1.29.30
>>>
>>>
>>> *-- Try running setup*(venv) [vaij@rocky4 runtime]$ python3
>>> $PGADMIN4_SRC/web/setup.py
>>> Traceback (most recent call last):
>>>   File "/home/vaij/pgadmin4/web/setup.py", line 24, in 
>>> import config
>>>   File "/home/vaij/pgadmin4/web/config.py", line 25, in 
>>> from pgadmin.utils import env, IS_WIN, fs_short_path
>>>   File "/home/vaij/pgadmin4/web/pgadmin/__init__.py", line 25, in
>>> 
>>> from flask_socketio import SocketIO
>>> ModuleNotFoundError: No module named 'flask_socketio'
>>>
>>> *-- (Trial and error) Try running with sudo*
>>> (venv) [vaij@rocky4 runti