英文:
centos8 install azkaban Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'
问题
环境:
CentOS 8
MySQL 版本 8.0.17
Java 版本 "1.8.0_261"
Azkaban 版本 v3.90.0
当我尝试安装 Azkaban Executor 服务器时：
cd /home/azkaban/azkaban/azkaban-exec-server/build/distributions
tar -xzvf azkaban-exec-server-3.91.0-4-gb468bffe.tar.gz
cd /home/azkaban/azkaban/azkaban-exec-server/build/distributions/azkaban-exec-server-3.91.0-4-gb468bffe/conf
cp azkaban.properties azkaban.properties_bak20200724
vi azkaban.properties
mysql.database=azkaban
mysql.user=azkaban
mysql.password=azkabanpassword
然后运行：
cd /home/azkaban/azkaban/azkaban-exec-server/build/distributions/azkaban-exec-server-3.91.0-4-gb468bffe
./bin/start-exec.sh
在 executorServerLog__2020-07-24+17:59:49.out 中：
ERROR [MySQLDataSource] [main] [Azkaban] 无法找到可写的数据库连接。等待 15 秒后重试。尝试次数 = 2
java.sql.SQLException: 无法创建 PoolableConnectionFactory（无法连接到数据库服务器。）
因此，我下载了 mysql-connector-java-8.0.17.jar 并将此 jar 放入 '/home/azkaban/azkaban/azkaban-exec-server/build/distributions/azkaban-exec-server-3.91.0-4-gb468bffe/lib' 文件夹中。
当我再次尝试启动时，仍然失败：
ERROR [StdOutErrRedirect] [main] [Azkaban] 正在加载类 'com.mysql.jdbc.Driver'。
这是不推荐的。新的驱动程序类是 'com.mysql.cj.jdbc.Driver'。
该驱动程序会通过 SPI 自动注册，通常不需要手动加载驱动程序类。
有人可以帮忙吗？
英文:
environment:<br> CentOS8<br> mysql Ver 8.0.17<br> java version "1.8.0_261"<br> azkaban v3.90.0.</br>
when I try to installing Azkaban Executor Server
cd /home/azkaban/azkaban/azkaban-exec-server/build/distributions
tar -xzvf azkaban-exec-server-3.91.0-4-gb468bffe.tar.gz
cd /home/azkaban/azkaban/azkaban-exec-server/build/distributions/azkaban-exec-server-3.91.0-4-gb468bffe/conf
cp azkaban.properties azkaban.properties_bak20200724
vi azkaban.properties
mysql.database=azkaban
mysql.user=azkaban
mysql.password=azkabanpassword
Then run:
cd /home/azkaban/azkaban/azkaban-exec-server/build/distributions/azkaban-exec-server-3.91.0-4-gb468bffe
./bin/start-exec.sh
in executorServerLog__2020-07-24+17:59:49.out
ERROR [MySQLDataSource] [main] [Azkaban] Failed to find write-enabled DB connection. Wait 15 seconds and retry. No.Attempt = 2
java.sql.SQLException: Cannot create PoolableConnectionFactory (Could not create connection to database server.)
So I download mysql-connector-java-8.0.17.jar and put this jar into '/home/azkaban/azkaban/azkaban-exec-server/build/distributions/azkaban-exec-server-3.91.0-4-gb468bffe/lib' </br>
when I try to start again,also fails:
ERROR [StdOutErrRedirect] [main] [Azkaban] 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.
Anyone can help?
答案1
得分: 0
降级MySQL从8.0.17到MySQL 5.7.31解决此问题。
英文:
downgrade mysql from 8.0.17 to mysql5.7.31 resolve it.
答案2
得分: 0
将代码中第51行的com.mysql.jdbc.Driver替换为：
com.mysql.cj.jdbc.Driver
重新构建
英文:
Replace the Code:
com.mysql.jdbc.Driver in the 51th row of code
azkaban/akaban-db/src/main/java/azkaban/db/MySQLDataSource.java
to
com.mysql.cj.jdbc.Driver
Rebuild
专注分享java语言的经验与见解，让所有开发者获益！
评论