Opher Shachar created AMBARI-25254:
--------------------------------------
Summary: The Cluster Install Wizard fails MariaDB (MySQL)
connection test
Key: AMBARI-25254
URL: https://issues.apache.org/jira/browse/AMBARI-25254
Project: Ambari
Issue Type: Bug
Components: ambari-web
Affects Versions: 2.7.3
Environment: CentOS 7.6
MariaDB 5.5.60
mariadb-java-client 2.4.1
Reporter: Opher Shachar
Installing on CentOS 7 by following the
[documentation|https://docs.hortonworks.com/HDPDocuments/Ambari-2.7.3.0/bk_ambari-installation/content/customize_services.html].
I arrive at the +Customize Services -> DATABASES -> RANGER+ page and do the
required configuration for my MariaDB instance using the
mariadb-java-client-2.4.1. Specifically, I update the _Driver class name_ to:
{{org.mariadb.jdbc.Driver}}
Pressing the Test Connection button I get "Connection Failed" with this stdout:
{code:java}
2019-04-16 16:52:50,190 - Host checks started.
2019-04-16 16:52:50,190 - Check execute list: db_connection_check
2019-04-16 16:52:50,191 - DB connection check started.
WARNING: File /var/lib/ambari-agent/cache/DBConnectionVerification.jar already
exists, assuming it was downloaded before
WARNING: File /var/lib/ambari-agent/cache/mariadb-java-client-2.4.1.jar already
exists, assuming it was downloaded before
2019-04-16 16:52:50,192 - call['/usr/lib/jvm/java-1.8.0/bin/java -cp
/var/lib/ambari-agent/cache/DBConnectionVerification.jar:/var/lib/ambari-agent/cache/mariadb-java-client-2.4.1.jar
-Djava.library.path=/var/lib/ambari-agent/cache
org.apache.ambari.server.DBConnectionVerification
"jdbc:mysql://opher-dev7.radcom.co.il:3306" "root" [PROTECTED]
com.mysql.jdbc.Driver'] {}
2019-04-16 16:52:50,284 - call returned (1, 'ERROR: Unable to connect to the
DB. Please check DB connection properties.\njava.lang.ClassNotFoundException:
com.mysql.jdbc.Driver')
2019-04-16 16:52:50,284 - DB connection check completed.
2019-04-16 16:52:50,285 - Host checks completed.
2019-04-16 16:52:50,285 - Check db_connection_check was unsuccessful. Exit
code: 1. Message: ERROR: Unable to connect to the DB. Please check DB
connection properties.
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
Command failed after 1 tries
{code}
Note that the wizard is wrongly trying to load the
{noformat}
com.mysql.jdbc.Driver{noformat}
class!
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
