MYSQL Workbench

[cjm4909]

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]

@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

[cjm4909]

@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

[cjm4909]

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

[jkandasa]

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

[cjm4909]

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

@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

[cjm4909]

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

[jkandasa]

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

[cjm4909]

@jkandasa The purge in the Snapshot is working great.