Skip to content

Installing SQL Agent on Linux

Installing the SQL Agent

Installing the SQL Agent on a Linux system involves downloading and running a product installation. The installation can be downloaded from \<to be determined>.

The name of the installation file will be as shown below, where n.n.n-n is the version number of the product you have downloaded:

sip-sql-agent-n.n.n-n.el9.x86\_64.rpm

The installation is started using the package manager and requires root privileges, like this:

sudo dnf install sip-sql-agent-n.n.n-n.el9.x86\_64.rpm

The product will be installed into the directory /usr/lib/synergex/sip/sql-agent.

Configuring the SQL Agent

By default the SQL Agent runs on port 5127.

Managing the Service

The SQL Agent runs as a standard Linux systemd service and can be controlled using the systemctl utility. Some examples of common systemctl commands are as follows:

  • To show the status of the service:

bash sudo systemctl status sip-sql-agent

To restart the service:

bash sudo systemctl restart sip-sql-agent

To stop the service:

bash sudo systemctl stop sip-sql-agent

To unregister the service:

bash sudo systemctl disable sip-sql-agent

To reregister the service:

bash sudo systemctl enable sip-sql-agent

Upgrading the SQL Agent

To upgrade the SQL Agent to a new version:

  • Review the release notes for the new version so you're aware of any prerequisite tasks or tasks that must be completed after the upgrade.
  • Download the installer for the new version and copy it to the target system.
  • Make sure you still have the installer for the version you are currently running, in case you need to revert to that version for any reason.
  • Perform any prerequisite tasks as defined in the release notes.
  • When you're ready to perform the upgrade, stop the service and verify that it stopped:

bash sudo systemctl stop sip-sql-agent sudo systemctl status sip-sql-agent

  • Execute the installer for the new version. You don't need to remove the old version; the installer for the new version will perform an in-place upgrade.

bash sudo dnf install sip-sql-agent-n.n.n-n.el10.x86\_64.rpm

  • Perform any post-upgrade tasks as defined in the release notes.
  • Restart the service and verify that it started.

bash sudo systemctl start sip-sql-agent sudo systemctl status sip-sql-agent

Removing the SQL Agent

To remove the SQL Agent from a Linux origin system:

  • Stop the service and verify that it stopped:

bash sudo systemctl stop sip-sql-agent sudo systemctl status sip-sql-agent

  • Similar to when the product was installed, remove the product using the package manager:

bash sudo dnf remove sip-sql-agent