risknfun's blog    |  go to risknfun's homepage
Blog Main
Tag | Guestbook | Admin   
 
[W6] Network data-logging through through Xport
Build a long-term datalogging system. Capture data from the physical world in a database and build a web interface to display the data gathered over time.

1. Arduino -> Processing -> PHP -> Text
2. Arduino -> Processing -> PHP -> MySQL
3. Arduino -> Xport -> PHP -> MySQL

I did the second option of this assignment during last weekend, but I wanted to try the third one that uses Xport because I was super impressed by Tom's Email clock before. Using Xport means the system becomes a 'stand-alone' one that doesn't need computer at all.

Anyway, this assignment was very challenging because I should have dealt with so many stuffs to work through this path, Sensor -> Arduino -> (serial communication) -> Xport -> (internet) -> PHP -> MySQL -> (internet) -> Web Browser.


- Hardware part


(click to see descriptions)


- Programming part

The code what I wrote, or modifed from the Network Datalogging Suite and the Arduino-Xport-PHP were:

1. A MySQL table setting code (click to expand)


2. An Arduino code on a chip of Arduino, which reads sensor values and send them to a Xport using an HTTP Request via a serial communication.

3. A PHP code on a remote Web server, which accepts data from the Xport by a GET method, and then save them to the MySQL database. This code is also used as a viewer for the saved data.

And, here is a simple version of the Arduino code just for a test.

Simple code of from Arduino to Xport to PHP. (click to expand)



- Result

I finally made it works and here is what I got. (temporary)

the last few lines of the result (click to expand)




- Problems what I faced

1. My Xport didn't response a ping command so I checked and checked again the network configurations.

2. MySQL Admin page didn't work properly. I couldn' create a table through it.

3. I forgot my MySQL DB password so I used a web server in Korea instead, which is quite slow from here.

4. I was confused the usage of GET statements. I couldn't find the sample code above so I've googled a lot.

5. I couldn't find my Xport through a device installer provided by Lantronix.

6. An IP address is needed not a domain name while connecting to the server via an HTTP Request command. But, one of my server I used at the moment didn't give me a way to connect through. Maybe it used a virtual host setting on the web server, I guess. So I move all files to an another server.


- Conclusion and Future Plan

Since the Xport was very hard to figure out how it works, I couldn't pick a sensor and a project that a timescale that’s longer than a typical human-reaction timescale. However, I think I can apply this knowledge to my project. For example, someone who lives in opposite side of the earth can visits my web page to see how my brain waves are changing when I'm sleeping in real-time.


Referece: http://www.lantronix.com/support/documentation.html
Tag : ,
Track this back : http://itp.nyu.edu/~yc581/blog/trackback/115

name    password    homepage
 hidden


 Category
All (251)
Project (1)
Me, Myself & I (52)
ITP (106)
NY (92)
 TAGS
"+ and -" 3D AIA Albeniz Alisa Weilerstein American Museum of Natural History Anish Kapoor Anne Ducros Anne-Sophie Mutter Application architecture Arduino Armory Show art Assistive Technology bar Beethoven bibimbab biofeedback Birdcalls Birdland bitforms BK Blog Blue Note Brahms Brown C cafe Calder Camera4K Carnegie Hall Center for Architecture Chelsea Chris Marker Cleveland Orchestra clock collage CommLab compform composition Computaional Form Computational Forms Computers for the Rest of You consciousness Daniel Barenboim Dave Holland design Designing for Constraints DfC Dia:Beacon Distortion DJ dogs Donald Judd drive dynavox EEG Elizabeth Seton email Experimental Video First Friday football fountain2006 Gagosian Gallery game Garrick Ohlsson Gehry Gershwin Gidon Kremer gmail Graphical Novel Grey Art Gallery Guggenheim Hair Halloween Harlem horse hot dog IAC Iannis Xenakis IDEO IFC center Illusion Wheels Interactive Puppet Theater IPAC2 IR sensor ITP jazz John Cage Kwang-Young Chun La Jetée Lamp Lang Lang Leeds Radio Leon Fleisher Lev Manovich Lilya Zilberstein Lincoln Center Louise Lawler Marc-André Hamelin Matthew Barney Maurizio Cattelan Maxim Vengerov Maya metaforms Michel Gondry Minsoo Lee MLB MoMA Mona Hatoum Morse code movie Moving Pictures Mozart Nam June Paik Neuroesthetics Nevada Smiths NY life Olafur Eliasson On Kawara OUT OF TIME paper prototype party photoshop Physical Computing piano
 Recent Entries
Moving
inspiration, perspiration..
lights in the dark
Life (2)
Dali
 Recent Comments
thank you man. hope you h..
risknfun - 2008
happy thanksgiving~
cheter - 2008
Some of the pictures have..
Chromaniac - 2008
저거 어디더라.. MET museu..
kaka - 2008
http://www.artnet.com/mag..
nori - 2008
 Archive
2009/01
2008/12
2008/11
2008/07
2008/06
 Visitor Statistics
Total : 86015
Today : 1
Yesterday : 7
rss