消息关闭
    暂无新消息!
使用Kettle6读取数据库数据库报 "#28000ip not in whitelist"错误,但是自己写的JDBC程序居然可以正常链接。
下面是部分错误日志:
Error connecting to database: (using class org.gjt.mm.mysql.Driver)
2017/06/19 15:53:08 - tss_t_rfd_trade_order_ext_exp_info.0 - Invalid authorization specification,  message from server: "#28000ip not in whitelist"
2017/06/19 15:53:08 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp
2017/06/19 15:53:08 - pay_tss_pay_method_exp_log.0 - ERROR (version 6.0.1.0-386, build 1 from 2015-12-03 11.37.25 by buildguy) : An error occurred intialising this step:
2017/06/19 15:53:08 - pay_tss_pay_method_exp_log.0 - Error occurred while trying to connect to the database

ERROR (version 6.0.1.0-386, build 1 from 2015-12-03 11.37.25 by buildguy) : Unexpected error rolling back the database connection.
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 - ERROR (version 6.0.1.0-386, build 1 from 2015-12-03 11.37.25 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 - Unable to get database metadata from this database connection
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at org.pentaho.commons.launcher.Launcher.main (Launcher.java:92)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at java.lang.reflect.Method.invoke (Method.java:498)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:43)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:62)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at sun.reflect.NativeMethodAccessorImpl.invoke0 (NativeMethodAccessorImpl.java:-2)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at org.pentaho.di.pan.Pan.main (Pan.java:501)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at org.pentaho.di.trans.Trans.execute (Trans.java:613)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at org.pentaho.di.trans.Trans.prepareExecution (Trans.java:1126)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose (TableOutput.java:610)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at org.pentaho.di.core.database.Database.rollback (Database.java:825)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at org.pentaho.di.core.database.Database.rollback (Database.java:833)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at org.pentaho.di.core.database.Database.getDatabaseMetaData (Database.java:2738)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:2740)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at org.pentaho.di.core.database.Database.rollback(Database.java:833)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at org.pentaho.di.core.database.Database.rollback(Database.java:825)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:610)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:1126)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at org.pentaho.di.trans.Trans.execute(Trans.java:613)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at org.pentaho.di.pan.Pan.main(Pan.java:501)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at java.lang.reflect.Method.invoke(Method.java:498)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 - Caused by: java.lang.NullPointerException
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:2738)
2017/06/19 15:53:09 - pay_trade_order_exp_log.0 -  ... 11 more

0个回答

暂无回答!