DocSpace Mysql credentials

I have answered the question here Access denied for user 'root'@'localhost' (using password: YES) · Issue #1817 · ONLYOFFICE/DocSpace · GitHub for dockerized DocSpace but i am struggling to access the database in order to set up some monitoring on the DEB package installation.

I have not been able to find the db credentials created on setup, so far. Any idea how to access mysql root?

It seems I found it myself but have not tested yet. By looking into the /usr/bin/docspace-configuration i found out that it is possible to set a password by running /usr/bin/docspace-configuration -mysqlp. I’ll try on my test environment.

Hello @irdi
The advice given at GitHub is correct. You can check MySQL credentials in /app/onlyoffice/.env file.
If I misunderstood your request, please clarify it.

That is for the docker setup and indeed is correct. The DEB package setup does not have .env files. I have yet to test the /usr/bin/docspace-configuration -mysqlp but im guessing that should be the right way to do it.

Ah, I got it. Please check /etc/onlyoffice/docspace/ folder on the host. There should be appsettings.enterprise.json file which contains necessary data, you need the ‘ConnectionStrings’ block.

This file might have a slightly different name, it depends to installed version of DocSpace.

1 Like

Thank you very much @Alexandre !

1 Like