Versions Compared

Version Old Version 11 New Version 12
Changes made by

Rajeev Rai

Rajeev Rai

Saved on

Key

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

...

  1. Download Prerequisites:

    • Download required software from Google Drive (ACExpress pre-required software).

  2. Install Software:

    • Install all required software on the Bastion.

  3. Install CLI for Windows:

    • Open PowerShell and run the following command to install Chocolatey:

      Copy code

      Set-ExecutionPolicy Bypass -Scope Process -Force; [System.Net.ServicePointManager]::SecurityProtocol = [System.Net.ServicePointManager]::SecurityProtocol -bor 3072; iex ((New-Object System.Net.WebClient).DownloadString('https://community.chocolatey.org/install.ps1'))

Info

Note: To deploy from your laptop, you must have administrative rights to install the Command Line Interface (CLI), Helm, and Chocolatey (choco).

Typically, the MST team will configure these tools and provide remote access for login and deployment. In this scenario, you will not need to configure the CLI, Helm, and Chocolatey yourself.

...

3. Database Configuration

  1. Database Setup:

    • Create the connection from the workbench.

    • Verify the DB user provided by Connectria.

    • Create the database and users. Example command:

      Copy code

      create user '<<customer_name>>productionuser'@'%' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON <<customer_name>>_backend.* TO '<<customer_name>>productionuser'@'%' WITH GRANT OPTION;

For Example:

  • acsSittrainingbackend and acsSittraininglogs are the two databases created.

  • acsSituser is the user created with full privileges over these two databases, and they can grant these privileges to others.

Expand
titleFor details click Here

Using MySQL Workbench to create two databases and a user, along with granting that user privileges to the databases. Here's the breakdown:

  1. Database Creation:

    • acsSittrainingbackend: A database named acsSittrainingbackend is being created.

    • acsSittraininglogs: Another database named acsSittraininglogs is being created.

  2. User Creation:

    • A user named acsSituser is being created with the password 'password'. The SQL command for this is:

      Code Block
      create user 'acsSituser'@'%' IDENTIFIED BY 'password';

    The @'%' part indicates that this user can connect from any host (% is a wildcard for any IP).

  3. Granting Privileges:

    • The user acsSituser is being granted all privileges on the acsSittrainingbackend and acsSittraininglogs databases with the GRANT OPTION. This means the user can perform any action on these databases and also grant the same privileges to other users. The commands used are:

      Code Block
      GRANT ALL PRIVILEGES ON acsSittrainingbackend.* TO 'acsSituser'@'%' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON acsSittraininglogs.* TO 'acsSituser'@'%' WITH GRANT OPTION;

    • These commands provide the user acsSituser full control over both databases, including the ability to read, write, update, delete data, and manage the structure.

...

...

4. YAML and Cluster Setup

  1. Prepare YAML Configuration:

    • Prepare the YAML file as per the client’s license and details provided via email.

    • How to access YAML file - Currently the YAML file is taken from product team and placed at shared location as shown in image below

Info

Note: Create a copy of ACExpress folder with other name and then edit the YAML files to input details

...

  • Update YAML File by changing the Env screat to update database and AIMap Backend update

image-20241010-072508.pngImage Added

Update backend and log details and set static, migration cleanup job to “True”

...

image-20241010-072847.pngImage Added

image-20241010-073533.pngImage Added

  1. AKS Cluster Setup:

    • Add the Bastion IP in the AKS cluster network security settings.

...

5. Helm and Adeptia Connect Installation

...