Cannot remove device from tracing

Posted on
Wed Jan 13, 2021 8:31 pm
kw123 offline
User avatar
Posts: 7731
Joined: May 12, 2013
Location: Dallas, TX

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

Posted on
Thu Jan 14, 2021 10:10 am
bjmouton offline
Posts: 65
Joined: Jul 23, 2017

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

Posted on
Thu Jan 14, 2021 11:38 am
kw123 offline
User avatar
Posts: 7731
Joined: May 12, 2013
Location: Dallas, TX

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

Posted on
Thu Jan 14, 2021 12:18 pm
kw123 offline
User avatar
Posts: 7731
Joined: May 12, 2013
Location: Dallas, TX

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

Posted on
Thu Jan 14, 2021 1:57 pm
bjmouton offline
Posts: 65
Joined: Jul 23, 2017

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

Posted on
Thu Jan 14, 2021 3:10 pm
kw123 offline
User avatar
Posts: 7731
Joined: May 12, 2013
Location: Dallas, TX

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

Posted on
Thu Jan 14, 2021 7:41 pm
bjmouton offline
Posts: 65
Joined: Jul 23, 2017

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
Screen Shot 2021-01-14 at 19.26.43.png (489.64 KiB) Viewed 650 times
Screen Shot 2021-01-14 at 19.36.17.png
Screen Shot 2021-01-14 at 19.36.17.png (125.22 KiB) Viewed 650 times
Screen Shot 2021-01-14 at 19.35.20.png
Screen Shot 2021-01-14 at 19.35.20.png (182.61 KiB) Viewed 650 times

Posted on
Thu Jan 14, 2021 10:00 pm
kw123 offline
User avatar
Posts: 7731
Joined: May 12, 2013
Location: Dallas, TX

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

Posted on
Thu Jan 14, 2021 10:07 pm
bjmouton offline
Posts: 65
Joined: Jul 23, 2017

Re: Cannot remove device from tracing

The directory structure not even close...
Attachments
Screen Shot 2021-01-14 at 22.05.08.png
Screen Shot 2021-01-14 at 22.05.08.png (302.01 KiB) Viewed 638 times

Posted on
Thu Jan 14, 2021 10:24 pm
kw123 offline
User avatar
Posts: 7731
Joined: May 12, 2013
Location: Dallas, TX

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

Posted on
Thu Jan 14, 2021 10:39 pm
kw123 offline
User avatar
Posts: 7731
Joined: May 12, 2013
Location: Dallas, TX

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

Posted on
Thu Jan 14, 2021 11:15 pm
bjmouton offline
Posts: 65
Joined: Jul 23, 2017

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
Screen Shot 2021-01-14 at 23.09.36.png (182.03 KiB) Viewed 610 times

Posted on
Thu Jan 14, 2021 11:28 pm
kw123 offline
User avatar
Posts: 7731
Joined: May 12, 2013
Location: Dallas, TX

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

Posted on
Fri Jan 15, 2021 9:46 am
kw123 offline
User avatar
Posts: 7731
Joined: May 12, 2013
Location: Dallas, TX

Re: Cannot remove device from tracing

/Applications/Postgres.app/Contents/Versions/latest/bin/psql
is mine for v 13
Screen Shot 2021-01-15 at 09.44.32.png
Screen Shot 2021-01-15 at 09.44.32.png (162.3 KiB) Viewed 541 times


did you download from here?
https://github.com/PostgresApp/Postgres ... 4.1-13.dmg

Karl

Posted on
Fri Jan 15, 2021 2:30 pm
bjmouton offline
Posts: 65
Joined: Jul 23, 2017

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

Who is online

Users browsing this forum: No registered users and 1 guest