jwagner010

@Javi I am at work so cannot check local but some data points: UD mobile connects to my Polisy (5.8.0) fine remotely UD mobile does not connect remotely to my ISY 994i (5.3.4) - oAuthPortal Error UD portal shows both systems online with the green light. Portal web access works on POLISY Portal web access does not work on the ISY994i Running latest UD mobile .60 Appears to be portal and ISY 994i related?

Same issue cannot connect remotely. Following.

I understand you can use the graph.microsoft.com API to append rows of data to excel 365 workbooks but have never invested the time to better understand the API and whether it’s something that could be used for this use case leveraging an IOX network resource or an IOX network resource that calls a php script on the web server or something like that. Lots of info at url above and specific examples here: https://learn.microsoft.com/en-us/graph/excel-write-to-workbook

Perhaps something like this behind your current manual shutoff valve. Pricey but would fit the use case: https://www.homecontrols.com/Greenfield-Z-Wave-Automatic-Security-Valve-Kit-GFASVxZ?quantity=1&custcol2=25

@Goose66Thank you Thank You this is what I was looking for. Based on a look at the launcher JNLP it is now isyfinder-3.5.jar which I was able to download and execute per your guidance above. I guess the trick is to just periodically download the latest jar file as it changes. @RPerraultUnfortunately I am on the naughty list so no PC from Santa this year.

Long story for another day, but my Laptop (Windows 11) is restricted by my employer from loading and running Oracle JAVA on it. We are limited to Azul Zulu being our Java JRE/JDK environment, and it does not include Java web start (javaws) being part of the standard Zulu install (I believe it is Azul IceTea but that is also restricted). I know nothing about JAVA so go easy on me, my questions are: Can I run the Admin Console another way than launching the JNLP file from windows web environment? If not, will the EISY ever get a non JAVA interface and if so the best guess what year? This question is not meant to inflame a debate on the AC and JAVA, just curious, I am still on my 994 and I have been a UDI fan and user since the ISY-26 days, but with a large Z-wave based installation I really don't want to upgrade to EISY until the AC interface is sorted out. I am happy to keep the 994i for the next 2 to 3 years (I have a POLISY running PG3), but if a new interface isn't on the cards in the next 2 maybe 3 years I might as well bite the bullet now and look at alternatives, not that I want to or necessarily will, just looking at my options.

Is there anything I can do on Polisy/PG3x side to fix the certificate issue? Eg install a let’s encrypt certificate?

Interesting, thanks. I learned something today!!!!

I thought port 3000 was for https only. So you can use http or https over port 3000?

I upgraded my POLISY from PG3 to PG3X over the weekend. A few issues with a couple of the Node Servers not converting correctly that I was able to resolve and get up and running. The one thing I cannot resolve is after the upgrade I cannot login into PG3X from my work computer (I have always used my work computer for logging into PG3 in the past). Now when I go to log into PG3X I get an error in the browser telling me my connection is not private that when Chrome tried to connect the website sent back unusual and incorrect credentials. NET::ERR_CERT_INVALID I also tried Microsoft Edge and I get a similar error to the above. My employer locks down the browser security levels and certificates on the PC. Seems like something changed with PG3X as I cannot get past the errors above, under PG3 I was able to get to login to the PG3 portal. What would have changed and can I change anything on the PG3X/POLISY side as I cannot make changes to security settings on my PC and Chrome as its locked down? My backup is my iPad and Safari which allows me to access to PG3X still without issue but I would prefer to access PG3X on my work PC versus an iPad. Anyone got thoughts on what is going on with PG3X that is different from a certificate/access access perspective for the PG3X web interface?

Yes it is enabled. Works without fault from Home Screen just not from favorites.

I have a state variable that I use to indicate if home or away on vacation that I have various programs use. If I change the variable from the UD Mobile Home->IOX System->Variables menu it triggers the various programs on my ISY just fine. So I decided to put the variable as a favorite with type default. When I change the state variable from the favorite screen/menu it doesn’t trigger programs in the ISY, only when I change it at Home->IOX System->Variables. Weird. Is this a bug in UD Mobile favorites?

Program 2 while it’s in wait. Got it. Thanks

Program 1: The then statement in Program 1 runs/calls the If statement in Program 2 Program 2: Is disabled so the If statement only runs when called from program 1 Question: Program 2 has a wait in the Then statement. If the program turns false during the Wait, will the Program continue running the Then because the If is disabled (program if condition is not reassessed) or will it run the Else in Program 2 at that point?

Recently I have noticed when I log into the NuHeat thermostat iOS app, it logs me out once I use the app, so every time I go to use the app again I need to enter my user ID and password. Pretty annoying. It used to stay logged in but over the last week this has changed. Are others experiencing this with the iOS App ?

I am back up and running now. Issue looks to have been corrected

Is the portal down or some other issue. Cannot remotely connect to my ISY994 or POLISY?

I believe it should be id not nsid. Either way I sent you a PM of the entire table.

That did the trick, installed and working now. Much appreciated all, I know this stuff is a PIA for all, so do appreciate the support from this community. PS The 'purchased' node servers table still shows as [Free] under the order ID column. Not sure I should worry about that or ignore it, but I definately purchased the NS not the free version and it used to show the Order ID number. Again thanks both for getting back up and running

In addition to my post above, not sure if it is just the license causing the issue? I did a fresh install in a new slot for version 4.0.1 of the node server and it does not even start and removes itself. I am running the latest version of PG3 3.1.18 on my POLISY. Here is the PG3 log when I tried to install it in a new slot (slot 6) below. Would appear to be a different/bigger problem than just the odd appearing license, as the node server seems to pass the license test when installing. Are others able to install the node server in a new slot under PG3 version 3.1.18 via the store? 3/7/2023, 06:04:07 [pg3] info: [XX:XX:XX:XX:XX:XX_6] :: Creating Node Server 'DysonPureCool' 3/7/2023, 06:04:07 [pg3] info: Adding customparams entries to custom database 3/7/2023, 06:04:07 [pg3] info: Adding nsdata, oauth entries to custom database 3/7/2023, 06:04:07 [pg3] info: [XX:XX:XX:XX:XX:XX_6] Set nsdata 3/7/2023, 06:04:07 [pg3] info: [XX:XX:XX:XX:XX:XX_6] Set oauth 3/7/2023, 06:04:07 [pg3] info: checkLicense:: DysonPureCool Valid perpetual license found. 3/7/2023, 06:04:07 [pg3] warn: DysonPureCool home directory exists already. 3/7/2023, 06:04:18 [pg3] error: unhandledRejection REPORT THIS!: [object Promise], reason: Error: Request failed with status code 404 3/7/2023, 06:04:39 [pg3] info: [XX:XX:XX:XX:XX:XX_6] Retrieved customparams 3/7/2023, 06:04:39 [pg3] info: [XX:XX:XX:XX:XX:XX_6] Retrieved oauth 3/7/2023, 06:05:01 [pg3] info: [XX:XX:XX:XX:XX:XX_6] Retrieved customparams 3/7/2023, 06:05:01 [pg3] info: [XX:XX:XX:XX:XX:XX_6] Retrieved oauth 3/7/2023, 06:05:31 [pg3] info: [XX:XX:XX:XX:XX:XX_6] Retrieved customparams 3/7/2023, 06:05:31 [pg3] info: [XX:XX:XX:XX:XX:XX_6] Retrieved oauth 3/7/2023, 06:06:01 [pg3] warn: [XX:XX:XX:XX:XX:XX_6] ISY does not have this Node Server. Removing from PG3. 3/7/2023, 06:08:01 [pg3] error: custom.add insert failed SqliteError: FOREIGN KEY constraint failed 3/7/2023, 06:08:01 [pg3] error: custom.add insert failed SqliteError: FOREIGN KEY constraint failed 3/7/2023, 06:08:01 [pg3] info: [XX:XX:XX:XX:XX:XX_6] Set customparams 3/7/2023, 06:08:01 [pg3] info: [XX:XX:XX:XX:XX:XX_6] Set customtypeddata 3/7/2023, 06:08:34 [pg3] error: MQTT on Inbound processFunction: TypeError: Cannot read properties of undefined (reading 'id') at Object.startNs (/var/polyglot/node_modules/@universaldevices/pg3/lib/services/node servers.js:868:27) at Object.startNs [as func] (/var/polyglot/node_modules/@universaldevices/pg3/lib/modules/frontend/ns.js:153:22) at process.processTicksAndRejections (node:internal/process/task_queues:95:5) 3/7/2023, 06:08:45 [pg3] error: MQTT on Inbound processFunction: TypeError: Cannot read properties of undefined (reading 'id') at Object.startNs (/var/polyglot/node_modules/@universaldevices/pg3/lib/services/node servers.js:868:27) at Object.startNs [as func] (/var/polyglot/node_modules/@universaldevices/pg3/lib/modules/frontend/ns.js:153:22) at process.processTicksAndRejections (node:internal/process/task_queues:95:5) 3/7/2023, 06:08:46 [pg3] error: MQTT on Inbound processFunction: TypeError: Cannot read properties of undefined (reading 'id') at Object.startNs (/var/polyglot/node_modules/@universaldevices/pg3/lib/services/node servers.js:868:27) at Object.startNs [as func] (/var/polyglot/node_modules/@universaldevices/pg3/lib/modules/frontend/ns.js:153:22) at process.processTicksAndRejections (node:internal/process/task_queues:95:5) 3/7/2023, 06:08:46 [pg3] error: MQTT on Inbound processFunction: TypeError: Cannot read properties of undefined (reading 'id') at Object.startNs (/var/polyglot/node_modules/@universaldevices/pg3/lib/services/node servers.js:868:27) at Object.startNs [as func] (/var/polyglot/node_modules/@universaldevices/pg3/lib/modules/frontend/ns.js:153:22) at process.processTicksAndRejections (node:internal/process/task_queues:95:5)

When I run the command select name,nsid from Node Server where name="DysonPureCool"; I get an error Parse error: no such column: nsid So I just ran: select name from Node Server where name="DysonPureCool"; and it returned nothing So to check I ran the command with another one of my purchased Node Servers OpenWeatherMap (but without nsid field) select name from Node Server where name="OpenWeatherMap"; and it returned OpenWeatherMap So would appear DysonPureCool is not listed in the table at all? (not sure of nsid field not being defined as a column in the the table?) Thoughts on anything else I can try or do I need to open a ticket with UDI?

Let me take a look when I get home. I have the node server in slots 2 and 3 (two different Dyson fans), I only updated slot 2 right now, and I am pretty sure that slot was initially first installed with the Free version as I was helping @glarsen test an updates to the node server a couple months back in the non production store and he then migrated that to production at which point I updated the version in slot 2 from a free non production version to the licensed production version. Short story is perhaps the nsid is still there for slot 3? Also I found the email confirmation when I purchased the node server and it has a license number on it, will PM it to you.

I am at work right now so cannot SSH in. However, I now see what you see when going into the Node Server store, perhaps @glarsen updated it again or perhaps it took a while to refresh through, either way I do see what you see. Two things: 1) So I when I now look at the purchased node servers and see it in there now but the [Free] version, no license number, see screenshot 2) So it now lets me do an install in the old slot and it appears to install (version number goes to 4.01) but the node server doesn't start or connect to the ISY, there isn't even a Dyson log created. The PG3 log is below when I do the install. Short story is the Node Server looks like it updates/installs but doesn't start: 3/6/2023, 17:33:08 [pg3] info: [XX:XX:XX:XX:XX:XX_2] :: Creating Node Server 'DysonPureCool' 3/6/2023, 17:33:08 [pg3] info: DysonPureCool preveously installed, re-installing... 3/6/2023, 17:33:08 [pg3] info: Adding customparams entries to custom database 3/6/2023, 17:33:08 [pg3] info: Adding nsdata, oauth entries to custom database 3/6/2023, 17:33:08 [pg3] info: [XX:XX:XX:XX:XX:XX_2] Set nsdata 3/6/2023, 17:33:08 [pg3] info: [XX:XX:XX:XX:XX:XX_2] Set oauth 3/6/2023, 17:33:08 [pg3] info: checkLicense:: DysonPureCool Valid perpetual license found. 3/6/2023, 17:33:08 [pg3] warn: DysonPureCool home directory exists already. 3/6/2023, 17:33:08 [pg3] error: unhandledRejection REPORT THIS!: [object Promise], reason: Error: Request failed with status code 404

Where should I see install button I only see a purchase button from within the node server store. See screenshot

@glarsen @bpwwer I see it in the store now, however, when I do a restart for it to reinstall I still get the message "Node server start: Automatic Update Failed". When I look at my purchased Node servers its still not showing up as one of my purchased node servers anymore so I suspect it could be failing to do the re-install because it thinks I haven't previously purchased it? How do I get that corrected so it appears on my list of purchased node servers again? Also the log (second last entry) seems to suggested the node server has not been added back to the production store still but I do see it in the store. Maybe related when I see it in the store, the information/description about the node server is scrambled so perhaps it hasn't been loaded currently in the store? Either way still not installing / working ]or me. 3/6/2023, 16:27:28 [pg3] info: [XX:XX:XX:XX:XX:XX_2] Retrieved customparams 3/6/2023, 16:27:28 [pg3] info: [XX:XX:XX:XX:XX:XX_2] Retrieved customparamsdoc 3/6/2023, 16:27:28 [pg3] info: [XX:XX:XX:XX:XX:XX_2] Retrieved customtypeddata 3/6/2023, 16:27:28 [pg3] info: [XX:XX:XX:XX:XX:XX_2] Retrieved notices 3/6/2023, 16:27:28 [pg3] info: [XX:XX:XX:XX:XX:XX:a1_2] Retrieved oauth 3/6/2023, 16:27:30 [pg3] info: [DysonPureCool(2)]: Restarting Node Server 3/6/2023, 16:27:30 [pg3] warn: [DysonPureCool(2)]: Was not running. Starting... 3/6/2023, 16:27:33 [pg3] info: startNs:: DysonPureCool 3/6/2023, 16:27:33 [pg3] info: startNs:: DysonPureCool is valid 3/6/2023, 16:27:33 [pg3] info: checkLicense:: DysonPureCool Valid perpetual license found. 3/6/2023, 16:27:33 [pg3] error: updateNs: Node server DysonPureCool has no store entry in Production. 3/6/2023, 16:27:33 [pg3] error: DysonPureCool automatic update failed xx'ed out the UUID