Solar Panel Project

1. Raspberry PI
   • Fixed IP: Static or DHCP Registered.
   • Port 80 open for Fixed IP on Edge FW.
   • Packages Needed...
     1. http
     2. cron
   • Script to prepare for download...
         /bin/mv <file.csv> <downloadfile.csv>
    /bin/touch <file.csv>
   • Job to prepare download csv file...
     OS file locking should ensure complete file move,
     But wise to check and confirm first and last lines have all fields.
    
   
2. AWS BingDev:watsolar
   • Packages/functions Needed...
     1. remote file upload.
     2. remote DB connection.
     3. color graph creation.
   • Test with wget to confirm connection and upload success.
   • PHP SCRIPT One:
     1. Connect to raspbery PI and get csv file
        file_get_contents()
     2. Do remote connection to AWS RDS and load file into database
        $mysqli=new mysqli("bingdev-db.binghamton.edu","watsonsolar",<password>","watsonsolar");
     3. clean up
   • crontab...
     1. Job to download csv file from Raspberry entry added.
   • PHP SCRIPT two:
     1. Connect to RDS DB.
     2. Present Data in Graph form.
     3. Present Data in other format.
     4. Other.

Tara Dhakal 
Daniel J Sidoti