Created question in FIWARE Q/A platform on 19-06-2023 at 04:06
Please, ANSWER this question AT https://stackoverflow.com/questions/76503568/using-keyrock-with-non-containerized-mysql-server

Question:
using keyrock with non containerized mysql server

Description:
I have a running mysql DB with server and now I want to use keyrock to add access control to it. I've read tutorials where keyrock uses MySQL docker image for setting up, but in my case I don't want MySQL to run as a docker container but as a standalone application on the server machine.
so my setup is like the following:

keyrock docker image
non containerized MySQL

Here's my docker-compose file:
version: '3.5'

services:
keyrock:
image: fiware/idm:7.6.0
container_name: fiware-keyrock
hostname: keyrock
ports:

• '3005:3005'
• '443:443'
  environment:
• IDM_DB_HOST=localhost
• IDM_DB_PORT=3306
• IDM_HOST=http://keyrock:3005
• IDM_PORT=3005
• IDM_DB_USER=<dbuser>
• IDM_DB_PASS=<dbpass>
• IDM_ADMIN_USER=admin
• IDM_ADMIN_EMAIL=admin@test.com
• IDM_ADMIN_PASS=1234
  volumes:
• ./config.js:/opt/fiware-idm/config.js # Mount the config.js file from host to container
  env_file:
• ./secrets.env

Here's my config.js file snippet related to the database:
// Database info
config.database = {
host: 'localhost',
password: '<pass>',
username: 'root',
database: '<db_name>',
dialect: 'mysql',
port: 3306
};

After running the docker-compose up the keyrock is not connecting with MySQL and keeps displaying the following message
[+] Building 0.0s (0/0)
[+] Running 1/0
✔ Container fiware-keyrock Created 0.1s
Attaching to fiware-keyrock
fiware-keyrock | Stopping Postfix Mail Transport Agent: postfix.
fiware-keyrock | Starting Postfix Mail Transport Agent: postfix.
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...
fiware-keyrock | Waiting for database connection...

Since it is the first time, I'm just trying things out here so can someone please help me find the issue where I might be making mistakes.
I am running the keyrock container and non-containerized MySQL on same machine (ubuntu 22.04)
Thanks in advance for the help.