search

ChuckBell / MySQL_Connector_Arduino

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

No connection on Arduino Due and Wiznet550io #17

Closed asetyde closed 6 years ago

asetyde commented 7 years ago

I’ve problem using Wiznet modify ethernet library for Wiz550io, all same code work on esp and Arduino , but on this board and with this library not , I never see an error code , only cannot connect as you can see it Something to debug ? schermata 2017-06-01 alle 20 11 16

I can't debug because error is on connect function , I suspect something miss in ethernet wiz modificate library

schermata 2017-06-08 alle 12 07 29

If someone can help me , or try to test it , I use ide 1.6.5 and last realese of this connector I tag Wiznet library contributor because isn't possibile create an issue @arjenhiemstra @jbkim @wardweistra @per1234

jbkim commented 7 years ago

Try to check below. 1) If 192.168.1.127 is a static IP address, check the ping reply from your PC. It there is no ping reply, check the hardware & cable connection. 2) If 192.168.1.127 is a dynamic IP address getting from DHCP server, the hardware connection is ok, so you need to debug the code.

asetyde commented 6 years ago

Hi , it's wiznet library , with enj8x library or w5100 library all ok . I suppose it's not update as arduino and connector libraries

asetyde commented 6 years ago

https://github.com/embeddist/WIZ_Ethernet_Library-IDE1.6.x/issues/3

OpusK commented 6 years ago

Hi, @asetyde WIZ550io uses W5500 chip. This is the chip used in Arduino Ethernet Shield2, and Arduino officially provides a library called Ethernet2.

Have you tried using this library?

asetyde commented 6 years ago

yes but it seems not work with this connector mysql , someone can try ?

asetyde commented 6 years ago

Hi @ChuckBell @OpusK , at now I think problem it comes between Ethernet2 library and Mysql connector , can you try this library ? https://github.com/adafruit/Ethernet2

asetyde commented 6 years ago

it'unique updated and support wiznet module

ChuckBell commented 6 years ago

No. The connector does not use any method to get the mac address. The mac address is provided to the connector via the constructor:

Ethernet.begin(mac_addr);

On Sep 8, 2017, at 5:50 AM, Alexandro Todeschini notifications@github.com wrote:

I think problem is localized on macaddress , get Mac . It's used from connector ?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/17#issuecomment-328059081, or mute the thread https://github.com/notifications/unsubscribe-auth/AH0j4F806roh037cIs5TMxOHDh6lAl58ks5sgQ3TgaJpZM4Nz3ZA.

asetyde commented 6 years ago

Hi Doctor Bell , now I try to find differences in library Ethernet with Ethernet2 , in particular on EthernetClient , I think it can be in this class

Alexandro Todeschini

Develop & Research Domotics Division +393351881688 - Skype : ElectricLabs alexandro.todeschini@electriclabs.it

Il giorno 08 set 2017, alle ore 15:02, Dr. Charles Bell notifications@github.com ha scritto:

No. The connector does not use any method to get the mac address. The mac address is provided to the connector via the constructor:

Ethernet.begin(mac_addr);

On Sep 8, 2017, at 5:50 AM, Alexandro Todeschini notifications@github.com wrote:

I think problem is localized on macaddress , get Mac . It's used from connector ?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/17#issuecomment-328059081, or mute the thread https://github.com/notifications/unsubscribe-auth/AH0j4F806roh037cIs5TMxOHDh6lAl58ks5sgQ3TgaJpZM4Nz3ZA.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/17#issuecomment-328097083, or mute the thread https://github.com/notifications/unsubscribe-auth/AF4G6B5jX_doZ5-pAileUoSJQmQtcrcKks5sgTrKgaJpZM4Nz3ZA.

asetyde commented 6 years ago

Probably someone go wrong on ok of connection ...

Alexandro Todeschini

Develop & Research Domotics Division +393351881688 - Skype : ElectricLabs alexandro.todeschini@electriclabs.it

Il giorno 08 set 2017, alle ore 15:02, Dr. Charles Bell notifications@github.com ha scritto:

No. The connector does not use any method to get the mac address. The mac address is provided to the connector via the constructor:

Ethernet.begin(mac_addr);

On Sep 8, 2017, at 5:50 AM, Alexandro Todeschini notifications@github.com wrote:

I think problem is localized on macaddress , get Mac . It's used from connector ?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/17#issuecomment-328059081, or mute the thread https://github.com/notifications/unsubscribe-auth/AH0j4F806roh037cIs5TMxOHDh6lAl58ks5sgQ3TgaJpZM4Nz3ZA.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/17#issuecomment-328097083, or mute the thread https://github.com/notifications/unsubscribe-auth/AF4G6B5jX_doZ5-pAileUoSJQmQtcrcKks5sgTrKgaJpZM4Nz3ZA.

asetyde commented 6 years ago

INSERT data work , GET not !! Strange !!

Alexandro Todeschini

Develop & Research Domotics Division +393351881688 - Skype : ElectricLabs alexandro.todeschini@electriclabs.it

Il giorno 08 set 2017, alle ore 15:02, Dr. Charles Bell notifications@github.com ha scritto:

No. The connector does not use any method to get the mac address. The mac address is provided to the connector via the constructor:

Ethernet.begin(mac_addr);

On Sep 8, 2017, at 5:50 AM, Alexandro Todeschini notifications@github.com wrote:

I think problem is localized on macaddress , get Mac . It's used from connector ?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/17#issuecomment-328059081, or mute the thread https://github.com/notifications/unsubscribe-auth/AH0j4F806roh037cIs5TMxOHDh6lAl58ks5sgQ3TgaJpZM4Nz3ZA.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/17#issuecomment-328097083, or mute the thread https://github.com/notifications/unsubscribe-auth/AF4G6B5jX_doZ5-pAileUoSJQmQtcrcKks5sgTrKgaJpZM4Nz3ZA.

ChuckBell commented 6 years ago

Please PM me your sketch and any output from the serial monitor.

On Sep 8, 2017, at 11:53 AM, Alexandro Todeschini notifications@github.com wrote:

INSERT data work , GET not !! Strange !!

Alexandro Todeschini

Develop & Research Domotics Division +393351881688 - Skype : ElectricLabs alexandro.todeschini@electriclabs.it

Il giorno 08 set 2017, alle ore 15:02, Dr. Charles Bell notifications@github.com ha scritto:

No. The connector does not use any method to get the mac address. The mac address is provided to the connector via the constructor:

Ethernet.begin(mac_addr);

On Sep 8, 2017, at 5:50 AM, Alexandro Todeschini notifications@github.com wrote:

I think problem is localized on macaddress , get Mac . It's used from connector ?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/17#issuecomment-328059081, or mute the thread https://github.com/notifications/unsubscribe-auth/AH0j4F806roh037cIs5TMxOHDh6lAl58ks5sgQ3TgaJpZM4Nz3ZA.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/17#issuecomment-328097083, or mute the thread https://github.com/notifications/unsubscribe-auth/AF4G6B5jX_doZ5-pAileUoSJQmQtcrcKks5sgTrKgaJpZM4Nz3ZA.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/17#issuecomment-328142289, or mute the thread https://github.com/notifications/unsubscribe-auth/AH0j4J-KnMQmv4ZtwcNLisQDK_qRQYz2ks5sgWLngaJpZM4Nz3ZA.

asetyde commented 6 years ago

OUTPUT :

Opening port Port open --------- | ZEUS START | ---------

--- | EEPROM check integrity : | --- ok check integrity

--- | EEPROM first config : | --- codeRunningForTheFirstTime: yes

RebootM Attention: Reboot Machine 0.00 --------- | ZEUS START | ---------

--- | EEPROM check integrity : | --- ok check integrity

--- | EEPROM first config : | --- codeRunningForTheFirstTime: no ################## LOAD FLASH EEPROM ##################

--- | WhatchDogOn | ---

SizeOf: 26360.00 --- | Connecting with DHCP | ---

--- | Start UDP Server | ---

--- | Server UDP up 9666 9555 9444 | ---

Version: 2.0-Zeusv2

Size struct :26360.00

RAM : My guess at free mem: 61264

IP: 192.168.1.110 Gatway: 192.168.1.1 Ethernet: 00:08:dc:50:b4:46

MANUAL-MODE PUT NEW DATA ON MYSQL - ISYNC

Start iamaliveSQLforecast! Trying connect. iamaliveSQLforecast - Cannot reconnect! Drat. End iamaliveSQLforecast!

Start putalldataSQLforecast! Trying connect. Cannot reconnect! Drat. end putalldataSQLforecast!

Start putChannelMSQ! setChannelMSQ - Cannot reconnect! Drat. End putChannelMSQ!

Start putActMYSQ! None done , 0 action putActMYSQ!

We done, 0.00 action putActMYSQ! End putActMYSQ!

Ended load data Close Setup Zeus_Device

Alexandro Todeschini

Develop & Research Domotics Division +393351881688 - Skype : ElectricLabs alexandro.todeschini@electriclabs.it

Il giorno 08 set 2017, alle ore 18:03, Dr. Charles Bell notifications@github.com ha scritto:

Please PM me your sketch and any output from the serial monitor.

On Sep 8, 2017, at 11:53 AM, Alexandro Todeschini notifications@github.com wrote:

INSERT data work , GET not !! Strange !!

Alexandro Todeschini

Develop & Research Domotics Division +393351881688 - Skype : ElectricLabs alexandro.todeschini@electriclabs.it

Il giorno 08 set 2017, alle ore 15:02, Dr. Charles Bell notifications@github.com ha scritto:

No. The connector does not use any method to get the mac address. The mac address is provided to the connector via the constructor:

Ethernet.begin(mac_addr);

On Sep 8, 2017, at 5:50 AM, Alexandro Todeschini notifications@github.com wrote:

I think problem is localized on macaddress , get Mac . It's used from connector ?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/17#issuecomment-328059081, or mute the thread https://github.com/notifications/unsubscribe-auth/AH0j4F806roh037cIs5TMxOHDh6lAl58ks5sgQ3TgaJpZM4Nz3ZA.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/17#issuecomment-328097083, or mute the thread https://github.com/notifications/unsubscribe-auth/AF4G6B5jX_doZ5-pAileUoSJQmQtcrcKks5sgTrKgaJpZM4Nz3ZA.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/17#issuecomment-328142289, or mute the thread https://github.com/notifications/unsubscribe-auth/AH0j4J-KnMQmv4ZtwcNLisQDK_qRQYz2ks5sgWLngaJpZM4Nz3ZA.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/17#issuecomment-328145011, or mute the thread https://github.com/notifications/unsubscribe-auth/AF4G6GXB4qE1tDrk0o3_v_VHAljwB-0Yks5sgWVLgaJpZM4Nz3ZA.

asetyde commented 6 years ago

Resolved , wiznet upgraded library and now it works