MYSQL Workbench



  • 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


  • ADMIN

    @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



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



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


  • ADMIN

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



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


  • ADMIN

    @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



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


  • ADMIN

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



  • @jkandasa The purge in the Snapshot is working great.


Log in to reply