Get Abiquo Reporting module
Obtain the abiquo-reporting-core.zip file for your version.
Unzip it into a reporting folder on Abiquo Reports server.
It contains the following files:
Install JasperReports Server Community Edition
Download Jasper Reports 6.2.0 Community release from http://community.jaspersoft.com/download to Abiquo Reports server.
Run the installer as root to perform a custom install. You can use the default settings:
Start the Jasper Server
Create admin user in the DB server
Go to the mysql prompt in the DB server and create an admin user with access from Abiquo Reports server. Replace ADMIN_USER, ADMIN_PASS and REPORTS_SERVER accordingly:
Install Abiquo Jasper Server integration
From the reporting folder, run the Abiquo Reports install script.
By default the script will try to install on localhost with user root and no password. If you would like to install it on another server, use the appropriate options, replacing variables such as DATABASEHOST, with values for your environment:
The install script will install the JasperServer service and restart the JasperServer.
Create reports user in the DB server
Create a reports user in the slave replica DB server. Go to mysql prompt and create the user manually as an admin user:
Log into Jasper Reports server UI
From a browser, log into Jasper Reports server by going to the URL below. Replace REPORTS_SERVER accordingly. Default credentials are jasperadmin / jasperadmin
Activate Abiquo Jasper Server theme
Configure Abiquo Data Source in Jasper Reports Server
Test the Reports
Log back into Jasper Reports server using the credentials of an Abiquo user and check if you can now run any of the installed reports. If you have any problems, see Troubleshoot Abiquo Reports
Configure Reports Button in the Abiquo GUI
You should be able to access the Jasper Server reporting portal directly from the Abiquo UI now:
Create Cron job to clean up temporary tables
The reporting schema contains temporary tables, which should be deleted periodically by running kinton_reporting.TruncateRLSTables stored procedure. Run this job during low traffic hours so you do not affect reports generated by cloud users. For example, to delete the tables every day at 01:00, use the cron entry below. Replace ADMIN_USER, ADMIN_PASS and DB_SERVER according to your installation.