[Bug] set MySQL visibility will not use VISIBILITY_MYSQL_USER/VISIBILITY_MYSQL_PWD - Githubissues

temporalio / docker-builds

Temporal service Docker images build

https://hub.docker.com/r/temporaliotest/auto-setup

MIT License

30 stars 59 forks source link

[Bug] set MySQL visibility will not use VISIBILITY_MYSQL_USER/VISIBILITY_MYSQL_PWD #236

Open onesaltedseafish opened 3 months ago

onesaltedseafish commented 3 months ago

What are you really trying to do?

I'm trying to set a seperate user and password for visibility, but I got:

temporal              | 2024-08-11T06:38:32.751Z        ERROR   Unable to create SQL database.  {"error": "Error 1044: Access denied for user 'temporal'@'%' to database 'temporal_visibility'", "logging-call-at": "handler.go:94"}

Describe the bug

I find the visibility.sql.user will not be used when init the temporal_visibility database. Can see the process in https://github.com/temporalio/docker-builds/blob/main/docker/auto-setup.sh#L172C1-L172C19 .

Minimal Reproduction

Environment/Versions

OS and processor: [x86 Linux]
Temporal Version: [1.24.2]
Are you using Docker or Kubernetes or building Temporal from source? Docker

Additional context

Just use a different user for database temporal and temporal_visibility.