Category: Random Bits

Monitoring Solar Panels with NodeRed + InfluxDB + Grafana

This post will guide you through how to monitor your solar panels using some free open source tools running on your local network. Required technical level: Moderate to Advanced experience with programming/networking/sql/docker. This certainly isn’t a point and click solution. Here’s a summary of the setup: Solar System: 18 x REC 350W panels 18 x […]

Load data into Google Spreadsheet from PHP

Lets say you have a PHP script that returns a value, based on a query string: Getting the result of that PHP script into Google Sheets is rather easy. Open Tools > Script Editor in Google Sheets and create a function like this: function getMyQueryValue(value) { var response = UrlFetchApp.fetch(“” + value); Logger.log(response.getContentText()); return JSON.parse(response); […]

Android ICS on HTC Desire with USB Host Mode

Install CronMod on your HTC Desire (see this thread: ) build custom kernel with USB host mode support: git clone git checkout remotes/origin/ics apply Host Mode patch: make clean make bravo_defconfig make menuconfig (select USB options, deselect USB gadget support)  “Device Drivers => USB Support => USB Modem (CDC ACM)  include as a module. $ grep […]

Android: Unknown symbol _GLOBAL_OFFSET_TABLE_

[ 1525.047424] bcm4329: Unknown symbol _GLOBAL_OFFSET_TABLE_ (err 0) I received this error after compiling a custom Android kernel and modules using the arm-linux-androideabi-4.4.3 prebuilt toolchain. I used arm-linux-androideabi-4.4.3 instead of arm-eabi-4.4.0 because arm-eabi-4.4.0 did not work for me on 64bit ubuntu ( * shrug * ) To fix this and to get my kernel modules loading I opened the […]

HOWTO: enable SSH on Android and network ADB

Activate debugging and network debugging on the android device. Find out the IP of your android device. Run adb on your computer connecting to android over the network: adb connect # displays “connected” message adb shell id # displays “uid=0(root) gid=0(root)” Enabling SSH: Push your public key to the android device to allow password-less […]