• Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    MYSQL Workbench

    General Discussion
    2
    10
    3990
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • C
      cjm4909 last edited by

      Can you use MySQL Workbench to access/update the H2DB database? Some of my sensors have stored incorrect (out of range) data and I want to clean it up so the graph is displayed correctly again?

      Thanks

      jkandasa 1 Reply Last reply Reply Quote 0
      • jkandasa
        jkandasa @cjm4909 last edited by

        @cjm4909 You cannot use MySQL workbench to access H2 database, However you can use H2 db utilities to access H2 database.
        To access via command line follow this: http://forum.mycontroller.org/topic/18/forgotten-password/2

        To access on browser: just run java -cp h2/bin/h2*.jar command once you downloaded http://www.h2database.com/h2-2014-04-05.zip.

        IMPORTANT: MyController server should be stopped when you access H2 database

        1 Reply Last reply Reply Quote 0
        • C
          cjm4909 last edited by

          @jkandasa said:

          @cjm4909 You cannot use MySQL workbench to access H2 database, However you can use H2 db utilities to access H2 database.
          To access via command line follow this: http://forum.mycontroller.org/topic/18/forgotten-password/2

          To access on browser: just run java -cp h2/bin/h2*.jar command once you downloaded http://www.h2database.com/h2-2014-04-05.zip.

          IMPORTANT: MyController server should be stopped when you access H2 database

          Thank you

          1 Reply Last reply Reply Quote 0
          • C
            cjm4909 last edited by

            I was able to connect via the browser, what table/tables would hold the sensor data?

            jkandasa 1 Reply Last reply Reply Quote 0
            • jkandasa
              jkandasa @cjm4909 last edited by

              @cjm4909 If you are looking sensor, then should be sensor
              If you are looking sensor variable, then should be sensor_variable

              Please note: Some internal mapping will be added for each resources on DB. Which is not a good approach to clean from database. What is the exact issue are you facing?

              C 1 Reply Last reply Reply Quote 0
              • C
                cjm4909 @jkandasa last edited by

                @jkandasa no real issue, I just have a few temp sensors that produce an incorrect value sometimes (3434430.00 F) and I would like to remove those values from the data.

                jkandasa 1 Reply Last reply Reply Quote 0
                • jkandasa
                  jkandasa @cjm4909 last edited by

                  @cjm4909 You can remove this value from GUI, Yes, in recent build(SNAPSHOT) build we have an option on sensorVariable

                  Navigate to Resources >> Sensors >> Detailed view of your sensor, click on purge icon,
                  0_1480001122380_upload-6e5ee459-e643-4777-83ca-87e95409e3c1

                  Now select value range and time range(if required).
                  0_1480001233595_upload-7142d40f-74e2-4a3f-9715-764d78660eda

                  NOTE: If you leave all the fields blank, will delete everything(metrics).

                  You can remove it from database table also, check it on the table metrics_double_type_device and remove it

                  1 Reply Last reply Reply Quote 0
                  • C
                    cjm4909 last edited by cjm4909

                    Thank you, I assume the most recent build isn't out yet. I am on 0.0.3.Alpha2.

                    jkandasa 1 Reply Last reply Reply Quote 0
                    • jkandasa
                      jkandasa @cjm4909 last edited by

                      @cjm4909 Yes, however you can download SNAPSHOT build from http://forum.mycontroller.org/topic/58/download-snapshot-build

                      C 1 Reply Last reply Reply Quote 0
                      • C
                        cjm4909 @jkandasa last edited by

                        @jkandasa The purge in the Snapshot is working great.

                        1 Reply Last reply Reply Quote 1
                        • First post
                          Last post

                        0
                        Online

                        638
                        Users

                        495
                        Topics

                        3.2k
                        Posts

                        Copyright © 2015-2022 MyController.org | Contributors | Localization