Synology – To edit hostname / IP address / port on Synology ShareSync connections
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.