Z-Wave support in HA - beta testers wanted

http://karpero.mine.nu/ha

Moderators: Daniel, tom_rosenback, Telldus

Ceasar
Posts: 10
Joined: Fri Mar 17, 2023 9:45 am

Re: Z-Wave support in HA - beta testers wanted

Post by Ceasar »

Hi
Just upgraded to HA 3.1.1 and ozssha 0.2. Great work!!
Seems to work nicely, I used the parser before is it enough to remark [// $systems[] = "openzwave";] in HomeAutomation/parser/parser_config.php to stop the parser ?
I noticed I got high load on the mysql server process could it be due to that the updates are more frequent now ?
Seems I get update on each Energy change W, have seen aprox 2-3 updates within a minute.
/Br Stefan
Daniel
Posts: 317
Joined: Fri Mar 17, 2023 9:45 am

Re: Z-Wave support in HA - beta testers wanted

Post by Daniel »

Ceasar wrote:Hi
Just upgraded to HA 3.1.1 and ozssha 0.2. Great work!!
Seems to work nicely, I used the parser before is it enough to remark [// $systems[] = "openzwave";] in HomeAutomation/parser/parser_config.php to stop the parser ?
I noticed I got high load on the mysql server process could it be due to that the updates are more frequent now ?
Seems I get update on each Energy change W, have seen aprox 2-3 updates within a minute.
/Br Stefan
Yep, just comment out in parser_config.php should do the trick. Assuming you want the parser to still parse something else (like telldus). If not, just remove it from your scheduler 8)

Regarding the frequency of updates, I guess that depends on how often the device in question sends updates. ozwssha just passes the information on to HA when it comes from the sensor. In my case my sensor sends values every fifth minute. I don't know if it could be something that's configurable in the device?

/Daniel
Senaste info och release om/av HomeAutomation hittas här http://karpero.mine.nu/ha
Latest info and release of HomeAutomation can be found here http://karpero.mine.nu/ha
Ceasar
Posts: 10
Joined: Fri Mar 17, 2023 9:45 am

Re: Z-Wave support in HA - beta testers wanted

Post by Ceasar »

Yep will investigate if it can be changed on the sensor side.

Does this mysql(process list) output say you anything ? , it looks like one query locks the following in sequence below.
And when this happens [mysqld] runs at 100%
top output => [27918 mysql 20 0 1096m 81m 7608 S 100 4.7 6:39.71 mysqld]

[10.FD9692010800] is my 1wire owfs temp sensor.
Could it be that the 1-wire is to slow and locks the following inputs ?

mysql> SHOW FULL PROCESSLIST;
+-----+------+-----------+----------------+---------+------+------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+-----------+----------------+---------+------+------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 80 | root | localhost | NULL | Query | 0 | NULL | SHOW FULL PROCESSLIST |
| 245 | root | localhost | homeautomation | Query | 8 | Sending data | SELECT s.id, s.name, s.serial, st.unit, IFNULL(s.gaugetype, st.gaugetype) AS gaugetype, IFNULL(s.min, st.min) AS min, IFNULL(s.max, st.max) AS max, IFNULL(s.high, st.high) AS high, IFNULL(s.low, st.low) AS low,
(SELECT ROUND(t.temp_c, 1)
FROM temps t
WHERE t.sensor_serial = s.serial
ORDER BY t.id DESC LIMIT 1) AS actual,
(SELECT t2.id
FROM temps t2
WHERE t2.sensor_serial = s.serial
ORDER BY t2.id DESC LIMIT 1) AS actual_id,
(SELECT ROUND(t3.temp_c, 1)
FROM temps t3
WHERE t3.sensor_serial = s.serial
ORDER BY t3.id DESC LIMIT 1, 1) AS previous
FROM tempsensors s
LEFT OUTER JOIN sensortypes st ON s.sensortype = st.id |
| 246 | root | localhost | homeautomation | Query | 4 | Waiting for table level lock | SELECT s.id, s.name, s.serial, st.unit, IFNULL(s.gaugetype, st.gaugetype) AS gaugetype, IFNULL(s.min, st.min) AS min, IFNULL(s.max, st.max) AS max, IFNULL(s.high, st.high) AS high, IFNULL(s.low, st.low) AS low,
(SELECT ROUND(t.temp_c, 1)
FROM temps t
WHERE t.sensor_serial = s.serial
ORDER BY t.id DESC LIMIT 1) AS actual,
(SELECT t2.id
FROM temps t2
WHERE t2.sensor_serial = s.serial
ORDER BY t2.id DESC LIMIT 1) AS actual_id,
(SELECT ROUND(t3.temp_c, 1)
FROM temps t3
WHERE t3.sensor_serial = s.serial
ORDER BY t3.id DESC LIMIT 1, 1) AS previous
FROM tempsensors s
LEFT OUTER JOIN sensortypes st ON s.sensortype = st.id WHERE s.serial = "10.FD9692010800" |
| 248 | root | localhost | homeautomation | Query | 5 | Waiting for table level lock | INSERT INTO temps (sensor_serial, temp_c, date) VALUES ("3-4-1-31", "1.2", now()) |
| 249 | root | localhost | homeautomation | Query | 4 | Waiting for table level lock | INSERT INTO temps (sensor_serial, temp_c, date) VALUES ("3-4-1-31", "1.7", now()) |
| 250 | root | localhost | homeautomation | Query | 3 | Waiting for table level lock | INSERT INTO temps (sensor_serial, temp_c, date) VALUES ("3-4-1-31", "0.6", now()) |
| 251 | root | localhost | homeautomation | Query | 2 | Waiting for table level lock | INSERT INTO temps (sensor_serial, temp_c, date) VALUES ("3-4-1-31", "0.5", now()) |
| 252 | root | localhost | homeautomation | Query | 0 | Waiting for table level lock | INSERT INTO temps (sensor_serial, temp_c, date) VALUES ("3-4-1-31", "1.6", now()) |
+-----+------+-----------+----------------+---------+------+------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
8 rows in set (0.00 sec)
Ceasar
Posts: 10
Joined: Fri Mar 17, 2023 9:45 am

Re: Z-Wave support in HA - beta testers wanted

Post by Ceasar »

Sorry :oops:
# Query_time: 20.646973 Lock_time: 0.000369 Rows_sent: 27 Rows_examined: 21165060
Seems the temp table had records since 2011......
/Br Stefan
Daniel
Posts: 317
Joined: Fri Mar 17, 2023 9:45 am

Re: Z-Wave support in HA - beta testers wanted

Post by Daniel »

Ceasar wrote:Rows_examined: 21165060
Makes sense. You might want to have a look at this thread: http://www.telldus.com/forum/viewtopic.php?f=27&t=5933

/Daniel
Senaste info och release om/av HomeAutomation hittas här http://karpero.mine.nu/ha
Latest info and release of HomeAutomation can be found here http://karpero.mine.nu/ha
tomolav
Posts: 7
Joined: Fri Mar 17, 2023 9:45 am

Re: Z-Wave support in HA - beta testers wanted

Post by tomolav »

Hi,
Thank you for the excellent work you do with HA.
I've been running v2.02 together with a Telldus DUO for years, with great stability. The nice interface also give it a high WAF :D :D
One thing I've been missing with the Telldus/ Nexa solution is feedback on the actual states for all actuators. For this reason I've spent some time looking into Mysensors (great concept, will continue using this for some special Arduino project like gardening water systems and fridge/ freezer monitoring). What the Mysensors solution is lacking is small "safe" actuators that can be easily installed in wall boxes etc. I was very happy when I read about Z-wave, and that HA was experimenting with support for these devices. I've done a couple of "test installs" with HA 3.0 and HA 3.1.1, and managed to control my Z-wave devices from the interface. I have however not had any success with receiving an updated status for the device if I change it locally.
I have now installed HA 3.2, but can not find the correct system openzwave plugin (v.0.2?) anywhere. There is a download link on the http://karpero.mine.nu/ha site called "OpenZWave v0.2", but it contains only the ozwssha source. The manual indicates that the plugins should be included in the main download for HA 3.2, but I'm not able to find it there either.

I'm running HA on a virtual Ubuntu 14.04 LTS server installation under ESXi, where it is easy to test new configurations on a copy of the stable setup. My Z-wave network consist of a Z-Stick Gen5 controller from Aeotec, a few Fibaro FGD-212 dimmers and a couple of secondary controllers for local control of the dimmers. I've also tried an installation of OpenHab on the same Z-wave network. There I get instant feedback of any local status changes.
Sorry if my long explanation is confusing :oops:

To summarize, my questions are:
Where can I find the latest system-plugin for openzwave?
Should the local status change give feedback to the HA? Or is my expectations for this plugin wrong?
/Br. Tom Olav
Daniel
Posts: 317
Joined: Fri Mar 17, 2023 9:45 am

Re: Z-Wave support in HA - beta testers wanted

Post by Daniel »

Hi.
Well, your questions certainly make sense and I can see why you're confused :D

Thing is, since the user base for this plugin is very close to zero, I've been kinda sloppy with the releases. I also thought that the openzwave system plugin was part of the HA zip, but now when I check it's not there, obviously Tom didn't think it should be...

Anyway, status changes certainly should get reported back to HA. In early versions of the plugin (like pre 0.2) this was done using the weather parser polling the ozwssha server, but now it's done by ozwssha reporting in the status to HA API. The only thing needed for this is for you to enter the HA url in ozwssha.conf as the readme.txt says.

As for the latest version I would recommend you to get the latest from svn. You'd also need the latest HA from svn for this to work (I did quite much stuff in this plugin some month ago that need stuff that's not in HA 3.2). Normally I wouldn't recommend svn, but right now it's pretty stable, we've been talking about maybe releasing a 3.3 soon.

/Daniel
Senaste info och release om/av HomeAutomation hittas här http://karpero.mine.nu/ha
Latest info and release of HomeAutomation can be found here http://karpero.mine.nu/ha
tomolav
Posts: 7
Joined: Fri Mar 17, 2023 9:45 am

Re: Z-Wave support in HA - beta testers wanted

Post by tomolav »

Thanks for a quick (and good) answer.
I will try the latest HA from SVN, and probably your user base is +1 :)
/Br. Tom Olav
Daniel
Posts: 317
Joined: Fri Mar 17, 2023 9:45 am

Re: Z-Wave support in HA - beta testers wanted

Post by Daniel »

tomolav wrote:Thanks for a quick (and good) answer.
I will try the latest HA from SVN, and probably your user base is +1 :)
Great! I'd be happy to hear any feedback!

/Daniel
Senaste info och release om/av HomeAutomation hittas här http://karpero.mine.nu/ha
Latest info and release of HomeAutomation can be found here http://karpero.mine.nu/ha
Post Reply