PiPlanter | Basic package setup and bringing everything together

<p>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.</p> <p>First I need to get the components of a LAMP server with the following commands:</p> <div id="crayon-5706ba7027699753579351" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"><span class="crayon-language">Shell</span></div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba7027699753579351-1">1</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba7027699753579351-2">2</div> <div class="crayon-num" data-line="crayon-5706ba7027699753579351-3">3</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba7027699753579351-4">4</div> <div class="crayon-num" data-line="crayon-5706ba7027699753579351-5">5</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba7027699753579351-1" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-v">apt</span><span class="crayon-o">–</span><span class="crayon-r">get</span> <span class="crayon-e">install</span> <span class="crayon-e">apache2</span></div> <div id="crayon-5706ba7027699753579351-2" class="crayon-line crayon-striped-line"><span class="crayon-e">sudo</span> <span class="crayon-v">apt</span><span class="crayon-o">–</span><span class="crayon-r">get</span> <span class="crayon-e">install</span> <span class="crayon-v">mysql</span><span class="crayon-o">–</span><span class="crayon-e">server</span></div> <div id="crayon-5706ba7027699753579351-3" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-v">apt</span><span class="crayon-o">–</span><span class="crayon-r">get</span> <span class="crayon-e">install</span> <span class="crayon-e">php5</span></div> <div id="crayon-5706ba7027699753579351-4" class="crayon-line crayon-striped-line"><span class="crayon-e">sudo</span> <span class="crayon-v">apt</span><span class="crayon-o">–</span><span class="crayon-r">get</span> <span class="crayon-e">install</span> <span class="crayon-v">php5</span><span class="crayon-o">–</span><span class="crayon-e">server</span></div> <div id="crayon-5706ba7027699753579351-5" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-v">apt</span><span class="crayon-o">–</span><span class="crayon-r">get</span> <span class="crayon-e">install</span> <span class="crayon-v">php5</span><span class="crayon-o">–</span><span class="crayon-v">mysql</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>Once you get the mysql server setup, you’ll need to create a database and tables in mysql.</p> <p>To create the database you’ll be using run the following command:</p> <div id="crayon-5706ba70276c1572798143" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-nums-button crayon-pressed" title="Toggle Line Numbers"></div> <p><span class="crayon-language">Shell</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba70276c1572798143-1">1</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba70276c1572798143-1" class="crayon-line"><span class="crayon-e">CREATE</span> <span class="crayon-e">DATABASE</span> <span class="crayon-v">piplanter</span><span class="crayon-sy">;</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>And then grant the proper privileges to use later with the command:</p> <div id="crayon-5706ba70276e1372992774" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-nums-button crayon-pressed" title="Toggle Line Numbers"></div> <div class="crayon-button crayon-popup-button" title="Open Code In New Window"></div> <p><span class="crayon-language">Shell</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba70276e1372992774-1">1</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70276e1372992774-2">2</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba70276e1372992774-1" class="crayon-line"><span class="crayon-v">mysql</span><span class="crayon-o">></span> <span class="crayon-v">mysql</span><span class="crayon-o">></span> <span class="crayon-e">GRANT</span> <span class="crayon-e">ALL</span> <span class="crayon-e">PRIVILEGES</span> <span class="crayon-e">ON</span> <span class="crayon-v">piplanter</span><span class="crayon-sy">.</span><span class="crayon-o">*</span> <span class="crayon-st">TO</span> <span class="crayon-s">‘user’</span><span class="crayon-sy">@</span><span class="crayon-s">‘localhost’</span> <span class="crayon-e">IDENTIFIED</span> <span class="crayon-i">BY</span> <span class="crayon-s">‘pass’</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70276e1372992774-2" class="crayon-line crayon-striped-line"><span class="crayon-e">FLUSH</span> <span class="crayon-v">PRIVILEGES</span><span class="crayon-sy">;</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>Then we can enter the database and create a table:</p> <div id="crayon-5706ba70276fe909198342" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-nums-button crayon-pressed" title="Toggle Line Numbers"></div> <div class="crayon-button crayon-popup-button" title="Open Code In New Window"></div> <p><span class="crayon-language">Shell</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba70276fe909198342-1">1</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70276fe909198342-2">2</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba70276fe909198342-1" class="crayon-line"><span class="crayon-st">USE</span> <span class="crayon-v">piplanter</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70276fe909198342-2" class="crayon-line crayon-striped-line"><span class="crayon-e">CREATE</span> <span class="crayon-e">TABLE</span> <span class="crayon-e">piplanter_table_01</span><span class="crayon-sy">(</span><span class="crayon-e">Sample_Number</span> <span class="crayon-t">INT</span> <span class="crayon-st">NOT</span> <span class="crayon-t">NULL</span> <span class="crayon-e">AUTO_INCREMENT</span> <span class="crayon-e">PRIMARY</span> <span class="crayon-v">KEY</span><span class="crayon-sy">,</span> <span class="crayon-r">Time</span> <span class="crayon-e">VARCHAR</span><span class="crayon-sy">(</span><span class="crayon-cn">100</span><span class="crayon-sy">)</span><span class="crayon-sy">,</span> <span class="crayon-e">Temp_F</span> <span class="crayon-e">VARCHAR</span><span class="crayon-sy">(</span><span class="crayon-cn">100</span><span class="crayon-sy">)</span><span class="crayon-sy">,</span> <span class="crayon-e">LDR_V</span> <span class="crayon-e">VARCHAR</span><span class="crayon-sy">(</span><span class="crayon-cn">100</span><span class="crayon-sy">)</span> <span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>Now we need to set up the specific libraries for <a href="http://ift.tt/1SDfWQV" itemprop="url" target="_bank" title="Running A Python Script At Boot Using Cron"><strong>python</strong></a> the first of which being spidev, the spi tool for the <a href="http://ift.tt/1UIqQdK" itemprop="url" target="_bank" title="raspberry"><strong>raspberry</strong></a> pi which we can grab from git using the following commands:</p> <div id="crayon-5706ba7027719611053800" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-nums-button crayon-pressed" title="Toggle Line Numbers"></div> <div class="crayon-button crayon-popup-button" title="Open Code In New Window"></div> <p><span class="crayon-language">Shell</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba7027719611053800-1">1</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba7027719611053800-2">2</div> <div class="crayon-num" data-line="crayon-5706ba7027719611053800-3">3</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba7027719611053800-4">4</div> <div class="crayon-num" data-line="crayon-5706ba7027719611053800-5">5</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba7027719611053800-1" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-v">apt</span><span class="crayon-o">–</span><span class="crayon-r">get</span> <span class="crayon-e">install</span> <span class="crayon-e">git</span></div> <div id="crayon-5706ba7027719611053800-2" class="crayon-line crayon-striped-line"><span class="crayon-e">git</span> <span class="crayon-r">clone</span> <span class="crayon-v">git</span><span class="crayon-o">:</span><span class="crayon-o">/</span><span class="crayon-o">/</span><span class="crayon-v">github</span><span class="crayon-e">.com</span><span class="crayon-o">/</span><span class="crayon-v">doceme</span><span class="crayon-o">/</span><span class="crayon-v">py</span><span class="crayon-o">–</span><span class="crayon-e">spidev</span></div> <div id="crayon-5706ba7027719611053800-3" class="crayon-line"><span class="crayon-r">cd</span> <span class="crayon-v">py</span><span class="crayon-o">–</span><span class="crayon-v">spidev</span><span class="crayon-o">/</span></div> <div id="crayon-5706ba7027719611053800-4" class="crayon-line crayon-striped-line"><span class="crayon-e">sudo</span> <span class="crayon-v">apt</span><span class="crayon-o">–</span><span class="crayon-r">get</span> <span class="crayon-e">install</span> <span class="crayon-v">python</span><span class="crayon-o">–</span><span class="crayon-e">dev</span></div> <div id="crayon-5706ba7027719611053800-5" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-e">python</span> <span class="crayon-v">setup</span><span class="crayon-e">.py</span> <span class="crayon-v">install</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>You also need to (copied from http://ift.tt/1Vc0WPO):</p> <p>As root, edit the kernel module blacklist file:</p> <div id="crayon-5706ba7027732119237297" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-nums-button crayon-pressed" title="Toggle Line Numbers"></div> <div class="crayon-button crayon-popup-button" title="Open Code In New Window"></div> <p><span class="crayon-language">Shell</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba7027732119237297-1">1</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba7027732119237297-1" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-r">vi</span> <span class="crayon-o">/</span><span class="crayon-v">etc</span><span class="crayon-o">/</span><span class="crayon-v">modprobe</span><span class="crayon-e">.d</span><span class="crayon-o">/</span><span class="crayon-v">raspi</span><span class="crayon-o">–</span><span class="crayon-v">blacklist</span><span class="crayon-e">.conf</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>Comment out the spi-bcm2708 line so it looks like this:</p> <div id="crayon-5706ba7027749603743915" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-nums-button crayon-pressed" title="Toggle Line Numbers"></div> <p><span class="crayon-language">Shell</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba7027749603743915-1">1</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba7027749603743915-1" class="crayon-line"><span class="crayon-c">#blacklist spi-bcm2708</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>Save the file so that the module will load on future reboots. To enable the module now, enter:</p> <div id="crayon-5706ba702775e457102376" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-nums-button crayon-pressed" title="Toggle Line Numbers"></div> <p><span class="crayon-language">Shell</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba702775e457102376-1">1</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba702775e457102376-1" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-e">modprobe</span> <span class="crayon-v">spi</span><span class="crayon-o">–</span><span class="crayon-v">bcm2708</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>We will also need WiringPi:</p> <div id="crayon-5706ba7027771922428619" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-nums-button crayon-pressed" title="Toggle Line Numbers"></div> <p><span class="crayon-language">Shell</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba7027771922428619-1">1</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba7027771922428619-2">2</div> <div class="crayon-num" data-line="crayon-5706ba7027771922428619-3">3</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba7027771922428619-1" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-v">apt</span><span class="crayon-o">–</span><span class="crayon-r">get</span> <span class="crayon-e">install</span> <span class="crayon-v">python</span><span class="crayon-o">–</span><span class="crayon-e">imaging</span> <span class="crayon-v">python</span><span class="crayon-o">–</span><span class="crayon-v">imaging</span><span class="crayon-o">–</span><span class="crayon-e">tk</span> <span class="crayon-v">python</span><span class="crayon-o">–</span><span class="crayon-e">pip</span> <span class="crayon-v">python</span><span class="crayon-o">–</span><span class="crayon-e">dev</span> <span class="crayon-e">git</span></div> <div id="crayon-5706ba7027771922428619-2" class="crayon-line crayon-striped-line"><span class="crayon-e">sudo</span> <span class="crayon-e">pip</span> <span class="crayon-e">install</span> <span class="crayon-e">spidev</span></div> <div id="crayon-5706ba7027771922428619-3" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-e">pip</span> <span class="crayon-e">install</span> <span class="crayon-v">wiringpi</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>Then you need to get APscheduler, the timing program used to execute the incremental timing with the following commands:</p> <div id="crayon-5706ba7027783753120952" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-popup-button" title="Open Code In New Window"></div> <p><span class="crayon-language">Shell</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba7027783753120952-1">1</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba7027783753120952-2">2</div> <div class="crayon-num" data-line="crayon-5706ba7027783753120952-3">3</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba7027783753120952-1" class="crayon-line"><span class="crayon-e">wget</span> <span class="crayon-v">https</span><span class="crayon-o">:</span><span class="crayon-o">/</span><span class="crayon-o">/</span><span class="crayon-v">pypi</span><span class="crayon-e">.python</span><span class="crayon-e">.org</span><span class="crayon-o">/</span><span class="crayon-v">packages</span><span class="crayon-o">/</span><span class="crayon-v">source</span><span class="crayon-o">/</span><span class="crayon-v">A</span><span class="crayon-o">/</span><span class="crayon-v">APScheduler</span><span class="crayon-o">/</span><span class="crayon-v">APScheduler</span><span class="crayon-o">–</span><span class="crayon-cn">2.1.0.tar.gz</span></div> <div id="crayon-5706ba7027783753120952-2" class="crayon-line crayon-striped-line"><span class="crayon-e">sudo</span> <span class="crayon-v">tar</span> <span class="crayon-o">–</span><span class="crayon-e">xzvf</span> <span class="crayon-v">APScheduler</span><span class="crayon-o">–</span><span class="crayon-cn">2.1.0.tar.gz</span></div> <div id="crayon-5706ba7027783753120952-3" class="crayon-line"><span class="crayon-e">python</span> <span class="crayon-v">setup</span><span class="crayon-e">.py</span> <span class="crayon-v">install</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>You will need mysqldb to interface <a href="http://ift.tt/1S5WXUP" itemprop="url" target="_bank" title="How To Autorun A Python Script On Raspberry Pi Boot"><strong>python</strong></a> and mysql:</p> <div id="crayon-5706ba7027794360204196" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"> <div class="crayon-button crayon-nums-button crayon-pressed" title="Toggle Line Numbers"></div> <p><span class="crayon-language">Shell</span></p> </div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba7027794360204196-1">1</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba7027794360204196-1" class="crayon-line"><span class="crayon-e">sudo</span> <span class="crayon-v">apt</span><span class="crayon-o">–</span><span class="crayon-r">get</span> <span class="crayon-e">install</span> <span class="crayon-v">python</span><span class="crayon-o">–</span><span class="crayon-v">mysqldb</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>Once you reboot, the following program should work:</p> <div id="crayon-5706ba70277a4245282675" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"><span class="crayon-language">Python</span></div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-1">1</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-2">2</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-3">3</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-4">4</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-5">5</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-6">6</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-7">7</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-8">8</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-9">9</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-10">10</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-11">11</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-12">12</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-13">13</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-14">14</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-15">15</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-16">16</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-17">17</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-18">18</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-19">19</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-20">20</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-21">21</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-22">22</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-23">23</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-24">24</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-25">25</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-26">26</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-27">27</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-28">28</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-29">29</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-30">30</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-31">31</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-32">32</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-33">33</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-34">34</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-35">35</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-36">36</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-37">37</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-38">38</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-39">39</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-40">40</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-41">41</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-42">42</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-43">43</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-44">44</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-45">45</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-46">46</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-47">47</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-48">48</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-49">49</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-50">50</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-51">51</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-52">52</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-53">53</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-54">54</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-55">55</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-56">56</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-57">57</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-58">58</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-59">59</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-60">60</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-61">61</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-62">62</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-63">63</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-64">64</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-65">65</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-66">66</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-67">67</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-68">68</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-69">69</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-70">70</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-71">71</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-72">72</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-73">73</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-74">74</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-75">75</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-76">76</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-77">77</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-78">78</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-79">79</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-80">80</div> <div class="crayon-num" data-line="crayon-5706ba70277a4245282675-81">81</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277a4245282675-82">82</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba70277a4245282675-1" class="crayon-line"><span class="crayon-c">#Timing setup</span></div> <div id="crayon-5706ba70277a4245282675-2" class="crayon-line crayon-striped-line"><span class="crayon-st">from</span> <span class="crayon-k">datetime</span> <span class="crayon-r">import</span> <span class="crayon-k">datetime</span></div> <div id="crayon-5706ba70277a4245282675-3" class="crayon-line"><span class="crayon-st">from</span> <span class="crayon-v">apscheduler</span><span class="crayon-sy">.</span><span class="crayon-e">scheduler</span> <span class="crayon-r">import</span> <span class="crayon-e">Scheduler</span></div> <div id="crayon-5706ba70277a4245282675-4" class="crayon-line crayon-striped-line"><span class="crayon-r">import</span> <span class="crayon-k">time</span></div> <div id="crayon-5706ba70277a4245282675-5" class="crayon-line"><span class="crayon-r">import</span> <span class="crayon-k">datetime</span></div> <div id="crayon-5706ba70277a4245282675-6" class="crayon-line crayon-striped-line"><span class="crayon-r">import</span> <span class="crayon-k">sys</span></div> <div id="crayon-5706ba70277a4245282675-7" class="crayon-line"></div> <div id="crayon-5706ba70277a4245282675-8" class="crayon-line crayon-striped-line"><span class="crayon-v">now</span> <span class="crayon-o">=</span><span class="crayon-k">datetime</span><span class="crayon-sy">.</span><span class="crayon-k">datetime</span><span class="crayon-sy">.</span><span class="crayon-e">now</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-9" class="crayon-line"></div> <div id="crayon-5706ba70277a4245282675-10" class="crayon-line crayon-striped-line"><span class="crayon-r">import</span> <span class="crayon-k">logging</span> <span class="crayon-c">#if you start getting logging errors, uncomment these two lines</span></div> <div id="crayon-5706ba70277a4245282675-11" class="crayon-line"><span class="crayon-k">logging</span><span class="crayon-sy">.</span><span class="crayon-e">basicConfig</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-12" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277a4245282675-13" class="crayon-line"><span class="crayon-c">#GPIO setup</span></div> <div id="crayon-5706ba70277a4245282675-14" class="crayon-line crayon-striped-line"><span class="crayon-r">import</span> <span class="crayon-v">RPi</span><span class="crayon-sy">.</span><span class="crayon-e">GPIO</span> <span class="crayon-st">as</span> <span class="crayon-e">GPIO</span></div> <div id="crayon-5706ba70277a4245282675-15" class="crayon-line"><span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-e">setmode</span><span class="crayon-sy">(</span><span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-v">BOARD</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-16" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277a4245282675-17" class="crayon-line"><span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-e">cleanup</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-18" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277a4245282675-19" class="crayon-line"><span class="crayon-v">pin</span> <span class="crayon-o">=</span> <span class="crayon-cn">26</span> <span class="crayon-c">#pin for the adc</span></div> <div id="crayon-5706ba70277a4245282675-20" class="crayon-line crayon-striped-line"><span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-e">setup</span><span class="crayon-sy">(</span><span class="crayon-v">pin</span><span class="crayon-sy">,</span> <span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-v">OUT</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-21" class="crayon-line"><span class="crayon-v">led1</span> <span class="crayon-o">=</span> <span class="crayon-cn">11</span> <span class="crayon-c">#pin for the short indicator led</span></div> <div id="crayon-5706ba70277a4245282675-22" class="crayon-line crayon-striped-line"><span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-e">setup</span><span class="crayon-sy">(</span><span class="crayon-v">led1</span><span class="crayon-sy">,</span> <span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-v">OUT</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-23" class="crayon-line"><span class="crayon-v">led2</span> <span class="crayon-o">=</span> <span class="crayon-cn">13</span> <span class="crayon-c">#pin for other long indicator led</span></div> <div id="crayon-5706ba70277a4245282675-24" class="crayon-line crayon-striped-line"><span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-e">setup</span><span class="crayon-sy">(</span><span class="crayon-v">led2</span><span class="crayon-sy">,</span> <span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-v">OUT</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-25" class="crayon-line"></div> <div id="crayon-5706ba70277a4245282675-26" class="crayon-line crayon-striped-line"><span class="crayon-c">#the adc’s SPI setup</span></div> <div id="crayon-5706ba70277a4245282675-27" class="crayon-line"><span class="crayon-r">import</span> <span class="crayon-e">spidev</span></div> <div id="crayon-5706ba70277a4245282675-28" class="crayon-line crayon-striped-line"><span class="crayon-v">spi</span> <span class="crayon-o">=</span> <span class="crayon-v">spidev</span><span class="crayon-sy">.</span><span class="crayon-e">SpiDev</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-29" class="crayon-line"><span class="crayon-v">spi</span><span class="crayon-sy">.</span><span class="crayon-k">open</span><span class="crayon-sy">(</span><span class="crayon-cn">0</span><span class="crayon-sy">,</span> <span class="crayon-cn">0</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-30" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277a4245282675-31" class="crayon-line"><span class="crayon-r">import</span> <span class="crayon-e">MySQLdb</span></div> <div id="crayon-5706ba70277a4245282675-32" class="crayon-line crayon-striped-line"><span class="crayon-v">con</span> <span class="crayon-o">=</span> <span class="crayon-v">MySQLdb</span><span class="crayon-sy">.</span><span class="crayon-e">connect</span><span class="crayon-sy">(</span><span class="crayon-s">‘localhost’</span><span class="crayon-sy">,</span><span class="crayon-s">‘piplanter_user’</span><span class="crayon-sy">,</span><span class="crayon-s">‘piplanter_pass’</span><span class="crayon-sy">,</span><span class="crayon-s">‘piplanter’</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277a4245282675-33" class="crayon-line"><span class="crayon-v">cursor</span> <span class="crayon-o">=</span> <span class="crayon-v">con</span><span class="crayon-sy">.</span><span class="crayon-e">cursor</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-34" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277a4245282675-35" class="crayon-line"><span class="crayon-c">#fuction that can read the adc</span></div> <div id="crayon-5706ba70277a4245282675-36" class="crayon-line crayon-striped-line"><span class="crayon-r">def</span> <span class="crayon-e">readadc</span><span class="crayon-sy">(</span><span class="crayon-v">adcnum</span><span class="crayon-sy">)</span><span class="crayon-o">:</span></div> <div id="crayon-5706ba70277a4245282675-37" class="crayon-line"><span class="crayon-c"># read SPI data from MCP3008 chip, 8 possible adc’s (0 thru 7)</span></div> <div id="crayon-5706ba70277a4245282675-38" class="crayon-line crayon-striped-line"><span class="crayon-h">    </span><span class="crayon-st">if</span> <span class="crayon-v">adcnum</span> <span class="crayon-o">></span> <span class="crayon-cn">7</span> <span class="crayon-st">or</span> <span class="crayon-v">adcnum</span> <span class="crayon-o"><</span> <span class="crayon-cn">0</span><span class="crayon-o">:</span></div> <div id="crayon-5706ba70277a4245282675-39" class="crayon-line"><span class="crayon-h">        </span><span class="crayon-st">return</span> <span class="crayon-o">–</span><span class="crayon-cn">1</span></div> <div id="crayon-5706ba70277a4245282675-40" class="crayon-line crayon-striped-line"><span class="crayon-h">    </span><span class="crayon-v">r</span> <span class="crayon-o">=</span> <span class="crayon-v">spi</span><span class="crayon-sy">.</span><span class="crayon-e">xfer2</span><span class="crayon-sy">(</span><span class="crayon-sy">[</span><span class="crayon-cn">1</span><span class="crayon-sy">,</span> <span class="crayon-cn">8</span> <span class="crayon-o">+</span> <span class="crayon-v">adcnum</span> <span class="crayon-o"><<</span> <span class="crayon-cn">4</span><span class="crayon-sy">,</span> <span class="crayon-cn">0</span><span class="crayon-sy">]</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-41" class="crayon-line"><span class="crayon-h">    </span><span class="crayon-v">adcout</span> <span class="crayon-o">=</span> <span class="crayon-sy">(</span><span class="crayon-sy">(</span><span class="crayon-v">r</span><span class="crayon-sy">[</span><span class="crayon-cn">1</span><span class="crayon-sy">]</span> <span class="crayon-o">&</span> <span class="crayon-cn">3</span><span class="crayon-sy">)</span> <span class="crayon-o"><<</span> <span class="crayon-cn">8</span><span class="crayon-sy">)</span> <span class="crayon-o">+</span> <span class="crayon-v">r</span><span class="crayon-sy">[</span><span class="crayon-cn">2</span><span class="crayon-sy">]</span></div> <div id="crayon-5706ba70277a4245282675-42" class="crayon-line crayon-striped-line"><span class="crayon-h">    </span><span class="crayon-st">return</span> <span class="crayon-e">adcout</span></div> <div id="crayon-5706ba70277a4245282675-43" class="crayon-line"><span class="crayon-e">    </span></div> <div id="crayon-5706ba70277a4245282675-44" class="crayon-line crayon-striped-line"><span class="crayon-r">def</span> <span class="crayon-e">rapidSample</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span><span class="crayon-o">:</span></div> <div id="crayon-5706ba70277a4245282675-45" class="crayon-line"><span class="crayon-v">sampleTime</span> <span class="crayon-o">=</span> <span class="crayon-k">time</span><span class="crayon-sy">.</span><span class="crayon-e">ctime</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-46" class="crayon-line crayon-striped-line"><span class="crayon-v">sampleTemp1</span> <span class="crayon-o">=</span> <span class="crayon-sy">(</span><span class="crayon-sy">(</span><span class="crayon-sy">(</span><span class="crayon-e">readadc</span><span class="crayon-sy">(</span><span class="crayon-cn">0</span><span class="crayon-sy">)</span><span class="crayon-o">*</span><span class="crayon-cn">3.3</span><span class="crayon-sy">)</span><span class="crayon-o">/</span><span class="crayon-cn">1024</span><span class="crayon-sy">)</span><span class="crayon-o">/</span><span class="crayon-sy">(</span><span class="crayon-cn">10.0</span><span class="crayon-o">/</span><span class="crayon-cn">1000</span><span class="crayon-sy">)</span><span class="crayon-sy">)</span> <span class="crayon-c">#this translates the analog voltage to temperature in def F</span></div> <div id="crayon-5706ba70277a4245282675-47" class="crayon-line"><span class="crayon-v">sampleLght1</span> <span class="crayon-o">=</span> <span class="crayon-e">readadc</span><span class="crayon-sy">(</span><span class="crayon-cn">1</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-48" class="crayon-line crayon-striped-line"><span class="crayon-v">samplePot1</span> <span class="crayon-o">=</span> <span class="crayon-e">readadc</span><span class="crayon-sy">(</span><span class="crayon-cn">2</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-49" class="crayon-line"></div> <div id="crayon-5706ba70277a4245282675-50" class="crayon-line crayon-striped-line"><span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-e">output</span><span class="crayon-sy">(</span><span class="crayon-v">led1</span><span class="crayon-sy">,</span> <span class="crayon-t">True</span><span class="crayon-sy">)</span> <span class="crayon-c">#turns the led on</span></div> <div id="crayon-5706ba70277a4245282675-51" class="crayon-line"><span class="crayon-k">time</span><span class="crayon-sy">.</span><span class="crayon-e">sleep</span><span class="crayon-sy">(</span><span class="crayon-sy">.</span><span class="crayon-cn">1</span><span class="crayon-sy">)</span> <span class="crayon-c">#sleeps a little bit so you can see the <a href="http://ift.tt/1LK8gQ0" itemprop="url" target="_bank" title="LED"><strong>LED</strong></a> on</span></div> <div id="crayon-5706ba70277a4245282675-52" class="crayon-line crayon-striped-line"><span class="crayon-k">print</span> <span class="crayon-s">“Job 1”</span><span class="crayon-sy">,</span> <span class="crayon-v">sampleTime</span><span class="crayon-sy">,</span><span class="crayon-s">“LDR:”</span><span class="crayon-sy">,</span><span class="crayon-i">sampleLght1</span> <span class="crayon-sy">,</span><span class="crayon-s">“Pot:”</span><span class="crayon-sy">,</span><span class="crayon-v">samplePot1</span><span class="crayon-sy">,</span><span class="crayon-s">“Temp:”</span><span class="crayon-sy">,</span><span class="crayon-v">sampleTemp1</span> <span class="crayon-c">#prints the debug info</span></div> <div id="crayon-5706ba70277a4245282675-53" class="crayon-line"></div> <div id="crayon-5706ba70277a4245282675-54" class="crayon-line crayon-striped-line"><span class="crayon-v">cursor</span><span class="crayon-sy">.</span><span class="crayon-e">execute</span><span class="crayon-sy">(</span><span class="crayon-s">“INSERT INTO piplanter_table_02(Time,Temp_F,LDR_V) VALUES(%s,’%s’,’%s’)”</span><span class="crayon-sy">,</span><span class="crayon-sy">(</span><span class="crayon-v">sampleTime</span><span class="crayon-sy">,</span><span class="crayon-v">sampleTemp1</span><span class="crayon-sy">,</span><span class="crayon-v">sampleLght1</span><span class="crayon-sy">)</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-55" class="crayon-line"><span class="crayon-v">con</span><span class="crayon-sy">.</span><span class="crayon-e">commit</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span> <span class="crayon-c">#this is important for live updating</span></div> <div id="crayon-5706ba70277a4245282675-56" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277a4245282675-57" class="crayon-line"><span class="crayon-k">time</span><span class="crayon-sy">.</span><span class="crayon-e">sleep</span><span class="crayon-sy">(</span><span class="crayon-sy">.</span><span class="crayon-cn">1</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-58" class="crayon-line crayon-striped-line"><span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-e">output</span><span class="crayon-sy">(</span><span class="crayon-v">led1</span><span class="crayon-sy">,</span> <span class="crayon-t">False</span><span class="crayon-sy">)</span> <span class="crayon-c">#turns the led off</span></div> <div id="crayon-5706ba70277a4245282675-59" class="crayon-line"></div> <div id="crayon-5706ba70277a4245282675-60" class="crayon-line crayon-striped-line"><span class="crayon-r">def</span> <span class="crayon-e">slowSample</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span><span class="crayon-o">:</span></div> <div id="crayon-5706ba70277a4245282675-61" class="crayon-line"><span class="crayon-v">sampleTime</span> <span class="crayon-o">=</span> <span class="crayon-k">time</span><span class="crayon-sy">.</span><span class="crayon-e">ctime</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-62" class="crayon-line crayon-striped-line"><span class="crayon-v">sampleTemp1</span> <span class="crayon-o">=</span> <span class="crayon-sy">(</span><span class="crayon-sy">(</span><span class="crayon-sy">(</span><span class="crayon-e">readadc</span><span class="crayon-sy">(</span><span class="crayon-cn">0</span><span class="crayon-sy">)</span><span class="crayon-o">*</span><span class="crayon-cn">3.3</span><span class="crayon-sy">)</span><span class="crayon-o">/</span><span class="crayon-cn">1024</span><span class="crayon-sy">)</span><span class="crayon-o">/</span><span class="crayon-sy">(</span><span class="crayon-cn">10.0</span><span class="crayon-o">/</span><span class="crayon-cn">1000</span><span class="crayon-sy">)</span><span class="crayon-sy">)</span> <span class="crayon-c">#this translates the analog voltage to temperature in def F</span></div> <div id="crayon-5706ba70277a4245282675-63" class="crayon-line"><span class="crayon-v">sampleLght1</span> <span class="crayon-o">=</span> <span class="crayon-e">readadc</span><span class="crayon-sy">(</span><span class="crayon-cn">1</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-64" class="crayon-line crayon-striped-line"><span class="crayon-v">samplePot1</span> <span class="crayon-o">=</span> <span class="crayon-e">readadc</span><span class="crayon-sy">(</span><span class="crayon-cn">2</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-65" class="crayon-line"></div> <div id="crayon-5706ba70277a4245282675-66" class="crayon-line crayon-striped-line"><span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-e">output</span><span class="crayon-sy">(</span><span class="crayon-v">led2</span><span class="crayon-sy">,</span> <span class="crayon-t">True</span><span class="crayon-sy">)</span> <span class="crayon-c">#turns the led on</span></div> <div id="crayon-5706ba70277a4245282675-67" class="crayon-line"><span class="crayon-k">time</span><span class="crayon-sy">.</span><span class="crayon-e">sleep</span><span class="crayon-sy">(</span><span class="crayon-cn">5</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-68" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277a4245282675-69" class="crayon-line"><span class="crayon-k">print</span> <span class="crayon-s">“Job 2”</span><span class="crayon-sy">,</span> <span class="crayon-v">sampleTime</span><span class="crayon-sy">,</span><span class="crayon-s">“LDR:”</span><span class="crayon-sy">,</span><span class="crayon-i">sampleLght1</span> <span class="crayon-sy">,</span><span class="crayon-s">“Pot:”</span><span class="crayon-sy">,</span><span class="crayon-v">samplePot1</span><span class="crayon-sy">,</span><span class="crayon-s">“Temp:”</span><span class="crayon-sy">,</span><span class="crayon-v">sampleTemp1</span> <span class="crayon-c">#prints the debug info</span></div> <div id="crayon-5706ba70277a4245282675-70" class="crayon-line crayon-striped-line"><span class="crayon-v">cursor</span><span class="crayon-sy">.</span><span class="crayon-e">execute</span><span class="crayon-sy">(</span><span class="crayon-s">“INSERT INTO piplanter_table_03(Time,Temp_F,LDR_V) VALUES(%s,’%s’,’%s’)”</span><span class="crayon-sy">,</span><span class="crayon-sy">(</span><span class="crayon-v">sampleTime</span><span class="crayon-sy">,</span><span class="crayon-v">sampleTemp1</span><span class="crayon-sy">,</span><span class="crayon-v">sampleLght1</span><span class="crayon-sy">)</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-71" class="crayon-line"><span class="crayon-v">con</span><span class="crayon-sy">.</span><span class="crayon-e">commit</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span> <span class="crayon-c">#this is important for live updating</span></div> <div id="crayon-5706ba70277a4245282675-72" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277a4245282675-73" class="crayon-line"><span class="crayon-k">time</span><span class="crayon-sy">.</span><span class="crayon-e">sleep</span><span class="crayon-sy">(</span><span class="crayon-cn">5</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-74" class="crayon-line crayon-striped-line"><span class="crayon-v">GPIO</span><span class="crayon-sy">.</span><span class="crayon-e">output</span><span class="crayon-sy">(</span><span class="crayon-v">led2</span><span class="crayon-sy">,</span> <span class="crayon-t">False</span><span class="crayon-sy">)</span> <span class="crayon-c">#turns the led on</span></div> <div id="crayon-5706ba70277a4245282675-75" class="crayon-line"></div> <div id="crayon-5706ba70277a4245282675-76" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277a4245282675-77" class="crayon-line"><span class="crayon-st">if</span> <span class="crayon-v">__name__</span> <span class="crayon-o">==</span> <span class="crayon-s">‘__main__’</span><span class="crayon-o">:</span></div> <div id="crayon-5706ba70277a4245282675-78" class="crayon-line crayon-striped-line"><span class="crayon-c">#the following 3 lines start up the interval job and keep it going</span></div> <div id="crayon-5706ba70277a4245282675-79" class="crayon-line"><span class="crayon-h">    </span><span class="crayon-v">scheduler</span> <span class="crayon-o">=</span> <span class="crayon-e">Scheduler</span><span class="crayon-sy">(</span><span class="crayon-v">standalone</span><span class="crayon-o">=</span><span class="crayon-t">True</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-80" class="crayon-line crayon-striped-line"><span class="crayon-h">    </span><span class="crayon-v">scheduler</span><span class="crayon-sy">.</span><span class="crayon-e">add_interval_job</span><span class="crayon-sy">(</span><span class="crayon-v">rapidSample</span><span class="crayon-sy">,</span> <span class="crayon-v">minutes</span><span class="crayon-o">=</span><span class="crayon-cn">1</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-81" class="crayon-line"><span class="crayon-h">    </span><span class="crayon-v">scheduler</span><span class="crayon-sy">.</span><span class="crayon-e">add_interval_job</span><span class="crayon-sy">(</span><span class="crayon-v">slowSample</span><span class="crayon-sy">,</span> <span class="crayon-v">hours</span><span class="crayon-o">=</span><span class="crayon-cn">1</span><span class="crayon-sy">)</span></div> <div id="crayon-5706ba70277a4245282675-82" class="crayon-line crayon-striped-line"><span class="crayon-h">    </span><span class="crayon-v">scheduler</span><span class="crayon-sy">.</span><span class="crayon-e">start</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>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:</p> <div id="crayon-5706ba70277b6608933182" class="crayon-syntax crayon-theme-orange-code crayon-font-courier-new crayon-os-pc print-yes notranslate" data-settings=" minimize scroll-mouseover"> <div class="crayon-toolbar" data-settings=" show"> <div class="crayon-tools"><span class="crayon-language">PHP</span></div> </div> <div class="crayon-plain-wrap"></div> <div class="crayon-main"> <table class="crayon-table"> <tbody> <tr class="crayon-row"> <td class="crayon-nums" data-settings="show"> <div class="crayon-nums-content"> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-1">1</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-2">2</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-3">3</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-4">4</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-5">5</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-6">6</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-7">7</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-8">8</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-9">9</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-10">10</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-11">11</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-12">12</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-13">13</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-14">14</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-15">15</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-16">16</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-17">17</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-18">18</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-19">19</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-20">20</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-21">21</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-22">22</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-23">23</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-24">24</div> <div class="crayon-num" data-line="crayon-5706ba70277b6608933182-25">25</div> <div class="crayon-num crayon-striped-num" data-line="crayon-5706ba70277b6608933182-26">26</div> </div> </td> <td class="crayon-code"> <div class="crayon-pre"> <div id="crayon-5706ba70277b6608933182-1" class="crayon-line"><span class="crayon-ta"><?php</span></div> <div id="crayon-5706ba70277b6608933182-2" class="crayon-line crayon-striped-line"><span class="crayon-e">mysql_connect</span><span class="crayon-sy">(</span><span class="crayon-s">“localhost”</span><span class="crayon-sy">,</span> <span class="crayon-s">“piplanter_user”</span><span class="crayon-sy">,</span><span class="crayon-s">“piplanter_pass”</span><span class="crayon-sy">)</span> <span class="crayon-st">or</span> <span class="crayon-k">die</span> <span class="crayon-sy">(</span><span class="crayon-s">“Could not connect: “</span> <span class="crayon-sy">.</span> <span class="crayon-e">mysql_error</span><span class="crayon-sy">(</span><span class="crayon-sy">)</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-3" class="crayon-line"><span class="crayon-e">mysql_select_db</span><span class="crayon-sy">(</span><span class="crayon-s">“piplanter”</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-4" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277b6608933182-5" class="crayon-line"><span class="crayon-v">$result</span> <span class="crayon-o">=</span> <span class="crayon-e">mysql_query</span><span class="crayon-sy">(</span><span class="crayon-s">“SELECT * FROM piplanter_table_02”</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-6" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277b6608933182-7" class="crayon-line"><span class="crayon-k">echo</span> <span class="crayon-s">“<table border=’1′></span></div> <div id="crayon-5706ba70277b6608933182-8" class="crayon-line crayon-striped-line"><span class="crayon-s"><tr></span></div> <div id="crayon-5706ba70277b6608933182-9" class="crayon-line"><span class="crayon-s"><th>Sample_Number</th></span></div> <div id="crayon-5706ba70277b6608933182-10" class="crayon-line crayon-striped-line"><span class="crayon-s"><th>Time</th></span></div> <div id="crayon-5706ba70277b6608933182-11" class="crayon-line"><span class="crayon-s"><th>Temp F</th></span></div> <div id="crayon-5706ba70277b6608933182-12" class="crayon-line crayon-striped-line"><span class="crayon-s"><th>LDR Value V</th></span></div> <div id="crayon-5706ba70277b6608933182-13" class="crayon-line"><span class="crayon-s"></tr>”</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-14" class="crayon-line crayon-striped-line"></div> <div id="crayon-5706ba70277b6608933182-15" class="crayon-line"><span class="crayon-st">while</span><span class="crayon-sy">(</span><span class="crayon-v">$row</span> <span class="crayon-o">=</span> <span class="crayon-e">mysql_fetch_array</span><span class="crayon-sy">(</span><span class="crayon-v">$result</span><span class="crayon-sy">)</span><span class="crayon-sy">)</span><span class="crayon-sy">{</span></div> <div id="crayon-5706ba70277b6608933182-16" class="crayon-line crayon-striped-line"><span class="crayon-k">echo</span><span class="crayon-s">“<tr>”</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-17" class="crayon-line"><span class="crayon-k">echo</span><span class="crayon-s">“<td>”</span> <span class="crayon-sy">.</span> <span class="crayon-v">$row</span><span class="crayon-sy">[</span><span class="crayon-s">‘Sample_Number’</span><span class="crayon-sy">]</span> <span class="crayon-sy">.</span> <span class="crayon-s">“</td>”</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-18" class="crayon-line crayon-striped-line"><span class="crayon-k">echo</span><span class="crayon-s">“<td>”</span> <span class="crayon-sy">.</span> <span class="crayon-v">$row</span><span class="crayon-sy">[</span><span class="crayon-s">‘Time’</span><span class="crayon-sy">]</span> <span class="crayon-sy">.</span> <span class="crayon-s">“</td>”</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-19" class="crayon-line"><span class="crayon-k">echo</span><span class="crayon-s">“<td>”</span> <span class="crayon-sy">.</span> <span class="crayon-v">$row</span><span class="crayon-sy">[</span><span class="crayon-s">‘Temp_F’</span><span class="crayon-sy">]</span> <span class="crayon-sy">.</span> <span class="crayon-s">“</td>”</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-20" class="crayon-line crayon-striped-line"><span class="crayon-k">echo</span><span class="crayon-s">“<td>”</span> <span class="crayon-sy">.</span> <span class="crayon-v">$row</span><span class="crayon-sy">[</span><span class="crayon-s">‘LDR_V’</span><span class="crayon-sy">]</span> <span class="crayon-sy">.</span> <span class="crayon-s">“</td>”</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-21" class="crayon-line"><span class="crayon-k">echo</span><span class="crayon-s">“</tr>”</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-22" class="crayon-line crayon-striped-line"><span class="crayon-sy">}</span></div> <div id="crayon-5706ba70277b6608933182-23" class="crayon-line"></div> <div id="crayon-5706ba70277b6608933182-24" class="crayon-line crayon-striped-line"><span class="crayon-k">echo</span> <span class="crayon-s">“</table>”</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-25" class="crayon-line"><span class="crayon-e">mysql_close</span><span class="crayon-sy">(</span><span class="crayon-v">$con</span><span class="crayon-sy">)</span><span class="crayon-sy">;</span></div> <div id="crayon-5706ba70277b6608933182-26" class="crayon-line crayon-striped-line"><span class="crayon-ta">?></span></div> </div> </td> </tr> </tbody> </table> </div> </div> <p>Sometime later I’ll get to graphing the data.</p> <div id="huge-it-share-buttons-top" class="huge-it-share-buttons nobackground"> <h3>Share This:</h3> <ul class="huge-it-share-buttons-list"> <li class=" nobackground"><a href="http://ift.tt/1LIxY7s" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1LIxY7s','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -0px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="https://twitter.com/share?status=http://yoursmart.mobi/feed&text=PiPlanter%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('https://twitter.com/share?status=http://yoursmart.mobi/feed&text=PiPlanter | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -30px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/22fLIsm%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/22fLIsm | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -60px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1LIxZZ0" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1LIxZZ0','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -90px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1qwJ5Hb%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together&mini=true&url=http://ift.tt/1LIxZZ4" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1qwJ5Hb | Basic package setup and bringing everything together&mini=true&url=http://ift.tt/1LIxZZ4','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -120px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/22fLIss%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/22fLIss | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -150px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1qwJ8To%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1qwJ8To | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -180px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/22fLKAr%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/22fLKAr | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -210px -120px" target="_blank"></a></li> <li class=" nobackground"><a href="http://ift.tt/1LIxY7u" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1LIxY7u','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -240px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1qwJ8Tx%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1qwJ8Tx | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -270px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/22fLKAt%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/22fLKAt | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -300px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1o7SuTq" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1o7SuTq','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -330px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1qwJ8TA%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1qwJ8TA | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -360px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1o7SuTs" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1o7SuTs','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -390px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/22fLKAD%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/22fLKAD | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -420px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1qwJ5XD%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together&pic=&ralateUid=&" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1qwJ5XD | Basic package setup and bringing everything together&pic=&ralateUid=&','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -450px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/22fLIIO%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/22fLIIO | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -480px -120px" target="_blank"></a></li> <li class="none nobackground"><a href="http://ift.tt/1qwJ99U%20|%20Basic%20package%20setup%20and%20bringing%20everything%20together" id="backforunical454" name="backforunical454" onclick="javascript:void window.open('http://ift.tt/1qwJ99U | Basic package setup and bringing everything together','1410949501326','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0');return false;" style="background-position: -510px -120px" target="_blank"></a></li> </ul> <div class="clear"></div> </div> View more at: <a href="http://yoursmart.mobi/">http://yoursmart.mobi</a>

PiPlanter | Basic package setup and bringing everything together

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 d...

Read more »