[Backlogmanager] [FIWARE-JIRA] (HELP-21536) [fiware-stackoverflow] using keyrock with non containerized mysql server

[José Ignacio Carretero Guarde (JIRA)]

     [ https://jira.fiware.org/browse/HELP-21536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

José Ignacio Carretero Guarde updated HELP-21536:
-------------------------------------------------
    Status: Answered  (was: In Progress)

> [fiware-stackoverflow] using keyrock with non containerized mysql server
> ------------------------------------------------------------------------
>
>                 Key: HELP-21536
>                 URL: https://jira.fiware.org/browse/HELP-21536
>             Project: Help-Desk
>          Issue Type: Monitor
>          Components: FIWARE-TECH-HELP
>            Reporter: Backlog Manager
>              Labels: docker, fiware, fiware-keyrock, mysql
>
> Created question in FIWARE Q/A platform on 19-06-2023 at 04:06
> {color: red}Please, ANSWER this question AT{color} 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 at 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.



--
This message was sent by Atlassian JIRA
(v6.4.1#64016)