ONLYOFFICE / CommunityServer

Free open source office suite with business productivity tools: document and project management, CRM, mail aggregator.
http://www.onlyoffice.com
Apache License 2.0
2.75k stars 621 forks source link

ONLYOFFICE UrlShortener service does not work if the external database does not use port 3306 #497

Closed ydelattre closed 8 months ago

ydelattre commented 8 months ago

Hello.

A few weeks ago, we migrated our MySQL database. Now the new database uses 3318 port instead of the default MySQL port 3306. Since then, the ONLYOFFICE UrlShortener Service no longer works. Indeed, the port is not specified in config.json of this service :

root@a757e4c704ce:/var/www/onlyoffice/Services/ASC.UrlShortener/config# cat config.UNIX.SERVER.json { "port": 9999, "core.machinekey": "XXXXXXXXXXXXXXXXXXXXX", "logPath": "/var/log/onlyoffice/web.urlshortener.log", "sql": { "host": "mybdd_hostname", "user": "mybdd_user", "password": "XXXXXXXXXXXXXXXXXXXXXXXXXX", "database": "mybdd_database" }

Adding it, solved the problem.

FYI :

Thanks. Regards. Yoann.

andreysavihin commented 8 months ago

Hi @ydelattre! Try manually adding "port": 3318 to the config file in the sql section and restarting the service.

ydelattre commented 8 months ago

Hi @andreysavihin

Thanks for your answer. Indeed, adding it fixed the problem until the next container restart... Could you, please, make a change to the entrypoint script to be able to use a custom database port with ONLYOFFICE UrlShortener service ?

Thanks a lot. Yoann

andreysavihin commented 8 months ago

We will fix it in the next release