Hi, while trying from LO image control to upload or update an image (4KB) from an Image control to a MySQL BLOB NULL field, it results in a BLOB 0 byte field. While uploading the same image from MySQL workbench, everything is OK, and the image can be visualized in LO form. When LO works with its embedded DB engine, it’s working fine too.
Here is the wireshark log from LO form:
36 16.334057 192.168.0.120 52.74.77.8 MySQL 116 Request Prepare Statement
39 16.538243 52.74.77.8 192.168.0.120 TCP 54 3306 → 49233 [ACK] Seq=1 Ack=63 Win=270 Len=0
40 16.538497 52.74.77.8 192.168.0.120 MySQL 133 Response
41 16.538759 192.168.0.120 52.74.77.8 MySQL 79 Request Execute Statement
42 16.746442 52.74.77.8 192.168.0.120 MySQL 106 Response OK
Here is the wireshark log from workbench
8 3.341354 192.168.0.120 52.74.77.8 MySQL 120 Request Prepare Statement
10 3.545522 52.74.77.8 192.168.0.120 MySQL 106 Response
11 3.545810 192.168.0.120 52.74.77.8 TCP 1514 50238 → 3306 [ACK] Seq=67 Ack=53 Win=253 Len=1460 [TCP segment of a reassembled PDU]
12 3.545810 192.168.0.120 52.74.77.8 TCP 1514 50238 → 3306 [ACK] Seq=1527 Ack=53 Win=253 Len=1460 [TCP segment of a reassembled PDU]
13 3.545810 192.168.0.120 52.74.77.8 MySQL 710 Request Send BLOB
14 3.546141 192.168.0.120 52.74.77.8 MySQL 72 Request Execute Statement
15 3.750302 52.74.77.8 192.168.0.120 TCP 54 3306 → 50238 [ACK] Seq=53 Ack=3643 Win=1425 Len=0
16 3.750744 52.74.77.8 192.168.0.120 MySQL 106 Response OK
It appears that LO form doesn’t send any data while Workbench is sending data and also makes a send BLOB request.
any idea ?
LO 7.3.5.2 Windows 64bits JDBC connection
MySQL 5.5.62-0ubuntu0.14.04.1
here is the Request Prepare Statement (from both WB and LO)
Request Command Prepare Statement
Command: Prepare Statement (22)
Statement: UPDATE sql6511740.Test SET Photo = ? WHERE (ID = ‘0’)
here is the Request Send BLOB (from workbench)
[3 Reassembled TCP Segments (3576 bytes): #11(1460), #12(1460), #13(656)]
[Frame: 11, payload: 0-1459 (1460 bytes)]
[Frame: 12, payload: 1460-2919 (1460 bytes)]
[Frame: 13, payload: 2920-3575 (656 bytes)]
[Segment count: 3]
[Reassembled TCP length: 3576]
[Reassembled TCP Data: f40d000018090000000000ffd8ffe000104a46494600010101006000600000ffe1006645…]