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!)
- System Update & upgrade :
pi@RPIMON1~$sudo apt-get upgrade
pi@RPIMON1~$sudo apt-get dist-upgrade
pi@RPIMON1~$sudo sync
- Reboot:
- INSTALL Required packages:
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~$wget http://cache.ruby-lang.org/pub/ruby/2.1/ruby-2.1.5.tar.gz
pi@RPIMON1~$tar xvzf ruby-2.1.5.tar.gz
pi@RPIMON1~$cd ruby-2.1.5
pi@RPIMON1~$./configure
pi@RPIMON1~$make
MAKE RESULT:
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
THINGSPEAK SERVER INSTALL
pi@RPIMON1~$git clone https://github.com/iobridge/thingspeak.git
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
Check MYSQL DB:
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
RUN the THINGSPEAK SERVER:
pi@RPIMON1 ~/yourthingspeak $ rails server webrick.
That's it! Prepare yourself for about 4 hours of patience :)
Waiting your feedback about!
