Install SSCP to SQL Bridge on Axon
I am trying to install the sscp-sql-bridge on an Axon M505 with latest MervisOS (220.127.116.11):
root@M505-sn69:/home/unipi# apt-get install sscp-sql-bridge Reading package lists... Done Building dependency tree... Done E: Unable to locate package sscp-sql-bridge
root@M505-sn69:/home/unipi# apt-get update Get:1 http://deb.debian.org/debian buster InRelease [122 kB] Get:2 http://deb.debian.org/debian-security buster/updates InRelease [65.4 kB] Get:3 http://deb.debian.org/debian buster-updates InRelease [49.3 kB] Get:4 https://repo.unipi.technology/debian buster InRelease [23.4 kB] Get:5 http://deb.debian.org/debian buster/main Sources [7832 kB] Get:6 http://deb.debian.org/debian buster/main armhf Packages [7699 kB] Get:7 https://repo.unipi.technology/debian buster/main arm64 Packages [17.2 kB] Get:8 https://repo.unipi.technology/debian buster/main armhf Packages [10.3 kB] Get:9 https://repo.unipi.technology/debian buster/main all Packages [3378 B] Get:10 https://repo.unipi.technology/debian buster/test arm64 Packages [22.9 kB] Get:11 https://repo.unipi.technology/debian buster/test armhf Packages [17.7 kB] Get:12 https://repo.unipi.technology/debian buster/test all Packages [7482 B] Get:13 http://deb.debian.org/debian buster/main arm64 Packages [7738 kB] Get:14 http://deb.debian.org/debian buster/main Translation-en [5969 kB] Get:15 http://deb.debian.org/debian-security buster/updates/main Sources [91.1 k B] Get:16 http://deb.debian.org/debian-security buster/updates/main armhf Packages [156 kB] Get:17 http://deb.debian.org/debian-security buster/updates/main arm64 Packages [156 kB] Get:18 http://deb.debian.org/debian-security buster/updates/main Translation-en [80.7 kB] Get:19 http://deb.debian.org/debian buster-updates/main Sources [2544 B] Get:20 http://deb.debian.org/debian buster-updates/main armhf Packages [5780 B] Get:21 http://deb.debian.org/debian buster-updates/main arm64 Packages [5776 B] Get:22 http://deb.debian.org/debian buster-updates/main Translation-en [3655 B] Fetched 30.1 MB in 18s (1629 kB/s) Reading package lists... Done
root@M505-sn69:/home/unipi# apt-get install sscp-sql-bridge Reading package lists... Done Building dependency tree... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: sscp-sql-bridge : Depends: libboost-system1.62.0 but it is not installable E: Unable to correct problems, you have held broken packages.
root@M505-sn69:/home/unipi# apt-get install libboost-system1.62.0 Reading package lists... Done Building dependency tree Reading state information... Done Package libboost-system1.62.0 is not available, but is referred to by another package. This may mean that the package is missing, has been obsoleted, or is only available from another source E: Package 'libboost-system1.62.0' has no installation candidate
Could you please explain the right way to install it?
Many thanks in advance.
the issue has been caused by the old version 1.62.0 of libboost-system. Our newly deployed Mervis packages 2.2.x.x are based on the Debian Buster distro where the version 1.67.0 of the package is used. It should be fixed in the dependency list now.
Can you please do apt update and try to install the package again?
Many thanks @martin_triska: installation is now successful and I could get the solution working.
However, the installer does not create the service file:
root@M505-sn69:/opt/unipi/tools# systemctl enable sscp-sql-daemon Failed to enable unit: Unit file sscp-sql-daemon.service does not exist. root@M505-sn69:/opt/unipi/tools# systemctl start sscp-sql-daemon Failed to start sscp-sql-daemon.service: Unit sscp-sql-daemon.service not found.
the service is named after the package: sscp-sql-bridge
Yes, many thanks!
I suggest you to correct service enable documentation on https://kb.unipi.technology/en:sw:01-mervis:08-sscp-bridge
Thank you @pascal37, I fixed it!
Dear Unipi support team,
Is there a way to make the SSCP to SQL Bridge more robust, for example, so that it is not necessary to restart it manually after every solution deployment or PLC restart?
Many thanks in advance and kind regards.