• linuxkettle安装部署 2017-10-06 23:29:23
    登陆-linux-(切换到kettle...从上面可以看到,在cognos用户下已经安装了java jdk,版本是1.6.0_20,我们看一下kettle的最低版本要求,编辑查看spoon.bat可以看到 java的版本需求为1.6.0_17,cognos用户下的jdk版本

    登陆-linux-(切换到kettle部署的用户下面)

    第一:产看系统的java环境,cat .bash_profile 文件

    从上面可以看到,在cognos用户下已经安装了java jdk,版本是1.6.0_20,我们看一下kettle的最低版本要求,编辑查看spoon.bat可以看到

    java的版本需求为1.6.0_17,cognos用户下的jdk版本在此之上,说明java环境已经符合。

    第二:上传文件,开始部署

    1. 将data-integration.zip上传到linux服务器(利用SSH将解压过的整个文件夹上传也可以)

    2. 使用unzip命令解压data-integration.zip   unzip data-integration.zip -d "/mnt/kettle"(如果上传的是文件夹,忽略此步骤)

    3.进入解压目录,找到./kitchen.sh

    键入./kitchen.sh,看输入信息

    BASH:/ kitchen.sh的:权限被拒绝

    从上面可以看出kitchen.sh缺少执行权限,我们再次进入看看文件盒文件夹的权限

    从上面可以看出,此目录下面的.sh文件都没有执行权限(X),接下来我们给这个文件夹下面的所有.sh文件赋执行的权限

    由上面的我们可以看出,赋权成功!

    再次./kitchen.sh,回车 看输出信息--

    可以看到上面出现 -rep,-user,-pass 这些kettle中的帮助信息,说明kettle部署成功!

    第三:调出spoon界面

    在windows系统上面是执行spoon.bat 同理在linux系统上面执行spoon.sh调出spoon的界面进行开发。

    执行./spoon.sh,查看信息

    这里说一下,调出spoon界面需要linux客户端支持图形化服务。我们这里采用的是SecureCRT_CN,只支持命令后台。这个时候就需要用tvnviewer,需要在linux服务端装tvnviewer服务端。

    在命令客户端执行:vncserver 打开vnc服务

    从上面的信息可以看出,服务已经启动,我们可以登陆tvnviewer

    登陆成功 --

     

    在终端执行调出spoon界面的命令!执行 xhost +(xhost + 是使所有用户都能访问Xserver.)

    OK ,所有host用户都可以访问图形服务了。

    进入目录,执行spoon.sh

    弹出下面的信息

    解决上面的问题,jdk已经没问题了到网上搜了一下

    http://forums.pentaho.com/archive/index.php/t-93893.html thanks  这位兄弟给出此方法

      从英文的大概可以看出来是需要编辑.kettle目录下的一个文件,于是发现linux上面cognos根目录下没有.kettle文件

      于是从window上面把C:\Users\Administrator\.kettle中的文件.spoonrc.kettle编辑修改

    保存,然后把.kettle整个文件夹赋值到cognos根目录下,查看是否存在(使用 ls -a显示所有对象,因为.XX的对象默认是隐藏的)

    再次执行./spoon.sh

    [cognos@bitic data-integration]$ ./spoon.sh


    /home/cognos/pdi-ce-4.2.0-stable/data-integration
    INFO  11-11 14:56:34,164 - Spoon - Logging goes to file:///tmp/spoon_66d28e63-4a9e-11e3-a301-7b09d1d32e5b.log
    INFO  11-11 14:56:35,641 - Logging to org.slf4j.impl.JCLLoggerAdapter(org.mortbay.log) via org.mortbay.log.Slf4jLog
    INFO  11-11 14:56:35,646 - class org.pentaho.agilebi.platform.JettyServer - WebServer.Log.CreateListener localhost:10000
    INFO  11-11 14:56:35,647 - jetty-6.1.21
    INFO  11-11 14:56:35,703 - NO JSP Support for /pentaho, did not find org.apache.jasper.servlet.JspServlet
    INFO  11-11 14:56:39,221 - Initializing Spring root WebApplicationContext
    INFO  11-11 14:56:39,221 - Root WebApplicationContext: initialization started
    INFO  11-11 14:56:39,242 - Refreshing org.pentaho.platform.web.http.context.PentahoSolutionSpringApplicationContext@e73783: display name [Root WebApplicationContext]; startup date [Mon Nov 11 14:56:39 CST 2013]; root of context hierarchy
    INFO  11-11 14:56:39,271 - Loading XML bean definitions from file [/home/cognos/pdi-ce-4.2.0-stable/data-integration/plugins/spoon/agile-bi/platform/pentaho-solutions/system/pentaho-spring-beans.xml]
    INFO  11-11 14:56:39,285 - Loading XML bean definitions from file [/home/cognos/pdi-ce-4.2.0-stable/data-integration/plugins/spoon/agile-bi/platform/pentaho-solutions/system/pentahoSystemConfig.xml]
    INFO  11-11 14:56:39,298 - Loading XML bean definitions from file [/home/cognos/pdi-ce-4.2.0-stable/data-integration/plugins/spoon/agile-bi/platform/pentaho-solutions/system/adminPlugins.xml]
    INFO  11-11 14:56:39,305 - Loading XML bean definitions from file [/home/cognos/pdi-ce-4.2.0-stable/data-integration/plugins/spoon/agile-bi/platform/pentaho-solutions/system/systemListeners.xml]
    INFO  11-11 14:56:39,310 - Loading XML bean definitions from file [/home/cognos/pdi-ce-4.2.0-stable/data-integration/plugins/spoon/agile-bi/platform/pentaho-solutions/system/sessionStartupActions.xml]
    INFO  11-11 14:56:39,316 - Loading XML bean definitions from file [/home/cognos/pdi-ce-4.2.0-stable/data-integration/plugins/spoon/agile-bi/platform/pentaho-solutions/system/applicationContext-spring-security.xml]
    INFO  11-11 14:56:39,331 - Loading XML bean definitions from file [/home/cognos/pdi-ce-4.2.0-stable/data-integration/plugins/spoon/agile-bi/platform/pentaho-solutions/system/applicationContext-common-authorization.xml]
    INFO  11-11 14:56:39,336 - Loading XML bean definitions from file [/home/cognos/pdi-ce-4.2.0-stable/data-integration/plugins/spoon/agile-bi/platform/pentaho-solutions/system/applicationContext-spring-security-memory.xml]
    INFO  11-11 14:56:39,343 - Loading XML bean definitions from file [/home/cognos/pdi-ce-4.2.0-stable/data-integration/plugins/spoon/agile-bi/platform/pentaho-solutions/system/applicationContext-pentaho-security-memory.xml]
    INFO  11-11 14:56:39,351 - Loading XML bean definitions from file [/home/cognos/pdi-ce-4.2.0-stable/data-integration/plugins/spoon/agile-bi/platform/pentaho-solutions/system/pentahoObjects.spring.xml]
    INFO  11-11 14:56:39,527 - Bean factory for application context [org.pentaho.platform.web.http.context.PentahoSolutionSpringApplicationContext@e73783]: org.springframework.beans.factory.support.DefaultListableBeanFactory@da52a1
    INFO  11-11 14:56:39,607 - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@da52a1: defining beans [systemSettingsService,org.pentaho.platform.engine.core.system.SpringPentahoSystemProxy#0,administrationPluginsList,systemListenersList,sessionStartupActionsList,filterChainProxy,authenticationManager,loggerListener,basicProcessingFilter,basicProcessingFilterEntryPoint,requestParameterProcessingFilter,requestParameterProcessingFilterEntryPoint,pentahoSecurityStartupFilter,anonymousProcessingFilter,anonymousAuthenticationProvider,httpSessionContextIntegrationFilter,logoutFilter,securityContextHolderAwareRequestFilter,httpSessionReuseDetectionFilter,exceptionTranslationFilter,authenticationProcessingFilter,authenticationProcessingFilterEntryPoint,httpRequestAccessDecisionManager,filterInvocationInterceptor,roleVoter,daoAuthenticationProvider,userDetailsService,userMap,userMapFactoryBean,passwordEncoder,userRoleListEnhancedUserMapFactoryBean,inMemoryUserRoleListService,pentahoUserRoleListService,ISolutionEngine,ISolutionRepository,ISolutionRepositoryService,IContentRepository,IAuditEntry,IUITemplater,file,vfs-ftp,contentrepo,IAclPublisher,IAclVoter,IVersionHelper,ICacheManager,IConditionalExecution,IMessageFormatter,IDatasourceService,IPasswordService,IPluginProvider,IPluginManager,IPluginResourceLoader,IMenuProvider,IServiceManager,ITempFileDeleter,gwtServiceManager,IChartBeansGenerator,systemStartupSession,connection-SQL,connection-MDX,connection-XML,connection-HQL,IThemeManager]; root of factory hierarchy
    INFO  11-11 14:56:39,687 - Adding user [org.springframework.security.userdetails.User@c24ef000: Username: suzy; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: Authenticated, User, cto, is]
    INFO  11-11 14:56:39,688 - Adding user [org.springframework.security.userdetails.User@e9f02600: Username: pat; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: Authenticated, User, dev]
    INFO  11-11 14:56:39,688 - Adding user [org.springframework.security.userdetails.User@7ba0e400: Username: joe; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: Admin, Authenticated, User, ceo]
    INFO  11-11 14:56:39,688 - Adding user [org.springframework.security.userdetails.User@6a247400: Username: tiffany; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: Authenticated, User, dev, devmgr]
    INFO  11-11 14:56:39,745 - Validated configuration attributes
    INFO  11-11 14:56:39,749 - Adding user [org.springframework.security.userdetails.User@c24ef000: Username: suzy; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: Authenticated, User, cto, is]
    INFO  11-11 14:56:39,749 - Adding user [org.springframework.security.userdetails.User@e9f02600: Username: pat; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: Authenticated, User, dev]
    INFO  11-11 14:56:39,749 - Adding user [org.springframework.security.userdetails.User@7ba0e400: Username: joe; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: Admin, Authenticated, User, ceo]
    INFO  11-11 14:56:39,749 - Adding user [org.springframework.security.userdetails.User@6a247400: Username: tiffany; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: Authenticated, User, dev, devmgr]
    INFO  11-11 14:56:39,761 - Root WebApplicationContext: initialization completed in 539 ms
    INFO  11-11 14:56:39,778 - misc-org.pentaho.platform.engine.core.system.PentahoSystem: Could not detemine implementor for IRuntimeRepository
    INFO  11-11 14:56:39,778 - misc-org.pentaho.platform.engine.core.system.PentahoSystem: Could not detemine implementor for ISubscriptionScheduler
    INFO  11-11 14:56:39,778 - misc-org.pentaho.platform.engine.core.system.PentahoSystem: Could not detemine implementor for ISubscriptionRepository
    INFO  11-11 14:56:39,778 - misc-org.pentaho.platform.engine.core.system.PentahoSystem: Could not detemine implementor for IUserFilesComponent
    INFO  11-11 14:56:39,778 - misc-org.pentaho.platform.engine.core.system.PentahoSystem: Could not detemine implementor for IBackgroundExecution
    INFO  11-11 14:56:39,778 - misc-org.pentaho.platform.engine.core.system.PentahoSystem: Could not detemine implementor for IScheduler
    INFO  11-11 14:56:39,778 - misc-org.pentaho.platform.engine.core.system.PentahoSystem: Could not detemine implementor for INavigationComponent
    INFO  11-11 14:56:39,778 - misc-org.pentaho.platform.engine.core.system.PentahoSystem: Could not detemine implementor for IUserSettingService
    INFO  11-11 14:56:39,810 - Mondrian: properties loaded from 'file:/home/cognos/pdi-ce-4.2.0-stable/data-integration/libext/mondrian/config/mondrian.properties'
    INFO  11-11 14:56:39,810 - Mondrian: loaded 0 system properties
    INFO  11-11 14:56:39,884 - Refreshing com.pentaho.analyzer.content.px@106e02e: display name [com.pentaho.analyzer.content.px@106e02e]; startup date [Mon Nov 11 14:56:39 CST 2013]; root of context hierarchy
    INFO  11-11 14:56:39,885 - Loading XML bean definitions from class path resource [beans.xml]
    INFO  11-11 14:56:39,921 - Bean factory for application context [com.pentaho.analyzer.content.px@106e02e]: org.springframework.beans.factory.support.DefaultListableBeanFactory@f67d81
    INFO  11-11 14:56:39,940 - Loading properties file from file [/home/cognos/pdi-ce-4.2.0-stable/data-integration/plugins/spoon/agile-bi/platform/pentaho-solutions/system/analyzer/analyzer.properties]
    INFO  11-11 14:56:39,944 - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@f67d81: defining beans [propertyConfigurer,properties,analysisAreaManager,olapMetaDataManager,olapConnectionManager,reportManager,reportRequestService,usageTracker,localizationService,CVAppContext]; root of factory hierarchy
    INFO  11-11 14:56:39,948 - Loading properties file from file [/home/cognos/pdi-ce-4.2.0-stable/data-integration/plugins/spoon/agile-bi/platform/pentaho-solutions/system/analyzer/analyzer.properties]
    Pentaho BI Platform server is ready. (Pentaho Platform Engine Core 3.9.0-stable.47240) Fully Qualified Server Url = http://localhost:8080/pentaho/, Solution Path = /home/cognos/pdi-ce-4.2.0-stable/data-integration/plugins/spoon/agile-bi/platform/pentaho-solutions
    INFO  11-11 14:56:40,048 - Started SocketConnector@localhost:10000
    INFO  11-11 14:56:40,054 - Refreshing org.springframework.context.support.FileSystemXmlApplicationContext@bf1a4a: display name [org.springframework.context.support.FileSystemXmlApplicationContext@bf1a4a]; startup date [Mon Nov 11 14:56:40 CST 2013]; root of context hierarchy
    INFO  11-11 14:56:40,054 - Loading XML bean definitions from file [/home/cognos/pdi-ce-4.2.0-stable/data-integration/plugins/spoon/agile-bi/visualizations/prpt/plugin.xml]
    INFO  11-11 14:56:40,070 - Bean factory for application context [org.springframework.context.support.FileSystemXmlApplicationContext@bf1a4a]: org.springframework.beans.factory.support.DefaultListableBeanFactory@9e4dc0
    INFO  11-11 14:56:40,071 - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@9e4dc0: defining beans [visualizationBean]; root of factory hierarchy
    INFO  11-11 14:56:40,079 - Refreshing org.springframework.context.support.FileSystemXmlApplicationContext@7348e: display name [org.springframework.context.support.FileSystemXmlApplicationContext@7348e]; startup date [Mon Nov 11 14:56:40 CST 2013]; root of context hierarchy
    INFO  11-11 14:56:40,080 - Loading XML bean definitions from file [/home/cognos/pdi-ce-4.2.0-stable/data-integration/plugins/spoon/agile-bi/visualizations/report-wizard/plugin.xml]
    INFO  11-11 14:56:40,094 - Bean factory for application context [org.springframework.context.support.FileSystemXmlApplicationContext@7348e]: org.springframework.beans.factory.support.DefaultListableBeanFactory@ffb35e
    INFO  11-11 14:56:40,095 - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@ffb35e: defining beans [visualizationBean]; root of factory hierarchy
    INFO  11-11 14:56:40,097 - Refreshing org.springframework.context.support.FileSystemXmlApplicationContext@153c9c7: display name [org.springframework.context.support.FileSystemXmlApplicationContext@153c9c7]; startup date [Mon Nov 11 14:56:40 CST 2013]; root of context hierarchy
    INFO  11-11 14:56:40,098 - Loading XML bean definitions from file [/home/cognos/pdi-ce-4.2.0-stable/data-integration/plugins/spoon/agile-bi/visualizations/analyzer/plugin.xml]
    INFO  11-11 14:56:40,123 - Bean factory for application context [org.springframework.context.support.FileSystemXmlApplicationContext@153c9c7]: org.springframework.beans.factory.support.DefaultListableBeanFactory@3eeab3
    INFO  11-11 14:56:40,125 - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@3eeab3: defining beans [visualizationBean]; root of factory hierarchy
    INFO  11-11 14:56:40,224 - Spoon - Asking for repository
    INFO  11-11 14:56:40,347 - RepositoriesMeta - Reading repositories XML file: /home/cognos/.kettle/repositories.xml
    INFO  11-11 14:56:41,118 - Version checker - OK

    --------------------------------------------出现上面的加载信息,图形界面成功调出------------------------------------------------------------------------------

    展开全文
  • kettlelinux环境中打开图形界面 kettle数据转换的时候需要图形界面 如果所在的linux环境中没有安装图形界面 可以在本机安装xshell 配置一个全局变量 ip是自己的本地ip DISPLAY=192.168.180.48:0.0 export DISPLAY...
  • KettleLinux安装使用 2020-06-24 16:33:46
    KettleLinux安装使用,很珍貴哦,需要金币下载,啦啦啦
  • 安装问题 1. 将文件上传至linux系统内(本人使用的是Xftp软件) 或直接下载 2.将压缩文件解压:unzip pdi-ce-7.0.0.0.1-stable.zip 3.进入data-integration文件夹 对spoon.sh问价进行赋值 chmod +spoon.sh 4....
  • kettle是一款纯java编写的开源ETL工具,需要jdk环境支持,下载jdk-6u45-linux-i586.bin到/root/Desktop,建立jdk安装目录 #mkdir /usr/java #cp /root/Desktop/jdk-6u45-linux-i586.bin /usr/java/ #cd /usr/java...
  • linux服务器下kettle安装 2019-08-14 17:45:22
    kettle为啥往服务器放? 在windows本地玩的再嗨,终究要面对生产环境~
  • kettlelinux状态下调用的脚本文件,自动化,一键运行,便于实施。
  • kettle6.0linux安装配置 2015-10-24 20:13:49
    kettle部署分为kettle server部署和客户端的kettle client部署,二者安装包完全一致,除因为不同操作系统执行相对应的脚本文件外(linux执行shell文件,windows执行bat文件),其它配置基本一致。 kettle版本:6.0,...
  • 2.4 Linux安装使用 2.4.1 单机 1)jdk安装 2)安装包上传到服务器,解压 注意:1. 把mysql驱动拷贝到lib目录下 2. 将本地用户家目录下的隐藏目录C:\Users\自己用户名\.kettle,整个上传到linux的家目录/home/...
  • 1、环境 测试环境 ip 180.200.2.36 Linux 版本 2.6.18-274.el5 数据库环境 oracle11g 必须先安装好JDK JDK...
  • kettlelinux上运行 2019-10-18 14:57:22
    1.在windows系统上用kettle生成转换和作业,运行成功之后可以放到linux上运行 注意:一定确保在Windows上是能正确运行的 2.找到kettle生成的转换文档,传入到linux系统中用pan.sh运行测试能否成功 cd data-...
  • 这章就开始讲下Kettlelinux环境下的安装部署,和其中遇到的一些坑。 安装部署 因为Kettle不需要编译和安装,直接把包传到服务器然后解压缩就可以了。(因为我用的kettle版本是8.2,所以环境依赖jdk1.8) [root@...
  • kettle安装部署 -- linux 2020-02-24 11:52:00
    kettle安装部署 – linux kettle安装 1、打开浏览器,百度输入kettle官网,默认搜索第一个就是官网网址 2、点击进入后,官网首页面如下所示 官网提示的安装步骤 CentOS 6桌面: 需要安装libwebkitgtk软件包。这...
  • Linux环境部署kettle 2018-08-08 23:22:58
    本博客主要是记录了鄙人第一次在Linux环境部署kettle的经历,以及其中遇到的部分问题,不一定很全面,仅供参考交流 博客内容主要分为:JDK安装kettle安装安装JDK与kettle可能遇到的问题、以及定时执行job等 一...
  • Linux环境下安装Kettle软件 2020-03-27 14:57:16
    博文目录Linux安装Kettle1. 介绍1.1. 目的1.2. 范围2. 安装准备2.1. 用户规划2.2. 目录规划2.3. 安装包准备2.4. 环境变量配置3. 开始安装4. 安装检查 Linux安装Kettle 1. 介绍 1.1. 目的 此文档为环境 ETL ...
  • 关于linux安装kettle的总结 2019-05-22 18:09:57
    1.1 JDK安装配置 命令行键入“cd /etc”进入etc目录 命令行键入“vi profile”打开profile文件 敲击键盘ctrl+F到文件末尾 在末尾处,即第一个~的地方,敲击键盘将以下内容输入到文件 export JAVA_HOME=/...
  • Kettle部署到linux 2019-03-29 11:27:41
    Kettle部署到linux系统 准备工作 安装JDK;(略) 准备.kjb或.ktr转换文件。(以CRM角色用户同步知识库为例)文件夹WORK\CRMKNOW\*. 准备pdi-ce-6.1.0.1-196.tar.gz文件(Kettle文件)。 安装步骤 复制pdi-ce-...
  • linux部署 kettle (图文步骤,超详细)
1 2 3 4 5 ... 20
收藏数 3,744
精华内容 1,497