Re: Unable to SSL i

[Var able]

Hi Georgi Kodinov,
Thanks for the response.. I have enabled log_error_verbosity = 3 and restarted mysql. Please find the error.log below.

2021-09-12T01:20:45.800511Z 0 [Note] [MY-010949] [Server] Basedir set to /usr/.
2021-09-12T01:20:45.800523Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25) starting as process 4272
2021-09-12T01:20:45.807125Z 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2021-09-12T01:20:45.807397Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2021-09-12T01:20:45.809497Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-09-12T01:20:45.809585Z 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
2021-09-12T01:20:45.809735Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2021-09-12T01:20:45.809813Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2021-09-12T01:20:45.809868Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2021-09-12T01:20:45.809931Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.11
2021-09-12T01:20:45.814678Z 1 [Note] [MY-013251] [InnoDB] Number of pools: 1
2021-09-12T01:20:45.814864Z 1 [Note] [MY-012951] [InnoDB] Using CPU crc32 instructions
2021-09-12T01:20:45.815419Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
2021-09-12T01:20:45.815509Z 1 [Note] [MY-012204] [InnoDB] Scanning './'
2021-09-12T01:20:45.855270Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 96 files.
2021-09-12T01:20:45.856300Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M
2021-09-12T01:20:45.865158Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2021-09-12T01:20:45.909777Z 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-09-12T01:20:45.910710Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2021-09-12T01:20:45.911311Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2021-09-12T01:20:45.962711Z 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2
2021-09-12T01:20:45.962826Z 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4
2021-09-12T01:20:45.962914Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2021-09-12T01:20:45.963003Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2021-09-12T01:20:45.963396Z 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 54755853, whereas checkpoint_lsn = 54755987 and start_lsn = 54755840
2021-09-12T01:20:45.965382Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2021-09-12T01:20:46.003745Z 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
2021-09-12T01:20:46.003941Z 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
2021-09-12T01:20:46.004366Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2021-09-12T01:20:46.005458Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2021-09-12T01:20:46.006550Z 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2021-09-12T01:20:46.006688Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 40713
2021-09-12T01:20:46.019046Z 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2021-09-12T01:20:46.019286Z 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-09-12T01:20:46.047224Z 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2021-09-12T01:20:46.047537Z 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
2021-09-12T01:20:46.059492Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2021-09-12T01:20:46.072971Z 1 [Note] [MY-012976] [InnoDB] 8.0.25 started; log sequence number 54755987
2021-09-12T01:20:46.073949Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-09-12T01:20:46.080939Z 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80023'.
2021-09-12T01:20:46.167127Z 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files
2021-09-12T01:20:46.172782Z 1 [Note] [MY-012356] [InnoDB] Scanned 98 tablespaces. Validated 98.
2021-09-12T01:20:46.198859Z 1 [Note] [MY-010006] [Server] Using data dictionary with version '80023'.
2021-09-12T01:20:46.204233Z 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available'
2021-09-12T01:20:46.204579Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '::' port: 33060'
2021-09-12T01:20:46.204729Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/var/run/mysqld/mysqlx.sock''
2021-09-12T01:20:46.204896Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2021-09-12T01:20:46.218999Z 0 [Note] [MY-010902] [Server] Thread priority attribute setting in Resource Group SQL shall be ignored due to unsupported platform or insufficient privilege.
2021-09-12T01:20:46.237548Z 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin
2021-09-12T01:20:46.237843Z 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end
2021-09-12T01:20:46.241237Z 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /data/mysql/ib_buffer_pool
2021-09-12T01:20:46.241811Z 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 210912 1:20:46
2021-09-12T01:20:46.279482Z 0 [Note] [MY-010913] [Server] You have not provided a mandatory server-id. Servers in a replication topology must have unique server-ids. Please refer to the proper server start-up parameters documentation.
2021-09-12T01:20:46.280945Z 0 [Note] [MY-010303] [Server] Skipping generation of SSL certificates as options related to SSL are specified.
2021-09-12T01:20:46.281999Z 0 [Warning] [MY-013595] [Server] Failed to initialize TLS for channel: mysql_main. See below for the description of exact issue.
2021-09-12T01:20:46.282220Z 0 [Warning] [MY-010069] [Server] Failed to set up SSL because of the following SSL library error: SSL_CTX_set_default_verify_paths failed
2021-09-12T01:20:46.282412Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are present in data directory.
2021-09-12T01:20:46.282606Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory.
2021-09-12T01:20:46.282948Z 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '*'; port: 3506
2021-09-12T01:20:46.283155Z 0 [Note] [MY-010253] [Server] IPv6 is available.
2021-09-12T01:20:46.283347Z 0 [Note] [MY-010264] [Server] - '::' resolves to '::';
2021-09-12T01:20:46.283542Z 0 [Note] [MY-010251] [Server] Server socket created on IP: '::'.
2021-09-12T01:20:46.299350Z 0 [Note] [MY-011025] [Repl] Failed to start slave threads for channel ''.
2021-09-12T01:20:46.301500Z 0 [Note] [MY-011242] [Server] Plugin mysqlx reported: 'Neither MySQL Server nor Mysqlx Plugin has valid SSL configuration'
2021-09-12T01:20:46.301843Z 0 [Warning] [MY-011302] [Server] Plugin mysqlx reported: 'Failed at SSL configuration: "SSL context is not usable without certificate and private key"'
2021-09-12T01:20:46.301867Z 0 [Note] [MY-011244] [Server] Plugin mysqlx reported: 'For more information, please see the Using Secure Connections with X Plugin section in the MySQL documentation'
2021-09-12T01:20:46.302077Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.25' socket: '/var/run/mysqld/mysqld.sock' port: 3506 MySQL Community Server - GPL.
2021-09-12T01:20:46.306612Z 5 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 5


Regards,
Var