Setting up a database in a RONIN machine and connecting to that machine from another RONIN machine is really simple within a project. We made all the networking friendly within projects so the machines are already able to connect to each other. For this example we will use Postgresql.
I have created and connected my Docker machine already, let's get started!
Step 1 - Install Postgresql
Run in a terminal.
sudo apt install postgresql -y
Step 2 - Modify the pg_hba config file:
sudo bash -c 'echo -e "host\tall\t\tall\t\t0.0.0.0/0\t\tmd5" >> /etc/postgresql/10/main/pg_hba.conf'
Step 3 - Modify the postgressql config file:
sudo bash -c 'echo -e "listen_addresses='\''*'\''" >> /etc/postgresql/10/main/postgresql.conf'
Step 4 - Restart the Postgres service
sudo service postgresql restart
Step 5 - Create a new super user
Run the following command in your terminal window, and enter the following prompts.
First log in as the postgress user.
sudo su - postgres
Then run the following command
createuser --interactive --pwprompt
At the 'Enter name of role to add:' prompt, type the desired role name. e.g. Admin
At the 'Enter password for new role:' prompt, type the desired password for the user role.
At the 'Enter it again:' prompt, retype the password.
At the 'Shall the new role be a superuser?' prompt, type 'y'.
Step 6 - Go to the PGADMIN UI and connect to your server with your new super user credentials
Yay!!! You now have connected your database to your RONIN machine.