When you have completed the preparations you can proceed to install Usage Engine Private Edition.
Main Installation Example
In this main installation example, it is assumed that the following optional resources have been added while preparing for the installation (see Kubernetes Cluster Add-ons - OCI (4.2)):
ingress-nginx-controller
cert-manager
Example Certificate
Since cert-manager is being used to provide TLS to the Usage Engine Private Edition installation in this example, you need to create an issuer to generate the required certificate.
In this example, we are going to use an ACME issuer type that is configured to match the Kubernetes cluster that was set up previously in the Preparations - OCI (4.2) chapter:
apiVersion: cert-manager.io/v1 kind: ClusterIssuer metadata: name: example-issuer spec: acme: # The ACME server URL server: https://acme-v02.api.letsencrypt.org/directory # Email address used for ACME registration # You must replace this email address with your own. # Let's Encrypt will use this to contact you about expiring # certificates, and issues related to your account. email: <your valid email address> # Name of a secret used to store the ACME account private key privateKeySecretRef: name: example-issuer-account-key solvers: - dns01: webhook: groupName: acme.d-n.be solverName: oci config: ociProfileSecretName: oci-profile
A few things that should be noted:
Set
email
to your email address of choice.The
oci-profile
is the credential to access Oracle Cloud Infrastructure API. If you choose another name for the secret thanoci-profile
, ensure you modify the value ofociProfileSecretName
in theClusterIssuer
.
Create a yaml file named oci-profile.yaml. The secret oci-profile
should look like this:
apiVersion: v1 kind: Secret metadata: name: oci-profile type: Opaque stringData: tenancy: <tenancy_ocid from terraform output> user: <user_ocid configured in terraform.tfvars> region: <region from terraform output> fingerprint: <fingerprint configured in terraform.tfvars> privateKey: | -----BEGIN RSA PRIVATE KEY----- ...KEY DATA HERE... -----END RSA PRIVATE KEY----- privateKeyPassphrase: "private keys passphrase or empty string if none"
Create the secret prior to ClusterIssuer creation. To install secret oci-profile
to cert-manager namespace run the following command:
kubectl apply -f oci-profile.yaml -n cert-manager
Assuming that the issuer spec above has been saved into a file called example-issuer.yaml
, you can create it by running the following command:
kubectl apply -f example-issuer.yaml
Load Balancer TLS Certificate
With ClusterIssuer setup properly, we can proceed to generate TLS Certificate and import into OCI Certificates Service.
To generate certificate, create a yaml file named certificate.yaml
with the following contents:
apiVersion: cert-manager.io/v1 kind: Certificate metadata: name: lb-cert spec: commonName: <cluster_dns_zone_name from terraform output> dnsNames: - <cluster_dns_zone_name from terraform output> - desktop-online.<cluster_dns_zone_name from terraform output> - platform.<cluster_dns_zone_name from terraform output> - ingress.<cluster_dns_zone_name from terraform output> - grafana.<cluster_dns_zone_name from terraform output> issuerRef: kind: ClusterIssuer name: example-issuer secretName: lb-cert
Execute the yaml file by running the following command:
kubectl apply -f certificate.yaml -n uepe
Wait for a while and confirm that the certificate has been generated successfully by running the following command:
kubectl get certificate -n uepe
The output will show that the certificate named
lbcert
’s status is ready
NAME READY SECRET AGE lb-cert True lb-cert 46h
Extract the server certificate and CA certificate from secret
lbcert
by running the following command:
kubectl get secrets lb-cert -n uepe -o yaml | yq '.data' | grep "tls.crt" | awk -F : '{print $2}'| tr -d " "|base64 -d > tls.crt
Separate server certificate and CA certificate into two files by running the following command:
csplit tls.crt '/^-----BEGIN CERTIFICATE-----$/'
Rename first generated file as server certificate file by running the following command:
mv xx00 tls.crt
Rename second generated file as CA certificate file by running the following command:
mv xx01 ca.crt
Extract the private key from secret
lbcert
by running the following command:
kubectl get secrets lb-cert -n uepe -o yaml | yq '.data' | grep "tls.key" | awk -F : '{print $2}'| tr -d " "|base64 -d > tls.key
The server certificate, CA certificate and private key are now stored in tls.crt
, ca.crt
and tls.key
respectively. The next step is to import them into the OCI Certificates Service.
Note!
You do not need to import the server certificate, CA certificate and private key into the OCI Certificate Service anymore if OCI Native Ingress controller version 1.3.8 and above is installed. The load balancer TLS certificate can be obtained from Ingress secret internally.
This helm chart property oci.certificates.enabled
must then be set to false
when following the Install Helm Chart section. The helm chart property oci.certificates.id
can be omitted.
Skip the next section and proceed to TLS Backendset Secret section.
Import into OCI Certificates Service
Go to the OCI console management and search for Certificates service. On the Certificates service page, click Create Certificate and follow these steps:
Select Certificate Type Imported and key in a unique name.
Click Next to go to Certificate Configuration page.
Upload the
tls.crt
,ca.crt
andtls.key
files according to table below:
OCI Certificates Configuration | file to upload |
---|---|
Certificate |
|
Certificate Chain |
|
Private Key |
|
Click Next and proceed to Create Certificate.
Wait for the certificate to be created.
Copy and save the certificate’s ocid. This ocid will be set to the
oci.certificates.id
property in the helm chart value file in the next section.
TLS Backendset Secret
The SSL configuration between the load balancer and the backend servers (worker nodes) in the backend set is known as backend SSL. In this case, the backend set is referring to the Platform Pod on the worker nodes. To implement backend SSL, store the SSL certificates and private key in the form of a Kubernetes secret.
The CA certificate and private key generated from the previous section can be reused to generate the Kubernetes secret needed by the backend set.
To store the certificate and the private key as a secret in Kubernetes, run the following command:
kubectl create secret generic ca-ser-secret -n uepe --from-file=tls.crt=tls.crt --from-file=tls.key=tls.key --from-file=ca.crt=ca.crt
The backend set secret named ca-ser-secret
has now been created in the namespace uepe
.
Note!
These secret names ca-ser-secret
and lb-cert
are default secret names used internally in the Usage Engine Private Edition helm chart. If you intend to use a different secret name, these helm chart properties MUST be set in uepe-values.yaml
:
oci.loadbalancer.secret=lb-cert-<cluster-name>
oci.loadbalancer.backendsetSecret=ca-ser-secret-<cluster-name>
Install Helm Chart
Although the number of helm value combinations to set is virtually endless, there are some values should practically always be set.
Start by creating a file called uepe-values.yaml
, and in that file, specify a minimal set of values that will serve as a good starting point:
In the example below, it is assumed that you have configured the Postgres admin password through a secret. If you have not done so, see https://infozone.atlassian.net/wiki/spaces/UEPE4D/pages/211091666/Usage+Engine+Private+Edition+Preparations+-+OCI+4.2#Bootstrapping-System-Credentials-%5BinlineExtension%5D for guidance.
oci: certificates: enabled: false backendNSG: <backend_nsg from terraform output> healthcheck: desktoponline: port: 9001 ingressnginx: port: 443 environment: oci global: domain: <cluster_dns_zone_name from terraform output> ingressController: serviceName: ingress-nginx-controller imagePullSecrets: - name: ecr-cred licenseKey: <insert-your-license-key-string-here> log: format: json platform: db: type: postgresql tls: cert: public: certManager certManager: public: issuer: kind: ClusterIssuer name: example-issuer enabled: true postgres: adminUsername: postgres host: <db_endpoint from > port: <db_port from terraform output> persistence: enabled: true existingClaim: fss-pvc
Below you can find information on how you can determine the values to set in your particular installation:
Value | Comment |
---|---|
| This value indicates if you to use OCI SSL certificate or Kubernetes secret for Load Balancer SSL termination. The default value is Set it to |
| This value should be set to match the ocid of certificate created in previous section, Import-into-OCI-Certificates-Service. This value is not in used if |
| This value is taken from the |
| This is the desktop-online backend set health check port, 9001. |
| This is the ingress nginx backend set health check port, 443. |
| This is the name of the Kubernetes |
| This value is taken from the |
| This is referencing an image pull secret containing the credentials required in order to pull container images from the DigitalRoute AWS ECR registry. If you are hosting the container images in your own container registry, another image pull secret might be needed, depending on how it is configured. See General Usage Engine Private Edition Preparations (4.2) for additional information. |
| This is the license key that can be found in the |
| If you need to use dedicated log collection and monitoring tools like Fluent-bit, Elasticsearch, Kibana or AWS CloudWatch for Usage Engine Private Edition, ensure that the log format is configured to |
| These values are set to use the example issuer created at the beginning of this page. This should only be seen as an example and the values should be adjusted according to the real world scenario. |
| This value is taken from the |
| This value is taken from the |
| This value is taken from the |
| The persistent volume claim name created in previous section OCI-Add-ons | oci-file-service-storage | Static Provisioning. Ignore if |
General information about the values above is provided in the values.yaml
file in the usage-engine-private-edition
helm chart.
In the example presented below, the following assumptions have been made:
PostgreSQL is used as the system database.
You have previously bootstrapped the
postgresqlPassword
secret key with a value equal to thedb_password
configured in theterraform.tfvars
file. See https://infozone.atlassian.net/wiki/spaces/UEPE4D/pages/211091666/Usage+Engine+Private+Edition+Preparations+-+OCI+4.2#Bootstrapping-System-Credentials-%5BinlineExtension%5D for instructions.The system database is automatically created during installation.
jdbcPassword
andmzownerPassword
are randomly generated.postgresqlPassword
/oraclePassword
/saphanaPassword
are not randomly generated and must therefore be created as secret as described in point 3.If you are using the database tool
uepe-sys-db-tool.jar
to create the system database manually, ensure that the credentials mentioned in point 5 and 6 are included in the secret. For more details, see https://infozone.atlassian.net/wiki/spaces/UEPE4D/pages/211091666/Usage+Engine+Private+Edition+Preparations+-+OCI+4.2#Bootstrapping-System-Credentials-%5BinlineExtension%5D.
You can use the following command to install Usage Engine Private Edition:
helm install uepe digitalroute/usage-engine-private-edition --version <version> -f uepe-values.yaml -n uepe
Where <version>
is the version of Usage Engine Private Edition to install, for example 4.0.0
.
Check that all pods are running and that all pod containers become ready by running the following command:
kubectl get pods -w -n uepe NAME READY STATUS RESTARTS AGE desktop-online-5fdd4df85b-5hc6z 1/1 Running 0 97m external-dns-54fb5cb46b-4lfld 1/1 Running 0 27h ingress-nginx-controller-7477648b4c-sz2nw 1/1 Running 0 27h oci-native-ingress-controller-6cd8cf8d79-dz8zp 1/1 Running 0 29h platform-0 1/1 Running 0 97m uepe-operator-controller-manager-69c4b499c8-h9l8w 2/2 Running 0 97m uepe-operator-controller-manager-69c4b499c8-hxdcb 2/2 Running 0 97m
This may take a little while
To get the Desktop Online web user interface hostname run the following command:
kubectl get ingress -n uepe
The output shows the FQDN hostname, IP address and port to access the desktop online user interface.
NAME CLASS HOSTS ADDRESS PORTS AGE desktop-online native-ic-ingress-class desktop-online.example-cluster.stratus.oci.digitalroute.net 130.162.252.220 80 99m ingress-nginx-controller native-ic-ingress-class ingress.example-cluster.stratus.oci.digitalroute.net 130.162.252.220 80 99m
You should now be able to access the Desktop Online user interface at: Note! If you want to connect Usage Engine Private Edition to the Desktop Client, you need to modify the
https://desktop-online.example-cluster.stratus.oci.digitalroute.net/
It may take a little while before the DNS record gets registered.To get the Platform web interface hostname run the following command:kubectl get service platform -n uepe -o jsonpath="{.metadata.annotations.external-dns\.alpha\.kubernetes\.io/hostname}"
pico.rcp.platform.port
value to 6790 in the Configuration l Properties tab after having added the instance via Platform FQDN hostname in Desktop Launcher.
Other Common Installation Configurations
Bellow are a few common installation configurations for the Usage Engine Private Edition helm chart.
They should be seen as variations to the main installation example outlined above.
Persistent File Storage
If you have selected to prepare for persistent file storage, there are two different ways of configuring your Usage Engine Private Edition installation to use it.
Use Bundled OCI Specific PVC
Specifically for OCI, the Usage Engine Private Edition helm chart contains a bundled persistent volume claim. This persistent volume claim is using the fss-dyn-storage
storage class. To enable it, set the following helm values:
persistence: enabled: true bundledClaim: storageRequest: "10Gi"
Where the persistence.bundledClaim.storageRequest
value is used to control the size of the requested storage (default is 1Gi).
You can use the following command to inspect the persistent volume claim that gets created as a result of setting the above helm values:
kubectl get persistentvolumeclaims mz-bundled-pvc -o yaml
Reference Arbitrary PVC
Usage Engine Private Edition can be configured to reference an arbitrary persistent volume claim by setting the following helm values:
persistence: enabled: true existingClaim: my-pvc
In this example, my-pvc
is an arbitrary persistent volume claim that you have created before hand.
If you are hosting the Usage Engine Private Edition container images in your own container registry (see https://infozone.atlassian.net/wiki/spaces/UEPE4D/pages/277676052/General+Usage+Engine+Private+Edition+Preparations+4.2#Hosting-Container-Images-in-Your-Own-Container-Registry), then the following helm values are required: If you have opted for placing the system database in Oracle rather than PostgreSQL, it is assumed that the system database has already been created using the system database tool (see https://infozone.atlassian.net/wiki/spaces/UEPE4D/pages/277676052/General+Usage+Engine+Private+Edition+Preparations+4.2#System-Database-%5BinlineExtension%5D). Then, when installing the Usage Engine Private Edition helm chart, make sure to set the following helm values: Additional information on how you can determine the values to set in your particular installation: Value Comment The name of a custom container image containing the following Oracle software: https://download.oracle.com/otn-pub/otn_software/jdbc/1923/ojdbc8.jar The Usage Engine Private Edition helm values file contains instructions on how to build this custom container image. Look for the The domain name of the Oracle database service. The port of the Oracle database service. The name of the Usage Engine Private Edition database that was created in Oracle. Note! None of the Container Images Hosted in Your Own Container Registry
platform:
repository: <the repository where the platform image is hosted>
operator:
repository: <the repository repo where the operator image is hosted>
desktopOnline:
repository: <the repository repo where the ui image is hosted>
System Database in Oracle
extensions:
enabled: true
image: my-uepe-extensions:1.0.0 # see additional information below on how to set this value
oracle:
host: oracle # see additional information below on how to set this value
port: 1521 # see additional information below on how to set this value
db: UEPE # see additional information below on how to set this value
expressEdition: false
platform:
db:
type: oracle
extensions.image
extensions
value to locate the instructions.oracle.host
oracle.port
oracle.db
postgres.*
values outlined in the main installation example are required when opting for placing the system database in Oracle.