problem when creating a device

Posted on
Wed Feb 28, 2018 12:36 pm
bsp9493 offline
Posts: 153
Joined: Nov 30, 2017
Location: Kelowna, BC

problem when creating a device

Hi...

Love this plugin... it has some real potential for me and I'm sure others.

Question...
I have looked through the 1st steps and am having a couple problems and would appreciate your input.

background
mac mini el capitan

current versions of:
Indigo 7
sqlite
gnu plot

looked for an answer, but couldn't find a solution

reviewing INDIGOplotD - 1st steps
trying to plot temps from 3 thermostats in system

from plugin
- print variable states for eligibility to ensure I am using valid items

Step 1 define data to be tracked for plotting
no issue
i am able to select the 3 valid devices that I want, confirm them, and then select the state I want to graph

Step 2
from indigo, create a new device, fill it in as in your example, and hit confirm
no issue

Step 3
add the lines that I want to plot
I have again checked vs your screenshot to ensure my settings are the same
modify or add line
datasource for this line
- i see the datasource i want (1 of 3) but when I select it, the field just blanks out and I cannot ADD any lines to my graph?

This seems like it should be so simple to use. I have checked logs and can not see any glaring errors, data appears to be available via sql. Not sure what I am missing, or what is NOT set up correctly?


Your help would be appreciated.

Thanx

Dave

Posted on
Wed Feb 28, 2018 10:29 pm
bsp9493 offline
Posts: 153
Joined: Nov 30, 2017
Location: Kelowna, BC

L

Problem solved...

Corrupt db file. Not sure where or how, but fortunately, I didn't have too much history in there.

Disabled SQL Logger and INDIGOplotD
Deleted indigo_history.sqlite

Enabled INDIGOplotD
Double checked my settings, added my lines
voila!!!

Enabled SQL Logger

and I am now producing wonderful graphs!!!

Wonderful Plugin!!!

d

Posted on
Thu Mar 01, 2018 12:27 am
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

problem when creating a device

Thanks for the compliments.

Strongly suggest to switch to Postgres.
With prostgres app the install is very simple.

Postgres is much more stable than SQLite.
No probs for >2 years with Postgres and the dB is 30+gbyte.

With SQLite there where issues 2 a year. Especially when you have power failure etc. SQLite is just a single file. Any corruption will likely destroy the whole dB.



Sent from my iPhone using Tapatalk

Posted on
Thu Mar 01, 2018 2:23 am
siclark offline
Posts: 1960
Joined: Jun 13, 2017
Location: UK

Re: problem when creating a device

Yes. If you've just started again with history definitely switch to postgres.


Sent from my iPhone using Tapatalk

Posted on
Thu Mar 01, 2018 3:41 pm
bsp9493 offline
Posts: 153
Joined: Nov 30, 2017
Location: Kelowna, BC

Re: problem when creating a device

I had looked at postgres org in the past, but found the installation a bit cumbersome and for some reason, the load on my old mac mini was just too much - super sluggish.

I found postgres app and installed this am. Much simpler to install and no apparent hit to the old machine that I can see at this time either. So far so good and YES, you guys are right, this appears to be a way more stable implementation for a SQL db.


Still one strange thing, and I'm guessing it's normal functionality.

When I go to modify a graph I have already created (i.e. to add new or different lines to the indigo plot device)
- I define/create the the new sources in INDIGOplotD

then I MUST
- DISABLE the SQL Logger Plugin
- DISABLE and then ENABLE INDIGOplotD
- make changes to my plot device (i.e. add new lines based on the new sources I just added)

if I don't disable SQL logger and then disable and enable INDIGOplotD - I get the issue I noted earlier where I select the new source and it just populates as blank.
if I do the above, everything seems to work fine.

Is this expected? or do I still have something broken?


Thanx

d

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 3 guests