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
