MySQL Forums
Forum List  »  Security

Re: Unable to SSL i
Posted by: Var able
Date: September 11, 2021 07:24PM

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


Options: ReplyQuote

Written By
September 10, 2021 10:54PM
September 11, 2021 04:27AM
Re: Unable to SSL i
September 11, 2021 07:24PM
September 13, 2021 01:50AM
September 14, 2021 10:30PM
September 15, 2021 01:23AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.