INDIGOplotD -- a plot tool for indigo

A Plugin to create Plots from INDIGO data and other sources
Post Reply
Devildog0331
Posts: 72
Joined: Wed Jan 22, 2014 11:44 pm
Location: Baton Rouge, LA

Re: INDIGOplotD -- a plot tool for indigo

Post by Devildog0331 »

Ran into a snag with ONLINE mode. Had a long line of repeating messages but no errors. Tried resetting to defaults and defining a new device... no luck.
Switched to BATCH mode - had an error. Switched to SQL Logger mode - appeared to be ok.
Long log output - not sure if you want me to post it or not (hate to keep jamming up your topic with em.

The repeating message while in ONLINE mode (1 every second):

Code: Select all

  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
I'll try playing around with the different setups and I'll advise of anything that may be useful.

--Richard
Top
User avatar
kw123
Posts: 8705
Joined: Sun May 12, 2013 4:44 pm
Location: Dallas, TX
Contact:
Contact kw123

Re: INDIGOplotD -- a plot tool for indigo

Post by kw123 »

could you switch debug OFF and post the log?
Top
Devildog0331
Posts: 72
Joined: Wed Jan 22, 2014 11:44 pm
Location: Baton Rouge, LA

Re: INDIGOplotD -- a plot tool for indigo

Post by Devildog0331 »

Thought about that one after I posted it... the line still repeats. Here's the marked up log:

Code: Select all

Jun 19, 2014, 9:01:14 PM
  Upgrading plugin "INDIGOplotD" to newer version 3.0.6 (previous version moved to trash)
  Loading plugin "INDIGOplotD 3.0.6"
  Starting plugin "INDIGOplotD 3.0.6" (pid 65666)
  Started plugin "INDIGOplotD 3.0.6"
  INDIGOplotD                     initializing  ... 3-0-6
  INDIGOplotD                     indigo version found: 6
  INDIGOplotD                     sql logger secs active:276.27 10
  INDIGOplotD                     could not read matplotPID file
  INDIGOplotD                     sqlLastID [0]
  INDIGOplotD                      read file /Users/richard/Documents/INDIGOPlotD/data/minute.dat lines: 2304
  INDIGOplotD                      read file /Users/richard/Documents/INDIGOPlotD/data/hour.dat lines: 912
  INDIGOplotD                      read file /Users/richard/Documents/INDIGOPlotD/data/day.dat lines: 390
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     read     device/prop from SQL db:  0:00:00.033576   get firstID  0
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                      sqlcmd=  SELECT id,ts, onOffState from device_history_745566283 t1  WHERE   t1.id > 0 and   t1.id <= 30000 and  NOT EXISTS ( SELECT  id, ts, onOffState t1 FROM  device_history_745566283 t2 WHERE t2.ts = t1.ts and   t2.id = t1.id -1   and   t2.onOffState = t1.onOffState )  LIMIT 20000
  INDIGOplotD                      ret= [[1, '2014-06-17 21:22:23.142786', False], [2, '2014-06-17 21:41:22.11516', False], [3, '2014-06-17 21:43:26.324752', True], [4, '2014-06-17 21:48:26.309973', False], [5, '2014-06-17 21:59:56.324306', False], [6, '2014-06-18 18:35:33.695111', True], [7, '2014-06-18 19:06:50.967978', False], [8, '2014-06-18 19:22:03.796874', True], [9, '2014-06-18 19:27:04.033178', False], [10, '2014-06-18 19:28:05.500836', True], [11, '2014-06-18 19:33:06.035489', False], [12, '2014-06-18 19:34:22.814873', True]
  INDIGOplotD                     [[1, '2014-06-17 21:22:23.142786', False], [2, '2014-06-17 21:41:22.11516', False], [3, '2014-06-17 21:43:26.324752', True], [4, '2014-06-17 21:48:26.309973', False], [5, '2014-06-17 21:59:56.324306', False], [6, '2014-06-18 18:35:33.695111', True], [7, '2014-06-18 19:06:50.967978', False], [8, '2014-06-18 19:22:03.796874', True], [9, '2014-06-18 19:27:04.033178', False], [10, '2014-06-18 19:28:05.500836', True], [11, '2014-06-18 19:33:06.035489', False], [12, '2014-06-18 19:34:22.814873', True]
  INDIGOplotD                     read     device/prop from SQL db:  0:00:00.064005   data base records read  22   firstID  0   lastID  22
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                      sqlcmd=  SELECT id,ts, onOffState from device_history_745566283 t1  WHERE   t1.id > 22 and   t1.id <= 30022 and  NOT EXISTS ( SELECT  id, ts, onOffState t1 FROM  device_history_745566283 t2 WHERE t2.ts = t1.ts and   t2.id = t1.id -1   and   t2.onOffState = t1.onOffState )  LIMIT 20000
  INDIGOplotD                      ret= []
  INDIGOplotD                     []
  INDIGOplotD                     Convert1 device/prop from SQL db:  0:00:00.094248 Switch, Work Bench-onOffState   Total data base records 22
  INDIGOplotD                     nrec into check  theProperty dType average onOffState   22
  INDIGOplotD                     nrec out of  check    23 rejects    0
  INDIGOplotD                     Convert1 device/prop from SQL db:  0:00:00.094438 Switch, Work Bench-onOffState-average            records read/accepted:       22/     22
  INDIGOplotD                     Convert2 device/prop from SQL db:  0:00:00.110686 Switch, Work Bench-onOffState-average            records read/converted:      22/     22 to PLOT format ==== rejected bad....ValueRange:     0 ..BadNumber:     0 ..sameTimeStamp:     0
  INDIGOplotD                     SQL import             2014-06-19 21:01:15.717854 ... finished, total number of records imported: 22
  INDIGOplotD                     initializing  ...2 
  INDIGOplotD                     sqlLastID [0]
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
****TRIMED REPEATING MESSAGE****  
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     command: reset device parameters
  INDIGOplotD                     command: reset device parameters done 
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     Updating device/prop from SQL db: no device or variable defined.. skipping update   ...

****RESET TO DEFAULTS & RELOADED THE PLUGIN****
Jun 19, 2014, 9:02:47 PM
  Reloading plugin "INDIGOplotD 3.0.6"
  Stopping plugin "INDIGOplotD 3.0.6" (pid 65666)
  INDIGOplotD                     stopConcurrentThread  ... 
  INDIGOplotD                     could not read matplotPID file
  INDIGOplotD                      stop matplot: not active, PID:  x
  INDIGOplotD                      main loop stopped
  INDIGOplotD                     stopConcurrentThread  ... 
  INDIGOplotD                     could not read matplotPID file
  INDIGOplotD                      stop matplot: not active, PID:  x
  Stopped plugin "INDIGOplotD 3.0.6"
  Starting plugin "INDIGOplotD 3.0.6" (pid 65800)
  Started plugin "INDIGOplotD 3.0.6"
  INDIGOplotD                     initializing  ... 3-0-6
  INDIGOplotD                     indigo version found: 6
  INDIGOplotD                     sql logger secs active:276.84 10
  INDIGOplotD                     could not read matplotPID file
  INDIGOplotD                     sqlLastID [0]
  INDIGOplotD                     numberOfDevs not the same kick out# 7
  INDIGOplotD                      read file /Users/richard/Documents/INDIGOPlotD/data/minute.dat lines: 2304
  INDIGOplotD                      read file /Users/richard/Documents/INDIGOPlotD/data/hour.dat lines: 912
  INDIGOplotD                      read file /Users/richard/Documents/INDIGOPlotD/data/day.dat lines: 390
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     Updating device/prop from SQL db: no device or variable defined.. skipping update   ...
  INDIGOplotD                     initializing  ...2 
  INDIGOplotD Error               ------------------------------------
  INDIGOplotD Error                not  configured yet, please select menue:  Indigo /plugins/indigoplot/Configure...
  INDIGOplotD Error               ------------------------------------

****DEFINED A NEW DEVICE****

Jun 19, 2014, 9:04:26 PM
  INDIGOplotD                     sqlLastID [0]
  INDIGOplotD                     numberOfDevs not the same kick out# 7
  INDIGOplotD                     initialized
  INDIGOplotD                     sqlLastID [0]
  INDIGOplotD                     numberOfDevs not the same kick out# 7

Jun 19, 2014, 9:05:26 PM
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     read     device/prop from SQL db:  0:00:00.032177   get firstID  0
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                      sqlcmd=  SELECT id,ts, onOffState from device_history_532434863 t1  WHERE   t1.id > 0 and   t1.id <= 30000 and  NOT EXISTS ( SELECT  id, ts, onOffState t1 FROM  device_history_532434863 t2 WHERE t2.ts = t1.ts and   t2.id = t1.id -1   and   t2.onOffState = t1.onOffState )  LIMIT 20000
  INDIGOplotD                      ret= [[1, '2014-06-17 21:22:23.130788', False], [2, '2014-06-17 21:41:22.09298', False], [3, '2014-06-17 21:43:26.298467', True], [4, '2014-06-17 21:48:26.284373', False], [5, '2014-06-17 21:59:56.3127', False], [6, '2014-06-18 19:01:50.408215', True], [7, '2014-06-18 19:06:50.946205', False], [8, '2014-06-18 19:22:03.773485', True], [9, '2014-06-18 19:27:04.0091', False], [10, '2014-06-18 19:28:05.471926', True], [11, '2014-06-18 19:33:06.009423', False], [12, '2014-06-18 19:33:18.711413', True], [1
  INDIGOplotD                     [[1, '2014-06-17 21:22:23.130788', False], [2, '2014-06-17 21:41:22.09298', False], [3, '2014-06-17 21:43:26.298467', True], [4, '2014-06-17 21:48:26.284373', False], [5, '2014-06-17 21:59:56.3127', False], [6, '2014-06-18 19:01:50.408215', True], [7, '2014-06-18 19:06:50.946205', False], [8, '2014-06-18 19:22:03.773485', True], [9, '2014-06-18 19:27:04.0091', False], [10, '2014-06-18 19:28:05.471926', True], [11, '2014-06-18 19:33:06.009423', False], [12, '2014-06-18 19:33:18.711413', True], [1
  INDIGOplotD                     read     device/prop from SQL db:  0:00:00.060382   data base records read  22   firstID  0   lastID  22
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                      sqlcmd=  SELECT id,ts, onOffState from device_history_532434863 t1  WHERE   t1.id > 22 and   t1.id <= 30022 and  NOT EXISTS ( SELECT  id, ts, onOffState t1 FROM  device_history_532434863 t2 WHERE t2.ts = t1.ts and   t2.id = t1.id -1   and   t2.onOffState = t1.onOffState )  LIMIT 20000
  INDIGOplotD                      ret= []
  INDIGOplotD                     []
  INDIGOplotD                     Convert1 device/prop from SQL db:  0:00:00.087340 Switch, Garage Main-onOffState   Total data base records 22
  INDIGOplotD                     nrec into check  theProperty dType average onOffState   22
  INDIGOplotD                     nrec out of  check    23 rejects    0
  INDIGOplotD                     Convert1 device/prop from SQL db:  0:00:00.087470 Switch, Garage Main-onOffState-average           records read/accepted:       22/     22
  INDIGOplotD                     Convert2 device/prop from SQL db:  0:00:00.102536 Switch, Garage Main-onOffState-average           records read/converted:      22/     22 to PLOT format ==== rejected bad....ValueRange:     0 ..BadNumber:     0 ..sameTimeStamp:     0
  INDIGOplotD                     SQL import             2014-06-19 21:05:26.862491 ... finished, total number of records imported: 22
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     sqlLastID [0]
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  Reloading plugin "INDIGOplotD 3.0.6"
  Stopping plugin "INDIGOplotD 3.0.6" (pid 65800)
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     stopConcurrentThread  ... 
  INDIGOplotD                     could not read matplotPID file
  INDIGOplotD                      stop matplot: not active, PID:  x
  INDIGOplotD                      main loop stopped
  INDIGOplotD                     stopConcurrentThread  ... 
  INDIGOplotD                     could not read matplotPID file
  INDIGOplotD                      stop matplot: not active, PID:  x
  Stopped plugin "INDIGOplotD 3.0.6"
  Starting plugin "INDIGOplotD 3.0.6" (pid 66017)
  Started plugin "INDIGOplotD 3.0.6"
  INDIGOplotD                     initializing  ... 3-0-6
  INDIGOplotD                     indigo version found: 6
  INDIGOplotD                     sql logger secs active:278.01 10
  INDIGOplotD                     could not read matplotPID file
  INDIGOplotD                     sqlLastID [0]
  INDIGOplotD                      read file /Users/richard/Documents/INDIGOPlotD/data/minute.dat lines: 2304
  INDIGOplotD                      read file /Users/richard/Documents/INDIGOPlotD/data/hour.dat lines: 912
  INDIGOplotD                      read file /Users/richard/Documents/INDIGOPlotD/data/day.dat lines: 390
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     read     device/prop from SQL db:  0:00:00.025496   get firstID  0
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                      sqlcmd=  SELECT id,ts, onOffState from device_history_532434863 t1  WHERE   t1.id > 0 and   t1.id <= 30000 and  NOT EXISTS ( SELECT  id, ts, onOffState t1 FROM  device_history_532434863 t2 WHERE t2.ts = t1.ts and   t2.id = t1.id -1   and   t2.onOffState = t1.onOffState )  LIMIT 20000
  INDIGOplotD                      ret= [[1, '2014-06-17 21:22:23.130788', False], [2, '2014-06-17 21:41:22.09298', False], [3, '2014-06-17 21:43:26.298467', True], [4, '2014-06-17 21:48:26.284373', False], [5, '2014-06-17 21:59:56.3127', False], [6, '2014-06-18 19:01:50.408215', True], [7, '2014-06-18 19:06:50.946205', False], [8, '2014-06-18 19:22:03.773485', True], [9, '2014-06-18 19:27:04.0091', False], [10, '2014-06-18 19:28:05.471926', True], [11, '2014-06-18 19:33:06.009423', False], [12, '2014-06-18 19:33:18.711413', True], [1
  INDIGOplotD                     [[1, '2014-06-17 21:22:23.130788', False], [2, '2014-06-17 21:41:22.09298', False], [3, '2014-06-17 21:43:26.298467', True], [4, '2014-06-17 21:48:26.284373', False], [5, '2014-06-17 21:59:56.3127', False], [6, '2014-06-18 19:01:50.408215', True], [7, '2014-06-18 19:06:50.946205', False], [8, '2014-06-18 19:22:03.773485', True], [9, '2014-06-18 19:27:04.0091', False], [10, '2014-06-18 19:28:05.471926', True], [11, '2014-06-18 19:33:06.009423', False], [12, '2014-06-18 19:33:18.711413', True], [1
  INDIGOplotD                     read     device/prop from SQL db:  0:00:00.056066   data base records read  22   firstID  0   lastID  22
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                      sqlcmd=  SELECT id,ts, onOffState from device_history_532434863 t1  WHERE   t1.id > 22 and   t1.id <= 30022 and  NOT EXISTS ( SELECT  id, ts, onOffState t1 FROM  device_history_532434863 t2 WHERE t2.ts = t1.ts and   t2.id = t1.id -1   and   t2.onOffState = t1.onOffState )  LIMIT 20000
  INDIGOplotD                      ret= []
  INDIGOplotD                     []
  INDIGOplotD                     Convert1 device/prop from SQL db:  0:00:00.083094 Switch, Garage Main-onOffState   Total data base records 22
  INDIGOplotD                     nrec into check  theProperty dType average onOffState   22
  INDIGOplotD                     nrec out of  check    23 rejects    0
  INDIGOplotD                     Convert1 device/prop from SQL db:  0:00:00.083290 Switch, Garage Main-onOffState-average           records read/accepted:       22/     22
  INDIGOplotD                     Convert2 device/prop from SQL db:  0:00:00.101754 Switch, Garage Main-onOffState-average           records read/converted:      22/     22 to PLOT format ==== rejected bad....ValueRange:     0 ..BadNumber:     0 ..sameTimeStamp:     0
  INDIGOplotD                     SQL import             2014-06-19 21:06:23.510779 ... finished, total number of records imported: 22
  INDIGOplotD                     initializing  ...2 
  INDIGOplotD                     sqlLastID [0]
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
****TRIMED REPEATING MESSAGE****  
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     connected to indigo_data as indigo on 127.0.0.1
  INDIGOplotD                     sqlLastID [0]
****SWITCHED TO BATCH MODE - MESSAGES STOPPED - RELOADED THE PLUGIN****
  Reloading plugin "INDIGOplotD 3.0.6"
  Stopping plugin "INDIGOplotD 3.0.6" (pid 66017)
  INDIGOplotD                     stopConcurrentThread  ... 
  INDIGOplotD                     could not read matplotPID file
  INDIGOplotD                      stop matplot: not active, PID:  x
  INDIGOplotD                      main loop stopped
  INDIGOplotD                     stopConcurrentThread  ... 
  INDIGOplotD                     could not read matplotPID file
  INDIGOplotD                      stop matplot: not active, PID:  x
  Stopped plugin "INDIGOplotD 3.0.6"
  Starting plugin "INDIGOplotD 3.0.6" (pid 66082)
  Started plugin "INDIGOplotD 3.0.6"
  INDIGOplotD                     initializing  ... 3-0-6
  INDIGOplotD                     indigo version found: 6
  INDIGOplotD                     sql logger secs active:278.27 10
  INDIGOplotD                     could not read matplotPID file
  INDIGOplotD                     sqlLastID [0]
  INDIGOplotD                      read file /Users/richard/Documents/INDIGOPlotD/data/minute.dat lines: 2304
  INDIGOplotD                      read file /Users/richard/Documents/INDIGOPlotD/data/hour.dat lines: 912
  INDIGOplotD                      read file /Users/richard/Documents/INDIGOPlotD/data/day.dat lines: 390
  INDIGOplotD Error               Error in plugin execution startup:

Traceback (most recent call last):
  File "plugin.py", line 395, in startup
  File "plugin.py", line 3657, in setupSQLDataBatch
<type 'exceptions.IndexError'>: list index out of range

  INDIGOplotD                     sqlLastID [0]
****SWITCHED TO SQL LOGGER THEN RELOADED****
Jun 19, 2014, 9:07:46 PM
  INDIGOplotD                     sqlLastID [0]
  Reloading plugin "INDIGOplotD 3.0.6"
  Stopping plugin "INDIGOplotD 3.0.6" (pid 66082)
  INDIGOplotD                     stopConcurrentThread  ... 
  INDIGOplotD                     could not read matplotPID file
  INDIGOplotD                      stop matplot: not active, PID:  x
  INDIGOplotD                      main loop stopped
  INDIGOplotD                     stopConcurrentThread  ... 
  INDIGOplotD                     could not read matplotPID file
  INDIGOplotD                      stop matplot: not active, PID:  x
  Stopped plugin "INDIGOplotD 3.0.6"
  Starting plugin "INDIGOplotD 3.0.6" (pid 66153)
  Started plugin "INDIGOplotD 3.0.6"
  INDIGOplotD                     initializing  ... 3-0-6
  INDIGOplotD                     indigo version found: 6
  INDIGOplotD                     sql logger secs active:278.55 10
  INDIGOplotD                     could not read matplotPID file
  INDIGOplotD                     sqlLastID [0]
  INDIGOplotD                      read file /Users/richard/Documents/INDIGOPlotD/data/minute.dat lines: 2304
  INDIGOplotD                      read file /Users/richard/Documents/INDIGOPlotD/data/hour.dat lines: 912
  INDIGOplotD                      read file /Users/richard/Documents/INDIGOPlotD/data/day.dat lines: 390
  INDIGOplotD                     initializing  ...2 
  INDIGOplotD                     sqlLastID [0]
  INDIGOplotD                     initialized
Top
User avatar
kw123
Posts: 8705
Joined: Sun May 12, 2013 4:44 pm
Location: Dallas, TX
Contact:
Contact kw123

Re: INDIGOplotD -- a plot tool for indigo

Post by kw123 »

I guess its confused now, could you reset everything -
-delete all plots and
- delete device/states ( in the menu "RESET device data to default)
and then start from scratch


in the first section it imported 2 devices successfully and finished ("initialize and initialize 2" messages), after that something else happened..

most of the error messages come from bad data definitions.
Top
Devildog0331
Posts: 72
Joined: Wed Jan 22, 2014 11:44 pm
Location: Baton Rouge, LA

Re: INDIGOplotD -- a plot tool for indigo

Post by Devildog0331 »

No plots... only one device defined. I did try it with an existing device - then reset it to the default config - then defined a new one. The log shows how it reacted to it.

I'll drop both databases, bring SQL Logger back to it's default config - delete the the plot plugin - install it - then advise. Might take a few but I'll post the results when I'm done.

Thanks again for sticking with me...
Top
User avatar
kw123
Posts: 8705
Joined: Sun May 12, 2013 4:44 pm
Location: Dallas, TX
Contact:
Contact kw123

Re: INDIGOplotD -- a plot tool for indigo

Post by kw123 »

Would like to get Postgre working.


Sent from my iPhone using Tapatalk
Top
Devildog0331
Posts: 72
Joined: Wed Jan 22, 2014 11:44 pm
Location: Baton Rouge, LA

Re: INDIGOplotD -- a plot tool for indigo

Post by Devildog0331 »

No change....
INDIGOplotD connected to indigo_history as indigo on 127.0.0.1
repeats every second in the log (debug on or off).

Steps taken:
plotD: Deleted the plugin and the folder in Documents.
postgreSQL: I dropped my two databases (indigo_data and indigo_history). Created a new indigo_history one and granted user indigo full privileges.
SQLLoger: switched the config back to SQLite then back to postgreSQL.
plotD: Installed the version from the file lib then updated to 3.0.6 (had errors with the one in the file lib - same as before). Once I updated and reloaded the plugin, the stream of "connected to...." lines started. Tried to define a new device (one not previously used), flipped thru the different SQL modes, BATCH gave the same errors and Turning off SQLite worked.

It appears that it's VERY close to being good to go. Example: After I did a reset and defined the new device, this was the output:

Code: Select all

  INDIGOplotD                     command: reset device parameters
  INDIGOplotD                     command: reset device parameters done 
  INDIGOplotD                     connected to indigo_history as indigo on 127.0.0.1
  INDIGOplotD                     Updating device/prop from SQL db: no device or variable defined.. skipping update   ...

Jun 19, 2014, 11:33:36 PM
  INDIGOplotD                     connected to indigo_history as indigo on 127.0.0.1
  INDIGOplotD                     connected to indigo_history as indigo on 127.0.0.1
  INDIGOplotD                     read     device/prop from SQL db:  0:00:00.024931   get firstID  0
  INDIGOplotD                     connected to indigo_history as indigo on 127.0.0.1
  INDIGOplotD                      sqlcmd=  SELECT id,ts, keypadButtonLed1 from device_history_798053763 t1  WHERE   t1.id > 0 and   t1.id <= 30000 and  NOT EXISTS ( SELECT  id, ts, keypadButtonLed1 t1 FROM  device_history_798053763 t2 WHERE t2.ts = t1.ts and   t2.id = t1.id -1   and   t2.keypadButtonLed1 = t1.keypadButtonLed1 )  LIMIT 20000
  INDIGOplotD                      ret= [[1, '2014-06-19 23:26:08.9612', True], [2, '2014-06-19 23:26:29.724564', True], [3, '2014-06-19 23:27:30.084554', True], [4, '2014-06-19 23:27:41.276986', True], [5, '2014-06-19 23:28:01.657913', True]]
  INDIGOplotD                     [[1, '2014-06-19 23:26:08.9612', True], [2, '2014-06-19 23:26:29.724564', True], [3, '2014-06-19 23:27:30.084554', True], [4, '2014-06-19 23:27:41.276986', True], [5, '2014-06-19 23:28:01.657913', True]]
  INDIGOplotD                     read     device/prop from SQL db:  0:00:00.053123   data base records read  5   firstID  0   lastID  5
  INDIGOplotD                     connected to indigo_history as indigo on 127.0.0.1
  INDIGOplotD                      sqlcmd=  SELECT id,ts, keypadButtonLed1 from device_history_798053763 t1  WHERE   t1.id > 5 and   t1.id <= 30005 and  NOT EXISTS ( SELECT  id, ts, keypadButtonLed1 t1 FROM  device_history_798053763 t2 WHERE t2.ts = t1.ts and   t2.id = t1.id -1   and   t2.keypadButtonLed1 = t1.keypadButtonLed1 )  LIMIT 20000
  INDIGOplotD                      ret= []
  INDIGOplotD                     []
  INDIGOplotD                     Convert1 device/prop from SQL db:  0:00:00.078908 KPL, Living Room-keypadButtonLed1   Total data base records 5
  INDIGOplotD                     nrec into check  theProperty dType average keypadButtonLed1    5
  INDIGOplotD                     nrec out of  check     6 rejects    0
  INDIGOplotD                     Convert1 device/prop from SQL db:  0:00:00.079007 KPL, Living Room-keypadButtonLed1-average        records read/accepted:        5/      5
  INDIGOplotD                     Convert2 device/prop from SQL db:  0:00:00.091175 KPL, Living Room-keypadButtonLed1-average        records read/converted:       5/      5 to PLOT format ==== rejected bad....ValueRange:     0 ..BadNumber:     0 ..sameTimeStamp:     0
  INDIGOplotD                     SQL import             2014-06-19 23:33:36.385346 ... finished, total number of records imported: 15
  INDIGOplotD                     connected to indigo_history as indigo on 127.0.0.1
  INDIGOplotD                     connected to indigo_history as indigo on 127.0.0.1
  INDIGOplotD                     connected to indigo_history as indigo on 127.0.0.1
Top
User avatar
kw123
Posts: 8705
Joined: Sun May 12, 2013 4:44 pm
Location: Dallas, TX
Contact:
Contact kw123

Re: INDIGOplotD -- a plot tool for indigo

Post by kw123 »

all the meta data is stored in indigo, when you delete directories, they will just be recreated with the indigo info.
so deleting the directories and the plugin does not erase any info.

here the sequence:
disable indigoplotd
delete indigo plugin
stop indigo
delete the prefs file com.karlwachs.INDIGOplotD.indiPref in the preference directory in .../ indigo 6/ Preferences/plugins/
start indigo
load plugin (double-click on plugin icon)
Top
User avatar
kw123
Posts: 8705
Joined: Sun May 12, 2013 4:44 pm
Location: Dallas, TX
Contact:
Contact kw123

Re: INDIGOplotD -- a plot tool for indigo

Post by kw123 »

by the way it looks as if it successfully imports the data from the sql database. don't understand why it continues to try to load more.

==> need a clean start. see previous email.
Top
User avatar
kw123
Posts: 8705
Joined: Sun May 12, 2013 4:44 pm
Location: Dallas, TX
Contact:
Contact kw123

Re: INDIGOplotD -- a plot tool for indigo

Post by kw123 »

Would like to get Postgre working.


Sent from my iPhone using Tapatalk
Top
Devildog0331
Posts: 72
Joined: Wed Jan 22, 2014 11:44 pm
Location: Baton Rouge, LA

Re: INDIGOplotD -- a plot tool for indigo

Post by Devildog0331 »

Working on it now.
Top
User avatar
kw123
Posts: 8705
Joined: Sun May 12, 2013 4:44 pm
Location: Dallas, TX
Contact:
Contact kw123

Re: INDIGOplotD -- a plot tool for indigo

Post by kw123 »

after removal, just start with basic setup- make it work
- no DB
- just some devices/ properties
- add 1 or 2 plots.

once this works we should see if posture works
Top
Devildog0331
Posts: 72
Joined: Wed Jan 22, 2014 11:44 pm
Location: Baton Rouge, LA

Re: INDIGOplotD -- a plot tool for indigo

Post by Devildog0331 »

Sorry for the delay. Not much more luck. Here's a summary of what I've done and the log output (which I marked up as I performed a specific action) is attached as a file.

Performed all per your request and I reset SQL Logger by changing the extension of the database and the preference file to .BU (confirmed it was changed and not just added too).

If you open the file in TextWrangler... the line that relates to my entries is noted below too.

166 - ENABLED SQL LOGGER
254 - INSTALLED plotD VERSION 3.0.6 (Had an error)
277 - RELOADED THE PLUGIN - From there on I experienced some misc errors.

I'm holding steady at this point. Please advise how you'd like for me to move forward.
Top
Devildog0331
Posts: 72
Joined: Wed Jan 22, 2014 11:44 pm
Location: Baton Rouge, LA

Re: INDIGOplotD -- a plot tool for indigo

Post by Devildog0331 »

I guess the file would help...
Attachments
karl.txt
(26.26 KiB) Downloaded 209 times
Top
User avatar
kw123
Posts: 8705
Joined: Sun May 12, 2013 4:44 pm
Location: Dallas, TX
Contact:
Contact kw123

Re: INDIGOplotD -- a plot tool for indigo

Post by kw123 »

Watching Fußball right now. Will fix this afternoon.


Sent from my iPhone using Tapatalk
Top
Post Reply

Return to “INDIGOplotD”