Cleaning Up ALDB on Switches

[Burzin Sumariwalla]

Hello,


I'm trying to cleanup the ALDB on a number of switches (2477D and 2477S) using Insteon-Terminal. However, Insteon-Terminal does not appear able to clean things up as I'd like what am I doing wrong?

Init.py (snippet)

def connectToMySerial():
"""connects to my modem on pre-defined serial port"""
connectToSerial("ttyUSB-Insteon")
connectToMySerial()
Modem1 = Modem2413U("Modem", "4C.17.28")
Modem2 = Modem2413U("Modem", "44.85.B2")
Kitchen_Island_Lights_A = Dimmer2477D("Kitchen_Island_Lights_A", "43.14.90")
Kitchen_Island_Lights_B = Dimmer2477D("Kitchen_Island_Lights_B", "43.48.66")

DB of Kitchen_Island_Lights_B

>>> Kitchen_Island_Lights_B.getdb()
getting db, be patient!
sent db query msg, incoming records: 1 1 2 3 4 5 6 6 7 8 9dbbuilder.done() is called
0fff Kitchen_Island_Lights_A 43.14.90 CTRL 11100010 group: 01 ON LVL: 3 RMPRT: 28 BUTTON: 1
0ff7 Kitchen_Island_Lights_A 43.14.90 RESP 10101010 group: 01 ON LVL: 255 RMPRT: 28 BUTTON: 1
0fef 4C.4C.4C 4C.4C.4C (RESP) 00101010 group: 01 ON LVL: 0 RMPRT: 28 BUTTON: 1
0fe7 Modem 44.85.B2 CTRL 11101010 group: fe ON LVL: 3 RMPRT: 28 BUTTON: 254
0fdf 00.00.00 00.00.00 (RESP) 00101010 group: fe ON LVL: 255 RMPRT: 28 BUTTON: 254
0fd7 4C.17.2B 4C.17.2B RESP 10101010 group: 01 ON LVL: 0 RMPRT: 28 BUTTON: 1
0fcf 4C.17.2B 4C.17.2B CTRL 11101010 group: 01 ON LVL: 3 RMPRT: 28 BUTTON: 1
0fc7 4C.4C.4C 4C.4C.4C (RESP) 00101010 group: 01 ON LVL: 3 RMPRT: 28 BUTTON: 1
0fbf 00.00.00 00.00.00 (STOP) 00000000 group: 00 ON LVL: 0 RMPRT: 0 BUTTON: 0

Entries to Remove

0fef 4C.4C.4C 4C.4C.4C (RESP) 00101010 group: 01 ON LVL: 0 RMPRT: 28 BUTTON: 1
0fe7 Modem 44.85.B2 CTRL 11101010 group: fe ON LVL: 3 RMPRT: 28 BUTTON: 254
0fdf 00.00.00 00.00.00 (RESP) 00101010 group: fe ON LVL: 255 RMPRT: 28 BUTTON: 254

Removal Attempts

>>> Kitchen_Island_Lights_B.removeController("44.85.B2", "fe")

getting db, be patient!

sent db query msg, incoming records: 1 1 2 3 4 4 5 6 7 7 8 9dbbuilder.done() is called

database complete, analyzing...

no matching found record, no action taken!

>>> Kitchen_Island_Lights_B.removeResponder("4C.4C.4C", "01")

getting db, be patient!

sent db query msg, incoming records: 1 2 3 4 5 6 7 8 9dbbuilder.done() is called

database complete, analyzing...

no matching found record, no action taken!

>>> Kitchen_Island_Lights_B.removeResponder("00.00.00", "fe")

getting db, be patient!

sent db query msg, incoming records: 1 2 3 3 4 4 5 6 7 8 9dbbuilder.done() is called

database complete, analyzing...

no matching found record, no action taken!

>>> Kitchen_Island_Lights_B.removeDevice("4C.4C.4C")

getting db, be patient!

sent db query msg, incoming records: 1 2 2 3 4 5 6 7 7 8 9dbbuilder.done() is called

database complete, analyzing...

no matching record found, no action taken!

>>> Kitchen_Island_Lights_B.removeDevice("00.00.00")

getting db, be patient!

sent db query msg, incoming records: 1 2 3 4 5 6 7 8 9dbbuilder.done() is called

database complete, analyzing...

no matching record found, no action taken!

>>> Kitchen_Island_Lights_B.removeDevice("44.85.B2")

getting db, be patient!

sent db query msg, incoming records: 1 2 3 3 4 5 6 6 7 8 9dbbuilder.done() is called

database complete, analyzing...

0fff Kitchen_Island_Lights_A 43.14.90 CTRL 11100010 group: 01 ON LVL: 3 RMPRT: 28 BUTTON: 1

found active records:

0ff7 Kitchen_Island_Lights_A 43.14.90 RESP 10101010 group: 01 ON LVL: 255 RMPRT: 28 BUTTON: 1

removing record: 0fe7 Modem 44.85.B2 CTRL 11101010 group: fe ON LVL: 3 RMPRT: 28 BUTTON: 254

0fef 4C.4C.4C 4C.4C.4C (RESP) 00101010 group: 01 ON LVL: 0 RMPRT: 28 BUTTON: 1

0fe7 Modem 44.85.B2 CTRL 11101010 group: fe ON LVL: 3 RMPRT: 28 BUTTON: 254

0fdf 00.00.00 00.00.00 (RESP) 00101010 group: fe ON LVL: 255 RMPRT: 28 BUTTON: 254

0fd7 4C.17.2B 4C.17.2B RESP 10101010 group: 01 ON LVL: 0 RMPRT: 28 BUTTON: 1

sent msg: OUT:Cmd:0x62|toAddress:43.48.66|messageFlags:0x1F=DIRECT:3:3|command1:0x2F|command2:0x00|userData1:0x00|userData2:0x02|userData3:0x0F|userData4:0xE7|userData5:0x08|userData6:0x2A|userData7:0xFE|userData8:0x44|userData9:0x85|userData10:0xB2|userData11:0x03|userData12:0x1C|userData13:0xFE|userData14:0x11|

0fcf 4C.17.2B 4C.17.2B CTRL 11101010 group: 01 ON LVL: 3 RMPRT: 28 BUTTON: 1

0fc7 4C.4C.4C 4C.4C.4C (RESP) 00101010 group: 01 ON LVL: 3 RMPRT: 28 BUTTON: 1

0fbf 00.00.00 00.00.00 (STOP) 00000000 group: 00 ON LVL: 0 RMPRT: 0 BUTTON: 0

>>> got set record got no reply!

Regards,

Burzin

[Bernd Pfrommer]

Are the records you are trying to remove active? The are in parentheses, e.g. (RESP) instead of RESP. That means they are already removed.

The insteon switches don't compress the database once you remove links. That's asking too much of such a low level device (really???).

But if you create new links, it will re-purpose the records that are inactive, i.e. (RESP) and (CTRL).

[3032.woodbrid...@gmail.com]

Ah thank you.  That explains it then.  Those parenthetical entries are not active.    Is there any place that I can read up on how to interpret the ALDB output?

[Bernd Pfrommer]

There is some stuff about it in the Insteon docs on what the entries mean, but sorry, not documented with Insteon Terminal.