Bug #35029: satellite upgrade to 6.11 fails in installer with "Could not open SSL root certificate file /root/.postgresql/root.crt" error for external DB setup - Foreman Maintain - Foreman

Actions

Copy link

Bug #35029

closed

satellite upgrade to 6.11 fails in installer with "Could not open SSL root certificate file /root/.postgresql/root.crt" error for external DB setup

Added by Amit Upadhye about 3 years ago. Updated about 3 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Category:

Target version:

Difficulty:

Triaged:

Bugzilla link:

2090820

Pull request:

https://github.com/theforeman/foreman_maintain/pull/623

Fixed in Releases:

Found in Releases:

Red Hat JIRA:

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=2090820

Description of problem:

Version-Release number of selected component (if applicable):
Satellite 6.10.6

How reproducible:
Always

Steps to Reproduce:
1. Prepare Satellite 6.10.6 with external PostgreSQL (with SSL)
2. Setup all required repositories and upgrade foreman-maintain packages
3. # foreman-maintain upgrade run --target-version 6.11 --whitelist='repositories-validate,repositories-setup'
...
Running Migration scripts to Satellite 6.11 ================================================================================
Setup repositories: [SKIPPED]
--------------------------------------------------------------------------------
Unlock packages: [OK]
--------------------------------------------------------------------------------
Update package(s) : [OK]
--------------------------------------------------------------------------------
Procedures::Installer::Upgrade: 2022-05-26 11:15:55 [NOTICE] [root] Loading installer configuration. This will take some time.
2022-05-26 11:16:02 [NOTICE] [root] Running installer with log based terminal output at level NOTICE.
2022-05-26 11:16:02 [NOTICE] [root] Use l to set the terminal output log level to ERROR, WARN, NOTICE, INFO, or DEBUG. See --full-help for definitions.
2022-05-26 11:16:08 [WARN ] [pre] Skipping system checks.
2022-05-26 11:16:08 [WARN ] [pre] Skipping system checks.
2022-05-26 11:16:33 [NOTICE] [configure] Starting system configuration.
2022-05-26 11:16:48 [NOTICE] [configure] 250 configuration steps out of 1849 steps complete.
2022-05-26 11:17:04 [NOTICE] [configure] 500 configuration steps out of 1851 steps complete.
2022-05-26 11:17:11 [ERROR ] [configure] Execution of '/usr/share/candlepin/cpdb --update --dbhost=<satellite> --dbport=5432 --database=candlepin1db?ssl=true --user=candlepin1! -<passwd>=RedHat1!' returned 1: ########## ERROR ############
2022-05-26 11:17:11 [ERROR ] [configure] Error running command: /usr/share/candlepin/liquibase.sh --driver=org.postgresql.Driver --classpath=/var/lib/tomcat/webapps/candlepin/WEB-INF/lib/postgresql-42.3.3.jar:/var/lib/tomcat/webapps/candlepin/WEB-INF/classes/ --changeLogFile=db/changelog/changelog-update.xml --url="jdbc:postgresql://<satellite>:5432/candlepin1db?ssl=true" --username=$DBUSERNAME --<passwd>=$DB<passwd> --logLevel=severe migrate -Dcommunity=False
2022-05-26 11:17:11 [ERROR ] [configure] Status code: 65280
2022-05-26 11:17:11 [ERROR ] [configure] Command output: Liquibase update Failed: liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: Could not open SSL root certificate file /root/.postgresql/root.crt.
2022-05-26 11:17:11 [ERROR ] [configure] SEVERE 5/26/22, 11:17 AM:liquibase: liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: Could not open SSL root certificate file /root/.postgresql/root.crt.
2022-05-26 11:17:11 [ERROR ] [configure] liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: Could not open SSL root certificate file /root/.postgresql/root.crt.
2022-05-26 11:17:11 [ERROR ] [configure] at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:61)
2022-05-26 11:17:11 [ERROR ] [configure] at liquibase.integration.commandline.Main.doMigration(Main.java:788)
2022-05-26 11:17:11 [ERROR ] [configure] at liquibase.integration.commandline.Main.main(Main.java:133)
2022-05-26 11:17:11 [ERROR ] [configure] Caused by: liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: Could not open SSL root certificate file /root/.postgresql/root.crt.
2022-05-26 11:17:11 [ERROR ] [configure] at liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:231)
2022-05-26 11:17:11 [ERROR ] [configure] at liquibase.database.DatabaseFactory.openDatabase(DatabaseFactory.java:141)
2022-05-26 11:17:11 [ERROR ] [configure] at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:52)
2022-05-26 11:17:11 [ERROR ] [configure] ... 2 more
2022-05-26 11:17:11 [ERROR ] [configure] Caused by: org.postgresql.util.PSQLException: Could not open SSL root certificate file /root/.postgresql/root.crt.
2022-05-26 11:17:11 [ERROR ] [configure] at org.postgresql.ssl.LibPQFactory.<init>(LibPQFactory.java:150)
2022-05-26 11:17:11 [ERROR ] [configure] at org.postgresql.core.SocketFactoryFactory.getSslSocketFactory(SocketFactoryFactory.java:61)
2022-05-26 11:17:11 [ERROR ] [configure] at org.postgresql.ssl.MakeSSL.convert(MakeSSL.java:34)
2022-05-26 11:17:11 [ERROR ] [configure] at org.postgresql.core.v3.ConnectionFactoryImpl.enableSSL(ConnectionFactoryImpl.java:571)
2022-05-26 11:17:11 [ERROR ] [configure] at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:168)
2022-05-26 11:17:11 [ERROR ] [configure] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:235)
2022-05-26 11:17:11 [ERROR ] [configure] at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
2022-05-26 11:17:11 [ERROR ] [configure] at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:223)
2022-05-26 11:17:11 [ERROR ] [configure] at org.postgresql.Driver.makeConnection(Driver.java:400)
2022-05-26 11:17:11 [ERROR ] [configure] at org.postgresql.Driver.connect(Driver.java:259)
2022-05-26 11:17:11 [ERROR ] [configure] at liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:223)
2022-05-26 11:17:11 [ERROR ] [configure] ... 4 more
2022-05-26 11:17:11 [ERROR ] [configure] Caused by: java.io.FileNotFoundException: /root/.postgresql/root.crt (No such file or directory)
2022-05-26 11:17:11 [ERROR ] [configure] at java.base/java.io.FileInputStream.open0(Native Method)
2022-05-26 11:17:11 [ERROR ] [configure] at java.base/java.io.FileInputStream.open(FileInputStream.java:219)
2022-05-26 11:17:11 [ERROR ] [configure] at java.base/java.io.FileInputStream.<init>(FileInputStream.java:157)
2022-05-26 11:17:11 [ERROR ] [configure] at java.base/java.io.FileInputStream.<init>(FileInputStream.java:112)
2022-05-26 11:17:11 [ERROR ] [configure] at org.postgresql.ssl.LibPQFactory.<init>(LibPQFactory.java:147)
2022-05-26 11:17:11 [ERROR ] [configure] ... 14 more
...