Error testing hue connection during services setup in CDP Private Trial: Unexpected error. Unable to verify database connection

[#1]

I get 

"Unexpected error. Unable to verify database connection"

 I checked cloudera-scm-server.log file, found the following ERROR:

7345 MainThread redactor     ERROR    Redaction rules file doesn't exist, not redacting logs. file: redaction-rules.json, directory: /run/cloudera-scm-agent/process/57-HUE-test-db-connection

------

Details:

[root@prw-cld-trial cloudera-scm-server]# pwd

/var/log/cloudera-scm-server

# more cloudera-scm-server.log

2024-12-20 14:20:06,319 INFO CommandPusher-1:com.cloudera.server.cmf.CommandPusherThread: Acquired lease lock on DbCommand:81

2024-12-20 14:20:06,446 INFO CommandPusher-1:com.cloudera.cmf.service.AbstractOneOffHostCommand: Unsuccessful 'HueTestDatabaseConnection'

2024-12-20 14:20:06,471 INFO CommandPusher-1:com.cloudera.cmf.service.AbstractDbConnectionTestCommand: Command exited with code: 1

2024-12-20 14:20:06,472 INFO CommandPusher-1:com.cloudera.cmf.service.AbstractDbConnectionTestCommand:   from cryptography import x509

[20/Dec/2024 14:19:43 +0000] 7345 MainThread redactor     INFO     Started launcher: /opt/cloudera/cm-agent/service/hue/hue.sh is_db_alive

[20/Dec/2024 14:19:43 +0000] 7345 MainThread redactor     ERROR    Redaction rules file doesn't exist, not redacting logs. file: redaction-rules.json, directory: /run/cloudera-scm-agent/process/57-HUE-test-db-connection

[20/Dec/2024 14:19:43 +0000] 7345 MainThread redactor     INFO     Re-exec watcher: /opt/cloudera/cm-agent/bin/cm proc_watcher 7382

/opt/cloudera/cm-agent/lib/python2.7/site-packages/OpenSSL/crypto.py:12: CryptographyDeprecationWarning: Python 2 is no longer supported by the Python core team. Support for it is now deprecated in cryptography, and will be removed in the next release.

  from cryptography import x509

+ date

+ date

Fri 20 Dec 14:20:02 EST 2024

++ dirname /opt/cloudera/cm-agent/service/hue/hue.sh

+ cloudera_config=/opt/cloudera/cm-agent/service/hue

++ cd /opt/cloudera/cm-agent/service/hue/../common

++ pwd

+ cloudera_config=/opt/cloudera/cm-agent/service/common

+ . /opt/cloudera/cm-agent/service/common/cloudera-config.sh

++ : /opt/cloudera/cm

++ export CLOUDERA_DIR

++ set -x

+ source_parcel_environment

+ '[' '!' -z '' ']'

+ locate_cdh_java_home

+ '[' -z '' ']'

+ '[' -z /usr/libexec/bigtop-utils ']'

+ local BIGTOP_DETECT_JAVAHOME=

+ for candidate in "${JSVC_HOME}" "${JSVC_HOME}/.." "/usr/lib/bigtop-utils" "/usr/libexec"

+ '[' -e /usr/libexec/bigtop-utils/bigtop-detect-javahome ']'

+ for candidate in "${JSVC_HOME}" "${JSVC_HOME}/.." "/usr/lib/bigtop-utils" "/usr/libexec"

+ '[' -e /usr/libexec/bigtop-utils/../bigtop-detect-javahome ']'

+ for candidate in "${JSVC_HOME}" "${JSVC_HOME}/.." "/usr/lib/bigtop-utils" "/usr/libexec"

+ '[' -e /usr/lib/bigtop-utils/bigtop-detect-javahome ']'

+ for candidate in "${JSVC_HOME}" "${JSVC_HOME}/.." "/usr/lib/bigtop-utils" "/usr/libexec"

+ '[' -e /usr/libexec/bigtop-detect-javahome ']'

+ '[' -z '' ']'

+ echo 'Cannot find CDH'\''s bigtop-detect-javahome.'

+ exit 1

----------

checked another log 

[root@prw-cld-trial logs]# pwd

/run/cloudera-scm-agent/process/57-HUE-test-db-connection/logs

cat stderr.log

/opt/cloudera/cm-agent/lib/python2.7/site-packages/OpenSSL/crypto.py:12: CryptographyDeprecationWarning: Python 2 is no longer supported by the Python core team. Support for it is now deprecated in cryptography, and will be removed in the next release.

  from cryptography import x509

[20/Dec/2024 14:19:43 +0000] 7345 MainThread redactor     INFO     Started launcher: /opt/cloudera/cm-agent/service/hue/hue.sh is_db_alive

[20/Dec/2024 14:19:43 +0000] 7345 MainThread redactor     ERROR    Redaction rules file doesn't exist, not redacting logs. file: redaction-rules.json, directory: /run/cloudera-scm-agent/process/57-HUE-test-db-connection

[20/Dec/2024 14:19:43 +0000] 7345 MainThread redactor     INFO     Re-exec watcher: /opt/cloudera/cm-agent/bin/cm proc_watcher 7382

/opt/cloudera/cm-agent/lib/python2.7/site-packages/OpenSSL/crypto.py:12: CryptographyDeprecationWarning: Python 2 is no longer supported by the Python core team. Support for it is now deprecated in cryptography, and will be removed in the next release.

  from cryptography import x509

+ date

+ date

Fri 20 Dec 14:20:02 EST 2024

++ dirname /opt/cloudera/cm-agent/service/hue/hue.sh

+ cloudera_config=/opt/cloudera/cm-agent/service/hue

++ cd /opt/cloudera/cm-agent/service/hue/../common

++ pwd

+ cloudera_config=/opt/cloudera/cm-agent/service/common

+ . /opt/cloudera/cm-agent/service/common/cloudera-config.sh

++ : /opt/cloudera/cm

++ export CLOUDERA_DIR

++ set -x

+ source_parcel_environment

+ '[' '!' -z '' ']'

+ locate_cdh_java_home

+ '[' -z '' ']'

+ '[' -z /usr/libexec/bigtop-utils ']'

+ local BIGTOP_DETECT_JAVAHOME=

+ for candidate in "${JSVC_HOME}" "${JSVC_HOME}/.." "/usr/lib/bigtop-utils" "/usr/libexec"

+ '[' -e /usr/libexec/bigtop-utils/bigtop-detect-javahome ']'

+ for candidate in "${JSVC_HOME}" "${JSVC_HOME}/.." "/usr/lib/bigtop-utils" "/usr/libexec"

+ '[' -e /usr/libexec/bigtop-utils/../bigtop-detect-javahome ']'

+ for candidate in "${JSVC_HOME}" "${JSVC_HOME}/.." "/usr/lib/bigtop-utils" "/usr/libexec"

+ '[' -e /usr/lib/bigtop-utils/bigtop-detect-javahome ']'

+ for candidate in "${JSVC_HOME}" "${JSVC_HOME}/.." "/usr/lib/bigtop-utils" "/usr/libexec"

+ '[' -e /usr/libexec/bigtop-detect-javahome ']'

+ '[' -z '' ']'

+ echo 'Cannot find CDH'\''s bigtop-detect-javahome.'

+ exit 1

[#2]

@Riyadbank Welcome to the Cloudera Community!

To help you get the best possible solution, I have tagged our hue experts @dturnau @nramanaiah  who may be able to assist you further.

Please keep us updated on your post, and we hope you find a satisfactory solution to your query.