---
apiVersion: v1
kind: Pod
metadata:
  annotations:
    k8s.ovn.org/pod-networks: '{"default":{"ip_addresses":["10.128.0.212/23"],"mac_address":"0a:58:0a:80:00:d4","gateway_ips":["10.128.0.1"],"routes":[{"dest":"10.128.0.0/16","nextHop":"10.128.0.1"},{"dest":"172.30.0.0/16","nextHop":"10.128.0.1"},{"dest":"169.254.0.5/32","nextHop":"10.128.0.1"},{"dest":"100.64.0.0/16","nextHop":"10.128.0.1"}],"ip_address":"10.128.0.212/23","gateway_ip":"10.128.0.1","role":"primary"}}'
    k8s.v1.cni.cncf.io/network-status: |-
      [{
          "name": "ovn-kubernetes",
          "interface": "eth0",
          "ips": [
              "10.128.0.212"
          ],
          "mac": "0a:58:0a:80:00:d4",
          "default": true,
          "dns": {}
      }]
    openshift.io/scc: anyuid
  creationTimestamp: "2026-02-20T15:17:08Z"
  generateName: ironic-280d-account-create-update-
  labels:
    batch.kubernetes.io/controller-uid: 2a9bb72e-fd5d-478d-b89d-eec837479d2a
    batch.kubernetes.io/job-name: ironic-280d-account-create-update
    controller-uid: 2a9bb72e-fd5d-478d-b89d-eec837479d2a
    job-name: ironic-280d-account-create-update
  managedFields:
  - apiVersion: v1
    fieldsType: FieldsV1
    fieldsV1:
      f:metadata:
        f:generateName: {}
        f:labels:
          .: {}
          f:batch.kubernetes.io/controller-uid: {}
          f:batch.kubernetes.io/job-name: {}
          f:controller-uid: {}
          f:job-name: {}
        f:ownerReferences:
          .: {}
          k:{"uid":"2a9bb72e-fd5d-478d-b89d-eec837479d2a"}: {}
      f:spec:
        f:containers:
          k:{"name":"mariadb-account-create-update"}:
            .: {}
            f:command: {}
            f:env:
              .: {}
              k:{"name":"DatabasePassword"}:
                .: {}
                f:name: {}
                f:valueFrom:
                  .: {}
                  f:secretKeyRef: {}
            f:image: {}
            f:imagePullPolicy: {}
            f:name: {}
            f:resources: {}
            f:terminationMessagePath: {}
            f:terminationMessagePolicy: {}
            f:volumeMounts:
              .: {}
              k:{"mountPath":"/var/lib/operator-scripts"}:
                .: {}
                f:mountPath: {}
                f:name: {}
                f:readOnly: {}
        f:dnsPolicy: {}
        f:enableServiceLinks: {}
        f:restartPolicy: {}
        f:schedulerName: {}
        f:securityContext: {}
        f:serviceAccount: {}
        f:serviceAccountName: {}
        f:terminationGracePeriodSeconds: {}
        f:volumes:
          .: {}
          k:{"name":"operator-scripts"}:
            .: {}
            f:configMap:
              .: {}
              f:defaultMode: {}
              f:items: {}
              f:name: {}
            f:name: {}
    manager: kube-controller-manager
    operation: Update
    time: "2026-02-20T15:17:08Z"
  - apiVersion: v1
    fieldsType: FieldsV1
    fieldsV1:
      f:metadata:
        f:annotations:
          f:k8s.ovn.org/pod-networks: {}
    manager: master-0
    operation: Update
    subresource: status
    time: "2026-02-20T15:17:08Z"
  - apiVersion: v1
    fieldsType: FieldsV1
    fieldsV1:
      f:metadata:
        f:annotations:
          f:k8s.v1.cni.cncf.io/network-status: {}
    manager: multus-daemon
    operation: Update
    subresource: status
    time: "2026-02-20T15:17:09Z"
  - apiVersion: v1
    fieldsType: FieldsV1
    fieldsV1:
      f:status:
        f:conditions:
          k:{"type":"ContainersReady"}:
            .: {}
            f:lastProbeTime: {}
            f:lastTransitionTime: {}
            f:reason: {}
            f:status: {}
            f:type: {}
          k:{"type":"Initialized"}:
            .: {}
            f:lastProbeTime: {}
            f:lastTransitionTime: {}
            f:reason: {}
            f:status: {}
            f:type: {}
          k:{"type":"PodReadyToStartContainers"}:
            .: {}
            f:lastProbeTime: {}
            f:lastTransitionTime: {}
            f:status: {}
            f:type: {}
          k:{"type":"Ready"}:
            .: {}
            f:lastProbeTime: {}
            f:lastTransitionTime: {}
            f:reason: {}
            f:status: {}
            f:type: {}
        f:containerStatuses: {}
        f:hostIP: {}
        f:hostIPs: {}
        f:phase: {}
        f:podIP: {}
        f:podIPs:
          .: {}
          k:{"ip":"10.128.0.212"}:
            .: {}
            f:ip: {}
        f:startTime: {}
    manager: kubelet
    operation: Update
    subresource: status
    time: "2026-02-20T15:17:16Z"
  name: ironic-280d-account-create-update-6drk5
  namespace: openstack
  ownerReferences:
  - apiVersion: batch/v1
    blockOwnerDeletion: true
    controller: true
    kind: Job
    name: ironic-280d-account-create-update
    uid: 2a9bb72e-fd5d-478d-b89d-eec837479d2a
  resourceVersion: "32238"
  uid: a459ddfe-81df-4abd-867d-1ea8ed2f0c95
spec:
  containers:
  - command:
    - /bin/sh
    - -c
    - |
      #!/bin/bash

      MYSQL_REMOTE_HOST="openstack.openstack.svc" source /var/lib/operator-scripts/mysql_root_auth.sh

      export DatabasePassword=${DatabasePassword:?"Please specify a DatabasePassword variable."}

      MYSQL_CMD="mysql -h openstack.openstack.svc -u root -P 3306"

      if [ -n "ironic" ]; then
          GRANT_DATABASE="ironic"
      else
          GRANT_DATABASE="*"
      fi

      # going for maximum compatibility here:
      # 1. MySQL 8 no longer allows implicit create user when GRANT is used
      # 2. MariaDB has "CREATE OR REPLACE", but MySQL does not
      # 3. create user with CREATE but then do all password and TLS with ALTER to
      #    support updates

      $MYSQL_CMD <<EOF
      CREATE USER IF NOT EXISTS 'ironic_280d'@'localhost';
      CREATE USER IF NOT EXISTS 'ironic_280d'@'%';

      ALTER USER 'ironic_280d'@'localhost' IDENTIFIED BY '$DatabasePassword';
      ALTER USER 'ironic_280d'@'%'  IDENTIFIED BY '$DatabasePassword';

      GRANT ALL PRIVILEGES ON ${GRANT_DATABASE}.* TO 'ironic_280d'@'localhost';
      GRANT ALL PRIVILEGES ON ${GRANT_DATABASE}.* TO 'ironic_280d'@'%';
      EOF

      # If we just changed the root password, update MYSQL_CMD to use the new password
      if [ "ironic_280d" = "root" ]; then
          MYSQL_CMD="mysql -h openstack.openstack.svc -u root -p${DatabasePassword} -P 3306"
      fi

      # search for the account.  not using SHOW CREATE USER to avoid displaying
      # password hash
      username=$($MYSQL_CMD -NB -e "select user from mysql.user where user='ironic_280d' and host='localhost';" )

      if [[ ${username} != "ironic_280d" ]]; then
          exit 1
      fi
    env:
    - name: DatabasePassword
      valueFrom:
        secretKeyRef:
          key: DatabasePassword
          name: ironic-db-secret
    image: quay.io/podified-antelope-centos9/openstack-mariadb@sha256:0f7943e02fbdd3daec1d3db72fa9396bf37ad3fdd6b0f3119c90e29629e095ed
    imagePullPolicy: IfNotPresent
    name: mariadb-account-create-update
    resources: {}
    securityContext:
      capabilities:
        drop:
        - MKNOD
    terminationMessagePath: /dev/termination-log
    terminationMessagePolicy: File
    volumeMounts:
    - mountPath: /var/lib/operator-scripts
      name: operator-scripts
      readOnly: true
    - mountPath: /var/run/secrets/kubernetes.io/serviceaccount
      name: kube-api-access-wwkhw
      readOnly: true
  dnsPolicy: ClusterFirst
  enableServiceLinks: true
  nodeName: master-0
  preemptionPolicy: PreemptLowerPriority
  priority: 0
  restartPolicy: OnFailure
  schedulerName: default-scheduler
  securityContext:
    seLinuxOptions:
      level: s0:c28,c22
  serviceAccount: galera-openstack
  serviceAccountName: galera-openstack
  terminationGracePeriodSeconds: 30
  tolerations:
  - effect: NoExecute
    key: node.kubernetes.io/not-ready
    operator: Exists
    tolerationSeconds: 300
  - effect: NoExecute
    key: node.kubernetes.io/unreachable
    operator: Exists
    tolerationSeconds: 300
  volumes:
  - configMap:
      defaultMode: 420
      items:
      - key: mysql_root_auth.sh
        path: mysql_root_auth.sh
      name: openstack-scripts
    name: operator-scripts
  - name: kube-api-access-wwkhw
    projected:
      defaultMode: 420
      sources:
      - serviceAccountToken:
          expirationSeconds: 3607
          path: token
      - configMap:
          items:
          - key: ca.crt
            path: ca.crt
          name: kube-root-ca.crt
      - downwardAPI:
          items:
          - fieldRef:
              apiVersion: v1
              fieldPath: metadata.namespace
            path: namespace
      - configMap:
          items:
          - key: service-ca.crt
            path: service-ca.crt
          name: openshift-service-ca.crt
status:
  conditions:
  - lastProbeTime: null
    lastTransitionTime: "2026-02-20T15:17:16Z"
    status: "False"
    type: PodReadyToStartContainers
  - lastProbeTime: null
    lastTransitionTime: "2026-02-20T15:17:08Z"
    reason: PodCompleted
    status: "True"
    type: Initialized
  - lastProbeTime: null
    lastTransitionTime: "2026-02-20T15:17:11Z"
    reason: PodCompleted
    status: "False"
    type: Ready
  - lastProbeTime: null
    lastTransitionTime: "2026-02-20T15:17:11Z"
    reason: PodCompleted
    status: "False"
    type: ContainersReady
  - lastProbeTime: null
    lastTransitionTime: "2026-02-20T15:17:08Z"
    status: "True"
    type: PodScheduled
  containerStatuses:
  - containerID: cri-o://ba6576013676e6b966c373c174f1b95e55f59f91b3126091070256173121b9c4
    image: quay.io/podified-antelope-centos9/openstack-mariadb@sha256:0f7943e02fbdd3daec1d3db72fa9396bf37ad3fdd6b0f3119c90e29629e095ed
    imageID: quay.io/podified-antelope-centos9/openstack-mariadb@sha256:0f7943e02fbdd3daec1d3db72fa9396bf37ad3fdd6b0f3119c90e29629e095ed
    lastState: {}
    name: mariadb-account-create-update
    ready: false
    restartCount: 0
    started: false
    state:
      terminated:
        containerID: cri-o://ba6576013676e6b966c373c174f1b95e55f59f91b3126091070256173121b9c4
        exitCode: 0
        finishedAt: "2026-02-20T15:17:10Z"
        reason: Completed
        startedAt: "2026-02-20T15:17:10Z"
    volumeMounts:
    - mountPath: /var/lib/operator-scripts
      name: operator-scripts
      readOnly: true
      recursiveReadOnly: Disabled
    - mountPath: /var/run/secrets/kubernetes.io/serviceaccount
      name: kube-api-access-wwkhw
      readOnly: true
      recursiveReadOnly: Disabled
  hostIP: 192.168.32.10
  hostIPs:
  - ip: 192.168.32.10
  phase: Succeeded
  podIP: 10.128.0.212
  podIPs:
  - ip: 10.128.0.212
  qosClass: BestEffort
  startTime: "2026-02-20T15:17:08Z"