---
apiVersion: v1
kind: Pod
metadata:
  annotations:
    k8s.ovn.org/pod-networks: '{"default":{"ip_addresses":["10.128.0.205/23"],"mac_address":"0a:58:0a:80:00:cd","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.205/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.205"
          ],
          "mac": "0a:58:0a:80:00:cd",
          "default": true,
          "dns": {}
      }]
    openshift.io/scc: anyuid
  creationTimestamp: "2026-02-23T13:28:25Z"
  generateName: ironic-dc5b-account-create-update-
  labels:
    batch.kubernetes.io/controller-uid: 4311f4be-3074-4860-8f51-f6e100da774d
    batch.kubernetes.io/job-name: ironic-dc5b-account-create-update
    controller-uid: 4311f4be-3074-4860-8f51-f6e100da774d
    job-name: ironic-dc5b-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":"4311f4be-3074-4860-8f51-f6e100da774d"}: {}
      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-23T13:28:25Z"
  - 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-23T13:28:25Z"
  - 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-23T13:28:26Z"
  - 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.205"}:
            .: {}
            f:ip: {}
        f:startTime: {}
    manager: kubelet
    operation: Update
    subresource: status
    time: "2026-02-23T13:28:32Z"
  name: ironic-dc5b-account-create-update-t78mz
  namespace: openstack
  ownerReferences:
  - apiVersion: batch/v1
    blockOwnerDeletion: true
    controller: true
    kind: Job
    name: ironic-dc5b-account-create-update
    uid: 4311f4be-3074-4860-8f51-f6e100da774d
  resourceVersion: "30069"
  uid: 5a9ec263-54d6-4981-9127-e9bd62d1cf7d
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_dc5b'@'localhost';
      CREATE USER IF NOT EXISTS 'ironic_dc5b'@'%';

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

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

      # If we just changed the root password, update MYSQL_CMD to use the new password
      if [ "ironic_dc5b" = "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_dc5b' and host='localhost';" )

      if [[ ${username} != "ironic_dc5b" ]]; then
          exit 1
      fi
    env:
    - name: DatabasePassword
      valueFrom:
        secretKeyRef:
          key: DatabasePassword
          name: ironic-db-secret
    image: quay.io/podified-antelope-centos9/openstack-mariadb@sha256:bafa959fd4a24c80de0c6b1c5adbf2b44992312068ca741c6a0717d49c919658
    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-bxq7g
      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-bxq7g
    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-23T13:28:32Z"
    status: "False"
    type: PodReadyToStartContainers
  - lastProbeTime: null
    lastTransitionTime: "2026-02-23T13:28:25Z"
    reason: PodCompleted
    status: "True"
    type: Initialized
  - lastProbeTime: null
    lastTransitionTime: "2026-02-23T13:28:28Z"
    reason: PodCompleted
    status: "False"
    type: Ready
  - lastProbeTime: null
    lastTransitionTime: "2026-02-23T13:28:28Z"
    reason: PodCompleted
    status: "False"
    type: ContainersReady
  - lastProbeTime: null
    lastTransitionTime: "2026-02-23T13:28:25Z"
    status: "True"
    type: PodScheduled
  containerStatuses:
  - containerID: cri-o://7b2da3601c5b7e5e4d8df48c98d082a05db7cec1946e464dfd133aee3377e71e
    image: quay.io/podified-antelope-centos9/openstack-mariadb@sha256:bafa959fd4a24c80de0c6b1c5adbf2b44992312068ca741c6a0717d49c919658
    imageID: quay.io/podified-antelope-centos9/openstack-mariadb@sha256:bafa959fd4a24c80de0c6b1c5adbf2b44992312068ca741c6a0717d49c919658
    lastState: {}
    name: mariadb-account-create-update
    ready: false
    restartCount: 0
    started: false
    state:
      terminated:
        containerID: cri-o://7b2da3601c5b7e5e4d8df48c98d082a05db7cec1946e464dfd133aee3377e71e
        exitCode: 0
        finishedAt: "2026-02-23T13:28:27Z"
        reason: Completed
        startedAt: "2026-02-23T13:28:27Z"
    volumeMounts:
    - mountPath: /var/lib/operator-scripts
      name: operator-scripts
      readOnly: true
      recursiveReadOnly: Disabled
    - mountPath: /var/run/secrets/kubernetes.io/serviceaccount
      name: kube-api-access-bxq7g
      readOnly: true
      recursiveReadOnly: Disabled
  hostIP: 192.168.32.10
  hostIPs:
  - ip: 192.168.32.10
  phase: Succeeded
  podIP: 10.128.0.205
  podIPs:
  - ip: 10.128.0.205
  qosClass: BestEffort
  startTime: "2026-02-23T13:28:25Z"