Servers

From Glacsweb Wiki
Revision as of 17:19, 12 March 2013 by Phil (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

env currently ends up with all the data accessible via http://data.glacsweb.info/iceland/graph. All data is stored in the raw files as received, it is also inserted into a MySQL database for easier analysis.

Norway data that was on leo has also been moved onto this server and is available at http://data.glacsweb.info/norway/plotter.php

Comms from Iceland are via an amazon cloud instance, for information about this contact Kirk or Phil.

The main website is hosted on a System machine.

This wiki is hosted on cima.

There is also a media repository available online - for details contact Phil.

All data stored on env is also backed up every 24hrs to a different building.

Connect MySQL to matlab

To enable matlab to get the data from mysql I followed the instructions given in http://matlab-ib-trading.blogspot.co.uk/2010/08/matlab-and-mysql.html with a couple of minor modifications.

  • Use the latest version of the connector
    • Change the line in the classpath file so that the version numbers match.
  • Make sure matlab has permision to change the classpath file (or run matlab in admin mode for that step only)

Connect MySQL to excel

  • Download the ODBC connector from http://dev.mysql.com/downloads/connector/odbc/ and install it (if running 32 bit office and 64 bit windows you seem to need both versions)
  • Goto data sources (ODBC) in Admin tools click add
  • Choose mysql ODBC driver and follow instructions
  • in Excel goto the data tab and select from other sources
  • Then choose microsoft query
  • Choose the name of the connection you chose earlier
  • You can then choose which data you want to import
  • It can be updated by clicking Refresh All