A guide to install Abiquo Reports for Abiquo.
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_auth.sh: Installs and configures Jasper Server authentication components.
reports/: Contains all report packs and Jasper Server and DB report objects.
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
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:
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 a reports user in the secondary DB server. Go to mysql prompt and create the user manually as an admin user:
From a browser, log into Jasper Reports server by going to the URL below. Replace REPORTS_SERVER accordingly. Default credentials are jasperadmin / jasperadmin
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
Now you should be able to access the Jasper Server reporting portal directly from the Abiquo UI.
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.