Logs exploding

Posted on
Fri Dec 18, 2020 3:50 pm
srkinard offline
Posts: 320
Joined: Apr 10, 2016
Location: Austin, Texas

Logs exploding

Hey Karl...I just reinstalled piBeacon in my system using a pair of Raspberry Pi Zero W units that I wanted to attach a few sensors to.

I'm not using the iBeacon parts at the moment but might if I can find the moving box I tossed the beacons I have in.

My logs are blowing up with SQL Logger and beacon stuff, and it's definitely increased the CPU load on my Indigo i3 Mac mini.

Here's what I see flooding the log:

Code: Select all
Dec 18, 2020 at 3:43:41 PM
   SQL Logger                      creating table device_history_1938907366 for "beacon_05:24:3C:C8:FE:2C"
   SQL Logger                      modifying column "txpowerreceived" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
   SQL Logger                      modifying column "txpowerset" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
   SQL Logger                      adding column "onoffstate_ui" to table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C")
   SQL Logger                      creating table device_history_1426355854 for "beacon_4F:20:94:94:46:C5"
   SQL Logger                      modifying column "txpowerreceived" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
   SQL Logger                      modifying column "txpowerset" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
   SQL Logger                      adding column "onoffstate_ui" to table device_history_1426355854 ("beacon_4F:20:94:94:46:C5")
   SQL Logger                      creating table device_history_141179452 for "beacon_5C:8E:33:DB:73:E1"
   SQL Logger                      modifying column "txpowerreceived" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
   SQL Logger                      modifying column "txpowerset" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
   SQL Logger                      adding column "onoffstate_ui" to table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1")
   SQL Logger                      creating table device_history_793955583 for "beacon_60:45:37:88:07:B2"
   SQL Logger                      modifying column "txpowerreceived" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
   SQL Logger                      modifying column "txpowerset" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
   SQL Logger                      adding column "onoffstate_ui" to table device_history_793955583 ("beacon_60:45:37:88:07:B2")
   SQL Logger                      modifying column "pi_01_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
   SQL Logger                      modifying column "pi_02_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
   SQL Logger                      modifying column "pi_03_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
   SQL Logger                      modifying column "pi_04_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
   SQL Logger                      modifying column "pi_05_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
   SQL Logger                      modifying column "pi_06_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
   SQL Logger                      modifying column "pi_07_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
   SQL Logger                      modifying column "pi_08_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
   SQL Logger                      modifying column "pi_09_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
   SQL Logger                      modifying column "pi_10_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
   SQL Logger                      modifying column "pi_11_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
   SQL Logger                      modifying column "pi_12_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
   SQL Logger                      modifying column "pi_13_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
   SQL Logger                      modifying column "pi_14_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
   SQL Logger                      modifying column "pi_15_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
   SQL Logger                      modifying column "pi_16_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
   SQL Logger                      modifying column "pi_17_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
   SQL Logger                      modifying column "pi_18_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
   SQL Logger                      modifying column "pi_19_distance" type of table device_history_1837678990 ("beacon_62:3D:12:92:81:AA") from integer to REAL
   SQL Logger                      modifying column "pi_01_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
   SQL Logger                      modifying column "pi_02_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
   SQL Logger                      modifying column "pi_03_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
   SQL Logger                      modifying column "pi_04_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
   SQL Logger                      modifying column "pi_05_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
   SQL Logger                      modifying column "pi_06_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
   SQL Logger                      modifying column "pi_07_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
   SQL Logger                      modifying column "pi_08_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
   SQL Logger                      modifying column "pi_09_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
   SQL Logger                      modifying column "pi_10_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
   SQL Logger                      modifying column "pi_11_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
   SQL Logger                      modifying column "pi_12_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
   SQL Logger                      modifying column "pi_13_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
   SQL Logger                      modifying column "pi_14_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
   SQL Logger                      modifying column "pi_15_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
   SQL Logger                      modifying column "pi_16_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
   SQL Logger                      modifying column "pi_17_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
   SQL Logger                      modifying column "pi_18_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
   SQL Logger                      modifying column "pi_19_distance" type of table device_history_1426355854 ("beacon_4F:20:94:94:46:C5") from integer to REAL
   SQL Logger                      modifying column "pi_01_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
   SQL Logger                      modifying column "pi_02_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
   SQL Logger                      modifying column "pi_03_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
   SQL Logger                      modifying column "pi_04_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
   SQL Logger                      modifying column "pi_05_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
   SQL Logger                      modifying column "pi_06_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
   SQL Logger                      modifying column "pi_07_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
   SQL Logger                      modifying column "pi_08_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
   SQL Logger                      modifying column "pi_09_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
   SQL Logger                      modifying column "pi_10_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
   SQL Logger                      modifying column "pi_11_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
   SQL Logger                      modifying column "pi_12_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
   SQL Logger                      modifying column "pi_13_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
   SQL Logger                      modifying column "pi_14_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
   SQL Logger                      modifying column "pi_15_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
   SQL Logger                      modifying column "pi_16_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
   SQL Logger                      modifying column "pi_17_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
   SQL Logger                      modifying column "pi_18_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
   SQL Logger                      modifying column "pi_19_distance" type of table device_history_1147954625 ("beacon_50:A0:B8:7E:22:27") from integer to REAL
   SQL Logger                      modifying column "pi_01_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
   SQL Logger                      modifying column "pi_02_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
   SQL Logger                      modifying column "pi_03_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
   SQL Logger                      modifying column "pi_04_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
   SQL Logger                      modifying column "pi_05_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
   SQL Logger                      modifying column "pi_06_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
   SQL Logger                      modifying column "pi_07_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
   SQL Logger                      modifying column "pi_08_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
   SQL Logger                      modifying column "pi_09_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
   SQL Logger                      modifying column "pi_10_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
   SQL Logger                      modifying column "pi_11_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
   SQL Logger                      modifying column "pi_12_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
   SQL Logger                      modifying column "pi_13_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
   SQL Logger                      modifying column "pi_14_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
   SQL Logger                      modifying column "pi_15_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
   SQL Logger                      modifying column "pi_16_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
   SQL Logger                      modifying column "pi_17_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
   SQL Logger                      modifying column "pi_18_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
   SQL Logger                      modifying column "pi_19_distance" type of table device_history_141179452 ("beacon_5C:8E:33:DB:73:E1") from integer to REAL
   SQL Logger                      modifying column "pi_01_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
   SQL Logger                      modifying column "pi_02_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
   SQL Logger                      modifying column "pi_03_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
   SQL Logger                      modifying column "pi_04_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
   SQL Logger                      modifying column "pi_05_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
   SQL Logger                      modifying column "pi_06_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
   SQL Logger                      modifying column "pi_07_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
   SQL Logger                      modifying column "pi_08_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
   SQL Logger                      modifying column "pi_09_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
   SQL Logger                      modifying column "pi_10_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
   SQL Logger                      modifying column "pi_11_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
   SQL Logger                      modifying column "pi_12_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
   SQL Logger                      modifying column "pi_13_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
   SQL Logger                      modifying column "pi_14_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
   SQL Logger                      modifying column "pi_15_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
   SQL Logger                      modifying column "pi_16_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
   SQL Logger                      modifying column "pi_17_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
   SQL Logger                      modifying column "pi_18_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
   SQL Logger                      modifying column "pi_19_distance" type of table device_history_1938907366 ("beacon_05:24:3C:C8:FE:2C") from integer to REAL
   SQL Logger                      modifying column "pi_01_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
   SQL Logger                      modifying column "pi_02_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
   SQL Logger                      modifying column "pi_03_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
   SQL Logger                      modifying column "pi_04_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
   SQL Logger                      modifying column "pi_05_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
   SQL Logger                      modifying column "pi_06_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
   SQL Logger                      modifying column "pi_07_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
   SQL Logger                      modifying column "pi_08_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
   SQL Logger                      modifying column "pi_09_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
   SQL Logger                      modifying column "pi_10_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
   SQL Logger                      modifying column "pi_11_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
   SQL Logger                      modifying column "pi_12_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
   SQL Logger                      modifying column "pi_13_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
   SQL Logger                      modifying column "pi_14_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
   SQL Logger                      modifying column "pi_15_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
   SQL Logger                      modifying column "pi_16_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
   SQL Logger                      modifying column "pi_17_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
   SQL Logger                      modifying column "pi_18_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
   SQL Logger                      modifying column "pi_19_distance" type of table device_history_793955583 ("beacon_60:45:37:88:07:B2") from integer to REAL
   SQL Logger                      modifying column "pi_01_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
   SQL Logger                      modifying column "pi_02_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
   SQL Logger                      modifying column "pi_03_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
   SQL Logger                      modifying column "pi_04_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
   SQL Logger                      modifying column "pi_05_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
   SQL Logger                      modifying column "pi_06_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
   SQL Logger                      modifying column "pi_07_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
   SQL Logger                      modifying column "pi_08_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
   SQL Logger                      modifying column "pi_09_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
   SQL Logger                      modifying column "pi_10_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
   SQL Logger                      modifying column "pi_11_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
   SQL Logger                      modifying column "pi_12_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
   SQL Logger                      modifying column "pi_13_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
   SQL Logger                      modifying column "pi_14_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
   SQL Logger                      modifying column "pi_15_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
   SQL Logger                      modifying column "pi_16_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
   SQL Logger                      modifying column "pi_17_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
   SQL Logger                      modifying column "pi_18_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
   SQL Logger                      modifying column "pi_19_distance" type of table device_history_1324165061 ("beacon_49:EA:FB:79:C4:3F") from integer to REAL
   SQL Logger                      creating table device_history_4543171 for "beacon_75:7D:79:84:4F:87"
   SQL Logger                      modifying column "txpowerreceived" type of table device_history_4543171 ("beacon_75:7D:79:84:4F:87") from integer to REAL
   SQL Logger                      modifying column "txpowerset" type of table device_history_4543171 ("beacon_75:7D:79:84:4F:87") from integer to REAL
   SQL Logger                      adding column "onoffstate_ui" to table device_history_4543171 ("beacon_75:7D:79:84:4F:87")
   SQL Logger                      creating table device_history_29127195 for "beacon_50:E8:94:2D:A7:10"
   SQL Logger                      modifying column "txpowerreceived" type of table device_history_29127195 ("beacon_50:E8:94:2D:A7:10") from integer to REAL
   SQL Logger                      modifying column "txpowerset" type of table device_history_29127195 ("beacon_50:E8:94:2D:A7:10") from integer to REAL
   SQL Logger                      adding column "onoffstate_ui" to table device_history_29127195 ("beacon_50:E8:94:2D:A7:10")


I thought I had turned off the SQL Logger stuff for it, as in screenshot attached.

What am I doing wrong?

Thanks
Ross
Attachments
Screen Shot 2020-12-18 at 3.49.02 PM.png
Screen Shot 2020-12-18 at 3.49.02 PM.png (110.56 KiB) Viewed 3659 times

Posted on
Fri Dec 18, 2020 5:31 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: Logs exploding

That indigo

When a device state gets created as number =integer ( only option) and the data is a real number indigo / sql changes the property to real when it gets populated

Normally when a device gets created it happens one after the other. But if all
Of them get created at once sql might get overwhelmed.
Don’t stop sql but stop pibeacon wait 1 minute then restart pibeacon. Do this several times until all states have been converted.

Sorry I can’t do anything about that until indigo offers real number for a state at initialization.

Karl


Sent from my iPhone using Tapatalk

Posted on
Fri Dec 18, 2020 10:16 pm
srkinard offline
Posts: 320
Joined: Apr 10, 2016
Location: Austin, Texas

Re: Logs exploding

I managed to stop the traffic (for now) by changing to this setting in Accept/Reject New Beacons
Code: Select all
RSSI >-5; Tag=off

When I re-introduce beacons I'll adapt and get it working

Setting all this up was a bit of a chore...the latest image I could find of your preconfigured image was 2020-02-25-pibeacon-buster.img and this would kernel panic on any SD card in every one of my Raspberry Pi Zero W units (I have 3)

I ended up installing the Raspberry Pi OS 32-bit minimal using the Raspberry Pi Imager software to DL and create the SD card.
Pushing the files to the Pi worked, but the installLibs.py would error out so I ended up running this series of commands to get it to work:

Code: Select all
sudo apt-get -y update
sudo apt-get -y upgrade
sudo apt-get dist-upgrade
sudo apt-get -y autoremove
sudo apt-get clean
sudo apt-get -y install git
sudo apt-get -y install build-essential python-dev
sudo apt-get -y install python-pygame
sudo apt-get -y install python-dev
sudo apt-get -y install python-bluez
sudo apt-get -y install python-smbus
sudo apt-get -y install i2c-tools
sudo apt-get -y install python3-setuptools
sudo apt install python-pip
python -m pip install --upgrade pip setuptools
sudo python installLibs.py


I still need to set them up for logs to write to RAM disk and save the write cycles on the SD card.

Might get a Pi 4 to be a controller in one room, with NeoPixel output to a series of them placed in a display case with figures and collectables...so I can control the colors and such in each area based on the object inside it.

Posted on
Fri Dec 18, 2020 10:26 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: Logs exploding

for a manual creation of the SD card check out the page: https://forums.indigodomo.com/viewtopic.php?f=187&t=15482

I tested THAT image on an RPI0w that one worked for me, don't know what wrong

Karl

Posted on
Fri Dec 18, 2020 10:46 pm
srkinard offline
Posts: 320
Joined: Apr 10, 2016
Location: Austin, Texas

Re: Logs exploding

I did try those instructions, but the base image that comes from the official Raspberry Pi tool is missing git and other things...

Here's just one of the attempts to run the installLibs.py and you'll see a few errors:
Code: Select all
pi@rPi-Zero-W-01:~/pibeacon $ sudo python installLibs.py
18-14:15:25 installLibs     <module>             L:316  Lv:30  installLibs starting
18-14:15:25 installLibs     <module>             L:343  Lv:30  installLibs no opsys upgrade requested
test: [-1, True, True, True, True, False, False, False, False, False]
18-14:15:25 installLibs     <module>             L:359  Lv:30 ==== tested installed version, doing upgrades
18-14:15:25 installLibs     setupLibs            L:23   Lv:30 ==== starting setup sensor libraries
18-14:15:25 installLibs     setupLibs            L:25   Lv:30 ==== check if nameserver works
18-14:15:27 installLibs     setupLibs            L:40   Lv:30 ==== testing config files and updating if needed
18-14:15:28 installLibs     setupLibs            L:179  Lv:30 ==== installing apt-get install -y python-dev
18-14:15:33 installLibs     setupLibs            L:181  Lv:30 python-dev return Reading package lists...
Building dependency tree...
Reading state information...
python-dev is already the newest version (2.7.16-1).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.


18-14:15:34 installLibs     setupLibs            L:185  Lv:30 ==== installing apt-get install python-bluez
18-14:15:40 installLibs     setupLibs            L:187  Lv:30 Reading package lists...
Building dependency tree...
Reading state information...
python-bluez is already the newest version (0.22+really0.22-1).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.


18-14:15:41 installLibs     setupLibs            L:191  Lv:30 ==== installing apt-get -y install python-smbus
18-14:15:47 installLibs     setupLibs            L:193  Lv:30 Reading package lists...
Building dependency tree...
Reading state information...
python-smbus is already the newest version (4.1-1).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.


18-14:15:48 installLibs     setupLibs            L:197  Lv:30 ==== installing apt-get -y install i2c-tools
18-14:15:54 installLibs     setupLibs            L:199  Lv:30 Reading package lists...
Building dependency tree...
Reading state information...
i2c-tools is already the newest version (4.1-1).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.


18-14:15:55 installLibs     setupLibs            L:203  Lv:30 ==== installing cd /home/pi/ ;git clone https://github.com/adafruit/Adafruit-Raspberry-Pi-Python-Code.git
18-14:15:58 installLibs     setupLibs            L:205  Lv:30
Cloning into 'Adafruit-Raspberry-Pi-Python-Code'...

18-14:15:59 installLibs     setupLibs            L:209  Lv:30 ==== checking  spi
18-14:16:00 installLibs     setupLibs            L:213  Lv:30
--2020-12-18 14:15:59--  https://github.com/Gadgetoid/py-spidev/archive/master.zip
Resolving github.com (github.com)... 140.82.114.4
Connecting to github.com (github.com)|140.82.114.4|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://codeload.github.com/Gadgetoid/py-spidev/zip/master [following]
--2020-12-18 14:15:59--  https://codeload.github.com/Gadgetoid/py-spidev/zip/master
Resolving codeload.github.com (codeload.github.com)... 140.82.113.10
Connecting to codeload.github.com (codeload.github.com)|140.82.113.10|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [application/zip]
Saving to: ‘master.zip’

     0K .......... .......... .                                 217K=0.1s

2020-12-18 14:16:00 (217 KB/s) - ‘master.zip’ saved [22178]


18-14:16:00 installLibs     setupLibs            L:216  Lv:30 ==== installing echo 'A'| unzip master.zip; rm master.zip; cd /home/pi/py-spidev-master; sudo /usr/bin/python setup.py install;cd /home/pi/pibeacon/
18-14:16:00 installLibs     setupLibs            L:218  Lv:30
unzip:  cannot find or open master.zip, master.zip.zip or master.zip.ZIP.
rm: cannot remove 'master.zip': No such file or directory
/usr/bin/python: can't open file 'setup.py': [Errno 2] No such file or directory

18-14:16:00 installLibs     setupLibs            L:219  Lv:30 ==== installing echo 'A'| unzip master.zip; rm master.zip; cd /home/pi/py-spidev-master; sudo /usr/bin/python setup.py install;cd /home/pi/pibeacon/ done
DHTinstalled False
18-14:16:01 installLibs     setupLibs            L:232  Lv:30 ==== getting  cd /home/pi/; git clone https://github.com/adafruit/Adafruit_Python_DHT.git
18-14:16:03 installLibs     setupLibs            L:235  Lv:30 Adafruit_Python_DHT return
Cloning into 'Adafruit_Python_DHT'...

18-14:16:03 installLibs     setupLibs            L:238  Lv:30 Adafruit_Python_DHT return
Traceback (most recent call last):
  File "setup.py", line 1, in <module>
    from setuptools import setup, find_packages, Extension
ImportError: No module named setuptools

18-14:16:04 installLibs     setupLibs            L:245  Lv:30 ==== getting  cd /home/pi/ ; git clone https://github.com/adafruit/Adafruit_Python_GPIO.git
18-14:16:06 installLibs     setupLibs            L:248  Lv:30 Adafruit_Python_GPIO return

Cloning into 'Adafruit_Python_GPIO'...

18-14:16:07 installLibs     setupLibs            L:251  Lv:30 Adafruit_Python_GPIO return
Adafruit GPIO Library
Works best with Python 2.7
THIS INSTALL SCRIPT MAY REQUIRE ROOT/ADMIN PERMISSIONS
Especially if you installed python for "all users" on Windows

try the following in your systems terminal if ensurepip is not sufficient:
$ python -m ensurepip --upgrade
$ python -m pip install --upgrade pip setuptools
ensurepip is disabled in Debian/Ubuntu for the system python.

Python modules For the system python are usually handled by dpkg and apt-get.

    apt-get install python-<module name>

Install the python-pip package to use pip itself.  Using pip together
with the system python might have unexpected results for any system installed
module, so use it on your own risk, or make sure to only use it in virtual
environments.



18-14:16:07 installLibs     setupLibs            L:256  Lv:30 =======  finished setup sensor libraries ==========
18-14:16:07 installLibs     <module>             L:368  Lv:30 ==== libraries install finished

Errors like the 'ImportError: No module named setuptools' would not resolve until I had run these three

Code: Select all
sudo apt-get -y install python3-setuptools
sudo apt install python-pip
python -m pip install --upgrade pip setuptools

Only after doing all that and rebooting did everything finally appear to be working.

Two of my Zero Ws are older and one I just purchased from Amazon a week or so ago.
Not sure why the image KPs on them...but now that I've got it all running they are functioning.
I've connected a DHT11 to each of them to test...will probably pop a BME280 on them instead, along with a motion sensor

I forgot how much this plugin could do...the last two years have been chaotic so just now back to tinkering with the setup.

Posted on
Fri Dec 18, 2020 10:50 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: Logs exploding

Code: Select all
sudo apt-get -y install python3-setuptools
sudo apt install python-pip
python -m pip install --upgrade pip setuptools


will add those to install libs .py

Posted on
Fri Dec 18, 2020 11:02 pm
srkinard offline
Posts: 320
Joined: Apr 10, 2016
Location: Austin, Texas

Re: Logs exploding

I vaguely remember as I completed them, there was a warning about pip not supporting Python 2.7 beginning Jan 2021, and will require Python 3 for future versions.
I was doing that late last night and was about to fall asleep...so I didn't screenshot it.

Posted on
Fri Dec 18, 2020 11:04 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: Logs exploding

O sh

Have to make a new sd image in December.


Sent from my iPhone using Tapatalk

Posted on
Sat Dec 19, 2020 8:06 am
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: Logs exploding

Re sensors. I would try the ble sensors
They cover almost all areas :
T
H
P
Acceleration/ gravity/ orientation
Proximity
Movement
On/off- contact / magnetic / button/ buttons ..
Light on/off
Gas alarm
Soil moisture..
Some with display
In various forms and sizes
Cost $5-30

And they can be placed anywhere < 30 m away from rpi ... no wires
I have them in freezer, pool , outside, inside
Pocket, window/door open/close
Remote buttons for garage door ...

Not covered are air quality, co,co2 rgb sensors

You can check the list
In “add new device” or in the plugin directory there are files with a list of sensors/ beacons and properties/functions supported

Karl


Sent from my iPhone using Tapatalk

Posted on
Sat Dec 19, 2020 5:06 pm
matt (support) offline
Site Admin
User avatar
Posts: 21411
Joined: Jan 27, 2003
Location: Texas

Re: Logs exploding

kw123 wrote:
Sorry I can’t do anything about that until indigo offers real number for a state at initialization.

We'll get this better behaved in the next release. Just use <ValueType>Float</ValueType> when declaring the state and for newly created devices it will be a float/real instead of an integer.

Image

Posted on
Sat Dec 19, 2020 6:11 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Logs exploding

Is that backward compatible ie
float in 7.5 —> number when using 7.4 ?


Sent from my iPhone using Tapatalk

Posted on
Sat Dec 19, 2020 6:11 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: Logs exploding

And in 2020


Sent from my iPhone using Tapatalk

Posted on
Sun Dec 20, 2020 10:49 am
matt (support) offline
Site Admin
User avatar
Posts: 21411
Joined: Jan 27, 2003
Location: Texas

Re: Logs exploding

kw123 wrote:
Is that backward compatible ie
float in 7.5 —> number when using 7.4 ?

Yes, I believe you can use Float currently in 7.4. It will default to an integer until 7.5, but it should still work okay.

Image

Posted on
Tue Dec 22, 2020 4:09 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Logs exploding

yes in 7.4 "Float" works in devices.xml for states, it shows the same behavior as "Number"

Karl

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 3 guests