User Tools

Site Tools


worklog

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
Next revision Both sides next revision
worklog [2014/01/27 12:15]
zoza created
worklog [2014/02/05 11:21]
zoza [arudino/pd to DMX light]
Line 1: Line 1:
 +====== android app logging on the server ======
 +
 +following [[http://​www.androidhive.info/​2012/​05/​how-to-connect-android-with-php-mysql/​|these instructions]]
 +
 +server side: 
 +
 +  * create a mysql user for the project
 +<​code>​
 +mysql -u root -p
 +</​code>​
 +<​code>​
 +mysql> use mysql;
 +mysql> INSERT INTO user (Host,​User,​Password) VALUES('​%','​username',​PASSWORD('​password'​));​
 +mysql> flush privileges;
 +</​code>​
 +  * create a database ​
 +<​code>​
 +myqsl> create database databasename;​
 +</​code>​
 +  * create a table
 +<​code>​
 +mysql> use databasename;​
 +mysql> CREATE TABLE tablename(
 +pid int(11) primary key auto_increment,​
 +value1 int(10) not null,
 +value2 int(10) not null,
 +value3 int(10) not null,
 +value4 int(10) not null,
 +created_at timestamp default now() 
 +);
 +</​code>​
 +  * create a php file which will handle http requests from the app; [[php-server-log]]
 +  * edit the class that sends data to the server, in this case SentToServ.java and include the correct server address ​
 +<code java>
 + private static final String SERVER_IP = "​http://​urloftheserver/​file.php";​
 +</​code>​
 +
 +====== arudino/pd to DMX light ======
 +
   * using eurolite LED Floor SLS-400 RGM DMX lights ([[http://​www.recordcase.de/​cosmoshop/​pix/​a/​media/​0020105380/​sls-400.pdf|manual]])   * using eurolite LED Floor SLS-400 RGM DMX lights ([[http://​www.recordcase.de/​cosmoshop/​pix/​a/​media/​0020105380/​sls-400.pdf|manual]])
  
-arudino to DMX light+ardunio Leonardo 
 + 
 +IDE version 1.1.5 
 + 
 +Tinkerit ​DMX shield, 3pins; 
 +(jumpers: EN-;​-DE;​TX-;​RX;​) 
 + 
 +DMXSimple library v3.1 found [[http://​nervousvision.com/​download/​DmxSimple_v3.1.zip|here]] with the customized [[dmx-simple|DmxSimple]] file (pin 2 always on) somewhere on this wiki 
 + 
 +light set to 5ch mode, addr 1 
 + 
 +pd testpatch [[eurolite-dmx-test]] 
 + 
 +====== install app: ====== 
 + 
 +qr code generator (you can specify the type like android app, iphone app, url...) [[http://​www.qrstuff.com/​]] 
 +qr code with download tracking [[https://​www.youscan.me/​dashboard/​]] 
 + 
 +====== set-up the router ====== 
 + 
 +  * TP LINK WR703N router 
 +  * OpenWRT installed following these instructions 
 +  * AP MODE: the blank wireless [[ap-configuration|configuration file]] 
 +  * BRIDGE MODE?
worklog.txt · Last modified: 2014/02/05 12:49 by zoza