MySQL Forums
Forum List  »  Security

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
4650
February 06, 2014 12:44PM
2135
February 07, 2014 08:23AM
2119
February 07, 2014 09:43AM
2012
February 07, 2014 10:07AM
2661
February 13, 2014 07:13AM
2061
February 13, 2014 07:47AM
2131
February 13, 2014 08:10AM
2102
February 13, 2014 08:33AM
Re: SSL don't work
2254
February 13, 2014 08:49AM
1977
February 13, 2014 09:08AM
2052
February 13, 2014 09:24AM
2011
February 14, 2014 02:16AM
2082
February 19, 2014 07:28AM
1792
February 19, 2014 08:15AM
2534
February 19, 2014 09:17AM
1820
February 19, 2014 09:32AM
3453
February 19, 2014 09:57AM
2064
February 19, 2014 10:00AM
2362
February 20, 2014 02:40AM
2026
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.