Docker-CommunityServer: Access denied for user `mail_admin`, unknown database `onlyoffice_mailserver`

Hello,

When trying to install OnlyOffice Workspace using docker-compose.workspace.yml, I’m encountering the following error : ERROR 1045 (28000): Access denied for user 'mail_admin'@'172.18.0.6' (using password: YES).

So I manually accessed the database and noticed that user doesn’t exist at all, therefore I changed MAIL_SERVER_DB_USER=mail_admin to MAIL_SERVER_DB_USER=root and MYSQL_ROOT_USER=mail_admin to use MYSQL_ROOT_USER=root, and now I’m encountering another error : ERROR 1049 (42000): Unknown database 'onlyoffice_mailserver'.

It seems no migration occurs despite starting the server for the first time.

What to do ?

Thanks

About this issue

Original URL
State: open
Created 5 months ago
Reactions: 1
Comments: 35 (8 by maintainers)

Most upvoted comments

you also need to change them accordingly in the database initialization script

What’s the point of having environment variables if the script doesn’t use these ?!

KaKi87 on Jan 24, 2024

Please check the status of your mail server container. If it is on restart, you need to enable vsyscall in your OS, read our guide. After the reboot, all containers should start. If not, try re-creating it.

Carazyda on Jan 23, 2024

No, because that’s actually wrongly called a bugfix as it’s rather a refactor.

KaKi87 on Jan 22, 2024