opkg update 
opkg install mysql-server
mysql -h192.168.0.20 -uroot -p
mysql> show databases;
mysql> CREATE DATABASE ARDUINO;
mysql> USE ARDUINO;
mysql> CREATE TABLE temperature (
id INT NOT NULL AUTO_INCREMENT,
sensor1 VARCHAR(20),
sensor2 VARCHAR(20),
insert_date TIMESTAMP,
PRIMARY KEY (id)
);
mysql> SHOW TABLES;
opkg update
opkg install python-mysql
nano /mnt/sda1/mysql.py
#!/usr/bin/python
# -*- coding: utf-8 -*-
import _mysql
import sys, string, os
try:
    	con = _mysql.connect('192.168.0.20', 'root', 'password', 'ARDUINO')
	sqlstr="INSERT INTO temperature(sensor1, sensor2) VALUES( '" + sys.argv[1] +"', '" + sys.argv[2] + "')"
	#print sqlstr
	con.query(sqlstr)   
except _mysql.Error, e:
    	print "Error %d: %s" % (e.args[0], e.args[1])
    	sys.exit(1)
finally:    
    	if con:
		con.close()
chmod 755  /mnt/sda1/mysql.py 
/mnt/sda1/mysql.py    'test1' 'test2'

Arduino code:

#include <Process.h>
int temperature;
void setup() {
 Bridge.begin();  // Initialize Bridge
}
void loop() {
 int sensor1 = random(0, 100);
 int sensor2 = random(0, 10);
 Process p;              
 p.begin("/mnt/sda1/mysql.py");      
 p.addParameter(String(sensor1)); 
 p.addParameter(String(sensor2)); 
 p.run();
 delay(5000); 
}

Comments powered by CComment