Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Prerequisites

...

  1. If you've already got MySQL db setup locally with data, skip this step and go to step 2.
    Get a copy of tis backup db data from S3 bucket (this could be either Prod or Stage) and upzip it on your local.
    After tis-mysql docker container is started up, import data into MySQL . (If you have no idea how to do this, please check with one of other devs).
  2. Anchor
    step2
    step2
    Run `docker exec -it tis-mysql bash` on your command line, then in the new bash env, type `mysql` to login, and modify the password of MySQL user `keycloak` by executing the following command:

    Code Block
    alter user 'keycloak'@'%' identified by '11111111';


  3. Run the following scripts in command line or via MySQL Workbench:

    Code Block
    use keycloak;
    
    -- clear admin user in keycloak
    SET @user_id = (SELECT ID FROM USER_ENTITY where username = "admin");
    delete from CREDENTIAL where user_id = @user_id;
    delete from USER_ROLE_MAPPING where user_id = @user_id;
    delete from USER_ENTITY where id = @user_id;
    
    SET @api_gateway_client_id = (select ID from CLIENT where CLIENT_ID = 'api-gateway' and REALM_ID = (SELECT ID FROM keycloak.REALM where NAME = 'lin'));
    
    -- reset secret for api-gateway
    update CLIENT
    set SECRET = 'local11111111' where ID = @api_gateway_client_id;
    
    -- reset redirect_uris
    delete from REDIRECT_URIS where CLIENT_ID = @api_gateway_client_id;
    insert into REDIRECT_URIS values(@api_gateway_client_id, '/admin/redirect_uri');
    insert into REDIRECT_URIS values(@api_gateway_client_id, '*');
    insert into REDIRECT_URIS values(@api_gateway_client_id, 'http://localhost/*');
    insert into REDIRECT_URIS values(@api_gateway_client_id, '/access/index.html');
    insert into REDIRECT_URIS values(@api_gateway_client_id, '/logout/index.html');
    
    -- reset web_origins
    update WEB_ORIGINS
    set value = 'https://local.tis.com' where CLIENT_ID = @api_gateway_client_id;


Configure Keycloak + Apache + Nginx

  • Please clone https://github.com/Health-Education-England/TIS-APACHE-SETUP to get started and use the branch "chore/setup_with_local_credentials".
  • Update the 3nd nginx volumn to map the folder of your local TIS-ADMINS-UI admin folder for Nginx to host.
  • do `docker-compose up` to start up all of these 3 docker containers.


After that, you will be able to access your local Nginx console - url: "http://local.tis.com/auth", username: admin, password: 11111111
and Admins-UI - url: "http://local.tis.com/admin", username and password will be your Stage/Prod credential depends on what backup data you imported.