18:fe:34:dc:e2:cc: - New record : { "boat_id": 7, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 83, "event_date": "2016-02-03T08:53:43-00:00" , "event_type": "ping", "value": 5.05 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:ea:4f: - New record : { "boat_id": 2, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 108, "event_date": "2016-02-03T08:53:45-00:00" , "event_type": "ping", "value": 20.37 },{ "device_id": 107, "event_date": "2016-02-03T08:53:45-00:00" , "event_type": "ping", "value": 0 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:ea:4f: In end of Amazon : 
5c:cf:7f:01:6b:ea: - New record : { "boat_id": 7, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 84, "event_date": "2016-02-03T08:54:16-00:00" , "event_type": "ping", "value": 2.92 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:f9:32:ea: - New record : { "boat_id": 12, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 135, "event_date": "2016-02-03T08:54:22-00:00" , "event_type": "ping", "value": 0 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:e1:2a: - New record : { "boat_id": 7, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 89, "event_date": "2016-02-03T08:54:27-00:00" , "event_type": "ping", "value": -13.88 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:e4:37: - New record : { "boat_id": 3, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 42, "event_date": "2016-02-03T08:54:43-00:00" , "event_type": "ping", "value": 15.68 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:e1:b5: - New record : { "boat_id": 3, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 103, "event_date": "2016-02-03T08:54:44-00:00" , "event_type": "ping", "value": 25.56 },{ "device_id": 102, "event_date": "2016-02-03T08:54:44-00:00" , "event_type": "ping", "value": 0 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:e2:cc: - New record : { "boat_id": 7, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 83, "event_date": "2016-02-03T08:54:51-00:00" , "event_type": "ping", "value": 4.73 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:ea:4f: - New record : { "boat_id": 2, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 108, "event_date": "2016-02-03T08:55:02-00:00" , "event_type": "ping", "value": 20.37 },{ "device_id": 107, "event_date": "2016-02-03T08:55:02-00:00" , "event_type": "ping", "value": 0 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:f9:32:ea: - New record : { "boat_id": 12, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 135, "event_date": "2016-02-03T08:55:31-00:00" , "event_type": "ping", "value": 0 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
5c:cf:7f:01:6a:22: - New record : { "boat_id": 11, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 121, "event_date": "2016-02-03T08:55:46-00:00" , "event_type": "ping", "value": 27.69 },{ "device_id": 122, "event_date": "2016-02-03T08:55:46-00:00" , "event_type": "ping", "value": 54 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:e1:b5: - New record : { "boat_id": 3, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 103, "event_date": "2016-02-03T08:55:52-00:00" , "event_type": "ping", "value": 25.56 },{ "device_id": 102, "event_date": "2016-02-03T08:55:52-00:00" , "event_type": "ping", "value": 0 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:e4:37: - New record : { "boat_id": 3, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 42, "event_date": "2016-02-03T08:55:59-00:00" , "event_type": "ping", "value": 15.66 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:e2:cc: - New record : { "boat_id": 7, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 83, "event_date": "2016-02-03T08:55:59-00:00" , "event_type": "ping", "value": 4.44 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:ea:4f: - New record : { "boat_id": 2, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 108, "event_date": "2016-02-03T08:56:19-00:00" , "event_type": "ping", "value": 20.35 },{ "device_id": 107, "event_date": "2016-02-03T08:56:19-00:00" , "event_type": "ping", "value": 0 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:f9:32:ea: - New record : { "boat_id": 12, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 135, "event_date": "2016-02-03T08:56:40-00:00" , "event_type": "ping", "value": 0 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:e1:2a: - New record : { "boat_id": 7, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 89, "event_date": "2016-02-03T08:56:42-00:00" , "event_type": "ping", "value": -13.88 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:e1:b5: - New record : { "boat_id": 3, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 103, "event_date": "2016-02-03T08:57:01-00:00" , "event_type": "ping", "value": 25.56 },{ "device_id": 102, "event_date": "2016-02-03T08:57:01-00:00" , "event_type": "ping", "value": 0 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:e2:cc: - New record : { "boat_id": 7, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 83, "event_date": "2016-02-03T08:57:07-00:00" , "event_type": "ping", "value": 4.16 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:e4:37: - New record : { "boat_id": 3, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 42, "event_date": "2016-02-03T08:57:15-00:00" , "event_type": "ping", "value": 15.66 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:ea:4f: - New record : { "boat_id": 2, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 108, "event_date": "2016-02-03T08:57:36-00:00" , "event_type": "ping", "value": 20.34 },{ "device_id": 107, "event_date": "2016-02-03T08:57:36-00:00" , "event_type": "ping", "value": 0 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:f9:32:ea: - New record : { "boat_id": 12, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 135, "event_date": "2016-02-03T08:57:48-00:00" , "event_type": "ping", "value": 0 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
5c:cf:7f:01:6b:c6: - New record : { "boat_id": 7, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 87, "event_date": "2016-02-03T08:58:00-00:00" , "event_type": "ping", "value": 2.36 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:e1:b5: - New record : { "boat_id": 3, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 103, "event_date": "2016-02-03T08:58:10-00:00" , "event_type": "ping", "value": 25.56 },{ "device_id": 102, "event_date": "2016-02-03T08:58:10-00:00" , "event_type": "ping", "value": 0 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:e2:cc: - New record : { "boat_id": 7, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 83, "event_date": "2016-02-03T08:58:15-00:00" , "event_type": "ping", "value": 4.08 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:e4:37: - New record : { "boat_id": 3, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 42, "event_date": "2016-02-03T08:58:32-00:00" , "event_type": "ping", "value": 15.64 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:ea:4f: - New record : { "boat_id": 2, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 108, "event_date": "2016-02-03T08:58:52-00:00" , "event_type": "ping", "value": 20.32 },{ "device_id": 107, "event_date": "2016-02-03T08:58:52-00:00" , "event_type": "ping", "value": 0 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:ea:4f: After end of Amazon : 
18:fe:34:dc:ea:4f: In Westlakelab : 
18:fe:34:f9:32:ea: - New record : { "boat_id": 12, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 135, "event_date": "2016-02-03T08:58:57-00:00" , "event_type": "ping", "value": 0 }] }
in amazon 1 
in amazon 2 
in amazon 3 
18:fe:34:dc:e1:2a: - New record : { "boat_id": 7, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 89, "event_date": "2016-02-03T08:58:57-00:00" , "event_type": "ping", "value": -13.91 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:f9:32:ea: After end of Amazon : 
'{ "boat_id": 12, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 135, "event_date": "2016-02-03T08:58:57-00:00" , "event_type": "ping", "value": 0 }] }'
INSERT INTO  `boatauto_test`.`NewDevices` (
`boatid` ,
`macid` ,
`deviceid1` ,
`deviceid2` ,
`deviceid3` ,
`deviceid4` ,
`deviceid5` ,
`deviceid6` ,
`deviceid7` ,
`deviceid8` ,
`deviceid9` ,
`value1` ,
`value2` ,
`value3` ,
`volts` ,
`button` ,
`pump1` ,
`pump2` ,
`pump3` ,
`ipaddress` ,
`signalst` ,
`freq` ,
`rebootfreq` , 
`env` ,
`datatopost` ,
`server_outputA` ,
`server_outputW` 
)
VALUES (
CONVERT(12, UNSIGNED) ,'18:fe:34:f9:32:ea:' , CONVERT(0, UNSIGNED), CONVERT(135, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 0.00,   0.00,   0.00,   0.00,  0,  0,  0,  0,  
'192.168.1.34',  73, 60, 999 , 'A', '{ "boat_id": 12, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 135, "event_date": "2016-02-03T08:58:57-00:00" , "event_type": "ping", "value": 0 }] }', '{"success":true,"errors":[],"token":"3f1bfdcb45"}', ''
)
in amazon 4 
18:fe:34:dc:e1:2a: After end of Amazon : 
18:fe:34:dc:e1:b5: - New record : { "boat_id": 3, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 103, "event_date": "2016-02-03T08:59:19-00:00" , "event_type": "ping", "value": 25.56 },{ "device_id": 102, "event_date": "2016-02-03T08:59:19-00:00" , "event_type": "ping", "value": 0 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:e1:b5: After end of Amazon : 
18:fe:34:dc:e2:cc: - New record : { "boat_id": 7, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 83, "event_date": "2016-02-03T08:59:23-00:00" , "event_type": "ping", "value": 4.05 }] }
in amazon 1 
in amazon 2 
in amazon 3 
in amazon 4 
18:fe:34:dc:e2:cc: After end of Amazon :