Arduino Code Help

[xQubeZx]

Hello,

 

I really need some help, and I'm hoping someone here can help me. 

I have a problem to solve, I just started a project on the arduino. I have a sensor that is going to send data to my web server with a cc3000 wifi sheild. But my problem is i suck at writing C/C++ code. So basiclly i need help to write a code that can read my sensor data (a DHT11 Sensor, for starts) and then send it over the LAN to my web server wich runs apache with a mysql database. And the database is going to pick up the data and store it. Im not sure if i should get the data by Push or Pull from the server side, but I hope someone here can help me with all this.

 

And also if you do a example code of similair please try to comment alot if possible, easier to learn and modify then.

 

All help is greatly apreciated  

[xQubeZx]

I'm using the arduino uno R3

[xQubeZx]

And right now i actully got a Arest code that is kind of working, it can send the data in json format but im not able to display it on my server now..

I can only see it if i make a call for the data in the browser but it wont work with my web code

[xQubeZx]

You can install a library to your Arduino IDE, that will help connecting directly to the database and storing the data that you want.

 

Take a look at MySQL Arduino project: http://bazaar.launchpad.net/~chuck-bell/mysql-arduino/release-1.0.2-beta/view/head:/Readme.txt

 

You can check for examples in the author's blog: http://drcharlesbell.blogspot.com.br/2013/04/introducing-mysql-connectorarduino_6.html

Well I'm using the cc3000 wifi sheild and not the Ethernet one, soo will it work if i modify the code somehow? And as i said im terrible at coding C/C++ code so I probably need more help with the code is that is possible.

[xQubeZx]

I cant get it to work beacuse the mysql.h includes the Ethernet instead of the cc3000, and i got the adafruit cc3000, but that maybe isnt a problem?

[xQubeZx]

Still dosent work

 

Im not sure if im doing something wrong or not, i dont think so atleast

[xQubeZx]

It says "Wifi.h No such file or directory"

 

But i really apreciate that you tries to help me

[xQubeZx]

The only one i can find is the mysql-connector-arduino, is it the one?

[xQubeZx]

Is it possible for you to edit the files, beacuse it seems like im donig something wrong, I'm just getting more errors when i change them.

[xQubeZx]

Okey now the libraries seems to work, but it says its errors in the code of the test_program.ino that i dont really know how to fix..kind of noobie at C

[xQubeZx]

It says this when compiling: test_program.ino:10:1: error: expected ',' or ';' before 'unsigned'

test_program.ino: In function 'void loop()':

test_program.ino:55:29: error: 'server_addr' was not declared in this scope

test_program.ino:62:3: error: 'else' without a previous 'if'

Error compiling.

[xQubeZx]

Thanks alot, i dont have time ti check if it works now but Il check it tomorrow as soon as i can.

[xQubeZx]

Well the code seems to work now, but i could use some help with setting up the database right too, haven't really succeded to make a connection but im getting closer atleast

 

I only get to this stage:

 

Initialising the CC3000 ...

Connected!

Request DHCP

Connecting...

 

Then it stops there

[xQubeZx]

Yeah, i probably need help to create the database isnt the good on it, and the DB user and password is my login for phpmyadmin right?

 

[EDIT]

It gets stuck on Connecting to DB again, so im thinking ive done something wrong with the databases and all that since im quite new to databases too..

[xQubeZx]

Okey thanks, but I'm still having the problem that it wont connect to the DB...

 

[EDIT]

 

What should the database name be? And what should the Table name be and what properties should it have and how many columns?

 

Just to check so ive made it all right or not

[xQubeZx]

I'm not getting anything in the serial monitor now, should it be so? And like the databases is still confusing do you know an good tutorial?, and what in the program points at the name of the database and the table?

 

Is it like this? Or am i totally lost?

 

test_arduino.dht

 

test_arduino=database

dht=table

[xQubeZx]

Okey, first its a problem when enabling the debug, i tried to find it but didn't succed. 

 

Here is the output:

test_program.ino: In function 'void setup()':

test_program.ino:73:32: error: expected ')' before ';' token

Error compiling.

 

[EDIT]

Found the missing ')' and solved it.

 

And I need help with the database stuff, I'm lost. I have an screenshot here so you can see. What am i supposed to type in all these columns and stuff? If you got time and its not to hard could you explain pretty deep? Sorry for being pretty bad at this stuff..

 

 

I know the resulution is a bit weird but manage to capture both screens. But maybe it help to trubleshoot with a picture.

[xQubeZx]

Okey, it wont connect to the database I can't figure out why. I've tried different users but still don't work. It stops at this in the serial monitor:

 

Initialising CC3000

Connected!

Request DHCP

DHCP acquired

Connecting to DB

 

(Been sitting in this stage for 10-15 min)

 

But the database seems to work great though I can add the data manually to it without any problems at all, so thats good atleast.

 

But do you have any ideas why it wont connect?

[xQubeZx]

Can't get it to work, is it a probelm if the server it will connect to is on an raspberry pi? It stops at Connecting to DB. I have set an static ip on the raspberry so that should not be a problem and the ip is right in the program. Can't figure out why it won't connect.

[xQubeZx]

Okey, il try to do some debugging. It would probably be in the section(s) of code with the connections to the server right?