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.