JowiHue Philips Hue control beta now available

[kenrad]

When I try to delete the SQl.interop.dll that is in the hs3 root folder and HS3 is running it tells me that it can't be deleted because it is in use by the hs3.exe so I am thinking that this is needed but maybe its not inthe correct folder

it that a possibility

Cheers Ken

[w.vuyk]

Kenrad,

I think HS3 itself is storing its SQl.interop.dll in the root of the bin directory. so you should one version there.
When you try to delete the file in the installation dfirectory you probably will see HS3 as it is HS3 starting the plugin.

You can check for the data directory where often databases are stored. Thisw way you know which plugins have databases (skip access databases), next you can look in the bin directoy, which plugins store their DLLs. The one(s) having databases and not to be found in the bin directory are your candidates.
Then you can check with removing SQl.interop.dll and disabling/enabling plugins?

Wim

[w.vuyk]

[w.vuyk]

Solved the zip issue. See first post.

Wim

[zigmund]

same errors on linux

Hi Wim,

On linux, I have similar errors. I enabled mono runtime debug. The system is 32 bit. I checked the config file. seems ok

Mono: Assembly Loader loaded assembly from location: '/usr/lib/mono/gac/System.Transactions/4.0.0.0__b77a5c561934e089/System.Transactions.dll'.
Mono: Config attempting to parse: '/usr/lib/mono/gac/System.Transactions/4.0.0.0__b77a5c561934e089/System.Transactions.dll.config'.
Mono: Config attempting to parse: '/etc/mono/assemblies/System.Transactions/System.Transactions.config'.
Mono: Assembly Ref addref System.Data.SQLite[0x9076618] -> System.Transactions[0x908e818]: 2
Mono: Assembly Ref addref System.Data[0x8f17710] -> System.Transactions[0x908e818]: 3
Mono: Assembly Ref addref System.Transactions[0x908e818] -> mscorlib[0x8e85b20]: 13
Mono: Assembly Ref addref System.Data.SQLite[0x9076618] -> System.Xml[0x8f1abd0]: 5
Mono: Assembly Ref addref System.Data.SQLite[0x9076618] -> System[0x8ef0b08]: 8
Mono: DllImport attempting to load: 'kernel32'.
Mono: DllImport loading library: '/usr/local/HomeSeer/bin/JowiHue/libkernel32'.
Mono: DllImport error loading library '/usr/local/HomeSeer/bin/JowiHue/libkernel32: cannot open shared object file: No such file or directory'.
Mono: DllImport loading library: '/usr/local/HomeSeer/bin/JowiHue/libkernel32.so'.
Mono: DllImport error loading library '/usr/local/HomeSeer/bin/JowiHue/libkernel32.so: cannot open shared object file: No such file or directory'.
Mono: DllImport loading location: 'libkernel32'.
Mono: DllImport error loading library: 'libkernel32: cannot open shared object file: No such file or directory'.
Mono: DllImport loading location: 'libkernel32.so'.
Mono: DllImport error loading library: 'libkernel32.so: cannot open shared object file: No such file or directory'.
Mono: DllImport loading: 'kernel32'.
Mono: DllImport error loading library 'kernel32: cannot open shared object file: No such file or directory'.
Mono: DllImport loading library: '/usr/local/HomeSeer/bin/JowiHue/libkernel32'.
Mono: DllImport error loading library '/usr/local/HomeSeer/bin/JowiHue/libkernel32: cannot open shared object file: No such file or directory'.
Mono: DllImport loading library: '/usr/local/HomeSeer/bin/JowiHue/libkernel32.so'.
Mono: DllImport error loading library '/usr/local/HomeSeer/bin/JowiHue/libkernel32.so: cannot open shared object file: No such file or directory'.
Mono: DllImport loading location: 'libkernel32'.
Mono: DllImport error loading library: 'libkernel32: cannot open shared object file: No such file or directory'.
Mono: DllImport loading location: 'libkernel32.so'.
Mono: DllImport error loading library: 'libkernel32.so: cannot open shared object file: No such file or directory'.
Mono: DllImport loading: 'libkernel32'.
Mono: DllImport error loading library 'libkernel32: cannot open shared object file: No such file or directory'.
Mono: DllImport unable to load library 'libkernel32: cannot open shared object file: No such file or directory'.
Mono: DllImport attempting to load: 'SQLite.Interop.dll'.
Mono: DllImport loading library: '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop.dll'.
Mono: DllImport error loading library '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop.dll: cannot open shared object file: No such file or directory'.
Mono: DllImport loading library: '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop.dll.so'.
Mono: DllImport error loading library '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop.dll.so: cannot open shared object file: No such file or directory'.
Mono: DllImport loading location: 'libSQLite.Interop.dll'.
Mono: DllImport error loading library: 'libSQLite.Interop.dll: cannot open shared object file: No such file or directory'.
Mono: DllImport loading location: 'libSQLite.Interop.dll.so'.
Mono: DllImport error loading library: 'libSQLite.Interop.dll.so: cannot open shared object file: No such file or directory'.
Mono: DllImport loading: 'SQLite.Interop.dll'.
Mono: DllImport error loading library 'SQLite.Interop.dll: cannot open shared object file: No such file or directory'.
Mono: DllImport loading library: '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop'.
Mono: DllImport error loading library '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop: cannot open shared object file: No such file or directory'.
Mono: DllImport loading library: '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop.so'.
Mono: DllImport error loading library '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop.so: cannot open shared object file: No such file or directory'.
Mono: DllImport loading location: 'libSQLite.Interop'.
Mono: DllImport error loading library: 'libSQLite.Interop: cannot open shared object file: No such file or directory'.
Mono: DllImport loading location: 'libSQLite.Interop.so'.
Mono: DllImport error loading library: 'libSQLite.Interop.so: cannot open shared object file: No such file or directory'.
Mono: DllImport loading: 'SQLite.Interop'.
Mono: DllImport error loading library 'SQLite.Interop: cannot open shared object file: No such file or directory'.
Mono: DllImport loading library: '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop.dll'.
Mono: DllImport error loading library '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop.dll: cannot open shared object file: No such file or directory'.
Mono: DllImport loading library: '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop.dll.so'.
Mono: DllImport error loading library '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop.dll.so: cannot open shared object file: No such file or directory'.
Mono: DllImport loading location: 'libSQLite.Interop.dll'.
Mono: DllImport error loading library: 'libSQLite.Interop.dll: cannot open shared object file: No such file or directory'.
Mono: DllImport loading location: 'libSQLite.Interop.dll.so'.
Mono: DllImport error loading library: 'libSQLite.Interop.dll.so: cannot open shared object file: No such file or directory'.
Mono: DllImport loading: 'libSQLite.Interop.dll'.
Mono: DllImport error loading library 'libSQLite.Interop.dll: cannot open shared object file: No such file or directory'.
Mono: DllImport unable to load library 'libSQLite.Interop.dll: cannot open shared object file: No such file or directory'.
Mono: DllImport attempting to load: 'SQLite.Interop.dll'.
Mono: DllImport loading library: '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop.dll'.
Mono: DllImport error loading library '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop.dll: cannot open shared object file: No such file or directory'.
Mono: DllImport loading library: '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop.dll.so'.
Mono: DllImport error loading library '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop.dll.so: cannot open shared object file: No such file or directory'.
Mono: DllImport loading location: 'libSQLite.Interop.dll'.
Mono: DllImport error loading library: 'libSQLite.Interop.dll: cannot open shared object file: No such file or directory'.
Mono: DllImport loading location: 'libSQLite.Interop.dll.so'.
Mono: DllImport error loading library: 'libSQLite.Interop.dll.so: cannot open shared object file: No such file or directory'.
Mono: DllImport loading: 'SQLite.Interop.dll'.
Mono: DllImport error loading library 'SQLite.Interop.dll: cannot open shared object file: No such file or directory'.
Mono: DllImport loading library: '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop'.
Mono: DllImport error loading library '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop: cannot open shared object file: No such file or directory'.
Mono: DllImport loading library: '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop.so'.
Mono: DllImport error loading library '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop.so: cannot open shared object file: No such file or directory'.
Mono: DllImport loading location: 'libSQLite.Interop'.
Mono: DllImport error loading library: 'libSQLite.Interop: cannot open shared object file: No such file or directory'.
Mono: DllImport loading location: 'libSQLite.Interop.so'.
Mono: DllImport error loading library: 'libSQLite.Interop.so: cannot open shared object file: No such file or directory'.
Mono: DllImport loading: 'SQLite.Interop'.
Mono: DllImport error loading library 'SQLite.Interop: cannot open shared object file: No such file or directory'.
Mono: DllImport loading library: '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop.dll'.
Mono: DllImport error loading library '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop.dll: cannot open shared object file: No such file or directory'.
Mono: DllImport loading library: '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop.dll.so'.
Mono: DllImport error loading library '/usr/local/HomeSeer/bin/JowiHue/libSQLite.Interop.dll.so: cannot open shared object file: No such file or directory'.
Mono: DllImport loading location: 'libSQLite.Interop.dll'.
Mono: DllImport error loading library: 'libSQLite.Interop.dll: cannot open shared object file: No such file or directory'.
Mono: DllImport loading location: 'libSQLite.Interop.dll.so'.
Mono: DllImport error loading library: 'libSQLite.Interop.dll.so: cannot open shared object file: No such file or directory'.
Mono: DllImport loading: 'libSQLite.Interop.dll'.
Mono: DllImport error loading library 'libSQLite.Interop.dll: cannot open shared object file: No such file or directory'.
Mono: DllImport unable to load library 'libSQLite.Interop.dll: cannot open shared object file: No such file or directory'.
Mono: gc took 3198 usecs
7/21/2014 9:24:42 PM:[Error]->Initializing plug-in(2): JowiHue Instance::SQLite.Interop.dll0STACK:  at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke (System.Runtime.Remoting.Proxies.RealProxy rp, IMessage msg, System.Exception& exc, System.Object[]& out_args) [0x00000] in <filename unknown>:0 
7/21/2014 9:24:42 PM:[Plug-In]->Finished initializing plug-in JowiHue

[w.vuyk]

Hi Wim,

On linux, I have similar errors. I enabled mono runtime debug. The system is 32 bit. I checked the config file. seems ok

Zigmund,

I have never tested it for Mono/Linux. The library mentioned I have not added to the build. I suppose it is needed for Linux, but do not know where to get this yet.
I am a bit of a nitwit for Linux...
Does the directory Homeer/bin/JowiHue exist on your system? Looking at the logging it does not?

Wim

[bartbakels]

Hi,

Just installed and looking great so far, wil test some days and if no strange things happen, plan to fully migrate all my hue stuff to your plugin.

Thanks

Bart

[kenrad]

Running the latest version the plug in still does not start looks like it is still the same SQL issue

Jul-22 4:59:09 PM Error Initializing plug-in(2): JowiHue Instance::Could not load file or assembly 'System.Data.SQLite, Version=1.0.92.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)0STACK:Server stack trace: Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessag e(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(Mess ageData& msgData, Int32 type) at HomeSeerAPI.IPlugInAPI.InitIO(String port) at Scheduler.clsHSPI.CheckInterfaces()

Cheers Ken

[w.vuyk]

Ken,

Then in that case the SQLLite DLL's in the installation directory are definitally in the way of operating this plugin. The only way is finding the owner of the plugin using the SQLLite in the installation folder. He should move them to its own directory.

Was hoping for better news
Wim

[w.vuyk]

Wim,

Saving current hue states to a global and severting back via that global. For example for alerting or messaging ( blue flash for rain)

Wakeup scene. But i think this should be possible in your new version.

Bart

Bart,

I am wondering what you would like to achieve whit the global. You can create a blue flash now with the scenes and animations or other alerts. You could trigger those alerts with events based on rain or other now?
I do not know what function you would like to get here?


Wim

[bartbakels]

Hi,

I ssee some issues in the log about parsing JSON and lost bridge connections.

In addition some creativity/scenes logic does not work as expected to me in triggerd events. I will test some further and come back with detailed findings. Overal great plugin so far !!!

Bart

[bdickhaus]

Ken,

Then in that case the SQLLite DLL's in the installation directory are definitally in the way of operating this plugin. The only way is finding the owner of the plugin using the SQLLite in the installation folder. He should move them to its own directory.

Was hoping for better news
Wim

I had this problem with the mcsXap plugin, but it was fixed in a newer release and now all is working well.

Great plugin. I tried all the other Hue plugins and this one is the best.

Bill

[bartbakels]

Bart,

I am wondering what you would like to achieve whit the global. You can create a blue flash now with the scenes and animations or other alerts. You could trigger those alerts with events based on rain or other now?
I do not know what function you would like to get here?


Wim

Wim,

I would like to take a snapshot of a hue situation, And revert back to that situation after a scene or animation or hue status change by homeseer. I think its possible by using your scenes but do not exaclty get the wait times, but this has probabaly has something todo with the alert command.


an example event;


HUES in state X

Alarm tripped.

Get current HUE state

all hues need to be set to color red and start alerting until alarm restored. (old situation with jon00 plugin i would send an alert command every 15 secs and the event can only trigger every 15 sec when the alarm is high)

Alarm restored.


Revert back to state X


By the way I totaly migrated now. My wakeup light works and off course the normal on/off commands for example on movements. Next step is my alarming and messaging using your plugin.

regards

Bart

[w.vuyk]

Wim,

I would like to take a snapshot of a hue situation, And revert back to that situation after a scene or animation or hue status change by homeseer. I think its possible by using your scenes but do not exaclty get the wait times, but this has probabaly has something todo with the alert command.


an example event;


HUES in state X

Alarm tripped.

Get current HUE state

all hues need to be set to color red and start alerting until alarm restored. (old situation with jon00 plugin i would send an alert command every 15 secs and the event can only trigger every 15 sec when the alarm is high)

Alarm restored.


Revert back to state X


By the way I totaly migrated now. My wakeup light works and off course the normal on/off commands for example on movements. Next step is my alarming and messaging using your plugin.

regards

Bart

Bart,

Good to hear the plugin works for you so far.

On your alert, the good thing is that this functionality is already available in the plugin.
When you create an animation you can select options per animation. One of these options is "return to original settings after animation ends"
So all you should need to do is create an alert animation and make sure to set this option.

I realise though that there might be a challenge if you create the alert as an infinite loop. There is no way yet to stop it ("Alarm restored") with an event action. I will work on that part for the next version.
A work around would be creating a infinite loop and when alarm is restored, generate a dummy on to the lights. You could use that till the next version?

Regards,

Wim

[w.vuyk]

I had this problem with the mcsXap plugin, but it was fixed in a newer release and now all is working well.

Great plugin. I tried all the other Hue plugins and this one is the best.

Bill

Bdickhaus,
Thanks for confirming this issue with SQLLite caused by other plugins. I am almost regretting using SQLlite because of this.

And many thanks on the compliment. I was missing functions on the other plugins as well, that was my main reason to start creating this. I am not finished yet with the plugin even.

Wim