[AMBARI-25254] The Cluster Install Wizard fails MariaDB (MySQL) connection test

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 2.7.3
• Component/s: ambari-web

Environment

CentOS 7.6

MariaDB 5.5.60

mariadb-java-client 2.4.1

• Assignee: Unassigned
• Reporter: Opher Shachar
• Created: 16/Apr/19 14:17
• Updated: 16/Apr/19 14:17

Description

Installing on CentOS 7 by following the documentation.

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:

 

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

Note that the wizard is wrongly trying to load the

com.mysql.jdbc.Driver

class!