/scm_prepare_database.sh报错 INFO Unable to find JDBC

最新推荐文章于 2023-12-27 11:20:52 发布

原创最新推荐文章于 2023-12-27 11:20:52 发布 · 2.4k 阅读

2 ·

CC 4.0 BY-SA版权

本文详细介绍了在Cloudera SCM中配置MySQL数据库的过程，包括解决找不到JDBC驱动的问题，通过将mysql-connector-java.jar复制到指定目录，成功完成数据库配置。

部署运行你感兴趣的模型镜像

[root@master ~]# sudo /opt/cloudera/cm/schema/scm_prepare_database.sh mysql scm scm
Enter SCM password: 
JAVA_HOME=/usr/java/jdk1.8.0_181-cloudera
Verifying that we can write to /etc/cloudera-scm-server
Creating SCM configuration file in /etc/cloudera-scm-server
Executing:  /usr/java/jdk1.8.0_181-cloudera/bin/java -cp :/opt/cloudera/cm/schema/../lib/* com.cloudera.enterprise.dbutil.DbCommandExecutor /etc/cloudera-scm-server/db.properties com.cloudera.cmf.db.
[                          main] DbCommandExecutor              INFO  Unable to find JDBC driver for database type: MySQL
[                          main] DbCommandExecutor              ERROR JDBC Driver com.mysql.jdbc.Driver not found.
[                          main] DbCommandExecutor              ERROR Exiting with exit code 3

注意看错误信息有个-cp :/opt/cloudera/cm/schema/../lib/*，翻译过来正好对应/opt/cloudera/cm/lib

所以可以这样，cp /usr/share/java/mysql-connector-java.jar /opt/cloudera/cm/lib。把mysql jar包往/opt/cloudera/cm/lib下放一份，再执行一下：

[root@master /]# sudo /opt/cloudera/cm/schema/scm_prepare_database.sh mysql scm scm
Enter SCM password: 
JAVA_HOME=/usr/java/jdk1.8.0_181-cloudera
Verifying that we can write to /etc/cloudera-scm-server
Creating SCM configuration file in /etc/cloudera-scm-server
Executing:  /usr/java/jdk1.8.0_181-cloudera/bin/java -cp :/opt/cloudera/cm/schema/../lib/* com.cloudera.enterprise.dbutil.DbCommandExecutor /etc/cloudera-scm-server/db.properties com.cloudera.cmf.db.
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
[                          main] DbCommandExecutor              INFO  Successfully connected to database.
All done, your SCM database is configured correctly!

总结：

个人觉得应该看启动日志-cp 后面的路径 -cp后面的路径是哪，就把msyql jar包往哪放一份就行。

您可能感兴趣的与本文相关的镜像