windows上安装kafka eable 1.2.6遇到 SQLErrorCodes loaded: [...MySQL...]数据库问题该如何解决
windows上安装kafka eable 1.2.6，启动都正常了，但是登陆时候遇到 SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase, Hana]数据库问题，捣鼓了半天还是没解决，创建对应的表也试过不行，有没有大神知道该如何解决？
安装参考文档：https://www.cnblogs.com/smartloli/p/9371904.html
我安装kafka eagle版本前，核对了kafka和zookeeper都安装并运行正常，由于我在本机localhost搭建的试用版本，因此kafka集群就1个，且为1台broker，并建了几个topic，配置基本差不多：
由于我本地配置的是mysql，因此配置里我改成了如下jdbc：按照安装参考文档，我只是创建了ke数据库，但里面没有表，在运行后，通过http://localhost:8048/ke 登陆界面登陆进去就报了如下错误：
tomcat控制台里也相应出现了如下错误信息
再登陆一遍就会报更详细的错误信息如下：（请问有没有大神知道该如何解决？）
Caused by: org.springframework.jdbc.BadSqlGrammarException:
Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table ‘ke.ke_clusters’ doesn’t exist
The error may exist in org/smartloli/kafka/eagle/web/dao/AlertDao.xml
The error may involve defaultParameterMap
The error occurred while setting parameters
SQL: select * from ke_clusters
Cause: java.sql.SQLSyntaxErrorException: Table ‘ke.ke_clusters’ doesn’t exist
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table ‘ke.ke_clusters’ doesn’t exist
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
at org.mybatis.spring.SqlSessionTemplateProxy12.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:198)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:119)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:63)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)
at com.sun.proxy.Cluster.cluster(AlertQuartz.java:247)
at org.smartloli.kafka.eagle.web.quartz.AlertQuartz.alertJobQuartz(AlertQuartz.java:78)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:269)
at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBeanSqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)
… 18 more
[2018-12-20 13:50:01] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:02] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:03] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:04] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:05] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:16] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:17] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:18] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:19] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:20] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:21] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:21] MBeanQuartz.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - Collector mbean data has error,msg is
Error updating database. Cause: java.sql.SQLSyntaxErrorException: Table ‘ke.ke_metrics’ doesn’t exist
The error may involve org.smartloli.kafka.eagle.web.dao.MBeanDao.insert-Inline
The error occurred while setting parameters
SQL: insert into ke_metrics(cluster,broker,type,key,value,timespan,tm) values (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?)
Cause: java.sql.SQLSyntaxErrorException: Table ‘ke.ke_metrics’ doesn’t exist
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table ‘ke.ke_metrics’ doesn’t exist
[2018-12-20 13:50:21] ZKMetricsUtils.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - Collector tcps has error, msg is Cannot run program “/bin/sh”: CreateProcess error=2, 系统找不到指定的文件。
[2018-12-20 13:50:21] ZKMetricsUtils.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - Collector tcps has error, msg is Cannot run program “/bin/sh”: CreateProcess error=2, 系统找不到指定的文件。
[2018-12-20 13:50:21] ZKMetricsUtils.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - Collector tcps has error, msg is Cannot run program “/bin/sh”: CreateProcess error=2, 系统找不到指定的文件。
[2018-12-20 13:50:21] ZKMetricsUtils.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - Collector tcps has error, msg is Cannot run program “/bin/sh”: CreateProcess error=2, 系统找不到指定的文件。
[2018-12-20 13:50:21] MBeanQuartz.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - Collector zookeeper data has error,msg is
Error updating database. Cause: java.sql.SQLSyntaxErrorException: Table ‘ke.ke_metrics’ doesn’t exist
The error may involve org.smartloli.kafka.eagle.web.dao.MBeanDao.insert-Inline
The error occurred while setting parameters
SQL: insert into ke_metrics(cluster,broker,type,key,value,timespan,tm) values (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?)
Cause: java.sql.SQLSyntaxErrorException: Table ‘ke.ke_metrics’ doesn’t exist
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table ‘ke.ke_metrics’ doesn’t exist
请问有没有大神知道该如何解决？