Install SSCP to SQL Bridge on Axon



  • 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.


  • administrators

    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?



  • 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.
    

  • administrators

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



  • 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


  • administrators

    Thank you @pascal37, I fixed it!