ChuckBell / MySQL_Connector_Arduino

Database connector library for using MySQL with your Arduino projects.
332 stars 133 forks source link

Not working on ESP32 #64

Closed SHIINA96 closed 5 years ago

SHIINA96 commented 5 years ago

I'm trying to run your code on my ESP32 Dev Module, and I can't compile the code. Here is what I get from the IDE

Arduino: 1.8.7 (Mac OS X), Board: "ESP32 Dev Module, Disabled, Default, QIO, 80MHz, 4MB (32Mb), 921600, None"

Wrote 612256 bytes (369701 compressed) at 0x00010000 in 6.2 seconds (effective 786.1 kbit/s)... Hash of data verified. Compressed 3072 bytes to 144...

Writing at 0x00008000... (100 %) Wrote 3072 bytes (144 compressed) at 0x00008000 in 0.0 seconds (effective 1527.6 kbit/s)... Hash of data verified.

Leaving... Hard resetting via RTS pin... /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.cpp: In static member function 'static uint16_t W5100Class::write(uint16_t, const uint8_t, uint16_t)': /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.cpp:315:22: error: no matching function for call to 'SPIClass::transfer(uint8_t [8], int)' SPI.transfer(cmd, 4); ^ In file included from /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.h:18:0, from /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.cpp:13: /Users/barney/Documents/Arduino/hardware/espressif/esp32/libraries/SPI/src/SPI.h:69:13: note: candidate: uint8_t SPIClass::transfer(uint8_t) uint8_t transfer(uint8_t data); ^ /Users/barney/Documents/Arduino/hardware/espressif/esp32/libraries/SPI/src/SPI.h:69:13: note: candidate expects 1 argument, 2 provided /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.cpp:369:29: error: no matching function for call to 'SPIClass::transfer(uint8_t [8], int)' SPI.transfer(cmd, len + 3); ^ In file included from /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.h:18:0, from /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.cpp:13: /Users/barney/Documents/Arduino/hardware/espressif/esp32/libraries/SPI/src/SPI.h:69:13: note: candidate: uint8_t SPIClass::transfer(uint8_t) uint8_t transfer(uint8_t data); ^ /Users/barney/Documents/Arduino/hardware/espressif/esp32/libraries/SPI/src/SPI.h:69:13: note: candidate expects 1 argument, 2 provided /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.cpp:371:23: error: no matching function for call to 'SPIClass::transfer(uint8_t [8], int)' SPI.transfer(cmd, 3); ^ In file included from /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.h:18:0, from /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.cpp:13: Multiple libraries were found for "WiFi.h" Used: /Users/barney/Documents/Arduino/hardware/espressif/esp32/libraries/WiFi Not used: /Users/barney/Documents/Arduino/libraries/WiFi Not used: /Applications/Arduino.app/Contents/Java/libraries/WiFi /Users/barney/Documents/Arduino/hardware/espressif/esp32/libraries/SPI/src/SPI.h:69:13: note: candidate: uint8_t SPIClass::transfer(uint8_t) uint8_t transfer(uint8_t data); ^ /Users/barney/Documents/Arduino/hardware/espressif/esp32/libraries/SPI/src/SPI.h:69:13: note: candidate expects 1 argument, 2 provided /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.cpp: In static member function 'static uint16_t W5100Class::read(uint16_t, uint8_t, uint16_t)': /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.cpp:416:22: error: no matching function for call to 'SPIClass::transfer(uint8_t [4], int)' SPI.transfer(cmd, 4); ^ In file included from /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.h:18:0, from /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.cpp:13: /Users/barney/Documents/Arduino/hardware/espressif/esp32/libraries/SPI/src/SPI.h:69:13: note: candidate: uint8_t SPIClass::transfer(uint8_t) uint8_t transfer(uint8_t data); ^ /Users/barney/Documents/Arduino/hardware/espressif/esp32/libraries/SPI/src/SPI.h:69:13: note: candidate expects 1 argument, 2 provided /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.cpp:418:24: error: no matching function for call to 'SPIClass::transfer(uint8_t&, uint16_t&)' SPI.transfer(buf, len); ^ In file included from /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.h:18:0, from /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.cpp:13: /Users/barney/Documents/Arduino/hardware/espressif/esp32/libraries/SPI/src/SPI.h:69:13: note: candidate: uint8_t SPIClass::transfer(uint8_t) uint8_t transfer(uint8_t data); ^ /Users/barney/Documents/Arduino/hardware/espressif/esp32/libraries/SPI/src/SPI.h:69:13: note: candidate expects 1 argument, 2 provided /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.cpp:460:22: error: no matching function for call to 'SPIClass::transfer(uint8_t [4], int)' SPI.transfer(cmd, 3); ^ In file included from /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.h:18:0, from /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.cpp:13: /Users/barney/Documents/Arduino/hardware/espressif/esp32/libraries/SPI/src/SPI.h:69:13: note: candidate: uint8_t SPIClass::transfer(uint8_t) uint8_t transfer(uint8_t data); ^ /Users/barney/Documents/Arduino/hardware/espressif/esp32/libraries/SPI/src/SPI.h:69:13: note: candidate expects 1 argument, 2 provided /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.cpp:462:24: error: no matching function for call to 'SPIClass::transfer(uint8_t&, uint16_t&)' SPI.transfer(buf, len); ^ In file included from /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.h:18:0, from /Applications/Arduino.app/Contents/Java/libraries/Ethernet/src/utility/w5100.cpp:13: /Users/barney/Documents/Arduino/hardware/espressif/esp32/libraries/SPI/src/SPI.h:69:13: note: candidate: uint8_t SPIClass::transfer(uint8_t) uint8_t transfer(uint8_t data); ^ /Users/barney/Documents/Arduino/hardware/espressif/esp32/libraries/SPI/src/SPI.h:69:13: note: candidate expects 1 argument, 2 provided exit status 1 Error compiling for board ESP32 Dev Module.

This report would have more information with "Show verbose output during compilation" option enabled in File -> Preferences.

Any help appreciated.

sand007man commented 5 years ago

Try to swap the referrence of ethernet.h in Packet.h to WiFi.h.

SHIINA96 commented 5 years ago

It works but causes by the silly enterprise wifi, I gonna try it later.

sand007man commented 5 years ago

OK do let me Know once it is Working, even i am working with esp 32 :)

SHIINA96 commented 5 years ago

Hi, I meet a new problem When I try to connect wifi, then monitor will print "Couldn't get a wifi connection" I checked the SSID or password, they both fine But when I upload others project which also using WiFi.h, the ESP32 connected to wifi successfully Any help?

ChuckBell commented 5 years ago

That isn’t a message from the connector. That appears to be from the ESP WiFi library. Be sure to check for conflicts and ensure you’ve modified the connector header file correctly.

On Oct 11, 2018, at 4:21 AM, SHIINA96 notifications@github.com wrote:

Hi, I meet a new problem When I try to connect wifi, then monitor will print "�Couldn't get a wifi connection" I checked the SSID or password, they both fine But when I upload others project which also using WiFi.h, the ESP32 connected to wifi successfully Any help?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

SHIINA96 commented 5 years ago

I found that the variable ' statue ' didn't work properly. After I changed the whole WiFi connection part, the problem was fixed.