Details

    • Type: extRequest
    • Status: Closed
    • Priority: Major
    • Resolution: Done
    • Fix Version/s: 2021
    • Component/s: None
    • Labels:
      None
    • HD-Enabler:
      Cygnus

      Description

      To may it whom concern,

      I have a problem using Cygnus GE, while trying to persist data into a MySQL database, I have the following error:
      Note that I have tried several connections to my mysql database in regards to username/password. MySQL database is running in localhost.

      18/05/29 10:18:33 INFO handlers.OrionRestHandler: Received data ({ "subscriptionId" : "5b0d28f9cb1aeaf960c0cfde", "originator" : "localhost", "contextResponses" : [ { "contextElement" : { "type" : "Alert", "isPattern" : "false", "id" : "Alert1", "attributes" : [

      { "name" : "humidity", "type" : "double", "value" : "60.0" }

      ,

      { "name" : "temperature", "type" : "double", "value" : "18.0" }

      ] }, "statusCode" :

      { "code" : "200", "reasonPhrase" : "OK" }

      } ]})
      18/05/29 10:18:33 INFO handlers.OrionRestHandler: Event put in the channel, id=1289405620
      18/05/29 10:18:33 INFO sinks.OrionSink: Batch completed, persisting it
      18/05/29 10:18:33 INFO sinks.OrionMySQLSink: [mysql-sink] Persisting data at OrionMySQLSink. Database (hannover), Table (Messe_Alert1_Alert), Fields ((recvTimeTs,recvTime,fiwareServicePath,entityId,entityType,attrName,attrType,attrValue,attrMd)), Values (('1527589113105','2018-05-29T10:18:33.105Z','Messe','Alert1','Alert','humidity','double','60.0','[]'),('1527589113105','2018-05-29T10:18:33.105Z','Messe','Alert1','Alert','temperature','double','18.0','[]'))
      18/05/29 10:18:33 ERROR sinks.OrionSink: Persistence error (Could not create connection to database server.)
      18/05/29 10:18:33 INFO sinks.OrionSink: Rollbacking again (1527589098-265-0000000000), batch TTL=1
      18/05/29 10:18:37 INFO sinks.OrionMySQLSink: [mysql-sink] Persisting data at OrionMySQLSink. Database (hannover), Table (Messe_Alert1_Alert), Fields ((recvTimeTs,recvTime,fiwareServicePath,entityId,entityType,attrName,attrType,attrValue,attrMd)), Values (('1527589113105','2018-05-29T10:18:33.105Z','Messe','Alert1','Alert','humidity','double','60.0','[]'),('1527589113105','2018-05-29T10:18:33.105Z','Messe','Alert1','Alert','temperature','double','18.0','[]'))
      18/05/29 10:18:37 ERROR sinks.OrionSink: Persistence error (Could not create connection to database server.)
      18/05/29 10:18:37 INFO sinks.OrionSink: Rollbacking again (1527589098-265-0000000000), batch TTL=0
      18/05/29 10:18:42 INFO sinks.OrionMySQLSink: [mysql-sink] Persisting data at OrionMySQLSink. Database (hannover), Table (Messe_Alert1_Alert), Fields ((recvTimeTs,recvTime,fiwareServicePath,entityId,entityType,attrName,attrType,attrValue,attrMd)), Values (('1527589113105','2018-05-29T10:18:33.105Z','Messe','Alert1','Alert','humidity','double','60.0','[]'),('1527589113105','2018-05-29T10:18:33.105Z','Messe','Alert1','Alert','temperature','double','18.0','[]'))
      18/05/29 10:18:42 ERROR sinks.OrionSink: Persistence error (Could not create connection to database server.)
      18/05/29 10:18:42 INFO sinks.OrionSink: TTL exhausted, finishing transaction (1527589098-265-0000000000)
      18/05/29 10:18:48 ERROR interceptors.GroupingRules: File not found. Details=/usr/cygnus/conf/grouping_rules.conf (No existe el fichero o el directorio))

      Un saludo.
      [cid:DCD632D2362FA94AA920D83BBD02BC4D@eurprd02.prod.outlook.com]
      Javier Hitado Simarro
      Research & Innovation
      T + 34946662100
      javier.hitadosimarro@atos.net<javier.hitadosimarro@atos.net>
      48013 Bilbao
      Atos.net
      [cid:F3AF942C56D2D346AAE13531D39D5BAF@eurprd02.prod.outlook.com]

      This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it.
      As its integrity cannot be secured on the Internet, the Atos group liability cannot be triggered for the message content. Although the sender endeavors to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted.

      Este mensaje y los ficheros adjuntos pueden contener información confidencial destinada solamente a la(s) persona(s) mencionadas anteriormente y pueden estar protegidos por secreto profesional.
      Si usted recibe este correo electrónico por error, gracias por informar inmediatamente al remitente y destruir el mensaje.
      Al no estar asegurada la integridad de este mensaje sobre la red, Atos no se hace responsable por su contenido. Su contenido no constituye ningún compromiso para el grupo Atos, salvo ratificación escrita por ambas partes.
      Aunque se esfuerza al máximo por mantener su red libre de virus, el emisor no puede garantizar nada al respecto y no será responsable de cualesquiera daños que puedan resultar de una transmisión de virus.

      [Created via e-mail received from: "Hitado Simarro, Javier" <javier.hitadosimarro@atos.net>]

        Activity

        Hide
        andres.munoza Andres Muñoz added a comment -

        Hi Javier,

        One of the main problems of your configuration is that you are using an old version of Cygnus. Also if you are using Orion with Cygnus of better to work with Cygnus-NGSI. The lastes documentation and a few configuration examples are available here http://fiware-cygnus.readthedocs.io/en/latest/ . Please try to install and configure Cygnus-NGSI following that guidelines and if your issue persist, let me know.

        Best Regards,

        Show
        andres.munoza Andres Muñoz added a comment - Hi Javier, One of the main problems of your configuration is that you are using an old version of Cygnus. Also if you are using Orion with Cygnus of better to work with Cygnus-NGSI. The lastes documentation and a few configuration examples are available here http://fiware-cygnus.readthedocs.io/en/latest/ . Please try to install and configure Cygnus-NGSI following that guidelines and if your issue persist, let me know. Best Regards,

          People

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

            Dates

            • Created:
              Updated:
              Resolved: