Backyard Aquaponics
A place to discuss aquaponics

I didn't get the "Global variables use 1,649 bytes (80%) of dynamic memory, leaving 399 bytes for local variables. Maximum is 2,048 bytes." message on mine, is that with DHCP off? Make sure to leave anything you aren't using off like light support.

Probably the easiest way to debug the Uno is to hook it up to USB and run the Serial Monitor in the Arduino IDE. That will let you see the debugging output and see if anything is going.

You probably already did but make sure to point the servip variable to your linux box's IP and open the port in it's firewall (UDP).

Thanks for the replies..

I ran the serial monitor and get the following cont scrolling

DS1307 Testsketch
Format is "hh:mm:ss dd-mm-yyyy DDD"
MEZ=0, MESZ=1 : 0

165:165:85 165-165-2165 MON seconds since 1.1.2000:1076433489 MEZ=0, MESZ=1 : 0 - Address in NV-RAM is: 0 - Clock was set!
165:165:85 165-165-2165 MON seconds since 1.1.2000:1076433489 MEZ=0, MESZ=1 : 0 - Address in NV-RAM is: 1 - Clock was set!
165:165:85 165-165-2165 MON seconds since 1.1.2000:1076433489 MEZ=0, MESZ=1 : 0 - Address in NV-RAM is: 2 - Clock was set!
165:165:85 165-165-2165 MON seconds since 1.1.2000:1076433489 MEZ=0, MESZ=1 : 0 - Address in NV-RAM is: 3 - Clock was set!
165:165:85 165-165-2165 MON seconds since 1.1.2000:1076433489 MEZ=0, MESZ=1 : 0 - Address

I have tried with dhcp on and off, same result.
I also tried changing mac address to something like byte eth_mac[] = { 0xBE, 0xEF, 0xBE, 0xEF, 0xF0, 0x0D };
still looking at what could be wrong

really odd.

Yeah, that's not the program so I guess it never got written to the Uno. It says it's a DS1307 (RTC) test program.

I seem to have a faulty arduino, borrowed another UNO and now I have it partially working..

ie it is sending a packet to server... but

on server I get a Packet Size Error message on server (message from a.out file which is compiled server.cpp file)

Packet size from arduino is not corresponding to what server.cpp is expecting..

Can you explain about how packet size works, building/tweaking server.cpp so packet size matches up???

Error: Received packet size != sizeof(SENSOR_PACKET)
Error: Received packet size != sizeof(SENSOR_PACKET)

On Arduino Monitor:

Temperature Sender starting up...
Attempting to get IP address with DHCP...
Obtained IP: 192.168.100.133
Bound UDP port...
Init sensors...
Number of 1-wire devices: 1
Setup complete.
Requesting temperatures... done
Temp 0: 28.62
Getting light value... 325
Requesting temperatures... done
Temp 0: 28.62
Getting light value... 280


and attaching a packet capture file

No. Time Source Destination Protocol Length Info
1 0.000000000 192.168.100.133 192.168.100.135 UDP 60 Source port: 28444 Destination port: 28444

Frame 1: 60 bytes on wire (480 bits), 60 bytes captured (480 bits) on interface 0
Ethernet II, Src: ae:ad:be:bf:f0:0f (ae:ad:be:bf:f0:0f), Dst: Hewlett-_43:ce:74 (00:14:c2:43:ce:74)
Internet Protocol Version 4, Src: 192.168.100.133 (192.168.100.133), Dst: 192.168.100.135 (192.168.100.135)
User Datagram Protocol, Src Port: 28444 (28444), Dst Port: 28444 (28444)
Data (17 bytes)

0000 4c 43 41 50 02 ae ad be bf f0 0f ff 01 6a 01 e4 LCAP.........j..
0010 41 A
Data: 4c43415002aeadbebff00fff016a01e441
[Length: 17]

In server.h, try adding this above line 45 (the line above struct SENSOR_PACKET {):
#pragma pack(1)

Then after the closing }; of the struct add:
#pragma pack()

Then recompile the server.

It worked!

Thanks for that pragma line!!

I see the log file update every 5mins on svr - fantastic!

here is some data
1380113100 temp 28:03:3B:40:00:00:00:53 27.56
1380113100 temp 28:85:71:AC:01:00:00:AF 27.88
1380113100 light AE:AD:BE:BF:F0:0F:FF:01 370
1380113400 temp 28:03:3B:40:00:00:00:53 27.75
1380113400 temp 28:85:71:AC:01:00:00:AF 28.12
1380113400 light AE:AD:BE:BF:F0:0F:FF:01 292
1380113700 temp 28:03:3B:40:00:00:00:53 27.75
1380113700 temp 28:85:71:AC:01:00:00:AF 28.06
1380113700 light AE:AD:BE:BF:F0:0F:FF:01 293
1380114000 temp 28:03:3B:40:00:00:00:53 27.81
1380114000 temp 28:85:71:AC:01:00:00:AF 28.12
1380114000 light AE:AD:BE:BF:F0:0F:FF:01 420



question about the strange time stamp on the left
what exactly is this time 1380114000??
its 10pm on the svr.. turned on time stamp/update on arduino,
be nice to have the basic 22:00 format, perhaps just even have the server time stamp directly at time of writing..?

thanks again for your time and patience!

yeah, that can be added. That number is a unix timestamp; if your frontend is going to be written in PHP you can use it with the date() function to print a time/date in any format.

Here you go, this adds the readable time and date to the log.

thanks for update, that looks much neater now.

Now to figure out how to get that file into a mysql db for archiving etc..

you could alter the source to write SQL queries to a file, or just have it log to mysql directly.

I am on a steep learning curve again with arduino data logging and mysql..
So now I have the arduino logging temp/light levels from greenhouse to webserver flat file. (thanks to your good work!)

As I understand the arduino itself cannot post data direct to mysql on its own correct (ie you can only do GET, PUT, or POST).
I would need some other application, like a PHP script, to get the data from that flat file from your current logger , and construct the SQL commands to insert the data in the database or is there a simpler way?

You do have a few options, yeah:

a) modify the LoggingServer to write SQL queries to a file,
b) make a PHP or bash script to read datalog.txt and make SQL queries from it, or
c) modify it to log to MySQL directly. MySQL's C api is pretty easy so don't let it freak you out or anything.