Pentaho Tools :

Pentaho C-Tools(CDE,CDF,CDA),Pentaho CE & EE Server,OLAP-Cubes,Analysis using Pivot4J, Saiku Analytics, Saiku Reporting, Ad-hoc Reporting using Interactive Reporting Tool,Dashboards,Reports using PRD, PDD,Data Integration using Kettle ETL,Data Mining usign WEKA,Integration of Servers with Databases,Mobile/iPad compatible Dashboards using Bootstrap Css,Drilldown dashboards,Interactive Dashboards

Monday, 7 April 2014

Pentaho C-Tools stable or trunk Manual Installation using ctools-installer.sh in Cent OS OR in any Linux server

Hi Guys,

If your network is bounded by proxy settings .. you can not able to connect to Pentaho Market place from the BI Server.
As an alternative you can download and install all the C-Tools using a simple command.

The procedure to install C-Tools manually is given below.

1) Click on below link to download the C-Tools installer https://github.com/pmalves/ctools-installer
2) At the bottom right corner you can find Download Zip file.
3) Once you download the zip file unzip it using unzip command.
   Eg : unzip ctools-installer-master.zip ( You will find ctools-installer-master folder once unzip done).
4) Now, Open your terminal to run the script file ( I always prefer to run the .sh files from command prompt)
5) From the terminal run the below command.


[a1551@localhost ctools-installer-master]$ 
sh ctools-installer.sh -s /home/a1551/softwares\ installed/Pentaho/biserver-ce/pentaho-solutions -w /home/a1551/softwares\ installed/Pentaho/biserver-ce/tomcat/webapps/pentaho -b stable -c marketplace,cdf,cda,cde,cgg,cfr,sparkl,cdc,cdb,cdv,saiku,saikuadhoc -y -n -r 

NOTE : Note that there should not be spaces b/w the folder name. If you have space add \ to the word.
For example in the above command : /softwares\ installed/  where softwares installed is the name of the folder.


Purpose of each one given in ReadMe.txt file.

Usage : ctools-installer.sh -s solutionPath [-w pentaho WebapPath] [-b branch]

-s   Solution Path (eg: /biserver/petnaho-solutions)
-w  Pentaho webapp server path(required for cgg on versions 
          before 4.5 eg:biserverce/tomcat/webapps/pentaho)
-b  Branch from where to get ctools,stable for release,dev for trunk. Default is stable
-c  Comma-separated list of CTools to install 
         (Supported module-name: marketplace,cdf,cda,cde,cgg,cfr,spark1,cdc,cdb,cdv,saiku,saikuadhoc)
-y  assume yest to all prompts
-n  Add newline to end of prompts(for integration with CBF)
-r  Directory for storing offline files
-h  This help screen. 


Once you done with the above command your installation will start with log saying

CTOOLS
ctools-installer version 1.46
Author: Pedro Alves (webdetails)
Thanks to Analytical Labs for jenkins builds
Copyright Webdetails 2011-2013
Changelog:
v1.46 - Added stable versions for Pentaho 5
v1.45 - Added Marketplace, CFR and Sparkl, currently on -b dev only
v1.44 - Added option -r to specify offline mode
v1.43 - Added option -c to specify ctools list to download - Thanks to Tom
v1.42 - Changed stable CGG download process
v1.41 - Changed dev CGG download process
v1.40 - Changed dev saiku download path
v1.39 - Changed saiku download path to 2.4
v1.38 - Added option -n for CBF integration
v1.37 - plugin-samples/cdv was not deleted. Fixed
v1.36 - CDV now installs samples too
v1.35 - Support for stable CDV, CDC and CDB installation
v1.34 - Support for CDV installation using -b dev switch
v1.33 - Added support for Saiku ad hoc stable (release) installations.
v1.32 - Added windows cr tolerance for this script's auto update
v1.31 - Support for CDB installation using -b dev switch
v1.30 - Support for CDC installation using -b dev switch
v1.29 - Changed saiku download path to 2.3
v1.28 - Support for CGG in 4.5, where webapp path is no longer required
v1.27 - Added support for CGG stable ( release ) installations.
v1.26 - -y flag now also works for ctools-installer update. ctools-installer update is now automated - Thanks to Mark Reid.
v1.25 - Removed overwrite, explicitly deleting marketplace definition
v1.24 - Added force overwrite to unzip to phase out overwrite confirmation
v1.23 - CDF trunk installation change due to js publish
v1.22 - Changed saiku download path to 2.2
v1.21 - Added support for CDE stable (release) installations.
v1.20 - CDF new samples location updated to stable installation.
v1.19 - Corrected installCDF and installCDE to remove samples dir before installing
v1.18 - CDA samples installation to plugin-samples also in stable mode.
v1.17 - Change to CDA and CDE samples installation. Now installs to folder plugin-samples instead of bi-developers (for trunk snapshot only).
v1.16 - Added support for CDC and Saiku-adhoc installation - for now only available in dev/trunk mode.
v1.15 - Change to CDF samples installation. Now installs to folder plugin-samples instead of bi-developers (for trunk snapshot only).
v1.14 - Added support for CDF stable (release) installations.
v1.13 - Fixed issue in CGG download
v1.12 - Fixed typo in -Y option
v1.11 - Added support for -y option (assume yes) - Thanks to Christian G. Warden
v1.10 - Added support for Saiku trunk snapshots installations.
v1.9 - Added support for CDA stable (release) installations.
v1.8 - Added CGG; Script refactor
v1.7 - Changed url locations to new path of analytical labs
v1.6 - Changed saiku download path to 2.1
v1.5 - Changed default indicator values in prompts
v1.4 - Added Saiku for the list of installs
v1.3 - Added support for automatic updates
v1.2 - Silent mode for downloading
v1.1 - Minor bugfixes
v1.0 - First release
Disclaimer: we can't be responsible for any damage done to your system, which hopefully will not happen
Note: ctools-installer.sh will upgrade the plugins under system directory.
Any changes you have made there (eg: cdf templates) will have to be backed up and manually copied after running the script
CGG will need to change the server WEB-INF/lib too. Backup your server
Downloading files
Downloading Marketplace...
End-of-central-directory signature not found. Either this file is not
a zipfile, or it constitutes one disk of a multi-part archive. In the
latter case the central directory and zipfile comment will be found on
the last disk(s) of this archive.
unzip: cannot find zipfile directory in one of .tmp/marketplace/plugin.zip or
.tmp/marketplace/plugin.zip.zip, and cannot find .tmp/marketplace/plugin.zip.ZIP, period.
Done
Downloading CDF...
Done
Downloading CDA...
Done
Downloading CDE...
Done
Downloading CGG...
Done
Downloading Sparkl...
Done
Downloading CDV...
Done
SAIKU [stable] not available for Pentaho 5.x yet.
Done

Installing files

  End-of-central-directory signature not found.  Either this file is not
  a zipfile, or it constitutes one disk of a multi-part archive.  In the
  latter case the central directory and zipfile comment will be found on
  the last disk(s) of this archive.
note:  .tmp/marketplace/plugin.zip may be a plain executable, not an archive
unzip:  cannot find zipfile directory in one of .tmp/marketplace/plugin.zip or
        .tmp/marketplace/plugin.zip.zip, and cannot find .tmp/marketplace/plugin.zip.ZIP, period.
cp: target `installed/Pentaho/biserver-ce/tomcat/webapps/pentaho/WEB-INF/lib' is not a directory
unzip:  cannot find or open .tmp/dist/sparkl-??.??.??.zip, .tmp/dist/sparkl-??.??.??.zip.zip or .tmp/dist/sparkl-??.??.??.zip.ZIP.

No zipfiles found.
unzip:  cannot find or open .tmp/dist/cdv-??.??.??.zip, .tmp/dist/cdv-??.??.??.zip.zip or .tmp/dist/cdv-??.??.??.zip.ZIP.

No zipfiles found.
unzip:  cannot find or open .tmp/dist/cdv-samples-??.??.??*zip, .tmp/dist/cdv-samples-??.??.??*zip.zip or .tmp/dist/cdv-samples-??.??.??*zip.ZIP.

No zipfiles found.
unzip:  cannot find or open .tmp/saiku-plugin*zip, .tmp/saiku-plugin*zip.zip or .tmp/saiku-plugin*zip.ZIP.

No zipfiles found.

Done!

References: