AAAR_Publish.sh trhowing error JNDI Connection error

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

bisana

Hi All
After the AAAR installation, and configuration. I have given correct parameters for alfresco and the DB for AAAR. I have also copied the mysql-jdbc dirver jar files to the lib directory
But when I run

AAAR_Publish.sh ‍

I get error message as

Invalid JNDI connection AAAR_Kettle : No suitable driver found for jdbc:mysql://localhost:3306/AAAR_Kettle
‍‍‍

When I checked my MySQL  I have seen the  "AAAR_Kettle" db with 46 tables inside it



Guidance and advice requested

bisana

Hi All
Was able to solve, it by adding values in
<strong> /opt/biserver-ce/pentaho-solutions/system/simple-jndi/jdbc.properties </strong>
the format of the values are

# A.A.A.R. - Alfresco Audit Analysis and Reporting - AAAR_DataMart.
AAAR_DataMart/type=javax.sql.DataSource
AAAR_DataMart/driver=com.mysql.jdbc.Driver
AAAR_DataMart/url=jdbc:mysql://localhost:3306/AAAR_DataMart
AAAR_DataMart/user=root
AAAR_DataMart/password=mypass

# A.A.A.R. - Alfresco Audit Analysis and Reporting - AAAR_Kettle.
AAAR_Kettle/type=javax.sql.DataSource
AAAR_Kettle/driver=com.mysql.jdbc.Driver
AAAR_Kettle/url=jdbc:mysql://localhost:3306/AAAR_Kettle
AAAR_Kettle/user=root
AAAR_Kettle/password=mypass
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍