cancel
Showing results for 
Search instead for 
Did you mean: 

AAAR installed, I followed this steps

bisana
Champ on-the-rise
Champ on-the-rise
Hi All,
Thanks to "Francesco " for his support, after repeated try I was able to install AAAR.
I am going to write down the steps which I followed, so that new comers for Pentaho or BI area gets help from this thread.
———-
I have installed CE edition on a Linux system
Used normal user to install it
—-
Best installing make sure you have Sun(Oracle) java installed , and JAVA_HOME,JRE_HOME and path set accordingly, I have my java in /opt folder and I have created a env file to reflect the above parameters, my env file contents are

export JAVA_HOME=/opt/java
export JRE_HOME=/opt/java/jre
export PATH=/opt/java/bin:$PATH

execute the environment files
Now my pentaho installation folder is in /opt
So I start the pentaho using the command

/opt/biserver-ce/start-pentaho.sh

For trouble shooting, I keep an eye on the logs created, for this you need to do

tail -f /opt/biserver-ce/tomcat/logs/catalina.out


checking the log files you get an idea on what is happening, the log files are friends which gives us direction where u gone wrong, so to save time, check the log files always, log entry which happens dynamically can be checked using this command
 
tail -f /opt/biserver-ce/tomcat/logs/catalina.out

After the installation, go to market place, then "installed plugins" update the plugins under the "installed plugins" to the latest, it will ask for restart, do it
to restart the service do this
 
/opt/biserver-ce/start-pentaho.sh
wait for some time, check the log files, to see the service stopped then
give
/opt/biserver-ce/start-pentaho.sh

Now prior installing AAAR we need to install

CDA   =  Community Data Access
CDE   =  Community DashBoard Editor
Sparkl = Pentaho Application Builder

Go to market place and install the above plugins
After installation of plugins, it will ask you to restart the service, please restart
the service.

Now once the service is up, go to market place and install AAAR, as asked by the system, please restart the service, Your AAAR installation is complete.

I have attached a screen shot of the list of plugins installed for AAAR to work, please check the attachment for your reference.

This is all the steps for installing.
the rest configuring of AAAR, I have not done, once finished I will post the steps with screen shots
thanks
Joseph John





15 REPLIES 15

macmarket
Champ in-the-making
Champ in-the-making
When I turn the Alfresco's Tomcat Server ON, looks like it blocks the Pentaho's Tomcat Server, even at port 8081.

The Alfresco has its own TomCat server which control all the WAR files from the Alfrescos. The Pentaho has its own Tomcat server too… even changing the port of Pentaho to 8081, I cannot have the 2 TomCats running together… looks like when one of them is up, the other stops…

I put a picture of my server screen now, with the Alfresco's Tomcat Server Running, and the Pentaho's not being available… some minutes ago, with the Alfresco's Tomcat stopped, I was able to connect Pentaho's server… 😕

macmarket
Champ in-the-making
Champ in-the-making
When I turn the Alfresco's Tomcat Server ON, looks like it blocks the Pentaho's Tomcat Server, even at port 8081.

The Alfresco has its own TomCat server which control all the WAR files from the Alfrescos. The Pentaho has its own Tomcat server too… even changing the port of Pentaho to 8081, I cannot have the 2 TomCats running together… looks like when one of them is up, the other stops…

I put a picture of my server screen now, with the Alfresco's Tomcat Server Running, and the Pentaho's not being available… some minutes ago, with the Alfresco's Tomcat stopped, I was able to connect Pentaho's server… 😕

emorenofer
Champ in-the-making
Champ in-the-making
Extract of pentaho.log inside TOMCAT directory…

2014-03-13 11:09:52,378 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - installFromConfiguration - Start of job execution
2014-03-13 11:09:52,381 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - installFromConfiguration - Starting entry [_installFromConfiguration]
2014-03-13 11:09:52,411 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - _installFromConfiguration - Starting entry [Checks if files exist]
2014-03-13 11:09:52,413 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - _installFromConfiguration - Starting entry [_readConfigurationInVariables]
2014-03-13 11:09:52,415 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - _readConfigurationInVariables - Loading transformation from XML file [file:///opt/biserver-ce/pentaho-solutions/system/AAAR/endpoints/kettle/_readConfigurationInVariables.ktr]
2014-03-13 11:09:52,475 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - _readConfigurationInVariables - Dispatching started for transformation [_readConfigurationInVariables]
2014-03-13 11:09:52,556 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Data Grid.0 - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
2014-03-13 11:09:52,634 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Get data from XML.0 - Finished processing (I=22, O=0, R=0, W=484, U=0, E=0)
2014-03-13 11:09:52,793 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,798 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 2.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,800 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 3.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,802 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 4.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,803 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 5.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,806 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 6.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,810 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 7.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,812 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 8.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,813 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 9.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,815 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 10.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,830 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 11.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,832 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Setting environment variables…
2014-03-13 11:09:52,832 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable AAARExportGetParents to value [false]
2014-03-13 11:09:52,832 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable AAARExportType to value [Get all]
2014-03-13 11:09:52,833 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable alfrescoAuditLimit to value [50000]
2014-03-13 11:09:52,833 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable alfrescoFtpPath to value [alfresco]
2014-03-13 11:09:52,833 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable alfrescoFtpPort to value [21]
2014-03-13 11:09:52,833 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable alfrescoHost to value [172.30.1.52]
2014-03-13 11:09:52,833 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable alfrescoLogin to value [admin]
2014-03-13 11:09:52,834 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable alfrescoPassword to value [SiPeT9Ce]
2014-03-13 11:09:52,834 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable alfrescoPort to value [8080]
2014-03-13 11:09:52,834 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable alfrescoProtocol to value [http]
2014-03-13 11:09:52,834 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable databaseBin to value [/usr/bin]
2014-03-13 11:09:52,834 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable databaseHost to value [localhost]
2014-03-13 11:09:52,835 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable databaseLogin to value [postgres]
2014-03-13 11:09:52,835 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable databasePassword to value [postgres]
2014-03-13 11:09:52,835 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable databasePort to value [5432]
2014-03-13 11:09:52,835 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable databaseSchemaAAAR to value [AAAR_DataMart]
2014-03-13 11:09:52,836 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable databaseSchemaKettle to value [AAAR_Kettle]
2014-03-13 11:09:52,836 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable databaseSchemaMain to value [postgres]
2014-03-13 11:09:52,836 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 12.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,837 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable databaseType to value [PostgreSql]
2014-03-13 11:09:52,837 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable kettlePath to value [/opt/data-integration]
2014-03-13 11:09:52,837 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable kettleVersion to value [5]
2014-03-13 11:09:52,838 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable pentahoAAARPath to value [/public/AAAR]
2014-03-13 11:09:52,838 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 13.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,839 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 14.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,841 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 15.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,843 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 16.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,845 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 17.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,846 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 18.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,848 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 19.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,850 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 20.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,852 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 21.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,854 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 22.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,855 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Finished after 1 rows.
2014-03-13 11:09:52,856 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2014-03-13 11:09:52,861 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - _installFromConfiguration - Starting entry [Check databaseType = 'PostgreSql']
2014-03-13 11:09:52,863 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - _installFromConfiguration - Starting entry [_installPostgreSql]
2014-03-13 11:09:52,892 INFO  [org.pentaho.di] 2014/03/13 11:09:52 - _installPostgreSql - Starting entry [Check Db connections]
2014-03-13 11:09:53,108 ERROR [org.pentaho.di] 2014/03/13 11:09:53 - Checks if files exist - ERROR (version 5.0.1-stable.148b6fef6a996547f0a83bc49a869d75ef55b8ca, build 1 from 2013-11-15_14-00-42 by buildguy) : Cannot connect to database [${databaseSchemaMain}] (connection [PostgreSql]). Exception : [org.pentaho.di.core.exception.KettleDatabaseException:
2014/03/13 11:09:53 - Checks if files exist - Error occured while trying to connect to the database
2014/03/13 11:09:53 - Checks if files exist -
2014/03/13 11:09:53 - Checks if files exist - Error connecting to database: (using class org.postgresql.Driver)
2014/03/13 11:09:53 - Checks if files exist - Invalid URL: jdbcSmiley Tongueostgresql://localhost:5432/postgres
2014/03/13 11:09:53 - Checks if files exist -
2014/03/13 11:09:53 - Checks if files exist - ]
2014-03-13 11:09:53,109 INFO  [org.pentaho.di] 2014/03/13 11:09:53 - _installPostgreSql - Finished job entry [Check Db connections] (result=[false])
2014-03-13 11:09:53,111 INFO  [org.pentaho.di] 2014/03/13 11:09:53 - _installFromConfiguration - Finished job entry [_installPostgreSql] (result=[false])
2014-03-13 11:09:53,111 INFO  [org.pentaho.di] 2014/03/13 11:09:53 - _installFromConfiguration - Finished job entry [Check databaseType = 'PostgreSql'] (result=[false])
2014-03-13 11:09:53,112 INFO  [org.pentaho.di] 2014/03/13 11:09:53 - _installFromConfiguration - Finished job entry [_readConfigurationInVariables] (result=[false])
2014-03-13 11:09:53,112 INFO  [org.pentaho.di] 2014/03/13 11:09:53 - _installFromConfiguration - Finished job entry [Checks if files exist] (result=[false])
2014-03-13 11:09:53,117 INFO  [org.pentaho.di] 2014/03/13 11:09:53 - installFromConfiguration - Finished job entry [_installFromConfiguration] (result=[false])
2014-03-13 11:09:53,117 INFO  [org.pentaho.di] 2014/03/13 11:09:53 - installFromConfiguration - Job execution finished





Pay attention with error connect to Database Tomcat…mmm…I've installed postgres with default credential, I've not modified nothing….mmmm….I don't know…

Maybe this, help you…

emorenofer
Champ in-the-making
Champ in-the-making
Ouch…I had problems with ProgreSQL and default user, perfect!

iblanco
Confirmed Champ
Confirmed Champ
Eduardo:

To be able to make both tomcats work at same time I changed 3 ports in Pentaho's Business Intelligence Server.
Edit /biserver-ce/tomcat/conf/server.xml and change the mentions to port 8080 (the default HTTP connector), mentions to port 8009 (An AJP connector) and finally look for a mention to port 8005 as a SHUTDOWN port. Add 1 to all of them and you should be done.
Those are the defaults ports in Tomcat and if you don't change them in one of the tomcats stranges things happen.

Good luck.

sandeepreddy1
Star Contributor
Star Contributor
Hai alfresco forum,


How to get and  install CDA, CDE and AAAR In pentaho Marketplace without internet connection in Redhat, can anyone help me out please