AAAR_Publish.sh trhowing error JNDI Connection error

[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
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍