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

MYSQL Workbench

Scheduled Pinned Locked Moved General Discussion
10 Posts 2 Posters 4.5k Views 1 Watching
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 Offline
    cjm4909
    last edited by 23 Nov 2016, 16:58

    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

    J 1 Reply Last reply 23 Nov 2016, 17:24 Reply Quote 0
    • J Offline
      jkandasa @cjm4909
      last edited by 23 Nov 2016, 17:24

      @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 Offline
        cjm4909
        last edited by 23 Nov 2016, 17:45

        @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 Offline
          cjm4909
          last edited by 24 Nov 2016, 11:55

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

          J 1 Reply Last reply 24 Nov 2016, 13:01 Reply Quote 0
          • J Offline
            jkandasa @cjm4909
            last edited by 24 Nov 2016, 13:01

            @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 24 Nov 2016, 14:05 Reply Quote 0
            • C Offline
              cjm4909 @jkandasa
              last edited by 24 Nov 2016, 14:05

              @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.

              J 1 Reply Last reply 24 Nov 2016, 15:29 Reply Quote 0
              • J Offline
                jkandasa @cjm4909
                last edited by 24 Nov 2016, 15:29

                @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 Offline
                  cjm4909
                  last edited by cjm4909 24 Nov 2016, 17:58

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

                  J 1 Reply Last reply 25 Nov 2016, 01:03 Reply Quote 0
                  • J Offline
                    jkandasa @cjm4909
                    last edited by 25 Nov 2016, 01:03

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

                    C 1 Reply Last reply 25 Mar 2017, 23:39 Reply Quote 0
                    • C Offline
                      cjm4909 @jkandasa
                      last edited by 25 Mar 2017, 23:39

                      @jkandasa The purge in the Snapshot is working great.

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

                      2

                      Online

                      618

                      Users

                      531

                      Topics

                      3.4k

                      Posts
                      Copyright © 2015-2025 MyController.org | Contributors | Localization