To edit hostname / IP address / port on Synology ShareSync connections,
without deleting the connection and re-creating it as a new one, do the following:

  • Stop the service from the Package Center.

  • ssh into the Synology and run the following commands:

    • user@NAS:~$ sudo -i bash

bash-4.3# sqlite3 /volume1/@CloudStationClient/db/sys.sqlite

sqlite> .header on
sqlite> .mode column
sqlite> SELECT id,server_name,server_ip,server_port FROM connection_table;

id          server_name       server_ip  server_port
----------  ----------------  ---------  -----------
2           aaa.yyy.com:6690  1.2.3.3    6690
3           xxx.yyy.com:6690  1.2.3.4    6690
4           bbb.yyy.com:6690  1.2.3.5    6690

sqlite> UPDATE connection_table SET server_name='abc.def.com:5577', server_ip='4.3.2.1', server_port='5577' WHERE id=3;

sqlite> SELECT id,server_name,server_ip,server_port FROM connection_table;

id          server_name       server_ip  server_port
----------  ----------------  ---------  -----------
2           aaa.yyy.com:6690  1.2.3.4    6690
3           abc.def.com:5577  4.3.2.1    5577
4           bbb.yyy.com:6690  1.2.3.5    6690

sqlite> .quit
  • Start the service from the Package Center.

    Now the connections should be updated and continue syncing as normal, with the new address.