To install the Analytics Datastore on Linux, follow the steps below.
To install Analytics on Linux
Download PostgreSQL 9.4+ for your Linux distribution from www.postgresql.org/download/
Make sure that the tcp/ip connection is enabled (localhost).
Use the setup.psql script to create a user with a password and a database and grant all required privileges to the user for the created database. The script can be found here: ….\ Automic_Workload_Automation….\Automation.Platform\Analytics\Datastore\setup.psql)
You need the hostname/ip , port (default localhost:5432) and the postgres admin user to init the datastore.
The script will also create an api key that can be used to get data from the backend. The API must be added to the webui-plugin-analytics properties as well as the required configuration for the backend to connect to the datastore.
Execute the script in the folder where the setup.psql was extracted with the following parameters:
[path to postgres bin]/psql -h {host} -p {db_port} -U {superuser} -v username="{db_user}" -v password="'{db_user_password}'" -v db_name="{db_name}" -f setup.psql
(line breaks for format reasons only)
The superuser password will be prompted.
Parameters:
| Parameter | Description |
|---|---|
| -h = {host} |
The hostname or ip where postgresql is running. |
| -p = {db_port} | The port postgresql is using. Default: 5432 (One Installer uses: 5434). |
| -U = {superuser} | Username for postgresql. Default: postgresassword will be prompted |
You can also choose the following parameters:
| Parameter | Description |
|---|---|
| -v username = {db_user} | The username that the script will create and use to set up the analytics database. |
| -v password = {db_user_password} | The password for the created database user. |
| -v db_name = {db_name} | The name of the created database. |
The setup script generates output that helps you to configure the webui plugin and the analytics backend.
Example output:
Set the following property in your plugin.properties of the webui-plugin-analytics:
backend.api_key=f4b7e4af-3d77-4cfc-a898-2c09a9318faa
The file is located in the awi folder: /path/to/awi/config/webui-plugin-analytics/plugin.properties
Set the following properties in your application.properties file:
datasource.analytics.url=jdbc:postgresql://localhost:5432/analytics
datasource.analytics.username=analytics
datasource.analytics.password=analytics
See also: www.postgresql.org/docs/9.4/static/app-psql.html for all options of the psql command.