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.