Re: pgAdmin4 v6.21 on RHEL7.9

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(at)yahoo(dot)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
>
>
>