Elastic Path Account Management Deployment Guide

Initializing Account Management Schema

Initializing Account Management Schema

  • Ensure that all requirements described in the Requirements section are met.
  • Ensure that you have access to the account-management-1.0.0.zip file in the Elastic Path Public Nexus repository.
  • Ensure that the MySQL compatible service is provisioned and the username, password, and other connectivity details are available.
  • Ensure that you have access to a machine which has connectivity to the MySQL service and can run Liquibase migrations.
  • Ensure that Keycloak is configured and deployed.
  • Ensure that the ID, full name, and e-mail of the seller administrator that you created in Keycloak are available. For more information, see the Creating new seller administrator section.
  1. Create a liquibase.properties file with the appropriate database access credentials and schema name.
  2. Copy the contents of the database folder from the account-management-1.0.0.zip and liquibase.properties files to the computer that execute the schema creation.
  3. To create the schema, run the following command:
    ./liquibase --changeLogFile=database/changelog-master.xml update 
  4. Connect to the database and run the following query:
    INSERT INTO TUSER (GUID, IDP_IDENTIFIER, FULL_NAME, EMAIL, USER_TYPE) 
    VALUES(UUID(), "<SELLER_ADMIN_ID>", "<Seller Admin Full Name>", "<Seller Admin Email>", "SELLER_USER");