• Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    Install SSCP to SQL Bridge on Axon

    Mervis
    3
    7
    702
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • P
      pascal37 last edited by

      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.

      1 Reply Last reply Reply Quote 0
      • M
        martin_triska administrators last edited by

        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?

        1 Reply Last reply Reply Quote 0
        • P
          pascal37 last edited by 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 1 Reply Last reply Reply Quote 0
          • Martin Kudláček
            Martin Kudláček @pascal37 last edited by

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

            P 1 Reply Last reply Reply Quote 0
            • P
              pascal37 @Martin Kudláček last edited by

              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 1 Reply Last reply Reply Quote 0
              • Martin Kudláček
                Martin Kudláček @pascal37 last edited by

                Thank you @pascal37, I fixed it!

                1 Reply Last reply Reply Quote 0
                • P
                  pascal37 last edited by 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.

                  1 Reply Last reply Reply Quote 0
                  • First post
                    Last post