Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ESP32-WROVER-E rebooting when attempting to connect to database #241

Open
PsySc0rpi0n opened this issue Nov 25, 2024 · 0 comments
Open

ESP32-WROVER-E rebooting when attempting to connect to database #241

PsySc0rpi0n opened this issue Nov 25, 2024 · 0 comments

Comments

@PsySc0rpi0n
Copy link

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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant