SyncriTab

Installing SyncriTab

Install SyncriTab on Windows or Linux, or run it in Docker, then open it in your browser for the first time.

You install SyncriTab once, on the server your team will use. Users don't install anything; they open SyncriTab in a web browser. The installer includes its own Java runtime, so you don't need to install Java first.

Before you begin

Installing on Windows

  1. Extract setup.exe from SyncriTab.zip.
  2. Right-click setup.exe and choose Run as administrator. If Windows asks whether to allow the app to make changes, click Yes.
  3. Follow the steps in the setup program. When asked for a destination folder, accept the default, C:\Program Files\SyncriTab, or choose another folder on a disk with room for your data.
  4. Click Install. The setup program copies the files and registers SyncriTab as a Windows service named SyncriTab.
  5. Click Finish. Your browser opens SyncriTab at http://localhost:21786. If the page doesn't load yet, wait a few seconds for the service to start, then refresh the page.
The SyncriTab setup program on Windows.
The SyncriTab setup program.

The setup program also adds a SyncriTab shortcut to the Start menu. It opens SyncriTab in your browser on the server itself.

Starting and stopping SyncriTab on Windows

SyncriTab runs as the SyncriTab Windows service and starts automatically when Windows starts. To start, stop, or restart it, use the Services console (services.msc), or run one of these commands in a Command Prompt opened as administrator:

net stop SyncriTab
net start SyncriTab

Administrators can also restart SyncriTab from its About page. See Updating & Restarting.

Installing on Linux

The Linux installer works on 64-bit distributions that use systemd, such as Ubuntu, Debian, Red Hat Enterprise Linux, Rocky Linux, Fedora, and Linux Mint.

  1. On the server, run this command:
    curl -fsSL https://web.synametrics.com/files/syncritab-install.sh | sudo sh
    It downloads the SyncriTab installer from Synametrics and runs it as root. If sudo asks for a password, enter your own Linux password.
  2. Answer the installer's questions. To accept a default, press Enter.
    QuestionDefaultWhat it means
    Installation directory/opt/SyncriTabWhere SyncriTab and its data are stored. Choose a disk with room for your data.
    OS user to run SyncriTab assyncritabThe Linux account that runs the SyncriTab service. If the account doesn't exist, the installer creates it as a system account.
  3. Wait for the installer to finish. It prints a summary that includes the address of the web interface, for example http://192.168.1.20:21786.
Terminal output from the SyncriTab Linux installer, ending with the installation summary.
The Linux installer's summary.

To read the installer before you run it, download it first, review it, and then run it:

curl -fsSL https://web.synametrics.com/files/syncritab-install.sh -o syncritab-install.sh
less syncritab-install.sh
sudo sh syncritab-install.sh

The installer does the following for you:

Starting and stopping SyncriTab on Linux

Manage the service with systemctl:

sudo systemctl status syncritab
sudo systemctl stop syncritab
sudo systemctl start syncritab
sudo systemctl restart syncritab

If the service doesn't start, view its most recent messages:

sudo journalctl -u syncritab -n 50

Linux without systemd

If the server doesn't use systemd, the installer displays a warning and installs SyncriTab as a traditional init.d service instead. In this case, SyncriTab runs as root, and the installer doesn't ask for a service user. Manage the service with:

sudo /etc/init.d/syncritab {start|stop|restart|status}

Running SyncriTab in Docker

Synametrics publishes a Dockerfile for SyncriTab in the SyncriTabDocker repository on GitHub. You build the image from it on your Docker host. The image is based on the Eclipse Temurin Java 21 runtime and downloads the latest SyncriTab release while it builds.

  1. Download the repository and open its folder:
    git clone https://github.com/Synametrics/SyncriTabDocker.git
    cd SyncriTabDocker
    If you don't have git, download the repository as a ZIP file from GitHub and extract it instead.
  2. Build the image:
    docker build -t syncritab-server .
  3. Start a container. This command keeps SyncriTab's data in a Docker volume named syncritab-data, and restarts the container automatically if it stops or the host restarts:
    docker run -d \
      --name syncritab-server \
      --restart unless-stopped \
      -v syncritab-data:/opt/SyncriTab \
      -p 21786:21786 -p 80:80 -p 443:443 \
      syncritab-server
  4. Open http://docker-host:21786 in your browser and continue with Initial Setup.

Ports

Each -p option maps a port on the Docker host to a port in the container:

Container portUsed for
21786HTTP. This is the only port SyncriTab uses when it first starts, so it's always required.
80HTTP, after an administrator turns it on
443HTTPS, after an administrator turns it on

If a port is already in use on the host, map a different host port to it. For example, -p 8443:443 makes HTTPS available on port 8443 of the host. You can leave out -p 80:80 and -p 443:443 if you don't plan to turn those ports on.

Where your data is stored

The container keeps the entire SyncriTab installation folder, /opt/SyncriTab, on the volume, including settings, users, data sources, JDBC drivers, certificates, logs, and everything your users save. The first time the container starts with an empty volume, it copies the SyncriTab files into it. Because the data lives on the volume, you can remove and re-create the container without losing it.

To keep the data in a folder of your choice instead of a Docker-managed volume, use a bind mount:

# Linux or macOS host
-v /srv/syncritab-data:/opt/SyncriTab

# Windows host
-v C:\syncritab-data:/opt/SyncriTab

Always use a volume or a bind mount in production. Without one, all of SyncriTab's data is lost when the container is removed.

Managing the container

docker stop syncritab-server       # stop SyncriTab
docker start syncritab-server      # start it again
docker logs -f syncritab-server    # follow the log output

To back up the syncritab-data volume to a file named syncritab-backup.tar.gz in the current folder:

docker run --rm -v syncritab-data:/data -v "$(pwd)":/backup ubuntu \
  tar czf /backup/syncritab-backup.tar.gz -C /data .

For more options, see the README in the SyncriTabDocker repository.

Opening SyncriTab for the first time

When the service is running, open SyncriTab in a web browser:

The first page you see is Welcome to SyncriTab, where you create the administrator account. Continue with Initial Setup.

If the page doesn't load:

For more help, see Troubleshooting.

The installation folder

The installation folder contains the program and, by default, everything SyncriTab saves. Include it in your server backups.

FolderContents
configServer settings, users, and data sources
htdocsThe web interface
JdbcDriversJDBC drivers, both the included drivers and those added by managers
jreThe Java runtime used by SyncriTab
libProgram files
logsLog files, useful for troubleshooting and support requests
patchesFiles used when SyncriTab is updated
pluginsDatabase-specific support for SQL Server, Oracle, MySQL, and other databases

As people use SyncriTab, it creates more folders here for saved scripts, saved sessions, query history, exported files, and its internal database.

Uninstalling SyncriTab

Back up first. The installation folder holds your settings, users, data sources, and everything your users saved. Copy it somewhere safe before you uninstall, in case you need it later.

Windows

  1. Open Settings › Apps › Installed apps (or Control Panel › Programs and Features).
  2. Find SyncriTab and choose Uninstall.

The uninstaller stops and removes the SyncriTab service and removes the installed program files. Files that SyncriTab created after installation, such as your settings and saved data, may remain in the installation folder. Delete the folder if you no longer need them.

Linux

Run the uninstall script from the installation directory:

sudo /opt/SyncriTab/Uninstall.sh

The script stops and removes the syncritab service and deletes the entire installation directory, including all saved data. It leaves the service user account in place. To remove that account and its home folder too, run:

sudo userdel -r syncritab

Docker

Stop and remove the container:

docker stop syncritab-server
docker rm syncritab-server

This leaves your data in the syncritab-data volume, so you can start a new container with it later. To delete the data permanently, remove the volume too:

docker volume rm syncritab-data

Next steps

Continue with Initial Setup to create the administrator account and activate SyncriTab.