Logo

Menu

戴志强1
Published on 2026-01-13 / 18 Visits
0
0

启动idme并获取ESN以便申请授权证书

启动idme并获取ESN以便申请授权证书

1. 上传idme相关的镜像

docker push 192.168.5.46:5000/common/idme/xdm-service:2.25.100.17.20260106.1

2. 创建idme关联的数据库

确认数据库的my.cnf 配置，忽略大小写，增大连接池的数量
cat /etc/my.cnf

[root@isc-imom-worker-0011 mysql]# cat my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
# default-authentication-plugin=mysql_native_password
skip-host-cache
skip-name-resolve
datadir=/var/lib/mysql
#socket=/var/run/mysqld/mysqld.sock
secure-file-priv=/var/lib/mysql-files
user=mysql

#pid-file=/var/run/mysqld/mysqld.pid

# 虚拟机搭建一定要挂载单独数据盘，不要用系统盘，要检查数据盘是否有初始化和挂载，可以扩容
skip-name-resolve
explicit_defaults_for_timestamp
max_allowed_packet=16M
character-set-server=UTF8
slow_query_log=1
long_query_time=3.0
# 最大连接数，默认151，最大设置3000
max_connections=1000
interactive_timeout=60
# lower_case_table_names 参数详解：
# 0: 区分大小写
# 1: 不区分大小写
# MySQL在Linux下数据库名、表名、列名、别名大小写规则是这样的：
#   1) 数据库名与表名是严格区分大小写的；
#   2) 表的别名是严格区分大小写的；
#   3) 列名与列的别名在所有情况下均忽略大小写；
#   4) 变量名是严格区分大小写的；
lower_case_table_names=1
# sql_mode: 删除 ONLY_FULL_GROUP_BY
sql_mode=IGNORE_SPACE,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

[client]
#socket=/var/run/mysqld/mysqld.sock

!includedir /etc/mysql/conf.d/

CREATE DATABASE xdm_dev CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
CREATE DATABASE xdm_dev_ssf CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;

3. 编辑idme相关的k8s配置

重点修改RDS, REDIS 的连接配置。

---
kind: ConfigMap
apiVersion: v1
metadata:
  name: idme-config
  namespace: common
  annotations:
    kubesphere.io/creator: lc
    kubesphere.io/description: idme配置项
data:
  application.properties: >-
    APP_IDENTIFIER=e3231ab62e9d4771bd0df793f62d2282

    APP_NAME=SieProMom

    CUSTOM_CODE_WHITELIST=org.springframework.util.CollectionUtils,org.slf4j.*,org.apache.commons.lang3.StringUtils,org.apache.commons.lang3.StringUtils,org.apache.commons.collections4.CollectionUtils,lombok.*,java.util.UUID,java.util.TimeZone,java.util.stream.*,java.util.Stack,java.util.Set,java.util.regex.*,java.util.Random,java.util.Optional,java.util.Objects,java.util.Map,java.util.Locale,java.util.List,java.util.LinkedHashMap,java.util.HashSet,java.util.HashMap,java.util.function.*,java.util.Date,java.util.Collections,java.util.Collection,java.util.Calendar,java.util.Arrays,java.util.ArrayList,java.time.*,java.sql.*,java.security.SecureRandom,java.nio.charset.StandardCharsets,java.math.*,java.lang.Throwable,java.lang.SuppressWarnings,java.lang.StringBuilder,java.lang.StringBuffer,java.lang.String,java.lang.Short,java.lang.Override,java.lang.Object,java.lang.Number,java.lang.Math,java.lang.Long,java.lang.Iterable,java.lang.Integer,java.lang.Float,java.lang.Exception,jjava.lang.Double,java.lang.Comparable,java.lang.Class,java.lang.Character,java.lang.Byte,java.lang.Boolean,java.lang.annotation.*,com.huawei.it.rdm.vo.*,com.huawei.it.rdm.util.common.ApplicationTenantContextUtil,com.huawei.it.rdm.service.exttypemgmt.IXdmTypeDefinitionService,com.huawei.it.rdm.service.extattrmgmt.IXdmEXADefinitionService,com.huawei.it.rdm.service.extattrmgmt.IXdmEXADefinitionLinkService,com.huawei.it.rdm.service.datamodelmgmt.IXdmDataModelService,com.huawei.it.rdm.plugin.*,com.huawei.it.rdm.dto.*,com.huawei.innovation.rdm.xdm.*,com.huawei.innovation.rdm.dto.entity.*,com.huawei.innovation.rdm.coresdk.persistence.*,com.huawei.innovation.rdm.coresdk.extattrmgmt.dto.*,com.huawei.innovation.rdm.coresdk.customservice.util.*,com.huawei.innovation.rdm.coresdk.basic.vo.*,com.huawei.innovation.rdm.coresdk.basic.util.ThreadLocalUtil,com.huawei.innovation.rdm.coresdk.basic.util.context.XDMContextManager,com.huawei.innovation.rdm.coresdk.basic.exception.*,com.huawei.innovation.rdm.coresdk.basic.enums.*,com.huawei.innovation.rdm.coresdk.basic.dto.*,com.huawei.innovation.rdm.bean.*,com.huawei.innovation.rdm.%APP_NAME%.*,com.fasterxml.jackson.databind.ObjectMapper,com.alibaba.fastjson.JSONObject,com.alibaba.fastjson.JSONArray,com.alibaba.fastjson.JSON,com.huawei.innovation.rdm.coresdk.enums.*,com.huawei.innovation.rdm.coresdk.lifecyclemgmt.vo.*

    CUSTOM_SERVICE_EXECUTABLE=true

    CUSTOM_SERVICE_GLOBAL_SWITCH=true

    CUSTOM_SERVICE_MANAGEABLE=true

    CUSTOM_SERVICE_MODIFIABLE=true

    DEPLOY_VERSION=2.25.060.8.20250626.6

    DEPLOY_TIMESTAMP=1754982406

    OLC_CONFIG_PATH=/opt/xdm/olc

    OPEN_IAM_TOKEN_VALIDATION=false

    OPEN_SECOND_LEVEL_CACHE=false

    PAAS_APP_NAME=siepromom

    RDS_DATABASE=xdm_dev

    RDS_IP=192.168.5.177

    RDS_NAME=root

    RDS_PASSWORD=nhdTaVMSAC

    RDS_PORT=3306

    RDS_TYPE=mysql

    REDIS_HOST=sie-redis-sentinel-master-svc.common

    REDIS_PASSWORD=Dme123456

    REDIS_PORT=6379

    REDIS_TYPE=SINGLE

    spring.redis.database=11

    RUNTIME_ENV_TYPE=IES

    SESSION_HMAC_KEY=61232C63DDAA25BA833BAE967F76707CCBCEF5A74255C1A398C977A4C6A0585C

    TENANT_ID=e3231ab62e9d4771bd0df793f62d2282

    XDM_LOGIN_TYPE=LOCAL

    XDM_SDK_DEPLOY_ENABLE=true

    xdm.runtime.java-compile.lib-path=/opt/xdm/lib

    xdm.kafka.init=false

    xdm.mongodb.init=false

    server.servlet.context-path=/rdm_e3231ab62e9d4771bd0df793f62d2282_app/services/

    server.ssl.enabled=false

    ssf.login.local.verifycode.verify-code=false

    ssf.login.logoutUri=http://192.168.168.207:30083/rdm_e3231ab62e9d4771bd0df793f62d2282_app/services/index.html

    ssf.sysmgr.sessionfilter.ignorePattern=/getIndexUrl;/v1/health;/v1/login/login;/v1/login/logout;/v1/login/verifycode;/v1/firstlogin/users;/v1/firstlogin/userpasswords:PUT;/static/**;/index.html;/HuaweiLog.ico;/HuaweiLog.png

    ssf.sysmgr.sessionfilter.loginUrl=LOCAL

    xdm.runtime.tenant.info={"owner":"1","shortName":"SieProMom","codeRepository":null,"dbConn":null,"dbReadOnlyConn":null,"hisDeployUnit":null,"databaseType":"mysql","aliasName":"SITAutotest","hisAppId":null,"tps":1000,"qps":1000,"operationTime":null,"dAMIntegrated":false,"xDMHosted":false,"appNameEn":"SieProMom","certifiedDataSourceNumber":"1","integrationMode":"API","domain":null,"appEnvInfo":"production","metadataSynchronization":false,"codeDownloadPath":"","jarDownloadPath":"","appStatus":1,"domainId":"-1","domainName":"siedme","identifier":"e3231ab62e9d4771bd0df793f62d2282","cloudDragonProjectId":null,"isSyncAstroPro":false,"tenantId":null,"publicKey":null,"privateKey":null,"markForDelete":false,"name":"sie-pro-mom","nameEn":"SieProMom","description":"赛意iDME","descriptionEn":"","id":"e3231ab62e9d4771bd0df793f62d2282","creator":"siedme
    c64af470e27947c68bacb80a093c2072","createTime":"2023-04-06
    11:59:54","modifier":"siedme
    c64af470e27947c68bacb80a093c2072","lastModifiedTime":"2024-03-27 09:36:34"}

    xdm.delegate.bean.inject=false

    xdm.license.deploy-type=CONTAINER

    xdm.tx-distributor.enable=true

    xdm.license.public-key=TODO_TODO_TODO_TODO_TODO_TODO_TODO_TODO_TODO_TODO_TODO_TODO_TODO_TODO_TODO_TODO_TODO_TODO

    xdm.license.init-type=SYSTEM_PATH

    xdm.license.licenseFile=/opt/xdm/license.dat

    xdm.license.runtime.valid-type=LICENSE

    xdm.runtime.transaction-api.limit=50

    xdm.runtime.transaction-api.timeout.seconds=180

    xdm.condition.batch.size=30000


---
kind: Secret
apiVersion: v1
metadata:
  name: idme-license
  namespace: common
  annotations:
    kubesphere.io/creator: lc
data:
  license.dat: >-
    SHVhd2VpIFRlY2hub2xvZ2llcyBDby4sIEx0ZApBbGwgcmlnaHRzIHJlc2VydmVkLgoKTGljZW5zZVNlcmlhbE5vPUxJQzIwMjUwODExRlRTODUwCkNyZWF0b3I9SHVhd2VpIFRlY2hub2xvZ2llcyBDby4sIEx0ZC4KQ3JlYXRlZFRpbWU9MjAyNS0wOC0xMSAxMToxMTo1NgoKQ291bnRyeT1VTktOT1dOCkN1c3RvbT1ObyByZWxldmFudCBjdXN0b21lciBpbmZvcm1hdGlvbgpPZmZpY2U9VU5LTk9XTgpTaWduPSAwQTVBNkMwN0VFRUM4MjU1OTg0QTFDOTNBNkRDRTJCNDU3OTY5NjNFOEYxREY1QzNCNURCMzk3MzBFOTgyMURDQTQ0NzUxMjY5RTZGQjUyQTc3Mzg5ODk4NjZDRTAxOEVEMDBCRjg1RTIyOTk4QTNCRTFFMDE2RjIwQkMzQTAzREY4ODhCQjlDODY5RUFCNEQ4QUVEMDc0OTk4MDc1Njc0RjU2MUJCRDlGNDU0OTg4QTgwMTQ3RjJEOUNBQTA2MDg0RDFERDg0RTU4OTNCNjQwOEU4ODM3MzM1MUY0OTEwMDM2QkM2Q0ZCMDA1Q0MyRjAyOEQyNkJEMDJFOUE1QkM1MEExODg2ODY5NEZGNTFGQzRGMDA3QUY5ODk5OTI1NzYyNUJFMDUwNjdENkEwNUFDQjNDQzc3QTZBRjhFNTI5M0ZEQUYxOEY2N0IzNUUzOTMzRURGODZFQzEzOEMxQzFCNDQyNEY5NTJERTcwODYxQjBFNTU5OTE5Mjc1QzQ3NDI0NkRFQ0VCQ0ZFQjIyNjg4NjY0MDAwN0RCMjc5OTk3QzZFOTg5RkQzM0FEMjU3QjRDQzFERDcyMTMyRjJDQjZERTJCMDFGNTEyNkEyODFEN0I3MkEwMDg5Q0VEMkRDODJFMkJCQjk5Q0UzMDFDMDBGNTEzOUE3RjQ0QTc0MjZGREM5OUUzOEYwOEFCMkU5Q0YzQTI2Nzc2OUM1M0FFQUMwRUQ3N0I5Q0U2MkFGQzYyMDk5NjVEQTc0Qjg5Qjk1REMzRTQ1NDgwNzVFODUyQkE5Mjk2OTE0NkY0OTJBQjlGNEJCMEMwMzIyNzJFQzg0NzMwNUYxNzAwRTg3QTAyRDE0QTE2QTkzNTlGN0NFOTQzMzI4RTBDRTM5MUJGM0U1QTZCRkE0NDlENEI4NjYwRTdDNTFDOTc2OUIwNTQ3MTNDQ0RBNTkzNTMxNDU0RDM1NUUzQjFGNUMzMzk5ODE5MzRDMjkzMzNCQjM4Qjc1Q0Y0MEM3NDIwMDUyOTRGREVERTIKClByb2R1Y3Q9aURNRSBTREsKRmVhdHVyZT1TZXJ2aWNlCkVzbj0iYXBwX2UzMjMxYWI2MmU5ZDQ3NzFiZDBkZjc5M2Y2MmQyMjgyLGN0bl85ZGNmM2Y5N2QyOGJiMzFlYWY0NGZiZjlmMWQzMTYyM2ZmNWIxMTc4MzNmYTNkMGEwMmE0NGRmNGM3NCxjdG5fNjg3NjE3MTEwMDZmOGNhMDIxNzg1ODUyMjE4YzMzNGUyZTNjNjEzMTFlZmY5ZDAwODQ4MzlmNDU2NDgiCkF0dHJpYj0iQ09NTSwgTlVMTCwgTlVMTCwgTlVMTCwgTlVMTCwgMjAyNi0wNS0yNiIKVmVyc2lvbj0xCkxpYnZlcj0xLjIKU2lnbj0gNTMwOTMyMjE3NjA3NEJBRTRCMTYxNERCMTgxMkNFNTExRDUzNDVFODRFNzA3NkJBQTFGOTZGMjk3RjdBNkU0NzVDQ0FBM0E3QTVCRDY4MDc5MTY4NTRFMjBERkFEOTI4QjY1NjgwRUE4RTMzNDM1MDVGMEVCQzlBMEUyRTY5NjE1NjYzMTAwQTc4M0Q1NDUwRjYwQTNBQkEwNTQ1NUQxNkEyNjQ1QTcxNUExRjlEMTlFNDM2Qzc0QzIxRkJFRTkxNDJEMjc0RUY3QjdGNDhFMjVGREMxMDJBOTdBODFCRDBFMzMxNEVGMDc5QjZEMURCOENFNTg3RUQ3NDY2MDNDNEIwNEI3ODkwNkI1QzNDMEI2MEU3RTgyNERGQzJBMDEzNkQzRUE4NzZEMEY3MkQ2Njg4RDM0Q0Y0QjhDQjZEM0U5OTg2NjA0QTY2Qjg3QjYyMDJFNzA1Mjk5Q0RFQjY1NDY4QUREMEUwMEI4MUY2OTdBNEIyN0Y4RkJFOUVDQTQ3RDgzNjJCMDVCMzAwQTNBQjk0M0IxMDUxN0NGRUVEOTY2NUE5RUQwM0E4M0VDM0Y2MjI3MTg4RUY5RTQzNDM2N0M4MjdGRkNDRTY1NDM5MjJGMDYzNkJCOEM0REQ0QkZCMUI0RTgzOTY4MUYwNDFFRjVDRTlGQkIyMEEyOTA1MzA4NUNCRDc4MjUyRjQwQURBQkU0NzdGMEExM0M5QzA3NzJGNkEwQ0NDMjk5OEMwNEYxRkI4QTZCQTk0QjJDNThEOEUyODQ4OUU0QjU2RDIyMjU0NTU2N0EzOUNCMkU3RUU1MjNBMEEzMUY0NTRDMkFENDFGRjdBRUQ4NDg2MDE0QzQxNTJFNEFEREM0MkZCNTlBN0VDRUVGNUZEOEM0MzAzRUZDNUM0RUVDOUU0M0VGMUIwREY4RDg3NDI1RkQxNDlCQThBRkE0MTIyNzVCMDNBMTdENkZDMEU4NkZENzk4MDBFRTY2MjNERjExN0ExNjIzMDAzNUE1MzZBMzkxMDE1CgpQcm9kdWN0PWlETUUgU0RLCkZlYXR1cmU9aURNRSB4RE0tRiBTREsKRXNuPSJhcHBfZTMyMzFhYjYyZTlkNDc3MWJkMGRmNzkzZjYyZDIyODIsY3RuXzlkY2YzZjk3ZDI4YmIzMWVhZjQ0ZmJmOWYxZDMxNjIzZmY1YjExNzgzM2ZhM2QwYTAyYTQ0ZGY0Yzc0LGN0bl82ODc2MTcxMTAwNmY4Y2EwMjE3ODU4NTIyMThjMzM0ZTJlM2M2MTMxMWVmZjlkMDA4NDgzOWY0NTY0OCIKQXR0cmliPSJDT01NLCAyMDI2LTA1LTI2LCA2MCwgTlVMTCwgTlVMTCwgTlVMTCIKUmVzb3VyY2U9ImlETUV4RE1GU0RLUkVTPTMiCkNvbW1lbnQ9IiQqKiojU1dJRD0yNTA4LTExUjgtUllVNyQqKiojIgpTaWduPSBEOTMxOTk1NzgxMjlDRDFDOTFCNzFDRDU0NzU2OURFMjExRThEQjg4QzIzMkE1MDY3MUJEMTVEMDY2MzJDQTQ1REVCOTBGRTk0MzAzMUE3NkM4MDM5RDZFQUQzQTE2MEQxNjk0MUQwNTM1MzAxNkZCQThFMEFDMjJEQTRDNzA1OUVCQUJDRDEzNDk5MjNBNkZERkY3MzY3NzBFQ0Y2NzNBQUE2RDIyQjk5ODdEQjNDOUU3MzFBMEQzNUI3QkEzMzZCRjA5RUI5MzRGQzJDQTA4Q0QwMjBCNEJGMDU3NTBFMjQxREI3RThDNDYwQjFGQTgyQ0ZEMTMzQ0ZBOEEwMTcyRUE0RDQ3MjM1RjVBNjA4NzdCRUJCMUE3MDhBRDYyNzI2Qzk3NjNEQkEyMEQ4NjhFMjI3NTJGMEU3RkI3NEJCNDE2QjM3N0Q1MDFFMTRDMzZERTk1RDIyMDA4RUQxRDBGQUQ5QzBGODY4MjRGOTVBQUIxRUM5QkI5MTUwNTg4NjI0RTY0MjA2OTc1MjExMDcyMzlCMUMwQkIzMjk5RDdCQzUzQTExMDcwN0Q0NUNCMDk4QTcyMDkxNDYxMTY2RDFGOTM5RjNBMTdEOTY1RTU0M0RFMDg1MjFEREEzRDQ1MUI1RkQ2QTBCMDk2MjM4RjU2N0FFRkI2QzlERUJENDZBQUE0RTI4RjdDRTRCMDBFN0E5QzQzM0Y0OEI0NTIyRTE3MTE5QjU4MjhENDA2QzFDRjg0OUQzOEYwQkQ5NjdEN0MyNzc5RTQzOUM2RTlFMjNGRTk4MkI5MTIxMjRFOTM3QTlBRUEzNDFCNjE1MDdFRkUxOTUwMjY4NTM4NDZGODc0NDA1MzA5NjVCMTE1MzIyRkRDRDQyMDJFMDZDRTI2NjQwM0VFMTgzQjgzODE5QTE0QTNGQjczRUJDRjE0NDU0OTNDQUY5QkI3ODk1RUE0OUIxMTdBRjFDNzUxRTJCMzJGMUYzRTUzQjMwOEY4NjFERkJENkZEQkI3MzU0OEEzMzM=
type: Opaque



---
kind: Service
apiVersion: v1
metadata:
  name: idme-dev
  namespace: common
  labels:
    app: idme-dev
  annotations:
    kubesphere.io/creator: lc
spec:
  ports:
    - name: http-0
      protocol: TCP
      port: 8003
      targetPort: 8003
      nodePort: 30083
  selector:
    app: idme-dev
  type: NodePort
  sessionAffinity: None
  externalTrafficPolicy: Cluster
  ipFamilies:
    - IPv4
  ipFamilyPolicy: SingleStack
  internalTrafficPolicy: Cluster


---
kind: Deployment
apiVersion: apps/v1
metadata:
  name: idme-dev
  namespace: common
  labels:
    app: idme-dev
  annotations:
    deployment.kubernetes.io/revision: '601'
    kubesphere.io/creator: lc
spec:
  replicas: 1
  selector:
    matchLabels:
      app: idme-dev
  template:
    metadata:
      creationTimestamp: null
      labels:
        app: idme-dev
        pod-template-hash: 55c7cd8f87
    spec:
      volumes:
        - name: volume-license
          secret:
            secretName: idme-license
            defaultMode: 420
        - name: volume-config
          configMap:
            name: idme-config
            defaultMode: 420
      containers:
        - name: container-idme
          image: '192.168.5.46:5000/common/idme/xdm-service:2.25.100.17.20260106.1'
          ports:
            - name: tcp-8003
              containerPort: 8003
              protocol: TCP
          env:
            - name: DEPLOY_VERSION
              value: 2.25.100.17.20260106.1
            - name: REDIS_HOST
              value: sie-redis-sentinel-master-svc.common
            - name: REDIS_PASSWORD
              value: Dme123456
            - name: REDIS_PORT
              value: '6379'
            - name: REDIS_TYPE
              value: SINGLE
            - name: JVM_OPTS
              value: >-
                -Xms5222m -Xmx5222m -XX:MaxMetaspaceSize=768M
                -XX:MaxDirectMemorySize=512m -XX:NativeMemoryTracking=summary
          resources:
            limits:
              cpu: '4'
              memory: 20000Mi
            requests:
              cpu: 250m
              memory: 4Gi
          volumeMounts:
            - name: volume-license
              readOnly: true
              mountPath: /opt/xdm/license.dat
              subPath: license.dat
            - name: volume-config
              readOnly: true
              mountPath: /opt/xdm/application.properties
              subPath: application.properties
          readinessProbe:
            httpGet:
              path: /rdm_e3231ab62e9d4771bd0df793f62d2282_app/services/v1/health
              port: 8003
              scheme: HTTP
            initialDelaySeconds: 120
            timeoutSeconds: 5
            periodSeconds: 30
            successThreshold: 1
            failureThreshold: 10
          terminationMessagePath: /dev/termination-log
          terminationMessagePolicy: File
          imagePullPolicy: IfNotPresent
      restartPolicy: Always
      terminationGracePeriodSeconds: 30
      dnsPolicy: ClusterFirst
      serviceAccountName: default
      serviceAccount: default
      securityContext: {}
      schedulerName: default-scheduler
  strategy:
    type: RollingUpdate
    rollingUpdate:
      maxUnavailable: 25%
      maxSurge: 25%
  revisionHistoryLimit: 10
  progressDeadlineSeconds: 600

4. 启动idme服务

kubectl apply -f idme_deploy.yaml

若中途出错, 修复flyway 上的SQL语句, 并跳过相关的flyway记录:

SET GLOBAL log_bin_trust_function_creators = 1;
CREATE FUNCTION `nextval` (
	`seqname` VARCHAR ( 64 )) RETURNS INT BEGIN
	UPDATE `T_SYS_SEQUENCE` 
	SET `SEQ_VALUE` = last_insert_id( `SEQ_VALUE` + 1 ) 
	WHERE
		`SEQ_NAME` = seqname;
	RETURN last_insert_id();

END

INSERT INTO t_sys_sequence (SEQ_NAME, SEQ_VALUE) values ('SEQ_USER_ID', 10000);
INSERT INTO t_sys_sequence (SEQ_NAME, SEQ_VALUE) values ('SEQ_ROLE_ID', 10000);

UPDATE `xdm_dev_ssf`.`ssf_local_flyway_schema_history` SET `success` = 1;

并重启idme:

kubectl scale deployment idme-dev --replicas=0 -n common
kubectl scale deployment idme-dev --replicas=1 -n common

查看日志:

kubectl logs -f idme-dev-95686dd99-bgtld  -n common

5. 进入idme容器，获取ESN

idme容器启动正常后，进入容器:

kubectl exec -it   idme-dev-6b586bc4f5-x46z9   -n common  -n common  -- /bin/bash

获取ESN:

curl -X POST \
  "http://127.0.0.1:8003/rdm_e3231ab62e9d4771bd0df793f62d2282_app/services/v1/license/collect-esn" \
  -H "x-auth-token: 1" \
  -H "Content-Type: application/json" \
  -H "Accept: */*" \
  -H "User-Agent: Apifox/1.0.0 (https://apifox.com)"

返回:

{"result":"SUCCESS","data":["ctn_a7009871894c2ac1c92df180c8f0470e7502f1c726c548624ff26041c3d"],"errors":[]}

将以上的信息以及 application.properties 提交给idme 运维人员，获取证书，参考: https://support.huaweicloud.com/sdkreference-idme/idme_sdkreference_0028.html

交付人员二开
前端流水线无法拉取nexus3仓库...

Comment