Re: SSL don't work
Posted by:
Blue Phaz
Date: February 13, 2014 08:49AM
> Start the server in a command prompt console (check the --console option to mysqld.exe) and see if the error is gone. If this works this means that whatever user is running the mysqld service can't open the keys.
foo.bat:
"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" --console
console output:
C:\Users\Administrator\Desktop>"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld"
--defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" --console
2014-02-13 16:10:10 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca
ted. Please use --explicit_defaults_for_timestamp server option (see documentati
on for more details).
error log:
2014-02-13 16:10:10 180640 [Note] Plugin 'FEDERATED' is disabled.
2014-02-13 16:10:10 180640 [Warning] option 'innodb-autoextend-increment': unsigned value 67108864 adjusted to 1000
2014-02-13 16:10:10 258d0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-02-13 16:10:10 180640 [Note] InnoDB: The InnoDB memory heap is disabled
2014-02-13 16:10:10 180640 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-02-13 16:10:10 180640 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-02-13 16:10:10 180640 [Note] InnoDB: Not using CPU crc32 instructions
2014-02-13 16:10:10 180640 [Note] InnoDB: Initializing buffer pool, size = 57.0M
2014-02-13 16:10:10 180640 [Note] InnoDB: Completed initialization of buffer pool
2014-02-13 16:10:10 180640 [Note] InnoDB: Highest supported file format is Barracuda.
2014-02-13 16:10:10 180640 [Note] InnoDB: The log sequence numbers 8526943 and 8526943 in ibdata files do not match the log sequence number 8527003 in the ib_logfiles!
2014-02-13 16:10:10 180640 [Note] InnoDB: Database was not shutdown normally!
2014-02-13 16:10:10 180640 [Note] InnoDB: Starting crash recovery.
2014-02-13 16:10:10 180640 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-02-13 16:10:10 180640 [Note] InnoDB: Restoring possible half-written data pages
2014-02-13 16:10:10 180640 [Note] InnoDB: from the doublewrite buffer...
2014-02-13 16:10:11 180640 [Note] InnoDB: 128 rollback segment(s) are active.
2014-02-13 16:10:11 180640 [Note] InnoDB: Waiting for purge to start
2014-02-13 16:10:11 180640 [Note] InnoDB: 5.6.14 started; log sequence number 8527003
SSL error: Unable to get private key from 'C:/server-key.pem'
2014-02-13 16:10:11 180640 [Warning] Failed to setup SSL
2014-02-13 16:10:11 180640 [Warning] SSL error: Unable to get private key
2014-02-13 16:10:11 180640 [Note] Server hostname (bind-address): '*'; port: 2013
2014-02-13 16:10:11 180640 [Note] IPv6 is available.
2014-02-13 16:10:11 180640 [Note] - '::' resolves to '::';
2014-02-13 16:10:11 180640 [Note] Server socket created on IP: '::'.
2014-02-13 16:10:11 180640 [Note] Event Scheduler: Loaded 0 events
2014-02-13 16:10:11 180640 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld: ready for connections.
Version: '5.6.14-log' socket: '' port: 2013 MySQL Community Server (GPL)
Edited 4 time(s). Last edit at 02/13/2014 09:11AM by Blue Phaz.
Subject
Views
Written By
Posted
5025
February 06, 2014 12:44PM
2241
February 07, 2014 08:23AM
2262
February 07, 2014 09:43AM
2133
February 07, 2014 10:07AM
2790
February 13, 2014 07:13AM
2237
February 13, 2014 07:47AM
2279
February 13, 2014 08:10AM
2227
February 13, 2014 08:33AM
Re: SSL don't work
2427
February 13, 2014 08:49AM
2118
February 13, 2014 09:08AM
2182
February 13, 2014 09:24AM
2144
February 14, 2014 02:16AM
2205
February 19, 2014 07:28AM
1944
February 19, 2014 08:15AM
2682
February 19, 2014 09:17AM
1947
February 19, 2014 09:32AM
3624
February 19, 2014 09:57AM
2206
February 19, 2014 10:00AM
2632
February 20, 2014 02:40AM
2181
February 20, 2014 02:57AM
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.