AAAR installed, I followed this steps

[bisana]

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

[emorenofer]

I'm in the same point!…Do you know what is the next step?…When I execute AAAR_Extract.sh I get the following error:


2014/03/12 13:29:33 - Kitchen - Logging is at level : Basic logging
2014/03/12 13:29:33 - Kitchen - Start of run.
ERROR: No repository provided, can't load job.
ERROR: Kitchen can't continue because the job couldn't be loaded.

Extraction complete!


I know that it is because I didn't config the data-integration, but I don't know how I can put this configuration…against my Alfresco Server.

Help?

Thanks!

[fcorti]

Hi Emilio,

I suggest you to follow the instructions <a href="http://fcorti.com/alfresco-audit-analysis-reporting/aaar-how-to-install/aaar-install/">here</a>.

[emorenofer]

When I execute /opt/data-integration/spoon.sh, I see the selecction of repository or bd of repository I don't know (see attach image)

What We need to config here? Repository of Alfresco? BD of Pentaho? Create something?


I think that after create this, AAAR_Extract.sh will be ok?


Grr…


Thanks!

[fcorti]

Hi Emilio,

Nothing to do here.
Please, don't use Spoon to configure AAAR.
I suggest you to follow (as close as possibile) the instructions <a href="http://fcorti.com/alfresco-audit-analysis-reporting/aaar-how-to-install/">here</a>.

[macmarket]

Hi Francesco, first I'd like o give you my best congrats due to your work about AAAR…

Well, since I'm a MacManiac, I decided to run Alfresco at one of my MacPros Xeon Octacore 2.26… looks a really great machine to take care of the job and its really fast and stable… well, I follow all the steps you suggested here to have to Pentaho running, and I had it running, but only when I turn off the Alfresco's TomCat, and let only the PostGreeSQL Server Running… so, I really ant to know if its possible to install de Pentaho under the same TomCat that I already have supporting my Alfresco. They are having a conflict, but I didn't find a Pentaho .war version to install in my previous TomCat. Any suggestion?

[fcorti]

Hi Eduardo,

Thank you for the feedback about AAAR.
I would like you to ask if the need of "one tomcat" into your machine is mandatory.
If you release this requirement you could have another tomcat running, for example, into the 8081 port and everything will work well: Alfresco on the 8080 port and Pentaho on the 8081 port.

I hope this will help you.

[macmarket]

Hi Francesco, its not mandatory… I've tried before to change the ports of Pentaho to 8081 and I followed some instructions I found in internet but it didn't work… do you have the complete instructions about how to change the Pentaho ports to 8081? I followed this ones: <strong> http://wiki.pentaho.com/display/COM/Run+bi-server+in+another+port+and+address </strong> but I think it's not up to date. Thanks in advance…

[macmarket]

Hi Francesco… I've just changed the Pentaho ports to 8081, and you can take a look at the screenshot I'm putting here its running, BUT, only when the Alfresco's Tomcat is stopped… Looks like I'm having a conflict between the Alfresco's built-in TomCat and the Pentaho's built-in ones…

[fcorti]

Hi Eduardo,

Looks good!
I cannot understand the conflict you mention, but in theory it should work.
I always use this configuration in my development enviroments. 😉