Issue with Setting up AAP Private Automation Hub 2.2 Bundle

[Basavan]

Can any one help to resolve this issue ?

I'm trying to setup Private automatuon hub and i'm keep getting this error when i try to install with DB on same node (no external DB)

django.db.utils.OperationalError could not connect to server: connection refused tls the server running on the host hub.lab.example.com TCP/IP connections on port

but here installation doesn't work if we keep automationhub_pg_host as empty as i need to have DB on the same server it self for automation hub

Set the passwords for the private automation hub admin account (automationhub_admin_password) and for the PostgreSQL database user account (automationhub_pg_password).

For installing the private automation hub with the PostgreSQL database on the same node, leave the values for the automationhub_pg_host and automationhub_pg_port variables empty.

automationhub_admin_password='password'
automationhub_pg_host=''
automationhub_pg_port=''
automationhub_pg_database='automationhub'
automationhub_pg_username='automationhub'
automationhub_pg_password='password'

[OlivierB]

Hi !

In the Inventory file, are tou trying to install both automation controller and automation hub?

Because [database] section should also be empty, when installing db on same node (one of controller or hub, or both) it's not possible to install them at the same time.

So in such case, you should use 2 inventory files. One for the hub and one for the controller. And I think it's better to install first the hub.

Let me know if it helps

[Travis]

@Basavan -

Since you haven't shared all the error and I don't know everything in the inventory file, I think that @OlivierB is somewhat on the correct track on how the database is specified. I would like to clarify one thing though ... it is possible to use a single inventory file and install all the components on different servers and VMs.

https://github.com/tmichett/DO274_Demo/blob/master/Demos/Installation/inventory.txt

I've provided a link with an AAP 2.4 inventory file which also includes the EDA controller pieces too. What is important here is that while each entity is separately installed hub, controller, eda-controller, the database is installed a single-time and it is co-located on the automation controller system. 

You need to specify where the database is being installed so that the Ansible playbooks know what systems to contact when they are running the playbooks. Furthermore, @OlivierB is correct in that you can have multiple inventory files and install things separately that way, but then you end up with multiple PostGres servers and databases (each installed with its corresponding components). The other thing you lose by installing things separately is the "magic" that happens with the single inventory file when it comes to automatic configuration of components (execution environments, credentials, etc.) that get setup between Controller/Hub, etc. as well as the ability to easily manage backups/restores and other administrative tasks since you need to use the setup script and inventory files to perform those operations.

[juliettet]

I too am facing the same issue. Is there any official documentation on how to achieve this with 2 separate inventory files when provided with only one inventory file that is included with the installer bundle?

Thanks!

[Travis]

@juliettet -

So you can copy the inventory file and create as many custom inventory files as you want as long as you specify the inventory file for the installer on which one to use. However, if you install with multiple different inventory files for the various components, then you have problems and issues after the installation as things aren't "automatically" setup for you. The purpose  of the single inventory file is so that all AAP components can be installed, but they also get configured and integrated with each other. If they are contained across multiple different inventory files, the configuration and integration that happens as part of the installation must be done manually.

https://github.com/tmichett/DO274_Demo/blob/master/Demos/Installation/inventory.txt

Again, one of the demos I did for the DO274 course which has EDA Controller, Controller, and Hub has the database (Postgresql) server for all three on the "Controller" VM. You just need to ensure that you specify all the proper variable files and also ensure that you have the firewall ports open as that is another reason TCP connections can be refused.