Bug 1999791

From Sat 6.10 Beta docs i.e. 

https://access.redhat.com/documentation/en-us/red_hat_satellite/6.10-beta/html-single/installing_satellite_server_from_a_connected_network/index#installing-postgresql_satellite

4.13.4. Configuring Satellite to use External Databases --> Reflects the satellite-installer options for foreman \ candlepin \ pulpcore db

But the section before that i.e. 4.13.3. Installing PostgreSQL , is missing the steps for creating pulpcore db. It only talks about foreman and candlepin at step 10 and 12.


Is this expected?

The steps here in https://access.redhat.com/documentation/%20ja-jp/red_hat_satellite/6.10/html/installing_satellite_server_from_a_disconnected_network/performing-additional-configuration#preparing-a-host-for-external-databases_satellite is broken .

To explain further:

In "3.10.3. Installing PostgreSQL" 

Point 10:

CREATE USER "pulpcore" WITH PASSWORD 'Pulpcore_Password';

Point 12:

PGPASSWORD='Pulpcore_Password' psql -h postgres.example.com -p 5432 -U pulpcore -d pulpcore -c "SELECT 1 as ping"

As you can see, we suggest creating pulpcore user


but by default the user satellite creates is pulp in an internal DB. So this installer flag always points to "pulp" user

--foreman-proxy-content-pulpcore-postgresql-user  User of the Pulpcore PostgreSQL database. (current: "pulp")


Since at "3.10.4. Configuring Satellite to use External Databases" we suggest running following with no pulpcore database user mentioned:

satellite-installer --scenario satellite \
  --foreman-db-host postgres.example.com \
  --foreman-db-password Foreman_Password \
  --foreman-db-database foreman \
  --foreman-db-manage false \
  --katello-candlepin-db-host postgres.example.com \
  --katello-candlepin-db-name candlepin \
  --katello-candlepin-db-password Candlepin_Password \
  --katello-candlepin-manage-db false \
  --foreman-proxy-content-pulpcore-manage-postgresql false \
  --foreman-proxy-content-pulpcore-postgresql-host postgres.example.com \
  --foreman-proxy-content-pulpcore-postgresql-db-name pulpcore \
  --foreman-proxy-content-pulpcore-postgresql-password Pulpcore_Password


It fails:

2022-02-17 03:50:42 [DEBUG ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/unless:     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
2022-02-17 03:50:42 [DEBUG ] [configure] /Stage[main]/Pulpcore::Database/Pulpcore::Admin[migrate --noinput]/Exec[pulpcore-manager migrate --noinput]/unless: django.db.utils.OperationalError: FATAL:  password authentication failed for user "pulp"


So the correct command would be:


satellite-installer --scenario satellite \
  --foreman-db-host postgres.example.com \
  --foreman-db-password Foreman_Password \
  --foreman-db-database foreman \
  --foreman-db-manage false \
  --katello-candlepin-db-host postgres.example.com \
  --katello-candlepin-db-name candlepin \
  --katello-candlepin-db-password Candlepin_Password \
  --katello-candlepin-manage-db false \
  --foreman-proxy-content-pulpcore-manage-postgresql false \
  --foreman-proxy-content-pulpcore-postgresql-host postgres.example.com \
  --foreman-proxy-content-pulpcore-postgresql-db-name pulpcore \
  --foreman-proxy-content-pulpcore-postgresql-password Pulpcore_Password \
  --foreman-proxy-content-pulpcore-postgresql-user pulpcore



 @mdolezel  , If possible, Can you have someone on it and get this one line change performed in the said documentation please?

The update documentation has been published on Red Hat Customer Portal:

https://access.redhat.com/documentation/en-us/red_hat_satellite/6.10/html-single/installing_satellite_server_from_a_disconnected_network/index#configuring-satellite-to-use-external-databases_satellite

Therefore, I'm closing this BZ. Please, feel free to reopen if needed.

Thank you!