indigo utilities discussion

Posted on
Sat Aug 18, 2018 2:19 pm
rapamatic offline
Posts: 276
Joined: Aug 03, 2015
Location: Glencoe, IL

Re: indigo utilities discussion

kw123 wrote:
can you try with:
Code: Select all
export LANG=en_US:UTF-8 &&/bin/ps -ef | grep MacOS/IndigoPluginHost

that is the only difference I can see

Karl


Here's what I get now:

Code: Select all
MacPro:~ ray$ export LANG=en_US:UTF-8 &&/bin/ps -ef | grep MacOS/IndigoPluginHost
  503   711   664   0 31Jul18 ??        24:34.40 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -f.Action Collection.indigoPlugin
  503   712   664   0 31Jul18 ??        61:02.09 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -f.Z-Wave.indigoPlugin
  503   713   664   0 31Jul18 ??       106:42.28 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fAlexa-Hue Bridge.indigoPlugin
  503   714   664   0 31Jul18 ??        27:58.33 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fapcupsd.indigoPlugin
  503   716   664   0 31Jul18 ??        68:11.29 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fCynical Behaviors.indigoPlugin
  503   718   664   0 31Jul18 ??        24:46.71 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fCynical Weather.indigoPlugin
  503   719   664   0 31Jul18 ??        23:07.74 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fDomoPad Mobile Client Plugin.indigoPlugin
  503   721   664   0 31Jul18 ??        77:25.44 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fEPS Device Extensions.indigoPlugin
  503   722   664   0 31Jul18 ??       239:15.86 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fEPS HomeKit Bridge.indigoPlugin
  503   723   664   0 31Jul18 ??        49:59.96 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fHarmonyHub.indigoPlugin
  503   724   664   0 31Jul18 ??        34:03.27 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fiFindFriendsMini.indigoPlugin
  503   725   664   0 31Jul18 ??        62:30.03 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fLIFXBridge.indigoPlugin
  503   729   664   0 31Jul18 ??        23:49.01 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fnodeMatrix.indigoPlugin
  503   730   664   0 31Jul18 ??        57:56.76 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fPlex Media Server Manager.indigoPlugin
  503   731   664   0 31Jul18 ??        21:51.44 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fPushover.indigoPlugin
  503   732   664   0 31Jul18 ??        62:23.86 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fsecondsSinceLastChange.indigoPlugin
  503   734   664   0 31Jul18 ??       109:42.98 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fSQL Logger.indigoPlugin
  503   735   664   0 31Jul18 ??       278:40.77 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fTimed Devices.indigoPlugin
  503   736   664   0 31Jul18 ??        23:43.70 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fTimers and Pesters.indigoPlugin
  503   738   664   0 31Jul18 ??        22:29.81 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fVirtual Devices.indigoPlugin
  503   739   664   0 31Jul18 ??        22:00.24 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fWatchdog.IndigoPlugin
  503 40606   664   0  5Aug18 ??        15:44.90 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fCynical CacheM-LM^A.indigoPlugin
  503 45777   664   0  6Aug18 ??        15:39.17 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -e_background_
  503 46546   664   0  2Aug18 ??        58:42.39 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fAutomatic OBD-II.indigoPlugin
  503 48390   664   0 Thu12PM ??        14:31.15 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fEcobee.indigoPlugin
  503 77776   664   0  2:00AM ??        15:22.13 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fSonos.indigoPlugin
  503 87642   664   0  1:46PM ??         0:14.29 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fLutron RadioRA 2.indigoPlugin
  503 88970 87790   0  3:18PM ttys009    0:00.00 grep MacOS/IndigoPluginHost

Posted on
Sat Aug 18, 2018 3:16 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: indigo utilities discussion

last try ...

open a FRESH terminal
Code: Select all
locale
ps -ef | grep MacOS/IndigoPluginHost


what is the output ?

When I use the wrong "local", I get your error

so we just have to find the right one ..

Posted on
Sat Aug 18, 2018 4:52 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: indigo utilities discussion

published a version


1. that has a fallback for Cache/
if language or char set is wrong it takes the scrambled name, and uses "noVers." as version number as it can not find the plugin prefs file.

The variable names will be:
if bad settings: CPU_usage_Cynical-CacheM-LM^A
with correct settings :CPU_usage_indigo.gcnet ( .... gcnet is the pluginID )

2. also added CPU_usage_AllIndigoAndPlugins: for all plugins + server+client +web+postgres (the indigo part)


Karl

Posted on
Sun Aug 19, 2018 10:05 am
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: indigo utilities discussion

Here a plot of INDIGO CPU usage .. The MAC has 12 cores (2*6) . The total runs at ~ 5%
Started the data collection yesterday evening
using the variable "CPU_usage_AllIndigoAndPlugins" as data source
the drop in CPU at ~ 22:00 is due to stopping the indigo client .. I have a lot of updates

There is also a significant difference what the client window shows:
show all devices no filter : 26%
subfolder with no updates: 19%
window closed : 5%


So if you run a MAC mini with 2 cores, 25% of load of one CPU can be substantial

Karl
Attachments
Screen Shot 2018-08-19 at 11.00.46.png
Screen Shot 2018-08-19 at 11.00.46.png (74.75 KiB) Viewed 7120 times

Posted on
Sun Aug 19, 2018 11:47 am
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: indigo utilities discussion

posted v 1.18.18


when a plugin was not running the variable was not updated ie stayed at the last value. Now CPU_usage_pluginName goes to 0 when the process is not running

Posted on
Mon Aug 20, 2018 6:58 am
rapamatic offline
Posts: 276
Joined: Aug 03, 2015
Location: Glencoe, IL

Re: indigo utilities discussion

kw123 wrote:
last try ...

open a FRESH terminal
Code: Select all
locale
ps -ef | grep MacOS/IndigoPluginHost


what is the output ?

When I use the wrong "local", I get your error

so we just have to find the right one ..


Here's what I get:

Code: Select all
MacPro:~ ray$ locale
LANG="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_CTYPE="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_ALL=
MacPro:~ ray$ ps -ef | grep MacOS/IndigoPluginHost
  503   611   553   0  8:16PM ??         0:51.12 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -f.Action Collection.indigoPlugin
  503   612   553   0  8:16PM ??         1:59.34 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -f.Z-Wave.indigoPlugin
  503   613   553   0  8:16PM ??         2:51.66 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fAlexa-Hue Bridge.indigoPlugin
  503   614   553   0  8:16PM ??         0:51.35 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fapcupsd.indigoPlugin
  503   615   553   0  8:16PM ??         1:37.85 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fAutomatic OBD-II.indigoPlugin
  503   617   553   0  8:16PM ??         0:50.59 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fbatterymonitor.indigoplugin
  503   618   553   0  8:16PM ??         1:12.28 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fCynical Behaviors.indigoPlugin
  503   619   553   0  8:16PM ??         0:48.11 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fCynical Cache?M^A.indigoPlugin
  503   620   553   0  8:16PM ??         0:52.45 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fCynical Weather.indigoPlugin
  503   621   553   0  8:16PM ??         0:48.84 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fDomoPad Mobile Client Plugin.indigoPlugin
  503   622   553   0  8:16PM ??         0:49.99 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fEcobee.indigoPlugin
  503   623   553   0  8:16PM ??         1:41.14 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fEPS Device Extensions.indigoPlugin
  503   624   553   0  8:16PM ??         2:26.93 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fEPS HomeKit Bridge.indigoPlugin
  503   625   553   0  8:16PM ??         1:46.10 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fHarmonyHub.indigoPlugin
  503   626   553   0  8:16PM ??         1:13.47 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fiFindFriendsMini.indigoPlugin
  503   627   553   0  8:16PM ??         1:11.42 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fLIFXBridge.indigoPlugin
  503   628   553   0  8:16PM ??         1:11.32 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fLutron RadioRA 2.indigoPlugin
  503   629   553   0  8:16PM ??         0:53.04 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fnodeMatrix.indigoPlugin
  503   630   553   0  8:16PM ??         2:00.92 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fPlex Media Server Manager.indigoPlugin
  503   631   553   0  8:16PM ??         0:47.68 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fPushover.indigoPlugin
  503   632   553   0  8:16PM ??         1:09.15 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fsecondsSinceLastChange.indigoPlugin
  503   634   553   0  8:16PM ??         1:32.83 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fSQL Logger.indigoPlugin
  503   635   553   0  8:16PM ??         8:31.96 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fTimed Devices.indigoPlugin
  503   636   553   0  8:16PM ??         0:50.71 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fTimers and Pesters.indigoPlugin
  503   637   553   0  8:16PM ??         1:01.17 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -futilities.indigoPlugin
  503   638   553   0  8:16PM ??         0:48.30 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fVirtual Devices.indigoPlugin
  503   639   553   0  8:16PM ??         0:47.58 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fWatchdog.IndigoPlugin
  503  3151   553   0  9:53PM ??         0:41.95 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -e_background_
  503  9126   553   0  2:00AM ??        10:43.51 /Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/MacOS/IndigoPluginHost -p1176 -fSonos.indigoPlugin
  503 23906 23881   0 11:42AM ttys000    0:00.00 grep MacOS/IndigoPluginHost
MacPro:~ ray$


So soemthing is still wrong, but as long as the plugin can gracefully ignore it now, probably not worth diving in more. All this localization and non-standard character set stuff makes my brain turn to jello.

Posted on
Mon Aug 20, 2018 10:08 am
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: indigo utilities discussion

Yes when even with the proper language setting in a regular terminal you get the wrong e/ .. I guess we leave it at that ..

posted the "last" utilities version 1.18.20
added fing in CPU report , some beautification . It is the last v for the next 2 weeks.

Karl

ps
I am off to Frankfurt setting up IKEA bed, closets, sofas, chairs billies, a lot of MALMs for son that moves from Boston back "home"
will come back with strong arms

Posted on
Thu Jan 09, 2020 3:33 am
durosity offline
User avatar
Posts: 4320
Joined: May 10, 2012
Location: Newcastle Upon Tyne, Ye Ol' England.

Re: indigo utilities discussion

Wee feature request.. I just noticed that this plugin at some point has had the ability to backup the whole indigo DB added but there's no easy way to define (as far as I can see) a customised location for that backup. Would it be possible to add that in to either the preferences or even better add it to the action so that I could have two schedules, one that backs up to one location and a different one that goes elsewhere? Also the ability to purge old backups after X days would be nice :)

Computer says no.

Posted on
Sat Apr 04, 2020 4:39 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: indigo utilities discussion

posted v 1.18.27

supports psql userid and password settings in config

Karl

Posted on
Wed Oct 07, 2020 12:31 pm
roquej offline
User avatar
Posts: 608
Joined: Jan 04, 2015
Location: South Florida, USA

Re: indigo utilities discussion

Karl,

Getting the follow when trying to “fix db”, as I stated getting some add behavior. Any suggestions?

----------------------------------------------------------------
starting indigo sqlite utility job 2020-10-07 14:28:24.872548 parameters ['fix'] variable_history_591786555

stepCopy cmd: cp '/Library/Application Support/Perceptive Automation/Indigo 7.4/logs/indigo_history.sqlite' '/Library/Application Support/Perceptive Automation/Indigo 7.4/logs/a.cp'
stepCopy seconds used :0; error= 0

stepDump started :2020-10-07 14:28:25.383379
stepDump cmd: /usr/bin/sqlite3 '/Library/Application Support/Perceptive Automation/Indigo 7.4/logs/a.cp' .dump > '/Library/Application Support/Perceptive Automation/Indigo 7.4/logs/a.dump'
stepDump seconds used :0; error= 0

doStepfixDump started :2020-10-07 14:28:25.456511
stepCompress seconds used :0; error= 1
finished indigo sqlite job :2020-10-07 14:28:25.459751
total seconds used :0
----------------------------------------------------------------

JP

Posted on
Wed Oct 07, 2020 12:39 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: indigo utilities discussion

I have given up on fixing sqlite db.. :oops:

It is a single file db and any crash or wrong write can completely corrupt the "db"

I strongly suggest to switch to postgres.

It is a very trivial change
- download the app https://postgresapp.com
- double click on app, make it start at boot
- in indigo switch from sqlite to postgres in logger config
~ 5 minutes max
thats it.

Karl

Posted on
Wed Oct 07, 2020 12:46 pm
roquej offline
User avatar
Posts: 608
Joined: Jan 04, 2015
Location: South Florida, USA

Re: indigo utilities discussion

Thank you. Well do that.

JP

Posted on
Wed Oct 07, 2020 2:09 pm
roquej offline
User avatar
Posts: 608
Joined: Jan 04, 2015
Location: South Florida, USA

Re: indigo utilities discussion

Moved to postgress, but getting this errors when starting logger:

Started plugin "SQL Logger 7.4.1"
SQL Logger connected to indigo_history as postgres on 127.0.0.1
SQL Logger searching for unused device and variable tables
SQL Logger search complete (none found)
SQL Logger updating all device tables
SQL Logger Error exception trying to insert row into table device_history_178900884 ("Tesla 3") -- unable to modify table
SQL Logger Error ERROR: value "1587771443282" is out of range for type integer at character 4225

SQL Logger Error INSERT INTO device_history_178900884 ("api_version", "autopark_state_v3", "backseat_token", "backseat_token_updated_at", "battery_heater", "battery_heater_no_power", "battery_heater_on", "battery_level", "battery_range", "calendar_enabled", "calendar_supported", "can_accept_navigation_requests", "can_actuate_trunks", "car_special_type", "car_type", "car_version", "center_display_state", "charge_current_request", "charge_current_request_max", "charge_enable_request", "charge_energy_added", "charge_limit_soc", "charge_limit_soc_max", "charge_limit_soc_min", "charge_limit_soc_std", "charge_miles_added_ideal", "charge_miles_added_rated", "charge_port_cold_weather_mode", "charge_port_door_open", "charge_port_latch", "charge_port_type", "charge_rate", "charge_to_max_range", "charger_actual_current", "charger_phases", "charger_pilot_current", "charger_power", "charger_voltage", "charging_state", "climate_keeper_mode", "color", "conn_charge_cable", "defrost_mode", "df", "displaystate", "display_name", "distancefromhomekm", "distancefromhomekm_ui", "distancefromhomem", "distancefromhomem_ui", "distancefromworkkm", "distancefromworkkm_ui", "distancefromworkm", "distancefromworkm_ui", "dr", "driver_temp_setting", "ece_restrictions", "est_battery_range", "eu_vehicle", "exterior_color", "fan_status", "fast_charger_brand", "fast_charger_present", "fast_charger_type", "fd_window", "fp_window", "ft", "gps_as_of", "gui_settings_gui_24_hour_time", "gui_settings_gui_charge_rate_units", "gui_settings_gui_distance_units", "gui_settings_gui_range_display", "gui_settings_gui_temperature_units", "gui_settings_show_range_units", "gui_settings_timestamp", "has_air_suspension", "has_ludicrous_mode", "heading", "_indigo_id", "id_s", "ideal_battery_range", "in_service", "inside_temp", "is_auto_conditioning_on", "is_climate_on", "is_front_defroster_on", "is_preconditioning", "is_rear_defroster_on", "is_user_present", "key_version", "latitude", "left_temp_direction", "locked", "longitude", "managed_charging_active", "managed_charging_start_time", "managed_charging_user_canceled", "max_avail_temp", "max_range_charge_counter", "media_state", "media_state_remote_control_enabled", "min_avail_temp", "minutes_to_full_charge", "motorized_charge_port", "native_latitude", "native_location_supported", "native_longitude", "native_type", "not_enough_power_to_heat", "notifications_supported", "odometer", "option_codes", "outside_temp", "parsed_calendar_supported", "passenger_temp_setting", "pf", "plg", "power", "pr", "rd_window", "rear_seat_heaters", "rear_seat_type", "remote_heater_control_enabled", "remote_start", "remote_start_enabled", "remote_start_supported", "rhd", "right_temp_direction", "roof_color", "rp_window", "rt", "scheduled_charging_pending", "scheduled_charging_start_time", "seat_heater_left", "seat_heater_right", "seat_type", "sentry_mode", "sentry_mode_available", "shift_state", "side_mirror_heaters", "software_update", "software_update_download_perc", "software_update_expected_duration_sec", "software_update_install_perc", "software_update_status", "software_update_version", "speed", "speed_limit_mode", "speed_limit_mode_active", "speed_limit_mode_current_limit_mph", "speed_limit_mode_max_limit_mph", "speed_limit_mode_min_limit_mph", "speed_limit_mode_pin_code_set", "spoiler_type", "state", "sun_roof_installed", "third_row_seats", "time_to_full_charge", "timestamp", "tokens", "trip_charging", "usable_battery_level", "use_range_badging", "user_charge_enable_request", "user_id", "valet_mode", "vehicle_id", "vehicle_name", "vin", "wheel_type", "wiper_blade_heater") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);
SQL Logger updating all variable tables
SQL Logger update complete

I assume that is a problem with the Tesla plugin?

JP

Posted on
Wed Oct 07, 2020 2:13 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: indigo utilities discussion

yes thats a q towards Jay/Matt and the Plugin author

and ps, the plugin author configure the plugin to set only update changed state values in SQL DB

Karl

Posted on
Wed Oct 07, 2020 2:19 pm
roquej offline
User avatar
Posts: 608
Joined: Jan 04, 2015
Location: South Florida, USA

Re: indigo utilities discussion

Ok - thanks

Matt/Jay?

JP

Who is online

Users browsing this forum: No registered users and 2 guests