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

FIWARE.Question.Tech.Data.OrionContextBroker.HowToSpecifyFiwareServiceFieldsToSetTheNameOfMysqlDatabaseinCygnus

    Details

      Description

      Created question in FIWARE Q/A platform on 23-04-2015 at 09:04
      Please, ANSWER this question AT http://stackoverflow.com/questions/29816214/how-i-specify-the-fiware-service-and-fiware-servicepath-fields-at-orion-that-set

      Question:
      How I specify the Fiware-Service and Fiware-ServicePath fields at Orion that set the name of MySQL database and table in Cygnus?

      Description:
      So far I have configured ContextBroker to send data to Cygnus which in turn saves data by default names in database.

      But what if I want to target a specific database with a specific table?

      I know I have to set:

      dbName=<fiware-service>
      tableName=<fiware-servicePath><entityId><entityType>

      I dont know where that file is, and I know it isnt in /etc/sysconfig/contextBroker because that folder doesnt exist.

      EDIT1: here is my updatecontext:

      (curl localhost:1026/NGSI10/updateContext s -S --header 'Content-Type: application/json' --header 'Accept: application/json' --header 'Fiware-Service: FiwareDatabase' --header 'Fiware-ServicePath: /AllSensors' -d @ ) <<EOF
      {
      "contextElements": [
      {
      "type": "Television",
      "isPattern": "false",
      "id": "TV2",
      "attributes": [

      { "name": "channel", "type": "integer", "value": "14" }

      ,

      { "name": "volume", "type": "float", "value": "9" }

      ]
      }
      ],
      "updateAction": "APPEND"
      }
      EOF

      As I said the table does get automatically created but the database doesnt.

        Activity

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open In Progress In Progress
        3h 1 Backlog Manager 28/Oct/15 6:04 PM
        In Progress In Progress Answered Answered
        2h 59m 1 Backlog Manager 28/Oct/15 9:04 PM
        Answered Answered Closed Closed
        11h 37m 1 Manuel Escriche 29/Oct/15 8:42 AM
        fla Fernando Lopez made changes -
        Fix Version/s 2021 [ 12600 ]
        mev Manuel Escriche made changes -
        HD-Enabler Orion [ 10875 ]
        HD-Chapter Data [ 10838 ]
        oriondev TID Orion Developer made changes -
        Summary FIWARE.Question.Tech.Data.OrionContextBroker.HowtoSpecifyFiwareServiceFieldsToSetTheNameOfMysqlDatabaseinCygnus FIWARE.Question.Tech.Data.OrionContextBroker.HowToSpecifyFiwareServiceFieldsToSetTheNameOfMysqlDatabaseinCygnus
        oriondev TID Orion Developer made changes -
        Summary FIWARE.Question.Tech.Data.OrionContextBroker.SpecifyFiwareServiceFieldsToSetTheNameOfMysqlDatabaseinCygnus FIWARE.Question.Tech.Data.OrionContextBroker.HowtoSpecifyFiwareServiceFieldsToSetTheNameOfMysqlDatabaseinCygnus
        oriondev TID Orion Developer made changes -
        Summary FIWARE.Question.Tech.Data.OrionContextBroker.SpecifyFiwareService FIWARE.Question.Tech.Data.OrionContextBroker.SpecifyFiwareServiceFieldsToSetTheNameOfMysqlDatabaseinCygnus
        oriondev TID Orion Developer made changes -
        Summary FIWARE.Question.Tech.Data.OrionContextBroker. FIWARE.Question.Tech.Data.OrionContextBroker.SpecifyFiwareService
        oriondev TID Orion Developer made changes -
        Summary [fiware-stackoverflow] How I specify the Fiware-Service and Fiware-ServicePath fields at Orion that set the name of MySQL database and table in Cygnus? FIWARE.Question.Tech.Data.OrionContextBroker.
        mev Manuel Escriche made changes -
        Assignee Fermín Galán [ fermin ]
        mev Manuel Escriche made changes -
        Resolution Done [ 10000 ]
        Status Answered [ 10104 ] Closed [ 6 ]
        Hide
        backlogmanager Backlog Manager added a comment -

        2015-10-28 21:05|UPDATED status: transition Answered| # answers= 1, accepted answer= True

        Show
        backlogmanager Backlog Manager added a comment - 2015-10-28 21:05|UPDATED status: transition Answered| # answers= 1, accepted answer= True
        backlogmanager Backlog Manager made changes -
        Status In Progress [ 3 ] Answered [ 10104 ]
        Hide
        backlogmanager Backlog Manager added a comment -

        2015-10-28 18:05|UPDATED status: transition Answer| # answers= 1, accepted answer= True

        Show
        backlogmanager Backlog Manager added a comment - 2015-10-28 18:05|UPDATED status: transition Answer| # answers= 1, accepted answer= True
        backlogmanager Backlog Manager made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        backlogmanager Backlog Manager made changes -
        Field Original Value New Value
        Component/s FIWARE-TECH-HELP [ 10278 ]
        Hide
        backlogmanager Backlog Manager added a comment -

        2015-10-28 15:05|CREATED monitor | # answers= 1, accepted answer= True

        Show
        backlogmanager Backlog Manager added a comment - 2015-10-28 15:05|CREATED monitor | # answers= 1, accepted answer= True
        backlogmanager Backlog Manager created issue -

          People

          • Assignee:
            fermin Fermín Galán
            Reporter:
            backlogmanager Backlog Manager
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: