question Re: Registry Schema failing right after starton HDF3.3 in Support Questions

question Re: Registry Schema failing right after starton HDF3.3 in Support Questions https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/236263#M198076 <P>Ok i was able to start shcema_registry manually by first including the mysql conenctor jar in the classpath variable:</P><P>export CLASSPATH=/usr/share/java/mysql-connector-java.jar:$CLASSPATH</P><P><BR /></P><P>To make this persistent you can enter the abo command in the "registry-env template" under the advanced config of the schema_registry service in ambari.</P><P><BR /></P><P>It would be nice to figure out and fix why this variable does not get set automatically. </P> Thu, 28 Mar 2019 01:14:05 GMT shqiperih 2019-03-28T01:14:05Z Registry Schema failing right after starton HDF3.3 https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/236260#M198073 <P>I have installed a an HDF v3.3 cluster. everything seems to be working fine except Schema Registry which starts fine but then shuts down immediately giving the following errors:</P><P><BR /></P><P>The mysql drivers have been loaded fine in ambari and work for all other modules.</P><P><BR /></P><PRE> </PRE><P>java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141)</P><P> at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)</P><P> at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)</P><P> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66)</P><P> at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)</P><P> at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)</P><P> at io.dropwizard.cli.Cli.run(Cli.java:75)</P><P> at io.dropwizard.Application.run(Application.java:93)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297)</P><P>Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)</P><P> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126)</P><P> ... 18 more</P><P>java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141)</P><P> at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)</P><P> at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)</P><P> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66)</P><P> at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)</P><P> at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)</P><P> at io.dropwizard.cli.Cli.run(Cli.java:75)</P><P> at io.dropwizard.Application.run(Application.java:93)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297)</P><P>Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)</P><P> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126)</P><P> ... 18 more</P><P>java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141)</P><P> at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)</P><P> at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)</P><P> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66)</P><P> at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)</P><P> at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)</P><P> at io.dropwizard.cli.Cli.run(Cli.java:75)</P><P> at io.dropwizard.Application.run(Application.java:93)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297)</P><P>Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)</P><P> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126)</P><P> ... 18 more</P><P>java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141)</P><P> at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)</P><P> at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)</P><P> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66)</P><P> at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)</P><P> at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)</P><P> at io.dropwizard.cli.Cli.run(Cli.java:75)</P><P> at io.dropwizard.Application.run(Application.java:93)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297)</P><P>Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)</P><P> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126)</P><P> ... 18 more</P><P>java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141)</P><P> at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)</P><P> at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)</P><P> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66)</P><P> at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)</P><P> at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)</P><P> at io.dropwizard.cli.Cli.run(Cli.java:75)</P><P> at io.dropwizard.Application.run(Application.java:93)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297)</P><P>Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)</P><P> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126)</P><P> ... 18 more</P><P>java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141)</P><P> at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)</P><P> at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)</P><P> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66)</P><P> at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)</P><P> at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)</P><P> at io.dropwizard.cli.Cli.run(Cli.java:75)</P><P> at io.dropwizard.Application.run(Application.java:93)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297)</P><P>Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)</P><P> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126)</P><P> ... 18 more</P><P>java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141)</P><P> at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)</P><P> at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)</P><P> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66)</P><P> at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)</P><P> at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)</P><P> at io.dropwizard.cli.Cli.run(Cli.java:75)</P><P> at io.dropwizard.Application.run(Application.java:93)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297)</P><P>Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)</P><P> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126)</P><P> ... 18 more</P><P>Any ideas?</P><P>I</P> Tue, 21 Apr 2026 11:38:02 GMT https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/236260#M198073 shqiperih 2026-04-21T11:38:02Z Re: Registry Schema failing right after starton HDF3.3 https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/236261#M198074 <P><A rel="noopener noreferrer noopener noreferrer noopener noreferrer noopener noreferrer" href="http://lorenc%20hysi/" target="_blank"><EM>@Lorenc Hysi</EM></A><EM> </EM></P><P><EM>Looks like you back end database could be the cause.</EM></P><PRE><EM>################################################# </EM> <EM># Create  Schema Registry and SAM metastore: </EM> <EM>################################################## </EM> <EM>mysql -u root -p{root_password} create database registry; </EM> <EM>create database streamline; CREATE USER 'registry'@'%' IDENTIFIED BY 'registry'; </EM> <EM>CREATE USER 'streamline'@'%' IDENTIFIED BY 'streamline'; </EM> <EM>GRANT ALL PRIVILEGES ON registry.* TO 'registry'@'%' WITH GRANT OPTION ; </EM> <EM>GRANT ALL PRIVILEGES ON streamline.* TO 'streamline'@'%' WITH GRANT OPTION ; </EM> <EM>commit; </EM> <EM>exit; </EM> <EM>################################################# </EM> <EM># Test connection  </EM> <EM>################################################## </EM> <EM>mysql -u streamline -pstreamline;</EM> <EM>mysql -u registry -pregistry;</EM></PRE><P><EM><BR /></EM></P><P><EM>The above should succeed</EM></P><P><EM>It doesn't cost you a thing rerun the below to redeploy the jdbc jars</EM></P><PRE><EM>ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar           </EM></PRE> Fri, 22 Mar 2019 05:02:37 GMT https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/236261#M198074 Shelton 2019-03-22T05:02:37Z Re: Registry Schema failing right after starton HDF3.3 https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/236262#M198075 <P>I did all the steps above but still the same errors persists and i cannot start schema registry. I even moved the schema registry to the same server as the database but still issues. </P><P>I also tried to pick the option to let ambari create the user and database for registry during install. Ambari is able to create the user and database, but the issue still persists. </P><P><BR /></P><P>Is there any other way to force shcema registry to recognize the com.mysql.jdbc.jdbc2.optional.MysqlDataSource jar? This to me looks more like an issue with variables not being properly passed but i am not sure.</P> Thu, 28 Mar 2019 00:53:39 GMT https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/236262#M198075 shqiperih 2019-03-28T00:53:39Z Re: Registry Schema failing right after starton HDF3.3 https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/236263#M198076 <P>Ok i was able to start shcema_registry manually by first including the mysql conenctor jar in the classpath variable:</P><P>export CLASSPATH=/usr/share/java/mysql-connector-java.jar:$CLASSPATH</P><P><BR /></P><P>To make this persistent you can enter the abo command in the "registry-env template" under the advanced config of the schema_registry service in ambari.</P><P><BR /></P><P>It would be nice to figure out and fix why this variable does not get set automatically. </P> Thu, 28 Mar 2019 01:14:05 GMT https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/236263#M198076 shqiperih 2019-03-28T01:14:05Z Re: Registry Schema failing right after starton HDF3.3 https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/304059#M221860 <P>From what I've investigated, it may be due to the version of the mysql-connector-java.</P><P>The class com.mysql.jdbc.jdbc2.optional.MysqlDataSource is present in version 5 and the one that I have installed is the 8.</P><P>I tried installing explicitly the version 5 but I got different errors.</P><P>What I've done and got it working is changing that class to the one available in version 8, which is com.mysql.cj.jdbc.MysqlXADataSource.</P><P> </P><P>For Schema Registry you have to modify 2 files:</P><UL><LI>/var/lib/ambari-server/resources/mpacks/hdf-ambari-mpack-3.4.1.1-4/common-services/REGISTRY/0.3.0/package/scripts/params.py</LI><LI>/var/lib/ambari-agent/cache/common-services/REGISTRY/0.3.0/package/scripts/params.py</LI></UL><P>There change the variable registry_storage_java_class to the value com.mysql.cj.jdbc.MysqlXADataSource</P><P>Note: the variable should appear twice.</P><P> </P><P>The same for Streaming Analytics, you have to modify 2 files. This time:</P><UL><LI>/var/lib/ambari-server/resources/mpacks/hdf-ambari-mpack-3.4.1.1-4/common-services/STREAMLINE/0.5.0/package/scripts/params.py</LI><LI>/var/lib/ambari-agent/cache/common-services/STREAMLINE/0.5.0/package/scripts/params.py</LI></UL><P>There change the variable streamline_storage_java_class also to the value com.mysql.cj.jdbc.MysqlXADataSource</P><P> </P><P>You should then be able to start the services.</P><P>I just solved this, so I'm not aware if any other errors will show up by using these services.</P> Thu, 08 Oct 2020 06:00:14 GMT https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/304059#M221860 pboffino 2020-10-08T06:00:14Z