Setting up iMac (OSXYosemite 10.10.5)

$ sudo easy_install pip
$ sudo pip install -U setuptools
$ sudo pip install pyserial

install MariaDB as that is what is installed on pew
==

  • make sure Xcode is uptodate or install it

$ xcode-select –install

  • install homebrew

$ ruby -e “$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)”

  • Check Homebrew

$ brew doctor

  • Update Homebrew

$ brew update

  • Check MariaDB version in brew repo

$ brew info mariadb

  • Install MariaDB

$ brew install mariadb

  • Run the Database Installer (change the version number in the path to match where MariaDB was installed in previous step)

$ unset TMPDIR
$ cd /usr/local/Cellar/mariadb/10.0.21/
$ mysql_install_db

  • Start MariaDB

$ mysql.server start

  • Secure the Installation

$ mysql_secure_installation

  • Connect to MariaDB

$ mysql -u root -p

  • Verify MariaDB Version

$ select @@version;

Fabulous source of the above instructions – https://mariadb.com/blog/installing-mariadb-10010-mac-os-x-homebrew

===

  • $ sudo pip install MySQL-python

$ sudo pip install PyMySQL

===

  • plug in USB to serial convertor and a sensor. You may have FTDI drivers installed – check using from root dir:

$ ls /dev/cu.*

You are looking for /dev/cu.usbserial or /dev/tty.usbserial (see http://pbxbook.com/other/mac-tty.html )

If not showing up install driver at http://www.prolific.com.tw/US/ShowProduct.aspx?p_id=229&pcid=41 and restart.

===

  • Change path in conn.py to be correct serial port path:

ser0 = serial.Serial(‘/dev/tty.usbserial’, 9600, timeout=5)

  • and fuck me this all worked straight away. I am learning after all.

Update 13th Nov 2015
To get up and running on the command line:
$ mysql.server start
then
$ mysql -u root -p
created nmr db on iMac and created tables using latest schema hosted on github.

TODO – export database from pew and install on imac so that nmr_index contains a tag ID that it can match.