在正常生产中使用kettle时遇到了一个修改数据库密码之后,kettle不能同步并一直报数据库链接密码错误;刚好能抽出一点时间将具体问题和解决步骤贴出来,供大家借鉴;
具体报错内容如下:
*******************************************************************************
*** Karaf Instance Number: 1 at /usr/software/kettle/./system/karaf/caches/ ***
*** default/data-1 ***
*** Karaf Port:8802 ***
*** OSGI Service Port:9051 ***
*******************************************************************************
11:01:04,364 INFO [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled
Sep 19, 2019 11:01:04 AM org.apache.karaf.main.Main$KarafLockCallback lockAquired
INFO: Lock acquired. Setting startlevel to 100
2019/09/19 11:01:05 - Kitchen - Logging is at level : Basic
2019/09/19 11:01:05 - Kitchen - Start of run.
2019/09/19 11:01:05 - RepositoriesMeta - Reading repositories XML file: /root/.kettle/repositories.xml
Thu Sep 19 11:01:05 CST 2019 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
2019/09/19 11:01:06 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp
Processing stopped because of an error:
Error connecting to the repository!
Error occurred while trying to connect to the database
Error connecting to database: (using class org.gjt.mm.mysql.Driver)
Access denied for user 'root'@'11.2.333.44' (using password: YES)
ERROR: Kitchen can't continue because the job couldn't be loaded.
一、解决方法
1、如果是将kettle链接数据库的密码配置到数据库表中的,要先检查一下数据库表中的密码是否更改;
注:密码文本是经过kettle工具加密
加解密方式请看我的另一篇博文:kettle-数据库密码加密及解密
链接:https://blog.csdn.net/qq_42567801/article/details/100935393*
2、检查服务器中kettle配置文件repositories.xml中的数据库密码是否更改;
注:经常忘了修改这个地方的密码,导致半天找不到问题所在
路径:/root/.kettle/repositories.xml
3、本地连接kettle库查看任务中表操作连接数据库密码是否正确;