Waterkotte Ecotouch Heatpump

[pioneersteffen]

Hi @all,

I want to connect my Waterkotte Ecotouch heatpump to LM/W4k. I have a working .php script what is running on my Raspberry. This script I want to transfer to LM.

To start with: My goal is to read "TEMPERATURE_OUTSIDE" and write it to a group address and write "ENABLE_HEATING" from a group address. 

Is this possible? Has anybody an idea how to start?

Many thanks for your help!

Best Regards
Steffen

[admin]

Try running this code and post what you get in Logs. Change ip, user and pwd variables as needed.

Code:

12345678910111213141516171819202122232425262728293031323334

http = require('socket.http') ip = '192.168.178.100' -- ip address of Waterkotte heat pump user = 'XXX' -- username of web interface pwd = 'XXX' -- password of web interface url = 'http://' .. ip .. '/cgi/login?username=' .. user .. '&password=' .. pwd res, code = http.request(url) log('login request', res, code) if res and code == 200 then   token = res:match('%x+')   log('token', token)   if type(token) == 'string' and #token == 32 then     storage.set('ecotouch-token', token)   end end if token then   url = 'http://' .. ip .. '/cgi/readTags?n=1&t1=A1'   res, code = http.request({     url = url,     headers = {       ['Cookie'] = 'IDALToken=' .. token     }   })   log('read request', res, code) end

[pioneersteffen]

@admin: Many thanks for your help.

I getting a login failure, here is the log:

Code:

12345678910111213141516171819202122

Waterkotte 07.03.2022 16:22:21 * arg: 1   * string: login request * arg: 2   * string: 1 #S_OK IDALToken=d98d4aa1b188273a90c0440da3f3f9d0 * arg: 3   * number: 200 Waterkotte 07.03.2022 16:22:21 * arg: 1   * string: token * arg: 2   * string: 1 Waterkotte 07.03.2022 16:22:21 * arg: 1   * string: read request * arg: 2   * string: #E_NEED_LOGIN * arg: 3   * number: 500

If I do the steps manual via Firefox browser:
1.) 

Code:

1

http://192.168.XXX.XX/cgi/login?username=XXX&password=XXX

[url=http://192.168.178.35/cgi/readTags?n=1&t1=A1][/url]

2.) 

Code:

1

http://192.168.XXX.XX/cgi/readTags?n=1&t1=A1

the return is: 

Code:

12

#A1    S_OK 192    80

The failure "E_NEED_LOGIN" I getting also in the browser when I don't do step 1 before step 2.

[admin]

Change line 14 to this and try again:

Code:

1

token = res:match('IDALToken=(%x+)')

[pioneersteffen]

@admin: Many thanks, now the login works successful!

Code:

1234567891011121314151617181920212223

Waterkotte 08.03.2022 10:01:43 * arg: 1   * string: login request * arg: 2   * string: 1 #S_OK IDALToken=d09570725af35fbaf13ba699ed6c2a0e * arg: 3   * number: 200 Waterkotte 08.03.2022 10:01:43 * arg: 1   * string: token * arg: 2   * string: d09570725af35fbaf13ba699ed6c2a0e Waterkotte 08.03.2022 10:01:43 * arg: 1   * string: read request * arg: 2   * string: #A19    S_OK 192    363 * arg: 3   * number: 200

„363“ is the value I want to parse and write it to a group address. 

@admin: Do you have an idea how to do that?

[admin]

Add after log('read request', res, code), if it works then you can replace log(value) with grp.checkwrite or grp.checkupdate.

Code:

12345

value = res:match('S_OK%s+%d+%s+(%d+)') if value then   value = tonumber(value)   log(value) end

[pioneersteffen]

@admin: Many thanks again for your big help! Highly appreciated! 

I made two script sets out of it. 

The first one is to read the actual values I'm interested in:

Code:

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304

http = require('socket.http') ip = 'xxx' -- ip address of Waterkotte heat pump user = 'xxx' -- username of web interface pwd = 'xxx' -- password of web interface url = 'http://' .. ip .. '/cgi/login?username=' .. user .. '&password=' .. pwd res, code = http.request(url) log('login request', res, code) if res and code == 200 then   token = res:match('IDALToken=(%x+)')   log('token', token)   if type(token) == 'string' and #token == 32 then     storage.set('ecotouch-token', token)   end end -- Read actual hot water temperature **************************** if token then   url = 'http://' .. ip .. '/cgi/readTags?n=1&t1=A19'   res, code = http.request({     url = url,     headers = {       ['Cookie'] = 'IDALToken=' .. token     }   })   log('read request', res, code)     value = res:match('S_OK%s+%d+%s+(%d+)')    if value then       value = tonumber(value)    -- log(value)       grp.checkupdate('46/1/1', value/10)    end end os.sleep(1)      -- Read actual source in temperature **************************** if token then   url = 'http://' .. ip .. '/cgi/readTags?n=1&t1=A4'   res, code = http.request({     url = url,     headers = {       ['Cookie'] = 'IDALToken=' .. token     }   })   log('read request', res, code) value = res:match('S_OK%s+%d+%s+(%d+)')    if value then       value = tonumber(value)    -- log(value)       grp.checkupdate('46/1/2', value/10)    end end os.sleep(1)      -- Read actual source out temperature **************************** if token then   url = 'http://' .. ip .. '/cgi/readTags?n=1&t1=A5'   res, code = http.request({     url = url,     headers = {       ['Cookie'] = 'IDALToken=' .. token     }   })   log('read request', res, code) value = res:match('S_OK%s+%d+%s+(%d+)')    if value then       value = tonumber(value)    -- log(value)       grp.checkupdate('46/1/3', value/10)    end end os.sleep(1)      -- ************************************************************ -- Read actual return temperature **************************** if token then   url = 'http://' .. ip .. '/cgi/readTags?n=1&t1=A11'   res, code = http.request({     url = url,     headers = {       ['Cookie'] = 'IDALToken=' .. token     }   })   log('read request', res, code) value = res:match('S_OK%s+%d+%s+(%d+)')    if value then       value = tonumber(value)    -- log(value)       grp.checkupdate('46/1/4', value/10)    end end os.sleep(1)      -- Read actual flow temperature **************************** if token then   url = 'http://' .. ip .. '/cgi/readTags?n=1&t1=A12'   res, code = http.request({     url = url,     headers = {       ['Cookie'] = 'IDALToken=' .. token     }   })   log('read request', res, code) value = res:match('S_OK%s+%d+%s+(%d+)')    if value then       value = tonumber(value)    -- log(value)       grp.checkupdate('46/1/5', value/10)    end end os.sleep(1)      -- ************************************************************ -- Read actual power compressor **************************** if token then   url = 'http://' .. ip .. '/cgi/readTags?n=1&t1=A25'   res, code = http.request({     url = url,     headers = {       ['Cookie'] = 'IDALToken=' .. token     }   })   log('read request', res, code) value = res:match('S_OK%s+%d+%s+(%d+)')    if value then       value = tonumber(value)    -- log(value)       grp.checkupdate('46/1/6', value/10)    end end os.sleep(1)      -- Read actual power heating**************************** if token then   url = 'http://' .. ip .. '/cgi/readTags?n=1&t1=A26'   res, code = http.request({     url = url,     headers = {       ['Cookie'] = 'IDALToken=' .. token     }   })   log('read request', res, code) value = res:match('S_OK%s+%d+%s+(%d+)')    if value then       value = tonumber(value)    -- log(value)       grp.checkupdate('46/1/7', value/10)    end end os.sleep(1)      -- Read actual COP*************************** if token then   url = 'http://' .. ip .. '/cgi/readTags?n=1&t1=A28'   res, code = http.request({     url = url,     headers = {       ['Cookie'] = 'IDALToken=' .. token     }   })   log('read request', res, code) value = res:match('S_OK%s+%d+%s+(%d+)')    if value then       value = tonumber(value)    -- log(value)       grp.checkupdate('46/1/8', value/10)    end end -- Read desrired hot water temperature **************************** if token then   url = 'http://' .. ip .. '/cgi/readTags?n=1&t1=A37'   res, code = http.request({     url = url,     headers = {       ['Cookie'] = 'IDALToken=' .. token     }   })   log('read request', res, code)     value = res:match('S_OK%s+%d+%s+(%d+)')    if value then       value = tonumber(value)    -- log(value)       grp.checkupdate('46/3/1', value/10)    end end os.sleep(1)    -- Read status heeting mode**************************** if token then   url = 'http://' .. ip .. '/cgi/readTags?n=1&t1=I30'   res, code = http.request({     url = url,     headers = {       ['Cookie'] = 'IDALToken=' .. token     }   })   log('read request', res, code)     value = res:match('S_OK%s+%d+%s+(%d+)')    if value then       value = tonumber(value)    -- log(value)         if value == 1             then             value = true             elseif             value == 0             then             value = false         end       grp.checkupdate('46/3/2', value)    end end os.sleep(1)    -- Read status cooling mode**************************** if token then   url = 'http://' .. ip .. '/cgi/readTags?n=1&t1=I31'   res, code = http.request({     url = url,     headers = {       ['Cookie'] = 'IDALToken=' .. token     }   })   log('read request', res, code)     value = res:match('S_OK%s+%d+%s+(%d+)')    if value then       value = tonumber(value)    -- log(value)         if value == 1             then             value = true             elseif             value == 0             then             value = false         end       grp.checkupdate('46/3/3', value)    end end os.sleep(1)   

And the second one to write the desired values:

Code:

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879

http = require('socket.http') ip = 'xxx' -- ip address of Waterkotte heat pump user = 'xxx' -- username of web interface pwd = 'xxx' -- password of web interface url = 'http://' .. ip .. '/cgi/login?username=' .. user .. '&password=' .. pwd res, code = http.request(url) log('login request', res, code) if res and code == 200 then   token = res:match('IDALToken=(%x+)')   log('token', token)   if type(token) == 'string' and #token == 32 then     storage.set('ecotouch-token', token)   end end os.sleep(1) -- Write enable heating mode **************************** setvalue = grp.getvalue('46/2/2') if setvalue == true then setvalue = 1     else setvalue = 0 end if token then   url = 'http://' .. ip .. '/cgi/writeTags?returnValue=true&n=1&t1=I30&v1='..setvalue   res, code = http.request({     url = url,     headers = {       ['Cookie'] = 'IDALToken=' .. token     }   })   log('read request', res, code)     end os.sleep(1) -- Write enable cooling mode **************************** setvalue = grp.getvalue('46/2/3') if setvalue == true then setvalue = 1     else setvalue = 0 end if token then   url = 'http://' .. ip .. '/cgi/writeTags?returnValue=true&n=1&t1=I31&v1='..setvalue   res, code = http.request({     url = url,     headers = {       ['Cookie'] = 'IDALToken=' .. token     }   })   log('read request', res, code) end os.sleep(1) -- Write water temperature**************************** setvalue = grp.getvalue('46/2/1') setvalue = setvalue *10 if token then   url = 'http://' .. ip .. '/cgi/writeTags?returnValue=true&n=1&t1=A38&v1='..setvalue   res, code = http.request({     url = url,     headers = {       ['Cookie'] = 'IDALToken=' .. token     }   })   log('read request', res, code) end

Generally it works fine EXCEPT when the time between two request is to short I getting the following return in the log and the values are not written to the heatpump:

Code:

12345678

Waterkotte_Sollwerte 10.03.2022 20:23:55 * arg: 1   * string: login request * arg: 2   * string: -37 #E_TOO_MANY_USERS * arg: 3   * number: 200

@admin: Do you have an idea how to control the situation? Do I need to detect: "#E_TOO_MANY_USERS" and then wait some second and resend? How would this look like? Many thanks for your help!

[admin]

The login procedure should not be performed for each request. The token is already saved into storage so it should be used in read/write requests. If the request fails with an error then the token should be refreshed.