Cannot remove device from tracing
Cannot remove device from tracing
Mine update correctly
Not all variables update all the time. Ie thisdaymax changes only when a new max happens today.
Naturally it is your choice to use this plugin
Karl
Sent from my iPhone using Tapatalk
Not all variables update all the time. Ie thisdaymax changes only when a new max happens today.
Naturally it is your choice to use this plugin
Karl
Sent from my iPhone using Tapatalk
Re: Cannot remove device from tracing
I found that my sql logger plugin was not enabled, once enabled all applicable data populated, that was apparently the problem. Is there any way to edit values in the log? I have goofy value in a variable that I would like to correct if possible; e.g. "xxx_value_thisDay_Max" has value of 143.5, it is a temperature and should be 43.5, don't know why it recorded 143.5.
Thanks,
Billy
Thanks,
Billy
Re: Cannot remove device from tracing
you could use an sql tool to edit the db, there is nothing from teh indigo side. indigo just added new entries and has the option to purge old data
So you could purge device(s)
indigo by default only does all devices before xx and all variables before xx..
utilities plugin has an option to purge ONE device/ variable .. as I recall
Karl
So you could purge device(s)
indigo by default only does all devices before xx and all variables before xx..
utilities plugin has an option to purge ONE device/ variable .. as I recall
Karl
Re: Cannot remove device from tracing
... And the min max plugin has the option to ignore values outside a range.
Set the range at the bottom of the selection screen
Sent from my iPhone using Tapatalk
Set the range at the bottom of the selection screen
Sent from my iPhone using Tapatalk
Re: Cannot remove device from tracing
I am experimenting with an editor. I found & made a copy of what I believe is the correct database "indigo_history.sqlite". I imported it into the editor & can see the definition of db structure including the Indigo item number I want to edit, but I see no actual data records in this file. Does the logged data reside in another file?
Billy
Billy
Re: Cannot remove device from tracing
If you don’t know what you are doing = doing this the first time - I strongly suggest to not mess around with the sql dB.
And may I suggest to switch from SQLite to Postgres dB
Installation is very simple
1 download Postgres app
2 install = double click on downloaded app
3 in indigo switch from SQLite to Postgres in sqllogger ( and in minmax plugin )
Postgres is much more stable than SQLite, faster and ...
SQLite is just one file, any issue will render your dB corrupt will just grow - difficult to compress
Sent from my iPhone using Tapatalk
And may I suggest to switch from SQLite to Postgres dB
Installation is very simple
1 download Postgres app
2 install = double click on downloaded app
3 in indigo switch from SQLite to Postgres in sqllogger ( and in minmax plugin )
Postgres is much more stable than SQLite, faster and ...
SQLite is just one file, any issue will render your dB corrupt will just grow - difficult to compress
Sent from my iPhone using Tapatalk
Re: Cannot remove device from tracing
Tried switching to postgreSQL, but something not right,all data links are severed. The min/Max config snapshot is in two captures due to file size limit. Any suggestions?
- Attachments
-
- Screen Shot 2021-01-14 at 19.26.43.png (489.64 KiB) Viewed 4807 times
-
- Screen Shot 2021-01-14 at 19.36.17.png (125.22 KiB) Viewed 4807 times
-
- Screen Shot 2021-01-14 at 19.35.20.png (182.61 KiB) Viewed 4807 times
Re: Cannot remove device from tracing
in config try:
/Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgres
instead of
/Library/PostgreSQL/bin/psql indigo_history postgres
that is the path to the postgres binary in the app
the plugin need to know where to find postgres.
Karl
/Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgres
instead of
/Library/PostgreSQL/bin/psql indigo_history postgres
that is the path to the postgres binary in the app
the plugin need to know where to find postgres.
Karl
Re: Cannot remove device from tracing
The directory structure not even close...
- Attachments
-
- Screen Shot 2021-01-14 at 22.05.08.png (302.01 KiB) Viewed 4795 times
Re: Cannot remove device from tracing
To try it open terminal
And paste the path and hit enter
Only the psql part when you get a prompt eg #
you are right
Sent from my iPhone using Tapatalk
And paste the path and hit enter
Only the psql part when you get a prompt eg #
you are right
Sent from my iPhone using Tapatalk
Re: Cannot remove device from tracing
....And the app is actually a directory. You need to right click on the psql.app and select contents. And go down until you find psql.bin (likely that’s the name)
Sent from my iPhone using Tapatalk
Sent from my iPhone using Tapatalk
Re: Cannot remove device from tracing
"SQL Shell (psql).app" is the closest thing I could find, I drill down into all sub folders and did find "psql.bin". I also did finder search for "psql.bin" and results were empty.
- Attachments
-
- Screen Shot 2021-01-14 at 23.09.36.png (182.03 KiB) Viewed 4767 times
Re: Cannot remove device from tracing
Mine is still at v10.
I will download the latest tomorrow and check.
Sent from my iPhone using Tapatalk
I will download the latest tomorrow and check.
Sent from my iPhone using Tapatalk
Re: Cannot remove device from tracing
/Applications/Postgres.app/Contents/Versions/latest/bin/psql
is mine for v 13 did you download from here?
https://github.com/PostgresApp/Postgres ... 4.1-13.dmg
Karl
is mine for v 13 did you download from here?
https://github.com/PostgresApp/Postgres ... 4.1-13.dmg
Karl
Re: Cannot remove device from tracing
I removed previous postgres install and re-installed from the link you provided. Directories line with with your directions now, but I am still not getting data from db. I didn't see any similar path setup in SQL Logger config, I think perhaps the SQL Logger is not doing what it needs to.
Billy
Billy