Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Error starting registry in Ambari (HDF 3.0)

avatar
Explorer

Hi,

After installing the HDF (3.0.0.0) platform with NiFi, I am trying to start the Registry service (0.3.0), but it fails due to the following error:

Downloading mysql jar from url: https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.40.zip
Downloading file mysql-connector-java-5.1.40.zip into /tmp
Failed to download the mysql driver from https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.40.zip
Error occurred while downloading MySQL jar. bootstrap dir: /usr/hdf/current/registry/bootstrap

I have modified my ambari-server/ambari-env.sh file with the correct proxy host name and port, but does not appear to help. I have also tried manually installing this version of the mysql-connector, again no luck.

Any ideas?

1 ACCEPTED SOLUTION

avatar
Explorer

Hi,

I had the same issue and I resolved it incluiding proxy information

-Dhttps.proxyHost=proxy_name

-Dhttps.proxyPort=xxxx

when bootstrap-storage.sh call the class ${TABLE_INITIALIZER_MAIN_CLASS}

(functions dropTables, createTables, checkStorageConnection).

View solution in original post

12 REPLIES 12

avatar
New Contributor

This is the bug (AMBARI-21492): https://issues.apache.org/jira/browse/AMBARI-21492

Another simple workaround is to download the file, stuff it somewhere on a web server and edit the MYSQL_JAR_URL_PATH in this file: /usr/hdf/current/registry/bootstrap/bootstrap-storage.sh
If you're super lazy, this can work too:

yum install httpd -y  # Installs the Apache HTTP Server.
apachectl start  # Starts it.
# You can optionally use the jar brought by 'yum install mysql-connector-java', if it's up to date, to pack it into a format the script expects:
# mkdir /tmp/mysql-connector-java-5.1.40
# cp /usr/share/java/mysql-connector-java.jar /tmp/mysql-connector-java-5.1.40/mysql-connector-java-5.1.40-bin.jar
# cd /tmp
# zip /tmp/mysql-connector-java-5.1.40/ mysql-connector-java-5.1.40.zip
cp <wherever>/mysql-connector-java-5.1.40.zip /var/www/html/  # Based on environment, this one's for RHEL/Centos.
vi /usr/hdf/current/registry/bootstrap/bootstrap-storage.sh
# MYSQL_JAR_URL_PATH=http://yourserver/mysql-connector-java-5.1.40.zip

avatar
New Contributor

I was able to resolve the issue by copying the jar "mysql-connector-java-5.1.40-bin.jar" in /usr/share/java and /usr/hdf/current/registry/bootstrap/lib/. Below are the steps I followed:

1. Remove the mysql-connector-java.jar or other version jars from /usr/share/java and /usr/hdf/current/registry/bootstrap/

2. copy the jar mysql-connector-java-5.1.40-bin.jar in /usr/hdf/current/registry/bootstrap/lib/ and /usr/share/java

3. Create the symlinks:

ln -s /usr/share/java/ mysql-connector-java-5.1.40-bin.jar /usr/share/mysql-connector-java.jar

4.ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar

5. ambari-server restart

6. Start the registry service from ambari

Thanks, Sinha

,

I was able to resolve the issue by copying the jar "mysql-connector-java-5.1.40-bin.jar" in /usr/share/java and /usr/hdf/current/registry/bootstrap/lib/. Below are the steps I followed:

1. Remove the mysql-connector-java.jar or other version jars from /usr/share/java and /usr/hdf/current/registry/bootstrap/

2. copy the jar mysql-connector-java-5.1.40-bin.jar in /usr/hdf/current/registry/bootstrap/lib/ and /usr/share/java

3. Crete the symlinks: ln -s /usr/share/java/ mysql-connector-java-5.1.40-bin.jar /usr/share/mysql-connector-java.jar

4.ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar

5. ambari-server restart 6. Start the registry service from ambari

Thanks,

Sinha

,

I was able to resolve the issue by copying the jar "mysql-connector-java-5.1.40-bin.jar" in /usr/hdf/current/registry/bootstrap/lib/ and /usr/share/java location. I created symlink with the mysql jar:

ln -s /usr/share/java/mysql-connector-java-5.1.40-bin.jar /usr/share/java/mysql-connector-java.jar

ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar

ambari-server restart

Start the registry service

Thanks,

Sinha

avatar
New Contributor

If the proxy configuration is not working for you, You can download it manually from https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.40.zip on the machine and change the MYSQL_JAR_URL_PATH variable in /usr/hdf/current/registry/bootstrap/bootstrap-storage.sh to local path where file is stored using the file:// format i.e MYSQL_JAR_URL_PATH=file:///root/mysql-connector-java-5.1.40.zip

,

If the proxy configuration is not working for you, You can download it manually from https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.40.zip on the machine and change the MYSQL_JAR_URL_PATH variable in /usr/hdf/current/registry/bootstrap/bootstrap-storage.sh to local path where file is stored using the file:// format i.e MYSQL_JAR_URL_PATH=file:///root/mysql-connector-java-5.1.40.zip.