02-07-2019 03:57 AM
Hello everyone,
I am trying to install A.A.A.R. with mysql cluster.
For some reasons, I am not allowed to use root for mysql, so I created another mysql user=pentahouser that has full permission to database AAAR_DataMart and AAAR_Kettle.
According to this page (http://fcorti.com/alfresco-audit-analysis-reporting/aaar-how-to-install/aaar-install/) , I pressed INSTALL A.A.A.R. button, the log in catalina.out showed that
Access denied for user 'pentahouser'@'%' to database 'mysql'
It looks like it needs permission to 'mysql' database.
Does anyone know what it reads/writes to 'mysql' database?
or do I need more permissions on the other databases?
02-10-2019 01:25 PM
Hi Thomas.
Which version of AAAR/Pentaho are you using?
As you are imagining this issue is related to the authentication/authorization for sure, but we need to understand in which task exactly.
02-10-2019 08:18 PM
Hi Francesco,
Here is the version of AAAR/Pentaho I am using.
AAAR-Alfresco-CE-v5.1-Repository-v4.5
pentaho-server-ce-7.0.0.0-25
02-11-2019 06:10 AM
Is there any reason for not using the latest Alflytics version?
Alflytics - The Open Source Business Intelligence solution over Alfresco - Francesco Corti
I mean, I usually recommend to use the latest (and the greatest).
Explore our Alfresco products with the links below. Use labels to filter content by product module.