OpenI-Jasper distribution is bundled with a SQL script (sampledb.sql) to create the necessary databases and tables in the database system and also, dumps the sample data for running the sample reports. Unzip the sampledb.zip file under the folder "sampledata" to extract the SQL script.
Please run the following mysql command from the terminal shell to execute the sql script (Note: OpenI-Jasper assumes that mysql server is successfully installed and the mysql executables are set in the environment variables to have global access)
mysql -u <<username>> -p <<password>> -h <<hostname>> < << path to the sql script>>
The script creates three databases in the database server namely, jasperserver, sugarcrm and foodmart.
OpenI-Jasper requires the properly configured JNDI datasources (jdbc/jasperserver, jdbc/sugarcrm and jdbc/foodmart), which it does by specifying in the context.xml file located under "<<openi jasper project>>/META-INF" folder location. These JNDI datasources are pre-configured to use the default user" openijasperdb" with password "password". So, you need to create a database user "openijaserperdb" in your database server, by logging into the mysql console and executing the following command.
mysql > CREATE USER 'openijasperdb'@'localhost' identified by 'password';
mysql> GRANT ALL PRIVILEGES ON jasperserver.* to 'openijasperdb';
mysql> GRANT ALL PRIVILEGES ON sugarcrm.* to 'openijasperdb';
mysql> GRANT ALL PRIVILEGES ON foodmart.* to 'openijasperdb';
You can you have your custom jndi datasources configuration in the context.xml file of the tomcat container itself.