Deploying OpenIAM on AKS (Kubernetes) with an external MSSQL database

Pre-requisite planning for the deployment

  1. Review your access and check infrastructure requirements. Hence, for AKS cluster access:
  • Make sure OpenIAM team has access to the AKS cluster, as it required for proper functioning.
  • Since access is going through the VDI infrastructure, please provide a connection steps and authentication methods.
  • Please confirm if kubectl access is allowed directly, or whether it must go through jump hosts.
  • Please install
    • DNS name for the OpenIAM host;
    • SSL Certificate for use by OpenIAM.
  1. Check the internet connectivity requirements.

To support the deployment of OpenIAM on AKS, the environment must allow internet connectivity for installing essential utilities. These tools can typically be installed using standard Linux package managers (yum, dnf, or apt), or manually from their official websites if required. Please ensure that the firewall and proxy policies allow outbound HTTPS access to the domains listed below, based on your preferred installation method.

ToolPurposeLinux Package Repository (Domain)Manual Download URL
TerraformInfrastructure provisioningrpm.releases.hashicorp.com or apt.releases.hashicorp.comhttps://developer.hashicorp.com/terraform/downloads
HelmKubernetes package managerbaltocdn.comhttps://helm.sh/docs/intro/install/
kubectlKubernetes CLI toolpackages.cloud.google.com, apt.kubernetes.io, or yum.kubernetes.iohttps://kubernetes.io/docs/tasks/tools/install-kubectl/
GitVersion controlmirror.centos.org, archive.ubuntu.com, security.ubuntu.comhttps://git-scm.com/downloads
Note: If the environment has restricted internet access, consider mirroring these repositories internally or working with your IT/security teams to whitelist the above domains.
  1. Providing access to code and repository.

As OpenIAM Terraform scripts are hosted on Bitbucket, please ensure access to Git repository at https://bitbucket.org/openiam. Additionally, as Docker images will be pulled from OpenIAM private container registry, please allow an outbound HTTPS access to the registry at https://confidant-bhaskara.container-registry.com.

  1. Service accounts and permissions

MS SQL server account is required to create and manage the OpenIAM and Activiti schemas via Flyway. It must satisfy the following requirements.

  • It cannot be a Windows-authenticated account.
  • Permissions needed:
    • Creating a database.
    • Creating/modifying tables, indexes, views, procedures.
    • Running Flyway migrations.

Moreover, please confirm that OpenIAM is certified on SQL Server 2019. If SQL Server 2022 is used, OpenIAM will first test compatibility in its lab.

For Active Directory (AD) service account to connect to the AD domain and to integrate OpenIAM with your AD environment OpenIAM requires host information. The following permissions are also needed.

  • Read access to directory objects (users, groups, OUs).
  • Write access if provisioning/deprovisioning is required.

Access

Finally, to send email notifications from OpenIAM, the SMTP details are to be provided.

  1. Network & access validation

The following network paths must be validated to ensure proper communication between OpenIAM components, the Windows Connector VM, Active Directory, and Microsoft SQL Server. Please ensure all listed ports are open and accessible from the relevant components.

SourceDestinationPort(s)Purpose
AKS Pods (OpenIAM)Windows Connector VM5672RabbitMQ communication.
Windows Connector VMActive Directory?WinRM communication to AD using PowerShell.
OpenIAM ComponentsMS SQL Server?Which port is being used by Manpower?
Additional notes:
  • OpenIAM will test connectivity and DNS resolution during setup.
  • Ensure the Windows Connector VM is domain-joined if using integrated AD authentication.

Installing OpenIAM

Install OpenIAM to the AKS cluster, using the steps described in this document

While installing, ensure to

  • Setup the DNS name.
  • Install the SSL cert provided MPG.
  • Install the AD connector.
  • Setup connectivity between AD and OpenIAM.
  • Configure the SMTP integration with OpenIAM.

Replicating the OpenIAM container registry to the registry at MPG

For OpenIAM team to replicate the OpenIAM container registry to another container registry at MPG, users need to provide connectivity details to the MPG repository and OpenIAM is to create a script to replicate the images.