I configured the default_master.propertes for my MySQL database. Then I install JasperServer via js-install-ce.sh. The build runs to completion and I see a BUILD_SUCCESS. The foodmart and Sugarcrm schemas have populated tables. But in the jasperserver schema, no tables have any rows. For instance, the JIFILERESOURCE table is empty... so the webapp throws an exception on login, since all theme resources are stored in JIFILERESOURCE.
I haven't found anyone else online that seems to have had this problem.
I'm using the MySQL JDBC driver (mysql-connector-java-5.1.40-bin.jar).
The issue is that our MySQL DBA had disabled autocommit. The Jasper installer depends on autocommit to populate jasperserver tables... I know this, because with autocommit enabled, everything is fine. Here is how to enable autocommit in the Jasper installer, for anyone else that has this problem. Edit the file buildomatic/conf_source/ieCe/applicationContext-export-config.xml. Find the data source bean. Add this property:
<property name="connectionInitSqls"> <list> <value>set autocommit = true</value> </list> </property>
Then run the install in the normal way, and jasperserver schema will be populated.