Hi Francesco ,
I am facing problem while executing the AAAR_Extract.sh.
I am using mysql and I used AAAR_Manual_Installation.pdf
Pentaho Combined Server 7.0.0.0-25 Distribution
mysql Ver 14.12 Distrib 5.0.95, for redhat-linux-gnu (x86_64) using readline 5.1
Pentaho and Alfresco are not same servers.
Below is the repositories.xml
]# cat /oracle/app/pentaho/data-integration/repositories.xml
<?xml version="1.0" encoding="UTF-8"?>
<repositories>
<connection>
<name>AAAR_Kettle</name>
<type>MYSQL</type>
<access>JNDI</access>
<database>AAAR_Kettle</database>
</connection>
<repository>
<id>KettleDatabaseRepository</id>
<name>AAAR_Kettle</name>
<description>AAAR_Kettle</description>
<connection>AAAR_Kettle</connection>
</repository>
</repositories>
and
<?xml version="1.0" encoding="UTF-8"?>
<AAAR>
<parameter name="AAARGetAudit" value="true"> </parameter>
<parameter name="AAARGetNodes" value="true"> </parameter>
<parameter name="AAARGetWorkflows" value="true"> </parameter>
<parameter name="alfrescoAuditLimit" value="50000"> </parameter>
<parameter name="alfrescoFtpPath" value="alfresco"> </parameter>
<parameter name="alfrescoFtpPort" value="121"> </parameter>
<parameter name="alfrescoHost" value="http://x.x.x.x"> </parameter>
<parameter name="alfrescoLogin" value="admin"> </parameter>
<parameter name="alfrescoNodeLimit" value="50000"> </parameter>
<parameter name="alfrescoPassword" value="welcome1"> </parameter>
<parameter name="alfrescoProtocol" value="http"> </parameter>
<parameter name="alfrescoPort" value="8080"> </parameter>
<parameter name="alfrescoType" value="Alfresco_5_1"> </parameter>
<parameter name="databaseBin" value="/usr/bin"> </parameter>
<parameter name="databaseType" value="mySql"> </parameter>
<parameter name="databaseHost" value="localhost"> </parameter>
<parameter name="databaseLogin" value="root"> </parameter>
<parameter name="databasePassword" value="xxxxx"> </parameter>
<parameter name="databasePort" value="3303"> </parameter>
<parameter name="databaseSchemaAAAR" value="AAAR_DataMart"> </parameter>
<parameter name="databaseSchemaKettle" value="AAAR_Kettle"> </parameter>
<parameter name="databaseSchemaMain" value="root"> </parameter>
<parameter name="kettlePath" value="/opt/data-integration"> </parameter>
<parameter name="kettleVersion" value="6"> </parameter>
<parameter name="pentahoAAARPath" value="/public/AAAR"> </parameter>
</AAAR>
I am getting below error while executing AAAR_Extract.sh and log file says "dummy". I am not sure what is wrong with connection. Please guide me in troubleshooting.
sh AAAR_Extract.sh
A.A.A.R. - Alfresco Audit Analysis and Reporting
Import procedure version 4.2.
Author: Francesco Corti (all rights reserved)
Date: 21 February 2016
Documentation and tips: http://fcorti.com.
Disclaimer:
We can't be responsible for any damage done to your system,
which hopefully will not happen.
You are going to execute this command:
./kitchen.sh /rep:AAAR_Kettle /job:"Get all" /dir:/Alfresco /user:admin /pass:admin /param:get_audit=true /param:get_nodes=true /param:get_workflows=true /log="/oracle/app/pentaho/pentaho-server/pentaho-solutions/system/AAAR/endpoints/kettle/script/../logs/AAAR.log" /level
ebug
Press <enter> to start import.
#######################################################################
WARNING: no libwebkitgtk-1.0 detected, some features will be unavailable
Consider installing the package with apt-get or yum.
e.g. 'sudo apt-get install libwebkitgtk-1.0-0'
#######################################################################
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0
14:51:21,421 INFO [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled
14:51:21,528 INFO [KarafInstance]
*******************************************************************************
*** Karaf Instance Number: 1 at /oracle/app/pentaho/data-integration/./syst ***
*** em/karaf/caches/kitchen/data-1 ***
*** Karaf Port:8802 ***
*** OSGI Service Port:9051 ***
*******************************************************************************
May 15, 2017 2:51:22 PM org.apache.karaf.main.Main$KarafLockCallback lockAquired
INFO: Lock acquired. Setting startlevel to 100
2017/05/15 14:51:22 - Kitchen - Logging is at level : Debug
2017/05/15 14:51:22 - Kitchen - Repository and username supplied
2017/05/15 14:51:22 - Kitchen - Start of run.
2017/05/15 14:51:22 - Kitchen - Allocate new job.
2017/05/15 14:51:22 - Kitchen - Parsing command line options.
2017/05/15 14:51:22 - Kitchen - Loading available repositories.
2017/05/15 14:51:22 - RepositoriesMeta - Reading repositories XML file: /oracle/app/pentaho/data-integration/repositories.xml
2017/05/15 14:51:22 - RepositoriesMeta - We have 1 connections...
2017/05/15 14:51:22 - RepositoriesMeta - Looking at connection #0
2017/05/15 14:51:22 - RepositoriesMeta - Read at connection: AAAR_Kettle
2017/05/15 14:51:22 - RepositoriesMeta - We have 1 repositories...
2017/05/15 14:51:22 - RepositoriesMeta - Looking at repository #0
2017/05/15 14:51:22 - RepositoriesMeta - Read at repository: AAAR_Kettle
2017/05/15 14:51:22 - Kitchen - Finding repository [AAAR_Kettle]
2017/05/15 14:51:22 - Kitchen - Allocate & connect to repository.
Processing stopped because of an error:
Error connecting to the repository!
Error occurred while trying to connect to the database
Access denied for user 'root'@'xxxxxx.com.xxx' (using password: YES)
ERROR: Kitchen can't continue because the job couldn't be loaded.
Extraction complete!
Log file has been generated in the file below:
/oracle/app/pentaho/pentaho-server/pentaho-solutions/system/AAAR/endpoints/kettle/script/../logs/AAAR.log
