Fang Jin The mysql connection I configured in schedulis-exec/web with azkaban.properties is as follows database.type=mysql mysql.port=3306 mysql.host=my_ip mysql.database=schedulis mysql.user=root mysql.password=pwd mysql.numconnections=100 And command line execution # mysql -uroot -ppwd -hmy_ip ........ mysql> It's OK But bin/start-exec.sh keeps reporting MySQL connection failure: 2023-01-08 22:54:07.038 INFO [main] org.eclipse.jetty.server.Server 400 doStart - Started @2983ms 2023-01-08 22:54:11.260 ERROR [main] azkaban.db.MySQLDataSource 111 getConnection - Failed to find write-enabled DB connection. Wait 15 seconds and retry. No.Attempt = 1 java.sql.SQLException: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2294) ~[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039) ~[commons-dbcp2-2.1.1.jar:2.1.1] at azkaban.db.MySQLDataSource.getConnection(MySQLDataSource.java:84) [azkaban-db-0.7.1.jar:?] at org.apache.commons.dbutils.AbstractQueryRunner.prepareConnection(AbstractQueryRunner.java:175) [commons-dbutils-1.5.jar:1.5] at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:286) [commons-dbutils-1.5.jar:1.5] at azkaban.db.DatabaseOperator.query(DatabaseOperator.java:70) [azkaban-db-0.7.1.jar:?] at azkaban.executor.ExecutorDao.fetchExecutor(ExecutorDao.java:64) [azkaban-common-0.7.1.jar:?] at azkaban.executor.JdbcExecutorLoader.fetchExecutor(JdbcExecutorLoader.java:379) [azkaban-common-0.7.1.jar:?] at azkaban.execapp.AzkabanExecutorServer.insertExecutorEntryIntoDB(AzkabanExecutorServer.java:310) [azkaban-exec-server-0.7.1.jar:?] at azkaban.execapp.AzkabanExecutorServer.start(AzkabanExecutorServer.java:288) [azkaban-exec-server-0.7.1.jar:?] at azkaban.execapp.AzkabanExecutorServer.launch(AzkabanExecutorServer.java:182) [azkaban-exec-server-0.7.1.jar:?] at azkaban.execapp.AzkabanExecutorServer.main(Azkaban
Zhang Huajin The password is to be encrypted. Please refer to the installation documentation Fang Jin Sure enough, thanks a lot Fang Jin 我在schedulis-exec/web中的azkaban.properties配置的mysql连接如下 database.type=mysql mysql.port=3306 mysql.host=my_ip mysql.database=schedulis mysql.user=root mysql.password=pwd mysql.numconnections=100 而且命令行执行 # mysql -uroot -ppwd -hmy_ip ........ mysql> 是可以的， 但启动 bin/start-exec.sh 一直报MySQL连接失败： 2023-01-08 22:54:07.038 INFO [main] org.eclipse.jetty.server.Server 400 doStart - Started @2983ms 2023-01-08 22:54:11.260 ERROR [main] azkaban.db.MySQLDataSource 111 getConnection - Failed to find write-enabled DB connection. Wait 15 seconds and retry. No.Attempt = 1 java.sql.SQLException: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2294) ~[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039) ~[commons-dbcp2-2.1.1.jar:2.1.1] at azkaban.db.MySQLDataSource.getConnection(MySQLDataSource.java:84) [azkaban-db-0.7.1.jar:?] at org.apache.commons.dbutils.AbstractQueryRunner.prepareConnection(AbstractQueryRunner.java:175) [commons-dbutils-1.5.jar:1.5] at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:286) [commons-dbutils-1.5.jar:1.5] at azkaban.db.DatabaseOperator.query(DatabaseOperator.java:70) [azkaban-db-0.7.1.jar:?] at azkaban.executor.ExecutorDao.fetchExecutor(ExecutorDao.java:64) [azkaban-common-0.7.1.jar:?] at azkaban.executor.JdbcExecutorLoader.fetchExecutor(JdbcExecutorLoader.java:379) [azkaban-common-0.7.1.jar:?] at azkaban.execapp.AzkabanExecutorServer.insertExecutorEntryIntoDB(AzkabanExecutorServer.java:310) [azkaban-exec-server-0.7.1.jar:?] at azkaban.execapp.AzkabanExecutorServer.start(AzkabanExecutorServer.java:288) [azkaban-exec-server-0.7.1.jar:?] at azkaban.execapp.AzkabanExecutorServer.launch(AzkabanExecutorServer.java:182) [azkaban-exec-server-0.7.1.jar:?] at azkaban.execapp.AzkabanExecutorServer.main(Azkaban Zhang Huajin 密码是要加密的 请注意查阅安装文档 Fang Jin 果然，多谢多谢
