Best posts made by parkerc | Smart Home

parkerc

I’m a bit old school, I still use Prowl with my Veras - https://www.prowlapp.com/

Here’s some code examples on how to use it.


function my_escape (s)
    s = string.gsub(s, " ", "+")
    return s
end

function my_prowl (appl, event, description)
    local prowl_url      = "https://api.prowlapp.com/publicapi/add?apikey="
        .. "put-your-api-code-here"
        .. "&application=" .. my_escape(appl)
        .. "&event="         .. my_escape(event)
        .. "&description=" .. my_escape(description)
        .. "&priority=-1"
        .. "&url=https://www.google.co.uk/"
    luup.inet.wget(prowl_url)
end

my_prowl ("Vera Home Controller", "Testing code", "this could any description")

Or something all in one..


luup.inet.wget("https://api.prowlapp.com/publicapi/add?apikey=Your-api-key-goes-here&application=Test+Event&event=Armed+Notification&description=The+DSC+alarm+system+has+been+armed&priority=1")

parkerc

I’m sure there is a better/more polished way to do this, but this remains one of my go to report urls on Vera.


-- http://forum.micasaverde.com/index.php?topic=52025.msg334246#msg334246

local d, n
local file = io.open("/www/sb.html", "w")
   file:write("<head> <meta http-equiv='refresh' content='30' /> </head>\n")
   file:write("<style>.custom { font-size: 1em; font-family: Gill Sans Extrabold, sans-serif; padding:5px; border-collapse: collapse; border: 1px solid black; }</style><table class=custom><tr class=custom><th class=custom>Security Sensor</th><th class=custom>Last Tripped</th></tr>\n")

local tt = {}
for n,d in pairs(luup.devices) do

    if d.category_num == 4 then
    -- local lasttrip = tonumber(luup.variable_get("urn:micasaverde-com:serviceId:SecuritySensor1", "LastTrip", n) or 0,10)
    local lasttrip = tonumber(luup.variable_get ("urn:micasaverde-com:serviceId:SecuritySensor1", "LastTrip", n) or os.time())
    local timeString = os.date(" %Y/%m/%d - %X", lasttrip)
    
    if lasttrip > 0 then
        table.insert(tt, { devnum=n, last=lasttrip, ltime=timeString })
    end
  end
end

table.sort(tt, function(a,b) return a.last > b.last end) -- sort highest to lowest

for n,d in ipairs(tt) do
    
   file:write("<tr class=custom><td class=custom>" .. luup.devices[d.devnum].description .. "</td><td class=custom>".. d.ltime .. "</td></tr>\n")

    print (
    d.ltime ..
   ' : ' .. luup.devices[d.devnum].description .. " Sensor was last tripped")
end
file:write("</table>\n")
file:close()

parkerc

Oh, and if I just want to pull one of the items I just specify the iso number with the snmpget command. E.g

local command = io.popen("ssh -i /etc/dropbear/dropbear_rsa_host_key pi@192.168.102.37 'snmpget -v1 -c public 10.10.10.103 iso.3.6.1.2.1.1.1.0' 2>&1")
local response = command:read("*a")
print(response)

which in this case will just return the first one.

iso.3.6.1.2.1.1.1.0 = STRING: "Eaton 5P 1150"

parkerc

Thanks - this is good timing as I’m at the point where I need to replace both the vacuum cleaner and also our lawn mower , and the robot option look very attractive in both areas

parkerc

Sharing the love...

As I have a number of foscam cameras around the house, using their API I created the following bit of code to set to retrieve any settings across all of them, to keep them in sync.

This one gets the device name from each of them. If anyone has any variations or ways to improve the bit of code please let me know..

local url = require("socket.url")
local URL = "http://" 
local username = "admin" 
local password = "password" 
local cmd = "getDevName"

-- /cgi-bin/CGIProxy.fcgi?cmd=getDevName&usr=admin&pwd=

local foscamsIPs = {
    { NO=1, IP="192.168.102.165:88", LOCATION="conservatory"}, 
    { NO=2, IP="192.168.102.38:80", LOCATION="boiler room"},
    { NO=3, IP="192.168.102.223:88", LOCATION="Living room"},
	{ NO=4, IP="192.168.102.245:88", LOCATION="front room"},
	{ NO=5, IP="192.168.102.104:88", LOCATION="kitchen"},
}

for k,v in pairs(foscamsIPs) do
  -- Read each value.
  local update = URL .. v["IP"] .. "/cgi-bin/CGIProxy.fcgi?cmd="..cmd.."&usr="..username.."&pwd="..password
  -- do this for each reading.
  local status, result = luup.inet.wget(update)
  	print(v["LOCATION"].. " status is " ..status.. " : result is " ..result)
end````

parkerc

Just wanted to add that my Vera Bridges stopped working, I can’t be sure exactly when, maybe after a reboot ? But wanted to share here as they were working fine..

The Variable for the RemotePort on both is /port_3480

Updating to :3480 fixes it..

@akbooer - not sure why this worked first and then stopped..

parkerc

Happy Birthday!

parkerc

Hi @d868, other than creating our own image, we’ll have to wait until one’s approved and then published on Docker Hub.
If it helps you I’m planning to do the same thing with MSR as I did with Home Assistant, and create a Container Station API build guide.

Jan 23, 2021

QNAP - Installation via Container Station’s API

Rather than use the UI to build your Home Assistant Docker container, you can do it all via the command line using its API. https://qnap-dev.github.io/container-station-api/ Here’s how I did it… On any device, access it via the command line, In this situation, I’m doing it on the QNAP itself...

parkerc

Thanks @toggledbits - it’s all working now !!

My last piece is back to my other post around error handling, and how I can present that better to the user, and so for that topic, I;ll revert back to that thread.. - > https://smarthome.community/topic/777/luup-error-handling/9

parkerc

There is a great community/code bank on GitHub.

GitHub - probonopd/irdb: One of the largest crowd-sourced, manufacturer-independent databases of infrared remote control codes on the web, and aspiring to become the most comprehensive and most...

One of the largest crowd-sourced, manufacturer-independent databases of infrared remote control codes on the web, and aspiring to become the most comprehensive and most accurate one - probonopd/irdb

Index of codes is here - https://github.com/probonopd/irdb/blob/master/index

With their API - http://irdb.tk/api

And you can retrieve a .csv set for anyone via https://cdn.jsdelivr.net/gh/probonopd/irdb@master/codes/Samsung/TV/7,7.csv

parkerc

Hey @rafale77

I’m going to have a play with this later, as a comprehensive usb/serial server (https://smarthome.community/topic/209/home-automation-serial-server-raspberry-pi ) is something I’ve been tinkering with for years ! (https://community.getvera.com/t/building-a-ser2net-serial-to-ip-server/173673) - wow has it really been that long .. 2012 !!!

Once announced and eventually added to Vera, Zigbee has been a capability that I’ve been keen to explore, but due to it’s lack of consistency (compared to z-wave) I’ve not invested much time.

Although; it is on my HA to-do list, - out of my league, but by opening up the zigbee on Vera, is there the potential to extend its usage with (https://github.com/koenkk/zigbee-herdsman ) and (https://github.com/koenkk/zigbee2mqtt) ?

parkerc

Managed to get there in the end, posting here to help others..

local http = require("socket.http")
local ltn12 = require("ltn12")
local mime = require("mime")
local lfs = require("lfs")

local username = "username,"
local password = "password"

http.TIMEOUT = 5

local function upload_file ( url, filename, title, correspondent )
    local fileHandle = io.open( filename,"rb")
    local fileContent = fileHandle:read( "*a" )
    fileHandle:close()

    local boundary = 'abcd'
	local cdfd = 'Content-Disposition: form-data; '

    local header_b = cdfd.. 'name="document"; filename="' ..filename.. '"\r\nContent-Type: application/pdf'
    local header_c = cdfd.. 'name="title"\r\n\r\n'..title
    local header_d = cdfd.. 'name="correspondent"\r\n\r\n'..correspondent

    local MP_b = '--'..boundary..'\r\n'..header_b..'\r\n\r\n'..fileContent..'\r\n'
    local MP_c = '--'..boundary..'\r\n'..header_c..'\r\n'
    local MP_d = '--'..boundary..'\r\n'..header_d..'\r\n'

    local MPCombined = MP_b..MP_c..MP_d..'--'..boundary..'--\r\n'

    local   response_body = { }
    local   _, code = http.request {
            url = url ,
            method = "POST",
            headers = {    
						["Authorization"] = "Basic " .. (mime.b64(username ..":" .. password)),
						["Content-Length"] =  MPCombined:len(),
                        ['Content-Type'] = 'multipart/form-data; boundary=' .. boundary
                         },
            source = ltn12.source.string(MPCombined) ,
            sink = ltn12.sink.table(response_body),
                }
     return code, table.concat(response_body)
end

 -- local rc,content = upload_file ('http://httpbin.org/post', '/mnt/nas/10.pdf' )
 local rc,content = upload_file ('http://192.168.1.134:8777/api/documents/post_document/', '/mnt/nas/10.pdf', 'Companies House', '12')
 print(rc,content)

parkerc

What bulbs do you have that are driving the requirement ?

Having the 2 wire set up myself - (using fibaro dimmers) I have a mix of bulb types, from the old fashion filament ones, up to the newer LEDs -

To avoid any issues, I would try to get dimmable bulbs - who knows you might start to like a bit of mood lighting.

Over time I’ve actually moved most of my lights over to Hue, and also put the hue switch over the existing switch (that way they can’t be turned off)
I did this as I liked that I can have more things access/control my lights.

parkerc

Slight tangent, but I’ve been using sipgate voip service ( https://www.sipgate.co.uk/ ) for years, and I’ve never really explored its API..

There seems to be a wealth of capabilities in there.. - https://api.sipgate.com/v2/doc

If it’s of interest to you or any others, my initial attempt to authenticate / use it is below..

#!/usr/bin/lua

print("start of whole code")

local https = require "ssl.https"
local mime = require "mime"
local json = require "dkjson"
--local http = require "socket.http"
local data = ""
local username = "sipname"
local password = "sippass"

local function collect(chunk)
  if chunk ~= nil then
    data = data .. chunk
    end
  return true
end

local ok, statusCode, headers, statusText = https.request {
  method = "GET",
  url = "https://api.sipgate.com/v2/history",
  headers = {
    ["Accept"] = "application/json",
    ["Authorization"] = "Basic " .. (mime.b64(username ..":" .. password)),
    },
  sink = collect
}

print("data = ", data)
local sip = json.decode(data)
print("---------")
for k, v in pairs(sip) do
	print(k, "\t", v)
  end
print("---------")
for n, a in pairs(sip.items) do
	print(n, "\t", a)
end
print("---------")
for p, k in pairs(sip.items) do
	--print(n, "\t", a)
print("---------")
for d, e in pairs(sip.items[p]) do
		print(d, "\t", e)
end
end
print("---------")

parkerc

@catmanv2 said in Dumb question about bulbs:

Mood is a thing for cattle and making love

Not quite sure how to interpret that !!

parkerc

@librasun said in Caller ID in HA workflow:

. But you bring up an interesting point, @parkerc ... I've never seen "Lua" among the languages they offer, lol!

Exactly !, I noticed that too, no one seems to promote Lua

@librasun said in Caller ID in HA workflow:

Nice to see you rolling your own. And if it works, perhaps send the company a copy for them to add to their library?

It took me a while to just get that working, I don’t think those types of companies will want to use my pieced together bits of code

parkerc

Thanks so much @therealdb - Such a silly mistake, for some reason I was thinking it would run the whole piece of code, when i should have realised it will only run the function part, as that’s all that’s being called! Doh !

.

parkerc

Quick update on this thread as Homer has become my go-to-place now for accessing all my applications - attached is a screenshot of one of my Homer pages..

If anyone’s wondering that ‘cabin’ is the glorified name for the shed at the end of the garden we converted (Sadly nothing as luxurious as it sounds.)

parkerc

It must have got there via the original restore process.

Ok, I’ve now copied over an earlier dongle dump direct from the VeraPlus, and made that the zero/0 one.

scp dongle.4.5.dump.4 root@192.168.1.145:/etc/cmh/dongle.4.5.dump.0

Let’s try again

parkerc

HA and AI

Self test

How to upgrade from an old version of MSR?

Access control - allowing anonymous user to dashboard

VEC Virtual Switch Auto Off

Upcoming Storage Change -- Got Back-ups?

Oddness in Copy/Move of Reactions

[Solved] function isRuleEnabled() issue

[Reactor] Problem with Global Reactions and groups

Possible feature request 2?

Reactor (Multi-System/Multi-Hub) Announcements

Genuinely impressed with Zigbee and HA / Reactor

Copying a global reaction

[HowTo] Using HABridge with Reactor

[Reactor] Bug when sending MQTT boolean payloads

Difficulty defining repeating annual period

Need help with sequence

Possible feature request?

Logic Assistance: Exterior Lights on when Illuminance Below Threshold

Time series documentation

Posts

QNAP - Installation via Container Station’s API

GitHub - probonopd/irdb: One of the largest crowd-sourced, manufacturer-independent databases of infrared remote control codes on the web, and aspiring to become the most comprehensive and most...