Schema Registry - Metstore tables Missing.

[#1]

Hi team,

I have followed the below document to configure schema registry using Mysql

https://docs.hortonworks.com/HDPDocuments/HDF3/HDF-3.0.1/bk_installing-hdf/content/database-config-m...

but after configured and started registry i am getting below error in registry UI.

"An exception was thrown while processing request with message: [com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'registry.schema_metadata_info' doesn't exist]"

And when i check the registry database no tables in that.

do we need to create tables manually??? kindly help to close this thread.

MariaDB [(none)]> use registry;
Database changed
MariaDB [registry]> show tables;
Empty set (0.00 sec)
MariaDB [registry]>

[#2]

@slachterman Hi Guru , need your help on this thread

[#3 · Accepted solution]

Hi @Anishkumar Valsalam

I setup a Schema Registry using MySQL as part of another HCC article (https://community.hortonworks.com/content/kbentry/119766/installing-a-local-hortonworks-registry-to-use-wit.html). I believe you need to run the bootstrap script, which will create the necessary tables:

	./bootstrap/bootstrap-storage.sh

[#4]

Thanks for the immediate response.

Using Configuration file: ./../conf/registry.yaml
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: .

is it possible to configure local path? for mysql connector,

[#5]

@Andrew Lim

Thank you so much i have configured with local URL i can able to execute the script and the tables create as expected 🙂