Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 771651 - dev-db/pgadmin4 - Failed to set ACL on the directory containing the configuration database
Summary: dev-db/pgadmin4 - Failed to set ACL on the directory containing the configura...
Status: RESOLVED INVALID
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: Normal normal (vote)
Assignee: PgSQL Bugs
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-02-19 19:03 UTC by acidtonic
Modified: 2022-10-24 05:26 UTC (History)
2 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description acidtonic 2021-02-19 19:03:53 UTC
I have installed pgadmin4 but it has a bunch of various errors that prevent it from launching.

First the permissions were not correct for my user.
Upon fixing that I had errors about the version variable is None.

WARNING: Failed to set ACL on the directory containing the configuration database:
           [Errno 1] Operation not permitted: '/var/lib/pgadmin'
HINT   : You may need to manually set the permissions on
         /var/lib/pgadmin to allow arkk to write to it.
Traceback (most recent call last):
  File "/usr/share/pgadmin4/web/pgAdmin4.py", line 93, in <module>
    app = create_app()
  File "/usr/share/pgadmin4/web/pgadmin/__init__.py", line 346, in create_app
    if not os.path.exists(SQLITE_PATH) or get_version() == -1:
  File "/usr/share/pgadmin4/web/pgadmin/setup/db_version.py", line 20, in get_version
    return version.value
AttributeError: 'NoneType' object has no attribute 'value'


So I added a tiny change to return -1 if version is None and get farther.... 

  File "/usr/share/pgadmin4/web/pgAdmin4.py", line 86, in <module>
    exec(open(file_quote(setup_py), 'r').read())
  File "<string>", line 449, in <module>
  File "<string>", line 372, in setup_db
  File "/usr/share/pgadmin4/web/pgadmin/__init__.py", line 350, in create_app
    db_upgrade(app)
  File "/usr/share/pgadmin4/web/pgadmin/setup/db_upgrade.py", line 25, in db_upgrade
    flask_migrate.upgrade(migration_folder)
  File "/usr/lib/python3.8/site-packages/flask_migrate/__init__.py", line 96, in wrapped
    f(*args, **kwargs)
  File "/usr/lib/python3.8/site-packages/flask_migrate/__init__.py", line 271, in upgrade
    command.upgrade(config, revision, sql=sql, tag=tag)
  File "/usr/lib/python3.8/site-packages/alembic/command.py", line 294, in upgrade
    script.run_env()
  File "/usr/lib/python3.8/site-packages/alembic/script/base.py", line 481, in run_env
    util.load_python_file(self.dir, "env.py")
  File "/usr/lib/python3.8/site-packages/alembic/util/pyfiles.py", line 97, in load_python_file
    module = load_module_py(module_id, path)
  File "/usr/lib/python3.8/site-packages/alembic/util/compat.py", line 182, in load_module_py
    spec.loader.exec_module(module)
  File "<frozen importlib._bootstrap_external>", line 783, in exec_module
  File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
  File "/usr/share/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 93, in <module>
    run_migrations_online()
  File "/usr/share/pgadmin4/web/pgadmin/setup/../../migrations/env.py", line 86, in run_migrations_online
    context.run_migrations()
  File "<string>", line 8, in run_migrations
  File "/usr/lib/python3.8/site-packages/alembic/runtime/environment.py", line 813, in run_migrations
    self.get_context().run_migrations(**kw)
  File "/usr/lib/python3.8/site-packages/alembic/runtime/migration.py", line 560, in run_migrations
    step.migration_fn(**kw)
  File "/usr/share/pgadmin4/web/migrations/versions/fdc58d9bd449_.py", line 122, in upgrade
    Security(current_app, user_datastore, register_blueprint=False)
  File "/usr/lib/python3.8/site-packages/flask_security/core.py", line 1024, in __init__
    self._state = self.init_app(
  File "/usr/lib/python3.8/site-packages/flask_security/core.py", line 1080, in init_app
    raise ValueError("User model must contain fs_uniquifier as of 4.0.0")
ValueError: User model must contain fs_uniquifier as of 4.0.0


At this point I'm declaring it broken and stopped trying.
Comment 1 Jonas Stein gentoo-dev 2021-02-19 21:42:54 UTC
Thank you for the report. We need to have all information at hand before ticket assignment. That is why I ask you to 
* attach the logs and 
* paste the emerge info 
as described on https://wiki.gentoo.org/wiki/Attach_the_logs_to_the_bug_ticket
Comment 2 Aaron W. Swenson gentoo-dev 2021-02-21 19:52:05 UTC
I've emerged and started pgAdmin4 just fine. To see what files it opened, I ran lsof on its PID. It doesn't have anything open in /var/lib, and /var/lib/pgadmin does not exist on my machine.

    titan ~
    $ lsof -P -n -p 12375 | grep -c 'var/lib'
    0

There's nothing in the current implementation needs any resources in /var/lib/pgadmin.

You're doing something that isn't supported. As this bug isn't about introducing such support, I'm closing it as invalid.