Wednesday, November 4, 2015

Raspberry PI2 + Thingspeak on JESSIE

   This is a follow-up for the previous Raspberry PI2 - Standalone Thingspeak server installation

   Because many people have encountered lots of issues with the installation, mainly r8188eu WIFI chipset driver issues or strange compile problems, I was thinking to give a chance also to the new RASPBIAN Jessie, maybe it might be possible to make life easier for many of us.

   The setup environment remain the same, same remain the SD Card flashing process, so please take a look first at : Raspberry PI2 - Standalone Thingspeak server installation

   First thing: because I use RPI2 board headless, I have disabled the new default boot to graphical interface that Jessie has, CLI is more than enough for me.

   GOOD NEWS!! The issue with the r8188eu WIFI seems to be solved. At least my dongle worked this time out of the box, nothing fancy to be done anymore.

   Below is the full transcript of a Thingspeak Server installation process finished about 30 min ago, using a fresh new RASPBIAN Jessie image:

System Update & required packages install

  • Switched over to SSH remote access with Putty - accept new key
  • Change "pi" account password:
  • Set ROOT password, so you can then use root (just for very, very special things!)
              pi@RPIMON1~$sudo passwd root
  • System Update & upgrade  :
              pi@RPIMON1~$sudo apt-get update            
              pi@RPIMON1~$sudo apt-get upgrade          
              pi@RPIMON1~$sudo apt-get dist-upgrade   
              pi@RPIMON1~$sudo sync

  • Reboot:
            pi@RPIMON1~$ sudo reboot
  • INSTALL Required packages:
           pi@RPIMON1~$sudo apt-get -y install build-essential git mysql-server mysql-client 
                                       libmysqlclient-dev libxml2-dev libxslt-dev libssl-dev libsqlite3-dev  

 MySQL Database configuration

    pi@RPIMON1~$mysql --user=root mysql -p useyourpasswd here
    pi@RPIMON1~$mysql> CREATE USER 'thing'@'localhost' IDENTIFIED BY 'speak’;
    pi@RPIMON1~$mysql> GRANT ALL PRIVILEGES ON *.* TO 'thing'@'localhost' WITH GRANT OPTION;
    pi@RPIMON1~$mysql> commit;
    pi@RPIMON1~$mysql> exit;

Ruby / Rails install

          pi@RPIMON1~$tar xvzf ruby-2.1.5.tar.gz
          pi@RPIMON1~$cd ruby-2.1.5


  Files:        962
  Classes:     1414 ( 566 undocumented)
  Modules:      268 (  87 undocumented)
  Constants:   2098 ( 624 undocumented)
  Attributes:  1146 ( 272 undocumented)
  Methods:    10651 (2228 undocumented)

  Total:      15577 (3777 undocumented)
   75.75% documented

  Elapsed: 812.6s

(That means you need to be VERY patient thru the entire process ! :) )

          pi@RPIMON1~$sudo make install
          pi@RPIMON1~$cd ..
          pi@RPIMON1~$echo "gem: --no-rdoc --no-ri" >> ${HOME}/.gemrc
          pi@RPIMON1~$sudo gem install rails


    pi@RPIMON1~$git clone
    pi@RPIMON1~$cp thingspeak/config/database.yml.example thingspeak/config/database.yml
    pi@RPIMON1~$cd thingspeak
    pi@RPIMON1~$bundle install
    pi@RPIMON1~$bundle exec rake db:create


    pi@RPIMON1~$mysql --user=root mysql -p
    pi@RPIMON1~$mysql> show databases;

#+----------------------------  +
#| Database                        |
#+----------------------------  +
#| information_schema        |
#| mysql                              |
#| performance_schema      |
#| thingspeak_development |
#| thingspeak_test               |

     pi@RPIMON1~$mysql> exit; 

IF MYSQL DB OK  then :

     pi@RPIMON1~$bundle exec rake db:schema:load


    pi@RPIMON1 ~/yourthingspeak $ rails server webrick.

 That's it! Prepare yourself for about 4 hours of patience :)

 Waiting your feedback about!


Scott Ramirez said...

When I configure the MySQL data base nothing happens, is that normal? How do i check if it was done right?

Tracker J said...

pi@RPIMON1~$mysql --user=root mysql -p
pi@RPIMON1~$mysql> show databases;
pi@RPIMON1~$mysql> exit;

Anders Løvstad said...

No way I could install libv8. Bundle install and all others failed.
I then tried sudo gem install libv8 -v '' and finally libv8 got installed.
Running the bundle install again went ok.
Problem now is: when ~/yourthingspeak $ rails server webrick
ends in : -bash: /home/pi/yourthingspeak: No such file or directory
Any idea?

Anders L said...

Off course it should be: rails server webrick.
Server is running now.
Thanks for the tutorial:)

Anders L said...

The line:
bundle exec rake db:schema:load
is missing in this description.
It should be after : bundle exec rake db:create

Tracker J said...

You have right, typo error when last update was done. Now OK.

sync said...
This comment has been removed by the author.
Tuan Anh Nguyen said...

thanks you so much!

Unknown said...

Hi there...
Got this error message:
An error occurred while installing eventmachine (1.0.3), and Bundler
cannot continue.
Make sure that `gem install eventmachine -v '1.0.3'` succeeds before
Whats wrong ?
This is on a Raspberry Pi 2 b

Post a Comment