ChuckBell / MySQL_Connector_Arduino

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

Compile error when combining AsyncMttClient with mySQL #56

Closed topdancer closed 6 years ago

topdancer commented 6 years ago

Hi,

I am struggling with combining MQTT with mySQL connector into a ESP8266 sketch.

I am starting with the „FullyFeatured-ESP8266“ example coming with the „AsyncMqttClient“ library from Marvin Roger, see here on Github: https://github.com/marvinroger/async-mqtt-client.

I can compile it without any error.

When I add:

include

include

the compiler throws a compile error:

„In file included from /Applications/Arduino.app/Contents/Java/libraries/WiFi/src/utility/wifi_drv.h:26:0, from /Applications/Arduino.app/Contents/Java/libraries/WiFi/src/WiFiUdp.cpp:26: /Documents/Arduino/hardware/esp8266com/esp8266/libraries/ESP8266WiFi/src/WiFiUdp.h:28:0: note: this is the location of the previous definition

define UDP_TX_PACKET_MAX_SIZE 8192

^ In file included from /Applications/Arduino.app/Contents/Java/libraries/WiFi/src/WiFiUdp.cpp:29:0: /Applications/Arduino.app/Contents/Java/libraries/WiFi/src/WiFiUdp.h:27:7: error: redefinition of 'class WiFiUDP' class WiFiUDP : public UDP { ^ In file included from /Applications/Arduino.app/Contents/Java/libraries/WiFi/src/utility/wifi_drv.h:26:0, from /Applications/Arduino.app/Contents/Java/libraries/WiFi/src/WiFiUdp.cpp:26: /Documents/Arduino/hardware/esp8266com/esp8266/libraries/ESP8266WiFi/src/WiFiUdp.h:32:7: error: previous definition of 'class WiFiUDP' class WiFiUDP : public UDP, public SList {„

and more errors …

MySQL_Packet.h refers to the library (contained in Arduino IDE) which seems to conflict with library, both containing a WiFiUDP.h file. Removing the WiFi library from Arduino IDE creates additional errors.

How can I resolve this issue?

Any hint is welcome.

Thanks, Kurt

topdancer commented 6 years ago

I am just seeing that exactly the same happens with the "mqtt-ESP8266" example from the well known PubSubClient library.

ChuckBell commented 6 years ago

Have you tried changing the include file in the connector? That usually solves the problem.

On Thu, Jul 19, 2018 at 10:07 topdancer notifications@github.com wrote:

I am just seeing that exactly the same happens with the "mqtt-ESP8266" example from the well known PubSubClient library.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/56#issuecomment-406288501, or mute the thread https://github.com/notifications/unsubscribe-auth/AH0j4IARmtISTwCQRohUTC6gVRwvUHSaks5uIJKNgaJpZM4VWdF4 .

topdancer commented 6 years ago

Thanks, Chuck, this solved my issue.