[BUG] dmdb secret name should not consist of upper case characters

Describe the bug A clear and concise description of what the bug is.

kbcli version
Kubernetes: v1.28.10-gke.1075001
KubeBlocks: 1.0.0-alpha.0
kbcli: 1.0.0-alpha.0

To Reproduce Steps to reproduce the behavior: 1.create cluster cluster yaml

apiVersion: apps.kubeblocks.io/v1alpha1
kind: Cluster
metadata:
  name: dmdb-cluster
  namespace: default
spec:
  # Specifies the behavior when a Cluster is deleted.
  # - `DoNotTerminate`: Prevents deletion of the Cluster. This policy ensures that all resources remain intact.
  # - `Halt`: Deletes Cluster resources like Pods and Services but retains Persistent Volume Claims (PVCs), allowing for data preservation while stopping other operations.
  # - `Delete`: Extends the `Halt` policy by also removing PVCs, leading to a thorough cleanup while removing all persistent data.
  # - `WipeOut`: An aggressive policy that deletes all Cluster resources, including volume snapshots and backups in external storage. This results in complete data removal and should be used cautiously, primarily in non-production environments to avoid irreversible data loss.
  terminationPolicy: Delete
  # Specifies a list of ClusterComponentSpec objects used to define the individual components that make up a Cluster. This field allows for detailed configuration of each component within the Cluster.
  # Note: `shardingSpecs` and `componentSpecs` cannot both be empty; at least one must be defined to configure a cluster.
  # ClusterComponentSpec defines the specifications for a Component in a Cluster.
  componentSpecs:
  - name: dmdb
    componentDef: dmdb-1.0.0-alpha.0
    serviceAccountName: kb-dmdb-cluster
    replicas: 1
    resources:
      limits:
        cpu: '0.5'
        memory: 0.5Gi
      requests:
        cpu: '0.5'
        memory: 0.5Gi
    volumeClaimTemplates:
      - name: data
        spec:
          accessModes:
            - ReadWriteOnce
          resources:
            requests:
              storage: 20Gi

see error

kbcli cluster list
NAME           NAMESPACE   CLUSTER-DEFINITION   VERSION   TERMINATION-POLICY   STATUS   CREATED-TIME                 
dmdb-cluster   default                                    Delete                        Jul 31,2024 16:41 UTC+0800

3.describe cmp

k describe cmp dmdb-cluster-dmdb
Name:         dmdb-cluster-dmdb
Namespace:    default
Labels:       app.kubernetes.io/instance=dmdb-cluster
          app.kubernetes.io/managed-by=kubeblocks
          apps.kubeblocks.io/cluster-uid=f6306932-c1a1-4e0f-aa29-9b5cc8099e23
          apps.kubeblocks.io/component-name=dmdb
          componentdefinition.kubeblocks.io/name=dmdb-1.0.0-alpha.0
Annotations:  kubeblocks.io/generation: 2
API Version:  apps.kubeblocks.io/v1alpha1
Kind:         Component
Metadata:
Creation Timestamp:  2024-07-31T08:41:25Z
Finalizers:
cluster.kubeblocks.io/finalizer
component.kubeblocks.io/finalizer
Generation:  1
Owner References:
API Version:           apps.kubeblocks.io/v1alpha1
Block Owner Deletion:  true
Controller:            true
Kind:                  Cluster
Name:                  dmdb-cluster
UID:                   f6306932-c1a1-4e0f-aa29-9b5cc8099e23
Resource Version:        23148679
UID:                     1917d42c-f32e-4012-956c-e81cf15a2186
Spec:
Comp Def:  dmdb-1.0.0-alpha.0
Replicas:  1
Resources:
Limits:
  Cpu:     500m
  Memory:  512Mi
Requests:
  Cpu:     500m
  Memory:  512Mi
Scheduling Policy:
Affinity:
  Node Affinity:
    Preferred During Scheduling Ignored During Execution:
      Preference:
        Match Expressions:
          Key:       kb-data
          Operator:  In
          Values:
            true
      Weight:  100
Tolerations:
  Effect:            NoSchedule
  Key:               kb-data
  Operator:          Equal
  Value:             true
Service Account Name:  kb-dmdb-cluster
Service Version:       0.1.0
Volume Claim Templates:
Name:  data
Spec:
  Access Modes:
    ReadWriteOnce
  Resources:
    Requests:
      Storage:  20Gi
Events:
Type     Reason   Age                 From                  Message
----     ------   ----                ----                  -------
Warning  Warning  25s (x14 over 66s)  component-controller  Secret "dmdb-cluster-dmdb-account-MONITOR" is invalid: metadata.name: Invalid value: "dmdb-cluster-dmdb-account-MONITOR": a lowercase RFC 1123 subdomain must consist of lower case alphanumeric characters, '-' or '.', and must start and end with an alphanumeric character (e.g. 'example.com', regex used for validation is '[a-z0-9]([-a-z0-9]*[a-z0-9])?(\.[a-z0-9]([-a-z0-9]*[a-z0-9])?)*')

Expected behavior A clear and concise description of what you expected to happen.

Screenshots If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

OS: [e.g. iOS]
Browser [e.g. chrome, safari]
Version [e.g. 22]

Additional context Add any other context about the problem here.

apecloud / kubeblocks

[BUG] dmdb secret name should not consist of upper case characters #7906