Domoticz

Code: Select all

2020-03-23 16:50:30.006 Error: EventSystem: in /home/pi/domoticz/scripts/lua/script_device_calculate_consumption.lua: ...ticz/scripts/lua/script_device_calculate_consumption.lua:21: module 'socket.http' not found:
2020-03-23 16:50:30.006 no field package.preload['socket.http']
2020-03-23 16:50:30.006 no file '/usr/local/share/lua/5.3/socket/http.lua'
2020-03-23 16:50:30.006 no file '/usr/local/share/lua/5.3/socket/http/init.lua'
2020-03-23 16:50:30.006 no file '/usr/local/lib/lua/5.3/socket/http.lua'
2020-03-23 16:50:30.006 no file '/usr/local/lib/lua/5.3/socket/http/init.lua'
2020-03-23 16:50:30.006 no file './socket/http.lua'
2020-03-23 16:50:30.006 no file './socket/http/init.lua'
2020-03-23 16:50:30.006 no file '/usr/local/lib/lua/5.3/socket/http.so'
2020-03-23 16:50:30.006 no file '/usr/local/lib/lua/5.3/loadall.so'
2020-03-23 16:50:30.006 no file './socket/http.so'
2020-03-23 16:50:30.006 no file '/usr/local/lib/lua/5.3/socket.so'
2020-03-23 16:50:30.006 no file '/usr/local/lib/lua/5.3/loadall.so'
2020-03-23 16:50:30.006 no file './socket.so'

Code: Select all

Reading package lists... Done
Building dependency tree
Reading state information... Done
Note, selecting 'liblua5.3-dev' for regex 'liblua5.3'
Note, selecting 'liblua5.3-0-dbg' for regex 'liblua5.3'
Note, selecting 'liblua5.3-0' for regex 'liblua5.3'
liblua5.3-0 is already the newest version (5.3.3-1.1).
liblua5.3-0-dbg is already the newest version (5.3.3-1.1).
liblua5.3-dev is already the newest version (5.3.3-1.1).
lua5.3 is already the newest version (5.3.3-1.1).
0 upgraded, 0 newly installed, 0 to remove and 27 not upgraded.

Code: Select all

sudo update-alternatives --config lua-interpreter

Code: Select all

There are 3 choices for the alternative lua-interpreter (providing /usr/bin/lua).

  Selection    Path             Priority   Status
------------------------------------------------------------
* 0            /usr/bin/lua5.2   120       auto mode
  1            /usr/bin/lua5.1   110       manual mode
  2            /usr/bin/lua5.2   120       manual mode
  3            /usr/bin/lua5.3   120       manual mode

Press <enter> to keep the current choice[*], or type selection number:

Code: Select all

2020-03-24 12:46:24.359 Error: EventSystem: in /home/pi/domoticz/scripts/lua/script_device_calculate_consumption.lua: ...ticz/scripts/lua/script_device_calculate_consumption.lua:21: module 'socket.http' not found:
2020-03-24 12:46:24.359 no field package.preload['socket.http']
2020-03-24 12:46:24.359 no file '/usr/local/share/lua/5.3/socket/http.lua'
2020-03-24 12:46:24.359 no file '/usr/local/share/lua/5.3/socket/http/init.lua'
2020-03-24 12:46:24.359 no file '/usr/local/lib/lua/5.3/socket/http.lua'
2020-03-24 12:46:24.359 no file '/usr/local/lib/lua/5.3/socket/http/init.lua'
2020-03-24 12:46:24.359 no file './socket/http.lua'
2020-03-24 12:46:24.359 no file './socket/http/init.lua'
2020-03-24 12:46:24.359 no file '/usr/local/lib/lua/5.3/socket/http.so'
2020-03-24 12:46:24.359 no file '/usr/local/lib/lua/5.3/loadall.so'
2020-03-24 12:46:24.359 no file './socket/http.so'
2020-03-24 12:46:24.359 no file '/usr/local/lib/lua/5.3/socket.so'
2020-03-24 12:46:24.359 no file '/usr/local/lib/lua/5.3/loadall.so'
2020-03-24 12:46:24.359 no file './socket.so'

Code: Select all

sudo find / -name socket.* | grep lua

Code: Select all

-- /home/pi/domoticz/scripts/lua/script_device_calculate_consumption.lua
-- This script collects the values below from Domoticz
--   * The Power and energy values (import and export) from a smartmeter 
--   * The Power and energy values from a Solar power inverter
-- It then calculates the consumed power and energy from the values above with the formula's
--   * EnergyConsumption = EnergyGeneration + EnergyImport - EnergyExport
--   * PowerConsumption = PowerGeneration + PowerImport - PowerExport
-- It then updates a virtual device which displays the consumed power and energy in Domoticz

----------------------------------------------------------------------------------------------------------
-- Domoticz IDX and names of the needed devices
----------------------------------------------------------------------------------------------------------
local GenerationDeviceName = "Power" 		-- Device name of the Generated energy
local EnergyDeviceName = "Power" 		-- Name of the energy device that shows imported and exported energy
local ConsumptionIDX = 61  			-- IDX of the energy device that shows calculated Consumption
local ConsumptionDeviceName = "ConsumptionDevice" 		-- Name of the energy device that shows calculated Consumption

----------------------------------------------------------------------------------------------------------
-- Require parameters
----------------------------------------------------------------------------------------------------------
local http = require("socket.http")

----------------------------------------------------------------------------------------------------------
-- Script parameters
----------------------------------------------------------------------------------------------------------
if (EnergyImportLow==nil) then
EnergyImportLow = 0	-- in Watt hours
EnergyImportHigh = 0	-- in Watt hours
EnergyExportLow = 0	-- in Watt hours
EnergyExportHigh = 0	-- in Watt hours
EnergyGeneration = 0 	-- in Watt hours
PowerGeneration = 0 	-- in Watts
EnergyImport = 0	-- in Watt hours
PowerImport = 0		-- in Watts
EnergyConsumption = 0 	-- in Watt hours
PowerConsumption = 0 	-- in Watts
Debug = "YES" 		-- Turn debugging on ("YES") or off ("NO")

end
----------------------------------------------------------------------------------------------------------
-- Lua Functions
----------------------------------------------------------------------------------------------------------
function update(device, id, power, energy, index)
	commandArray[index] = {['UpdateDevice'] = id .. "|0|" .. power .. ";" .. energy}
end 

----------------------------------------------------------------------------------------------------------
-- CommandArray
----------------------------------------------------------------------------------------------------------
commandArray = {}
	-- Generated
	PowerGeneration, EnergyGeneration = otherdevices_svalues[GenerationDeviceName]:match("([^;]+);([^;]+)")
	if Debug=="YES" then
		print("  ----- PowerGeneration = " .. PowerGeneration .. " W");
		print("  ----- EnergyGeneration = " .. EnergyGeneration .. " Wh");
	end

	EnergyImportLow, EnergyImportHigh, EnergyExportLow, EnergyExportHigh, PowerImport, PowerExport = otherdevices_svalues[EnergyDeviceName]:match("([^;]+);([^;]+);([^;]+);([^;]+);([^;]+);([^;]+)")
	EnergyImport = EnergyImportLow + EnergyImportHigh
	EnergyExport = EnergyExportLow + EnergyExportHigh
	if Debug=="YES" then
		print("  ----- PowerImport = " .. PowerImport .. " W");
		print("  ----- EnergyImportLow = " .. EnergyImportLow .. " Wh");
		print("  ----- EnergyImportHigh = " .. EnergyImportHigh .. " Wh");
		print("  ----- EnergyImport = " .. EnergyImport .. " Wh");
		print("  ----- PowerExport = " .. PowerExport .. " W");
		print("  ----- EnergyExportLow = " .. EnergyExportLow .. " Wh");
		print("  ----- EnergyExportHigh = " .. EnergyExportHigh .. " Wh");
		print("  ----- EnergyExport = " .. EnergyExport .. " Wh");
	end

	-- Calculate consumption
	PowerConsumption = PowerGeneration + PowerImport - PowerExport
	if Debug=="YES" then
		print("  ----- PowerConsumption = " .. PowerConsumption .. " W");
	end
	EnergyConsumption = EnergyGeneration + EnergyImport - EnergyExport
	if Debug=="YES" then
		print("  ----- EnergyConsumption = " .. EnergyConsumption .. " Wh");
	end

	-- Update comsumption device in Domoticz
	if devicechanged[EnergyDeviceName] then
		update(ConsumptionDeviceName, ConsumptionIDX, PowerConsumption, EnergyConsumption, 1)
	end
	
return commandArray

Code: Select all

----------------------------------------------------------------------------------------------------------
-- Require parameters
----------------------------------------------------------------------------------------------------------
-- local http = require("socket.http")

Code: Select all

cmake -DCMAKE_BUILD_TYPE=Release CMakeLists.txt -DUSE_OPENSSL_STATIC="NO" -DUSE_BUILTIN_LUA="NO"

Code: Select all

-- /home/pi/domoticz/scripts/lua/script_time_upload_to_PVoutput.lua
-- This script collects the values below from Domoticz
--   * The Power generation, energy generation and voltage from a Solar power inverter
--   * The temperature from a outside temperature sensor
--   * The Power consumption and energy consumption which is calculated in another Lua script 
-- And uploads all of the values to a PVoutput account.
--
-- For more information about PVoutput, see their user documentation on http://www.pvoutput.org/help.html

----------------------------------------------------------------------------------------------------------
-- Domoticz IDX of devices
----------------------------------------------------------------------------------------------------------
local GenerationDeviceName = "PowerOutput"	-- Device name of the Generated energy
local ConsumptionDeviceName = "ConsumptionDevice" 	-- Name of the energy device that shows calculated Consumption
local VoltageDeviceName = "VoltageOutput"	-- Name of the voltage device that shows voltage of the inverter
local TemperatureDeviceName = "THB" -- Name of the temperature device that shows outside temperature

----------------------------------------------------------------------------------------------------------
-- PVoutput parameters
----------------------------------------------------------------------------------------------------------
local PVoutputApi = "xxxxxxx"		-- Your PVoutput api key
local PVoutputSystemID = "xxxxx" 					-- Your PVoutput System ID
local PVoutputPostInterval = 5  					-- The number of minutes between posts to PVoutput (normal is 5 but when in donation mode it's max 1)
local PVoutputURL = '://pvoutput.org/service/r2/addstatus.jsp?key='	-- The URL to the PVoutput Service

----------------------------------------------------------------------------------------------------------
-- Require parameters
----------------------------------------------------------------------------------------------------------
local http = require("socket.http")

----------------------------------------------------------------------------------------------------------
-- Script parameters
----------------------------------------------------------------------------------------------------------

EnergyGeneration = 0 	-- v1 in Watt hours
PowerGeneration = 0 	-- v2 in Watts
EnergyConsumption = 0 	-- v3 in Watt hours
PowerConsumption = 0 	-- v4 in Watts
CurrentTemp = 0 	-- v5 in celcius
Voltage = 0 		-- v6 in volts
c1 = 1 			-- c1 = 0 when v1 is today's energy. c1 = 1 when v1 is lifetime energy.
Debug = "YES" 		-- Turn debugging on ("YES") or off ("NO")

----------------------------------------------------------------------------------------------------------
-- Lua Functions
----------------------------------------------------------------------------------------------------------
function UploadToPVoutput(self)
	b, c, h = http.request("http" .. PVoutputURL .. PVoutputApi .. "&sid=".. PVoutputSystemID .. "&d=" .. os.date("%Y%m%d") .. "&t=" .. os.date("%H:%M") .. 

	"&v1=" .. EnergyGeneration .. "&v2=" .. PowerGeneration .. "&v3=" .. EnergyConsumption .. "&v4=" .. PowerConsumption .. "&v5=" .. CurrentTemp .. "&v6=" .. Voltage .. "&c1=" .. c1 )
	if b=="OK 200: Added Status" then
		print(" -- Current status successfully uploaded to PVoutput.org")
	else
		print(" -- " ..b)
	end
	
	print("  --Energy generation (v1) = ".. EnergyGeneration .. " Wh")
	print("  --Power generation (v2) = " .. PowerGeneration .. " W")
	print("  --Energy consumption (v3) = " .. EnergyConsumption .. " Wh")
	print("  --Power consumption (v4) = " .. PowerConsumption .. " W")
	print("  --Current temperature (v5) = " .. CurrentTemp .. " C")
	print("  --Voltage (v6) = " .. Voltage .. "V")
	print("  --Cumulative Flag (c1) = " .. c1 .. "")
end

function update(device, id, power, energy, index)
	commandArray[index] = {['UpdateDevice'] = id .. "|0|" .. power .. ";" .. energy}
end 

----------------------------------------------------------------------------------------------------------
-- CommandArray
----------------------------------------------------------------------------------------------------------
commandArray = {}

	time = os.date("*t")
	if PVoutputPostInterval > 1 then
		TimeToGo = PVoutputPostInterval - (time.min % PVoutputPostInterval)
		print('Time to go before upload to PVoutput: ' ..TimeToGo.. " minutes")
	end
	
	if((time.min % PVoutputPostInterval)==0)then
		-- Generated
		PowerGeneration, EnergyGeneration = otherdevices_svalues[GenerationDeviceName]:match("([^;]+);([^;]+)")
		if Debug=="YES" then
			print(" ---- The total generated energy is " .. EnergyGeneration .. " Wh");
			print(" ---- The current generated power is " .. PowerGeneration .. " W");
		end

		-- Voltage
		Voltage = otherdevices_svalues[VoltageDeviceName] :match("([^;]+)")
		if Debug=="YES" then
			print(" ---- The voltage of the inverter is " .. Voltage .. " V");
		end
		
		-- Temperature
		CurrentTemp = otherdevices_svalues[TemperatureDeviceName]:match("([^;]+)")
		if Debug=="YES" then
			print(" ---- The outside temperature is " .. CurrentTemp .. " C.");
		end
		--EnergyGeneration = "0"
		--PowerGeneration = "0"
		-- PowerConsumption
		EnergyConsumption, PowerConsumption = otherdevices_svalues[ConsumptionDeviceName]:match("([^;]+);([^;]+)")
		if Debug=="YES" then
			print(" ---- The total consumed energy is " .. EnergyConsumption .. " Wh");
			print(" ---- The current consumed power is " .. PowerConsumption .. " W");
		end
		-- Upload data to PVoutput	
		UploadToPVoutput()
	end

return commandArray

Code: Select all

2020-03-27 15:18:22.666 Error: dzVents: Error: (3.0.1) Eigen verbruik: An error occurred when calling event handler script_time_upload_to_PVoutput
2020-03-27 15:18:22.666 Error: dzVents: Error: (3.0.1) Eigen verbruik: ...ripts/dzVents/scripts/script_time_upload_to_PVoutput.lua:38: attempt to perform arithmetic on a string value (local 'PowerGeneration')

Code: Select all

return {

    on = {
        devices = { 
                    21, -- Slimme meter youless (youless or P1)
                    61, -- Zonnepanelen
					}
         },
    logging = {
        level = domoticz.LOG_INFO,
--        level = domoticz.LOG_ERROR,
        marker = "Eigen verbruik"
               },    
    
    execute = function(domoticz, item)
        
        local Smartmeter = domoticz.devices(21)   -- Slimme meter (youless or P1)
        local Generation = domoticz.devices(30)   -- Zonnepanelen
        local Consumption = domoticz.devices(61)  -- Eigen verbruik / calculated value / dummy Elekta kWh + counter
        
        -- Smartmeter
        local EnergyImportLow = Smartmeter.rawData[1]
        local EnergyImportHigh = Smartmeter.rawData[2]
        local EnergyExportLow = Smartmeter.rawData[3]
        local EnergyExportHigh = Smartmeter.rawData[4]
        local PowerImport = Smartmeter.rawData[5]
        local PowerExport = Smartmeter.rawData[6]
        
        -- Generation
        local EnergyGeneration = Generation.rawData[2]
        local PowerGeneration = Generation.rawData[1]

        --Calculate
        local EnergyImport = EnergyImportLow + EnergyImportHigh
        local EnergyExport = EnergyExportLow + EnergyExportHigh
        
        local EnergyConsumption = EnergyGeneration + EnergyImport - EnergyExport
        local PowerConsumption = PowerGeneration + PowerImport - PowerExport

        domoticz.log('EnergyImportLow ' .. EnergyImportLow .. ' Wh ', domoticz.LOG_INFO)
        domoticz.log('EnergyImportHigh ' .. EnergyImportHigh .. ' Wh ', domoticz.LOG_INFO)
        domoticz.log('EnergyExportLow ' .. EnergyExportLow .. ' Wh ', domoticz.LOG_INFO)
        domoticz.log('EnergyExportHigh ' .. EnergyExportHigh .. ' Wh ', domoticz.LOG_INFO)

        domoticz.log('PowerImport ' .. PowerImport .. ' W ', domoticz.LOG_INFO)
        domoticz.log('PowerExport ' .. PowerExport .. ' W ', domoticz.LOG_INFO)
        domoticz.log('EnergyGeneration ' .. EnergyGeneration .. ' Wh ', domoticz.LOG_INFO)
        domoticz.log('PowerGeneration ' .. PowerGeneration .. ' W ', domoticz.LOG_INFO)

        domoticz.log('EnergyConsumption ' .. EnergyConsumption .. ' Wh ', domoticz.LOG_INFO)
        domoticz.log('PowerConsumption: ' .. PowerConsumption .. ' W ', domoticz.LOG_INFO)
        
        domoticz.openURL('http://127.0.0.1:8080/json.htm?type=command&param=udevice&idx=21'..'&nvalue=0&svalue='..PowerConsumption..';'..EnergyConsumption)  
        --vul zelf hier idx in van dummy Consumption (83) en domoticz port (8095)
        
    end
    
}

Code: Select all

return {

    on = {
        devices = { 
                    21, -- Slimme meter youless (youless or P1)
                    61, -- Zonnepanelen
					}
         },
    logging = {
        level = domoticz.LOG_INFO,
--        level = domoticz.LOG_ERROR,
        marker = "Eigen verbruik"
               },    
    
    execute = function(domoticz, item)
        
        local Smartmeter = domoticz.devices(21)   -- Slimme meter (youless or P1)
        local Generation = domoticz.devices(30)   -- Zonnepanelen
        local Consumption = domoticz.devices(61)  -- Eigen verbruik / calculated value / dummy Elekta kWh + counter
        
		-- Smartmeter
        local EnergyImportLow = Smartmeter.usage2
        local EnergyImportHigh = Smartmeter.usage1
        local EnergyExportLow = Smartmeter.return2
        local EnergyExportHigh = Smartmeter.return1
        local PowerImport = Smartmeter.usage
        local PowerExport = Smartmeter.usageDelivered
        
        -- Generation
        local EnergyGeneration = tonumber(Generation.rawData[2])
        local PowerGeneration = tonumber(Generation.rawData[1])

        --Calculate
        local EnergyImport = EnergyImportLow + EnergyImportHigh
        local EnergyExport = EnergyExportLow + EnergyExportHigh
        
        local EnergyConsumption = EnergyGeneration + EnergyImport - EnergyExport
        local PowerConsumption = PowerGeneration + PowerImport - PowerExport

        domoticz.log('EnergyImportLow ' .. EnergyImportLow .. ' Wh ', domoticz.LOG_INFO)
        domoticz.log('EnergyImportHigh ' .. EnergyImportHigh .. ' Wh ', domoticz.LOG_INFO)
        domoticz.log('EnergyExportLow ' .. EnergyExportLow .. ' Wh ', domoticz.LOG_INFO)
        domoticz.log('EnergyExportHigh ' .. EnergyExportHigh .. ' Wh ', domoticz.LOG_INFO)

        domoticz.log('PowerImport ' .. PowerImport .. ' W ', domoticz.LOG_INFO)
        domoticz.log('PowerExport ' .. PowerExport .. ' W ', domoticz.LOG_INFO)
        domoticz.log('EnergyGeneration ' .. EnergyGeneration .. ' Wh ', domoticz.LOG_INFO)
        domoticz.log('PowerGeneration ' .. PowerGeneration .. ' W ', domoticz.LOG_INFO)

        domoticz.log('EnergyConsumption ' .. EnergyConsumption .. ' Wh ', domoticz.LOG_INFO)
        domoticz.log('PowerConsumption: ' .. PowerConsumption .. ' W ', domoticz.LOG_INFO)
        
        domoticz.openURL('http://127.0.0.1:8080/json.htm?type=command&param=udevice&idx=21'..'&nvalue=0&svalue='..PowerConsumption..';'..EnergyConsumption)  
        --vul zelf hier idx in van dummy Consumption (83) en domoticz port (8095)
        
    end
    
}