Guten Tag zusammen,
ich bekomme beim folgenden Sketch eine mögliche Fehlermeldung vom Nodemcu.
Der Nodemcu startet immer wieder neu , anscheinend hängt er irgendwo.
//Konfiguration für die Datenbank
IPAddress server_addr(); // IP of the MySQL *server* here
char user[] = ""; // MySQL user login username
char* passwordDB = " ";
char* DB = "Wetterdaten";
char query[128];
char temperature[10];
WiFiClient client;
MySQL_Connection conn(&client);
MySQL_Cursor* cursor;
void setup() {
Serial.begin(115200);
WiFi.mode(WIFI_STA);
WiFi.begin(ssid, password);
Serial.println("");
// Wait for connection
while (WiFi.status() != WL_CONNECTED) {
delay(500);
Serial.print(".");
}
Serial.println("");
Serial.print("Connected to ");
Serial.println(ssid);
Serial.print("IP address: ");
Serial.println(WiFi.localIP());
mlx.begin();
// create MySQL cursor object
cursor = new MySQL_Cursor(&conn);
Serial.println("DB - Connecting...");
while (conn.connect(server_addr, 3306, user, passwordDB) != true) {
delay(500);
Serial.print ( "." );
}
}
void saveTempData() {
Serial.print("Sky-Temp: ");
Serial.println(mlx.readObjectTempC());
Serial.print("Temp: ");
Serial.println(bme.readTemperature());
//dtostrf(mlx.readObjectTempC(), 2, 2, temperature);
sprintf(query, "INSERT INTO Wetterdaten.wetterwerte (Himmelstemperatur) VALUES (%f)",mlx.readObjectTempC());
cursor->execute(query);
delete cursor;
conn.close();
}
void loop() {
delay(2000);
saveTempData();
}
[code]
20:59:14.768 -> <<<stack<<<
20:59:14.768 ->
20:59:14.768 -> ets Jan 8 2013,rst cause:2, boot mode:(3,6)
20:59:14.768 ->
20:59:14.768 -> load 0x4010f000, len 3456, room 16
20:59:14.768 -> tail 0
20:59:14.768 -> chksum 0x84
20:59:14.768 -> csum 0x84
20:59:14.768 -> va5432625
20:59:14.768 -> ~ld
[/code]