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
-
@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/2To 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/2To 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?
-
@cjm4909 If you are looking sensor, then should be
sensor
If you are looking sensor variable, then should besensor_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.
-
@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,
Now select value range and time range(if required).
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.
-
@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.