Wiz550io , Arduino due , Mysql_connector (arduino ide)

Network Module WIZ550io
1

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 :

2

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.

3

Hi , thanks for fast reply.

I 've tried many library , official wiznet to embeddeist , my version of IDE is last 1.8.3 , and I use with mysql connector library that you can find on library manager of ide,

Module is Wiz550io ethernet module http://www.wiznet.io/product-item/wiz550io/

4

Arduino DUE is linked as :

(I take it but wire is this , we use our custom PCB )

1541×692 245 KB

5

Unfortunately I don’t have Arduino DUE.
So I will explain for Arduino UNO.

First of all, prepare Arduino UNO and WIZ550io module.
Connect Arduino UNO and WIZ550io module like below.
Arduino UNO pin<->WIZ55io pin
3.3V<->3V3D
GND<->GND
13<->SCLK
12<->MISO
11<->MOSI
10<->SCSn
RESET<->RSTn

4032×3024 1.65 MB

I recommand to use ioShield-A.

4032×3024 1.84 MB

Execute Arduino IDE.
Select Arduino IDE Menubar->Sketch->Include Library->Mange Libraries…
Search Ethernet2 library by string.
Install Ethernet2 library.

Find w5500.h, w5500.cpp
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
…

For example, you can modify Ethernet.begin function of WebServer code without mac parameter.
Compile and upload by Arduino IDE.
Please refer to the attached file.
WebServer.zip (1.4 KB)

Thanks.

6

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

7

Mysql is not our support scope.
But I have tested that in curiosity.

You have to use <Ethernet2.h> instead of <Ethernet.h> in MySQL_Packet.h

//#include <Ethernet.h>
#include <Ethernet2.h>

Refer to the test result and file.

Connecting…
Connected to server version 5.5.57-0+deb8u1
Disconnected.

Mysql.zip (1.2 KB)

Thanks.

8

I will try again

9

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

10

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

11

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

12

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

13

Ethernet2 library already is used in WizArduino(ATSAMD21G18).
If you can send an Arduino Due to me, please refer to the following WIZnet HQ address.
http://www.wiznet.io/about/contact-us/

I will investigate after receiving a target.
Thanks.

14

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

15

Hi

I receivied your target board.
I have tested after code modification.
It works fine.
I upload my test images and code.

Thanks.

20170914_163951
20170914_1639514032×3024 2.09 MB

packwiz
packwiz858×952 259 KB

packwiz_2
packwiz_2876×483 80.7 KB

test_mysql_wiz.zip (1.9 KB)

16

Can you can give your library ?
How do you print Mac address ? ( I want take to my code to put on database )

17

I attached library files.
Thanks.

Ethernet2.zip (62.3 KB)
MySQL_Connector_Arduino.zip (409.2 KB)

18

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

19

Arduino UNO + W5500, ethernet2 libs
Instruction Works

2017-09-17 (2)
2017-09-17 (2)1920×1080 282 KB

Thank you!

20

Congratulations about working well.
If you need a business inquiry, please contact to sales@wiznet.io
Thanks.

1 Like