Problem:
After foreman-installer --scenario katello candlepin and pulpcore postgresql databases wouldn’t allow access to users candlepin and pulp.
Expected outcome:
public grants would be done during the installation.
Foreman and Proxy versions:
Foreman 3.15 Katello 4.17
Foreman and Proxy plugin versions:
Distribution and version:
Rocky Linux 9.6
Other relevant data:
This isn’t a request for help per se. I was able to manually grant permissions to the databases after the initial install when I noticed certain problems on the web interface. So those problems are cleared up, but the foreman install and logs complained about lack of permissions to candlepin and pulpcore databases.
\c candlepin
GRANT USAGE ON SCHEMA public TO candlepin;
GRANT CREATE ON SCHEMA public TO candlepin;
\c pulpcore
GRANT USAGE ON SCHEMA public TO pulp;
GRANT CREATE ON SCHEMA public TO pulp;
Fixed the issues. As far as I can tell my old installation on foreman 3.5 and katello 4.7 doesn’t grant these permissions and it works fine. If these permissions are needed, shouldn’t they be created when the databases are created with foreman-installer? I’m putting this all in puppet, so I’m curious what is going on. This was some of the output that tipped me off to why pulpcore packages failed to install initially after I’d already granted permissions to candlepin and fixed another web issue.
django.db.utils.ProgrammingError: permission denied for schema public
LINE 1: CREATE TABLE “django_migrations” (“id” integer NOT NULL PRIM…
^
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File “/usr/bin/pulpcore-manager”, line 8, in
sys.exit(manage())
After permissions were granted re-running foreman-installer installed all the necessary pulpcore packages and started the services.
Thanks for any feedback.