Question: Enterprise install trying to connect to wrong database

Forum - Installation
1

I am trying to set up Eramba Enterprise in our AWS account and want to use a RDS database for better stability and performance. I’ve updated the .env file as follows:

DB_HOST=[FQDN-to].rds.amazonaws.com
DB_DATABASE=docker
DB_USERNAME=eramba.socotra
DB_PASSWORD=XXXXXXXX
CACHE_URL=Redis://?server=redis&port=6379&password=&timeout=3
MYSQL_ROOT_PASSWORD=XXXXXXXX
USE_PROXY=0
PROXY_HOST=
PROXY_PORT=
USE_PROXY_AUTH=0
PROXY_AUTH_USER=
PROXY_AUTH_PASS=
PUBLIC_ADDRESS=https://XXXXXXXX
DOCKER_DEPLOYMENT=1
LDAPTLS_REQCERT=never

I also commented out the settings in the docker-compose tiles for deploying the mysql image, and removed the requires and links pieces.

I have confirmed that I can run mysql commands from the host that is running the eramba images using the MYSQL_ROOT_PASSWORD.

For some reason the eramba logs are saying this:

Waiting for database...
Connection to Mysql could not be established: SQLSTATE[HY000] [1045] Access denied for user 'eramba.socotra'@'172.31.13.160' (using password: YES)
Using connection: default
-------------------------------------------------------------------------------

As it turns out 172.31.13.160 is the IP of the Host that is running docker. So Mysql is not running locally at all, it shoudl be making these calls our to the rds instance. I’m not sure which setting is missing that is making this happen instead of as configured in .env

I never started any of the docker images prior to this, so it’s not grabbing an old config. Even so, I have tried to remove the local images and start again.

What am I missing?

2

I could be wrong, but I think in that log, that is supposed to be the source IP, not the host you are trying to connect to.

I would check the following:

  • Check the environment variables inside the eramba container to ensure the database host, user, pass, etc is correct.

  • Try to connect to the database directly from the server using mysql command/mysql client.

  • Check if the mysql RDS account has any user host restrictions that could be preventing the connection from that host.