Sunday, November 30, 2014

Installing MySql on Pìdora 2014

Pidora 2014
Apache HTTPD
MySQL 5.5.28


Status:

  • 20141130 Working on it.
  • 20141207 It's working.
ToDo:
  • Import robot database in to this server.
Installing:
  • Install MySql from old repository (fc18):
  • Downloads:
  • cd ~/Downloads
  • wget http://pidora.ca/pidora/releases/18/packages/armv6hl/os/Packages/m/mysql-server-5.5.28-1.fc18.armv6hl.rpm
  • wget http://pidora.ca/pidora/releases/18/packages/armv6hl/os/Packages/m/mysql-5.5.28-1.fc18.armv6hl.rpm
  • wget http://pidora.ca/pidora/releases/18/packages/armv6hl/os/Packages/m/mysql-libs-5.5.28-1.fc18.armv6hl.rpm
  • Login as root:
  • cd ~/Downloads
  • yum install perl-DBD-MySQL.armv6hl (mariadb and mariadb-server does not work)
  • rpm -i mysql-libs-5.5.28-1.fc18.armv6hl.rpm
  • rpm -i mysql-5.5.28-1.fc18.armv6hl.rpm
  • rpm -i mysql-server-5.5.28-1.fc18.armv6hl.rpm
  • Activate service and start mysql:
  • chkconfig mysqld on
  • service mysqld start

Testing:

  • Change mysql root password:
  • mysql
  • UPDATE mysql.user SET Password=PASSWORD('123456') WHERE User='root';


References:
MariaDB vs. MySQL

Raspberry Pidora with Arduino Uno

Pidora
Arduino Uno R3
Python 2.7.8
PySerial 2.7


Status:

  • 20141130 It's working.
Installing PySerial:
  • mkdir ~/pyserial
  • cd ./pyserial
  • Download PySerial sources:
  • wget http://pypi.python.org/packages/source/p/pyserial/pyserial-2.7.tar.gz
  • gzip -d -r ./pyserial-2.7.tar.gz
  • tar -xvf pyserial-2.7.tar
  • cd pyserial-2.7
  • su
  • pwd
  • python setup.py install
Testing PySerial:
  • python
  • import serial
  • ser=serial.Serial(port='/dev/ttyACM0', baudrate=500000, timeout=1)
  • print ser.readline()
  • ser.write("100:1:200:0\n")
  • ser.write("000:1:000:0\n")
References: