-
Notifications
You must be signed in to change notification settings - Fork 132
Open
Description
Hello.
I'm trying to use one of your example codes to connect to a database via WiFi
The example code is this:
https://github.com/ChuckBell/MySQL_Connector_Arduino/blob/master/examples/connect_wifi/connect_wifi.ino
but with some minor changes.
/*
MySQL Connector/Arduino Example : connect by wifi
This example demonstrates how to connect to a MySQL server from an
Arduino using an Arduino-compatible Wifi shield. Note that "compatible"
means it must conform to the Ethernet class library or be a derivative
with the same classes and methods.
For more information and documentation, visit the wiki:
https://github.com/ChuckBell/MySQL_Connector_Arduino/wiki.
INSTRUCTIONS FOR USE
1) Change the address of the server to the IP address of the MySQL server
2) Change the user and password to a valid MySQL user and password
3) Change the SSID and pass to match your WiFi network
4) Connect a USB cable to your Arduino
5) Select the correct board and port
6) Compile and upload the sketch to your Arduino
7) Once uploaded, open Serial Monitor (use 115200 speed) and observe
If you do not see messages indicating you have a connection, refer to the
manual for troubleshooting tips. The most common issues are the server is
not accessible from the network or the user name and password is incorrect.
Note: The MAC address can be anything so long as it is unique on your network.
Created by: Dr. Charles A. Bell
*/
#include <WiFi.h> // Use this for WiFi instead of Ethernet.h
#include <MySQL_Connection.h>
#include <MySQL_Cursor.h>
IPAddress server_addr(111,1111,111,111); // IP of the MySQL *server* here <-- dummy IP
char user[] = "root"; // MySQL user login username
char password[] = "rootdummypassword"; // MySQL user login password
// WiFi card example
const char *ssid = "My_WiFi"; // your SSID
const char *pass = "my-password"; // your SSID Password
WiFiClient client; // Use this for WiFi instead of EthernetClient
MySQL_Connection conn((Client *)&client);
void setup() {
Serial.begin(115200);
// while (!Serial); // wait for serial port to connect. Needed for Leonardo only
// Begin WiFi section
WiFi.mode(WIFI_STA);
WiFi.begin(ssid, pass);
Serial.println("Connectiing to WiFi");
unsigned long start_time = millis();
const unsigned long timeout = 20000;
while(WiFi.status() != WL_CONNECTED && (millis() - start_time) < timeout){
delay(500);
Serial.print(".");
}
if (WiFi.status() == WL_CONNECTED){
Serial.println("\nConnected to WiFi!");
Serial.print("IP address: ");
Serial.println(WiFi.localIP());
} else {
Serial.println("\nFailed to connect to WiFi.");
}
// End WiFi section
Serial.println("Connecting...");
if (conn.connect(server_addr, 3306, user, password)) {
delay(1000);
Serial.println("Connected to database!");
}
else
Serial.println("Connection failed.");
conn.close();
}
void loop() {
}
This is what I get in my serial monitor:
IP address: 192.168.1.129
Connecting...
...trying...
Write(uint8_t) called with data: 61
Current byteCount: 1
Write(uint8_t) completed
Guru Meditation Error: Core 1 panic'ed (LoadProhibited). Exception was unhandled.
Core 1 register dump:
PC : 0x400d5beb PS : 0x00060930 A0 : 0x800d5c5f A1 : 0x3ffb2050
A2 : 0x0000001a A3 : 0x00000080 A4 : 0x0000000a A5 : 0xfffffffd
A6 : 0xb33fffff A7 : 0xb33fffff A8 : 0x800d6b34 A9 : 0x3ffb2030
A10 : 0x00000002 A11 : 0x3f404234 A12 : 0x00000018 A13 : 0x0000ff00
A14 : 0x00ff0000 A15 : 0xff000000 SAR : 0x00000010 EXCCAUSE: 0x0000001c
EXCVADDR: 0x00000062 LBEG : 0x40089d51 LEND : 0x40089d61 LCOUNT : 0xffffffff
Backtrace: 0x400d5be8:0x3ffb2050 0x400d5c5c:0x3ffb2070 0x400d5c51:0x3ffb2090 0x40160dbf:0x3ffb20b0 0x400d6b0b:0x3ffb20d0 0x400d6b1d:0x3ffb20f0 0x400d5f1a:0x3ffb2110 0x400d6029:0x3ffb21a0 0x400d5a7d:0x3ffb21d0 0x400d28c4:0x3ffb2220 0x400d8203:0x3ffb2270 0
ELF file SHA256: 50ce9256bdb3c688
Rebooting...
Any thing I can do to try to figure out what is happening?
Metadata
Metadata
Assignees
Labels
No labels