12/12/2014
give me input
Showing posts with label raspberry. Show all posts
Showing posts with label raspberry. Show all posts
Sunday, February 1, 2015
Temperature and Relative Humidity
Below is a plot of my measured temperatures and humitidy for my house over time. Data is collected from Oregon sensors over 433hz wireless transmission to the raspberry pi (with 433hz receiver) and stored in Google docs. The graph below is created with the help of highcharts using java script.
Sunday, January 25, 2015
Curl C to google sheets
A quick post about using the CURL C API to upload data to google spreadsheets. I used it upload temperature and humidity data that I am tracking at home. There are a few steps
1.) create a google spreadsheet the normal way (with headings for each data item you want to save)
2.) get auth from google:
curl_easy_setopt(curl, CURLOPT_URL, "https://www.google.com/accounts/ClientLogin");
curl_easy_setopt(curl, CURLOPT_FOLLOWLOCATION, 1L);
curl_easy_setopt(curl, CURLOPT_POSTFIELDS, "Email=YOUREMAIL&Passwd=YOURPASSWORD&accountType=GOOGLE&source=cURL&service=writely");
3.) Form your data in the correct XML format:
sprintf(postData, "<entry xmlns='http://www.w3.org/2005/Atom' xmlns:gsx='http://schemas.google.com/spreadsheets/2006/extended'> <gsx:date>%s</gsx:date> <gsx:time>%s</gsx:time> <gsx:temp>%f</gsx:temp> <gsx:relhum>%f</gsx:relhum><gsx:location>%d</gsx:location><gsx:device>oregon</gsx:device></entry>",
dateStr, timeStr, s->getTemperature(), s->getHumidity(), s->getChannel());
4.) Post the data with the correct fields to the spreadsheet:
curl_easy_setopt(curl, CURLOPT_URL, "https://spreadsheets.google.com/feeds/list/YOURSPREADSHEETKEY/1/private/full");
curl_easy_setopt(curl, CURLOPT_POSTFIELDSIZE, strlen(postData));
curl_easy_setopt(curl, CURLOPT_POSTFIELDS, postData);
curl_easy_setopt(curl, CURLOPT_POST, true);
struct curl_slist *headerlist=NULL;
char authHeader[600];
sprintf(authHeader, "Authorization: GoogleLogin auth=%s", g_auth);
cout << "auth header " << authHeader << endl << flush;
headerlist = curl_slist_append(headerlist, authHeader);
headerlist = curl_slist_append(headerlist, "GData-Version: 3.0");
headerlist = curl_slist_append(headerlist, "Content-Type: application/atom+xml");
Full function code at https://github.com/arcanon/curlgooglespreadsheet/blob/master/googledocs-c.cpp
1.) create a google spreadsheet the normal way (with headings for each data item you want to save)
2.) get auth from google:
curl_easy_setopt(curl, CURLOPT_URL, "https://www.google.com/accounts/ClientLogin");
curl_easy_setopt(curl, CURLOPT_FOLLOWLOCATION, 1L);
curl_easy_setopt(curl, CURLOPT_POSTFIELDS, "Email=YOUREMAIL&Passwd=YOURPASSWORD&accountType=GOOGLE&source=cURL&service=writely");
3.) Form your data in the correct XML format:
sprintf(postData, "<entry xmlns='http://www.w3.org/2005/Atom' xmlns:gsx='http://schemas.google.com/spreadsheets/2006/extended'> <gsx:date>%s</gsx:date> <gsx:time>%s</gsx:time> <gsx:temp>%f</gsx:temp> <gsx:relhum>%f</gsx:relhum><gsx:location>%d</gsx:location><gsx:device>oregon</gsx:device></entry>",
dateStr, timeStr, s->getTemperature(), s->getHumidity(), s->getChannel());
4.) Post the data with the correct fields to the spreadsheet:
curl_easy_setopt(curl, CURLOPT_URL, "https://spreadsheets.google.com/feeds/list/YOURSPREADSHEETKEY/1/private/full");
curl_easy_setopt(curl, CURLOPT_POSTFIELDSIZE, strlen(postData));
curl_easy_setopt(curl, CURLOPT_POSTFIELDS, postData);
curl_easy_setopt(curl, CURLOPT_POST, true);
struct curl_slist *headerlist=NULL;
char authHeader[600];
sprintf(authHeader, "Authorization: GoogleLogin auth=%s", g_auth);
cout << "auth header " << authHeader << endl << flush;
headerlist = curl_slist_append(headerlist, authHeader);
headerlist = curl_slist_append(headerlist, "GData-Version: 3.0");
headerlist = curl_slist_append(headerlist, "Content-Type: application/atom+xml");
Full function code at https://github.com/arcanon/curlgooglespreadsheet/blob/master/googledocs-c.cpp
Monday, February 24, 2014
Modifying coova chilli to allow anonymous users for a private hotspot using automatic MAC addresses
So I spent a lot of time looking for a way to allow anonymous users to a coova chilli hotspot. Anonymous in the sense that a user can just click a button and get 30 min Internet access without having to type a password and what not. It made complete sense to use the MAC address as the users ID, but this only worked if you entered the MAC already. And NO where did I find that you could accept any new MAC address as a new user. Eventually I learnt enough about coova chilli to do this myself. The trick is to change the function dologin in the haserl script /etc/chilli/www/config-local.sh (use your password instead of XXXX) to
dologin() {
res="$(echo "select username from radcheck where username ='$REMOTE_MAC';" | mysql -u root -pXXXX radius)"
if [ "$res" = "" ]
then
echo "insert into radcheck (username, attribute, op, value) values ('$REMOTE_MAC', 'Cleartext-Password', ':=', 'password');" | mysql -u root -pXXXX radius
echo "insert into radusergroup (username, groupname) values ('$REMOTE_MAC', '30min');" | mysql -u root -pXXXX radius
fi
# url=$(chi_login_url "$FORM_username" "$FORM_password" "$FORM_userurl")
url=$(chi_login_url "$REMOTE_MAC" "password" "$FORM_userurl")
cat <<ENDHTML
<html><head>
<meta http-equiv="refresh" content="0;url=$url"/>
</head></html>
ENDHTML
wisprLoginResultsURL "$url"
}
Once you have done this, every time a new device logs into your web page, the script will check if the MAC address exists or not. If not it will require any username. I changed my login page to just be a button and made the other fields hidden, like so edit /etc/chilli/www/login_form.tmpl :
<!-- -- The login form --> <div id="login-form"> <table> <tr> <!-- <td>Usernamebb</td> --> <td><INPUT NAME="username" VALUE="user1" TYPE="hidden"></td> </tr> <tr> <!-- <td>Password</td> --> <td><INPUT NAME="password" VALUE="password" TYPE="hidden" TYPE="password"></td> </tr> <tr> <td colspan="2" nowrap align="center"> <input type="submit" name="button" value="Login & Accept Terms"> </td> </tr> </table> </div>
Subscribe to:
Posts (Atom)