AnsweredAssumed Answered

AAAR_Etract.sh is failing due to connection

Question asked by manirangasamy on May 15, 2017
Latest reply on Jun 1, 2017 by fcorti

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:Debug

 

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

Outcomes