ONLYOFFICE Document Server snap install. Is there a way to use external MySQL server?

I install ONLYOFFICE Document Server using snap by following this: https://github.com/ONLYOFFICE/snap-documentserver. All things work perfect.

The only thing I do not like is: currently the MySQL server is running on the same server as ONLYOFFICE DS. I have another server running MySQL. Is that possible to config OO DS to let it using that external MySQL server?

If it is, how can export (using mysqldump) the current database handled by OO DS snap install?

Thanks

Hello @kaman
Probably you can change database to external one via local.json config file. I mean this section:

"sql": {
        "type": "postgres",
        "dbHost": "localhost",
        "dbPort": "5432",
        "dbName": "onlyoffice",
        "dbUser": "onlyoffice",
        "dbPass": "onlyoffice"

After that you have to restart all Document server services.

Please note that we didn’t test this scenario (external database for snap installation), so we can’t provide support or predict possible issues. At first sight, you might face issues with AppArmor profiles.

Thanks for reply me. I think I will keep using the mysql db included in snap installation.

Actually, I use nextcloud snap installation. It has the same issue.

Sorry about this situation. If in the future you come back to this question, I would recommend to take a look at docker installation. There’s possibility to change database even on an installation step: Installing ONLYOFFICE Docs for Docker on a local server - ONLYOFFICE


Anyway, feel free to contact us if you face any difficulties.

1 Like