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

        backlogmanager Backlog Manager created issue -
        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 made changes -
        Field Original Value New Value
        Component/s FIWARE-TECH-HELP [ 10278 ]
        backlogmanager Backlog Manager made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        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 In Progress [ 3 ] Answered [ 10104 ]
        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
        mev Manuel Escriche made changes -
        Resolution Done [ 10000 ]
        Status Answered [ 10104 ] Closed [ 6 ]
        mev Manuel Escriche made changes -
        Assignee Fermín Galán [ fermin ]
        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.
        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.Question.Tech.Data.OrionContextBroker.SpecifyFiwareService FIWARE.Question.Tech.Data.OrionContextBroker.SpecifyFiwareServiceFieldsToSetTheNameOfMysqlDatabaseinCygnus
        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.HowtoSpecifyFiwareServiceFieldsToSetTheNameOfMysqlDatabaseinCygnus FIWARE.Question.Tech.Data.OrionContextBroker.HowToSpecifyFiwareServiceFieldsToSetTheNameOfMysqlDatabaseinCygnus
        mev Manuel Escriche made changes -
        HD-Enabler Orion [ 10875 ]
        HD-Chapter Data [ 10838 ]
        fla Fernando Lopez made changes -
        Fix Version/s 2021 [ 12600 ]
        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

          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: