Q:kettle手动连接数据库时,能连接成功!但是到连接资源库时就连接不上,报:“You don't seem to be getting a connection to the server. Please check the pa……” 如图
A:问题原因在于:你所要连的数据库里面少了R_USER这张表! 用命令行或其他工具进入数据库,并创建R_USER这张表,并插入数据
INSERT INTO R_USER(ID_USER, LOGIN, PASSWORD, NAME, DESCRIPTION, ENABLED) VALUES (1,'admin','2be98afc86aa7f2e4cb79ce71da9fa6d4','Administrator','User manager',1);
INSERT INTO R_USER(ID_USER, LOGIN, PASSWORD, NAME, DESCRIPTION, ENABLED) VALUES (2,'guest','2be98afc86aa7f2e4cb79ce77cb97bcce','Guest account','Read-only guest account',1);
,再连接资源库用admin/admin或guest/guest登陆即可。