Temporal with MySQL

Community Support
,
1

Hi everyone!

Could you help please,
I use repo:

And MySQL from:

Errors:
image
and logs from Worker:
[Fx] Error returned: received non-nil error from function .ServerOptionsProvider
/home/builder/temporal/temporal/fx.go:173:
sql schema version compatibility check failed: unable to read DB schema version keyspace/database: temporal error: Error 1146: Table ‘temporal.schema_version’ doesn’t exist
[Fx] ERROR Failed to initialize custom logger: could not build arguments for function .(*module).constructCustomLogger.func2
/go/pkg/mod/go.uber.org/fx@v1.20.0/module.go:251:
failed to build fxevent.Logger:
could not build arguments for function .glob…func8
/home/builder/temporal/temporal/fx.go:1037:
failed to build log.Logger:
received non-nil error from function .ServerOptionsProvider
/home/builder/temporal/temporal/fx.go:173:
sql schema version compatibility check failed: unable to read DB schema version keyspace/database: temporal error: Error 1146: Table ‘temporal.schema_version’ doesn’t exist
Unable to create server. Error: could not build arguments for function .(*module).constructCustomLogger.func2 (/go/pkg/mod/go.uber.org/fx@v1.20.0/module.go:251): failed to build fxevent.Logger: could not build arguments for function .glob…func8 (/home/builder/temporal/temporal/fx.go:1037): failed to build log.Logger: received non-nil error from function .ServerOptionsProvider (/home/builder/temporal/temporal/fx.go:173): sql schema version compatibility check failed: unable to read DB schema version keyspace/database: temporal error: Error 1146: Table ‘temporal.schema_version’ doesn’t exist.

sql schema version compatibility check failed: unable to read DB schema version keyspace/database: temporal error: Error 1146: Table ‘temporal.schema_version’ doesn’t exist.

My configure:
values.mysql.yaml:

server:
config:
persistence:
default:
driver: “sql”

    sql:
      driver: "mysql8"
      host: temporaltest-mysql
      port: 3306
      database: "temporal"
      user: "temporal"
      password: "temporal"
      maxConns: 20
      maxConnLifetime: "1h"

  visibility:
    driver: "sql"

    sql:
      driver: "mysql8"
      host: temporaltest-mysql
      port: 3306
      database: "temporal"
      user: "temporal"
      password: "temporal"
      maxConns: 20
      maxConnLifetime: "1h"

cassandra:
enabled: false

mysql:
enabled: true
auth:
rootPassword: “admpswd”
username: “temporal”
password: “temporal”

postgresql:
enabled: false

schema:
setup:
enabled: false
update:
enabled: false

and values.yaml mysql chart:
Filled AUTH block
auth:

rootPassword: “admpswd”
createDatabase: true
database: “temporal”
username: “temporal”
password: “temporal”

and StorageClass:

storageClass: “csi-disk”

without that PVC wiill not create.

helm dependency list:

NAME VERSION REPOSITORY STATUS
cassandra 0.14.3 h ttps://charts.helm.sh/incubator ok
prometheus 15.1.3 h ttps://prometheus-community.github.io/helm-charts ok
elasticsearch 7.17.3 h ttps://helm.elastic.co ok
grafana 5.0.10 h ttps://grafana.github.io/helm-charts ok
mysql 9.22.0 h ttps://charts.bitnami.com/bitnami ok

I don’t understand where this circuit is, and how to solve this issue, please help=)
Many thanks.