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

[Fiware-general-help] Problema con la conexión entre Cygnus y MySQL

        Details

        • Type: extRequest
        • Status: Closed
        • Priority: Major
        • Resolution: Done
        • Fix Version/s: 2021
        • Component/s: FIWARE-GENERAL-HELP
        • Labels:
          None

          Description

          El siguiente mensaje va dirigido a Andres Muñoz Arcentales para seguir el
          hilo de ayuda que estabamos desarrollando en privado.
          Ya he ejecutado correctamen el .sh , simplemente no estaba abierto el
          puerto 5050 de mi FiwareLab, he obtenido el siguiente resultado

          • About to connect() to localhost port 5050 (#0)
          • Trying ::1... connected
          • Connected to localhost (::1) port 5050 (#0)
            > POST /notify HTTP/1.1
            > Host: localhost:5050
            > Content-Type: application/json; charset=utf-8
            > Accept: application/json
            > User-Agent: orion/0.10.0
            > Fiware-Service: /
            > Fiware-ServicePath: /
            > Content-Length: 460
            >
            < HTTP/1.1 200 OK
            < Transfer-Encoding: chunked
            < Server: Jetty(6.1.26)
            <
          • Connection #0 to host localhost left intact
          • Closing connection #0

          Supongo que al dar este resultado, damos por resuelto si el problema viene
          por la suscripción. Te adjunto la traza que he obtenido en cygnus.log tras
          realizar la nueva actualización de mi entidad, lamentablemente siguen sin
          replicarse los históricos en MySQL.

          Muchas gracias por tu ayuda y colaboración!

          –

          Francisco José Melgar Molina
          CTO Ciclogreen

          francisco.melgar@ciclogreen.com · www.ciclogreen.com

          41092 · Sevilla

          <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
          Libre
          de virus. www.avg.com
          <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
          <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

          __________________________________________________________________________________________

          You can get more information about our cookies and privacy policies on the following links:

          Fiware-general-help mailing list
          Fiware-general-help@lists.fiware.org
          https://lists.fiware.org/listinfo/fiware-general-help

          [Created via e-mail received from: Fran Melgar <francisco.melgar@ciclogreen.com>]

          1. HTML File
            [FIWARE-JIRA] (HELP-13000) [Fiware-general-help] Problema con la conexión entre Cygnus y MySQL
            7 kB
            FW External User
          2. Text File
            agent.conf
            4 kB
            Joaquin Salvachua
          3. Text File
            nueva.txt
            18 kB
            FW External User
          1. imageedit_2_6393390379.png
            53 kB

            Activity

            Descending order - Click to sort in ascending order
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            Open Open In Progress In Progress
            		30m 25s 1 José Ignacio Carretero Guarde 04/Dec/17 9:26 AM
            In Progress In Progress Answered Answered
            		3s 1 José Ignacio Carretero Guarde 04/Dec/17 9:26 AM
            Answered Answered Closed Closed
            		38d 22h 59m 1 Fernando Lopez 12/Jan/18 8:26 AM
            fla Fernando Lopez made changes -
            Fix Version/s 2021 [ 12600 ]
            joaquin.salvachua Joaquín Salvachúa made changes -
            Assignee Joaquín Salvachúa [ joaquin.salvachua ] Andres Muñoz [ andres.munoza ]
            fla Fernando Lopez made changes -
            HD-Enabler Cygnus [ 11304 ]
            fla Fernando Lopez made changes -
            Resolution Done [ 10000 ]
            Status Answered [ 10104 ] Closed [ 6 ]
            Hide
            Permalink
            fla Fernando Lopez added a comment -

            We close the ticket because we do not get more problems from the user.

            Show
            fla Fernando Lopez added a comment - We close the ticket because we do not get more problems from the user.
            fla Fernando Lopez made changes -
            Comment [ Comment by jira-help-desk@jira.fiware.org :

            Spam detection software, running on the system "fiware-forge-01", has
            identified this incoming email as possible spam. The original message
            has been attached to this so you can view it (if it isn't spam) or label
            similar future email. If you have any questions, see
            the administrator of that system for details.

            Content preview: [ https://jira.fiware.org/browse/HELP-13000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
               ] FW External User updated HELP-13000: Attachment: [FIWARE-JIRA] (HELP-13000)
               [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job
               Application [...]

            Content analysis details: (6.1 points, 4.5 required)

             pts rule name description
            ---- ---------------------- --------------------------------------------------
             1.7 URIBL_BLACK Contains an URL listed in the URIBL blacklist
                                        [URIs: latedeliver.com]
             2.5 URIBL_DBL_SPAM Contains a spam URL listed in the DBL blocklist
                                        [URIs: latedeliver.com]
             0.0 FSL_HELO_NON_FQDN_1 FSL_HELO_NON_FQDN_1
             3.8 HELO_LOCALHOST HELO_LOCALHOST
            -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1%
                                        [score: 0.0000]

            ]
            fla Fernando Lopez made changes -
            Comment [ Comment by jira-help-desk@jira.fiware.org :

            Spam detection software, running on the system "fiware-forge-01", has
            identified this incoming email as possible spam. The original message
            has been attached to this so you can view it (if it isn't spam) or label
            similar future email. If you have any questions, see
            the administrator of that system for details.

            Content preview: [ https://jira.fiware.org/browse/HELP-13000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
               ] FW External User updated HELP-13000: > [Fiware-general-help] [SPAM] [FIWARE-JIRA]
               (HELP-13082) [SPAM] Website Job Application > > > Key: HELP-13000 > URL:
              https://jira.fiware.org/browse/HELP-13000 > Project: Help-Desk > Issue Type:
               extRequest > Reporter: FW External User > Attachments: [FIWARE-JIRA] (HELP-13082)
               [Fiware-general-help] [SPAM] Website Job Application > > > Spam detection
               software, running on the system "fiware-forge-01", has > identified this
              incoming email as possible spam. The original message > has been attached
              to this so you can view it (if it isn't spam) or label > similar future email.
               If you have any questions, see > the administrator of that system for details.
               > Content preview: [ https://jira.fiware.org/browse/HELP-13082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
               > ] FW External User updated HELP-13082: Attachment: [FIWARE-JIRA] (HELP-13082)
               > [Fiware-general-help] [SPAM] Website Job Application [...] > Content analysis
               details: (6.1 points, 4.5 required) > pts rule name description > ---- >
              1.7 URIBL_BLACK Contains an URL listed in the URIBL blacklist > [URIs: latedeliver.com]
               > 2.5 URIBL_DBL_SPAM Contains a spam URL listed in the DBL blocklist > [URIs:
               latedeliver.com] > 0.0 FSL_HELO_NON_FQDN_1 FSL_HELO_NON_FQDN_1 > 3.8 HELO_LOCALHOST
               HELO_LOCALHOST > -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1% >
              [score: 0.0000] > > You can get more information about our cookies and privacy
               policies on the following links: > - http://forge.fiware.org/plugins/mediawiki/wiki/fiware/index.php/FIWARE_Privacy_Policy
               > - http://forge.fiware.org/plugins/mediawiki/wiki/fiware/index.php/Cookies_Policy_FIWARE
               > Fiware-general-help mailing list > Fiware-general-help@lists.fiware.org
               > https://lists.fiware.org/listinfo/fiware-general-help > [Created via e-mail
               received [...]

            Content analysis details: (6.9 points, 4.5 required)

             pts rule name description
            ---- ---------------------- --------------------------------------------------
             1.7 URIBL_BLACK Contains an URL listed in the URIBL blacklist
                                        [URIs: latedeliver.com]
             2.5 URIBL_DBL_SPAM Contains a spam URL listed in the DBL blocklist
                                        [URIs: latedeliver.com]
             0.0 FSL_HELO_NON_FQDN_1 FSL_HELO_NON_FQDN_1
             3.8 HELO_LOCALHOST HELO_LOCALHOST
            -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1%
                                        [score: 0.0000]
             0.8 RDNS_NONE Delivered to internal network by a host with no rDNS

            ]
            fla Fernando Lopez made changes -
            Attachment [FIWARE-JIRA] (HELP-13000) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application [ 61203 ]
            fw.ext.user FW External User made changes -
            Attachment [FIWARE-JIRA] (HELP-13000) [Fiware-general-help] [SPAM] [FIWARE-JIRA] (HELP-13082) [SPAM] Website Job Application [ 61203 ]
            Hide
            Permalink
            andres.munoza Andres Muñoz added a comment -

            Hi Fran,

            Do you have any feedback on your issue?

            Show
            andres.munoza Andres Muñoz added a comment - Hi Fran, Do you have any feedback on your issue?
            jicg José Ignacio Carretero Guarde made changes -
            Assignee José Ignacio Carretero Guarde [ jicg ] Joaquín Salvachúa [ joaquin.salvachua ]
            jsalvachua Joaquin Salvachua made changes -
            Attachment agent.conf [ 60090 ]
            jsalvachua Joaquin Salvachua made changes -
            Attachment imageedit_2_6393390379.png [ 60089 ]
            Hide
            Permalink
            jsalvachua Joaquin Salvachua added a comment -

            Hi Fran,
            I am Andrés, I have made a test with a clean installation of MySql and Cygnus and it works without problems, to this comment I am attaching yo the agent.conf file that I used, if you run Cygnus with the script that I sent previously, you will have the data in your MysqlDB as is shown in the attached figure. Please compare your agent.conf file to find the possible error in your configuration and give know if you can solve the problem.

            Show
            jsalvachua Joaquin Salvachua added a comment - Hi Fran, I am Andrés, I have made a test with a clean installation of MySql and Cygnus and it works without problems, to this comment I am attaching yo the agent.conf file that I used, if you run Cygnus with the script that I sent previously, you will have the data in your MysqlDB as is shown in the attached figure. Please compare your agent.conf file to find the possible error in your configuration and give know if you can solve the problem.
            jicg José Ignacio Carretero Guarde made changes -
            Assignee Stefano De Panfilis [ stefano ] José Ignacio Carretero Guarde [ jicg ]
            jicg José Ignacio Carretero Guarde made changes -
            Status In Progress [ 3 ] Answered [ 10104 ]
            jicg José Ignacio Carretero Guarde made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            Hide
            Permalink
            jicg José Ignacio Carretero Guarde added a comment -

            I think this means you request closing ticket https://jira.fiware.org/browse/HELP-12983

            Regards,
            José Ignacio

            Show
            jicg José Ignacio Carretero Guarde added a comment - I think this means you request closing ticket https://jira.fiware.org/browse/HELP-12983 Regards, José Ignacio
            backlogmanager Backlog Manager made changes -
            Assignee Stefano De Panfilis [ stefano ]
            backlogmanager Backlog Manager made changes -
            Field Original Value New Value
            Component/s FIWARE-GENERAL-HELP [ 10277 ]
            fw.ext.user FW External User created issue -

              People

              • Assignee:
                andres.munoza Andres Muñoz
                Reporter:
                fw.ext.user FW External User
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: