Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
11.4.3
-
None
Description
Given:
Windows 10 withot internet connection, becouse closed in externel firewall (only lan connection possible).
MariaDB version 11.4.3.
Error:
In terminal executed command "mysql -u root -p" throws one error (screenshot.jpg).
MariaDB 10.11.6 did not have this problem. Was used on same pc before using MariaDB 11.4.3. No preinstalled MariaDB, system was reseted before every installation from a backuped image.
Logsection (from file testpcname.err):
2024-11-11 10:42:10 0 [Note] Starting MariaDB 11.4.3-MariaDB source revision 5ab81ffe0097a22a774957df28c5223cf0201de3 server_uid c/P00bHqcfSzxHFB5BpVOCWWLNI= as process 4112
|
2024-11-11 10:42:10 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
|
2024-11-11 10:42:10 0 [Note] InnoDB: Number of transaction pools: 1
|
2024-11-11 10:42:10 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
|
2024-11-11 10:42:10 0 [Note] InnoDB: Initializing buffer pool, total size = 3.999GiB, chunk size = 63.984MiB
|
2024-11-11 10:42:10 0 [Note] InnoDB: Completed initialization of buffer pool
|
2024-11-11 10:42:10 0 [Note] InnoDB: File system buffers for log disabled (block size=4096 bytes)
|
2024-11-11 10:42:10 0 [Note] InnoDB: End of log at LSN=47629
|
2024-11-11 10:42:10 0 [Note] InnoDB: Opened 3 undo tablespaces
|
2024-11-11 10:42:10 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
|
2024-11-11 10:42:10 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
|
2024-11-11 10:42:10 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
|
2024-11-11 10:42:10 0 [Note] InnoDB: log sequence number 47629; transaction id 14
|
2024-11-11 10:42:10 0 [Note] InnoDB: Loading buffer pool(s) from C:\Program Files\MariaDB 11.4\data\ib_buffer_pool
|
2024-11-11 10:42:10 0 [Note] Plugin 'FEEDBACK' is disabled.
|
2024-11-11 10:42:10 0 [Note] mysqld.exe: SSPI: using principal name 'localhost', mech 'Negotiate'
|
2024-11-11 10:42:10 0 [Note] InnoDB: Buffer pool(s) load completed at 241111 10:42:10
|
2024-11-11 10:42:11 0 [Note] Server socket created on IP: '::'.
|
2024-11-11 10:42:11 0 [Note] Server socket created on IP: '0.0.0.0'.
|
2024-11-11 10:42:11 0 [Note] mysqld.exe: Event Scheduler: Loaded 0 events
|
2024-11-11 10:42:11 0 [Note] C:\Program Files\MariaDB 11.4\bin\mysqld.exe: ready for connections.
|
Version: '11.4.3-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
|
2024-11-11 10:50:26 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (Got an error reading communication packets)
|
2024-11-11 10:50:26 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
|
Workarounds:
- If this command was once executed when the pc had a internet connection, then the command works also when the internet connection is closed in a external firewall (only lan connection possible).
- Remove DNS entrie in the ethernet setings (there was no entries in hosts file).
