PiPlanter | Basic package setup and bringing everything together

May 5, 2013 / 1 Comment

I’m in a hotel trying to occupy myself with something interesting so I’ve decided to work on this. I had to re-image the SD card I’ve been developing this project on, but I saved to code so there’s no problem there. Now I need to re-install all the basic packages.

First I need to get the components of a LAMP server with the following commands:

sudo apt-get install apache2
sudo apt-get install mysql-server
sudo apt-get install php5
sudo apt-get install php5-server
sudo apt-get install php5-mysql

sudo apt-get install apache2

sudo apt-get install mysql-server

sudo apt-get install php5

sudo apt-get install php5-server

sudo apt-get install php5-mysql

Once you get the mysql server setup, you’ll need to create a database and tables in mysql.

To create the database you’ll be using run the following command:

CREATE DATABASE piplanter;

1	CREATE DATABASE piplanter;

And then grant the proper privileges to use later with the command:

mysql&gt; mysql&gt; GRANT ALL PRIVILEGES ON piplanter.* TO 'user'@'localhost' IDENTIFIED BY 'pass';
FLUSH PRIVILEGES;

1 2	mysql> mysql> GRANT ALL PRIVILEGES ON piplanter.* TO 'user'@'localhost' IDENTIFIED BY 'pass'; FLUSH PRIVILEGES;

Then we can enter the database and create a table:

USE piplanter;
CREATE TABLE piplanter_table_01(Sample_Number INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Time VARCHAR(100), Temp_F VARCHAR(100), LDR_V VARCHAR(100) );

1 2	USE piplanter; CREATE TABLE piplanter_table_01(Sample_Number INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Time VARCHAR(100), Temp_F VARCHAR(100), LDR_V VARCHAR(100) );

Now we need to set up the specific libraries for python the first of which being spidev, the spi tool for the raspberry pi which we can grab from git using the following commands:

sudo apt-get install git
git clone git://github.com/doceme/py-spidev
cd py-spidev/
sudo apt-get install python-dev
sudo python setup.py install

sudo apt-get install git

git clone git://github.com/doceme/py-spidev

cd py-spidev/

sudo apt-get install python-dev

sudo python setup.py install

You also need to (copied from http://scruss.com/blog/2013/01/19/the-quite-rubbish-clock/):

As root, edit the kernel module blacklist file:

sudo vi /etc/modprobe.d/raspi-blacklist.conf

1	sudo vi /etc/modprobe.d/raspi-blacklist.conf

Comment out the spi-bcm2708 line so it looks like this:

#blacklist spi-bcm2708

1	#blacklist spi-bcm2708

Save the file so that the module will load on future reboots. To enable the module now, enter:

sudo modprobe spi-bcm2708

1	sudo modprobe spi-bcm2708

We will also need WiringPi:

sudo apt-get install python-imaging python-imaging-tk python-pip python-dev git
sudo pip install spidev
sudo pip install wiringpi

sudo apt-get install python-imaging python-imaging-tk python-pip python-dev git

sudo pip install spidev

sudo pip install wiringpi

Then you need to get APscheduler, the timing program used to execute the incremental timing with the following commands:

wget https://pypi.python.org/packages/source/A/APScheduler/APScheduler-2.1.0.tar.gz
sudo tar -xzvf APScheduler-2.1.0.tar.gz
python setup.py install

wget https://pypi.python.org/packages/source/A/APScheduler/APScheduler-2.1.0.tar.gz

sudo tar -xzvf APScheduler-2.1.0.tar.gz

python setup.py install

You will need mysqldb to interface python and mysql:

sudo apt-get install python-mysqldb

1	sudo apt-get install python-mysqldb

Once you reboot, the following program should work:

#Timing setup
from datetime import datetime
from apscheduler.scheduler import Scheduler
import time
import datetime
import sys

now =datetime.datetime.now()

import logging #if you start getting logging errors, uncomment these two lines
logging.basicConfig()

#GPIO setup
import RPi.GPIO as GPIO
GPIO.setmode(GPIO.BOARD)

GPIO.cleanup()

pin = 26 #pin for the adc
GPIO.setup(pin, GPIO.OUT)
led1 = 11 #pin for the short indicator led
GPIO.setup(led1, GPIO.OUT)
led2 = 13 #pin for other long indicator led
GPIO.setup(led2, GPIO.OUT)

#the adc's SPI setup
import spidev
spi = spidev.SpiDev()
spi.open(0, 0)

import MySQLdb
con = MySQLdb.connect('localhost','piplanter_user','piplanter_pass','piplanter');
cursor = con.cursor()

#fuction that can read the adc
def readadc(adcnum): 
# read SPI data from MCP3008 chip, 8 possible adc's (0 thru 7)
    if adcnum > 7 or adcnum < 0:
        return -1
    r = spi.xfer2([1, 8 + adcnum << 4, 0])
    adcout = ((r[1] & 3) << 8) + r[2]
    return adcout
    
def rapidSample():	
	sampleTime = time.ctime()
	sampleTemp1 = (((readadc(0)*3.3)/1024)/(10.0/1000)) #this translates the analog voltage to temperature in def F
	sampleLght1 = readadc(1)
	samplePot1 = readadc(2)
	
	GPIO.output(led1, True) #turns the led on
	time.sleep(.1) #sleeps a little bit so you can see the LED on
	print "Job 1", sampleTime,"LDR:",sampleLght1 ,"Pot:",samplePot1,"Temp:",sampleTemp1 #prints the debug info
	
	cursor.execute("INSERT INTO piplanter_table_02(Time,Temp_F,LDR_V) VALUES(%s,'%s','%s')",(sampleTime,sampleTemp1,sampleLght1))
	con.commit() #this is important for live updating
	
	time.sleep(.1)
	GPIO.output(led1, False) #turns the led off
	
def slowSample():
	sampleTime = time.ctime()
	sampleTemp1 = (((readadc(0)*3.3)/1024)/(10.0/1000)) #this translates the analog voltage to temperature in def F
	sampleLght1 = readadc(1)
	samplePot1 = readadc(2)
	
	GPIO.output(led2, True) #turns the led on
	time.sleep(5)
	
	print "Job 2", sampleTime,"LDR:",sampleLght1 ,"Pot:",samplePot1,"Temp:",sampleTemp1 #prints the debug info
	cursor.execute("INSERT INTO piplanter_table_03(Time,Temp_F,LDR_V) VALUES(%s,'%s','%s')",(sampleTime,sampleTemp1,sampleLght1))
	con.commit() #this is important for live updating
	
	time.sleep(5)
	GPIO.output(led2, False) #turns the led on
	
	
if __name__ == '__main__':
	#the following 3 lines start up the interval job and keep it going
    scheduler = Scheduler(standalone=True)
    scheduler.add_interval_job(rapidSample, minutes=1)
    scheduler.add_interval_job(slowSample, hours=1)
    scheduler.start()

#Timing setup

from datetime import datetime

from apscheduler.scheduler import Scheduler

import time

import datetime

import sys

now =datetime.datetime.now()

import logging #if you start getting logging errors, uncomment these two lines

logging.basicConfig()

#GPIO setup

import RPi.GPIO as GPIO

GPIO.setmode(GPIO.BOARD)

GPIO.cleanup()

pin = 26 #pin for the adc

GPIO.setup(pin, GPIO.OUT)

led1 = 11 #pin for the short indicator led

GPIO.setup(led1, GPIO.OUT)

led2 = 13 #pin for other long indicator led

GPIO.setup(led2, GPIO.OUT)

#the adc's SPI setup

import spidev

spi = spidev.SpiDev()

spi.open(0, 0)

import MySQLdb

con = MySQLdb.connect('localhost','piplanter_user','piplanter_pass','piplanter');

cursor = con.cursor()

#fuction that can read the adc

def readadc(adcnum):

# read SPI data from MCP3008 chip, 8 possible adc's (0 thru 7)

if adcnum > 7 or adcnum < 0:

return -1

r = spi.xfer2([1, 8 + adcnum << 4, 0])

adcout = ((r[1] & 3) << 8) + r[2]

return adcout

def rapidSample():

sampleTime = time.ctime()

sampleTemp1 = (((readadc(0)*3.3)/1024)/(10.0/1000)) #this translates the analog voltage to temperature in def F

sampleLght1 = readadc(1)

samplePot1 = readadc(2)

GPIO.output(led1, True) #turns the led on

time.sleep(.1) #sleeps a little bit so you can see the LED on

print "Job 1", sampleTime,"LDR:",sampleLght1 ,"Pot:",samplePot1,"Temp:",sampleTemp1 #prints the debug info

cursor.execute("INSERT INTO piplanter_table_02(Time,Temp_F,LDR_V) VALUES(%s,'%s','%s')",(sampleTime,sampleTemp1,sampleLght1))

con.commit() #this is important for live updating

time.sleep(.1)

GPIO.output(led1, False) #turns the led off

def slowSample():

sampleTime = time.ctime()

sampleTemp1 = (((readadc(0)*3.3)/1024)/(10.0/1000)) #this translates the analog voltage to temperature in def F

sampleLght1 = readadc(1)

samplePot1 = readadc(2)

GPIO.output(led2, True) #turns the led on

time.sleep(5)

print "Job 2", sampleTime,"LDR:",sampleLght1 ,"Pot:",samplePot1,"Temp:",sampleTemp1 #prints the debug info

cursor.execute("INSERT INTO piplanter_table_03(Time,Temp_F,LDR_V) VALUES(%s,'%s','%s')",(sampleTime,sampleTemp1,sampleLght1))

con.commit() #this is important for live updating

time.sleep(5)

GPIO.output(led2, False) #turns the led on

if __name__ == '__main__':

#the following 3 lines start up the interval job and keep it going

scheduler = Scheduler(standalone=True)

scheduler.add_interval_job(rapidSample, minutes=1)

scheduler.add_interval_job(slowSample, hours=1)

scheduler.start()

And there you go! The program should log data every minute and then every hour to two different tables. To view those data sets as php tables you can use this php script:

&lt;?php
mysql_connect("localhost", "piplanter_user","piplanter_pass") or die ("Could not connect: " . mysql_error());
mysql_select_db("piplanter");

$result = mysql_query("SELECT * FROM piplanter_table_02");

echo "&lt;table border='1'&gt;
&lt;tr&gt;
&lt;th&gt;Sample_Number&lt;/th&gt;
&lt;th&gt;Time&lt;/th&gt;
&lt;th&gt;Temp F&lt;/th&gt;
&lt;th&gt;LDR Value V&lt;/th&gt;
&lt;/tr&gt;";

while($row = mysql_fetch_array($result)){
	echo"&lt;tr&gt;";
	echo"&lt;td&gt;" . $row['Sample_Number'] . "&lt;/td&gt;";
	echo"&lt;td&gt;" . $row['Time'] . "&lt;/td&gt;";
	echo"&lt;td&gt;" . $row['Temp_F'] . "&lt;/td&gt;";
	echo"&lt;td&gt;" . $row['LDR_V'] . "&lt;/td&gt;";
	echo"&lt;/tr&gt;";
}

echo "&lt;/table&gt;";
mysql_close($con);
?&gt;

<?php

mysql_connect("localhost", "piplanter_user","piplanter_pass") or die ("Could not connect: " . mysql_error());

mysql_select_db("piplanter");

$result = mysql_query("SELECT * FROM piplanter_table_02");

echo "<table border='1'>

<tr>

<th>Sample_Number</th>

<th>LDR Value V</th>

</tr>";

while($row = mysql_fetch_array($result)){

echo"<tr>";

echo"<td>" . $row['Sample_Number'] . "</td>";

echo"<td>" . $row['Time'] . "</td>";

echo"<td>" . $row['Temp_F'] . "</td>";

echo"<td>" . $row['LDR_V'] . "</td>";

echo"</tr>";

}

echo "</table>";

mysql_close($con);

Sometime later I’ll get to graphing the data.

PiPlanter | Using APScheduler to get timed samples in python

April 28, 2013 / Leave a comment

I’m taking a “break” from my drone while I save some money to buy more tricopter parts, and since the weather’s getting nicer and nicer I’ve decided to start working on my PiPlanter again.

As a refresher, the PiPlanter is a Raspberry Pi powered garden. The goal is for it to just be able to be plugged in and add water to a water source and have the Pi monitor temp and moisture levels to be able to add more water as needed.

I’ve shown that is relatively easy to go from analog sensors to good looking tables and graphs using the raspberry pi, the problem that I ran into however was timing.

It became harder and harder to use the time.sleep function in python to handle long periods of time. When you are dealing with things like plants, you don’t need to water it very often, but for data’s sake, you should be polling the sensors a lot.

I’ve landed on the use of APScheduler in python, and here’s my source code:

[py]
#Timing setup
from datetime import datetime
from apscheduler.scheduler import Scheduler
import time

import logging #if you start getting logging errors, uncomment these two lines
logging.basicConfig()

#GPIO setup
import RPi.GPIO as GPIO
GPIO.setmode(GPIO.BOARD)

GPIO.cleanup()

pin = 26 #pin for the adc
GPIO.setup(pin, GPIO.OUT)
led1 = 11 #pin for the short indicator led
GPIO.setup(led1, GPIO.OUT)
led2 = 13 #pin for other long indicator led
GPIO.setup(led2, GPIO.OUT)

#the adc’s SPI setup
import spidev
spi = spidev.SpiDev()
spi.open(0, 0)

going = True

#fuction that can read the adc
def readadc(adcnum):
# read SPI data from MCP3008 chip, 8 possible adc’s (0 thru 7)
if adcnum > 7 or adcnum < 0:
return -1
r = spi.xfer2([1, 8 + adcnum << 4, 0])
adcout = ((r[1] & 3) << 8) + r[2]
return adcout

def rapidSample():
sampleTemp1 = (((readadc(0)*3.3)/1024)/(10.0/1000)) #this translates the analog voltage to temperature in def F
sampleLght1 = readadc(1)
samplePot1 = readadc(2)

GPIO.output(led1, True) #turns the led on
time.sleep(.1) #sleeps a little bit so you can see the LED on
print “Job 1″, datetime.now(),”LDR:”,sampleLght1 ,”Pot:”,samplePot1,”Temp:”,sampleTemp1 #prints the debug info
time.sleep(.1)
GPIO.output(led1, False) #turns the led off

def slowSample():
print “Job 2” , datetime.now()
GPIO.output(led2, True) #turns the led on
time.sleep(5)
GPIO.output(led2, False) #turns the led on

if __name__ == ‘__main__’:
#the following 3 lines start up the interval job and keep it going
scheduler = Scheduler(standalone=True)
scheduler.add_interval_job(rapidSample, seconds=1)
scheduler.add_interval_job(slowSample, minutes=1)
scheduler.start()
[/py]

This produces a loop that flashed a green led on and of for .1 seconds at a time per second, and then every minute, turns on a speaker and a red led for 5 seconds then turns it off. There are some images of what goes on below.

Here is a picture of the the print dialog in python:

You can see that the first job (green led) posts the values from the analog sensors every second

The second job (red led) just posts the time. But the function is expandable to do anything at any time.

Here are pictures of the board and the circuit in action:

Both LED’s off

The Green LED on, the red circled process in the printout

Here are both on

The next step is adding the mySQL in as seen in some other posts.

PiPlanter | Going from analog data to the web using python, mysql and php

February 17, 2013 / Leave a comment

Here’s a video:

Essentially, the adc reads an analog value and sends it to python. Python connects to a mysql database and adds the data to that. Once the user accesses the php script, a table, containing all of the values, is rendered.

First of all, you’ll need to make a mysql table with the correct specifications:

CREATE TABLE adc_input_data_10(Sample_Number INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Time VARCHAR(100), Channel_1 VARCHAR(100), Channel_2 VARCHAR(100), Channel_3 VARCHAR(100) );

1	CREATE TABLE adc_input_data_10(Sample_Number INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Time VARCHAR(100), Channel_1 VARCHAR(100), Channel_2 VARCHAR(100), Channel_3 VARCHAR(100) );

This creates a table that is found in the python script so it is very important that the TABLE values match as well as the column names.

Here’s that python script:

#!/usr/bin/env python
# -*- coding: utf-8 -*-
import spidev
import time
import MySQLdb
import sys
import RPi.GPIO as GPIO
import datetime

now = datetime.datetime.now()

pin = 26

GPIO.setmode(GPIO.BOARD)
GPIO.setup(pin, GPIO.OUT)

con = MySQLdb.connect('localhost','adc_user','adc_user_pass','adc_database');
cursor = con.cursor()

spi = spidev.SpiDev()
spi.open(0, 0)
maxcyclenumber = 10

count = 0

def readadc(adcnum):
# read SPI data from MCP3008 chip, 8 possible adc's (0 thru 7)
    if adcnum > 7 or adcnum < 0:
        return -1
    r = spi.xfer2([1, 8 + adcnum << 4, 0])
    adcout = ((r[1] & 3) << 8) + r[2]
    return adcout

for _ in range(maxcyclenumber):
	cursor.execute("INSERT INTO adc_input_data_10(Time,Channel_1,Channel_2,Channel_3) VALUES(%s,'%s','%s','%s')",(datetime.datetime.now().strftime('%b-%d-%I%M%p-%G'),readadc(0),readadc(1),readadc(2)) )
	con.commit() #this is important for live updating
	count = count+1
	print count
	time.sleep (1)

if count == maxcyclenumber:
	GPIO.cleanup()
	con.close()</pre>

#!/usr/bin/env python

# -*- coding: utf-8 -*-

import spidev

import time

import MySQLdb

import sys

import RPi.GPIO as GPIO

import datetime

now = datetime.datetime.now()

pin = 26

GPIO.setmode(GPIO.BOARD)

GPIO.setup(pin, GPIO.OUT)

con = MySQLdb.connect('localhost','adc_user','adc_user_pass','adc_database');

cursor = con.cursor()

spi = spidev.SpiDev()

spi.open(0, 0)

maxcyclenumber = 10

count = 0

def readadc(adcnum):

# read SPI data from MCP3008 chip, 8 possible adc's (0 thru 7)

if adcnum > 7 or adcnum < 0:

return -1

r = spi.xfer2([1, 8 + adcnum << 4, 0])

adcout = ((r[1] & 3) << 8) + r[2]

return adcout

for _ in range(maxcyclenumber):

cursor.execute("INSERT INTO adc_input_data_10(Time,Channel_1,Channel_2,Channel_3) VALUES(%s,'%s','%s','%s')",(datetime.datetime.now().strftime('%b-%d-%I%M%p-%G'),readadc(0),readadc(1),readadc(2)) )

con.commit() #this is important for live updating

count = count+1

print count

time.sleep (1)

if count == maxcyclenumber:

GPIO.cleanup()

con.close()</pre>

This reads the values from the adc (it is wired up as seen in this post)

Here’s the php, it reads the values from the adc_input_data_10 table on the adc_database.

&lt;?php
mysql_connect("localhost", "adc_user","adc_user_pass") or die ("Could not connect: " . mysql_error());
mysql_select_db("adc_database");

$result = mysql_query("SELECT * FROM adc_input_data_10");

echo "&lt;table border='1'&gt;
&lt;tr&gt;
&lt;th&gt;Sample Number&lt;/th&gt;
&lt;th&gt;Time&lt;/th&gt;
&lt;th&gt;Channel 1&lt;/th&gt;
&lt;th&gt;Channel 2&lt;/th&gt;
&lt;th&gt;Channel 3&lt;/th&gt;
&lt;/tr&gt;";

while($row = mysql_fetch_array($result)){
	echo"&lt;tr&gt;";
	echo"&lt;td&gt;" . $row['Sample_Number'] . "&lt;/td&gt;";
	echo"&lt;td&gt;" . $row['Time'] . "&lt;/td&gt;";
	echo"&lt;td&gt;" . $row['Channel_1'] . "&lt;/td&gt;";
	echo"&lt;td&gt;" . $row['Channel_2'] . "&lt;/td&gt;";
	echo"&lt;td&gt;" . $row['Channel_3'] . "&lt;/td&gt;";
	echo"&lt;/tr&gt;";
}

echo "&lt;/table&gt;";
mysql_close($con);
?&gt;

<?php

mysql_connect("localhost", "adc_user","adc_user_pass") or die ("Could not connect: " . mysql_error());

mysql_select_db("adc_database");

$result = mysql_query("SELECT * FROM adc_input_data_10");

echo "<table border='1'>

<tr>

<th>Sample Number</th>

<th>Channel 1</th>

<th>Channel 2</th>

<th>Channel 3</th>

</tr>";

while($row = mysql_fetch_array($result)){

echo"<tr>";

echo"<td>" . $row['Sample_Number'] . "</td>";

echo"<td>" . $row['Time'] . "</td>";

echo"<td>" . $row['Channel_1'] . "</td>";

echo"<td>" . $row['Channel_2'] . "</td>";

echo"<td>" . $row['Channel_3'] . "</td>";

echo"</tr>";

}

echo "</table>";

mysql_close($con);

This is all very preliminary stuff, and I’ll tighten up the code as time goes on.

PiPlanter | Graphing With PHP 2

February 16, 2013 / Leave a comment

This is a much more refined version of that graph I created earlier.

This one is much more detailed, and the sizes of the graph can easily be controlled with the imageSizeX and Y Vals.

This program will render:

&lt;?php
/* CAT:Scaling */

/* pChart library inclusions */
include("/srv/www/lib/pChart/class/pData.class.php");
include("/srv/www/lib/pChart/class/pDraw.class.php");
include("/srv/www/lib/pChart/class/pImage.class.php");

$imageSizeXXal = 1000;
$imageSizeYVal = 600;

/* Create and populate the pData object */
$MyData = new pData();
$MyData-&gt;addPoints(array(17,19,4,1,2,6,7,3,4,4,8,2),"Pressure");
$MyData-&gt;setSerieDrawable("Pressure",FALSE);
$MyData-&gt;setAxisName(0,"Temperatures");

$MyData-&gt;addPoints(array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"),"Labels");
$MyData-&gt;setSerieDescription("Labels","Months");
$MyData-&gt;setAbscissa("Labels");

/* Create the pChart object */
$myPicture = new pImage($imageSizeXXal,$imageSizeYVal,$MyData); //size of the graph box

/* Draw the background */
$Settings = array("R"=&gt;84, "G"=&gt;84, "B"=&gt;84, "Dash"=&gt;1, "DashR"=&gt;95, "DashG"=&gt;95, "DashB"=&gt;95);
$myPicture-&gt;drawFilledRectangle(0,0,$imageSizeXXal+5,$imageSizeYVal,$Settings); //size of the grey background

/* Write the picture title */
$myPicture-&gt;setFontProperties(array("FontName"=&gt;"/srv/www/lib/pChart/fonts/Silkscreen.ttf","FontSize"=&gt;6));
$myPicture-&gt;drawText(10,13,"Upper Text 1",array("R"=&gt;255,"G"=&gt;255,"B"=&gt;255));

/* Write the chart title */
$myPicture-&gt;setFontProperties(array("FontName"=&gt;"/srv/www/lib/pChart/fonts/Forgotte.ttf","FontSize"=&gt;11));
$myPicture-&gt;drawText($imageSizeXXal/2,30,"Chart Title",array("FontSize"=&gt;20,"Align"=&gt;TEXT_ALIGN_BOTTOMMIDDLE));

/* Define the 2nd chart area */
$myPicture-&gt;setGraphArea(40,40,$imageSizeXXal-35,$imageSizeYVal-25); //top left, then bottom right conrner of box
$myPicture-&gt;setFontProperties(array("FontName"=&gt;"/srv/www/lib/pChart/fonts/pf_arma_five.ttf","FontSize"=&gt;6));

/* Draw the scale */
$scaleSettings = array("DrawSubTicks"=&gt;TRUE,"CycleBackground"=&gt;TRUE);
$MyData-&gt;setSerieDrawable("Temperature",FALSE);
$MyData-&gt;setSerieDrawable("Pressure",TRUE);
$MyData-&gt;setAxisName(0,"Pressure");
$myPicture-&gt;drawScale($scaleSettings);
$myPicture-&gt;drawPlotChart();

/* Render the picture (choose the best way) */
$myPicture-&gt;autoOutput();
?&gt;

<?php

/* CAT:Scaling */

/* pChart library inclusions */

include("/srv/www/lib/pChart/class/pData.class.php");

include("/srv/www/lib/pChart/class/pDraw.class.php");

include("/srv/www/lib/pChart/class/pImage.class.php");

$imageSizeXXal = 1000;

$imageSizeYVal = 600;

/* Create and populate the pData object */

$MyData = new pData();

$MyData->addPoints(array(17,19,4,1,2,6,7,3,4,4,8,2),"Pressure");

$MyData->setSerieDrawable("Pressure",FALSE);

$MyData->setAxisName(0,"Temperatures");

$MyData->addPoints(array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"),"Labels");

$MyData->setSerieDescription("Labels","Months");

$MyData->setAbscissa("Labels");

/* Create the pChart object */

$myPicture = new pImage($imageSizeXXal,$imageSizeYVal,$MyData); //size of the graph box

/* Draw the background */

$Settings = array("R"=>84, "G"=>84, "B"=>84, "Dash"=>1, "DashR"=>95, "DashG"=>95, "DashB"=>95);

$myPicture->drawFilledRectangle(0,0,$imageSizeXXal+5,$imageSizeYVal,$Settings); //size of the grey background

/* Write the picture title */

$myPicture->setFontProperties(array("FontName"=>"/srv/www/lib/pChart/fonts/Silkscreen.ttf","FontSize"=>6));

$myPicture->drawText(10,13,"Upper Text 1",array("R"=>255,"G"=>255,"B"=>255));

/* Write the chart title */

$myPicture->setFontProperties(array("FontName"=>"/srv/www/lib/pChart/fonts/Forgotte.ttf","FontSize"=>11));

$myPicture->drawText($imageSizeXXal/2,30,"Chart Title",array("FontSize"=>20,"Align"=>TEXT_ALIGN_BOTTOMMIDDLE));

/* Define the 2nd chart area */

$myPicture->setGraphArea(40,40,$imageSizeXXal-35,$imageSizeYVal-25); //top left, then bottom right conrner of box

$myPicture->setFontProperties(array("FontName"=>"/srv/www/lib/pChart/fonts/pf_arma_five.ttf","FontSize"=>6));

/* Draw the scale */

$scaleSettings = array("DrawSubTicks"=>TRUE,"CycleBackground"=>TRUE);

$MyData->setSerieDrawable("Temperature",FALSE);

$MyData->setSerieDrawable("Pressure",TRUE);

$MyData->setAxisName(0,"Pressure");

$myPicture->drawScale($scaleSettings);

$myPicture->drawPlotChart();

/* Render the picture (choose the best way) */

$myPicture->autoOutput();

This image:

And by modifying the values mentioned above to:

$imageSizeXXal = 1500;
$imageSizeYVal = 400;

1 2	$imageSizeXXal = 1500; $imageSizeYVal = 400;

You will get this image:

PiPlanter | Graphing With PHP

February 12, 2013 / Leave a comment

Again, short post. This php code:

&lt;?php
session_start();
require_once "/srv/www/lib/pChart/class/pDraw.class.php";
require_once "/srv/www/lib/pChart/class/pImage.class.php";
require_once "/srv/www/lib/pChart/class/pData.class.php";

$squareSeries = array();
$cubeSeries = array();
$fourthSeries = array();

for ($i = 0; $i &lt;= 4; $i++){ 	$squareSeries[$i] = pow($i,2); 	$cubeSeries[$i] = pow($i,3); 	$fourthSeries[$i] = pow($i, 4); } $myPowersData = new pData(); $myPowersData -&gt; addPoints($squareSeries,"Square");
$myPowersData -&gt; addPoints($cubeSeries,"Cube");
$myPowersData -&gt; addPoints($fourthSeries,"Fourth");

$myPowersData-&gt; setPalette("Square",
	array("R" =&gt; 240, "G" =&gt; 16, "B" =&gt; 16, "Alpha" =&gt; 100));
$myPowersData-&gt; setPalette("Cube",
	array("R" =&gt; 16, "G" =&gt; 240, "B" =&gt; 16, "Alpha" =&gt; 100));
$myPowersData-&gt; setPalette("Forth",
	array("R" =&gt; 16, "G" =&gt; 16, "B" =&gt; 240, "Alpha" =&gt; 100));

$myPowersImage = new pImage(500,300, $myPowersData);
$myPowersImage -&gt; setFontProperties(array(
	"FontName" =&gt; "/srv/www/lib/pChart/fonts/verdana.ttf",
	"FontSize" =&gt; 12));

$myPowersImage-&gt;setGraphArea(40,40, 460,260);
$myPowersImage-&gt;drawScale();

$myPowersImage-&gt;drawLineChart();
header("Content-Type: image/png");
$myPowersImage-&gt;Render(null);

<?php

session_start();

require_once "/srv/www/lib/pChart/class/pDraw.class.php";

require_once "/srv/www/lib/pChart/class/pImage.class.php";

require_once "/srv/www/lib/pChart/class/pData.class.php";

$squareSeries = array();

$cubeSeries = array();

$fourthSeries = array();

for ($i = 0; $i <= 4; $i++){ $squareSeries[$i] = pow($i,2); $cubeSeries[$i] = pow($i,3); $fourthSeries[$i] = pow($i, 4); } $myPowersData = new pData(); $myPowersData -> addPoints($squareSeries,"Square");

$myPowersData -> addPoints($cubeSeries,"Cube");

$myPowersData -> addPoints($fourthSeries,"Fourth");

$myPowersData-> setPalette("Square",

array("R" => 240, "G" => 16, "B" => 16, "Alpha" => 100));

$myPowersData-> setPalette("Cube",

array("R" => 16, "G" => 240, "B" => 16, "Alpha" => 100));

$myPowersData-> setPalette("Forth",

array("R" => 16, "G" => 16, "B" => 240, "Alpha" => 100));

$myPowersImage = new pImage(500,300, $myPowersData);

$myPowersImage -> setFontProperties(array(

"FontName" => "/srv/www/lib/pChart/fonts/verdana.ttf",

"FontSize" => 12));

$myPowersImage->setGraphArea(40,40, 460,260);

$myPowersImage->drawScale();

$myPowersImage->drawLineChart();

header("Content-Type: image/png");

$myPowersImage->Render(null);

will produce this graph:

I learned this using this resource:

http://phpmaster.com/charting-with-pchart/

PiPlanter | Interfacing an ADC, Python, and MySQL [Documentation]

February 12, 2013 / 2 Comments

As this post is more of an update, I won’t be adding any explanations, just giving the python code.

This will read 3 values from the adc and put them into the database “adc_database”. It will put them in the table “adc_input_data_4” in the columns “Channel_1″,”Channel_2” and “Channel_3” respectively.

#!/usr/bin/env python
# -*- coding: utf-8 -*-
import spidev
import time
import MySQLdb
import sys
import RPi.GPIO as GPIO

pin = 26

GPIO.setmode(GPIO.BOARD)
GPIO.setup(pin, GPIO.OUT)

con = MySQLdb.connect('localhost','adc_user','adc_user_pass','adc_database');
cursor = con.cursor()

spi = spidev.SpiDev()
spi.open(0, 0)
count = 0
maxcyclenumber = 5

tmp = "derp"

def readadc(adcnum):
# read SPI data from MCP3008 chip, 8 possible adc's (0 thru 7)
    if adcnum > 7 or adcnum < 0:
        return -1
    r = spi.xfer2([1, 8 + adcnum << 4, 0])
    adcout = ((r[1] & 3) << 8) + r[2]
    return adcout
    

for _ in range(maxcyclenumber):
	
	GPIO.output(pin,True)
	cursor.execute("INSERT INTO adc_input_data_4(Channel_1,Channel_2,Channel_3) VALUES('%s','%s','%s')",(readadc(0),readadc(1),readadc(2)) )
	GPIO.output(pin,False)
	
	count = count+1
	print count
	time.sleep (1)
	
if count == maxcyclenumber:
	GPIO.cleanup()
	con.commit()
	con.close()

#!/usr/bin/env python

# -*- coding: utf-8 -*-

import spidev

import time

import MySQLdb

import sys

import RPi.GPIO as GPIO

pin = 26

GPIO.setmode(GPIO.BOARD)

GPIO.setup(pin, GPIO.OUT)

con = MySQLdb.connect('localhost','adc_user','adc_user_pass','adc_database');

cursor = con.cursor()

spi = spidev.SpiDev()

spi.open(0, 0)

count = 0

maxcyclenumber = 5

tmp = "derp"

def readadc(adcnum):

# read SPI data from MCP3008 chip, 8 possible adc's (0 thru 7)

if adcnum > 7 or adcnum < 0:

return -1

r = spi.xfer2([1, 8 + adcnum << 4, 0])

adcout = ((r[1] & 3) << 8) + r[2]

return adcout

for _ in range(maxcyclenumber):

GPIO.output(pin,True)

cursor.execute("INSERT INTO adc_input_data_4(Channel_1,Channel_2,Channel_3) VALUES('%s','%s','%s')",(readadc(0),readadc(1),readadc(2)) )

GPIO.output(pin,False)

count = count+1

print count

time.sleep (1)

if count == maxcyclenumber:

GPIO.cleanup()

con.commit()

con.close()

There you go, bigger post coming later tonight.

Raspberry Pi Media Server | Mounting Hard Drive & Better Minidlna Config

December 30, 2012 / Leave a comment

Please note that this is more for my sake. To mount a hard drive in raspbian do the following: Make sure you have ntfs-3g installed by running:

sudo apt-get install ntfs-3g

1	sudo apt-get install ntfs-3g

Then mount the drive read/write with the following command:

sudo mkdir /media/USBHDD
sudo mount -t ntfs-3g /dev/sda1/ /media/USBHDD/

1 2	sudo mkdir /media/USBHDD sudo mount -t ntfs-3g /dev/sda1/ /media/USBHDD/

And it shout be mounted. /dev/sda1 is the location of your hard drive. Now to configuring minidlna. Location of minidlna.conf file and access command:

sudo vi /etc/minidlna.conf

1	sudo vi /etc/minidlna.conf

This is the file I’m running right now. As I type this i’m successfully streaming to my Kindle Fire HD (the reason why I’ve decided to really make this thing work) but I’m not sure if it’s stable. It’s also able to stream to VLC as of now.

Raspberry Pi Media Server | Moving Backwards to go Forwards

December 29, 2012 / Leave a comment

It’s time to face facts, minidlna and XBMC won’t run at the same time in Raspbmc. The basic UPNP included in Raspbmc won’t work consistently and Raspmc and is not nearly as stable as minidlna. OpenELEC is fast enough, but does not have the expandability of a full linux OS. I need to restart this project.

First thing’s first I’m going to straight up speed this thing up as much as I can. At the base level, this begins with the SD card. I’m going to go from a junk 4gb standard speed SD card to a 8gb SanDisk Ultra 30mb/s SDHC. On this I’m going to install the latest version of Raspian and overclock it to the maximum 1GHz.

I’ll keep you posted on how I progress.

Raspberry Pi Media Server | Speeding Up Raspberry Pi [Documentation]

December 14, 2012 / Leave a comment

So although I haven’t written about it yet, right now I’ve gotten a Raspbmc Server up and running along with Minidlna. It works great for about an hour at a time and then it really bogs down. This seems to be caused by a combination of Raspbmc and the hard drive spinning down. My solution is to try OpenELEC, overclock the Raspberry Pi, and change out the SD card for one with a faster read/write speed.

Basic Wetness Sensor

November 22, 2012 / 1 Comment

So I’ve had the idea for a while to try and automate the growing of plants so I need to be able to tell if something’s wet or not. Here’s a video:

Basically the hookup process is that of a regular analog sensor with this in it’s place. There’s a 10k pullup resistor as the voltage divider.

Here’s the source for the Arduino.

int write1;
int writeval;

void setup(){
 Serial.begin(9600);
 pinMode(3, OUTPUT);
}

void loop(){
 Serial.println(analogRead(0));
 write1 = map(analogRead(0), 0, 1023, 0, 100);
 writeval = map(write1, 0, 100, 0, 1023);
 analogWrite(3, writeval);
 delay(100);
}