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.