Linux Deployment Kettle__linux

Reprint Source: http://www.cnblogs.com/wxjnew/p/3417942.html

Since the server is a Linux system, but the feeling of Linux graphics is not strong, so from contact with the kettle has been operating in the Windows system ETL design and processing. Now you need to look in Linux to see if the kettle repository is connected properly, and to schedule the kettle job on Linux, you need to configure the kettle environment on Linux.

Login-linux-(switch to the Kettle deployment user below)

First: Production view of the system's Java environment, cat. bash_profile file

As you can see from the above, the Java JDK has been installed under the Cognos user, the version is 1.6.0_20, we look at the minimum version of Kettle requirements, edit view Spoon.bat can see

The Java version needs to be a JDK version of the 1.6.0_17,cognos user, stating that the Java environment is compliant.

Second: Upload files, start deployment

1. Upload the data-integration.zip to the Linux server (use SSH to upload the entire folder you unzipped)

2. Use the unzip command to extract Data-integration.zip unzip data-integration.zip-d "/mnt/kettle" (if uploaded is a folder, ignore this step)

3. Into the decompression directory, find./kitchen.sh

Type./kitchen.sh, look at the input information

bash:/kitchen.sh: Permission denied

From the above you can see kitchen.sh lack of execution permissions, we go back to see the File box folder permissions

As you can see from the above, the. sh file under this directory does not have Execute permission (X), and next we assign permission to all. sh files under this folder.

As we can see from the above, empowerment is successful.

Again./kitchen.sh, return to see output information--

You can see the help information in these kettle that appears above, which indicates kettle deployment was successful-rep,-user,-pass.

Third: Pull up the Spoon interface

On the Windows system above is the implementation of Spoon.bat the same reason on the Linux system to perform spoon.sh pull up spoon interface for development.

Execute./spoon.sh, View information

Here, the Spoon interface requires that the Linux client support graphical services. We use the SECURECRT_CN here, only the command background is supported. This time you need to use tvnviewer, you need to install the Tvnviewer server on the Linux service side.

Executing on command client: Vncserver Open VNC Service

From the above information can be seen, the service has been started, we can login Tvnviewer

Landing Success--

Perform a command to pull up the spoon interface at the terminal. Execute Xhost + (Xhost + is to enable all users to access Xserver.)

OK, the graphics service is accessible to all host users.

Enter directory, execute spoon.sh

The following information pops up

To solve the problem above, the JDK is no longer a problem to search the Internet

Http://forums.pentaho.com/archive/index.php/t-93893.html the brother gave this method

From the English can be seen is the need to edit the. Kettle directory of a file, and found Linux above the Cognos root directory does not have the. Kettle file

So from the window above the C:\Users\Administrator\.kettle file. Spoonrc.kettle Edit Modify

Save, and then put. Kettle the entire folder to the Cognos root directory to see if it exists (use Ls-a to display all objects, because.) The object of XX is hidden by default)

Execute again./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 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/plug Ins/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/plug Ins/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/plug Ins/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/plug Ins/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/plug Ins/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/plug Ins/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/plug Ins/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/plug Ins/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/plug Ins/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/plug Ins/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 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.springfram Ework.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 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/plug Ins/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 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/plug Ins/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 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/plug Ins/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

--------------------------------------------The above loading information appears, The graphical interface was successfully paged out------------------------------------------------------------------------------

Summary: As for the Solution Showwelcomepageonstartup=n Welcome page can be loaded at the site design page, do not know is the above reasons, at this time we click on the Spoon interface to show the Welcome interface will appear the same error, which the great God saw, Welcome message Popular Science.