Papaille
commented
6 years ago include
include
include
include
include
include
include
include
include
include
include
include
include
define RREF 430.0
const byte SENSOR_ADDRESS_1[] = { 0x28, 0xFF, 0x75, 0x19, 0xC1, 0x16, 0x04, 0x83 }; const byte SENSOR_ADDRESS_2[] = { 0x28, 0xFF, 0x4F, 0xCC, 0xB4, 0x16, 0x05, 0xBE }; const char INSERT_DATA[] = "INSERT INTO domotic.test(id_device,value) VALUES (%s, %s)";
// L'adresse MAC du shield byte mac[] = { 0x90, 0xA2, 0xDA, 0x0E, 0xA5, 0x7E };
EthernetClient client; EthernetServer serveur(80);
OneWire ds(22);
MySQL_Connection sql_conn((Client *)&client); IPAddress db_addr(192,168,0,103); Adafruit_MAX31865 pt100 = Adafruit_MAX31865(23);
char user[] = "heatdom"; char password[] = "heatdom";
long prevtime = 0; long interval = 10000; float temperature[3];
void setup() {
Serial.begin(115200);
int DHCP = 0;
DHCP = Ethernet.begin(mac);
if (!DHCP) {
Serial.println("DHCP echoue");
return;
}
Serial.println("Adressage par DHCP OK.");
serveur.begin();
client.setTimeout(100);
pt100.begin(MAX31865_3WIRE);}
void loop() {
client = serveur.available();
if (client) {
if (client.connected()) {
webrequest();
}
}
if (millis() - prevtime > interval) {
acquistemp();
insertobdd();
prevtime = millis();
}}
void acquistemp() { Serial.println("Acquisition des temperatures...");
temperature[0] = getTemperature(SENSOR_ADDRESS_1);
temperature[1] = getTemperature(SENSOR_ADDRESS_2);
temperature[2] = pt100.temperature(100, RREF);}
void webrequest() {
while (client.available()) {
char c = client.read();
Serial.write(c);
}
client.println("HTTP/1.1 200 OK");
client.println("Content-Type: application/json");
client.println("Connection: close");
client.println();
client.println("{");
client.print("\t\"uptime\": ");
client.print(millis());
client.println(",");
client.print("\t\"temperature 1\": ");
client.print(temperature[0], 2);
client.println(",");
client.print("\t\"temperature 2\": ");
client.print(temperature[1], 2);
client.println(",");
client.print("\t\"temperature 3\": ");
client.print(temperature[2], 2);
client.println();
client.println("}");
client.flush();
client.stop();
Serial.println("Client deconnecte");}
void insertobdd() { Serial.println("Connection base de donnees Domotic ..."); if (sql_conn.connect(db_addr, 3306, user, password)) { delay(1000); for (int i = 0; i < 3; i++) { MySQL_Cursor *cur_mem = new MySQL_Cursor(&sql_conn); char query[128]; char tempstr[4]; char id[1]; dtostrf(temperature[i], 1, 2, tempstr); dtostrf(i + 1, 1, 0, id); sprintf(query, INSERT_DATA, id, tempstr); cur_mem->execute(query); delete cur_mem; } } else Serial.println("Connection echouee."); sql_conn.close(); }###
ChuckBell
ed-lab
Hello,
I'm using MySQL_Connector_Arduino, it's working fine on MEGA 2560 with ethernet shield W5100, thanks for this library. The aim of this project is to measure some different temperatures and store it in database. But my Arduino runs at the same as EthernetServer, to send a JSON file with temperature value to client connected. When I check if there is a client making a request, the Arduino reboot. Why ? Memory problem ?
If I delete the server code, all works fine. If I delete the MySQL code, the server part works fine.
Thanks in advance.