Uploaded image for project: 'Help-Desk'
  1. Help-Desk
  2. HELP-6334

FIWARE.Request.Tech.Apps.DataViz-SpagoBI.Apps.DataViz-SpagoBI.FIWARE SpagoBI dockerization updated version

        Details

          Description

          Hi,

          The following is a message received from the Leansite team and it is about the “Dockerization” of SpagoBI.

          Best regards,
          Marco

          Marco Terrinoni
          Consoft Sistemi s.p.a.
          BU Application
          Via Pio VII 127 - 10127 - Torino
          Tel (+39) 011 3161571
          Fax (+39) 011 3161583

          Da: Ergo Pikas ergo.pikas@gmail.com
          Inviato: giovedì 7 aprile 2016 14:44
          A: consoft-fiwarecoach@consoft.it; fiware-ceedtech-coaching@lists.fiware.org
          Cc: Zsolt Illés <zsolt.illes@slamby.com>; Attila László <attila.laszlo@slamby.com>; david@thorgate.eu
          Oggetto: Re: [Fiware-ceedtech-coaching] I: FIWARE Docker question

          Hi Marco and Zsolt Illés,

          I am writing to you from Startup Wise Guys Estonia. We are developing a construction site management app called Leansite and need to use FIWARE enablers! We are trying to use SpagoBI and have following concerns!

          We have had issues using SpagoBI 5.2 within docker on our Ubuntu server.
          It seems that the source code no longer contains a docker image and the official
          docker image you provide on docker hub is both an older version and fails with
          a java error. Do you have any advice on how to use SpagoBI 5.2 with docker?

          Looking forward to any help!

          Ergo Pikas

          Since January 1st, old domains won't be supported and messages sent to any domain different to @lists.fiware.org will be lost.
          Please, send your messages using the new domain (Fiware-ceedtech-coaching@lists.fiware.org) instead of the old one.
          _______________________________________________
          Fiware-ceedtech-coaching mailing list
          Fiware-ceedtech-coaching@lists.fiware.org
          https://lists.fiware.org/listinfo/fiware-ceedtech-coaching

            Issue Links

            relates to

            extRequest - Request from external stakeholder received in the help desk HELC-1355 FIWARE.Request.Coach.CEED-Tech.FIWARE SpagoBI dockerization updated version

            • Major - Major loss of function.
            • Closed

              Activity

              Ascending order - Click to sort in descending order
              Hide
              Permalink
              consoft_coach Marco Terrinoni added a comment -

              Dear Davide,

              I kindly ask you to have a look at this question and provide an answer to the user.
              Basically, this is about the latest version of SpagoBI on Docker.

              Thank you very much for your time and effort!

              Best regards,
              Marco

              Show
              consoft_coach Marco Terrinoni added a comment - Dear Davide, I kindly ask you to have a look at this question and provide an answer to the user. Basically, this is about the latest version of SpagoBI on Docker. Thank you very much for your time and effort! Best regards, Marco
              Hide
              Permalink
              zerbetto Davide Zerbetto added a comment -

              Hi
              at the moment no docker script for SpagoBI 5.2 is available, but you can use the 5.1-fiware-all-in-one docker script, it is very close to SpagoBI 5.2.
              Hope this helps
              Best regards
              Davide

              Show
              zerbetto Davide Zerbetto added a comment - Hi at the moment no docker script for SpagoBI 5.2 is available, but you can use the 5.1-fiware-all-in-one docker script, it is very close to SpagoBI 5.2. Hope this helps Best regards Davide
              Hide
              Permalink
              consoft_coach Marco Terrinoni added a comment -

              Thanks Davide!
              I'm going to forward your answer to the team.
              Thank you very much.

              Best regards,
              Marco

              Show
              consoft_coach Marco Terrinoni added a comment - Thanks Davide! I'm going to forward your answer to the team. Thank you very much. Best regards, Marco
              Hide
              Permalink
              consoft_coach Marco Terrinoni added a comment -

              Good morning Davide,
              I just received the reply from the user, saying that he will try your proposed solution.
              I think we can close this ticket; I will notify you in case of problems.
              Thank you very much for your cooperation.
              Best regards,
              Marco

              Show
              consoft_coach Marco Terrinoni added a comment - Good morning Davide, I just received the reply from the user, saying that he will try your proposed solution. I think we can close this ticket; I will notify you in case of problems. Thank you very much for your cooperation. Best regards, Marco
              Hide
              Permalink
              zerbetto Davide Zerbetto added a comment -

              Ok
              Thank you
              Davide

              Show
              zerbetto Davide Zerbetto added a comment - Ok Thank you Davide
              Hide
              Permalink
              consoft_coach Marco Terrinoni added a comment -

              Hello Davide,
              Sorry to bother you again about this issue.
              I received a reply from the user and he said he's still facing some problems with SpagoBI and Docker.
              The following is his message; let me know if you are able to provide a solution, otherwise I will open a new dedicated issue.

              I tried to get SpagoBI working in a docker instance using these instructions:
              https://github.com/SpagoBILabs/SpagoBI/tree/master/docker

              The first command involved starting up a MYSQL docker instance:
              sudo docker run --name spagobidb -e MYSQL_USER=spagobiuser -e MYSQL_PASSWORD=spagobipassword -e MYSQL_DATABASE=spagobidb -e MYSQL_ROOT_PASSWORD=spagobirootpassword -d mysql:5.5

              This does not give any errors and runs as expected.

              Then I linked the SpagoBI docker image as follows:
              sudo docker run --link spagobidb:db --name spagobi -d spagobilabs/spagobi:all-in-one

              This does not give any errors and runs as expected.

              Then I tried to access this SpagoBI image by finding the IP address of the spagobi docker image:
              sudo docker inspect --format '{{.NetworkSettings.IPAddress }}' spagobi

              This gave 172.17.0.5

              I then tried to access SpagoBi at the following addresses:
              http://172.17.0.5:8080/SpagoBI
              https://172.17.0.5:8080/SpagoBI

              Both of these addresses resulted in a timeout.

              How can we access the SpagoBI image once it is running?

              Thank you very much for your support Davide!

              Best regards,
              Marco

              Show
              consoft_coach Marco Terrinoni added a comment - Hello Davide, Sorry to bother you again about this issue. I received a reply from the user and he said he's still facing some problems with SpagoBI and Docker. The following is his message; let me know if you are able to provide a solution, otherwise I will open a new dedicated issue. I tried to get SpagoBI working in a docker instance using these instructions: https://github.com/SpagoBILabs/SpagoBI/tree/master/docker The first command involved starting up a MYSQL docker instance: sudo docker run --name spagobidb -e MYSQL_USER=spagobiuser -e MYSQL_PASSWORD=spagobipassword -e MYSQL_DATABASE=spagobidb -e MYSQL_ROOT_PASSWORD=spagobirootpassword -d mysql:5.5 This does not give any errors and runs as expected. Then I linked the SpagoBI docker image as follows: sudo docker run --link spagobidb:db --name spagobi -d spagobilabs/spagobi:all-in-one This does not give any errors and runs as expected. Then I tried to access this SpagoBI image by finding the IP address of the spagobi docker image: sudo docker inspect --format '{{.NetworkSettings.IPAddress }}' spagobi This gave 172.17.0.5 I then tried to access SpagoBi at the following addresses: http://172.17.0.5:8080/SpagoBI https://172.17.0.5:8080/SpagoBI Both of these addresses resulted in a timeout. How can we access the SpagoBI image once it is running? Thank you very much for your support Davide! Best regards, Marco
              Hide
              Permalink
              zerbetto Davide Zerbetto added a comment -

              Hi
              first of all I suggest you to use spagobilabs/spagobi:latest instead of spagobilabs/spagobi:all-in-one.
              Please pay attention also to container available memory and resources, maybe default container doesn't have enough memory.
              URL http://172.17.0.5:8080/SpagoBI should be fine.
              If you want to enter the container, you can type:
              $ docker exec -i -t <container name> bash
              Hope this helps
              Best regards
              Davide

              Show
              zerbetto Davide Zerbetto added a comment - Hi first of all I suggest you to use spagobilabs/spagobi:latest instead of spagobilabs/spagobi:all-in-one. Please pay attention also to container available memory and resources, maybe default container doesn't have enough memory. URL http://172.17.0.5:8080/SpagoBI should be fine. If you want to enter the container, you can type: $ docker exec -i -t <container name> bash Hope this helps Best regards Davide
              Hide
              Permalink
              consoft_coach Marco Terrinoni added a comment -

              Thank you very much Davide; I just forwarded your answer to the user and see if this fixes his problem.
              I also suggested to specify the port matching while starting the container.
              Thank you again for your support!
              Best regards,
              Marco

              Show
              consoft_coach Marco Terrinoni added a comment - Thank you very much Davide; I just forwarded your answer to the user and see if this fixes his problem. I also suggested to specify the port matching while starting the container. Thank you again for your support! Best regards, Marco

                People

                • Assignee:
                  zerbetto Davide Zerbetto
                  Reporter:
                  fw.ext.user FW External User
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: