Temporal mysql db usage

Community Support
1

i am trying to connect to external aws mysql rds:

environment:
- DB=mysql
- DB_PORT=3327
- MYSQL_USER=temporal
- MYSQL_PWD=
- MYSQL_SEEDS=
- DYNAMIC_CONFIG_FILE_PATH=config/dynamicconfig/development.yaml
- SKIP_DB_CREATE=false

Here , the db “temporal” is already created and user “temporal” has access on the db “temporal”

on docker-compose up, i get the error:

temporal | + temporal-sql-tool --ep -u temporal create --db temporal
temporal | 2022-06-24T05:25:30.400Z ERROR Unable to create SQL database. {“error”: “dial tcp 172.26.22.202:3306: connect: connection refused”, “logging-call-at”: “handler.go:98”}

How do i skip the db creation process?

4

only 2 tables are getting created on running the command:

docker run --entrypoint “/usr/local/bin/temporal-sql-tool” temporalio/admin-tools:1.15.0 -ep -p 3327 -u temporal --pw pwd --db temporal setup-schema -v 1.7

the tables getting created are:

schema_update_history
schema_version

but, i suppose more tables are required for te setup to run, on docker-compose up i get the error:

: Table ‘temporal.cluster_metadata_info’ doesn’t exist

1 Like
6

You can see the sql tool commands auto-setup image runs here.
If you are skipping db creation, see the two create commands the script skips that should be run before starting cluster

hope this helps.