pgAdmin4 v6.21 on RHEL7.9

Поиск
Список
Период
Сортировка
От Daxu Yin
Тема pgAdmin4 v6.21 on RHEL7.9
Дата
Msg-id 675243126.4799003.1704404306483@mail.yahoo.com
обсуждение исходный текст
Ответ на Re: pgAdmin4 v6.21 on RHEL7.9 with FIPS enabled  (Daxu Yin <daxuyin@yahoo.com>)
Ответы Re: pgAdmin4 v6.21 on RHEL7.9  (Yogesh Mahajan <yogesh.mahajan@enterprisedb.com>)
Список pgadmin-support
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


Вложения

В списке pgadmin-support по дате отправления:

Предыдущее
От: Morten Bonnerup Rasmussen
Дата:
Сообщение: Re: Enable HTTPS on pgAdmin in Server Mode
Следующее
От: Yogesh Mahajan
Дата:
Сообщение: Re: Enable HTTPS on pgAdmin in Server Mode