i have ardruino wifi rev 2 and i've downloaded the latest MySQL_Connector_Arduino library
my server PC has static ip 192.168.1.2 with the latest mysql installed
my system is arch linux x86_64 with the latest kernel
#include <SPI.h>
#include <WiFiNINA.h>
#include <MySQL_Connection.h>
#include <MySQL_Cursor.h>
byte mac_addr[] = { 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED };
IPAddress ip(192,168,1,130);
IPAddress server_addr(192,168,1,2); // IP of the MySQL *server* here
char user[] = "root"; // MySQL user login username
char password[] = "***"; // MySQL user login password
// WiFi card example
char ssid[] = "WeatherPi"; // your SSID
char pass[] = "***"; // your SSID Password
WiFiClient client; // Use this for WiFi instead of EthernetClient
MySQL_Connection conn((Client *)&client);
char INSERT_SQL[] = "INSERT INTO test.data (`num_steps`) VALUES ('4')";
void setup() {
Serial.begin(115200);
while (!Serial); // wait for serial port to connect. Needed for Leonardo only
// Begin WiFi section
int status = WiFi.begin(ssid, pass);
WiFi.config(ip);
if ( status != WL_CONNECTED) {
Serial.println("Couldn't get a wifi connection");
while(true);
}
// print out info about the connection:
else {
Serial.println("Connected to network");
IPAddress ip = WiFi.localIP();
Serial.print("My IP address is: ");
Serial.println(ip);
}
// End WiFi section
Serial.println("Connecting...");
if (conn.connect(server_addr, 3306, user, password)) {
delay(500);
Serial.println("Connection Successfull,inserting to database.");
// Initiate the query class instance
MySQL_Cursor *cur_mem = new MySQL_Cursor(&conn);
// Execute the query
cur_mem->execute(INSERT_SQL);
// Note: since there are no results, we do not need to read any data
// Deleting the cursor also frees up memory used
delete cur_mem;
Serial.println("Query Success!");
}
else
Serial.println("Connection failed.");
conn.close();
}
void loop() {
}
in my server i created a database 'test' with 1 table 'data' and 2 rows 'id' and 'num_steps'
my ardruino is connecting into my network but it freezes when it tries to connect into my database....
is something wrong with my setup or my code?
