Install SSCP to SQL Bridge on Axon

pascal37

I am trying to install the sscp-sql-bridge on an Axon M505 with latest MervisOS (2.2.0.8):

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.

martin_triska

Hello @pascal37,

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?

pascal37

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.

Martin Kudláček

Hello @pascal37,
the service is named after the package: sscp-sql-bridge

pascal37

Hi @martin-kudláček,

Yes, many thanks!
I suggest you to correct service enable documentation on https://kb.unipi.technology/en:sw:01-mervis:08-sscp-bridge

Martin Kudláček

Thank you @pascal37, I fixed it!

pascal37

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.