# Optionsfile documentation for ODK Aggregate Installer

**URL:** <https://forum.getodk.org/t/optionsfile-documentation-for-odk-aggregate-installer/9990>\
**Category:** Support\
**Tags:** odk-aggregate\
**Created:** [September 25, 2017, 7:10pm UTC](https://forum.getodk.org/t/optionsfile-documentation-for-odk-aggregate-installer/9990 "2017-09-25T19:10:44Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![yanokwa](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/yanokwa/32/1695_2.png) [@yanokwa](https://forum.getodk.org/u/yanokwa)\
**Post date:** [September 26, 2017, 8:55am UTC](https://forum.getodk.org/t/optionsfile-documentation-for-odk-aggregate-installer/9990/2 "2017-09-26T08:55:33Z")

</div>

Hi John! We are in the middle of some changes to Aggregate that should make all this easier. We need help with that effort and if you'd like to chip, please read [ODK Aggregate future plans](https://forum.getodk.org/t/odk-aggregate-future-plans/9219) and comment there.

As to the problem at hand, what I've done in the past to generate unattended installs for MySQL and Tomcat is this..

```bash
command: "{{ all_tmp_dir }}/{{ aggregate_installer }} 
--mode unattended 
--parent_installdir {{ all_tmp_dir }} 
--platform mysql 
--tomcat_http_port 80 
--tomcat_https_port 443 
--raw_hostname {{ all_fqdn }} 
--database_port 3306 
--database_hostname {{ all_mysql_host }} 
--jdbc_username {{ all_mysql_user }} 
--jdbc_password {{ all_mysql_pass }} 
--jdbc_database {{ all_mysql_db }} 
--instance_display_name {{ all_fqdn }} 
--username {{ all_aggregate_user }} 
--app_id '' 
--master_slave_app_id '' 
--jdbc_sqlserver_url '' 
--jdbc_gae_mysql_instance_name '' 
--jdbc_gae_mysql_password ''"

```

This is from an Ansible setup that I use to spin up Aggregate VMs for testing. You can find it at [https://github.com/nafundi/odk-aggregate-box/blob/master/provisioning/roles/install-aggregate/tasks/main.yml](https://github.com/nafundi/odk-aggregate-box/blob/master/provisioning/roles/install-aggregate/tasks/main.yml). That whole project might give you other useful hints.

Another thing to be aware of is there is a bug with Aggregate's JDBC properties. `database_hostname` and `database_port` aren't set in jdbc.properties and I've filed that [https://github.com/opendatakit/aggregate/issues/82](https://github.com/opendatakit/aggregate/issues/82).

Oh and welcome to ODK! When you get a chance, please [introduce yourself here](https://forum.getodk.org/t/-/6671). I'd also encourage you to add a real picture as your avatar because it helps build community!

---

_[View the full topic](https://forum.getodk.org/t/optionsfile-documentation-for-odk-aggregate-installer/9990)._