search

oracle / python-oracledb

Python driver for Oracle Database conforming to the Python DB API 2.0 specification. This is the renamed, new major release of cx_Oracle
https://oracle.github.io/python-oracledb
Other
328 stars 66 forks source link

DPY-5000: internal error: unknown protocol message type 0 while connecting to oracleDB #176

Closed kartik1581 closed 1 year ago

kartik1581 commented 1 year ago

While connecting to oracleDB, i am getting "DPY-5000: internal error: unknown protocol message type 0"

i have upgraded library to the latest version but still getting an error. Through SQL developer, i am able to connect to the DB with the same credentials

Machine: MAC M2 chip - Ventura OS

Code:

import traceback
import oracledb
try:
            # establish a new connection
            with oracledb.connect(user="username",
                                   password="password",
                                   dsn="hostname:port/servicename"
                                   ) as connection:
                # create a cursor
                with connection.cursor() as cursor:
                    cursor.execute("select * from dual")

except:
    traceback.print_exc()

Error:

### File "/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/oracledb/connection.py", line 1008, in connect
    return conn_class(dsn=dsn, pool=pool, params=params, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/oracledb/connection.py", line 130, in __init__
    impl.connect(params_impl)
  File "src/oracledb/impl/thin/connection.pyx", line 314, in oracledb.thin_impl.ThinConnImpl.connect
  File "src/oracledb/impl/thin/connection.pyx", line 202, in oracledb.thin_impl.ThinConnImpl._connect_with_params
  File "src/oracledb/impl/thin/connection.pyx", line 173, in oracledb.thin_impl.ThinConnImpl._connect_with_description
  File "src/oracledb/impl/thin/connection.pyx", line 114, in oracledb.thin_impl.ThinConnImpl._connect_with_address
  File "src/oracledb/impl/thin/protocol.pyx", line 228, in oracledb.thin_impl.Protocol._connect_phase_two
  File "src/oracledb/impl/thin/protocol.pyx", line 343, in oracledb.thin_impl.Protocol._process_message
  File "src/oracledb/impl/thin/protocol.pyx", line 322, in oracledb.thin_impl.Protocol._process_message
  File "src/oracledb/impl/thin/messages.pyx", line 292, in oracledb.thin_impl.Message.process
  File "src/oracledb/impl/thin/messages.pyx", line 179, in oracledb.thin_impl.Message._process_message
  File "/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/oracledb/errors.py", line 118, in _raise_err
    raise exc_type(_Error(message)) from cause
oracledb.exceptions.InternalError: DPY-5000: internal error: unknown protocol message type 0`
anthony-tuininga commented 1 year ago

Are you able to share the packet trace? That message indicates that the server is sending back something the client does not expect. You can get a packet trace by setting the environment variable PYO_DEBUG_PACKETS to any value before running your script. You can e-mail it to me directly if you prefer, too.

kartik1581 commented 1 year ago

Hi - i am bit new to python. can you help me out with example for setting PYO_DEBUG_PACKETS and how to print the logs?

Thanks, Kartik Shah

On Tue, Apr 25, 2023 at 10:14 PM Anthony Tuininga @.***> wrote:

Are you able to share the packet trace? That message indicates that the server is sending back something the client does not expect. You can get a packet trace by setting the environment variable PYO_DEBUG_PACKETS to any value before running your script. You can e-mail it to me directly if you prefer, too.

— Reply to this email directly, view it on GitHub https://github.com/oracle/python-oracledb/issues/176#issuecomment-1522106254, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAXYJHMBAIITANMO2C36CQDXC75PXANCNFSM6AAAAAAXLFNGF4 . You are receiving this because you authored the thread.Message ID: @.***>

anthony-tuininga commented 1 year ago

You can do the following:

import os

os.environ["PYO_DEBUG_PACKETS"] = "1"

import oracledb

conn = oracledb.connect("user/password@host/service_name")

That will display the packet contents to stdout. You can then copy/paste the output into this issue. Thanks!

cjbj commented 1 year ago

@kartik1581 if you aren't already on it, upgrade to python-oracledb 1.3.1.

kartik1581 commented 1 year ago

@cjbj i am already on 1.3.1 Name: oracledb Version: 1.3.1 Summary: Python interface to Oracle Database Home-page: https://oracle.github.io/python-oracledb Author: Anthony Tuininga Author-email: anthony.tuininga@oracle.com License: Apache and/or UPL Location: /Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/oracledb-1.3.1-py3.11-macosx-10.9-universal2.egg Requires: cryptography Required-by:

kartik1581 commented 1 year ago

here is the packet info. i have removed some specific info

Thanks, Kartik Shah

On Tue, Apr 25, 2023 at 10:14 PM Anthony Tuininga @.***> wrote:

Are you able to share the packet trace? That message indicates that the server is sending back something the client does not expect. You can get a packet trace by setting the environment variable PYO_DEBUG_PACKETS to any value before running your script. You can e-mail it to me directly if you prefer, too.

— Reply to this email directly, view it on GitHub https://github.com/oracle/python-oracledb/issues/176#issuecomment-1522106254, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAXYJHMBAIITANMO2C36CQDXC75PXANCNFSM6AAAAAAXLFNGF4 . You are receiving this because you authored the thread.Message ID: @.***>

2023-04-27 09:44:39.790 [socket: 6] Sending packet: 0000 : 00 4A 00 00 01 00 00 00 |.J......| 0008 : 01 3F 01 2C 04 01 20 00 |.?.,....| 0016 : FF FF 4F 98 00 00 00 01 |..O.....| 0024 : 00 ED 00 4A 00 00 00 00 |...J....| 0032 : 84 84 00 00 00 00 00 00 |........| 0040 : 00 00 00 00 00 00 00 00 |........| 0048 : 00 00 00 00 00 00 00 00 |........| 0056 : 00 00 00 00 20 00 00 00 |........| 0064 : FF FF 00 00 00 00 00 00 |........| 0072 : 00 01 |.. |

2023-04-27 09:44:39.790 [socket: 6] Sending packet: 0000 : 00 F7 00 00 06 00 00 00 |........| 0008 : 00 00 28 44 45 53 43 52 |..(DESCR| 0016 : 49 50 54 49 4F 4E 3D 28 |IPTION=(| 0024 : 41 44 44 52 45 53 53 3D |ADDRESS=| 0032 : 28 50 52 4F 54 4F 43 4F |(PROTOCO| 0040 : 4C 3D 74 63 70 29 28 48 |L=tcp)(H| 0048 : 4F 53 54 3D 73 74 2D 72 |OST=host| 0056 : 61 63 2D 70 72 64 65 65 |name | 0064 : 30 31 2E 6E 61 2E 72 74 |host | 0072 : 64 6F 6D 2E 6E 65 74 29 |name | 0080 : 28 50 4F 52 54 3D 31 35 |(port | 0088 : 32 31 29 29 28 43 4F 4E |21))(CON| 0096 : 4E 45 43 54 5F 44 41 54 |NECT_DAT| 0104 : 41 3D 28 53 45 52 56 49 |A=(SERVI| 0112 : 43 45 5F 4E 41 4D 45 3D |CENAME=| 0120 : 50 52 53 4D 50 52 44 5F |service| 0128 : 4E 31 29 28 43 49 44 3D |Na)(CID=| 0136 : 28 50 52 4F 47 52 41 4D |(PROGRAM| 0144 : 3D 2F 4C 69 62 72 61 72 |=/Librar| 0152 : 79 2F 46 72 61 6D 65 77 |y/Framew| 0160 : 6F 72 6B 73 2F 50 79 74 |orks/Pyt| 0168 : 68 6F 6E 2E 66 72 61 6D |hon.fram| 0176 : 65 77 6F 72 6B 2F 56 65 |ework/Ve| 0184 : 72 73 69 6F 6E 73 2F 33 |rsions/3| 0192 : 2E 31 31 2F 62 69 6E 2F |.11/bin/| 0200 : 70 79 74 68 6F 6E 33 29 |python3)| 0208 : 28 48 4F 53 54 3D 50 55 |(HOST= | 0216 : 2D 4D 42 50 2D 4B 53 48 | | 0224 : 41 33 29 28 55 53 45 52 | | 0232 : 3D 6B 61 72 74 69 6B 73 | | 0240 : 68 61 68 29 29 29 29 | |

2023-04-27 09:44:40.039 [socket: 6] Receiving packet: 0000 : 00 0A 00 0A 05 02 00 00 |........| 0008 : 01 4E |.N |

2023-04-27 09:44:40.039 [socket: 6] Receiving packet: 0000 : 01 58 00 0A 06 00 00 00 |.X......| 0008 : 00 40 28 41 44 44 52 45 |.@(ADDRE| 0016 : 53 53 3D 28 50 52 4F 54 |SS=(PROT| 0024 : 4F 43 4F 4C 3D 54 43 50 |OCOL=TCP| 0032 : 29 28 48 4F 53 54 3D 31 |)(HOST=1| 0040 : 30 2E 32 35 33 2E 32 34 | | 0048 : 2E 39 33 29 28 50 4F 52 | | 0056 : 54 3D 31 35 32 31 29 29 | | 0064 : 00 28 44 45 53 43 52 49 | | 0072 : 50 54 49 4F 4E 3D 28 41 | | 0080 : 44 44 52 45 53 53 3D 28 |DDRESS | 0088 : 50 52 4F 54 4F 43 4F 4C |PROTOCOL| 0096 : 3D 74 63 70 29 28 48 4F |=tcp)(HO| 0104 : 53 54 3D 73 74 2D 72 61 |ST= | 0112 : 63 2D 70 72 64 65 65 30 | | 0120 : 31 2E 6E 61 2E 72 74 64 | | 0128 : 6F 6D 2E 6E 65 74 29 28 | | 0136 : 50 4F 52 54 3D 31 35 32 |PORT= | 0144 : 31 29 29 28 43 4F 4E 4E |1))(CONN| 0152 : 45 43 54 5F 44 41 54 41 |ECT_DATA| 0160 : 3D 28 53 45 52 56 49 43 |=(SERVIC| 0168 : 45 5F 4E 41 4D 45 3D 50 |ENAME=| 0176 : 52 53 4D 50 52 44 5F 4E | | 0184 : 31 29 28 43 49 44 3D 28 | )(CID=(| 0192 : 50 52 4F 47 52 41 4D 3D |PROGRAM=| 0200 : 2F 4C 69 62 72 61 72 79 |/Library| 0208 : 2F 46 72 61 6D 65 77 6F |/Framewo| 0216 : 72 6B 73 2F 50 79 74 68 |rks/Pyth| 0224 : 6F 6E 2E 66 72 61 6D 65 |on.frame| 0232 : 77 6F 72 6B 2F 56 65 72 |work/Ver| 0240 : 73 69 6F 6E 73 2F 33 2E |sions/3.| 0248 : 31 31 2F 62 69 6E 2F 70 |11/bin/p| 0256 : 79 74 68 6F 6E 33 29 28 |ython3)(| 0264 : 48 4F 53 54 3D 50 55 2D |HOST= | 0272 : 4D 42 50 2D 4B 53 48 41 | | 0280 : 33 29 28 55 53 45 52 3D |3)(USER=| 0288 : 6B 61 72 74 69 6B 73 68 | | 0296 : 61 68 29 29 28 53 45 52 |ah))(SER| 0304 : 56 45 52 3D 64 65 64 69 |VER=dedi| 0312 : 63 61 74 65 64 29 28 49 |cated)(I| 0320 : 4E 53 54 41 4E 43 45 5F |NSTANCE| 0328 : 4E 41 4D 45 3D 53 54 52 |NAME= | 0336 : 50 30 31 43 31 29 29 29 |P01C1)))|

2023-04-27 09:44:40.287 [socket: 7] Sending packet: 0000 : 00 4A 00 00 01 00 00 00 |.J......| 0008 : 01 3F 01 2C 04 01 20 00 |.?.,....| 0016 : FF FF 4F 98 00 00 00 01 |..O.....| 0024 : 01 17 00 4A 00 00 00 00 |...J....| 0032 : 84 84 00 00 00 00 00 00 |........| 0040 : 00 00 00 00 00 00 00 00 |........| 0048 : 00 00 00 00 00 00 00 00 |........| 0056 : 00 00 00 00 20 00 00 00 |........| 0064 : FF FF 00 00 00 00 00 00 |........| 0072 : 00 01 |.. |

2023-04-27 09:44:40.288 [socket: 7] Sending packet: 0000 : 01 21 00 00 06 00 00 00 |.!......| 0008 : 00 00 28 44 45 53 43 52 |..(DESCR| 0016 : 49 50 54 49 4F 4E 3D 28 |IPTION=(| 0024 : 41 44 44 52 45 53 53 3D |ADDRESS=| 0032 : 28 50 52 4F 54 4F 43 4F |(PROTOCO| 0040 : 4C 3D 74 63 70 29 28 48 |L=tcp)(H| 0048 : 4F 53 54 3D 73 74 2D 72 |OST= | 0056 : 61 63 2D 70 72 64 65 65 | | 0064 : 30 31 2E 6E 61 2E 72 74 | | 0072 : 64 6F 6D 2E 6E 65 74 29 | | 0080 : 28 50 4F 52 54 3D 31 35 |(PORT=15| 0088 : 32 31 29 29 28 43 4F 4E |21))(CON| 0096 : 4E 45 43 54 5F 44 41 54 |NECT_DAT| 0104 : 41 3D 28 53 45 52 56 49 |A=(SERVI| 0112 : 43 45 5F 4E 41 4D 45 3D |CENAME=| 0120 : 50 52 53 4D 50 52 44 5F | | 0128 : 4E 31 29 28 43 49 44 3D |N1)(CID=| 0136 : 28 50 52 4F 47 52 41 4D |(PROGRAM| 0144 : 3D 2F 4C 69 62 72 61 72 |=/Librar| 0152 : 79 2F 46 72 61 6D 65 77 |y/Framew| 0160 : 6F 72 6B 73 2F 50 79 74 |orks/Pyt| 0168 : 68 6F 6E 2E 66 72 61 6D |hon.fram| 0176 : 65 77 6F 72 6B 2F 56 65 |ework/Ve| 0184 : 72 73 69 6F 6E 73 2F 33 |rsions/3| 0192 : 2E 31 31 2F 62 69 6E 2F |.11/bin/| 0200 : 70 79 74 68 6F 6E 33 29 |python3)| 0208 : 28 48 4F 53 54 3D 50 55 |(HOST=PU| 0216 : 2D 4D 42 50 2D 4B 53 48 |-MBP-KSH| 0224 : 41 33 29 28 55 53 45 52 |A3)(USER| 0232 : 3D 6B 61 72 74 69 6B 73 |=kartiks| 0240 : 68 61 68 29 29 28 53 45 |hah))(SE| 0248 : 52 56 45 52 3D 64 65 64 |RVER=ded| 0256 : 69 63 61 74 65 64 29 28 |icated)(| 0264 : 49 4E 53 54 41 4E 43 45 |INSTANCE| 0272 : 5F 4E 41 4D 45 3D 53 54 |_NAME=ST| 0280 : 52 50 30 31 43 31 29 29 | ))| 0288 : 29 |) |

2023-04-27 09:44:40.574 [socket: 7] Receiving packet: 0000 : 00 08 00 00 0B 00 00 00 |........|

2023-04-27 09:44:40.574 [socket: 7] Sending packet: 0000 : 00 4A 00 00 01 00 00 00 |.J......| 0008 : 01 3F 01 2C 04 01 20 00 |.?.,....| 0016 : FF FF 4F 98 00 00 00 01 |..O.....| 0024 : 01 17 00 4A 00 00 00 00 |...J....| 0032 : 84 84 00 00 00 00 00 00 |........| 0040 : 00 00 00 00 00 00 00 00 |........| 0048 : 00 00 00 00 00 00 00 00 |........| 0056 : 00 00 00 00 20 00 00 00 |........| 0064 : FF FF 00 00 00 00 00 00 |........| 0072 : 00 01 |.. |

2023-04-27 09:44:40.574 [socket: 7] Sending packet: 0000 : 01 21 00 00 06 00 00 00 |.!......| 0008 : 00 00 28 44 45 53 43 52 |..(DESCR| 0016 : 49 50 54 49 4F 4E 3D 28 |IPTION=(| 0024 : 41 44 44 52 45 53 53 3D |ADDRESS=| 0032 : 28 50 52 4F 54 4F 43 4F |(PROTOCO| 0040 : 4C 3D 74 63 70 29 28 48 |L=tcp)(H| 0048 : 4F 53 54 3D 73 74 2D 72 |OST= | 0056 : 61 63 2D 70 72 64 65 65 | | 0064 : 30 31 2E 6E 61 2E 72 74 | | 0072 : 64 6F 6D 2E 6E 65 74 29 | | 0080 : 28 50 4F 52 54 3D 31 35 |(PORT=15| 0088 : 32 31 29 29 28 43 4F 4E |21))(CON| 0096 : 4E 45 43 54 5F 44 41 54 |NECT_DAT| 0104 : 41 3D 28 53 45 52 56 49 |A=(SERVI| 0112 : 43 45 5F 4E 41 4D 45 3D |CENAME=| 0120 : 50 52 53 4D 50 52 44 5F | | 0128 : 4E 31 29 28 43 49 44 3D |N1)(CID=| 0136 : 28 50 52 4F 47 52 41 4D |(PROGRAM| 0144 : 3D 2F 4C 69 62 72 61 72 |=/Librar| 0152 : 79 2F 46 72 61 6D 65 77 |y/Framew| 0160 : 6F 72 6B 73 2F 50 79 74 |orks/Pyt| 0168 : 68 6F 6E 2E 66 72 61 6D |hon.fram| 0176 : 65 77 6F 72 6B 2F 56 65 |ework/Ve| 0184 : 72 73 69 6F 6E 73 2F 33 |rsions/3| 0192 : 2E 31 31 2F 62 69 6E 2F |.11/bin/| 0200 : 70 79 74 68 6F 6E 33 29 |python3)| 0208 : 28 48 4F 53 54 3D 50 55 |(HOST=PU| 0216 : 2D 4D 42 50 2D 4B 53 48 |-MBP-KSH| 0224 : 41 33 29 28 55 53 45 52 |A3)(USER| 0232 : 3D 6B 61 72 74 69 6B 73 |=kartiks| 0240 : 68 61 68 29 29 28 53 45 |hah))(SE| 0248 : 52 56 45 52 3D 64 65 64 |RVER=ded| 0256 : 69 63 61 74 65 64 29 28 |icated)(| 0264 : 49 4E 53 54 41 4E 43 45 |INSTANCE| 0272 : 5F 4E 41 4D 45 3D 53 54 |_NAME=ST| 0280 : 52 50 30 31 43 31 29 29 | ))| 0288 : 29 |) |

2023-04-27 09:44:40.881 [socket: 7] Receiving packet: 0000 : 00 29 00 00 02 00 00 00 |.)......| 0008 : 01 3C 04 01 00 00 00 00 |.<......| 0016 : 01 00 00 00 00 29 C5 00 |.....)..| 0024 : 00 00 00 00 00 00 00 00 |........| 0032 : 00 00 20 00 00 00 FF FF |........| 0040 : 00 |. |

2023-04-27 09:44:40.882 [socket: 7] Sending packet: 0000 : 00 00 00 1D 06 00 00 00 |........| 0008 : 00 00 01 06 00 70 79 74 |.....pyt| 0016 : 68 6F 6E 2D 6F 72 61 63 |hon-orac| 0024 : 6C 65 64 62 00 |ledb. |

2023-04-27 09:44:41.131 [socket: 7] Receiving packet: 0000 : 00 00 00 F1 06 00 00 00 |........| 0008 : 00 00 01 06 00 78 38 36 |.....x86| 0016 : 5F 36 34 2F 4C 69 6E 75 |_64/Linu| 0024 : 78 20 32 2E 34 2E 78 78 |x.2.4.xx| 0032 : 00 69 03 01 0A 00 66 03 |.i....f.| 0040 : 40 03 01 40 03 66 03 01 @.**@.f..| 0048 : 66 03 48 03 01 48 03 66 |f.H..H.f| 0056 : 03 01 66 03 52 03 01 52 |..f.R..R| 0064 : 03 66 03 01 66 03 61 03 |.f..f.a.| 0072 : 01 61 03 66 03 01 66 03 |.a.f..f.| 0080 : 1F 03 08 1F 03 66 03 01 |.....f..| 0088 : 00 64 00 00 00 60 01 24 |.d...`.$| 0096 : 0F 05 0B 0C 03 0C 0C 05 |........| 0104 : 04 05 0D 06 09 07 08 05 |........| 0112 : 05 05 05 05 0F 05 05 05 |........| 0120 : 05 05 0A 05 05 05 05 05 |........| 0128 : 04 05 06 07 08 08 23 47 |......#G| 0136 : 23 47 08 11 23 08 11 41 |#G..#..A| 0144 : B0 47 00 83 03 69 07 D0 |.G...i..| 0152 : 03 00 00 00 00 00 00 00 |........| 0160 : 00 00 00 00 00 00 00 00 |........| 0168 : 00 00 00 00 00 00 00 00 |........| 0176 : 00 00 00 00 00 00 00 00 |........| 0184 : 00 00 00 00 00 00 2A 06 |.......| 0192 : 01 01 01 6F 01 01 09 01 |...o....| 0200 : 01 01 01 01 01 01 7F FF |........| 0208 : 03 0C 03 03 01 01 FF 01 |........| 0216 : FF FF 01 0B 01 01 FF 01 |........| 0224 : 06 09 62 01 7F 04 00 03 |..b.....| 0232 : 0D 07 02 01 00 01 18 00 |........| 0240 : 0F |. |

2023-04-27 09:44:41.132 [socket: 7] Sending packet: 0000 : 00 00 0A 00 06 00 00 00 |........| 0008 : 00 00 02 69 03 69 03 03 |...i.i..| 0016 : 2D 06 00 00 00 EA 00 00 |-.......| 0024 : 09 01 00 00 00 00 00 00 |........| 0032 : 29 90 03 07 03 00 01 00 |).......| 0040 : CF 00 00 04 01 00 00 00 |........| 0048 : 10 00 00 0C 00 00 B0 00 |........| 0056 : 00 04 00 05 00 00 07 02 |........| 0064 : 00 00 00 00 00 05 00 01 |........| 0072 : 00 01 00 01 00 00 00 02 |........| 0080 : 00 02 00 0A 00 00 00 08 |........| 0088 : 00 08 00 01 00 00 00 0C |........| 0096 : 00 0C 00 0A 00 00 00 17 |........| 0104 : 00 17 00 01 00 00 00 18 |........| 0112 : 00 18 00 01 00 00 00 19 |........| 0120 : 00 19 00 01 00 00 00 1A |........| 0128 : 00 1A 00 01 00 00 00 1B |........| 0136 : 00 1B 00 01 00 00 00 1C |........| 0144 : 00 1C 00 01 00 00 00 1D |........| 0152 : 00 1D 00 01 00 00 00 1E |........| 0160 : 00 1E 00 01 00 00 00 1F |........| 0168 : 00 1F 00 01 00 00 00 20 |........| 0176 : 00 20 00 01 00 00 00 21 |.......!| 0184 : 00 21 00 01 00 00 00 0A |.!......| 0192 : 00 0A 00 01 00 00 00 0B |........| 0200 : 00 0B 00 01 00 00 00 28 |.......(| 0208 : 00 28 00 01 00 00 00 29 |.(.....)| 0216 : 00 29 00 01 00 00 00 75 |.).....u| 0224 : 00 75 00 01 00 00 00 78 |.u.....x| 0232 : 00 78 00 01 00 00 01 22 |.x....."| 0240 : 01 22 00 01 00 00 01 23 |.".....#| 0248 : 01 23 00 01 00 00 01 24 |.#.....$| 0256 : 01 24 00 01 00 00 01 25 |.$.....%| 0264 : 01 25 00 01 00 00 01 26 |.%.....&| 0272 : 01 26 00 01 00 00 01 2A |.&.....| 0280 : 01 2A 00 01 00 00 01 2B |......+| 0288 : 01 2B 00 01 00 00 01 2C |.+.....,| 0296 : 01 2C 00 01 00 00 01 2D |.,.....-| 0304 : 01 2D 00 01 00 00 01 2E |.-......| 0312 : 01 2E 00 01 00 00 01 2F |......./| 0320 : 01 2F 00 01 00 00 01 30 |./.....0| 0328 : 01 30 00 01 00 00 01 31 |.0.....1| 0336 : 01 31 00 01 00 00 01 32 |.1.....2| 0344 : 01 32 00 01 00 00 01 33 |.2.....3| 0352 : 01 33 00 01 00 00 01 34 |.3.....4| 0360 : 01 34 00 01 00 00 01 35 |.4.....5| 0368 : 01 35 00 01 00 00 01 36 |.5.....6| 0376 : 01 36 00 01 00 00 01 37 |.6.....7| 0384 : 01 37 00 01 00 00 01 38 |.7.....8| 0392 : 01 38 00 01 00 00 01 39 |.8.....9| 0400 : 01 39 00 01 00 00 01 3B |.9.....;| 0408 : 01 3B 00 01 00 00 01 3C |.;.....<| 0416 : 01 3C 00 01 00 00 01 3D |.<.....=| 0424 : 01 3D 00 01 00 00 01 3E |.=.....>| 0432 : 01 3E 00 01 00 00 01 3F |.>.....?| 0440 : 01 3F 00 01 00 00 01 40 |.?.....@| 0448 : 01 40 00 01 00 00 01 41 @.| 0456 : 01 41 00 01 00 00 01 42 |.A.....B| 0464 : 01 42 00 01 00 00 01 43 |.B.....C| 0472 : 01 43 00 01 00 00 01 47 |.C.....G| 0480 : 01 47 00 01 00 00 01 48 |.G.....H| 0488 : 01 48 00 01 00 00 01 49 |.H.....I| 0496 : 01 49 00 01 00 00 01 4B |.I.....K| 0504 : 01 4B 00 01 00 00 01 4D |.K.....M| 0512 : 01 4D 00 01 00 00 01 4E |.M.....N| 0520 : 01 4E 00 01 00 00 01 4F |.N.....O| 0528 : 01 4F 00 01 00 00 01 50 |.O.....P| 0536 : 01 50 00 01 00 00 01 51 |.P.....Q| 0544 : 01 51 00 01 00 00 01 52 |.Q.....R| 0552 : 01 52 00 01 00 00 01 53 |.R.....S| 0560 : 01 53 00 01 00 00 01 54 |.S.....T| 0568 : 01 54 00 01 00 00 01 55 |.T.....U| 0576 : 01 55 00 01 00 00 01 56 |.U.....V| 0584 : 01 56 00 01 00 00 01 57 |.V.....W| 0592 : 01 57 00 01 00 00 01 58 |.W.....X| 0600 : 01 58 00 01 00 00 01 59 |.X.....Y| 0608 : 01 59 00 01 00 00 01 5A |.Y.....Z| 0616 : 01 5A 00 01 00 00 01 5C |.Z.....| 0624 : 01 5C 00 01 00 00 01 5D |......]| 0632 : 01 5D 00 01 00 00 01 62 |.].....b| 0640 : 01 62 00 01 00 00 01 63 |.b.....c| 0648 : 01 63 00 01 00 00 01 67 |.c.....g| 0656 : 01 67 00 01 00 00 01 6B |.g.....k| 0664 : 01 6B 00 01 00 00 01 7C |.k.....|| 0672 : 01 7C 00 01 00 00 01 7D |.|.....}| 0680 : 01 7D 00 01 00 00 01 7E |.}.....~| 0688 : 01 7E 00 01 00 00 01 7F |.~......| 0696 : 01 7F 00 01 00 00 01 80 |........| 0704 : 01 80 00 01 00 00 01 81 |........| 0712 : 01 81 00 01 00 00 01 82 |........| 0720 : 01 82 00 01 00 00 01 83 |........| 0728 : 01 83 00 01 00 00 01 84 |........| 0736 : 01 84 00 01 00 00 01 85 |........| 0744 : 01 85 00 01 00 00 01 86 |........| 0752 : 01 86 00 01 00 00 01 87 |........| 0760 : 01 87 00 01 00 00 01 89 |........| 0768 : 01 89 00 01 00 00 01 8A |........| 0776 : 01 8A 00 01 00 00 01 8B |........| 0784 : 01 8B 00 01 00 00 01 8C |........| 0792 : 01 8C 00 01 00 00 01 8D |........| 0800 : 01 8D 00 01 00 00 01 8E |........| 0808 : 01 8E 00 01 00 00 01 8F |........| 0816 : 01 8F 00 01 00 00 01 90 |........| 0824 : 01 90 00 01 00 00 01 91 |........| 0832 : 01 91 00 01 00 00 01 94 |........| 0840 : 01 94 00 01 00 00 01 95 |........| 0848 : 01 95 00 01 00 00 01 96 |........| 0856 : 01 96 00 01 00 00 01 97 |........| 0864 : 01 97 00 01 00 00 01 9D |........| 0872 : 01 9D 00 01 00 00 01 9E |........| 0880 : 01 9E 00 01 00 00 01 9F |........| 0888 : 01 9F 00 01 00 00 01 A0 |........| 0896 : 01 A0 00 01 00 00 01 A1 |........| 0904 : 01 A1 00 01 00 00 01 A2 |........| 0912 : 01 A2 00 01 00 00 01 A3 |........| 0920 : 01 A3 00 01 00 00 01 A4 |........| 0928 : 01 A4 00 01 00 00 01 A5 |........| 0936 : 01 A5 00 01 00 00 01 A6 |........| 0944 : 01 A6 00 01 00 00 01 A7 |........| 0952 : 01 A7 00 01 00 00 01 A8 |........| 0960 : 01 A8 00 01 00 00 01 A9 |........| 0968 : 01 A9 00 01 00 00 01 AA |........| 0976 : 01 AA 00 01 00 00 01 AB |........| 0984 : 01 AB 00 01 00 00 01 AD |........| 0992 : 01 AD 00 01 00 00 01 AE |........| 1000 : 01 AE 00 01 00 00 01 AF |........| 1008 : 01 AF 00 01 00 00 01 B0 |........| 1016 : 01 B0 00 01 00 00 01 B1 |........| 1024 : 01 B1 00 01 00 00 01 C1 |........| 1032 : 01 C1 00 01 00 00 01 C2 |........| 1040 : 01 C2 00 01 00 00 01 C6 |........| 1048 : 01 C6 00 01 00 00 01 C7 |........| 1056 : 01 C7 00 01 00 00 01 C8 |........| 1064 : 01 C8 00 01 00 00 01 C9 |........| 1072 : 01 C9 00 01 00 00 01 CA |........| 1080 : 01 CA 00 01 00 00 01 CB |........| 1088 : 01 CB 00 01 00 00 01 CC |........| 1096 : 01 CC 00 01 00 00 01 CD |........| 1104 : 01 CD 00 01 00 00 01 CE |........| 1112 : 01 CE 00 01 00 00 01 CF |........| 1120 : 01 CF 00 01 00 00 01 D2 |........| 1128 : 01 D2 00 01 00 00 01 D3 |........| 1136 : 01 D3 00 01 00 00 01 D4 |........| 1144 : 01 D4 00 01 00 00 01 D5 |........| 1152 : 01 D5 00 01 00 00 01 D6 |........| 1160 : 01 D6 00 01 00 00 01 D7 |........| 1168 : 01 D7 00 01 00 00 01 D8 |........| 1176 : 01 D8 00 01 00 00 01 D9 |........| 1184 : 01 D9 00 01 00 00 01 DA |........| 1192 : 01 DA 00 01 00 00 01 DB |........| 1200 : 01 DB 00 01 00 00 01 DC |........| 1208 : 01 DC 00 01 00 00 01 DD |........| 1216 : 01 DD 00 01 00 00 01 DE |........| 1224 : 01 DE 00 01 00 00 01 DF |........| 1232 : 01 DF 00 01 00 00 01 E0 |........| 1240 : 01 E0 00 01 00 00 01 E1 |........| 1248 : 01 E1 00 01 00 00 01 E2 |........| 1256 : 01 E2 00 01 00 00 01 E3 |........| 1264 : 01 E3 00 01 00 00 01 E4 |........| 1272 : 01 E4 00 01 00 00 01 E5 |........| 1280 : 01 E5 00 01 00 00 01 E6 |........| 1288 : 01 E6 00 01 00 00 01 EA |........| 1296 : 01 EA 00 01 00 00 01 EB |........| 1304 : 01 EB 00 01 00 00 01 EC |........| 1312 : 01 EC 00 01 00 00 01 ED |........| 1320 : 01 ED 00 01 00 00 01 EE |........| 1328 : 01 EE 00 01 00 00 01 EF |........| 1336 : 01 EF 00 01 00 00 01 F0 |........| 1344 : 01 F0 00 01 00 00 01 F2 |........| 1352 : 01 F2 00 01 00 00 01 F3 |........| 1360 : 01 F3 00 01 00 00 01 F4 |........| 1368 : 01 F4 00 01 00 00 01 F5 |........| 1376 : 01 F5 00 01 00 00 01 F6 |........| 1384 : 01 F6 00 01 00 00 01 FD |........| 1392 : 01 FD 00 01 00 00 01 FE |........| 1400 : 01 FE 00 01 00 00 02 01 |........| 1408 : 02 01 00 01 00 00 02 02 |........| 1416 : 02 02 00 01 00 00 02 04 |........| 1424 : 02 04 00 01 00 00 02 05 |........| 1432 : 02 05 00 01 00 00 02 06 |........| 1440 : 02 06 00 01 00 00 02 07 |........| 1448 : 02 07 00 01 00 00 02 08 |........| 1456 : 02 08 00 01 00 00 02 09 |........| 1464 : 02 09 00 01 00 00 02 0A |........| 1472 : 02 0A 00 01 00 00 02 0B |........| 1480 : 02 0B 00 01 00 00 02 0C |........| 1488 : 02 0C 00 01 00 00 02 0D |........| 1496 : 02 0D 00 01 00 00 02 0E |........| 1504 : 02 0E 00 01 00 00 02 0F |........| 1512 : 02 0F 00 01 00 00 02 10 |........| 1520 : 02 10 00 01 00 00 02 11 |........| 1528 : 02 11 00 01 00 00 02 12 |........| 1536 : 02 12 00 01 00 00 02 13 |........| 1544 : 02 13 00 01 00 00 02 14 |........| 1552 : 02 14 00 01 00 00 02 15 |........| 1560 : 02 15 00 01 00 00 02 16 |........| 1568 : 02 16 00 01 00 00 02 17 |........| 1576 : 02 17 00 01 00 00 02 18 |........| 1584 : 02 18 00 01 00 00 02 19 |........| 1592 : 02 19 00 01 00 00 02 1A |........| 1600 : 02 1A 00 01 00 00 02 1B |........| 1608 : 02 1B 00 01 00 00 02 1C |........| 1616 : 02 1C 00 01 00 00 02 1D |........| 1624 : 02 1D 00 01 00 00 02 1E |........| 1632 : 02 1E 00 01 00 00 02 1F |........| 1640 : 02 1F 00 01 00 00 02 30 |.......0| 1648 : 02 30 00 01 00 00 02 35 |.0.....5| 1656 : 02 35 00 01 00 00 02 3C |.5.....<| 1664 : 02 3C 00 01 00 00 02 3D |.<.....=| 1672 : 02 3D 00 01 00 00 02 3E |.=.....>| 1680 : 02 3E 00 01 00 00 02 3F |.>.....?| 1688 : 02 3F 00 01 00 00 02 40 |.?.....@| 1696 : 02 40 00 01 00 00 02 42 @.| 1704 : 02 42 00 01 00 00 02 33 |.B.....3| 1712 : 02 33 00 01 00 00 02 34 |.3.....4| 1720 : 02 34 00 01 00 00 02 43 |.4.....C| 1728 : 02 43 00 01 00 00 02 44 |.C.....D| 1736 : 02 44 00 01 00 00 02 45 |.D.....E| 1744 : 02 45 00 01 00 00 02 46 |.E.....F| 1752 : 02 46 00 01 00 00 02 47 |.F.....G| 1760 : 02 47 00 01 00 00 02 48 |.G.....H| 1768 : 02 48 00 01 00 00 02 49 |.H.....I| 1776 : 02 49 00 01 00 00 00 03 |.I......| 1784 : 00 02 00 0A 00 00 00 04 |........| 1792 : 00 02 00 0A 00 00 00 05 |........| 1800 : 00 01 00 01 00 00 00 06 |........| 1808 : 00 02 00 0A 00 00 00 07 |........| 1816 : 00 02 00 0A 00 00 00 09 |........| 1824 : 00 01 00 01 00 00 00 0F |........| 1832 : 00 01 00 01 00 00 00 27 |.......'| 1840 : 00 78 00 01 00 00 00 44 |.x.....D| 1848 : 00 02 00 0A 00 00 00 5B |.......[| 1856 : 00 02 00 0A 00 00 00 5E |.......^| 1864 : 00 01 00 01 00 00 00 5F |......._| 1872 : 00 17 00 01 00 00 00 60 |.......| 1880 : 00 60 00 01 00 00 00 61 |......a| 1888 : 00 60 00 01 00 00 00 64 |.`.....d| 1896 : 00 64 00 01 00 00 00 65 |.d.....e| 1904 : 00 65 00 01 00 00 00 66 |.e.....f| 1912 : 00 66 00 01 00 00 00 68 |.f.....h| 1920 : 00 0B 00 01 00 00 00 6A |.......j| 1928 : 00 6A 00 01 00 00 00 6C |.j.....l| 1936 : 00 6D 00 01 00 00 00 6D |.m.....m| 1944 : 00 6D 00 01 00 00 00 6E |.m.....n| 1952 : 00 6F 00 01 00 00 00 6F |.o.....o| 1960 : 00 6F 00 01 00 00 00 70 |.o.....p| 1968 : 00 70 00 01 00 00 00 71 |.p.....q| 1976 : 00 71 00 01 00 00 00 72 |.q.....r| 1984 : 00 72 00 01 00 00 00 73 |.r.....s| 1992 : 00 73 00 01 00 00 00 74 |.s.....t| 2000 : 00 66 00 01 00 00 00 77 |.f.....w| 2008 : 00 77 00 01 00 00 00 C6 |.w......| 2016 : 00 C6 00 01 00 00 00 92 |........| 2024 : 00 92 00 01 00 00 00 98 |........| 2032 : 00 02 00 0A 00 00 00 99 |........| 2040 : 00 02 00 0A 00 00 00 9A |........| 2048 : 00 02 00 0A 00 00 00 9B |........| 2056 : 00 01 00 01 00 00 00 9C |........| 2064 : 00 0C 00 0A 00 00 00 AC |........| 2072 : 00 02 00 0A 00 00 00 B2 |........| 2080 : 00 B2 00 01 00 00 00 B3 |........| 2088 : 00 B3 00 01 00 00 00 B4 |........| 2096 : 00 B4 00 01 00 00 00 B5 |........| 2104 : 00 B5 00 01 00 00 00 B6 |........| 2112 : 00 B6 00 01 00 00 00 B7 |........| 2120 : 00 B7 00 01 00 00 00 B8 |........| 2128 : 00 0C 00 0A 00 00 00 B9 |........| 2136 : 00 B9 00 01 00 00 00 BA |........| 2144 : 00 BA 00 01 00 00 00 BB |........| 2152 : 00 BB 00 01 00 00 00 BC |........| 2160 : 00 BC 00 01 00 00 00 BD |........| 2168 : 00 BD 00 01 00 00 00 BE |........| 2176 : 00 BE 00 01 00 00 00 C3 |........| 2184 : 00 70 00 01 00 00 00 C4 |.p......| 2192 : 00 71 00 01 00 00 00 C5 |.q......| 2200 : 00 72 00 01 00 00 00 D0 |.r......| 2208 : 00 D0 00 01 00 00 00 E7 |........| 2216 : 00 E7 00 01 00 00 00 E8 |........| 2224 : 00 E7 00 01 00 00 00 E9 |........| 2232 : 00 E9 00 01 00 00 00 F1 |........| 2240 : 00 6D 00 01 00 00 00 FC |.m......| 2248 : 00 FC 00 01 00 00 02 4E |.......N| 2256 : 02 4E 00 01 00 00 02 4F |.N.....O| 2264 : 02 4F 00 01 00 00 02 50 |.O.....P| 2272 : 02 50 00 01 00 00 02 65 |.P.....e| 2280 : 02 65 00 01 00 00 02 66 |.e.....f| 2288 : 02 66 00 01 00 00 02 67 |.f.....g| 2296 : 02 67 00 01 00 00 02 68 |.g.....h| 2304 : 02 68 00 01 00 00 02 63 |.h.....c| 2312 : 02 63 00 01 00 00 02 64 |.c.....d| 2320 : 02 64 00 01 00 00 02 51 |.d.....Q| 2328 : 02 51 00 01 00 00 02 52 |.Q.....R| 2336 : 02 52 00 01 00 00 02 53 |.R.....S| 2344 : 02 53 00 01 00 00 02 54 |.S.....T| 2352 : 02 54 00 01 00 00 02 55 |.T.....U| 2360 : 02 55 00 01 00 00 02 56 |.U.....V| 2368 : 02 56 00 01 00 00 02 57 |.V.....W| 2376 : 02 57 00 01 00 00 02 58 |.W.....X| 2384 : 02 58 00 01 00 00 02 59 |.X.....Y| 2392 : 02 59 00 01 00 00 02 5A |.Y.....Z| 2400 : 02 5A 00 01 00 00 02 5B |.Z.....[| 2408 : 02 5B 00 01 00 00 02 5C |.[.....| 2416 : 02 5C 00 01 00 00 02 5D |......]| 2424 : 02 5D 00 01 00 00 02 6E |.].....n| 2432 : 02 6E 00 01 00 00 02 6F |.n.....o| 2440 : 02 6F 00 01 00 00 02 70 |.o.....p| 2448 : 02 70 00 01 00 00 02 71 |.p.....q| 2456 : 02 71 00 01 00 00 02 72 |.q.....r| 2464 : 02 72 00 01 00 00 02 73 |.r.....s| 2472 : 02 73 00 01 00 00 02 74 |.s.....t| 2480 : 02 74 00 01 00 00 02 75 |.t.....u| 2488 : 02 75 00 01 00 00 02 76 |.u.....v| 2496 : 02 76 00 01 00 00 02 77 |.v.....w| 2504 : 02 77 00 01 00 00 02 78 |.w.....x| 2512 : 02 78 00 01 00 00 02 7D |.x.....}| 2520 : 02 7D 00 01 00 00 02 7E |.}.....~| 2528 : 02 7E 00 01 00 00 02 7C |.~.....|| 2536 : 02 7C 00 01 00 00 02 7F |.|......| 2544 : 02 7F 00 01 00 00 02 80 |........| 2552 : 02 80 00 01 00 00 00 00 |........|

2023-04-27 09:44:41.382 [socket: 7] Receiving packet: 0000 : 00 00 0A 7D 06 00 00 00 |...}....| 0008 : 00 00 02 00 01 00 01 00 |........| 0016 : 01 00 00 00 02 00 02 00 |........| 0024 : 0A 00 00 00 08 00 08 00 |........| 0032 : 01 00 00 00 0C 00 0C 00 |........| 0040 : 0A 00 00 00 17 00 17 00 |........| 0048 : 01 00 00 00 18 00 18 00 |........| 0056 : 01 00 00 00 19 00 19 00 |........| 0064 : 01 00 00 00 1A 00 1A 00 |........| 0072 : 01 00 00 00 1B 00 1B 00 |........| 0080 : 01 00 00 00 1C 00 1C 00 |........| 0088 : 01 00 00 00 1D 00 1D 00 |........| 0096 : 01 00 00 00 1E 00 1E 00 |........| 0104 : 01 00 00 00 1F 00 1F 00 |........| 0112 : 01 00 00 00 20 00 20 00 |........| 0120 : 01 00 00 00 21 00 21 00 |....!.!.| 0128 : 01 00 00 00 0A 00 0A 00 |........| 0136 : 01 00 00 00 0B 00 0B 00 |........| 0144 : 01 00 00 00 28 00 28 00 |....(.(.| 0152 : 01 00 00 00 29 00 29 00 |....).).| 0160 : 01 00 00 00 75 00 75 00 |....u.u.| 0168 : 01 00 00 00 78 00 78 00 |....x.x.| 0176 : 01 00 00 01 22 01 22 00 |....".".| 0184 : 01 00 00 01 23 01 23 00 |....#.#.| 0192 : 01 00 00 01 24 01 24 00 |....$.$.| 0200 : 01 00 00 01 25 01 25 00 |....%.%.| 0208 : 01 00 00 01 26 01 26 00 |....&.&.| 0216 : 01 00 00 01 2A 01 2A 00 |......| 0224 : 01 00 00 01 2B 01 2B 00 |....+.+.| 0232 : 01 00 00 01 2C 01 2C 00 |....,.,.| 0240 : 01 00 00 01 2D 01 2D 00 |....-.-.| 0248 : 01 00 00 01 2E 01 2E 00 |........| 0256 : 01 00 00 01 2F 01 2F 00 |...././.| 0264 : 01 00 00 01 30 01 30 00 |....0.0.| 0272 : 01 00 00 01 31 01 31 00 |....1.1.| 0280 : 01 00 00 01 32 01 32 00 |....2.2.| 0288 : 01 00 00 01 33 01 33 00 |....3.3.| 0296 : 01 00 00 01 34 01 34 00 |....4.4.| 0304 : 01 00 00 01 35 01 35 00 |....5.5.| 0312 : 01 00 00 01 36 01 36 00 |....6.6.| 0320 : 01 00 00 01 37 01 37 00 |....7.7.| 0328 : 01 00 00 01 38 01 38 00 |....8.8.| 0336 : 01 00 00 01 39 01 39 00 |....9.9.| 0344 : 01 00 00 01 3B 01 3B 00 |....;.;.| 0352 : 01 00 00 01 3C 01 3C 00 |....<.<.| 0360 : 01 00 00 01 3D 01 3D 00 |....=.=.| 0368 : 01 00 00 01 3E 01 3E 00 |....>.>.| 0376 : 01 00 00 01 3F 01 3F 00 |....?.?.| 0384 : 01 00 00 01 40 01 40 00 @.@.| 0392 : 01 00 00 01 41 01 41 00 |....A.A.| 0400 : 01 00 00 01 42 01 42 00 |....B.B.| 0408 : 01 00 00 01 43 01 43 00 |....C.C.| 0416 : 01 00 00 01 47 01 47 00 |....G.G.| 0424 : 01 00 00 01 48 01 48 00 |....H.H.| 0432 : 01 00 00 01 49 01 49 00 |....I.I.| 0440 : 01 00 00 01 4B 01 4B 00 |....K.K.| 0448 : 01 00 00 01 4D 01 4D 00 |....M.M.| 0456 : 01 00 00 01 4E 01 4E 00 |....N.N.| 0464 : 01 00 00 01 4F 01 4F 00 |....O.O.| 0472 : 01 00 00 01 50 01 50 00 |....P.P.| 0480 : 01 00 00 01 51 01 51 00 |....Q.Q.| 0488 : 01 00 00 01 52 01 52 00 |....R.R.| 0496 : 01 00 00 01 53 01 53 00 |....S.S.| 0504 : 01 00 00 01 54 01 54 00 |....T.T.| 0512 : 01 00 00 01 55 01 55 00 |....U.U.| 0520 : 01 00 00 01 56 01 56 00 |....V.V.| 0528 : 01 00 00 01 57 01 57 00 |....W.W.| 0536 : 01 00 00 01 58 01 58 00 |....X.X.| 0544 : 01 00 00 01 59 01 59 00 |....Y.Y.| 0552 : 01 00 00 01 5A 01 5A 00 |....Z.Z.| 0560 : 01 00 00 01 5C 01 5C 00 |......| 0568 : 01 00 00 01 5D 01 5D 00 |....].].| 0576 : 01 00 00 01 62 01 62 00 |....b.b.| 0584 : 01 00 00 01 63 01 63 00 |....c.c.| 0592 : 01 00 00 01 67 01 67 00 |....g.g.| 0600 : 01 00 00 01 6B 01 6B 00 |....k.k.| 0608 : 01 00 00 01 7C 01 7C 00 |....|.|.| 0616 : 01 00 00 01 7D 01 7D 00 |....}.}.| 0624 : 01 00 00 01 7E 01 7E 00 |....~.~.| 0632 : 01 00 00 01 7F 01 7F 00 |........| 0640 : 01 00 00 01 80 01 80 00 |........| 0648 : 01 00 00 01 81 01 81 00 |........| 0656 : 01 00 00 01 82 01 82 00 |........| 0664 : 01 00 00 01 83 01 83 00 |........| 0672 : 01 00 00 01 84 01 84 00 |........| 0680 : 01 00 00 01 85 01 85 00 |........| 0688 : 01 00 00 01 86 01 86 00 |........| 0696 : 01 00 00 01 87 01 87 00 |........| 0704 : 01 00 00 01 89 01 89 00 |........| 0712 : 01 00 00 01 8A 01 8A 00 |........| 0720 : 01 00 00 01 8B 01 8B 00 |........| 0728 : 01 00 00 01 8C 01 8C 00 |........| 0736 : 01 00 00 01 8D 01 8D 00 |........| 0744 : 01 00 00 01 8E 01 8E 00 |........| 0752 : 01 00 00 01 8F 01 8F 00 |........| 0760 : 01 00 00 01 90 01 90 00 |........| 0768 : 01 00 00 01 91 01 91 00 |........| 0776 : 01 00 00 01 94 01 94 00 |........| 0784 : 01 00 00 01 95 01 95 00 |........| 0792 : 01 00 00 01 96 01 96 00 |........| 0800 : 01 00 00 01 97 01 97 00 |........| 0808 : 01 00 00 01 9D 01 9D 00 |........| 0816 : 01 00 00 01 9E 01 9E 00 |........| 0824 : 01 00 00 01 9F 01 9F 00 |........| 0832 : 01 00 00 01 A0 01 A0 00 |........| 0840 : 01 00 00 01 A1 01 A1 00 |........| 0848 : 01 00 00 01 A2 01 A2 00 |........| 0856 : 01 00 00 01 A3 01 A3 00 |........| 0864 : 01 00 00 01 A4 01 A4 00 |........| 0872 : 01 00 00 01 A5 01 A5 00 |........| 0880 : 01 00 00 01 A6 01 A6 00 |........| 0888 : 01 00 00 01 A7 01 A7 00 |........| 0896 : 01 00 00 01 A8 01 A8 00 |........| 0904 : 01 00 00 01 A9 01 A9 00 |........| 0912 : 01 00 00 01 AA 01 AA 00 |........| 0920 : 01 00 00 01 AB 01 AB 00 |........| 0928 : 01 00 00 01 AD 01 AD 00 |........| 0936 : 01 00 00 01 AE 01 AE 00 |........| 0944 : 01 00 00 01 AF 01 AF 00 |........| 0952 : 01 00 00 01 B0 01 B0 00 |........| 0960 : 01 00 00 01 B1 01 B1 00 |........| 0968 : 01 00 00 01 C1 01 C1 00 |........| 0976 : 01 00 00 01 C2 01 C2 00 |........| 0984 : 01 00 00 01 C6 01 C6 00 |........| 0992 : 01 00 00 01 C7 01 C7 00 |........| 1000 : 01 00 00 01 C8 01 C8 00 |........| 1008 : 01 00 00 01 C9 01 C9 00 |........| 1016 : 01 00 00 01 CA 01 CA 00 |........| 1024 : 01 00 00 01 CB 01 CB 00 |........| 1032 : 01 00 00 01 CC 01 CC 00 |........| 1040 : 01 00 00 01 CD 01 CD 00 |........| 1048 : 01 00 00 01 CE 01 CE 00 |........| 1056 : 01 00 00 01 CF 01 CF 00 |........| 1064 : 01 00 00 01 D2 01 D2 00 |........| 1072 : 01 00 00 01 D3 01 D3 00 |........| 1080 : 01 00 00 01 D4 01 D4 00 |........| 1088 : 01 00 00 01 D5 01 D5 00 |........| 1096 : 01 00 00 01 D6 01 D6 00 |........| 1104 : 01 00 00 01 D7 01 D7 00 |........| 1112 : 01 00 00 01 D8 01 D8 00 |........| 1120 : 01 00 00 01 D9 01 D9 00 |........| 1128 : 01 00 00 01 DA 01 DA 00 |........| 1136 : 01 00 00 01 DB 01 DB 00 |........| 1144 : 01 00 00 01 DC 01 DC 00 |........| 1152 : 01 00 00 01 DD 01 DD 00 |........| 1160 : 01 00 00 01 DE 01 DE 00 |........| 1168 : 01 00 00 01 DF 01 DF 00 |........| 1176 : 01 00 00 01 E0 01 E0 00 |........| 1184 : 01 00 00 01 E1 01 E1 00 |........| 1192 : 01 00 00 01 E2 01 E2 00 |........| 1200 : 01 00 00 01 E3 01 E3 00 |........| 1208 : 01 00 00 01 E4 01 E4 00 |........| 1216 : 01 00 00 01 E5 01 E5 00 |........| 1224 : 01 00 00 01 E6 01 E6 00 |........| 1232 : 01 00 00 01 EA 01 EA 00 |........| 1240 : 01 00 00 01 EB 01 EB 00 |........| 1248 : 01 00 00 01 EC 01 EC 00 |........| 1256 : 01 00 00 01 ED 01 ED 00 |........| 1264 : 01 00 00 01 EE 01 EE 00 |........| 1272 : 01 00 00 01 EF 01 EF 00 |........| 1280 : 01 00 00 01 F0 01 F0 00 |........| 1288 : 01 00 00 01 F2 01 F2 00 |........| 1296 : 01 00 00 01 F3 01 F3 00 |........| 1304 : 01 00 00 01 F4 01 F4 00 |........| 1312 : 01 00 00 01 F5 01 F5 00 |........| 1320 : 01 00 00 01 F6 01 F6 00 |........| 1328 : 01 00 00 01 FD 01 FD 00 |........| 1336 : 01 00 00 01 FE 01 FE 00 |........| 1344 : 01 00 00 02 01 02 01 00 |........| 1352 : 01 00 00 02 02 02 02 00 |........| 1360 : 01 00 00 02 04 02 04 00 |........| 1368 : 01 00 00 02 05 02 05 00 |........| 1376 : 01 00 00 02 06 02 06 00 |........| 1384 : 01 00 00 02 07 02 07 00 |........| 1392 : 01 00 00 02 08 02 08 00 |........| 1400 : 01 00 00 02 09 02 09 00 |........| 1408 : 01 00 00 02 0A 02 0A 00 |........| 1416 : 01 00 00 02 0B 02 0B 00 |........| 1424 : 01 00 00 02 0C 02 0C 00 |........| 1432 : 01 00 00 02 0D 02 0D 00 |........| 1440 : 01 00 00 02 0E 02 0E 00 |........| 1448 : 01 00 00 02 0F 02 0F 00 |........| 1456 : 01 00 00 02 10 02 10 00 |........| 1464 : 01 00 00 02 11 02 11 00 |........| 1472 : 01 00 00 02 12 02 12 00 |........| 1480 : 01 00 00 02 13 02 13 00 |........| 1488 : 01 00 00 02 14 02 14 00 |........| 1496 : 01 00 00 02 15 02 15 00 |........| 1504 : 01 00 00 02 16 02 16 00 |........| 1512 : 01 00 00 02 17 02 17 00 |........| 1520 : 01 00 00 02 18 02 18 00 |........| 1528 : 01 00 00 02 19 02 19 00 |........| 1536 : 01 00 00 02 1A 02 1A 00 |........| 1544 : 01 00 00 02 1B 02 1B 00 |........| 1552 : 01 00 00 02 1F 02 1F 00 |........| 1560 : 01 00 00 02 20 00 00 02 |........| 1568 : 21 00 00 02 22 00 00 02 |!..."...| 1576 : 23 00 00 02 24 00 00 02 |#...$...| 1584 : 25 00 00 02 26 00 00 02 |%...&...| 1592 : 27 00 00 02 28 00 00 02 |'...(...| 1600 : 29 00 00 02 2A 00 00 02 |)......| 1608 : 2B 00 00 02 2C 00 00 02 |+...,...| 1616 : 2D 00 00 02 2E 00 00 02 |-.......| 1624 : 2F 00 00 02 30 02 30 00 |/...0.0.| 1632 : 01 00 00 02 31 00 00 02 |....1...| 1640 : 32 00 00 02 33 02 33 00 |2...3.3.| 1648 : 01 00 00 02 34 02 34 00 |....4.4.| 1656 : 01 00 00 02 36 00 00 02 |....6...| 1664 : 37 00 00 02 38 00 00 02 |7...8...| 1672 : 39 00 00 02 3A 00 00 02 |9...:...| 1680 : 3B 00 00 02 3C 02 3C 00 |;...<.<.| 1688 : 01 00 00 02 3D 02 3D 00 |....=.=.| 1696 : 01 00 00 02 3E 02 3E 00 |....>.>.| 1704 : 01 00 00 02 3F 02 3F 00 |....?.?.| 1712 : 01 00 00 02 40 02 40 00 **@.***@.| 1720 : 01 00 00 02 41 00 00 02 |....A...| 1728 : 42 02 42 00 01 00 00 02 |B.B.....| 1736 : 43 02 43 00 01 00 00 02 |C.C.....| 1744 : 44 02 44 00 01 00 00 02 |D.D.....| 1752 : 45 02 45 00 01 00 00 02 |E.E.....| 1760 : 46 02 46 00 01 00 00 02 |F.F.....| 1768 : 47 02 47 00 01 00 00 02 |G.G.....| 1776 : 48 02 48 00 01 00 00 02 |H.H.....| 1784 : 49 02 49 00 01 00 00 02 |I.I.....| 1792 : 4A 00 00 02 4B 00 00 02 |J...K...| 1800 : 4C 00 00 02 4D 00 00 02 |L...M...| 1808 : 4E 02 4E 00 01 00 00 02 |N.N.....| 1816 : 4F 02 4F 00 01 00 00 02 |O.O.....| 1824 : 50 02 50 00 01 00 00 02 |P.P.....| 1832 : 51 02 51 00 01 00 00 02 |Q.Q.....| 1840 : 52 02 52 00 01 00 00 02 |R.R.....| 1848 : 53 02 53 00 01 00 00 02 |S.S.....| 1856 : 54 02 54 00 01 00 00 02 |T.T.....| 1864 : 55 02 55 00 01 00 00 02 |U.U.....| 1872 : 56 02 56 00 01 00 00 02 |V.V.....| 1880 : 57 02 57 00 01 00 00 02 |W.W.....| 1888 : 58 02 58 00 01 00 00 02 |X.X.....| 1896 : 59 02 59 00 01 00 00 02 |Y.Y.....| 1904 : 5A 02 5A 00 01 00 00 02 |Z.Z.....| 1912 : 5B 02 5B 00 01 00 00 02 |[.[.....| 1920 : 5C 02 5C 00 01 00 00 02 |......| 1928 : 5D 02 5D 00 01 00 00 02 |].].....| 1936 : 63 02 63 00 01 00 00 02 |c.c.....| 1944 : 64 02 64 00 01 00 00 02 |d.d.....| 1952 : 65 02 65 00 01 00 00 02 |e.e.....| 1960 : 66 02 66 00 01 00 00 02 |f.f.....| 1968 : 67 02 67 00 01 00 00 02 |g.g.....| 1976 : 68 02 68 00 01 00 00 02 |h.h.....| 1984 : 6E 02 6E 00 01 00 00 02 |n.n.....| 1992 : 6F 02 6F 00 01 00 00 02 |o.o.....| 2000 : 70 02 70 00 01 00 00 02 |p.p.....| 2008 : 71 02 71 00 01 00 00 02 |q.q.....| 2016 : 72 02 72 00 01 00 00 02 |r.r.....| 2024 : 73 02 73 00 01 00 00 02 |s.s.....| 2032 : 74 02 74 00 01 00 00 02 |t.t.....| 2040 : 75 02 75 00 01 00 00 02 |u.u.....| 2048 : 76 02 76 00 01 00 00 02 |v.v.....| 2056 : 77 02 77 00 01 00 00 02 |w.w.....| 2064 : 78 02 78 00 01 00 00 02 |x.x.....| 2072 : 79 00 00 02 7A 00 00 02 |y...z...| 2080 : 7B 00 00 02 7C 02 7C 00 |{...|.|.| 2088 : 01 00 00 02 7D 02 7D 00 |....}.}.| 2096 : 01 00 00 02 7E 02 7E 00 |....~.~.| 2104 : 01 00 00 02 7F 02 7F 00 |........| 2112 : 01 00 00 02 80 02 80 00 |........| 2120 : 01 00 00 02 81 00 00 02 |........| 2128 : 82 00 00 02 83 00 00 02 |........| 2136 : 84 00 00 02 85 00 00 00 |........| 2144 : 03 00 02 00 0A 00 00 00 |........| 2152 : 04 00 02 00 0A 00 00 00 |........| 2160 : 05 00 01 00 01 00 00 00 |........| 2168 : 06 00 02 00 0A 00 00 00 |........| 2176 : 07 00 02 00 0A 00 00 00 |........| 2184 : 09 00 01 00 01 00 00 00 |........| 2192 : 0D 00 00 00 0E 00 00 00 |........| 2200 : 0F 00 00 00 10 00 00 00 |........| 2208 : 11 00 00 00 12 00 00 00 |........| 2216 : 13 00 00 00 14 00 00 00 |........| 2224 : 15 00 00 00 16 00 00 00 |........| 2232 : 27 00 78 00 01 00 00 00 |'.x.....| 2240 : 3A 00 00 00 44 00 02 00 |:...D...| 2248 : 0A 00 00 00 45 00 00 00 |....E...| 2256 : 46 00 00 00 4A 00 00 00 |F...J...| 2264 : 4C 00 00 00 5B 00 02 00 |L...[...| 2272 : 0A 00 00 00 5E 00 01 00 |....^...| 2280 : 01 00 00 00 5F 00 17 00 |...._...| 2288 : 01 00 00 00 60 00 60 00 |......| 2296 : 01 00 00 00 61 00 60 00 |....a.`.| 2304 : 01 00 00 00 64 00 64 00 |....d.d.| 2312 : 01 00 00 00 65 00 65 00 |....e.e.| 2320 : 01 00 00 00 66 00 66 00 |....f.f.| 2328 : 01 00 00 00 68 00 00 00 |....h...| 2336 : 69 00 00 00 6A 00 6A 00 |i...j.j.| 2344 : 01 00 00 00 6C 00 6D 00 |....l.m.| 2352 : 01 00 00 00 6D 00 6D 00 |....m.m.| 2360 : 01 00 00 00 6E 00 6F 00 |....n.o.| 2368 : 01 00 00 00 6F 00 6F 00 |....o.o.| 2376 : 01 00 00 00 70 00 70 00 |....p.p.| 2384 : 01 00 00 00 71 00 71 00 |....q.q.| 2392 : 01 00 00 00 72 00 72 00 |....r.r.| 2400 : 01 00 00 00 73 00 73 00 |....s.s.| 2408 : 01 00 00 00 74 00 66 00 |....t.f.| 2416 : 01 00 00 00 76 00 00 00 |....v...| 2424 : 79 00 00 00 7A 00 00 00 |y...z...| 2432 : 7B 00 00 00 88 00 00 00 |{.......| 2440 : 92 00 92 00 01 00 00 00 |........| 2448 : 93 00 00 00 98 00 02 00 |........| 2456 : 0A 00 00 00 99 00 02 00 |........| 2464 : 0A 00 00 00 9A 00 02 00 |........| 2472 : 0A 00 00 00 9B 00 01 00 |........| 2480 : 01 00 00 00 9C 00 0C 00 |........| 2488 : 0A 00 00 00 AC 00 02 00 |........| 2496 : 0A 00 00 00 B2 00 B2 00 |........| 2504 : 01 00 00 00 B3 00 B3 00 |........| 2512 : 01 00 00 00 B4 00 B4 00 |........| 2520 : 01 00 00 00 B5 00 B5 00 |........| 2528 : 01 00 00 00 B6 00 B6 00 |........| 2536 : 01 00 00 00 B7 00 B7 00 |........| 2544 : 01 00 00 00 B8 00 0C 00 |........| 2552 : 0A 00 00 00 B9 00 00 00 |........| 2560 : BA 00 00 00 BB 00 00 00 |........| 2568 : BC 00 00 00 BD 00 00 00 |........| 2576 : BE 00 00 00 BF 00 00 00 |........| 2584 : C0 00 00 00 C3 00 70 00 |......p.| 2592 : 01 00 00 00 C4 00 71 00 |......q.| 2600 : 01 00 00 00 C5 00 72 00 |......r.| 2608 : 01 00 00 00 D0 00 D0 00 |........| 2616 : 01 00 00 00 D1 00 00 00 |........| 2624 : E7 00 E7 00 01 00 00 00 |........| 2632 : E8 00 E7 00 01 00 00 00 |........| 2640 : E9 00 E9 00 01 00 00 00 |........| 2648 : F1 00 6D 00 01 00 00 00 |..m.....| 2656 : F5 00 00 00 F6 00 00 00 |........| 2664 : FA 00 00 00 FB 00 00 00 |........| 2672 : FC 00 FC 00 01 00 00 02 |........| 2680 : 03 00 00 00 00 |..... |

2023-04-27 09:44:41.386 [socket: 7] Sending packet: 0000 : 00 00 00 E0 06 00 00 00 |........| 0008 : 00 00 03 76 01 01 01 0D |...v....| 0016 : 01 01 01 01 05 01 01 0D |........| 0024 : 50 48 4F 54 4F 4E 5F 4D | | 0032 : 44 4D 5F 52 4F 01 0D 0D | ...| 0040 : 41 55 54 48 5F 54 45 52 |AUTHTER| 0048 : 4D 49 4E 41 4C 01 07 07 |MINAL...| 0056 : 75 6E 6B 6E 6F 77 6E 00 |unknown.| 0064 : 01 0F 0F 41 55 54 48 5F |...AUTH| 0072 : 50 52 4F 47 52 41 4D 5F |PROGRAM_| 0080 : 4E 4D 01 3E 3E 2F 4C 69 |NM.>>/Li| 0088 : 62 72 61 72 79 2F 46 72 |brary/Fr| 0096 : 61 6D 65 77 6F 72 6B 73 |ameworks| 0104 : 2F 50 79 74 68 6F 6E 2E |/Python.| 0112 : 66 72 61 6D 65 77 6F 72 |framewor| 0120 : 6B 2F 56 65 72 73 69 6F |k/Versio| 0128 : 6E 73 2F 33 2E 31 31 2F |ns/3.11/| 0136 : 62 69 6E 2F 70 79 74 68 |bin/pyth| 0144 : 6F 6E 33 00 01 0C 0C 41 |on3....A| 0152 : 55 54 48 5F 4D 41 43 48 |UTH_MACH| 0160 : 49 4E 45 01 0C 0C 50 55 |INE... | 0168 : 2D 4D 42 50 2D 4B 53 48 | | 0176 : 41 33 00 01 08 08 41 55 |A3....AU| 0184 : 54 48 5F 50 49 44 01 05 |TH_PID..| 0192 : 05 32 33 32 38 32 00 01 |.23282..| 0200 : 08 08 41 55 54 48 5F 53 |..AUTH_S| 0208 : 49 44 01 0A 0A 6B 61 72 |ID... | 0216 : 74 69 6B 73 68 61 68 00 | .|

2023-04-27 09:44:41.648 [socket: 7] Receiving packet: 0000 : 00 00 01 FA 06 00 00 00 |........| 0008 : 00 00 08 01 06 01 0C 0C |........| 0016 : 41 55 54 48 5F 53 45 53 |AUTHSES| 0024 : 53 4B 45 59 01 40 40 36 |SKEY.@@6| 0032 : 30 43 33 42 33 34 34 32 |0C3B3442| 0040 : 38 31 35 36 46 43 31 42 |8156FC1B| 0048 : 45 46 46 31 34 36 42 38 |EFF146B8| 0056 : 30 35 44 42 41 39 33 37 |05DBA937| 0064 : 42 30 36 38 33 31 38 39 |B0683189| 0072 : 41 39 32 42 39 43 33 39 |A92B9C39| 0080 : 43 45 36 44 38 37 46 39 |CE6D87F9| 0088 : 38 42 35 37 38 31 33 00 |8B57813.| 0096 : 01 0D 0D 41 55 54 48 5F |...AUTH| 0104 : 56 46 52 5F 44 41 54 41 |VFR_DATA| 0112 : 01 14 14 37 38 32 39 34 |...78294| 0120 : 36 42 32 43 37 45 35 46 |6B2C7E5F| 0128 : 38 33 43 39 43 42 38 02 |83C9CB8.| 0136 : 1B 25 01 14 14 41 55 54 |.%...AUT| 0144 : 48 5F 50 42 4B 44 46 32 |H_PBKDF2| 0152 : 5F 43 53 4B 5F 53 41 4C |_CSK_SAL| 0160 : 54 01 20 20 31 42 31 34 |T...1B14| 0168 : 46 46 45 33 45 31 38 32 |FFE3E182| 0176 : 38 30 41 46 37 36 33 37 |80AF7637| 0184 : 45 42 32 45 41 46 37 33 |EB2EAF73| 0192 : 43 33 35 38 00 01 16 16 |C358....| 0200 : 41 55 54 48 5F 50 42 4B |AUTH_PBK| 0208 : 44 46 32 5F 56 47 45 4E |DF2_VGEN| 0216 : 5F 43 4F 55 4E 54 01 04 |_COUNT..| 0224 : 04 34 30 39 36 00 01 16 |.4096...| 0232 : 16 41 55 54 48 5F 50 42 |.AUTH_PB| 0240 : 4B 44 46 32 5F 53 44 45 |KDF2_SDE| 0248 : 52 5F 43 4F 55 4E 54 01 |R_COUNT.| 0256 : 01 01 33 00 01 1A 1A 41 |..3....A| 0264 : 55 54 48 5F 47 4C 4F 42 |UTH_GLOB| 0272 : 41 4C 4C 59 5F 55 4E 49 |ALLY_UNI| 0280 : 51 55 45 5F 44 42 49 44 |QUE_DBID| 0288 : 00 01 20 20 46 30 31 35 |....F015| 0296 : 34 32 39 37 36 36 32 33 |42976623| 0304 : 38 30 43 34 36 41 37 38 |80C46A78| 0312 : 46 39 37 33 46 45 35 39 |F973FE59| 0320 : 38 34 35 33 00 17 08 01 |8453....| 0328 : 01 15 00 00 01 01 88 88 |........| 0336 : 01 00 02 00 02 00 00 00 |........| 0344 : 4D 2A 8D 7B CF 54 F1 C5 |M*.{.T..| 0352 : DE 1A CB 10 26 00 00 00 |....&...| 0360 : 6E 42 13 3A 00 00 00 00 |nB.:....| 0368 : 00 00 00 00 88 00 00 00 |........| 0376 : 0A 00 0A 00 00 00 00 00 |........| 0384 : 00 00 00 00 00 00 00 00 |........| 0392 : 00 00 00 00 00 00 00 00 |........| 0400 : 00 01 00 00 02 00 00 00 |........| 0408 : 7F 00 00 00 00 00 00 00 |........| 0416 : 00 00 00 00 00 00 00 00 |........| 0424 : 00 00 00 00 00 00 00 00 |........| 0432 : 47 6A 32 9A 00 80 40 00 @.***| 0440 : 00 00 00 00 00 00 00 00 |........| 0448 : 00 00 00 00 00 00 00 00 |........| 0456 : 00 00 00 00 00 00 00 00 |........| 0464 : 00 00 00 00 00 00 00 00 |........| 0472 : 04 01 01 02 49 E7 00 00 |....I...| 0480 : 00 00 00 00 00 00 00 00 |........| 0488 : 00 00 00 00 00 00 00 00 |........| 0496 : 00 01 00 00 00 00 00 00 |........| 0504 : 00 00 |.. |

cjbj commented 1 year ago

Got it. Thanks. We'll take a look.

(PS. using https://gist.github.com/ is handy for sharing code or long traces)

anthony-tuininga commented 1 year ago

@kartik1581, I took a look at the packet output and analyzed it. In the final packet that is reported I see the return parameters (0x08, starting at position 10), server side piggyback for AC replay (0x17 at position 325) and error information (0x04 at position 472). All of these look correct -- but the presence of the server side piggyback for AC replay is unexpected. Can you provide more detail of the database to which you are connecting? Is it on the cloud? On premises? What type of service are you connecting to and what service parameters have you set?

I have pushed some code to improve the diagnosibility of the invalid message type error. Are you able to build from source and try it again?

I also noted this string in the packet output: ***@***.***| which isn't correct. Is that from your attempt to obfuscate some of the details in the packet output or are you actually seeing that yourself?

anthony-tuininga commented 1 year ago

Thanks to @sudarshan12s and an equivalent issue found in the node-oracledb driver, I have pushed code that should address this issue. If you are able to build from source you can verify that it corrects your issue as well.

anthony-tuininga commented 1 year ago

This has been included in python-oracledb 1.4.0 which was just released.