The Ultimate Partner For Vera ?

Community Playground General Discussions
#21

[quote=“nullx8, post:17, topic:175184”]the questions is not about the hardware and/or the operating system.

the question is … “will mios run on it … and how to get the source/binaries”[/quote]
I suspect you already know this answer, but…

MiOS/Vera will not run on this x86 PC. MiOS/Vera is compiled for and runs on a MIPS processor and is incompatible with the x86 architecture. It would have to be ported and recompiled for x86 and MCV is highly unlikely to do that any time soon.

#22
My thoughts were that MiOS would remains on Vera. The chosen partner simply compliments the processing and storage requirements etc, via a small app and a plugin on Vera to allow the two to interact and send/receive info/actions.

That is the route I am trying to implement. I want to keep the VeraLite as stable as possible and only have it do the Z-Wave coordination and logging (and scenes).

My plan is to have a MySQL database holding all the log/sensor data.

I am using a PogoPlug E02 with Debian installed, then installed Lighttpd/PHP/MySQL on it. So you get a full-blown Linux system at 5 - 10W power consumption for about $15 shipped ([url=http://www.adorama.com/COCPOGOP21.html]http://www.adorama.com/COCPOGOP21.html[/url]).
Then I set up the Vera “AlternateEventServer” ([url=http://forum.micasaverde.com/index.php/topic,15245.0.html]http://forum.micasaverde.com/index.php/topic,15245.0.html[/url])

This works fine for logging events/notifications from my DSC Alarm Panel.
Now I am trying to get the Watts and kWh values from my Aeon Labs Energy Meter logged as well, probably using variable_watch and posting to the alternate event Server URL directly from LUUP.

After that I’ll look into making a UI for this, either using PHP or Node.js, not 100% sure about the implementation, but I need to have the data logged first :slight_smile:

#23

have a look here: http://forum.micasaverde.com/index.php?topic=15245.0

i will have this running on my Raspberry, as it runing the web interface for my in-wall tablets already …
(we basically have the same ideas) :wink:

#24

Sounds like you’re doing similar things to my replacement for dataMine and eventWatcher…

[url=http://forum.micasaverde.com/index.php/topic,17232.msg143007.html#msg143007]http://forum.micasaverde.com/index.php/topic,17232.msg143007.html#msg143007[/url]
[url=http://forum.micasaverde.com/index.php/topic,16984.msg152404.html#msg152404]http://forum.micasaverde.com/index.php/topic,16984.msg152404.html#msg152404[/url]

Nothing wrong with that, though!

#25

That would be:

What is a nerd that has lots of money and free time ?
#26

Sounds like you’re doing similar things to my replacement for dataMine and eventWatcher…

[url=http://forum.micasaverde.com/index.php/topic,17232.msg143007.html#msg143007]http://forum.micasaverde.com/index.php/topic,17232.msg143007.html#msg143007[/url]
[url=http://forum.micasaverde.com/index.php/topic,16984.msg152404.html#msg152404]http://forum.micasaverde.com/index.php/topic,16984.msg152404.html#msg152404[/url]

Nothing wrong with that, though![/quote]

That was my thought too before you started to develop those tools :slight_smile:
I was working on the mySQL approach that @Quinten started.

#27

Vera 3 Main Unit
Z-Wave Devices (34 Z-Wave Devices, All Plugins)
Ecolink Garage Tilt Sensor + Linear Dry Contact Module, 9 x HSM100-S3 Inside Motion Sensors (DC Wired), 7 x Everspring Outdoor Motion (battery), 3 Yale Locks, Everpring Door Sensor Converted to Doorbell Sensor (w/Elk Doorbell Detect), 3 x Leviton 4-Scene Panels, 2 x Aeon MiniMotes, 2 x Aeon MiniFobs, Aeon Panic Button, 2 x GE Remotes, Aeon 4 & 1 Sensor, Evolve LCD Scene Controller

Non-Z-Wave Integrated Devices via Plugins:
Nest Thermostat, iTach IR Blaster, 9 x Hue Lightbulbs, 5 x Somfy Automated Blinds via Serial, Russound 6-Zone Home Audio w/Keypads via Serial, 6 x Dahua 1.3MP POE IR Cams, 2 x Foscam 9826 IR PTZ w/3x Zoom, OpenSprinkler Controller.

Vera Lite Z-Wave Slave Unit
(68 Z-Wave Devices, No Plugins) - 28 x Leviton Outlets, Switches or Dimmers, 3 x Evolve Dimmers, Leviton Plugin Lamp Module, Everpring Screw In Lamp Module, 3 x Vera Smart Switches, 4 x Aeon Recessed Sensors, 11 x Aeon Door/Window Contact Sensors, 9 x Vera Shock/Glass Break Sensor, 3 x Leviton 2-Scene Panels, 5 x Fortrezz Water Leak Sensors, Fortrezz Strobe/Siren, 2 x Aeon Smart Strips.

External Vera Media Partner:
Windows Media Center 8 with Vera integration via mControl over IP, iSpy Camera Server Hub (using Vera outdoor motion sensors to trigger recording), 8 x HDMI Splitter to all TV’s (all 7 TV’s/Russpind Audio power motion controlled On/Off with scene using iTach IR blaster), 3 x Keyspan Whole Home RF Media Remote Controls

#28

[quote=“parkerc, post:26, topic:175184”]That was my thought too before you started to develop those tools :slight_smile:
I was working on the mySQL approach that @Quinten started.[/quote]

@parkerc: So what solution are you using now? The EventLogger from akbooer (log files on separate server or SQL DB?) or the AlternateEventServer (Quinten)?
And do you have graphing capabilities implemented? If so, how?

I am looking for some ideas how other folks here approach having a separate server for the sensor data and running some UI/processing of that.

Thanks,
Mike

#29

Hi @mikewop

I liked the benefits of a MySQL dB, but used only as an alternative event server it seemed limited to I looked at creating other entries by watching variables and sending them to server too (http://forum.micasaverde.com/index.php/topic,16713.0.html).But I had trouble getting the dates working, so it’s only partially implemented.

As for DataMine I still use that and I have my data stored on my NAS, the main issue there is that it he data is stored in loads of individual text files. (But at least it’s not on the USB key)

Them @akbooer brought out EventWatcher and its really good, and with an integration for sysloging and plans (I think) to merge with a updated version of DataMine…

  • if InfoViewer, DataMine and EventWatcher could all merge into one that would be a pretty powerful plugin :slight_smile:

Graphing is available via DataMine or Event Waycher,

Regarding a separate server - using something like a RaspberryPi and ser2net that is a good way to pass data from an external system into Vera, I’ve played with it hosting the current cost EnviR connection and also a. rS232 interface with my TV. - Another benefit of the Pi would be to run XBMC and have that linked to Vera. The thought process earlier was that rather than having those devices feeding into individual plugins, could them feed into a consolidated one (freeing up memory etc)

#30

after very quickly bored of the advantages and disadvantages of every single one of the plugins … i decided to “tune” the datamine plugin alittle …
it writes now everything it write to files also into mysql.

time to start making very fancy things now :wink:

#31

Hi @nullx8

Do you have a specific post anywhere that details what you did to integrate DataMine with a MySQL dB?

@akbooer was looking at redeveloping it - and it would be a great enhancement to the plugin if you could choose from a list of storage options (e.g local USB, external NAS, Syslog server, MySQL dB etc…)

Having the data in a relational dB brings many benefits .

#32

@akbooer - on the NUC - yes that’s 6.5 Watts, not 65 W - it uses less during idle.

@parkerc - over here may be a good spot:
http://forum.micasaverde.com/index.php/topic,22732.msg153056.html#msg153056

#33

I think I’m missing something here. Can you explain the fascination with MySQL ? Is it:

[ol][li]because you need the relational capabilities, or,[/li]
[li]because it’s just a ‘database’ you can get your hands on easily?[/li][/ol]

…I hate to be left out of the fun, but it seems to me that a relational database is, in fact, about the last thing you need for this type of data.

#34

no i did not made a extra thread for this.

i added a luup.inet.wget(…) below the lines in datamin1.lua where the datafiles beeing written.
leading to a phpfile on my raspberry … and there just poke it straightforward into the database.

i’m still playing with the database fields and things 9i mage a thread for this in datamine subforum) …
once that is optimixed i will write some “nice code” and post it here

#35
..I hate to be left out of the fun, but it seems to me that a relational database is, in fact, about the last thing you need for this type of data.
For a home type of environment ... this is a good solution. If you were monitoring hundreds of Vera's this may not be the case. But if you want to roll your own solution .... It can easily handle the data and provides a lot of options for integration with other tools.

I personally would use RDDTool.

#36

I’m going for a Lua implementation of Graphite / Whisper (which is RDD-like)

#37

An RRD-like tool would be good.

The reason for looking at MySQL was because it came as standard on my NAS so I thought I’d give it a go, plus @Quinten wrote his Alternative Event Server post referring to MySQL and I tried to build upon it. http://forum.micasaverde.com/index.php/topic,16713.msg128214.html#msg128214

In addition to my NAS i also have access to MySQL with my web domain service - so I had both local and remote hosting options.

Ultimately Id just like a secure place (not on Vera) to store all my event data, that I can view in list form as well as graph (which is why the work you’re doing @akbooer in this area is great to see…)

#38

We seem to have strayed a long way off topic… Perhaps repost under dataMine (maybe under “…development stopped…” or new thread? Happy to answer then…

#39

Another product I’ve been looking at for a while is NeTV, which creates an overlay on your TV so you could configure it to present pop up messages while your watching TV,DVD,cable etc.

http://wiki.chumby.com/index.php?title=What_is_NeTV

It would require someone with some programming skills, to configure it to work with Vera, but in the absence of anything else similar I think it has potential.

NeTV Starter Pack : ID 609 : $150.00 : Adafruit Industries, Unique & fun DIY electronics and kits. Bought in kit form.

#40

[quote=“parkerc, post:39, topic:175184”]Another product I’ve been looking at for a while is NeTV, which creates an overlay on your TV so you could configure it to present pop up messages while your watching TV,DVD,cable etc.

http://wiki.chumby.com/index.php?title=What_is_NeTV

It would require someone with some programming skills, to configure it to work with Vera, but in the absence of anything else similar I think it has potential.

NeTV Starter Pack : ID 609 : $150.00 : Adafruit Industries, Unique & fun DIY electronics and kits. Bought in kit form.[/quote]
Since the company that maintain this software has gone out of business, may be Vera could invest in it and bundle in to the official Vera software. Just saying… :slight_smile: