Home > mailing lists

Thread: pgAdmin4 v6.21 on RHEL7.9 with FIPS enabled

pgAdmin4 v6.21 on RHEL7.9 with FIPS enabled

From

Daxu Yin

Date:

26 May 2023, 18:16:45

Hi,

I am new to this list, please forgive me if I am submitting the following to the wrong place.

We've just installed pgAdmin4 web mode on RHEL7.9.

Once we started the httpd service, we couldn't login the system, the webpage spins forever.

The error message is attached below.

The RHEL 7.9 we use has FIPS enabled, e.g. cat /proc/sys/crypto/fips_enabled has a value of 1.

It seems the version of pgAdmin4, 6.21, still uses MD5, which is not allowed by FIPS.

I'd highly appreciate if anyone could let us know:

1. Is there a version of pgAdmin4 on RHEL 7.9 that supports FIPS?

2. Is there any plan down the road that pgAdmin4 would support FIPS on RHEL 7.9?

3. Is there any way to get around the issue?

Many thanks in advance,

==============Error msg in pgadmin log file =========================

2023-05-16 03:04:13,593: ERROR pgadmin: [digital envelope routines: EVP_DigestInit_ex] disabled for fips

Traceback (most recent call last):

File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/app.py", line 1516, in full_dispatch_request

rv = self.dispatch_request()

File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/app.py", line 1502, in dispatch_request

Connection to 10.138.182.10 closed by remote host.le.endpoint])(**req.view_args)

Connection to 10.138.182.10 closed.thon3.6/site-packages/flask_login/utils.py", line 272, in decorated_view

[daxu@ip-192-168-40-129 ~]$ rgs)

File "/usr/pgadmin4/web/pgadmin/browser/__init__.py", line 634, in utils

current_ui_lock=current_ui_lock

File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/templating.py", line 150, in render_template

ctx.app,

File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/templating.py", line 128, in _render

rv = template.render(context)

File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/jinja2/environment.py", line 1291, in render

self.environment.handle_exception()

File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/jinja2/environment.py", line 925, in handle_exception

raise rewrite_traceback_stack(source=source)

File "/usr/pgadmin4/web/pgadmin/browser/templates/browser/js/utils.js", line 119, in top-level template code

gravatar: {% if config.SHOW_GRAVATAR_IMAGE %}'{{ username | gravatar }}'{% else %}''{% endif %},

File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask_gravatar/__init__.py", line 151, in __call__

hash = hashlib.md5(email.encode('utf-8')).hexdigest()

ValueError: [digital envelope routines: EVP_DigestInit_ex] disabled for fips

Daxu Yin
410-340-5842

Re: pgAdmin4 v6.21 on RHEL7.9 with FIPS enabled

From

Fahar Abbas

Date:

29 May 2023, 06:19:19

Hi,

We have dropped the support for Rhel 7 (https://www.pgadmin.org/download/pgadmin-4-rpm/), Can you please upgrade your platform and version 7.1 and try again?

On Fri, May 26, 2023 at 8:17 PM Daxu Yin <daxuyin@yahoo.com> wrote:

Hi,

I am new to this list, please forgive me if I am submitting the following to the wrong place.

We've just installed pgAdmin4 web mode on RHEL7.9.
Once we started the httpd service, we couldn't login the system, the webpage spins forever.
The error message is attached below.
The RHEL 7.9 we use has FIPS enabled, e.g. cat /proc/sys/crypto/fips_enabled has a value of 1.

It seems the version of pgAdmin4, 6.21, still uses MD5, which is not allowed by FIPS.

I'd highly appreciate if anyone could let us know:

1. Is there a version of pgAdmin4 on RHEL 7.9 that supports FIPS?
2. Is there any plan down the road that pgAdmin4 would support FIPS on RHEL 7.9?
3. Is there any way to get around the issue?

Many thanks in advance,

==============Error msg in pgadmin log file =========================
2023-05-16 03:04:13,593: ERROR pgadmin: [digital envelope routines: EVP_DigestInit_ex] disabled for fips
Traceback (most recent call last):
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/app.py", line 1516, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/app.py", line 1502, in dispatch_request
Connection to 10.138.182.10 closed by remote host.le.endpoint])(**req.view_args)
Connection to 10.138.182.10 closed.thon3.6/site-packages/flask_login/utils.py", line 272, in decorated_view
[daxu@ip-192-168-40-129 ~]$ rgs)
File "/usr/pgadmin4/web/pgadmin/browser/__init__.py", line 634, in utils
current_ui_lock=current_ui_lock
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/templating.py", line 150, in render_template
ctx.app,
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/templating.py", line 128, in _render
rv = template.render(context)
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/jinja2/environment.py", line 1291, in render
self.environment.handle_exception()
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/jinja2/environment.py", line 925, in handle_exception
raise rewrite_traceback_stack(source=source)
File "/usr/pgadmin4/web/pgadmin/browser/templates/browser/js/utils.js", line 119, in top-level template code
gravatar: {% if config.SHOW_GRAVATAR_IMAGE %}'{{ username | gravatar }}'{% else %}''{% endif %},
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask_gravatar/__init__.py", line 151, in __call__
hash = hashlib.md5(email.encode('utf-8')).hexdigest()
ValueError: [digital envelope routines: EVP_DigestInit_ex] disabled for fips

Daxu Yin
410-340-5842

Fahar Abbas

pgAdmin4 team

EnterpriseDB Corporation

Mobile: +92-333-5409707
Skype ID: live:fahar.abbas
Website: www.enterprisedb.com

Re: pgAdmin4 v6.21 on RHEL7.9 with FIPS enabled

From

Khushboo Vashi

Date:

29 May 2023, 07:12:25

Hi,

On Fri, May 26, 2023 at 8:47 PM Daxu Yin <daxuyin@yahoo.com> wrote:

Hi,

I am new to this list, please forgive me if I am submitting the following to the wrong place.

We've just installed pgAdmin4 web mode on RHEL7.9.
Once we started the httpd service, we couldn't login the system, the webpage spins forever.
The error message is attached below.
The RHEL 7.9 we use has FIPS enabled, e.g. cat /proc/sys/crypto/fips_enabled has a value of 1.

It seems the version of pgAdmin4, 6.21, still uses MD5, which is not allowed by FIPS.

I'd highly appreciate if anyone could let us know:

1. Is there a version of pgAdmin4 on RHEL 7.9 that supports FIPS?
2. Is there any plan down the road that pgAdmin4 would support FIPS on RHEL 7.9?
3. Is there any way to get around the issue?

Many thanks in advance,

==============Error msg in pgadmin log file =========================
2023-05-16 03:04:13,593: ERROR pgadmin: [digital envelope routines: EVP_DigestInit_ex] disabled for fips
Traceback (most recent call last):
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/app.py", line 1516, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/app.py", line 1502, in dispatch_request
Connection to 10.138.182.10 closed by remote host.le.endpoint])(**req.view_args)
Connection to 10.138.182.10 closed.thon3.6/site-packages/flask_login/utils.py", line 272, in decorated_view
[daxu@ip-192-168-40-129 ~]$ rgs)
File "/usr/pgadmin4/web/pgadmin/browser/__init__.py", line 634, in utils
current_ui_lock=current_ui_lock
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/templating.py", line 150, in render_template
ctx.app,
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/templating.py", line 128, in _render
rv = template.render(context)
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/jinja2/environment.py", line 1291, in render
self.environment.handle_exception()
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/jinja2/environment.py", line 925, in handle_exception
raise rewrite_traceback_stack(source=source)
File "/usr/pgadmin4/web/pgadmin/browser/templates/browser/js/utils.js", line 119, in top-level template code
gravatar: {% if config.SHOW_GRAVATAR_IMAGE %}'{{ username | gravatar }}'{% else %}''{% endif %},
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask_gravatar/__init__.py", line 151, in __call__
hash = hashlib.md5(email.encode('utf-8')).hexdigest()
ValueError: [digital envelope routines: EVP_DigestInit_ex] disabled for fips

This issue is reported here: https://bugzilla.redhat.com/show_bug.cgi?id=1744670.

And the target version for the fix is RHEL 8.0

Thanks,

Khushboo

Daxu Yin
410-340-5842

Re: pgAdmin4 v6.21 on RHEL7.9 with FIPS enabled

From

Daxu Yin

Date:

30 May 2023, 02:07:09

Actually minor verion of RHEL 7 we have is version 7.9

Daxu Yin
410-340-5842

On Sunday, May 28, 2023 at 11:19:32 PM EDT, Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:

Hi,

We have dropped the support for Rhel 7 (https://www.pgadmin.org/download/pgadmin-4-rpm/), Can you please upgrade your platform and version 7.1 and try again?

On Fri, May 26, 2023 at 8:17 PM Daxu Yin <daxuyin@yahoo.com> wrote:

Hi,

I am new to this list, please forgive me if I am submitting the following to the wrong place.

We've just installed pgAdmin4 web mode on RHEL7.9.
Once we started the httpd service, we couldn't login the system, the webpage spins forever.
The error message is attached below.
The RHEL 7.9 we use has FIPS enabled, e.g. cat /proc/sys/crypto/fips_enabled has a value of 1.

It seems the version of pgAdmin4, 6.21, still uses MD5, which is not allowed by FIPS.

I'd highly appreciate if anyone could let us know:

1. Is there a version of pgAdmin4 on RHEL 7.9 that supports FIPS?
2. Is there any plan down the road that pgAdmin4 would support FIPS on RHEL 7.9?
3. Is there any way to get around the issue?

Many thanks in advance,

==============Error msg in pgadmin log file =========================
2023-05-16 03:04:13,593: ERROR pgadmin: [digital envelope routines: EVP_DigestInit_ex] disabled for fips
Traceback (most recent call last):
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/app.py", line 1516, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/app.py", line 1502, in dispatch_request
Connection to 10.138.182.10 closed by remote host.le.endpoint])(**req.view_args)
Connection to 10.138.182.10 closed.thon3.6/site-packages/flask_login/utils.py", line 272, in decorated_view
[daxu@ip-192-168-40-129 ~]$ rgs)
File "/usr/pgadmin4/web/pgadmin/browser/__init__.py", line 634, in utils
current_ui_lock=current_ui_lock
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/templating.py", line 150, in render_template
ctx.app,
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/templating.py", line 128, in _render
rv = template.render(context)
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/jinja2/environment.py", line 1291, in render
self.environment.handle_exception()
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/jinja2/environment.py", line 925, in handle_exception
raise rewrite_traceback_stack(source=source)
File "/usr/pgadmin4/web/pgadmin/browser/templates/browser/js/utils.js", line 119, in top-level template code
gravatar: {% if config.SHOW_GRAVATAR_IMAGE %}'{{ username | gravatar }}'{% else %}''{% endif %},
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask_gravatar/__init__.py", line 151, in __call__
hash = hashlib.md5(email.encode('utf-8')).hexdigest()
ValueError: [digital envelope routines: EVP_DigestInit_ex] disabled for fips

Daxu Yin
410-340-5842

Fahar Abbas

pgAdmin4 team

EnterpriseDB Corporation

Mobile: +92-333-5409707
Skype ID: live:fahar.abbas
Website: www.enterprisedb.com

Re: pgAdmin4 v6.21 on RHEL7.9 with FIPS enabled

From

Daxu Yin

Date:

30 May 2023, 16:06:01

Thanks a lot for your response, it is very helpful.

Do we know when that release on RHEL 8 will be available?

Thanks again

Daxu Yin
410-340-5842

On Monday, May 29, 2023 at 12:12:47 AM EDT, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

Hi,

On Fri, May 26, 2023 at 8:47 PM Daxu Yin <daxuyin@yahoo.com> wrote:

Hi,

I am new to this list, please forgive me if I am submitting the following to the wrong place.

We've just installed pgAdmin4 web mode on RHEL7.9.
Once we started the httpd service, we couldn't login the system, the webpage spins forever.
The error message is attached below.
The RHEL 7.9 we use has FIPS enabled, e.g. cat /proc/sys/crypto/fips_enabled has a value of 1.

It seems the version of pgAdmin4, 6.21, still uses MD5, which is not allowed by FIPS.

I'd highly appreciate if anyone could let us know:

1. Is there a version of pgAdmin4 on RHEL 7.9 that supports FIPS?
2. Is there any plan down the road that pgAdmin4 would support FIPS on RHEL 7.9?
3. Is there any way to get around the issue?

Many thanks in advance,

==============Error msg in pgadmin log file =========================
2023-05-16 03:04:13,593: ERROR pgadmin: [digital envelope routines: EVP_DigestInit_ex] disabled for fips
Traceback (most recent call last):
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/app.py", line 1516, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/app.py", line 1502, in dispatch_request
Connection to 10.138.182.10 closed by remote host.le.endpoint])(**req.view_args)
Connection to 10.138.182.10 closed.thon3.6/site-packages/flask_login/utils.py", line 272, in decorated_view
[daxu@ip-192-168-40-129 ~]$ rgs)
File "/usr/pgadmin4/web/pgadmin/browser/__init__.py", line 634, in utils
current_ui_lock=current_ui_lock
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/templating.py", line 150, in render_template
ctx.app,
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/templating.py", line 128, in _render
rv = template.render(context)
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/jinja2/environment.py", line 1291, in render
self.environment.handle_exception()
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/jinja2/environment.py", line 925, in handle_exception
raise rewrite_traceback_stack(source=source)
File "/usr/pgadmin4/web/pgadmin/browser/templates/browser/js/utils.js", line 119, in top-level template code
gravatar: {% if config.SHOW_GRAVATAR_IMAGE %}'{{ username | gravatar }}'{% else %}''{% endif %},
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask_gravatar/__init__.py", line 151, in __call__
hash = hashlib.md5(email.encode('utf-8')).hexdigest()
ValueError: [digital envelope routines: EVP_DigestInit_ex] disabled for fips

This issue is reported here: https://bugzilla.redhat.com/show_bug.cgi?id=1744670.

And the target version for the fix is RHEL 8.0

Thanks,

Khushboo

Daxu Yin
410-340-5842

Re: pgAdmin4 v6.21 on RHEL7.9 with FIPS enabled

From

Daxu Yin

Date:

14 July 2023, 14:32:46

Is there a version of pgadmin4 certified with FIPS and RHEL 8 available for download?

If no official release available, do we know when it would be available?

Many thanks,

Daxu Yin
410-340-5842

On Monday, May 29, 2023 at 12:12:47 AM EDT, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

Hi,

On Fri, May 26, 2023 at 8:47 PM Daxu Yin <daxuyin@yahoo.com> wrote:

Hi,

I am new to this list, please forgive me if I am submitting the following to the wrong place.

We've just installed pgAdmin4 web mode on RHEL7.9.
Once we started the httpd service, we couldn't login the system, the webpage spins forever.
The error message is attached below.
The RHEL 7.9 we use has FIPS enabled, e.g. cat /proc/sys/crypto/fips_enabled has a value of 1.

It seems the version of pgAdmin4, 6.21, still uses MD5, which is not allowed by FIPS.

I'd highly appreciate if anyone could let us know:

1. Is there a version of pgAdmin4 on RHEL 7.9 that supports FIPS?
2. Is there any plan down the road that pgAdmin4 would support FIPS on RHEL 7.9?
3. Is there any way to get around the issue?

Many thanks in advance,

==============Error msg in pgadmin log file =========================
2023-05-16 03:04:13,593: ERROR pgadmin: [digital envelope routines: EVP_DigestInit_ex] disabled for fips
Traceback (most recent call last):
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/app.py", line 1516, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/app.py", line 1502, in dispatch_request
Connection to 10.138.182.10 closed by remote host.le.endpoint])(**req.view_args)
Connection to 10.138.182.10 closed.thon3.6/site-packages/flask_login/utils.py", line 272, in decorated_view
[daxu@ip-192-168-40-129 ~]$ rgs)
File "/usr/pgadmin4/web/pgadmin/browser/__init__.py", line 634, in utils
current_ui_lock=current_ui_lock
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/templating.py", line 150, in render_template
ctx.app,
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/templating.py", line 128, in _render
rv = template.render(context)
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/jinja2/environment.py", line 1291, in render
self.environment.handle_exception()
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/jinja2/environment.py", line 925, in handle_exception
raise rewrite_traceback_stack(source=source)
File "/usr/pgadmin4/web/pgadmin/browser/templates/browser/js/utils.js", line 119, in top-level template code
gravatar: {% if config.SHOW_GRAVATAR_IMAGE %}'{{ username | gravatar }}'{% else %}''{% endif %},
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask_gravatar/__init__.py", line 151, in __call__
hash = hashlib.md5(email.encode('utf-8')).hexdigest()
ValueError: [digital envelope routines: EVP_DigestInit_ex] disabled for fips

This issue is reported here: https://bugzilla.redhat.com/show_bug.cgi?id=1744670.

And the target version for the fix is RHEL 8.0

Thanks,

Khushboo

Daxu Yin
410-340-5842

Re: pgAdmin4 v6.21 on RHEL7.9 with FIPS enabled

From

Aditya Toshniwal

Date:

14 July 2023, 15:15:11

Hi Daxu,

Please check the supported OS and versions here - https://www.pgadmin.org/download/pgadmin-4-rpm/

On Fri, Jul 14, 2023 at 5:02 PM Daxu Yin <daxuyin@yahoo.com> wrote:

Is there a version of pgadmin4 certified with FIPS and RHEL 8 available for download?

If no official release available, do we know when it would be available?

Many thanks,

Daxu Yin
410-340-5842

On Monday, May 29, 2023 at 12:12:47 AM EDT, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

Hi,

On Fri, May 26, 2023 at 8:47 PM Daxu Yin <daxuyin@yahoo.com> wrote:
Hi,

I am new to this list, please forgive me if I am submitting the following to the wrong place.

We've just installed pgAdmin4 web mode on RHEL7.9.
Once we started the httpd service, we couldn't login the system, the webpage spins forever.
The error message is attached below.
The RHEL 7.9 we use has FIPS enabled, e.g. cat /proc/sys/crypto/fips_enabled has a value of 1.

It seems the version of pgAdmin4, 6.21, still uses MD5, which is not allowed by FIPS.

I'd highly appreciate if anyone could let us know:

1. Is there a version of pgAdmin4 on RHEL 7.9 that supports FIPS?
2. Is there any plan down the road that pgAdmin4 would support FIPS on RHEL 7.9?
3. Is there any way to get around the issue?

Many thanks in advance,

==============Error msg in pgadmin log file =========================
2023-05-16 03:04:13,593: ERROR pgadmin: [digital envelope routines: EVP_DigestInit_ex] disabled for fips
Traceback (most recent call last):
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/app.py", line 1516, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/app.py", line 1502, in dispatch_request
Connection to 10.138.182.10 closed by remote host.le.endpoint])(**req.view_args)
Connection to 10.138.182.10 closed.thon3.6/site-packages/flask_login/utils.py", line 272, in decorated_view
[daxu@ip-192-168-40-129 ~]$ rgs)
File "/usr/pgadmin4/web/pgadmin/browser/__init__.py", line 634, in utils
current_ui_lock=current_ui_lock
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/templating.py", line 150, in render_template
ctx.app,
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/templating.py", line 128, in _render
rv = template.render(context)
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/jinja2/environment.py", line 1291, in render
self.environment.handle_exception()
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/jinja2/environment.py", line 925, in handle_exception
raise rewrite_traceback_stack(source=source)
File "/usr/pgadmin4/web/pgadmin/browser/templates/browser/js/utils.js", line 119, in top-level template code
gravatar: {% if config.SHOW_GRAVATAR_IMAGE %}'{{ username | gravatar }}'{% else %}''{% endif %},
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask_gravatar/__init__.py", line 151, in __call__
hash = hashlib.md5(email.encode('utf-8')).hexdigest()
ValueError: [digital envelope routines: EVP_DigestInit_ex] disabled for fips

This issue is reported here: https://bugzilla.redhat.com/show_bug.cgi?id=1744670.
And the target version for the fix is RHEL 8.0

Thanks,
Khushboo

Daxu Yin
410-340-5842

Thanks,

Aditya Toshniwal

pgAdmin Hacker | Sr. Software Architect | enterprisedb.com

"Don't Complain about Heat, Plant a TREE"

Re: pgAdmin4 v6.21 on RHEL7.9 with FIPS enabled

From

Dave Page

Date:

14 July 2023, 15:17:13

On Fri, 14 Jul 2023 at 12:32, Daxu Yin <daxuyin@yahoo.com> wrote:

Is there a version of pgadmin4 certified with FIPS and RHEL 8 available for download?

If no official release available, do we know when it would be available?

We have no plans for FIPS certification. We do support pgAdmin in non-FIPS on RHEL 8.

Many thanks,

Daxu Yin
410-340-5842

On Monday, May 29, 2023 at 12:12:47 AM EDT, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

Hi,

On Fri, May 26, 2023 at 8:47 PM Daxu Yin <daxuyin@yahoo.com> wrote:
Hi,

I am new to this list, please forgive me if I am submitting the following to the wrong place.

We've just installed pgAdmin4 web mode on RHEL7.9.
Once we started the httpd service, we couldn't login the system, the webpage spins forever.
The error message is attached below.
The RHEL 7.9 we use has FIPS enabled, e.g. cat /proc/sys/crypto/fips_enabled has a value of 1.

It seems the version of pgAdmin4, 6.21, still uses MD5, which is not allowed by FIPS.

I'd highly appreciate if anyone could let us know:

1. Is there a version of pgAdmin4 on RHEL 7.9 that supports FIPS?
2. Is there any plan down the road that pgAdmin4 would support FIPS on RHEL 7.9?
3. Is there any way to get around the issue?

Many thanks in advance,

==============Error msg in pgadmin log file =========================
2023-05-16 03:04:13,593: ERROR pgadmin: [digital envelope routines: EVP_DigestInit_ex] disabled for fips
Traceback (most recent call last):
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/app.py", line 1516, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/app.py", line 1502, in dispatch_request
Connection to 10.138.182.10 closed by remote host.le.endpoint])(**req.view_args)
Connection to 10.138.182.10 closed.thon3.6/site-packages/flask_login/utils.py", line 272, in decorated_view
[daxu@ip-192-168-40-129 ~]$ rgs)
File "/usr/pgadmin4/web/pgadmin/browser/__init__.py", line 634, in utils
current_ui_lock=current_ui_lock
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/templating.py", line 150, in render_template
ctx.app,
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask/templating.py", line 128, in _render
rv = template.render(context)
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/jinja2/environment.py", line 1291, in render
self.environment.handle_exception()
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/jinja2/environment.py", line 925, in handle_exception
raise rewrite_traceback_stack(source=source)
File "/usr/pgadmin4/web/pgadmin/browser/templates/browser/js/utils.js", line 119, in top-level template code
gravatar: {% if config.SHOW_GRAVATAR_IMAGE %}'{{ username | gravatar }}'{% else %}''{% endif %},
File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask_gravatar/__init__.py", line 151, in __call__
hash = hashlib.md5(email.encode('utf-8')).hexdigest()
ValueError: [digital envelope routines: EVP_DigestInit_ex] disabled for fips

This issue is reported here: https://bugzilla.redhat.com/show_bug.cgi?id=1744670.
And the target version for the fix is RHEL 8.0

Thanks,
Khushboo

Daxu Yin
410-340-5842

Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: https://www.enterprisedb.com

pgadmin4 web interface is frozen after login

From

Daxu Yin

Date:

10 August 2023, 22:22:37

Hi,

We have an issue with a pgadmin4 user, once after she logged in the web page, the webpage is kind of frozen, with two empty windows "Properties" and "SQL", as shown in the attachment.

The pgadmin4 was working fine for her yesterday.

We're running pgadmin4 version 6.21 on RHEL 7.9

Could anyone help us?

Many thanks in advance.

Daxu Yin
410-340-5842

Attachment

MicrosoftTeams.png

Re: pgadmin4 web interface is frozen after login

From

Aditya Toshniwal

Date:

11 August 2023, 07:59:36

Hi Daxu,

Please upgrade to the latest pgAdmin v7.5. The issue is fixed.

On Fri, Aug 11, 2023 at 12:52 AM Daxu Yin <daxuyin@yahoo.com> wrote:

Hi,

We have an issue with a pgadmin4 user, once after she logged in the web page, the webpage is kind of frozen, with two empty windows "Properties" and "SQL", as shown in the attachment.
The pgadmin4 was working fine for her yesterday.

We're running pgadmin4 version 6.21 on RHEL 7.9

Could anyone help us?

Many thanks in advance.

Daxu Yin
410-340-5842

Thanks,

Aditya Toshniwal

pgAdmin Hacker | Sr. Software Architect | enterprisedb.com

"Don't Complain about Heat, Plant a TREE"

Re: pgadmin4 web interface is frozen after login

From

Yogesh Mahajan

Date:

11 August 2023, 08:00:54

Hi,

Can you please try on updated version 7.5? Also can you please try resetting layout File > Rest layout.

Thanks,

Yogesh Mahajan

EnterpriseDB

On Fri, Aug 11, 2023 at 12:53 AM Daxu Yin <daxuyin@yahoo.com> wrote:

Hi,

We have an issue with a pgadmin4 user, once after she logged in the web page, the webpage is kind of frozen, with two empty windows "Properties" and "SQL", as shown in the attachment.
The pgadmin4 was working fine for her yesterday.

We're running pgadmin4 version 6.21 on RHEL 7.9

Could anyone help us?

Many thanks in advance.

Daxu Yin
410-340-5842

pgAdmin4 v6.21 on RHEL7.9

From

Daxu Yin

Date:

05 January, 00:38:26

Dear pgAdmin4 experts,

We're running pgadmin4-web 6.21 on RHEL 7.9

Everything worked for a couple of years, suddenly we couldn't start the server.

It seems the httpd server started, but the pgadmin4 module wouldn't load.

The first few lines of the error messages are shown below, also attached a zipped /var/log/httpd/error_log in this email.

It seems it try to upgrade the sqllite database somehow, but failed.

I suspected the pgadmin4.db is corrupted somehow, so I stopped the service, and brought back a backup copy of pgadmin4.db,

But it didn't fix the problem.

Could anyone help me what would be the problem? and how to fix it?

Many thanks in advance,

Daxu Yin

410-340-5842

-------------------------------------------------------------------------------------------------------------------------------------------------

[Thu Jan 04 15:18:37.998634 2024] [mpm_prefork:notice] [pid 30242] AH00170: caught SIGWINCH, shutting down gracefully

[Thu Jan 04 15:20:06.897388 2024] [core:notice] [pid 31066] SELinux policy enabled; httpd running as context system_u:system_r:httpd_t:s0

[Thu Jan 04 15:20:06.898563 2024] [suexec:notice] [pid 31066] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)

[Thu Jan 04 15:20:06.914969 2024] [so:warn] [pid 31066] AH01574: module wsgi_module is already loaded, skipping

AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using fe80::1060:abff:fe12:6013. Set the 'ServerName' directive globally to suppress this message

[Thu Jan 04 15:20:06.917938 2024] [lbmethod_heartbeat:notice] [pid 31066] AH02282: No slotmem from mod_heartmonitor

[Thu Jan 04 15:20:06.922454 2024] [mpm_prefork:notice] [pid 31066] AH00163: Apache/2.4.6 (Red Hat Enterprise Linux) mod_wsgi/4.9.0 Python/3.6 configured -- resuming normal operations

[Thu Jan 04 15:20:06.922498 2024] [core:notice] [pid 31066] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'

[Thu Jan 04 15:20:21.376721 2024] [wsgi:error] [pid 31067] NOTE: Configuring authentication for SERVER mode.

[Thu Jan 04 15:20:21.376766 2024] [wsgi:error] [pid 31067]

[Thu Jan 04 15:20:21.376793 2024] [wsgi:error] [pid 31067] Enter the email address and password to use for the initial pgAdmin user account:

[Thu Jan 04 15:20:21.376803 2024] [wsgi:error] [pid 31067]

[Thu Jan 04 15:20:21.376876 2024] [wsgi:error] [pid 31067] Email address:

[Thu Jan 04 15:20:21.377894 2024] [wsgi:error] [pid 31067] 2024-01-04 15:20:21,377: ERROR\tpgadmin:\tDatabase migration failed

[Thu Jan 04 15:20:21.380424 2024] [wsgi:error] [pid 31067] 2024-01-04 15:20:21,380: ERROR\tpgadmin:\tTraceback (most recent call last):

[Thu Jan 04 15:20:21.380447 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/web/pgadmin/__init__.py", line 390, in upgrade_db

[Thu Jan 04 15:20:21.380459 2024] [wsgi:error] [pid 31067] db_upgrade(app)

[Thu Jan 04 15:20:21.380467 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/web/pgadmin/setup/db_upgrade.py", line 25, in db_upgrade

[Thu Jan 04 15:20:21.380477 2024] [wsgi:error] [pid 31067] flask_migrate.upgrade(migration_folder)

[Thu Jan 04 15:20:21.380487 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask_migrate/__init__.py", line 111, in wrapped

[Thu Jan 04 15:20:21.380497 2024] [wsgi:error] [pid 31067] f(*args, **kwargs)

[Thu Jan 04 15:20:21.380517 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask_migrate/__init__.py", line 200, in upgrade

[Thu Jan 04 15:20:21.380537 2024] [wsgi:error] [pid 31067] command.upgrade(config, revision, sql=sql, tag=tag)

[Thu Jan 04 15:20:21.380547 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/alembic/command.py", line 320, in upgrade

[Thu Jan 04 15:20:21.380557 2024] [wsgi:error] [pid 31067] script.run_env()

[Thu Jan 04 15:20:21.380566 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/alembic/script/base.py", line 563, in run_env

[Thu Jan 04 15:20:21.380576 2024] [wsgi:error] [pid 31067] util.load_python_file(self.dir, "env.py")

[Thu Jan 04 15:20:21.380586 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/alembic/util/pyfiles.py", line 92, in load_python_file

[Thu Jan 04 15:20:21.380596 2024] [wsgi:error] [pid 31067] module = load_module_py(module_id, path)

[Thu Jan 04 15:20:21.380605 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/alembic/util/pyfiles.py", line 108, in load_module_py

[Thu Jan 04 15:20:21.380615 2024] [wsgi:error] [pid 31067] spec.loader.exec_module(module) # type: ignore

[Thu Jan 04 15:20:21.380625 2024] [wsgi:error] [pid 31067] File "<frozen importlib._bootstrap_external>", line 678, in exec_module

[Thu Jan 04 15:20:21.380634 2024] [wsgi:error] [pid 31067] File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed

[Thu Jan 04 15:20:21.380644 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 95, in <module>

[Thu Jan 04 15:20:21.380654 2024] [wsgi:error] [pid 31067] run_migrations_online()

[Thu Jan 04 15:20:21.380663 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 87, in run_migrations_online

[Thu Jan 04 15:20:21.380672 2024] [wsgi:error] [pid 31067] context.run_migrations()

[Thu Jan 04 15:20:21.380681 2024] [wsgi:error] [pid 31067] File "<string>", line 8, in run_migrations

[Thu Jan 04 15:20:21.380688 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/alembic/runtime/environment.py", line 851, in run_migrations

[Thu Jan 04 15:20:21.380694 2024] [wsgi:error] [pid 31067] self.get_context().run_migrations(**kw)

[Thu Jan 04 15:20:21.380700 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/alembic/runtime/migration.py", line 620, in run_migrations

[Thu Jan 04 15:20:21.380705 2024] [wsgi:error] [pid 31067] step.migration_fn(**kw)

[Thu Jan 04 15:20:21.380711 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/web/migrations/versions/fdc58d9bd449_.py", line 38, in upgrade

[Thu Jan 04 15:20:21.380717 2024] [wsgi:error] [pid 31067] email, password = user_info()

[Thu Jan 04 15:20:21.380723 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 75, in user_info

[Thu Jan 04 15:20:21.380728 2024] [wsgi:error] [pid 31067] email, p1 = user_info_server()

Daxu Yin
410-340-5842

Attachment

error_log_20240104.zip

Re: pgAdmin4 v6.21 on RHEL7.9

From

Yogesh Mahajan

Date:

08 January, 14:19:00

Hi,

Error indicates the initial account is not set up on the pgadmin database. You need to run command below to setup these details -

sudo /usr/pgadmin4/bin/setup-web.sh

However this means, pgadmin will have a new database which does not have old data. Also when you have brought the backup copy pgadmin4 db, you have renamed it to pgadmin4.db

Thanks,

Yogesh Mahajan

EnterpriseDB

On Fri, Jan 5, 2024 at 3:09 AM Daxu Yin <daxuyin@yahoo.com> wrote:

Dear pgAdmin4 experts,

We're running pgadmin4-web 6.21 on RHEL 7.9
Everything worked for a couple of years, suddenly we couldn't start the server.

It seems the httpd server started, but the pgadmin4 module wouldn't load.
The first few lines of the error messages are shown below, also attached a zipped /var/log/httpd/error_log in this email.
It seems it try to upgrade the sqllite database somehow, but failed.
I suspected the pgadmin4.db is corrupted somehow, so I stopped the service, and brought back a backup copy of pgadmin4.db,
But it didn't fix the problem.

Could anyone help me what would be the problem? and how to fix it?

Many thanks in advance,

Daxu Yin
410-340-5842
-------------------------------------------------------------------------------------------------------------------------------------------------
[Thu Jan 04 15:18:37.998634 2024] [mpm_prefork:notice] [pid 30242] AH00170: caught SIGWINCH, shutting down gracefully
[Thu Jan 04 15:20:06.897388 2024] [core:notice] [pid 31066] SELinux policy enabled; httpd running as context system_u:system_r:httpd_t:s0
[Thu Jan 04 15:20:06.898563 2024] [suexec:notice] [pid 31066] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Thu Jan 04 15:20:06.914969 2024] [so:warn] [pid 31066] AH01574: module wsgi_module is already loaded, skipping
AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using fe80::1060:abff:fe12:6013. Set the 'ServerName' directive globally to suppress this message
[Thu Jan 04 15:20:06.917938 2024] [lbmethod_heartbeat:notice] [pid 31066] AH02282: No slotmem from mod_heartmonitor
[Thu Jan 04 15:20:06.922454 2024] [mpm_prefork:notice] [pid 31066] AH00163: Apache/2.4.6 (Red Hat Enterprise Linux) mod_wsgi/4.9.0 Python/3.6 configured -- resuming normal operations
[Thu Jan 04 15:20:06.922498 2024] [core:notice] [pid 31066] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Thu Jan 04 15:20:21.376721 2024] [wsgi:error] [pid 31067] NOTE: Configuring authentication for SERVER mode.
[Thu Jan 04 15:20:21.376766 2024] [wsgi:error] [pid 31067]
[Thu Jan 04 15:20:21.376793 2024] [wsgi:error] [pid 31067] Enter the email address and password to use for the initial pgAdmin user account:
[Thu Jan 04 15:20:21.376803 2024] [wsgi:error] [pid 31067]
[Thu Jan 04 15:20:21.376876 2024] [wsgi:error] [pid 31067] Email address:
[Thu Jan 04 15:20:21.377894 2024] [wsgi:error] [pid 31067] 2024-01-04 15:20:21,377: ERROR\tpgadmin:\tDatabase migration failed
[Thu Jan 04 15:20:21.380424 2024] [wsgi:error] [pid 31067] 2024-01-04 15:20:21,380: ERROR\tpgadmin:\tTraceback (most recent call last):
[Thu Jan 04 15:20:21.380447 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/web/pgadmin/__init__.py", line 390, in upgrade_db
[Thu Jan 04 15:20:21.380459 2024] [wsgi:error] [pid 31067] db_upgrade(app)
[Thu Jan 04 15:20:21.380467 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/web/pgadmin/setup/db_upgrade.py", line 25, in db_upgrade
[Thu Jan 04 15:20:21.380477 2024] [wsgi:error] [pid 31067] flask_migrate.upgrade(migration_folder)
[Thu Jan 04 15:20:21.380487 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask_migrate/__init__.py", line 111, in wrapped
[Thu Jan 04 15:20:21.380497 2024] [wsgi:error] [pid 31067] f(*args, **kwargs)
[Thu Jan 04 15:20:21.380517 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask_migrate/__init__.py", line 200, in upgrade
[Thu Jan 04 15:20:21.380537 2024] [wsgi:error] [pid 31067] command.upgrade(config, revision, sql=sql, tag=tag)
[Thu Jan 04 15:20:21.380547 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/alembic/command.py", line 320, in upgrade
[Thu Jan 04 15:20:21.380557 2024] [wsgi:error] [pid 31067] script.run_env()
[Thu Jan 04 15:20:21.380566 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/alembic/script/base.py", line 563, in run_env
[Thu Jan 04 15:20:21.380576 2024] [wsgi:error] [pid 31067] util.load_python_file(self.dir, "env.py")
[Thu Jan 04 15:20:21.380586 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/alembic/util/pyfiles.py", line 92, in load_python_file
[Thu Jan 04 15:20:21.380596 2024] [wsgi:error] [pid 31067] module = load_module_py(module_id, path)
[Thu Jan 04 15:20:21.380605 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/alembic/util/pyfiles.py", line 108, in load_module_py
[Thu Jan 04 15:20:21.380615 2024] [wsgi:error] [pid 31067] spec.loader.exec_module(module) # type: ignore
[Thu Jan 04 15:20:21.380625 2024] [wsgi:error] [pid 31067] File "<frozen importlib._bootstrap_external>", line 678, in exec_module
[Thu Jan 04 15:20:21.380634 2024] [wsgi:error] [pid 31067] File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
[Thu Jan 04 15:20:21.380644 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 95, in <module>
[Thu Jan 04 15:20:21.380654 2024] [wsgi:error] [pid 31067] run_migrations_online()
[Thu Jan 04 15:20:21.380663 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 87, in run_migrations_online
[Thu Jan 04 15:20:21.380672 2024] [wsgi:error] [pid 31067] context.run_migrations()
[Thu Jan 04 15:20:21.380681 2024] [wsgi:error] [pid 31067] File "<string>", line 8, in run_migrations
[Thu Jan 04 15:20:21.380688 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/alembic/runtime/environment.py", line 851, in run_migrations
[Thu Jan 04 15:20:21.380694 2024] [wsgi:error] [pid 31067] self.get_context().run_migrations(**kw)
[Thu Jan 04 15:20:21.380700 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/alembic/runtime/migration.py", line 620, in run_migrations
[Thu Jan 04 15:20:21.380705 2024] [wsgi:error] [pid 31067] step.migration_fn(**kw)
[Thu Jan 04 15:20:21.380711 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/web/migrations/versions/fdc58d9bd449_.py", line 38, in upgrade
[Thu Jan 04 15:20:21.380717 2024] [wsgi:error] [pid 31067] email, password = user_info()
[Thu Jan 04 15:20:21.380723 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 75, in user_info
[Thu Jan 04 15:20:21.380728 2024] [wsgi:error] [pid 31067] email, p1 = user_info_server()

Daxu Yin
410-340-5842

Re: pgAdmin4 v6.21 on RHEL7.9

From

Daxu Yin

Date:

09 January, 20:07:44

Thanks a lot for your feedback, Yogesh,

I kind of guessed that was the issue, however, the pgadmin4.db and the corresponding pgadmin web instance have been running for a while with the initial account setup appropriately.

I wondered if the pgadmin4.db was corrupted somehow, so I first restored the pgadmin4.db from a backup a day ago, but I ran into the same issue.

Then I ran the command you mentioned below,

sudo /usr/pgadmin4/bin/setup-web.sh

It ended up triggering some kind of repository database migration, a new pgadmin4.db was created, and the pgadmin4 indeed started up.

However, the users lost everything, e.g. their login credentials, saved database connections

Regardless, the issue was fixed, though not in an ideal way.

Many thanks for your help,

Daxu Yin
410-340-5842

On Monday, January 8, 2024 at 06:19:46 AM EST, Yogesh Mahajan <yogesh.mahajan@enterprisedb.com> wrote:

Hi,

Error indicates the initial account is not set up on the pgadmin database. You need to run command below to setup these details -

sudo /usr/pgadmin4/bin/setup-web.sh

However this means, pgadmin will have a new database which does not have old data. Also when you have brought the backup copy pgadmin4 db, you have renamed it to pgadmin4.db

Thanks,

Yogesh Mahajan

EnterpriseDB

On Fri, Jan 5, 2024 at 3:09 AM Daxu Yin <daxuyin@yahoo.com> wrote:

Dear pgAdmin4 experts,

We're running pgadmin4-web 6.21 on RHEL 7.9
Everything worked for a couple of years, suddenly we couldn't start the server.

It seems the httpd server started, but the pgadmin4 module wouldn't load.
The first few lines of the error messages are shown below, also attached a zipped /var/log/httpd/error_log in this email.
It seems it try to upgrade the sqllite database somehow, but failed.
I suspected the pgadmin4.db is corrupted somehow, so I stopped the service, and brought back a backup copy of pgadmin4.db,
But it didn't fix the problem.

Could anyone help me what would be the problem? and how to fix it?

Many thanks in advance,

Daxu Yin
410-340-5842
-------------------------------------------------------------------------------------------------------------------------------------------------
[Thu Jan 04 15:18:37.998634 2024] [mpm_prefork:notice] [pid 30242] AH00170: caught SIGWINCH, shutting down gracefully
[Thu Jan 04 15:20:06.897388 2024] [core:notice] [pid 31066] SELinux policy enabled; httpd running as context system_u:system_r:httpd_t:s0
[Thu Jan 04 15:20:06.898563 2024] [suexec:notice] [pid 31066] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Thu Jan 04 15:20:06.914969 2024] [so:warn] [pid 31066] AH01574: module wsgi_module is already loaded, skipping
AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using fe80::1060:abff:fe12:6013. Set the 'ServerName' directive globally to suppress this message
[Thu Jan 04 15:20:06.917938 2024] [lbmethod_heartbeat:notice] [pid 31066] AH02282: No slotmem from mod_heartmonitor
[Thu Jan 04 15:20:06.922454 2024] [mpm_prefork:notice] [pid 31066] AH00163: Apache/2.4.6 (Red Hat Enterprise Linux) mod_wsgi/4.9.0 Python/3.6 configured -- resuming normal operations
[Thu Jan 04 15:20:06.922498 2024] [core:notice] [pid 31066] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Thu Jan 04 15:20:21.376721 2024] [wsgi:error] [pid 31067] NOTE: Configuring authentication for SERVER mode.
[Thu Jan 04 15:20:21.376766 2024] [wsgi:error] [pid 31067]
[Thu Jan 04 15:20:21.376793 2024] [wsgi:error] [pid 31067] Enter the email address and password to use for the initial pgAdmin user account:
[Thu Jan 04 15:20:21.376803 2024] [wsgi:error] [pid 31067]
[Thu Jan 04 15:20:21.376876 2024] [wsgi:error] [pid 31067] Email address:
[Thu Jan 04 15:20:21.377894 2024] [wsgi:error] [pid 31067] 2024-01-04 15:20:21,377: ERROR\tpgadmin:\tDatabase migration failed
[Thu Jan 04 15:20:21.380424 2024] [wsgi:error] [pid 31067] 2024-01-04 15:20:21,380: ERROR\tpgadmin:\tTraceback (most recent call last):
[Thu Jan 04 15:20:21.380447 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/web/pgadmin/__init__.py", line 390, in upgrade_db
[Thu Jan 04 15:20:21.380459 2024] [wsgi:error] [pid 31067] db_upgrade(app)
[Thu Jan 04 15:20:21.380467 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/web/pgadmin/setup/db_upgrade.py", line 25, in db_upgrade
[Thu Jan 04 15:20:21.380477 2024] [wsgi:error] [pid 31067] flask_migrate.upgrade(migration_folder)
[Thu Jan 04 15:20:21.380487 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask_migrate/__init__.py", line 111, in wrapped
[Thu Jan 04 15:20:21.380497 2024] [wsgi:error] [pid 31067] f(*args, **kwargs)
[Thu Jan 04 15:20:21.380517 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/flask_migrate/__init__.py", line 200, in upgrade
[Thu Jan 04 15:20:21.380537 2024] [wsgi:error] [pid 31067] command.upgrade(config, revision, sql=sql, tag=tag)
[Thu Jan 04 15:20:21.380547 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/alembic/command.py", line 320, in upgrade
[Thu Jan 04 15:20:21.380557 2024] [wsgi:error] [pid 31067] script.run_env()
[Thu Jan 04 15:20:21.380566 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/alembic/script/base.py", line 563, in run_env
[Thu Jan 04 15:20:21.380576 2024] [wsgi:error] [pid 31067] util.load_python_file(self.dir, "env.py")
[Thu Jan 04 15:20:21.380586 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/alembic/util/pyfiles.py", line 92, in load_python_file
[Thu Jan 04 15:20:21.380596 2024] [wsgi:error] [pid 31067] module = load_module_py(module_id, path)
[Thu Jan 04 15:20:21.380605 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/alembic/util/pyfiles.py", line 108, in load_module_py
[Thu Jan 04 15:20:21.380615 2024] [wsgi:error] [pid 31067] spec.loader.exec_module(module) # type: ignore
[Thu Jan 04 15:20:21.380625 2024] [wsgi:error] [pid 31067] File "<frozen importlib._bootstrap_external>", line 678, in exec_module
[Thu Jan 04 15:20:21.380634 2024] [wsgi:error] [pid 31067] File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
[Thu Jan 04 15:20:21.380644 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 95, in <module>
[Thu Jan 04 15:20:21.380654 2024] [wsgi:error] [pid 31067] run_migrations_online()
[Thu Jan 04 15:20:21.380663 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 87, in run_migrations_online
[Thu Jan 04 15:20:21.380672 2024] [wsgi:error] [pid 31067] context.run_migrations()
[Thu Jan 04 15:20:21.380681 2024] [wsgi:error] [pid 31067] File "<string>", line 8, in run_migrations
[Thu Jan 04 15:20:21.380688 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/alembic/runtime/environment.py", line 851, in run_migrations
[Thu Jan 04 15:20:21.380694 2024] [wsgi:error] [pid 31067] self.get_context().run_migrations(**kw)
[Thu Jan 04 15:20:21.380700 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/venv/lib64/python3.6/site-packages/alembic/runtime/migration.py", line 620, in run_migrations
[Thu Jan 04 15:20:21.380705 2024] [wsgi:error] [pid 31067] step.migration_fn(**kw)
[Thu Jan 04 15:20:21.380711 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/web/migrations/versions/fdc58d9bd449_.py", line 38, in upgrade
[Thu Jan 04 15:20:21.380717 2024] [wsgi:error] [pid 31067] email, password = user_info()
[Thu Jan 04 15:20:21.380723 2024] [wsgi:error] [pid 31067] File "/usr/pgadmin4/web/pgadmin/setup/user_info.py", line 75, in user_info
[Thu Jan 04 15:20:21.380728 2024] [wsgi:error] [pid 31067] email, p1 = user_info_server()

Daxu Yin
410-340-5842