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 […]
Category: Random Bits
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(“https://mysite.com.com/query.php?string=” + value); Logger.log(response.getContentText()); return JSON.parse(response); […]
How to generate Slack API Tokens
The Slack UI has changed and a lot of old documentation still asks people to create API tokens from https://api.slack.com/web But legacy tokens (not oauth) have moved over to: https://api.slack.com/custom-integrations/legacy-tokens
Easily Pay Invoices with Bitcoin
Need an easy way for your customers to pay their invoices with bitcoin? Check out Ultimate Client Manager (UCM), they just released a bitcoin payments feature http://codecanyon.net/item/ultimate-client-manager-pro-edition/2621629
Android ICS on HTC Desire with USB Host Mode
Install CronMod on your HTC Desire (see this thread: http://forum.xda-developers.com/showthread.php?t=1946517 ) build custom kernel with USB host mode support: git clone git@github.com:croniccorey/eternity-kernel.git 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 192.168.0.16:5555 # 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 […]
HTC Desire USB Host Mode HOWTO
Quick post with instructions on USB Host Mode for HTC Desire
Android Galaxy S3 connected to an Arduino Leostick
Quick post, will push full code and instructions when completed. Create a USB on the go cable (or just buy one if you don’t have spare cables to cut up) Connect it to an Android device (3.1 or above with USB host mode support) Plug in an Arduino (or a leostick) Arduino should power up […]