Wiz550io , Arduino due , Mysql_connector (arduino ide)

Question

Hi , We want use Wiz550io as hem board on our system for domotics , but we are blocked on connection bug between Arduino due with wiz550io and mysql connector (I cc also him) . For us this module is useful for macaddress stored inside despite enj8260 is more simple and work but not too fast and not have macaddress. I’ve tried with embeddeist library and wiznet official library but something no work and we are not able to find bug, if you can help us we are interested to use and buy a lot od this board , if not we must change to enj8260 Greetings Ref : github.com/embeddist/WIZ_Ethernet_Library-IDE1.6.x ARDUINO DUE + Wiz550io+Mysql_connector issue opened 01:05PM - 17 Jul 17 UTC asetyde https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/17 I’ve proble…m using Wiznet modify ethernet library for Wiz550io, all same code work on esp and Arduino w5100 standard library , but on this board DUE and with this library not , I never see an error code , only cannot connect as you can see it. Also with DUE and EJ82.. it works. Someone can try with this library and mysql connect , ti can be found on arduino library manager github.com/ChuckBell/MySQL_Connector_Arduino No connection on Arduino Due and Wiznet550io opened 10:18AM - 08 Jun 17 UTC closed 01:17PM - 08 Nov 17 UTC asetyde I’ve problem using Wiznet modify ethernet library for Wiz550io, all same code wo…rk 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](https://user-images.githubusercontent.com/6162152/26924029-52106078-4c44-11e7-8c80-e1da0d660c1f.png) 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](https://user-images.githubusercontent.com/6162152/26924134-cd30ff06-4c44-11e7-8fa0-6071e57bd728.png) 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

jim · Answer

Dear asetyde I have a few question for investigation. Which version do you use as Arduino IDE? Do you use ioShield-A or WIZ550io only? http://wizwiki.net/wiki/doku.php?id=osh:ioshield-a:start Thanks.

asetyde · Answer

Arduino DUE is linked as : (I take it but wire is this , we use our custom PCB ) 1541×692 245 KB

asetyde · Answer

Ok but you can try with mysql library ? this is problem , you can install from Arduino ice library

jim · Answer

Mysql is not our support scope. But I have tested that in curiosity. You have to use instead of in MySQL_Packet.h //#include #include Refer to the test result and file. Connecting… Connected to server version 5.5.57-0+deb8u1 Disconnected. Mysql.zip (1.2 KB) Thanks.

asetyde · Answer

I will try again

asetyde · Answer

If you not try with Arduino DUE it’s not a true test

asetyde · Answer

It’s big problem for me , please can you help me

asetyde · Answer

ARDUINO DUE in not assimilate to Arduino uno , there are some issue also with Ethernet2 library , we want use your module but it’s not possibile if not work with Arduino due and this mysql library , first order can be 100 pieces to up , please take a Arduino due and help us

asetyde · Answer

I can send you a Arduino due , we must begin from this , and produce many pieces . I’ve tried with w5100 shield and Arduino ethernet standard library and all go , problem is , I think between Arduino sam and w5500 core , all in ethernet library. Need to be updated

asetyde · Answer

Hi , thank you so much for reply , we need a full working library to work good. We use UDP and mysql connector together and at now ump work so so , mysql no . I send you in private message tracking id of shipment and link with pack test software . We send to you a sample of our product , composed from Arduino due , zeus board , wiz550io . Thanks and we wait

jim · Answer

Hi I receivied your target board. I have tested after code modification. It works fine. I upload my test images and code. Thanks. 20170914_1639514032×3024 2.09 MB packwiz858×952 259 KB packwiz_2876×483 80.7 KB test_mysql_wiz.zip (1.9 KB)

jim · Answer

I attached library files. Thanks. Ethernet2.zip (62.3 KB) MySQL_Connector_Arduino.zip (409.2 KB)

asetyde · Answer

At now work very fast and perfect , your library is quite different to ethernet2 I think . Thanks so much Please , wizen can collaborate with ours to create a unique pub model ? is possible , use address given in private message .Thanks Jim

aix150 · Answer

Arduino UNO + W5500, ethernet2 libs Instruction Works 2017-09-17 (2)1920×1080 282 KB Thank you!

asetyde · Answer

About this library , UDP , si not so stable , after some message sometimes crash , do you have some tips , or trick to receive udp , also 24 UDP packet , is bad few limit

asetyde · Answer

It’s seems not all working perfect , also connection of database and udp has some problems. UDP seems blocked after some messages or after database loading and putting . I think is bad thing use ethernet 2 adafruit , it’s not update , we can not a simple conversion of Arduino ethernet library ? We are safe driver is correctly done of w5500 ? about buffer etc

asetyde · Answer

it seems for example , after loading or putting of mysql connector , udp port not working , after cut power yes , can be wiz not reset ?

asetyde · Answer

i’ve test many times , seems board not reset correctly after … udp not work after a software reboot with wdt. If driver not reset correctly board ?

asetyde · Answer

Some DUE correction on Arduino main library w5100 seems not improved on ethernet2 w5500 , why ? github.com/arduino/Arduino Ethernet: fixed regression for SAM (Arduino Due) committed 05:33PM - 05 Nov 15 UTC cmaglie +19 -19 Fix https://github.com/arduino/Arduino/issues/4072

asetyde · Answer

Hi , one problem is resolved , I see this issue after softReset , after yesterday I see wizen note on wiki about HW and SW reset and issues can be generated … we implemented a hw reset and all work. About your wiznet library , I used at first but mysql connector not work 2 month ago , also this library seems not upgraded as Arduino standard library Ethernet , can be expose library to many issues . It’s work in your test ? it can be managed and fuse with actual standard library ? We need as stable safe driver , I can’t jump to other every time , If we can do a good work we can use it . We are waiting to order wiznet board , to complete test , thanks for your help !

connaissant · Answer

Dear Jim, could you explain, what are the changes for Arduino Mega adk with Wiz550io?

jim · Answer

Dear connaissant Think of it as similar to Arduino. Please refer to the W5500 library fix at the top. Thanks. Find w5500.h, w5500.cpp in Ethernet2 library. Windows OS C:\Users\your username\Documents\Adruino\libraries\Ethernet2\utility Linux /home/your username/Arduino/libraries/Ethernet2/src/utility/ Insert the following code in w5500.h … #define WIZ550io_WITH_MACADDRESS … Insert the following code in w5500.cpp … #if !defined(WIZ550io_WITH_MACADDRESS) w5500.swReset(); #endif …

connaissant · Answer

Thanks for the answer. Should I change the lines in ethernet2.h? (for mega) EthernetClass() { _dhcp = NULL; w5500_cspin = 53; } void init(uint8_t _cspin = 53) { w5500_cspin = _cspin; } in w5500h: public: void init(uint8_t ss_pin = 53); uint8_t readVersion(void); or I must explicitly specify in the sketch void setup() { pinMode(53, OUTPUT); digitalWrite(53, HIGH); Serial.begin(9600); …}

connaissant · Answer

Jim, help me please. The server runs for about 10 seconds and then stops working. I did everything according to the instructions. What could have been the cause? Look at the my previous post please. Kind regards, connaissant.

jim · Answer

If you upload whole source code, I will check. Thanks.

connaissant · Answer

When I download a sketch for the first time, everything is fine, in the subsequent times putty writes “server is at 0.0.0.0 or 40.40.40.40” Thank you. for Jim.zip (67.0 KB)

jim · Answer

I used your WebServer application and ArduinoMega+WIZ550io+ioShield-A. I didn’t find any problem. I upload my Ethernet2 library. If the problem persists, please check the connection of H/W. Thanks. Ethernet2.zip (62.3 KB) connection2138×2851 2.54 MB result1740×954 365 KB